Customer Portal

Insert data to the multiple Excel files

Comments 4

  • Avatar
    admin
    0
    Comment actions Permalink
    Hi vachah,

    I would use http://doc.cloveretl.com/documentation/ ... files.html

    In short:
    * add field into metadata describing output file name
    * set partitioning on SpreadsheetDataWriter with this new field as key
    * and do something like described on line "path/outjohnsmith.xls, path/outmarksmith.xls, path/outmichaelgordon.xls, etc. (if File URL is path/out#.xls and Partition file tag is set to Key file tag)." of doc above.

    I hope this helps.
  • Avatar
    vachah
    0
    Comment actions Permalink
    Good afternoon, I know this functionality but it is not what I look for. I have many .flax files with different names and different data but with the same structure and I need to fill data from database to appropriate .flax file. To do this I need to indentify appropriate .xlsx file (when data comes from database and pair each row with appropriate data from database). I have enough information in database to identify appropriate .xlsx file but I don't know how to handle these data to open file/s I won't to open.
    Thanks, Hynek
  • Avatar
    imriskal
    0
    Comment actions Permalink
    Hello, vachah,

    we are still not sure what you want to do. Our best guess is following:

    The first part of your input data is stored in MySQL database and each record has a pointer to the second part of your input data. You want to join these two data sets and to do that you have to open appropriate file with the second half of your input data.

    You can send some path to a file as string to some reader component and set the reader to process input stream as a path to the file you want to read. In the File URL field of the reader will be something like port:$0.Field1:source (Autofilled by clicking on Port tab in URL Dialog and selecting appropriate options.) where Field1 is a name of the field in metadata. More info here http://doc.cloveretl.com/documentation/ ... ading.html

    I have also prepaired an example for you, simplified - just for your inspiration.

    inputfiles.zip

    I hope this is what you were looking for. If we got you wrong again, I am sorry, please try to send some example input and output files with example data in this case. Thank you.

    Best regards,
  • Avatar
    vachah
    0
    Comment actions Permalink
    Thanks a lot. The second works fine for our purpose.

Please sign in to leave a comment.