The Grammar of the Archaeological Record
2. The Manual

5. Secondary Input: Files Generated by Programs

Giorgio Buccellati – June 2010

Back to top: 5. Secondary Input: Files Generated by Programs

5.1: Introduction

Secondary input refers to input that has to be processed by an intermediate program that will produce a .J file to be then used by the JD suite.

In some cases, the initial input on which these programs operate is originally entered in an Excel type format (e.g., with Typology of Pottery).

In other cases, the initial input is a formatted directory, as with the V and W directories.

two spaces not allowed in VW, G\P and G\T filenames; if blank field is to be used, use dash.

Back to top: 5. Secondary Input: Files Generated by Programs

5.2: D folders within V/W folders

These files are generated by the JD5-B program.

Back to top: 5. Secondary Input: Files Generated by Programs

5.3: FILELIST folder within W or W\LoRes folders

These files are generated by the VWX program.

The following file is generated within the G\SCR folder by the G program, starting f.

Back to top: 5. Secondary Input: Files Generated by Programs

5.4: 2JPG

.G to .SCR rom a .G file within the I\G folder. The .SCR file is used to generate an AutoCAD plot (.DWG file).

undo mark
undo control none
layer new L704LRA6-g new L704LRA6-e new L704LRA6-r

layer set L704LRA6-g

layer color red L704LRA6-r

layer color blue L704LRA6-e

3dpoly 38034,41556,9135 38059,41159,8342

point 38000,41450,9014
point 38079,41231,8472
3dpoly 37973,41384,8395 38135,41388,8385

3dpoly 37941,41309,8250 37983,41297,8315 37984,41255,8956 38104,41264,8332

3dpoly 37944,41600,8917 37816,41608,8899 37816,41608,8899

layer set L704LRA6-r

text      38034,41556,9135      10      0      r65
text      38059,41159,8342      10      0      r66
text      38000,41450,9014      10      0      r64
text      38079,41231,8472      10      0      r67
text      37973,41384,8395      10      0      r68
text      38135,41388,8385      10      0      r69
text      37941,41309,8250      10      0      r73
text      37983,41297,8315      10      0      r72
text      37984,41255,8956      10      0      r71
text      38104,41264,8332      10      0      r70
text      37944,41600,8917      10      0      r95
text      37816,41608,8899      10      0      r96
text      37816,41608,8899      10      0      r97

layer set L704LRA6-e

text      38034,41556,9135      10      270      L628      lr      a6
text      38059,41159,8342      10      270      L628      lr      a6
text      38000,41450,9014      10      270      L628      lr      a6
text      38079,41231,8472      10      270      L628      lr      a6
text      37973,41384,8395      10      270      L628      lr      a6
text      38135,41388,8385      10      270      L628      lr      a6
text      37941,41309,8250      10      270      L628      lr      a6
text      37983,41297,8315      10      270      L628      lr      a6
text      37984,41255,8956      10      270      L628      lr      a6
text      38104,41264,8332      10      270      L628      lr      a6
text      37944,41600,8917      10      270      L704      lr      f47
text      37816,41608,8899      10      270      L704      lr      f47
zoom extents
zoom .9x
undo all

Back to top: 5. Secondary Input: Files Generated by Programs

5.5:Processing directories

[TEXT TO BE WRITTEN; ZGz05 mDP]

Back to top: 5. Secondary Input: Files Generated by Programs

5.5.1: Multiple input within I\J folder

The file I\J\FILELIST.TXT (produced by the FILELIST-J.BAT batch file within the I\J folder) is required in order to process multiple input files in a single pass. The file is deleted after running the JD program.

The batch file RENAME –J.BAT is a temporary utility that allows a global change of files with extension .-J to extension .J (for repeated processing of input files).

Back to top: 5. Secondary Input: Files Generated by Programs

5.5.2: Plots

[TEXT TO BE WRITTEN; ZGz05 mDP]

Back to top: 5. Secondary Input: Files Generated by Programs

5.5.3: Templates

The file G\T\LoRes\FILELIST.TXT (produced by the FILELIST-JPG.BAT batch file within the G\T\LoRes folder) has the following format:

L_A16t0001 V14d4001 M726 lr.jpg
L_A16t0001a V14d4002 M726 lr.jpg
L_A16t0001b V14d4003 M726 lr.jpg
L_A16t0002 V14d4004 L711 sv.jpg
L_A16t0002a V14d4004 L711 sv.jpg
L_A16t0003 V14d4008 L715 sv.jpg
L_A16t0003c V14d4010 L715 sv.jpg
L_A16t0003d V14d4011 L715 sv.jpg
L_A16t0004 V14d4012 L914 lr.jpg
L_A16t0004a V14d4013 L914 lr.jpg
L_A16t0004b V14d4014 L914 lr.jpg



This file serves as the input for the PTD program, and must be produced before running the program.

Back to top: 5. Secondary Input: Files Generated by Programs

5.6: Strata assignment to elements other than features

The program S (see below, 22.7) operates automatically on the basis of the S batch file (see below, 21.4.4). It uses as input all the pertinent files found in the O folder.

It presupposes that a strata assignment J file be first processed by the JD suite. This file must contain a log in the format described above under 4.6.6.

Back to top: 5. Secondary Input: Files Generated by Programs

