Importing Punch List Items

Large numbers of punch lists can be entered using the Import option. To use this option, the user must already have the punch list header as the current screen.

Clicking the [Import] button will open the file selection pop-up window.

Check the 'Delete existing imported records' box to remove any temporary data previously uploaded using this import tool. This option does not delete or overwrite any existing records in the system.

Once the file is selected, click the [Upload] button to bring the data in prior to validation. The screen displayed below is presented to the user:

Edit the data. All fields shown with a non-white background include an error and must be corrected to be imported. Placing the mouse-pointer over the colored area will give details of the error. Individual records may be deleted from the import by checking the 'Delete' box on the right side of the display.

Use the [Re-Validate] button to update changes and review any further errors. Once all records are corrected, click the [Accept] button. Existing punch list items will be updated and new ones will be created by the import, if they are not already existing.

ASCII File Layout – Punch List Items Import

CONTROL FILE = PMPUNCHL.CTL

Column Separator: comma (,) Column delimiters (optional): quotes ("")

No	Database Column	Description	Data Type	Required
1	PMFPDI_COMP_CODE	Company Code	CHAR 8	Yes
2	PMFPDI_PROJ_CODE	Project Code	CHAR 10	Yes
3	PMFPDI_PMPL_CODE	Punchlist Header	CHAR 10	Yes
4	PMFPDI_ITEM_CODE	Item No	NUM 5	Yes
5	PMFPDI_AREA1_VALUE	Area1 Value	CHAR 10
6	PMFPDI_AREA2_VALUE	Area2 Value	CHAR 10
7	PMFPDI_AREA3_VALUE	Area3 Value	CHAR 10
8	PMFPDI_AREA4_VALUE	Area4 Value	CHAR 10
9	PMFPDI_DESC	Description	CHAR 4000
10	PMFPDI_STATUS_CODE	Status	CHAR 10	Yes
11	PMFPDI_PARTN_ABBREV	Responsibility	CHAR 8
12	PMFPDI_CONTACT_CODE	Contact	CHAR 10
13	PMFPDI_AUTH_PARTN_ABBREV	Author Comp.	CHAR 8
14	PMFPDI_AUTH_CONTACT_CODE	Authored By	CHAR 10
15	PMFPDI_INSP_PARTN_ABBREV	Inspection Comp	CHAR 8
16	PMFPDI_INSP_CONTACT_CODE	Inspected By	CHAR 10
17	PMFPDI_INSPECTED_DATE	Inspected On	DATE DD-MON-RRRR
18	PMFPDI_RECEIVED_DATE	Received On	DATE DD-MON-RRRR
19	PMFPDI_ISSUED_DATE	Issued On	DATE DD-MON-RRRR
20	PMFPDI_START_DATE	Started On	DATE DD-MON-RRRR
21	PMFPDI_SCHD_COMPL_DATE	Schd. Compl.	DATE DD-MON-RRRR
22	PMFPDI_REINSPECTED_DATE	Re-Inspected	DATE DD-MON-RRRR
23	PMFPDI_COMPLETED_DATE	Completed	DATE DD-MON-RRRR
24	PMFPDI_SIGNED_OFF_DATE	Signed-Off	DATE DD-MON-RRRR
25	PMFPDI_VALUE	Value	NUM
26	PMFPDI_CLV_VALUE_CODE1 Class. Depend.	Classifier Code 1	CHAR 16
27	PMFPDI_CLV_VALUE_CODE2 Class. Depend.	Classifier Code 2	CHAR 16
28	PMFPDI_CLV_VALUE_CODE3 Class. Depend.	Classifier Code 3	CHAR 16
29	PMFPDI_CLV_VALUE_CODE4 Class. Depend.	Classifier Code 4	CHAR 16
30	PMFPDI_CLV_VALUE_CODE5 Class. Depend.	Classifier Code 5	CHAR 16
31	PMFPDI_CLV_VALUE_CODE6 Class. Depend.	Classifier Code 6	CHAR 16