8 Replies Latest reply on Jan 30, 2014 1:02 PM by philmodjunk

    Seeking Advice for Importing from CSV without a unique id in source file

    aklobby

      Title

      Seeking Advice for Importing from CSV without a unique id in source file

      Post

           I am having to import several times a week from a csv file that changes daily but does not have a good unique id. I am faced with having records skipped due to errors and I think it is because sometimes the id in the source table may change slightly from import to import. Does anyone have any advice on how to create a unique ID in the source file (third party) that could help reduce errors? The ID field format is two or three letters followed by two spaces and then a series of numbers. It is very important that the records be updated most every day as things change constantly in the record. With the skipped record error, I also have no clue which records are being skipped. My database currently has 600+ records, but by the end of a two week period could have as many as 2 thousand. 

           Any help would be greatly appreciated. 

           Allison