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:

TISS28 Form Scanning ‎ (← links) Deleting an item from TISS28.accdb ‎ (← links)