Sage 100

Importing Duplicate records Some time ago I thought I read where one of you wrote a program to prevent importing duplicate records using VI within the same import BEFORE the records have been updated. The user occasionally runs the import a second time. Can someone point me in the right direction? MAS 200 Ver 4.4.9

It was this thread if it was for AP invoices. https://90minds-com.socialcast.com/messages/5664955

Just completed a project in which the client was importing into some data entry files. To prevent this I added some perform logic that would move and rename the source file so the user would be forced to generate a new source fiile again.

Any thoughts on sharing what you did???

@JeffSchwenk he probably used something like this, which was found on Slade Hornick's old website: Renaming the Import File with Job Success Perform Logic 1. Create a text file with the following perform logic SETERR EXIT_LOGIC F$=STP(VI2_IMPORT_FILE$) F=POS("".""=F$,-1) IF F<>0 THEN F$=F$(1,F-1) F$=F$+"".XXX"" ! OR WHATEVER EXTENSION YOU WANT ERASE F$,ERR=*NEXT ! DELETES THE FILE IF IT ALREADY EXIST CH=FFN(VI2_IMPORT_FILE$) IF CH<>-1 THEN CLOSE (CH) RENAME VI2_IMPORT_FILE$,F$ EXIT_LOGIC: EXIT 2. Save it in your VI directory 3. On the configuration tab of Visual Integrator select the perform button. And supply the call to the text file and perform on success. 4. Test with a dummy company and files. **** THE ABOVE EXAMPLE IS FOR ILLUSTRATION ONLY OF WHAT CAN BE DONE WITH PERFORM LOGIC. USE OF ANY PART OR ALL OF THIS EXAMPLE IS AT YOUR OWN RISK.****

It's at home, I'll post later.

My perform logic to rename is: If exist U:\TimeTest.xls rename U:\TimeTest.xls WOTime_%date:~4,2%%date:~7,2%%date:~10,4%.%time:~0,2%%time:~3,2%%time:~6,2%.xls This renamed the file with a time and date stamp