Skip to Content
avatar image
Former Member

Content Conversion Parameters

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Mar 23, 2010 at 12:47 AM

    Liz,

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

    Thanks!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2010 at 01:10 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Mar 23, 2010 at 02:09 AM

    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 !!

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Mar 24, 2010 at 01:40 AM

    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

    Add comment
    10|10000 characters needed characters exceeded