Content Conversion Parameters

[Former Member]

I am trying doing content conversion text file to text file with one communication channel emisor on the 'Content Conversion' parameters shown below:

Document Name: mt_DatosMaestros

Document Namespace:urn:Bais:DatosMaestros

Recordset Structure: mt_actividad_comprador,,mt_canal,,mt_clase_ruta_dist,,mt_clase_ruta_prevta,,mt_cuenta_clave,,mt_forma_pago,,mt_franquicia,,mt_int_comp,,mt_jefe_com,,mt_nivel_socioec,,mt_prog_lealtad,,mt_sector,,mt_subcanal,,mt_tamano_cte,,mt_tipo_venta,,mt_zona,,mt_categoria,,mt_empaque,,mt_familia,,mt_lanzamiento,,mt_lista_precios,,mt_marca,,mt_presentacion,,mt_propietario,,mt_retornabilidad,,mt_sabor,,mt_segmento,,mt_tamano,,mt_tipo_articulo,,mt_Listas_prec,,mt_promotor,,mt_exclusivo,,mt_estado,,mt_municipio,,mt_ciudad,,mt_tipoentrega,,mt_modoventa,,mt_tiempoent,,mt_Tipo_Visita,*

Recordset Sequence: Variable

Recordsets per Message: 1

Key Field Name: tipo

Key Field Type: Integer

The parameters I used are shown below:

mt_actividad_comprador.fieldSeparator ;

mt_actividad_comprador.fieldNames tipo,idioma,actividad,desccorta,descmedia,desclarga

ignoreRecordsetName true

mt_actividad_comprador.keyFieldValue 14

mt_actividad_comprador.keyFieldInStructure ignore

mt_canal.fieldSeparator ;

mt_canal.fieldNames tipo,idioma,canal,desccorta,descmedia,desclarga

mt_canal.keyFieldValue 15

mt_canal.keyFieldInStructure iggnore

mt_clase_ruta_dist.fieldSeparator ;

mt_clase_ruta_dist.fieldNames tipo,idioma,claserutadist,desccorta,descmedia,desclarga

.

.

.

Above i done but i dont know how send this datos to text file for each Recordset Structure according

to keyFieldValue and with one communication channel receptor

I do not want multi-channel receptors i need that the channel receptor write different text files according to keyFieldValue someone can help me?

Thanks

[Former Member]

Hi Justin

Thanks by the links

I want to according to the input text file the receiver channel must create a text file output to a specific directory with only receptor channel and receiver channel.

Thanks

[Former Member]

Raj

the structure I mentioned above was an example actually I have not finished the emisor channel

this is the source file (LCRECVTAS03.csv):

D56,0000040382,181.154,CU,225.299,CU,-19.6

D56,0000040388,527.757,CU,628.123,CU,-16.0

D56,0000040396,347.057,CU,324.896,CU,6.8

D56,0000040398,159.600,CU,246.674,CU,-35.3

D56,0000040410,380.983,CU,489.303,CU,-22.1

D56,0000040414,78.380,CU,45.000,CU,74.2

D56,0000040416,177.274,CU,188.187,CU,-5.8

D56,0000040418,94.121,CU,180.041,CU,-47.7

D56,0000040423,89.467,CU,205.812,CU,-56.5

D56,0000040437,189.252,CU,238.311,CU,-20.6

D56,0000040442,100.029,CU,108.019,CU,-7.4

D56,0000040445,140.207,CU,154.544,CU,-9.3

D56,0000040447,120.543,CU,141.820,CU,-15.0

D56,0000040450,169.213,CU,191.566,CU,-11.7

D56,0000040458,128.838,CU,234.496,CU,-45.1

this is the text file (Clients.txt) on how you want it:

00403820022500181.D56

00403880062800528.D56

00403960032500347.D56

00403980024700160.D56

00404100048900381.D56

00404140004500078.D56

00404160018800177.D56

00404180018000094.D56

00404230020600089.D56

00404370023800189.D56

00404420010800100.D56

00404450015500140.D56

00404470014200121.D56

00404500019200169.D56

00404580023400129.D56

00404600012400097.D56

00404610020800225.D56

00404640032100088.D56

Thanks Raj !!

[justin_santhanam]

Liz,

Can you please go through the below blogs and see if it helps you?

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

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

/people/venkat.donela/blog/2005/06/08/how-to-send-a-flat-file-with-various-field-lengths-and-variable-substructures-to-xi-30

/people/anish.abraham2/blog/2005/06/08/content-conversion-patternrandom-content-in-input-file

/people/shabarish.vijayakumar/blog/2005/08/17/nab-the-tab-file-adapter

/people/jeyakumar.muthu2/blog/2005/11/29/file-content-conversion-for-unequal-number-of-columns

/people/shabarish.vijayakumar/blog/2006/02/27/content-conversion-the-key-field-problem

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

~Raj

[Former Member]

Raj

My source file structure is:

mt_actividad_comprador 0..unbounded dt_actividad_comprador

idioma 0..1 xsd:string minLength="1"; maxLength="1" 0..1

actividad 0..1 xsd:string minLength="1"; maxLength="1"

desccorta 0..1 xsd:string minLength="20"; maxLength="20"

descmedia 0..1 xsd:string minLength="40"; maxLength="40"

desclarga 0..1 xsd:string minLength="60"; maxLength="60"

target structure:

LANGU 0..1 xsd:string maxLength="1"

ZBIACTCOM 0..1 xsd:string maxLength="1"

TXTSH 0..1 xsd:string maxLength="20"

TXTMD 0..1 xsd:string maxLength="40"

TXTLG 0..1 xsd:string maxLength="60"

Thanks

[justin_santhanam]

Liz,

I would like to see your flat file.(text file) and also you want to apply content conversion only on Sender File Adapter or Receiver File adapter too.

Thanks!

[justin_santhanam]

Liz,

Can you reply with your flat file structure from source system and XML Structure on how you want?

Thanks!