Link to home
Create AccountLog in
Avatar of jhinson
jhinson

asked on

EDI with VAN, particularly CovalentWorks

We are switching from AS400 platform to Windows based for all applications, including EDI.  We know how to generate our X12 transaction sets and have tested successfully with two financial institutions.  Windows based solution uses FTP.

We have one customer who must go through a VAN.  With the AS400 we would send/receive one file and the VAN broke out to whom the data would be sent based upon ISA record.  That option is not available to us when we switch to FTP.

Our script is similar to:
Script to get our file
Open ftpsitename
username
password
cd /Inbox
get NameOfFile.TXT c:\Folder\FileName.txt
Quit

Script to send a file
Open ftpsitename
username
password
cd /Outbox
put c:\Location\FileName.txt
Quit

Our problem is that our customer could send multiple files and our VAN says we will have to "Get" the files by file name.  I kind of understand that we could use "MGET" but then how could we control processing unknown file names after receiving the file(s).
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Not quite sure I understand what you're having trouble with.

Are you having troubles getting multiple files from the FTP site?

Or are you having troubles processing those files through the VAN after getting the files?
Avatar of jhinson
jhinson

ASKER

Sorry for confusion.  Let's say there are 3 files in my inbox.  FileA, FileB, and FileC.  I could (if I knew the file name) GET each file by file name or I could MGET all files at once (as I understand FTP).  But after MGET the script would not know the file names, correct?  So without human intervention (renaming each file, then processing) how could I process the 3 unknown files?
ASKER CERTIFIED SOLUTION
Avatar of Scott McDaniel (EE MVE )
Scott McDaniel (EE MVE )
Flag of United States of America image

Link to home
membership
Create an account to see this answer
Signing up is free. No credit card required.
Create Account