• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Exporting files for CSV re-import
#1
In case you have edited lots of meta-data in MSP that you want to make available for other users or you want to remove a fakebook from your library and keep the meta-data for later  import of single songs from it or ...:
It is possible to create a CSV file out of MSP that can be used for CSV import later.
To do that go to "Settings - Generate Song List Format" and set the song list format to something like 
%TITLE%;%PAGE_ORDER%;%KEYS%;%ALBUMS%;%SOURCE_TYPES%;%COLLECTIONS%
The trick is to use a separator like ; that is valid for CSV import and to remove the blanks after the separator that MSP inserts automatically. Set "Show Setlist Title" to OFF.
(You might want to copy the songlist format line into a text  file to store several versions for different purposes)
Then create a setlist of the songs you want to include in your CSV file and export a setlist file via "Generate Song List". Save that song list into a file.
To make that file a valid CSV file for CSV import insert a title line that corresponds with the songlist format that you used. For the example above that would be
title;pages;keys;albums;sourcetypes;collections
and the CSV is ready to be used for CSV import and to be shared in the MSP forum - thank you in advance.
And here's my feature request for Mike:
Please let a copy of the song list format line be a valid and working title line for CSV import. If it is possible to just copy and paste the song list format into the exported file the process described above would be much easier and less error-prone.
first language: German
Acer A1-830, Android 4.4.2 - HP x2 210 G2 Detachable, Win 10 2004
www.moonlightcrisis.de - www.basdjo.de - www.frankenbaend.de


Reply


Messages In This Thread
Exporting files for CSV re-import - by itsme - 05-27-2016, 08:12 AM
RE: Exporting files for CSV re-import - by itsme - 06-15-2016, 08:04 AM
RE: Exporting files for CSV re-import - by itsme - 06-15-2016, 08:55 AM
RE: Exporting files for CSV re-import - by itsme - 06-15-2016, 08:58 AM
RE: Exporting files for CSV re-import - by itsme - 06-16-2016, 02:37 AM
RE: Exporting files for CSV re-import - by itsme - 06-16-2016, 05:39 AM
RE: Exporting files for CSV re-import - by itsme - 06-18-2016, 08:01 AM
RE: Exporting files for CSV re-import - by itsme - 06-18-2016, 04:16 PM
RE: Exporting files for CSV re-import - by itsme - 06-18-2016, 05:30 PM
RE: Exporting files for CSV re-import - by itsme - 01-27-2017, 09:34 AM
RE: Exporting files for CSV re-import - by itsme - 01-27-2017, 09:30 PM

Digg   Delicious   Reddit   Facebook   Twitter   StumbleUpon  


Users browsing this thread:
1 Guest(s)


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