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

[ Post a follow-up to this message ]

zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404120644.35b64b9e@posting.g
oogle.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.

[ Post a follow-up to this message ]

dshamrick@earthlink.net (DonH) wrote in message news:<43b18ab7.0404121040.15bed436@posting.
google.com>...
> zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404120644.3
5b64b9e@posting.google.com>... 
>
> Try chaning the delimiter to 0x0D 0x0A with a delimiter type of Hexadecimal.[/colo
r]

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

[ Post a follow-up to this message ]

zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404130553.54c804a1@posting.g
oogle.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

[ Post a follow-up to this message ]

Tank you,

The max and min occurs properties did the trick.


dshamrick@earthlink.net (DonH) wrote in message news:<43b18ab7.0404140455.52adee61@posting.g
oogle.com>...
> zebra1024@hotmail.com (zebra) wrote in message news:<51c7f1fe.0404130553.5
4c804a1@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

[ Post a follow-up to this message ]