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
massimport?
Author Message
DVD Profiler Unlimited Registrantzwerg84
Registered: January 9, 2011
Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi

We have a csv list with DVD title and a note. Can i import all this movies with the note, or must i insert movie for movie?

With BulkEdit i don't have found a way.

Great

Oliver
 Last edited: by zwerg84
DVD Profiler Unlimited Registrantzwerg84
Registered: January 9, 2011
Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi

Sorry for the double post. But givs a way, or must i entry dvd for dvd from the older list where i have only the name and a note?

Great

Oliver
DVD Profiler Unlimited RegistrantStar Contributordee1959jay
Registered: March 19, 2007
Reputation: Highest Rating
Netherlands Posts: 6,018
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Check out this thread.
DVD Profiler Unlimited RegistrantStar ContributorMithi
Sushi Annihilator
Registered: March 13, 2007
Reputation: Superior Rating
Germany Posts: 2,217
Posted:
PM this userEmail this userVisit this user's homepageView this user's DVD collectionDirect link to this postReply with quote
Quoting zwerg84:
Quote:
We have a csv list with DVD title and a note. Can i import all this movies with the note, or must i insert movie for movie?

First major problem: Profiler works with UPC/EAN, not titles. So if your list say "Terminator" it surely would be possible to work it somehow so you get one DVD of this movie into your collection, the chance that it is the DVD you actually own is quite slim.

How many titles and what kind of note are we talking about here?
Maybe it would be the best way to first enter all your DVDs by UPC/EAN in to profiler. Then make a XML-Export of this data and try to work in the notes, or rather send the XML and those notes to me so I can have a look at it.

Quote:
With BulkEdit i don't have found a way.

BulkEdit can import the XML-Export of DVD Profiler itself, and some known formats of different Movie inventory programs. So a list of UPCs and Notes must be converted to this format first, that would be an rather easy task for me, but as I said: without the proper UPC/EAN you will get into problems later.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited Registrantzwerg84
Registered: January 9, 2011
Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi

Ok thank you. Its 600 movies. than i woud like to inset movie to movie.

Great

Oliver
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
Hey Mithi, you continue to be my good partner in helping people. Thank you.

Here are some ideas:

(1) Mithi can use XSLT to create a file like this from your delimited text file:

<?xml version="1.0" encoding="windows-1252"?>
<!--DVD Profiler Collection Export-->
<Collection>
  <DVD>
    <ID>M5555555555</ID>
    <MediaTypes>
      <DVD>true</DVD>
      <HDDVD>false</HDDVD>
      <BluRay>false</BluRay>
    </MediaTypes>
    <CollectionType>Owned</CollectionType>
    <Title>Title 1</Title>
    <Notes>This is notes for title 1</Notes>
  </DVD>
  <DVD>
    <ID>M5555555556</ID>
    <MediaTypes>
      <DVD>true</DVD>
      <HDDVD>false</HDDVD>
      <BluRay>false</BluRay>
    </MediaTypes>
    <CollectionType>Owned</CollectionType>
    <Title>Title 2</Title>
    <Notes>This is notes for title 2</Notes>
  </DVD>
</Collection>

The IDs can be any set of unique profile ids. This will create manual profile that you can change the UPC on later. You can even append locaility if you want, such as M1234567.4.

Alternatively, you can use the <UPC></UPC> element. You can add any other Profiler fields if you want to include that data, such as Purchase date, etc.

Then BulkEdit will import it and create the manual profiles for you, preserving the notes.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Desktop and Mobile Registrantmediadogg
Aim high. Ride the wind.
Registered: March 18, 2007
Reputation: Highest Rating
United States Posts: 6,463
Posted:
PM this userVisit this user's homepageDirect link to this postReply with quote
My browser gets crazy for long posts, so here is the remainder. In the previous post of course you can set the Collection and MediaType as desired. All 3.7.1 fields should be available. If not, please post a bug report.

(2) Temporarily go back to Profiler 3.5 and use an old copy of BulkEdit to import the CSV, then export the XML or create a database backup, then go back to 3.7.1. I will post the old copy of BE on my website later today.

(3) I have an update to BE coming soon. I will restore basic CSV (DVDSpot, and Profiler 2.4 ) which is adequate for your needs. The 3.6 / 3.7 code is being reworked and is still incomplete. I need to study Mark's CSV Export Plugin results for 3.7.1 first, because that is my goal - to be able to load whatever that one spits out.

Let us know what you want to do, and how it goes.

By the way, I have been experimenting with a bulk title import that automatically makes an intelligent guess on the UPC/EAN, but it is not ready yet.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
    Invelos Forums->DVD Profiler: Desktop Technical Support Page: 1  Previous   Next