Reading FlatFiles from Amazon S3 Bucket

AlanParsons

Member
Hi

Customer uses the Amazon S3 buckets ( .csv / .txt) to store bank files. We need to read and upload them in JDE. I tried to used the FetchNextLineFromFlatFile (B76B0220) function but it fails. Checked the debuglog and it gives the 3003 error code (Open of File Unsuccessful). The files / S3 buckets have all the permissions required to read the files. Am I missing anything?


Release : 9.2.0.3

Thanks!!

Feb 10 12:56:21.194009 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 1] <Item>: szFlatFileName <type>: STRING <Value>: [https://s3.us-east-2.amazonaws.com/t...r/Tesfile.csv]
Feb 10 12:56:21.194010 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 2] <Item>: idFilePtr <type>: ID <Value>: [0]
Feb 10 12:56:21.194011 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 3] <Item>: szFlatFileRecord <type>: STRING <Value>: []
Feb 10 12:56:21.194012 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 4] <Item>: mnRecordLength <type>: MATH_NUMERIC <Value>: [500]
Feb 10 12:56:21.194013 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 5] <Item>: cSuppressErrorMessage <type>: CHAR <Value>: []
Feb 10 12:56:21.194014 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 6] <Item>: cErrorCode <type>: CHAR <Value>: [2]
Feb 10 12:56:21.194015 - 3124/2236 WRK:Starting jdeCallObject OUT->[ 7] <Item>: szErrorMessageID <type>: STRING <Value>: [3003]
Feb 10 12:56:21.194016 - 3124/2236 WRK:Starting jdeCallObject
 
I don't think JDE has any built-in functionality for this. The File IO functions work with OS file API's, while here you effectively need a WEB access API for this to work. It would require some custom development...
 
Design a script that would access and read the file from AWS and copy it locally on your network and then call this script and open function from E1 process that should work.

Chan
 
Thank you all for the responses. The customer is going to FTP the files from S3 into JDE server folder path.
 
Back
Top