Re: Biztalk 2004 CSV file parsing

From: DonH (dshamrick_at_earthlink.net)
Date: 04/14/04 

Date: 14 Apr 2004 05:55:08 -0700

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>...
> > 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.
>
> 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

Relevant Pages

  • Re: Importing schema properties
    ... If the users already exist in the directory you cannot use csvde to update them. ... In that case a custom script will need to be written that loops through the CSV file and updates the appropriate attributes. ... OP will confuse folks by saying schema unless they are actually modifying the schema of a domain. ... What's the best way to import schema information that we have stored in a CSV file? ...
    (microsoft.public.win2000.active_directory)
  • Re: Validate a CSV file
    ... a SP into a clone of the target table (just schema). ... >validate against our database.I was thinking about loading that CSV file ... >into a Typed-Dataset which has our database schema in it and then try to ... > of those refferecing tables into my dataset as well? ...
    (microsoft.public.dotnet.framework.adonet)
  • RE: Validating a (wrong) message just succeeds
    ... bad csv file that reproducess the problem so that I can look into this. ... I'm running into validation problems with Biztalk 2004. ... not more than the one in the schema of course. ... the 9th field of the first record is simple ...
    (microsoft.public.biztalk.general)
  • Re: What is the logic of storing XML in a Database?
    ... proprietary schema format for flatfiles and sell a proprietary tool ... for validating a CSV file that conforms to the flat file. ... I thought XML was supposed to be used for transport? ...
    (comp.databases.theory)
  • Re: Strange schema behaviour
    ... I have a schema that defines some tables. ... Table1 say, has columns A, B, C, D and E ... which is a property of the Columns property of the Table they are in a ... I don't recall ever seeing this happen with a CSV file. ...
    (microsoft.public.dotnet.framework.adonet)