flat file

  1. Reading from Flat file (XML) and adding substrings as data to table

    Hi everyone , I need help.I want to use an UBE to read an XML as a flat file , and by using Fetch next Line from flat file , cut a substring between the <MS1:MsgId> to </MS1:MsgId> for example , and store it in a custom table , already built to match the type of the data we are going to...
  2. 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...
  3. Flat file access issue

    Hi I created a flat file in my C drive as C:/file.txt and sending the same to my report through PO. and I debugged the report. while the B34A1010 (Open Flat file) function is working correctly and getting a file pointer. then the function B76B0220 (fetch next line from fat file)is called and...
  4. Invalid Format Error When Running R47002C for Inbound 850 Flatfile

    Hi - I am trying to convert an inbound 850 flatfile using R47002C. The format is set up to go into F47011 and F47012. The delimiters are a comma (,) to separate fields and an apostrophe (" ") to delimit text. If anyone has resolved this problem and you please let me know how you resolved the...
  5. Speed gain using cache to write lines to flat file

    Hello guys. I would like to know if using a cache structure, to write lines to a flat file in it, would be faster than stopping the application flow to wirte one line to flat file and get back to the application to process it again. So, if I "cache" the lines within the Do Section, in my...
  6. Speed gain using cache to write lines to flat file

    Hello guys. I would like to know if using a cache structure, to write lines to a flat file in it, would be faster than stopping the application flow to wirte one line to flat file and get back to the application to process it again. So, if I "cache" the lines within the Do Section, in my report...
  7. Aarto

    Example of flat file for Forecast import into F3460Z1 using R47002C

    Hi all! Does anyone have an example of flatfile format that can be used to import into F3460Z1 forecast interop table using R47002C? I've read all documents i could find and have a file that should work but am "getting invalid format error" Attached is one of the files i've used. It's just...
  8. SPS Commerce and EDI

    Hi Guys, We are starting to work with SPS commerce for out EDI business. Recently they provided 850 layout, which was in single quote as double quote as qualifiers with LineFeed (LF) on the end. The problem with such a text file is that it doesn't specify whether each line is Header/Detiail or...
Top