Invelos Forums->DVD Profiler: Desktop Technical Support |
Page:
1 Previous Next
|
massimport? |
|
|
|
Author |
Message |
Registered: January 9, 2011 | Posts: 5 |
| Posted: | | | | 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 |
| Registered: January 9, 2011 | Posts: 5 |
| Posted: | | | | 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 |
| Registered: March 19, 2007 | Reputation: | Posts: 6,018 |
| | Registered: March 13, 2007 | Reputation: | Posts: 2,217 |
| Posted: | | | | 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 |
| Registered: January 9, 2011 | Posts: 5 |
| Posted: | | | | Hi
Ok thank you. Its 600 movies. than i woud like to inset movie to movie.
Great
Oliver |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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 |
| Registered: March 18, 2007 | Reputation: | Posts: 6,463 |
| Posted: | | | | 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
|
|