Uploaded image for project: 'Fuse Tooling'
  1. Fuse Tooling
  2. FUSETOOLS-2216

editor is generating a header attribute within a csv marshal tag which causes errors

    XMLWordPrintable

Details

    • Hide
      • Create a JBoss Fuse project with blueprint template.
      • Delete existing route from the blueprint.xml using Source tab.
      • Paste following route in Source tab.
           <route id="extract-route">
                             <from id="cron" uri="{{extract.schedule}}"/>
                    <transacted id="_transacted" ref="PROPAGATION_REQUIRED"/>
                    <log id="log_start" message="Firing db call"/>
                    <to id="to_select" uri="sql:classpath:cx_extract_combined.sql"/>
                    <to id="to_update" uri="sql:{{sql.cx.update}}"/>
                    <marshal id="marshal">
                        <csv delimiter="|">
                            <header>person_id</header>
                            <header>first_name</header>
                            <header>last_name</header>
                            <header>email_address</header>
                            <header>collar_number</header>
                            <header>user_id</header>
                            <header>ex_employee</header>
                            <header>post_rank</header>
                            <header>job_title</header>
                        </csv>
                    </marshal>
                    <to id="to_local_file" uri="{{local.generated.file.path}}?fileName=cx_export.csv.${date:now:yyyy-MM-dd-HHmmss}&amp;tempPrefix=."/>
                      </route>
        
      • Now switch to Design tab and than back to Source tab.
      • We see extra option header added to <csv .../> tag. Check screen-shot step_3.png file.
              <marshal id="marshal">
                        <csv delimiter="|" header="[person_id, first_name, last_name, email_address, collar_number, user_id, ex_employee, post_rank, job_title]">
                            <header>person_id</header>
                            <header>first_name</header>
                            <header>last_name</header>
                            <header>email_address</header>
                            <header>collar_number</header>
                            <header>user_id</header>
                            <header>ex_employee</header>
                            <header>post_rank</header>
                            <header>job_title</header>
                        </csv>
                    </marshal>
        
      • Also Source tab point it as a invalid statement.
      • Screenshot attached.
      Show
      Create a JBoss Fuse project with blueprint template. Delete existing route from the blueprint.xml using Source tab. Paste following route in Source tab. <route id= "extract-route" > <from id= "cron" uri= "{{extract.schedule}}" /> <transacted id= "_transacted" ref= "PROPAGATION_REQUIRED" /> <log id= "log_start" message= "Firing db call" /> <to id= "to_select" uri= "sql:classpath:cx_extract_combined.sql" /> <to id= "to_update" uri= "sql:{{sql.cx.update}}" /> <marshal id= "marshal" > <csv delimiter= "|" > <header>person_id</header> <header>first_name</header> <header>last_name</header> <header>email_address</header> <header>collar_number</header> <header>user_id</header> <header>ex_employee</header> <header>post_rank</header> <header>job_title</header> </csv> </marshal> <to id= "to_local_file" uri= "{{local.generated.file.path}}?fileName=cx_export.csv.${date:now:yyyy-MM-dd-HHmmss}&amp;tempPrefix=." /> </route> Now switch to Design tab and than back to Source tab. We see extra option header added to <csv .../> tag. Check screen-shot step_3.png file. <marshal id= "marshal" > <csv delimiter= "|" header= "[person_id, first_name, last_name, email_address, collar_number, user_id, ex_employee, post_rank, job_title]" > <header>person_id</header> <header>first_name</header> <header>last_name</header> <header>email_address</header> <header>collar_number</header> <header>user_id</header> <header>ex_employee</header> <header>post_rank</header> <header>job_title</header> </csv> </marshal> Also Source tab point it as a invalid statement. Screenshot attached.

    Attachments

      1. step_1.png
        step_1.png
        218 kB
      2. step_2.png
        step_2.png
        157 kB
      3. step_3.png
        step_3.png
        236 kB

      Issue Links

        Activity

          People

            apupier@redhat.com Aurélien Pupier
            rhn-support-cpandey Chandra Shekhar Pandey (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            5 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved: