flat file structured

[former_member184166]

Hi,

I can to manipulate an archivo how this using file adapter?

FABRICA : FA2 FABRICA 2

CODIGO :224 - A-DC (3426) FECHA : 13/02/2006 FORMULADOR : MGV

ANALISIS INGREDIENTS : /1000 /3000

-

---

-

---

23 MAIZ ARGENTINO = 620.65 1,861.95

154 POROTO SOYA = 233.00 699.00

647 H.PESC S = 118.00 354.00

428 FOSF BICALCICO = 11.00 33.00

49 SAL = 4.00 12.00

regards,

[moorthy]

Hi,

Is given sample is File contents? and if you want to process this using XI ?

If so read entire file with Record,Row structure (general content conversion without specific to the field level) then you can manipulate either thru Module Processor to get into requuired structure or thru mapping.

Just to know more about above approach-

/people/sravya.talanki2/blog/2005/08/16/configuring-generic-sender-file-cc-adapter

If you provide more info, answers will be better.

Regards,

Moorthy

Message was edited by: Krishna Moorthy P

[former_member184166]

Hi Krishna.

I want to process this using XI.

Mi scenario is FILE --> XI --> JDBC

I need to read this archive, parsing it and insert the registers in an database.

I'm go to revise the weblogs

Regards,

[moorthy]

Thanks for the update..

Then this blog will give you intial idea and then you can continue with Module Processor, to get the correct sturcture . Then ordinary mapping to get into the JDBC adapter.

Or even you can think of Java mapping to get parse the general record level structure got from the file (as described in the blog) and proceed further.

For adapter modules -

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/3bdc14e1-0901-0010-b5a9-a01...

Regards,

Moorthy

[former_member184166]

Thanks Krishna..

The second link is referent to java proxy?...

I'm think i need to create an module java for to parsing the flat file because not it an file simple...

is correct?

Best Regards,

[moorthy]

<i>The second link is referent to java proxy?...</i>

No ,

It is for Adapter modules.

<i>I'm think i need to create an module java for to parsing the flat file because not it an file simple...

is correct?</i>

Yes, you are going to parse flat xml with all the data into respective fields . Totally you are going to make the strutcure out from flat xml..

Regards,

Moorthy