It is currently 21 Jun 2019, 01:15




 Page 1 of 1 [ 6 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: 2349
Location: France
Has thanked: 79 times
Been thanked: 132 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!
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: 675
Location: NH, United States
Has thanked: 3 times
Been thanked: 9 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: 2349
Location: France
Has thanked: 79 times
Been thanked: 132 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!
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: 675
Location: NH, United States
Has thanked: 3 times
Been thanked: 9 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  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 6 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: