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
 

Alex_Pastuhov

Legendary Poster
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...
 

Chan Rana

Legendary Poster
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
 
Top