DVDpedia - import to Credits tab

[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!)

[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]

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!

[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]

... 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!

[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.