Skip to Content
author's profile photo Former Member
0
Former Member

Send a flat file with fixed lengths to XI 3.0 using a Central File Adapter?

Posted on Jan 05, 2005 at 09:35 AM 29 Views

Hello,

I'm wondering if someone have experience setting up conversion for different record structures. The example shown,

/people/michal.krawczyk2/blog/2004/12/15/how-to-send-a-flat-file-with-fixed-lengths-to-xi-30-using-a-central-file-adapter,

(in a greate way) only picture one kind of structure.

How should it be done if the file would contain

10Mat1

20100PCS

The first record structure has columns

ID(2),Material(10)

The second redcord structure has columns

ID(2),Quantity(3), Unit of messure (3)

Brgds

Kalle

Message was edited by: Karl Bergstrom

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Stefan Grube
    Stefan Grube
    Posted on Jan 05, 2005 at 11:49 AM
    1

    The configuration would be like follows:

    Content Conversion Parameters:

    Document Name: <your message type name>

    Document Namespace: <your message type namespace>

    Document Offset: <leave empty>

    Recordset Name: <any name>

    Recordset Namespace: <leave empty>

    Recordset Structure: row1,,row2,

    Recordset Sequence: any

    Recordsets per Message: *

    Key Field Name: ID

    Key Field Type: String

    Parameters for Recordset Structures:

    row1.fieldNames ID,Material

    row1.fieldFixedLengths 2,10

    row1.keyFieldValue 10

    row2.fieldNames ID,Quantity,UOM

    row2.fieldFixedLengths 2,3,3

    row2.keyFieldValue 20

    Instead of row1 and row2 you can choose any name.

    Regards

    Stefan

    Add a comment
    10|10000 characters needed characters exceeded

    • Stefan Grube Former Member
      Jan 10, 2005 at 02:27 PM

      When I compare the input file with the configuration: are you sure, that the material number has 10 signs? Mat1 followed by 6 spaces?

      Otherwise change the config to:

      row1.fieldNames ID,Material

      row1.fieldFixedLengths 2,4

      row1.keyFieldValue 10

      row1.lastFieldsOptional YES

      Regards

      Stefan

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.