DVDpedia - import to Credits tab

Any trouble you encounter with the Pedias, here's the place to ask for help.
Post Reply
drum365
Junior Member
Junior Member
Posts: 4
Joined: Thu Dec 14, 2017 2:18 pm

DVDpedia - import to Credits tab

Post by drum365 »

I'm new to DVDpedia, and I'm stuck...

I have several collections of short films that don't have the individual shorts listed in the databases. For example: Cinema16 American Short Films contains 16 films but only lists George Lucas and Alexander Payne as commentators. I would like to either import or cut-and-paste the director and title into the "Credits" tab, with the director's name under "Name" and the film's title under "Role." Here are the first three films:

Adam Davidson - The Lunch Date (11 mins – 1990)
Peter Sollett - Five Feet High and Rising (29 mins – 1999)
George Lucas - Freiheit (3 mins – 1966)
...

I saw an old (2007) thread about pasting csv, comma-delimited, and semicolon-delimited fields into the Credits tab, but I can't make it work. The closest I've been able to get is to use semicolons and no spaces. Pasting this:

Adam Davidson;The Lunch Date (11 mins – 1990)
Peter Sollett;Five Feet High and Rising (29 mins – 1999)
George Lucas;Freiheit (3 mins – 1966)
...

gives me separate entries on each line, but the director, the semicolon, and the title all populate into the "Name" field, with nothing going over into the "Role" field.

Name___________________________________________|_Role____________________________
Adam Davidson;The Lunch Date (11 mins – 1990)
Peter Sollett;Five Feet High and Rising (29 mins – 1999)
George Lucas;Freiheit (3 mins – 1966)

Is there some way I can get the "title (running time - year)" over in the Role field?

Thanks (and thanks for a great program!)
User avatar
Conor
Top Dog
Posts: 5335
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: DVDpedia - import to Credits tab

Post by Conor »

Thank you so much for being so specific and clear in the description, I know exactly what you are looking for:

=

It was the safest character to use that would not mistakenly appear in someone's name or role. But yo duo bring up a good point that it should match the CSV import character, although that was picked on the fact that semi-colon is standard use in text imports files. In short replace your semi-colon with the equal sign.

Adam Davidson=The Lunch Date (11 mins – 1990)
Peter Sollett=Five Feet High and Rising (29 mins – 1999)
George Lucas=Freiheit (3 mins – 1966)
drum365
Junior Member
Junior Member
Posts: 4
Joined: Thu Dec 14, 2017 2:18 pm

Re: DVDpedia - import to Credits tab

Post by drum365 »

Yay - it worked! Thanks so much!

(But shouldn't this be in documentation or help or a FAQ or something? ... Or did I just miss it?)

Thanks for a great program and a quick response!
User avatar
Conor
Top Dog
Posts: 5335
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: DVDpedia - import to Credits tab

Post by Conor »

:) Great.

It should be, but small features get added and then never make it all the way to the documentation. We have to overhaul the help file to make it easier to amend and keep updated.
drum365
Junior Member
Junior Member
Posts: 4
Joined: Thu Dec 14, 2017 2:18 pm

Re: DVDpedia - import to Credits tab

Post by drum365 »

... well, I thought I had this all worked out...

When I have a title with a comma in it (e.g. What's Opera, Doc?) and I structure my list like this:

What's Opera, Doc?=Chuck Jones, dir.

When I import it, I end up with two lines, split at the comma:

Code: Select all

What's Opera
Doc?                   Chuck Jones, dir
I tried enclosing the title in quotes, as is standard in CSV files, and got:

Code: Select all

"What's Opera
Doc?"                   Chuck Jones, dir
Is there a way around this?

Thanks!
User avatar
Conor
Top Dog
Posts: 5335
Joined: Sat Jul 03, 2004 12:58 pm
Contact:

Re: DVDpedia - import to Credits tab

Post by Conor »

Thank you for the examples. Fixed in the DVDpedia beta.

If you have multiple lines, you nee not do anything. If you have a single line, you need to quote it.
Post Reply