Import/update Script Required 29.03.08
Looking for a simple asp script that can do the following:
Fetch tab delimited files from a directory
Check items in the file and if it exists, update details… otherwise Import (adding/updating with the date imported/updated)
Delete the original file
Then finally, delete any items which haven’t been changed in a week.
Also, if it can be made to run automated, it would be useful if it could record the text file name, total items added/updated to a log file but not critical.
Either way, I’d like it to be as automated as possible as we’ll be getting files that need to be processed every other day.