Deleting a duplicate record from the TISS pre-import file
This page deals with deletions during the import process. For deletions after import, see Deleting an item from TISS28.accdb.
Instructions
As part of TISS28_Form_Scanning#Importing_batch_into_TISS28.accdb you may get the following error:
- title: Form already exists
- content: A scanned form has a D_ID and first date that already exists in L_TISS Form. Click OK to see query. You might be able to edit the TISS_export table to resolve the issue(e.g. delete the offending line). Click OK to re-check or cancel and stop import.
- you will see a query come up which displays the offender: (qry_ExportCheck_form_already_exists_in_L_TISS_Form).
- press "OK"
- go to folder x:\Tiss28\ExportData
- Open TISS28 PROD2012-12-11.csv file
- delete the row with the record that is a duplicate
- save the file
- A message window will show up: TISS28 PROD2012-12-11.csv already exists. Do you want to replace it?
- Click YES.
- Another message window will show up: TISS28 PROD2012-12-11.csv not compatible with csv, do you want save the workbook in this format?
- Click YES again.
- go to TISS28 Database and click the "Import TISS Data".
- return to TISS28_Form_Scanning#Importing_batch_into_TISS28.accdb
Related articles
Related articles: |