This forum has been archived. All content is frozen. Please use KDE Discuss instead.

Update music with barcode

Tags: None
(comma "," separated)
mrhappy
Registered Member
Posts
9
Karma
0

Update music with barcode

Mon Oct 26, 2020 7:50 pm
I recntly switched from Windows to Arch so I needed a replacement for Collectorz Music and found this.
Looks pretty good, but I would like to be able to import my export from Collectorz.
It worked for only the basic information.
Is it possible to have the albums updated with data from Discogs (I have an api-key) based on the barcode?
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Tue Oct 27, 2020 1:06 pm
mrhappy wrote:I recently switched from Windows to Arch so I needed a replacement for Collectorz Music and found this.
Looks pretty good, but I would like to be able to import my export from Collectorz.
It worked for only the basic information.

What kind of import did you do, with a CSV file? Or XML? I improved the XML import for the next release of Tellico. If you download the collectorz2tellico.xsl file from https://invent.kde.org/office/tellico/-/raw/master/xslt/collectorz2tellico.xsl, you could "Import XSL Transform..." with your current version. That might help you.

mrhappy wrote:Is it possible to have the albums updated with data from Discogs (I have an api-key) based on the barcode?

Tellico doesn't support barcode searches at the moment. I can check into adding that.
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Tue Oct 27, 2020 2:22 pm
robbystephenson wrote:
mrhappy wrote:I recently switched from Windows to Arch so I needed a replacement for Collectorz Music and found this.
Looks pretty good, but I would like to be able to import my export from Collectorz.
It worked for only the basic information.

What kind of import did you do, with a CSV file? Or XML? I improved the XML import for the next release of Tellico. If you download the collectorz2tellico.xsl file from https://invent.kde.org/office/tellico/-/raw/master/xslt/collectorz2tellico.xsl, you could "Import XSL Transform..." with your current version. That might help you.


Awesome, that looks a lot better...
Any tips how I can 'automatically' can get the cover images in it too?

robbystephenson wrote:
mrhappy wrote:Is it possible to have the albums updated with data from Discogs (I have an api-key) based on the barcode?

Tellico doesn't support barcode searches at the moment. I can check into adding that.

That would be great :)

How can I alter the xsl so I can import other values as well.
I.e.
Code: Select all
  <length>53:43</length>
  <lengthsecs>3223</lengthsecs>
  <nrtracks>12</nrtracks>   
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Wed Oct 28, 2020 1:25 am
mrhappy wrote:
robbystephenson wrote:
mrhappy wrote:I recently switched from Windows to Arch so I needed a replacement for Collectorz Music and found this.
Looks pretty good, but I would like to be able to import my export from Collectorz.
It worked for only the basic information.

What kind of import did you do, with a CSV file? Or XML? I improved the XML import for the next release of Tellico. If you download the collectorz2tellico.xsl file from https://invent.kde.org/office/tellico/-/raw/master/xslt/collectorz2tellico.xsl, you could "Import XSL Transform..." with your current version. That might help you.


Awesome, that looks a lot better...
Any tips how I can 'automatically' can get the cover images in it too?

Tellico 3.4 will try to take care of the image import, too. With a basic XSL import, it's tougher and more dependent on the file structure. Where are the images stored relative to the imported file?
mrhappy wrote:How can I alter the xsl so I can import other values as well.
I.e.
Code: Select all
  <length>53:43</length>
  <lengthsecs>3223</lengthsecs>
  <nrtracks>12</nrtracks>   
If you want to email me your Collectorz XML file directly, I can see about modifying the XSL to account for any missing info. I only had one example file to go from, so more insight in that regard would be appreciated. robby at periapsis.org
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Wed Oct 28, 2020 7:48 am
robbystephenson wrote:
mrhappy wrote:
robbystephenson wrote:What kind of import did you do, with a CSV file? Or XML? I improved the XML import for the next release of Tellico. If you download the collectorz2tellico.xsl file from https://invent.kde.org/office/tellico/-/raw/master/xslt/collectorz2tellico.xsl, you could "Import XSL Transform..." with your current version. That might help you.


Awesome, that looks a lot better...
Any tips how I can 'automatically' can get the cover images in it too?

Tellico 3.4 will try to take care of the image import, too. With a basic XSL import, it's tougher and more dependent on the file structure. Where are the images stored relative to the imported file?

