|
Home > Archive > BizTalk Server > April 2004 > Biztalk 2004 CSV file parsing
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Biztalk 2004 CSV file parsing
|
|
| zebra 2004-04-12, 11:52 am |
| I am trying to create a schema to import a CSV file I generated using
Excel.
When I test the map I get the following XML file:
<ns0:Root xmlns:ns0="http://Circles.NamesOut">
- <Person>
<ID>1</ID>
<FirstName>ted</FirstName>
<LastName>Jones</LastName>
<Address1>1 any street</Address1>
<Address2>Apt 2</Address2>
<PhoneNumber>555-1212 2</PhoneNumber>
</Person>
</ns0:Root>
The source file is:
1,ted,jones,1 any street,Apt 2,555-1212
2,Ted,davis,2 any street,suite 344,667-9090
It picks up the 2 on the second line as part of the PhoneNumber so it
appears the Repeating Delimiter is not working.
I set it to Type hex with a value of 0x0D0A which looks correct when I
open the file with a hex editor. Am I missing something?
Thanks
| |
|
| zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404120644.35b64b9e@posting.google.com>...
> I am trying to create a schema to import a CSV file I generated using
> Excel.
>
> When I test the map I get the following XML file:
> <ns0:Root xmlns:ns0="http://Circles.NamesOut">
> - <Person>
> <ID>1</ID>
> <FirstName>ted</FirstName>
> <LastName>Jones</LastName>
> <Address1>1 any street</Address1>
> <Address2>Apt 2</Address2>
> <PhoneNumber>555-1212 2</PhoneNumber>
> </Person>
> </ns0:Root>
>
> The source file is:
> 1,ted,jones,1 any street,Apt 2,555-1212
> 2,Ted,davis,2 any street,suite 344,667-9090
>
> It picks up the 2 on the second line as part of the PhoneNumber so it
> appears the Repeating Delimiter is not working.
>
> I set it to Type hex with a value of 0x0D0A which looks correct when I
> open the file with a hex editor. Am I missing something?
>
>
> Thanks
Try chaning the delimiter to 0x0D 0x0A with a delimiter type of Hexadecimal.
| |
| zebra 2004-04-13, 10:05 am |
| dshamrick@earthlink.net (DonH) wrote in message news:<43b18ab7.0404121040.15bed436@posting.google.com>...
> zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404120644.35b64b9e@posting.google.com>...
>
> Try chaning the delimiter to 0x0D 0x0A with a delimiter type of Hexadecimal.
This helped but only the first line of the CSV file is being processed.
My schema looks like this:
<Schema>
----- People (Child delimiter set to 0x0D 0x0A) (PostFix)
------------ person (Child delimiter set to , (Infix))
-------------------ID
-------------------First
-------------------Last
------------------- (rest of fields)
I want each row of the CSV file to become a person record in the XML file.
Thanks
| |
|
| zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404130553.54c804a1@posting.google.com>...
> dshamrick@earthlink.net (DonH) wrote in message news:<43b18ab7.0404121040.15bed436@posting.google.com>...
>
> This helped but only the first line of the CSV file is being processed.
>
> My schema looks like this:
>
> <Schema>
> ----- People (Child delimiter set to 0x0D 0x0A) (PostFix)
> ------------ person (Child delimiter set to , (Infix))
> -------------------ID
> -------------------First
> -------------------Last
> ------------------- (rest of fields)
>
> I want each row of the CSV file to become a person record in the XML file.
>
> Thanks
There are a couple of setting that probably need adjusting. First
Check that you schema Editor extension property is set to Flat File
Extension.
Next, your Person record should have the max and min occurs
properties set properly. You want Max Occurs to be "Unbounded" Enter
* and that will take care of that, next your min occurs property
should be 1
| |
|
| Tank you,
The max and min occurs properties did the trick.
dshamrick@earthlink.net (DonH) wrote in message news:<43b18ab7.0404140455.52adee61@posting.google.com>...
> zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404130553.54c804a1@posting.google.com>...
>
> There are a couple of setting that probably need adjusting. First
> Check that you schema Editor extension property is set to Flat File
> Extension.
>
> Next, your Person record should have the max and min occurs
> properties set properly. You want Max Occurs to be "Unbounded" Enter
> * and that will take care of that, next your min occurs property
> should be 1
|
|
|
|
|