Results 1 to 5 of 5

Thread: Reading FlatFiles from Amazon S3 Bucket

  1. #1

    Reading FlatFiles from Amazon S3 Bucket

    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

  2. #2
    Senior Member Alex_Pastuhov's Avatar
    Join Date
    Jul 2001
    Location
    Australia
    Posts
    1,723
    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...
    Regards,
    Alexander Pastuhov
    http://www.everestsoftint.com/

  3. #3
    LynX File Exchanger does precisely what you are trying to do. Link: https://www.aellius.com/lynx-busines...ile-exchanger/
    Regards,

    Hari Sharma
    Aellius
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  4. #4
    Senior Member Chan Rana's Avatar
    Join Date
    Aug 2005
    Location
    PA,USA
    Posts
    1,000
    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
    Chandrakant Rana
    E1 Xe-9.0, AS/400, XML, BSSV
    E1 Integration,C,HTML,Java,CreateForm 3.0

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

Thread Information

Users Browsing this Thread

There are currently 2 users browsing this thread. (0 members and 2 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company, Oracle or Peoplesoft.