Recordset Structure Help

[Former Member]

Hi.

I'm new to XI and I'm currently trying to build a simple File to File scenario. I have a flat file that looks like:

name,address,id,age,....

name....

so each element is comma seperated and each record is on a new line.

I have a DT that looks like:

DT_Flat_File

-name

-address

-id

etc

I am currently building the Comunication Channel for the pickup and i dont know what to put into the "Recordset Structure" field.

Any help would be appreciated, and maybe a summary of what can go into this field also.

Thanks

Gareth

[Shabarish_Nair]

make the DT as

DT_Flat_File

-Root

-

---

name

-

---

address

-

---

id

etc

so that name, id etc comes under root

Now your recordset is root.

In the other case;

DT_Flat_File

-name

-address

-id

you will not be able to provide a recordset and it wudnt be possible to read the file using content conversion.

[Former Member]

Thanks

what about the Recordset structure field on the CC builder?

i need to tell XI how the file is delimited

[Former Member]

Hi,

Just adding with Shabz,

Recordset Structure will be

Root,*

Regards,

Jai Shankar

[Former Member]

Thanks Guys

[Shabarish_Nair]

in case your file is multilined ie

name, id

name, id ....

....

is repeating, then give it as

Recordset Structure -> root,*

and then,

root.fieldNames name, id etc

root.fieldSeparator ,

root.endSeparator 'nl'

[Former Member]

Gareth,

Also refer this link,

http://help.sap.com/saphelp_nw2004s/helpdata/en/0b/9a50465ccf84479e39a6d50c90fb3f/frameset.htm

You can fill the conversion paramters easily.

Regards,

JaiShankar

[Former Member]

HI,

in which area do i put the:

root.fieldNames name, id etc

root.fieldSeparator ,

root.endSeparator 'nl'

[Former Member]

Hi,

In Sender file communication channel. Choose the Msg protcol as File Content Conversion. You will get a table kind of thing in the bottom of your communication channel. There you will fill these.

Go through this weblog

/people/venkat.donela/blog/2005/03/02/introduction-to-simplefile-xi-filescenario-and-complete-walk-through-for-starterspart1 - File to File Part 1

/people/venkat.donela/blog/2005/03/03/introduction-to-simple-file-xi-filescenario-and-complete-walk-through-for-starterspart2 - File to File Part 2

Regards,

Jai Shankar

[Former Member]

HI,

i am now getting this error:

Conversion initialization failed: java.lang.Exception: java.lang.Exception: java.lang.Exception: Error(s) in XML conversion parameters found: Parameter 'Root.fieldFixedLengths' or 'Root.fieldSeparator' is missing Consistency check: no. of arguments in 'Root.fieldFixedLength' does not match 'Root.fieldNames' (0 <> 7)

any ideas?

[Shabarish_Nair]

use Root.fieldSeparator = , in case your file is separated by a comma. dont use fixedfieldlengths.

[Former Member]

i have the following

Root.fieldSeperator = ,

Root.endSeperator = 'nl'

Root.fieldNames = address,name,....etc

i currently dont have anything about fixedfieldlengths and i'm still getting that error

[Former Member]

Ok i changed "Seperator" to "Separator" and it worked. so just a simple spelling error.

now i'm trying to get it to access a folder on my machine. i have it shared and have the source in as
machine name\folder.

how should i have this?