Does anyone know what happens if there are duplicate records in the HR521CSV file? Will they overwrite or add new ones or will the program error out? I have several duplicate records that I don't really care to clean up before running in, any ideas?
The HR521 program will basically add a new record for each record in your CSV file. In fact you'd have a hard time getting it to produce any errors, which is kinda good in a way.
I think you'd be better off coming up with some way to get rid of your duplicates. Are you using UNIX or NT? Not that it matters much but I know of a UNIX tool that can help if the records are really exact duplicates.
if you have exact duplicates you can potentially do this:
cat yourfile.csv | sort | uniq > uniqfile.csv
the uniqfile.csv will contain only sorted uniq records. I use this trick pretty often to get rid of extra junk. But it only works with exact duplicates, if you have two history records that are identical but have different dates then you're out of luck, I guess you could either write a program or pull them into Excel if you have less than 65000 records.
<_< hah hah, this emoticons are neat