It is currently 18 Jun 2026, 14:46




 Page 1 of 1 [ 9 posts ] 
Author Message
 Post subject: More data fields in the collection list export function  Topic is solved
PostPosted: 04 Jun 2017, 03:49 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 743
Location: NH, United States
Has thanked: 5 times
Been thanked: 29 times
I think it's great that we can do exports of our collection but is there a way to designate more fields (or select the ones we want). I have almost 1700 movies in my collection and would like the ability to add some other fields, such as movie length to the exports. It would be extra great if we can select specific fields to include or exclude. I typically will manually delete some default exported fields such as country, video, etc. before printing a master list of my movies for a physical copy reference list.

Export is a great way to get a full list of the movies you own into a format that is easily printable in a spreadsheet program. However, it seems like a missed opportunity to not have access to all the data fields in the database. Thanks.
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 20 Jun 2017, 14:21 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 743
Location: NH, United States
Has thanked: 5 times
Been thanked: 29 times
I just also wanted to bring up an issue with the "CSV" export. The export file is kind of broken when there are titles where the prefix is sent to the end with a comma. For example, all the movies that are titled "The ..." are listed in the database as "..., The". When you go and try to import the CSV file, new entries are made for those comma's in the title. CSV export should have the option of removing these commas in the titles (or restore the title to their original versions).

Downloading the files in XML/XLS solves this issue I believe.
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 12 Jul 2018, 05:54 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 5351
Location: Tokyo
Has thanked: 431 times
Been thanked: 1756 times
invenio wrote:
When you go and try to import the CSV file, new entries are made for those comma's in the title. CSV export should have the option of removing these commas in the titles (or restore the title to their original versions).


The separator for this file is \t (tabulation).
Have you tried importing with tab instead of comma?
Maybe rename it from .csv to.tsv for Excel?

Example:

ID   Format   Reference   Title   Release   Video   Specs   Country   UPC   Condition   Notes   Date
11126   ld   356190   Cité des enfants perdus, La (1995)   1996   PAL   LBX/SRD   France   3388333561908   7


Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
MSD4 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 12 Jul 2018, 23:57 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 743
Location: NH, United States
Has thanked: 5 times
Been thanked: 29 times
Hi Julien

I think your knowledge of database information is way beyond mine. I was just pointing out that when you export the collection in csv and then open it up with a spreadsheet program, the commas in the titles mess up the output. I have attached the exported csv file as well as the csv file imported into Libreoffice Calc (I don't use MS Excel). The commas in the titles mess up the columns as you can see.

I can't upload the files as .csv and .ods are not allowed so I put them in a zip file if you want to see the original export and the import via Libreoffice.


Attachments:
2018-07-13_LDDb_Collection.zip [116.88 KiB]
Downloaded 223 times
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 16 Jul 2018, 07:52 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 5351
Location: Tokyo
Has thanked: 431 times
Been thanked: 1756 times
invenio wrote:
I have attached the exported csv file as well as the csv file imported into Libreoffice Calc (I don't use MS Excel). The commas in the titles mess up the columns as you can see.


I'm sure LibreOffice has an "import" module that lets you choose which delimiter is to be used like this?
Using tabs will make commas work as expected.

Attachment:
tab.jpg
tab.jpg [ 43.1 KiB | Viewed 4947 times ]


Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
MSD4 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 17 Jul 2018, 17:32 
Advanced fan
Advanced fan
User avatar

Joined: 21 Sep 2011, 15:15
Posts: 743
Location: NH, United States
Has thanked: 5 times
Been thanked: 29 times
Yes, Julien. You are correct. If I import them using the tab option it appears to work well. Thanks for the clarification.

Any chance that in the future we would be able to export more of database fields?
_________________
My Home Theater Gallery
Laserdisc Collection Storage
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 11 Dec 2024, 11:51 
Serious fan
Serious fan
User avatar

Joined: 13 Oct 2018, 12:06
Posts: 193
Location: Germany
Has thanked: 50 times
Been thanked: 46 times
Seems the starting question got kinda lost.

Any way to export additional fields. Besides Length, language and so on I'm currently also interested in the value. So including the selling prices would be nice. I think there is no way online to check for the most valuable discs.
Online
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 11 Dec 2024, 11:54 
Site Admin
Site Admin
User avatar

Joined: 07 Aug 2002, 23:37
Posts: 5351
Location: Tokyo
Has thanked: 431 times
Been thanked: 1756 times
That's not something I'd be inclined to do.

LDDb is centralizing up-to-date data online, a complete offline export is the exact opposite.

Julien
_________________
HARDWARE DATABASE
HLD-X0/9 LD-S9 OPPO 105/205 SL-1200G
MSD4 MSC-4000 R2144 PONTUS II C45 MC257
Offline
 Profile  
 
 Post subject: Re: More data fields in the collection list export function
PostPosted: 18 May 2026, 13:32 
Third post and above
Third post and above
User avatar

Joined: 26 Apr 2026, 13:08
Posts: 5
Location: Belgium
Has thanked: 0 time
Been thanked: 3 times
Hi Julien,

I completely understand your point about preventing full database scraping and keeping users connected to the platform.

However, could you please consider adding just one small text field to the quick export: the "Localized / Cover Title" (Titre de la pochette) ?

Here is why this would be a lifesaver for some of us:
*The "Flea Market" Problem: I am a French-speaking collector living in Europe. When I go hunting for LaserDiscs in local flea markets or media fairs, mobile network coverage (5G/4G) is very often terrible or non-existent.
*The Title Mismatch: The quick export currently only provides the original English/international title. But in my region, 90% of the PAL discs we find have local French titles on the cover, which are often completely different from the original English ones. Without a network signal, I cannot check LDDb or IMDb to find the English equivalent.
*Multi-format Confusion: I currently own around 300 LaserDiscs, but also more than 1,500 movies in other formats (DVD, Blu-ray, etc.). In the middle of a crowded flea market, it becomes very hard to remember if I already own a specific film, and more importantly, on which format or which specific cut.

Ideally, having the video format info (like Letterbox 2.35:1 vs Pan&Scan) in the export would be the absolute dream to help differentiate versions on the fly. But honestly, just having the local cover title would already be a massive help for offline inventory checks.

Since this is just basic metadata, it does not expose any heavy content (like chapters or audio bitrates), so it still protects the database while heavily helping local collectors on the field.

Thank you for considering this!

Vincent
Offline
 Profile  
 
Display posts from previous:  Sort by  
 Page 1 of 1 [ 9 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: