Not importing all slips, Record Failed, Nickname 2 already in use

SUGGESTED

I have a couple of issues with importing:

I have imported all the purged slips from my backups for the fiscal year (5/1 thru 4/30) into a separate archive database, so that we can run certain reports based on those slips.

Most of the backups imported accurately with the correct number of slips matching my paper log.  However, 12 of the 154 backups did not import *all* the slips that they should have.  The dialog box that pops up on these imports shows the total imported (which is way less than it should be) and it says "Failed: 1".  

For instance, for 5/26/21 there should have been 40 slips imported.  But it only imported 6.  

When I click on Journal to view the details, it says "Record 7 Failed - The Nickname 2 field contains a name that is already in use.  You must define unique names for Nickname 2. Please change the name." --(In our case, Nickname 1 is the alpha/numeric Client Name, and Nickname 2 is a 4-digit numeric Client Number)

So it stopped importing at the "failed" record (#7) and did not import any more slips after that. 

It's the same for all the incorrect imports: it stops at the failed one and doesn't import any more after that.  It's also the same error message for each one (Nickname 2 error).

Issue #1 - I don't know which client/slip it's referring to that it says has a duplicate Nickname 2.  It says "Record number", but how do I cross-reference that?

To troubleshoot, I tried selecting a couple of the incorrect imports, and manually checked each client that was billed on that particular backup to see if there was a duplicate Nickname 2 anywhere else in the Open, Templates, Inactive or Closed lists of clients, and I could not find any.  So why is it telling me there is a duplicate Nickname 2?

Issue #2 - The Grand Total of slips that were imported was 13,816.  However, there are an additional 1,436 slips missing from the incorrect imports (based on my paper logs) which means that any reports I run will not be accurate.  (Almost 10% of the slips were not imported!)

Any thoughts or solutions to these issues and/or how to import those missing slips? (Running 2015 Sage Timeslips)

  • 0

    "It says "Record number", but how do I cross-reference that?"

    It is the number of the record (in your case slip) that you are trying to import. 

    I would try to see what Record 7 has for client nicknames, it might help you find the duplicate.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0 in reply to Nancy Duhon

    Do you mean the Slip ID?......because slip ID's for that fiscal year are 5 to 6 digits long. 

    If you don't mean Slip ID, then how do I search for Record 7 out of that import? (There's a Record 7 in every import.  The numbering starts over each time.)

  • 0 in reply to Tr@cy
    SUGGESTED

    No, I do not mean Slip ID.

    Record 7 is literally the seventh record in the file that you are trying to import.

    Alternatively, you could just temporarily allow duplicate Nickname 2's. Make a backup, allow them, get the slips in, get your reports, then restore.

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]

  • 0

    Actually the record number on the import is the record number from the csv file.  So if it is the 7th record in the csv file, it will say "Record 7 failed).  It also imports them in the order of which the appear on the csv file so if you print a slip listing, you can probably match them up.  

  • 0 in reply to Terryr

    True, but I think they are trying to combine an archive file, not a CSV.

  • 0 in reply to Nancy Duhon

    Nancy,

    Sorry I went dark for awhile....I have been working on it like you suggested: allowing duplicate Nickname 2's and re-importing the backups that had the failed records the first time around.  It was painful (!) but it is now a 99% success with just some operator error, so thank you.  (Painful because the re-importing brought in duplicates of the slips that had already successfully imported the first time, so I had to go thru "Show Slips" for each account on the particular backup and find the duplicate slips and delete them. I'm hoping you're not going to tell me now how I could've done that task much easier and faster....)

    I do these reports once a year and every year I learn something new.  Next year I will make sure to Allow Duplicate Nickname 2's.

    I still would like to know how to view the list of Records in each import.  

    Thank you!

  • 0 in reply to Tr@cy

    I don't think you can view the contents of the Archive file without combining them back into a database. If it was a raw data/CSV file, you could open it in Excel to look at the contents.

    But next time, just make a backup before you start importing. Then, if you have trouble, you can always restore that backup and start over. (No need to hand delete. That does sound particularly painful.)

    Nancy Duhon, Esq.
    Duhon Technology Solutions, LLC
    Master Certified Consultant for Sage Timeslips
    Providing individual Consultations and Third Party Remote Desktop Support - including older/unsupported versions.
    404-325-9779
    [email protected]