Deleting a duplicate record from the TISS pre-import file: Difference between revisions
Jump to navigation
Jump to search
Ttenbergen (talk | contribs) m (Text replacement - "TISS28.mdb" to "TISS28.accdb") |
Ttenbergen (talk | contribs) m (Text replacement - "Deleting an item from TISS.mdb" to "Deleting an item from TISS28.accdb") |
||
| Line 1: | Line 1: | ||
This page deals with deletions '''during''' the import process. For deletions after import, see [[Deleting an item from | This page deals with deletions '''during''' the import process. For deletions after import, see [[Deleting an item from TISS28.accdb]]. | ||
== Instructions == | == Instructions == | ||
Revision as of 12:09, 2020 June 5
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: |