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->General: New Users Forum Page: 1  Previous   Next
Import XLS/CSV file
Author Message
DVD Profiler Unlimited Registrantalweb
Registered: April 21, 2011
Brazil Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Hi
How can I import a XLS/CSV file that was export by another application and contains sequencial, original movie name, actors, director, legth, distributor, classification, etc?
I try it with BulkEdit but it don't work.

Please, can any help me?

tks!

Alweb
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
You might want to take a look in 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 alweb:
Quote:
How can I import a XLS/CSV file that was export by another application and contains sequencial, original movie name, actors, director, legth, distributor, classification, etc?

Most important question: do you have the UPCs in that file?

Because DVD Profiler bases the profiles on those, without them you are pretty much scre... out of luck.
Everything else, like actors, running time etc. would then come from the main-database.
More interesting would be if you have personal data for each profile (date of purchase, place of purchase, date watched etc) which needs to be carried over.

If your answer is: "I have the UPCs and no personal data" then simply put the UPCs in a text-file, and in DVD Profiler go to: DVD -> Add to Collection -> Add by UPC -> Add Multiple and click the upper-left icon 'load UPC file'

Additional question: which locality are your DVDs from? If they are not US the locality might become a small obstacle, just give a holler if you need help.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited Registrantalweb
Registered: April 21, 2011
Brazil Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Mithi
Tks!
Really I don't have The UPCs in that file and I am from Brazil (23??).
Can I create a CSV file with  "randomic" UPCs and fix the other informations separated by ";"?
I have date of purchase but not place and others.
Basicaly the informations was: Movie Title, Original Title, Actors, Director, length, Productor, year, language, subtitles, format, classification, etc
On CSV file was a sequence that was the same on the label on DVD box...
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
Quoting alweb:
Quote:
Hi
How can I import a XLS/CSV file that was export by another application and contains sequencial, original movie name, actors, director, legth, distributor, classification, etc?
I try it with BulkEdit but it don't work.

Please, can any help me?

tks!

Alweb

Sorry it didn't work for you. Future versions will have some kind of Title search, but not yet - I am still working on that.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
DVD Profiler Unlimited Registrantalweb
Registered: April 21, 2011
Brazil Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Mediadogg

Tks!!!
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 alweb:
Quote:
Really I don't have The UPCs in that file

Then your are out of luck, sorry.
Quote:
Can I create a CSV file with  "randomic" UPCs

eh, no. The UPC is the primary key for a profile, so it has to be the right one, just try adding one DVD by UPC and you'll see.

Depending on how much DVDs you have it might be a good idea to get a barcode-scanner, that would make the mass entry a lot faster and more comfortable.

cya, Mithi
Mithi's little XSLT tinkering - the power of XML --- DVD-Profiler Mini-Wiki
DVD Profiler Unlimited Registrantalweb
Registered: April 21, 2011
Brazil Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Tks all....
Really it was a problem... but...
I have more or less 800 movie DVDs and 500 Divx/Games DVDs
I will esse what I can do!
Tks!
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
Quoting alweb:
Quote:
Tks all....
Really it was a problem... but...
I have more or less 800 movie DVDs and 500 Divx/Games DVDs
I will esse what I can do!
Tks!

If you want something (imperfect) to play with, PM me and I will respond with my email address. I can always use real examples of what people need. In return, I can send you a DVDP database that results from whatever I am able to do / not do. Meanwhile, I could add your sample data to the pool of test data that I use to make further improvements in the future. No pressure. No invasion of privacy inteneded, but if you are game, let me know.

It might be satisfying to see even an imperfect representation of your collection as a database. Then at your leisure, you can use a scanner to update the UPCs and all the good stuff from Invelos will blast down from the net. It will overwrite everything EXCEPT personal data such as purchase date, notes, etc. So it would be a waste of time to add movie data unless you find movies that are not yet in the Invelos database.

BTW, I am aware that this is likely more for my benefit. Using a scanner and the Invelos "Add multiple" feature, you can get your DVD collection set up quite quickly. This will also work for any Divx files that have a corresponding DVD. There is a place in the profile to store the location of the Divx file.

As for Games, that's another matter.
Thanks for your support.
Free Plugins available here.
Advanced plugins available here.
Hey, new product!!! BDPFrog.
 Last edited: by mediadogg
DVD Profiler Unlimited Registrantalweb
Registered: April 21, 2011
Brazil Posts: 5
Posted:
PM this userView this user's DVD collectionDirect link to this postReply with quote
Medidogg
Tks!!
No problem. I'm doing what I can!
This software is very god.
When I end it... I will generate a csv file from the dabase!
Tks!

Alweb
    Invelos Forums->General: New Users Forum Page: 1  Previous   Next