• Welcome to the upgraded JDELIST forum and thank you for your patience.
    Please restrict discussions and issues regarding the new forum software to the Off Topic forum. We will be monitoring that forum for issues.
    If you have trouble logging in, please reset your password using the forgotten password form: https://www.jdelist.com/community/index.php?lost-password/
    If you are unable to successfully reset your password, please contact us: Click here!
    We hope that you enjoy the upgraded forum.
  • Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Flat File Formatting


Dear All,

I am currently exploring the possibility of using flat files to populate OW tables in Xe.
The position I'm currently in is that I have the text file that I have downloaded from my suppliers web site and it's currently stored on my local drive. I have also mapped the file in the P47002 cross reference program.
When I run the R47002c I receive an "invalid format" error. What is the next step I should be taking? Currently the text file is empty of any quotation marks or commas so I guess this is where the problem lies.

Many thanks in advance,



Active Member

Which tables do you want to populate?
One thing to keep in mind is that the data in the import-file must be in exact the same order as the 47-table you want to populate. In the documentation there is information about which fields are required etc. See also the processing options of the R47002C: e.g. the field delimiter and text qualifier.

(my two euro-cents)


B7332 / XE / NT4 / SQL 7 / VisualStudio 6 SP5