DVDpedia - import to Credits tab

Any trouble you encounter with the Pedias, here's the place to ask for help.

DVDpedia - import to Credits tab

Postby drum365 » Sat Feb 03, 2018 4:53 pm

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!)
drum365
Junior Member
Junior Member
 
Posts: 3
Joined: Thu Dec 14, 2017 2:18 pm

Re: DVDpedia - import to Credits tab

Postby Conor » Sun Feb 04, 2018 3:05 pm

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)
User avatar
Conor
Top Dog
 
Posts: 4972
Joined: Sat Jul 03, 2004 12:58 pm

Re: DVDpedia - import to Credits tab

Postby drum365 » Sun Feb 04, 2018 4:12 pm

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!
drum365
Junior Member
Junior Member
 
Posts: 3
Joined: Thu Dec 14, 2017 2:18 pm

Re: DVDpedia - import to Credits tab

Postby Conor » Mon Feb 05, 2018 5:52 am

:) 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.
User avatar
Conor
Top Dog
 
Posts: 4972
Joined: Sat Jul 03, 2004 12:58 pm

Re: DVDpedia - import to Credits tab

Postby drum365 » Mon Feb 05, 2018 9:34 pm

... 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!
drum365
Junior Member
Junior Member
 
Posts: 3
Joined: Thu Dec 14, 2017 2:18 pm

Re: DVDpedia - import to Credits tab

Postby Conor » Thu Feb 08, 2018 7:41 am

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.
User avatar
Conor
Top Dog
 
Posts: 4972
Joined: Sat Jul 03, 2004 12:58 pm


Return to Support

cron