It is currently 12 Dec 2019, 14:20




 Page 1 of 1 [ 8 posts ] 
Author Message
 Post subject: The possibility to select data fields in the export.
PostPosted: 28 Dec 2018, 12:36 
Shows curiousity
Shows curiousity
User avatar

Joined: 18 May 2018, 12:08
Posts: 31
Location: Sweden
Has thanked: 9 times
Been thanked: 1 time
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.
_________________
HLD X9
CLD D925
CLD D504
CLD 950
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 28 Dec 2018, 14:44 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 2593
Location: Tokyo
Has thanked: 87 times
Been thanked: 186 times
Hello!

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

Julien
_________________
LDDb on Facebook!
HLD-X9 | LG-1 | RFD-1 | MSC-4000 | Lumagen 2144
DHS-8.8 | Oppo 205 | SL-1200G
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 28 Dec 2018, 16:49 
Shows curiousity
Shows curiousity
User avatar

Joined: 18 May 2018, 12:08
Posts: 31
Location: Sweden
Has thanked: 9 times
Been thanked: 1 time
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 :)
_________________
HLD X9
CLD D925
CLD D504
CLD 950
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 22 Jan 2019, 20:41 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 680
Location: NH, United States
Has thanked: 3 times
Been thanked: 10 times
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.
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 22 Jan 2019, 23:19 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 2593
Location: Tokyo
Has thanked: 87 times
Been thanked: 186 times
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
_________________
LDDb on Facebook!
HLD-X9 | LG-1 | RFD-1 | MSC-4000 | Lumagen 2144
DHS-8.8 | Oppo 205 | SL-1200G
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 22 Jan 2019, 23:29 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 680
Location: NH, United States
Has thanked: 3 times
Been thanked: 10 times
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.
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 28 Jun 2019, 10:29 
Third post and above
Third post and above
User avatar

Joined: 25 Jun 2019, 22:52
Posts: 3
Location: United States
Has thanked: 0 time
Been thanked: 0 time
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.
Offline
 Profile  
 
 Post subject: Re: The possibility to select data fields in the export.
PostPosted: 01 Jul 2019, 16:47 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 2593
Location: Tokyo
Has thanked: 87 times
Been thanked: 186 times
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
_________________
LDDb on Facebook!
HLD-X9 | LG-1 | RFD-1 | MSC-4000 | Lumagen 2144
DHS-8.8 | Oppo 205 | SL-1200G
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 8 posts ] 


Who is online

Users browsing this forum: No registered users and 1 guest


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to: