Using the XML.TODB tool

Hey List,

Having a small problem with using the U2 XML.TODB command. We are
currently using the Database.TOXML command to dump our information to an xml
file using the U2 XML/Database Mapping Tool for file mappings and works like
a charm. The issue I'm having is bringing back that info from an .xml
file - it's bringing back additional attributes we didn't dump. For
example , it the U2 record contains 15 attributes and and the record
map contains 20, XML.TODB is bringing back all 20 attributes into the
U2 record (an additional 5 attributes). Also, if there is an
association tied to any MV attribute then XML.TODB is bringing back
associated delimters.

Has anyone experienced this and if so, other than writing code to
handle, how did you correct this?

Thanks!!

On Aug 18, 10:44*am, ranman wrote:
> Hey List,
>
> Having a small problem with using the U2 XML.TODB command. *We are
> currently using the Database.TOXML command to dump our information to an xml
> file using the U2 XML/Database Mapping Tool for file mappings and works like
> a charm. *The issue I'm having is bringing back that info from an .xml
> file - it's bringing back additional attributes we didn't dump. *For
> example , it the U2 record contains 15 attributes and and the record
> map contains 20, XML.TODB is bringing back all 20 attributes into the
> U2 record (an additional 5 attributes). *Also, if there is an
> association tied to any MV attribute then XML.TODB is bringing back
> associated delimters.
>
> Has anyone experienced this and if so, other than writing code to
> handle, how did you correct this?
>
> Thanks!!

Wha are you using to pull the XML back out to a file with?

I use MVbase and VIA to pull back out into specific files, but I
notice if I ask for all attributes I get some "BS" attributes, but if
I ask for all fields indiviually then I have no problem

On Aug 18, 5:00*pm, spa...@jitservices.com wrote:
> On Aug 18, 10:44*am, ranman wrote:
>
>
>
>
>
> > Hey List,
>
> > Having a small problem with using the U2 XML.TODB command. *We are
> > currently using the Database.TOXML command to dump our information to an xml
> > file using the U2 XML/Database Mapping Tool for file mappings and works like
> > a charm. *The issue I'm having is bringing back that info from an .xml
> > file - it's bringing back additional attributes we didn't dump. *For
> > example , it the U2 record contains 15 attributes and and the record
> > map contains 20, XML.TODB is bringing back all 20 attributes into the
> > U2 record (an additional 5 attributes). *Also, if there is an
> > association tied to any MV attribute then XML.TODB is bringing back
> > associated delimters.
>
> > Has anyone experienced this and if so, other than writing code to
> > handle, how did you correct this?
>
> > Thanks!!
>
> Wha are you using to pull the XML back out to a file with?
>
> I use MVbase and VIA to pull back out into specific files, but I
> notice if I ask for all attributes I get some "BS" attributes, but if
> I ask for all fields indiviually then I have no problem- Hide quoted text-
>
> - Show quoted text -

Good Question,

yes I'm using the the XML.TODB command to do this and yes I'm getting
the same thing. I think I'll probably have to write a utility to
replace the command I'm using, scan for the necessary data I should be
getting and call it a day. It's a pain to be sure...

On Aug 19, 2:52 pm, ranman wrote:
> On Aug 18, 5:00 pm, spa...@jitservices.com wrote:
>
>
>
> > On Aug 18, 10:44 am, ranman wrote:
>
> > > Hey List,
>
> > > Having a small problem with using the U2 XML.TODB command. We are
> > > currently using the Database.TOXML command to dump our information to an xml
> > > file using the U2 XML/Database Mapping Tool for file mappings and works like
> > > a charm. The issue I'm having is bringing back that info from an .xml
> > > file - it's bringing back additional attributes we didn't dump. For
> > > example , it the U2 record contains 15 attributes and and the record
> > > map contains 20, XML.TODB is bringing back all 20 attributes into the
> > > U2 record (an additional 5 attributes). Also, if there is an
> > > association tied to any MV attribute then XML.TODB is bringing back
> > > associated delimters.
>
> > > Has anyone experienced this and if so, other than writing code to
> > > handle, how did you correct this?
>
> > > Thanks!!
>
> > Wha are you using to pull the XML back out to a file with?
>
> > I use MVbase and VIA to pull back out into specific files, but I
> > notice if I ask for all attributes I get some "BS" attributes, but if
> > I ask for all fields indiviually then I have no problem- Hide quoted text -
>
> > - Show quoted text -
>
> Good Question,
>
> yes I'm using the the XML.TODB command to do this and yes I'm getting
> the same thing. I think I'll probably have to write a utility to
> replace the command I'm using, scan for the necessary data I should be
> getting and call it a day. It's a pain to be sure...


Just set the fields that you want to bring back in your EXT file. It
will then ignore the rest