LaserDisc Database
https://forum.lddb.com/

The possibility to select data fields in the export.
https://forum.lddb.com/viewtopic.php?f=8&t=8189
Page 1 of 1

Author:  sethp3d [ 28 Dec 2018, 12:36 ]
Post subject:  The possibility to select data fields in the export.

Would it be possible to remove any given number of fields and just export what I select For instance I only need the Title/Year part
The reason I'm importing the titles to my Letterboxd account.

Author:  admin [ 28 Dec 2018, 14:44 ]
Post subject:  Re: The possibility to select data fields in the export.

Hello!

Maybe simply export in XLS-compatible format, open with Excel (or equivalent) and drop all the columns you don't need?

Julien

Author:  sethp3d [ 28 Dec 2018, 16:49 ]
Post subject:  Re: The possibility to select data fields in the export.

admin wrote:
Hello!

Maybe simply export in XLS-compatible format, open with Excel (or equivalent) and drop all the columns you don't need?

Julien


I did try that, but the result when I save from excel doesn't look like what I get when I export CSV. I'll have to work on my excel skills if not I'll do some manual cleaning of the CSV file I get from LDDB :)

Author:  invenio [ 22 Jan 2019, 20:41 ]
Post subject:  Re: The possibility to select data fields in the export.

I think I commented on exporting problems in the past but CSV export typically doesn't work because many of the titles have a comma in the movie titles and it messes up the import into the spreadsheet program. I don't know of any way to strip the extra commas out of the CSV export file.

Author:  admin [ 22 Jan 2019, 23:19 ]
Post subject:  Re: The possibility to select data fields in the export.

invenio wrote:
I think I commented on exporting problems in the past but CSV export typically doesn't work because many of the titles have a comma in the movie titles and it messes up the import into the spreadsheet program.


Unless I missed something I'm using semi-colon (;) for the ASCII export and TABS for the CSV (which becomes a TSV then...) to avoid this kind of problem. CSV will load as a garbled mix of text but if you select the first column then DATA => TEXT TO COLUMN => DELIMITED => TAB, then it will spread the column properly.

Julien

Author:  invenio [ 22 Jan 2019, 23:29 ]
Post subject:  Re: The possibility to select data fields in the export.

Perhaps it's fixed. This is the thread I was referring to: More data fields in the collection list export function

I believe if you use the tab separator it seems to work well. If you use comma's, I think the problem arises. It's been a while so maybe I'm not remembering it correctly? Maybe it's no longer an issue I just wanted to clarify for OP.

Author:  realpoo [ 28 Jun 2019, 10:29 ]
Post subject:  Re: The possibility to select data fields in the export.

Is a database dump of all titles available? I really hope the data outlives the site, and hopefully as more than just a bunch of web pages in the Internet Archive.

Author:  admin [ 01 Jul 2019, 16:47 ]
Post subject:  Re: The possibility to select data fields in the export.

realpoo wrote:
Is a database dump of all titles available? I really hope the data outlives the site, and hopefully as more than just a bunch of web pages in the Internet Archive.


I made the original online database dumps available again.
These are the extracts I used to start validating the first titles:

Laserviews
https://www.lddb.com/_misc/webarchive.org/laserdisc.list.definitiva.zip

Sight and Sound
https://www.lddb.com/_misc/webarchive.org/us.zip
https://www.lddb.com/_misc/webarchive.org/non-us.zip

Julien

Page 1 of 1 All times are UTC [ DST ]
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/