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).
Software.NET Programming

Avatar of undefined
Last Comment
Scott McDaniel (EE MVE )

8/22/2022 - Mon
Scott McDaniel (EE MVE )

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?
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
Scott McDaniel (EE MVE )

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
All of life is about relationships, and EE has made a viirtual community a real community. It lifts everyone's boat
William Peck