Flat file empty space question

Home Page › Forums › BizTalk 2004 – BizTalk 2010 › Flat file empty space question

Viewing 1 reply thread
  • Author
    Posts
    • March 19, 2009 at 3:45 PM #21935
      community-content

        hey guru’s,

        I’m trying to figure out how to create empty spaces with commas, i.e. “, ,” in a csv formated flat file through my schema and map. So far for empty fields I have commas with no spaces, i.e. “,,”. I have played around with some of the mapping settings and set the Value property to <empty> as well as setting the pad character property to “default pad character”, however, my output flatfile .csv always seems to be without spaces. The xml also produces empty elements, i.e. “<Remittance_Msg />”

        Here’s a sample of the output that I’m looking for:

        PRQT,104681, ,914686088-125020,05/29/07,0,VAN, ,BUSE,INVC, , ,NETCASH,CAD,0,0,0,47992.21,05/31/07, , ,N, , , , , , , , ,1, , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , , ,

        Another twist is that after the last semicolon there is a {CRLF} directly after the comma with no space, is this possible?

        Can anyone help me out with setting the xsd properties or the mapping file properties?Please let me know if your looking for additional information.

        thanks!

        E

      • March 20, 2009 at 9:45 AM #21939
        community-content

          Have you tried setting the default value of your destination schema fields at the mapper file??

           

           

          • March 20, 2009 at 10:26 AM #21940
            community-content

              hey there,

              Thanks for replying.

              ya, I set the default values to ” ” in the xsd and then set the value property in the General section of the mapper file to be ” “. When I try to test the map the output elements are closed tags, like “<Remittance_Msg />”. Should I attempt to deploy this and see if that makes a difference? Is there something that I’m missing?

              thanks again.

              Eric

              • March 20, 2009 at 11:44 AM #21942
                community-content

                  ok I resolved this.. Apparently the empty element doesn’t matter and the flat file assembler will honor the default value. Hey now that we’re on teh subject, is there a way to test pipelines/assemblers without having to deploy to a test application? I find it time consuming to remap my pipelines to my schema and then have to update the build numbers.. perhaps I’m doing something wrong? thanks again.

          • Author
            Posts
          Viewing 1 reply thread
          • The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.