• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel spreadsheet to input library info
#1
I have a spreadsheet with all my songs and various data like that stored in the Library.  Is there anyway to quickly import all this info?

(I'm able to export a list that I can make into a spreadsheet which gave me the idea how nice it would be to go the other way.   The spreadsheet is easy to input, change lots of things, search and replace, etc, and sort by various parameters.)
Reply
#2
Unfortunately, no, there isn't a way to import data from a spreadsheet at the moment. This is something I will consider supporting in the future, although supporting excel files is very difficult and usually requires expensive third party libraries. I could support a simpler format like CSV though.

Mike
Reply
#3
(10-31-2020, 04:52 PM)Zubersoft Wrote: Unfortunately, no, there isn't a way to import data from a spreadsheet at the moment. This is something I will consider supporting in the future, although supporting excel files is very difficult and usually requires expensive third party libraries. I could support a simpler format like CSV though.

Mike
I believe that CSV import would actually be the best approach, not just because it is easier (quicker?)  to program, but because I believe it would be usable by more MobileSheets users.

CSV has the big advantage that it is not App specific (as an Excel import would be). Many apps have the ability to easily save or export to csv. It takes less than 30 seconds to save a copy of an Excel file in csv format! 

Peter Rollin
Reply
#4
CSV to/from Excel can be converted easily in both directions. The main limit of the currently existing CSV features are that every CSV file corresponds only to one single PDF file. CSV import is mainly intended to import PDF fakebooks.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#5
That's basically the nature of the change I would need to make - to support a different format for the CSV that allows each song in the CSV to be tied to a specific file instead of just one. I'm not sure if I'll just add a new required column to support this, or modify it so that you can specify a file before each group of songs, and until a new file is encountered in the file, all of those songs will use that same file. Having to specify the file on each line would be more "csv-like", but is extremely redundant if most of the songs are tied to just a few files.

Mike
Reply
#6
Thanks for considering this long standing request again.

I think a new column is the better way even if it can be redundant. As you said it's more csv-like and you can mix and sort the lines
and always see which one belongs to which pdf.
Reply
#7
Actually my original comment had to do with making a "fakebook" compliation where all my many cover songs have been in text format which converts to CSV when imported iinto Excel.    Thus if MS allowed using a CSV that would be perfect. 
    Both the free Libre Office or Open Office can convert back and forth from Excel,  CSV and open office format. 
    My wish is to have the CSV contain all the data for each song (columns) with one row for each song.
Reply
#8
Could that be of help? https://zubersoft.com/mobilesheets/forum...p?tid=5213
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 22H2 - Huawei Media Pad T5, Android 8.0 - Boox Tab Ultra C, Android 11
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply
#9
That is very helpful for songs already in MS.   I'm new to all this but learning fast.
    My main interest is to use a laptop generated CSV to enter all the metadata into the MS Library, i.e. import a ton of PDFs and text files and then fill the Library with all the connections, keys, titles, etc.   I'm a lot faster using a keyboard on a laptop than tapping on a tablet with rudimentary editing / sorting capabilities.
    For instance, the composer and artist on many of my covers is the same but I have to enter the name twice, once for each field.   It doesn't pull the name from one field to the other.   This is easy to do on a spreadsheet.
Reply
#10
Nope, read itsme's post again. The csv import *is* for getting new songs/PDF into MSP with your metadata from a spreadsheet. You have to adjust your format of course and you have to put some effort in it (believe me I know; i've spent hours to hone my library) but I'm pretty sure it's what you are looking for. It's a kind of batch import.

It's the other way round: It's not possible (or at least not in a convienient way) to populate existing songs in MSP with metadata from an external spreadsheet.
Reply
#11
Updating existing songs is something I'm going to have to add support for. I know several users have requested support for that.

Mike
Reply




Users browsing this thread:
1 Guest(s)


  Theme © 2014 iAndrew  
Powered By MyBB, © 2002-2024 MyBB Group.