Header and Detail Flat Txt Files and PDF get FTP'd to us.
Header Flat File (contains "hd")
Detail Flat File (contains "dt")
PDF
NOTE: The file names begin with the last 3 digits of the wave name... IE if Dody asks about "wave 15662", the files start with 662...
Task Scheduler runs "GNCUpload" every 30 minutes.
This runs \\Web2\e$\EDInterchange2022\GNCUpload.bat
This runs:
OrderImporter.exe /p:1
OrderImporter.exe /p:2
cmdUtil.exe /o:w /p:5
Orders are added to WinSQL2 DB ImportOrder Table
After Processing an email goes to Dody and to us.
PDF File gets moved to:
\\Web2\e$\EDInterchange2022\Files\GNC\PDF
Files get moved to:
\\Web2\e$\EDInterchange2022\Files\GNC\Orders
Ship Notes are sent daily (early morning) via email.
Usually if there is a problem it is because the files never made it to our sFTP.
Simply check the sFTP to see if the files are there, if not they need to resend.
Sometimes they send the order files but not the PDF workorders.
Sometimes an orders in the Header File does not have a matching number in the Detail file. This causes an error. The offending order could be removed from the header file to proceed. That order would then need to be manually input by Dody using the work order as a guide.