|
|
| Line 118: |
Line 118: |
| === [[Fixing a D ID in TISS28.mdb]] === | | === [[Fixing a D ID in TISS28.mdb]] === |
|
| |
|
| === How to resolve and delete a duplicate TISS form or has an error with D_ID when an error message appears during import into [[TISS28 Data.mdb]] === | | === [[Deleting a duplicate record from the TISS pre-import file]] === |
| *When you try to Import TISS after scanning you will get an error message window: Form already exists that says:
| |
| **''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).
| |
| {{Discuss | who=Pagasa | question = do you press OK or do you press CANCEL at this point? [[User:TOstryzniuk|Trish Ostryzniuk]] 18:10, 2018 April 3 (CDT) }}
| |
| * go to folder [[x:\]]Tiss28\ExportData
| |
| ** Open TISS28 PROD2012-12-11.csv file
| |
| ** delete the row with the record that is a dupliate
| |
| ** 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".
| |
|
| |
|
| === How to delete an "Item" from Tiss.mdb === | | === How to delete an "Item" from Tiss.mdb === |