Esker File Error Report

select * from C_ESKERF where customer = '12345' and c_eskerf_id = '1234567890'

2) If the query returns anything, then it was a timing issue and may be disregarded.

3) If the query DOES NOT return anything, then the Esker CSV needs to be reprocessed in in UNIX. Connect to UNIX by using PuTTY and follow the next steps.

4) Using PuTTY, log in to G2 (erpprod2.hagerco.com). Navigate to /g2/prod/userdata/scripts/esker/eskerdone and look for the CSV file for the Esker order.

• Use the command: ls -Al OrderCSV'EskerNumber.csv' (Ex.  ls -Al OrderCSV1000678741175949460.csv)

5) Move the CSV file to the Esker Temp directory. (UNIX command 'mv' is used to move files)

mv  OrderCSV1000678741175949460.csv ../eskertemp

6) There is a cron job that looks for Esker orders in the eskertemp directory every 2 minutes. The cron job will grab the CSV file, process the file, and move the CSV to eskerdone when complete. 

7) Navigate to eskertemp and list the directory to verify the CSV was moved. 

 cd .. ; cd eskertemp ; ls -Al  

'cd ..' -- moves to previous directory
'cd eskertemp' -- moves to the eskertemp directory
'ls -Al' -- lists all contents in directory, in long format (showing more details)
Commands can be linked together for a single line argument by using a semicolon between commands.

ls -Al 

OR USE COMMAND 'll' (Two lower case letter L).