TISS28 Form Scanning: Difference between revisions
| Line 44: | Line 44: | ||
==Importing batch into [[TISS28.mdb]]== | ==Importing batch into [[TISS28.mdb]]== | ||
# Open the '''[[TISS28.mdb]]''' (Access icon), Enter password (a list of main office passwords are stored in an Excel file on "M") | # Open the '''[[TISS28.mdb]]''' (Access icon), Enter password (a list of main office passwords are stored in an Excel file on "M") | ||
# click | # click "Re-connect.MDBs" button | ||
# Click "Import TISS Data", click "OK" for success message (takes <1 minute) | # Click "Import TISS Data", click "OK" for success message (takes <1 minute) | ||
#* when done, program says "Successfully imported data from <THE NUMBER> TISS forms." (this number is pretty much never wrong) | #* when done, program says "Successfully imported data from <THE NUMBER> TISS forms." (this number is pretty much never wrong) | ||
#* There might be an error titled "Form already exists" with 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."; if so see [[Deleting a duplicate record from the TISS pre-import file]] | #* There might be an error titled "Form already exists" with 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."; if so see [[Deleting a duplicate record from the TISS pre-import file]] | ||
# A table will show up -qryConfirmImport | # A table will show up - "qryConfirmImport" | ||
# Verify that you have a line with correct D_ID for each form | # Verify that you have a line with correct D_ID for each form | ||