5.7: Strata assignment to aggregates and element assignment to aggregates (and viceversa)

The program A (see below, 22.8) operates automatically on the basis of the A batch file (see below, 21.4.5). It uses as input all the pertinent files found in the O folder.

It presupposes that an aggregate assignment J file be first processed by the JD suite. This file must contain a log in the format described above under 4.6.6.

It also presupposes that the S program be first run, since the S program assigns strata to items and other elements that may define the aggregate, and are therefore used by the A program.

Back to top: 5. Secondary Input: Files Generated by Programs

5.8: Directories of photographs and drawings


\MZ\A\V14\G\HiRes\V14d10 \V14d1001 A10v147 L613 okk.tif
\MZ\A\V14\G\HiRes\V14d10 A10_views [dummy folder,]
\MZ\A\V14\G\LoRes\V14d10 \L_V14d1001 A10v147 L613 okk.jpg
\MZ\A\V14\G\LoRes\UNITBKS \A01O7Z7V.J
\MZ\A\V14\G\TN\V14d10 \T_V14d1001 A10v147 L613 okk.jpg



W t files

  • Only two fields are allowed, and they are the same as the first two fields in other W files.
  • The first field gives the drawing label. All labels with final 0 (W17t1600, W17t1610, W17t1620, etc.) always refer to files that contain the full drawing, while the others contain the detail.
  • When there are more than nine details, the same full drawing is repeated in the pertinent (final zero) position. Thus, in the example below, for W17t1700 and W17t1710.
  • The second field gives the element name. It must be of the type A16i0108 (with i, not a period) and leading zero(es).
  • The detail is introduced by a tilde and identified by the appropriate number as per the pertinent special roster (thus, in the examples below, the numbers 4, 5, 611, etc.)

W17t16
W17t1600      A16i0108.jpg
W17t1601      A16i0108~4.jpg
W17t1602      A16i0108~5.jpg
W17t1603      A16i0108~611.jpg
W17t1604      A16i0108~612.jpg
W17t1605      A16i0108~613.jpg
W17t1606      A16i0108~713.jpg

W17t17
W17t1700      A16i0117.jpg
W17t1701      A16i0117~4.p.jpg
W17t1702      A16i0117~5.p.jpg
W17t1703      A16i0117~611.jpg
W17t1704      A16i0117~612.jpg
W17t1705      A16i0117~613.jpg
W17t1706      A16i0117~621.jpg
W17t1707      A16i0117~622.jpg
W17t1708      A16i0117~623.jpg
W17t1709      A16i0117~6A1.jpg
W17t1710      A16i0117.jpg
W17t1711      A16i0117~6A2.jpg
W17t1712      A16i0117~711.jpg
W17t1713      A16i01


Back to top: 5. Secondary Input: Files Generated by Programs

5.9: Directories of plots and templates

[TEXT TO BE WRITTEN; ZGz05 mDP]

Back to top: 5. Secondary Input: Files Generated by Programs

5.9.1: Plots

J03p001    Q505    jW.wmf
J03p002    Q505    jW.wmf
J03p003    Q505    jW.wmf

Back to top: 5. Secondary Input: Files Generated by Programs

5.9.2: Templates

J03t001    V18d3043    P905    gM.jpg
J03t002    V18d3005    P813    gM.jpg
J03t003    V18d3008    P813    gM.jpg

Back to top: 5. Secondary Input: Files Generated by Programs

5.10: Typology of Pottery (Body and Shape Sherds)

An original Excel input is supposed. It follows the exact format of the form for either body or shape sherds (see figure below, which gives only the left hand side of the form).

Note that all extraneous lines (here, lines 1-4 and lines 7-8) must have a semi-colon (;) as the first character. They will then be disregarded by the TP program.

The Excel file name has no fixed format. It will include the initials of the people who entered the date and then proofread them. It is recommended that the filename be entered in the line immediately before the data, with a semi-colon initial. For changes in the filename when it is processed, see below, 18.2 [mistaken reference; ZGz10 mDP].

All lines that are not related to the data entry must begin with a semi-colon

The critical line in the form is line 5. It gives the codes that are used to define the fields in the J file. The full list is given below:

.rd .ri .bk q# cp F2 ZcaA wm sh ZcaS1 ZcaS2 ZcaS3 ZcaS4 ZcaD1 ZcaD2



.qc w1 w2 ZcaM1 th ZcaC2 ZcaC4 ZcaW5 ZcaW6 ZcaW7 ZcaW8 ZcaW3 ZcaS9 ZcaF1 nt



The first four fields (.rd, .ri, .bk, q#) must be filled in at the beginning and whenever they change.

Field F2 can be left blank because it will not be copied to the .TP file. It is only useful for internal checking of EXCEL files.

The sixth field (cp) must be filled in in all records. For body sherds, the numeration from 70 to 99 must be used (see Grammar 1: “The System”, 4.6). If a number is missing for an individual sherd, this presumably means that the physical sherd did not have a number written on it. In this case, numbers 69 and lower are used, with a note in the note field. This means that numbers from 70 up and from 69 down will not be written on the sherds, while numbers from 1 up will be written. As the system is fully implemented, the 69 and lower series will disappear.

Back to top: 5. Secondary Input: Files Generated by Programs