Welcome to the Invelos forums. Please read the forum rules before posting.

Read access to our public forums is open to everyone. To post messages, a free registration is required.

If you have an Invelos account, sign in to post.

    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next
Help with XML export
Author Message
DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
I'm new to working with XML data.  When I try to import the XML file created by DVDProfiler into MS Access XP it creates separate tables for the diffent types of data (ie. DVD, AudioTrack, Format, Features, etc) which is great.  But there is no primary key (such as the UPC or ID) in each of the tables to be able to link the tables (ie. linking which AudioTrack(s) go with with DVD), so except for the DVD table the rest is pretty much unusable.  Any ideas or suggestions?
DVD Profiler Unlimited RegistrantStar ContributorTomGaines
Registered Sept. 24, 2001
Registered: March 13, 2007
Reputation: High Rating
Germany Posts: 2,005
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
You could try my Cinematic Collection Viewer. It can import the Profiler XML and the result is a Access database which you can use for your needs.
Or you can use the CCViewer's SQL Query window for custom queries.


DVD Profiler Unlimited RegistrantScaryBear
Registered: June 29, 2007
Posts: 30
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Thanks Tom, CCV is awesome, seems to have worked perfectly .  It appears you decided to go with building your own import process, which always seems to be the way to go with MS products   Thanks again.
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next