Unfortunately the images don't get exported with the xml, so they must be manually copied.
Maybe copying them manually to the same folder as the export (or a subfolder 'images' of the export-folder) would be easier?

robbystephenson wrote:
mrhappy wrote:How can I alter the xsl so I can import other values as well.
I.e.
Code: Select all
  <length>53:43</length>
  <lengthsecs>3223</lengthsecs>
  <nrtracks>12</nrtracks>   
If you want to email me your Collectorz XML file directly, I can see about modifying the XSL to account for any missing info. I only had one example file to go from, so more insight in that regard would be appreciated. robby at periapsis.org

The xml is on its way...
Thanks!
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Mon Nov 02, 2020 1:47 am
mrhappy wrote:
robbystephenson wrote:
mrhappy wrote:Is it possible to have the albums updated with data from Discogs (I have an api-key) based on the barcode?

Tellico doesn't support barcode searches at the moment. I can check into adding that.

That would be great :)

Tellico 3.4 will do a barcode search on Discogs for updates if there is a field named barcode.
https://invent.kde.org/office/tellico/- ... ec7b3be6bc
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Sat Jan 02, 2021 2:04 pm
robbystephenson wrote:Tellico 3.4 will do a barcode search on Discogs for updates if there is a field named barcode.
https://invent.kde.org/office/tellico/- ... ec7b3be6bc


It's been a while since I had time to tinker with my database some more...
Searching on barcode works fine, but is it possible to save the barcode along with the other data from Discogs?
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Sun Jan 03, 2021 8:51 pm
mrhappy wrote:
robbystephenson wrote:Tellico 3.4 will do a barcode search on Discogs for updates if there is a field named barcode.
https://invent.kde.org/office/tellico/- ... ec7b3be6bc


It's been a while since I had time to tinker with my database some more...
Searching on barcode works fine, but is it possible to save the barcode along with the other data from Discogs?

Sure, https://invent.kde.org/office/tellico/c ... 59022ffe1f
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Tue Jan 05, 2021 2:49 pm
robbystephenson wrote:
mrhappy wrote:
robbystephenson wrote:Tellico 3.4 will do a barcode search on Discogs for updates if there is a field named barcode.
https://invent.kde.org/office/tellico/- ... ec7b3be6bc


It's been a while since I had time to tinker with my database some more...
Searching on barcode works fine, but is it possible to save the barcode along with the other data from Discogs?

Sure, https://invent.kde.org/office/tellico/c ... 59022ffe1f

That's fast ;D
(When does this end up in a new build? :< )
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Wed Jan 06, 2021 2:02 am
mrhappy wrote:(When does this end up in a new build? :< )

I think I'll have version 3.4 ready in February.
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Sat Jan 16, 2021 2:09 pm
robbystephenson wrote:
mrhappy wrote:(When does this end up in a new build? :< )

I think I'll have version 3.4 ready in February.

Looking forward to it :)
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Sat Jan 30, 2021 6:04 pm
Copied the cover-files from a backup to the files-directory (which is in the same directory as the tellico-file.
when I remove the entire path of the cover-files from the collectorz-export-file (and leave only the filename) and import it using the xlst the images are not shown.

How can I fix that?
Does the xlst needs to be changed?
robbystephenson
KDE Developer
Posts
384
Karma
1
OS

Re: Update music with barcode

Sun Jan 31, 2021 8:39 pm
mrhappy wrote:Copied the cover-files from a backup to the files-directory (which is in the same directory as the tellico-file.
when I remove the entire path of the cover-files from the collectorz-export-file (and leave only the filename) and import it using the xlst the images are not shown.

How can I fix that?
Does the xlst needs to be changed?

Try replacing tc:coverstring by tc:cover in two places
mrhappy
Registered Member
Posts
9
Karma
0

Re: Update music with barcode

Mon Feb 01, 2021 2:12 pm
robbystephenson wrote:
mrhappy wrote:Copied the cover-files from a backup to the files-directory (which is in the same directory as the tellico-file.
when I remove the entire path of the cover-files from the collectorz-export-file (and leave only the filename) and import it using the xlst the images are not shown.

How can I fix that?
Does the xlst needs to be changed?

Try replacing tc:coverstring by tc:cover in two places

Awesome! Thanks!


Bookmarks



Who is online

Registered users: bartoloni, Bing [Bot], Google [Bot], Sogou [Bot], Yahoo [Bot]