Author Topic: Playlist in printable format  (Read 765 times)

0 Members and 1 Guest are viewing this topic.

Offline andorra

Playlist in printable format
« on: January 18, 2020, 10:47:12 AM »
I'd like my playlists to excel or txt file convert, if it possible was...
« Last Edit: January 18, 2020, 11:08:42 AM by andorra »
PSR-SX700
 

Offline Fred Smith

Re: Playlist in printable format
« Reply #1 on: January 18, 2020, 11:31:50 AM »
I'd like my playlists to excel or txt file convert, if it possible was...

No problem. Itís a TSV (tab separated value) file. Just open it in Excel.

Cheers,
Fred
Fred Smith,
Saskatoon, SK
Sun Lakes, AZ
Genos, Bose L1 compacts, Finale 2015
Check out my Registration Lessons
 
The following users thanked this post: andorra

Offline andorra

Re: Playlist in printable format
« Reply #2 on: January 18, 2020, 12:56:46 PM »
Thank You, really.  It's good, but the style and OTS informations are missing.
PSR-SX700
 

Offline Fred Smith

Re: Playlist in printable format
« Reply #3 on: January 18, 2020, 03:26:31 PM »
Thank You, really.  It's good, but the style and OTS informations are missing.

That's because that information is in the registration, not the playlist.

Cheers,
Fred
Fred Smith,
Saskatoon, SK
Sun Lakes, AZ
Genos, Bose L1 compacts, Finale 2015
Check out my Registration Lessons
 
The following users thanked this post: andorra

Offline andorra

Re: Playlist in printable format
« Reply #4 on: January 18, 2020, 04:30:46 PM »
That's right.  ;)
Could I make a list in Excel format about the 2000 registers?
« Last Edit: January 18, 2020, 04:39:23 PM by andorra »
PSR-SX700
 

Offline tyrosaurus

Re: Playlist in printable format
« Reply #5 on: January 18, 2020, 06:49:19 PM »
You can try the 'Reports' function in Murray Best's 'Yamaha Registration Manager' program (for PC), which produces a tab delimited .txt file containing details of the individual registration in all banks within a specified folder.

You can then open this file in Excel or other spreadsheet and edit it as required.

The program does not read the .tsv Play List files, so the report won't be able to associate the registration details with a Play List entry, but you should be able to do that manually if you really want to put the effort in!

Murray has not yet released a fully modified version of the program for the latest keyboards, but he has released a 'special' version meanwhile, which allows you to use the program with the SX models and Genos V2.

There is a link to download it in this forum post...   https://www.psrtutorial.com/forum/index.php/topic,53618.msg417951.html#msg417951   

You can get a PDF of the user manual from the bottom of the page at this link... https://psrtutorial.com/util/best.html

Information about the Report Generator function starts on page 57.


Regards

Ian

 
The following users thanked this post: Dave Shively

Offline murrayb

Re: Playlist in printable format
« Reply #6 on: January 18, 2020, 09:20:00 PM »
Ian:

I did a test with the Report writer on the Genos Playlist, and the Registration Bank Names are identical to the Playlist entry names so it would be very easy to relate them. 

Although the report function will tell one the actual voices settings for each registration bank/button, there is nothing that will list the available OTS voices for each style / variation in those registrations.

However, within YRM if one edits a button in any of the Playlist registration banks, and clicks the option "View OTS", all the voices available for the style in the registration button will be shown for each variation.

I haven't created a way to list that stuff as yet, but maybe that's a new idea for the future.

Cheers,

Murray

One can do without most things, but not without the pleasure of music.

Check out my Registration Manager at:  http://psrtutorial.com/util/best.html
 
The following users thanked this post: andorra

Offline rcpilot

Re: Playlist in printable format
« Reply #7 on: January 19, 2020, 01:05:24 AM »
I installed the pgm, ran a report, and got the txt file. When I import it to spreadsheet it is not formatted or columns lined up or anything...just looks like txt...I must need to do something else?
Thanks,
Lee
Yamaha SX-900, used to play Thomas and Yamaha Organ's
 
The following users thanked this post: andorra

Offline tyrosaurus

Re: Playlist in printable format
« Reply #8 on: January 19, 2020, 01:17:08 PM »
Hi Lee,

When you try to open the .txt report in Excel, the 'Text Import Wizard' should pop up.

In the Wizard, set:  Original data type = 'Delimited',  Start import at row  = 2 , and Delimiters = 'Tab'.

Click 'Finish' and the sheet should open with the records correctly split into columns (fields).

You will need to adjust the width of each column to suit the data in it.


Regards

Ian
 

Offline rcpilot

Re: Playlist in printable format
« Reply #9 on: January 19, 2020, 02:59:14 PM »
Ian, OK, got it working, I use Open Office, and I had to do it a little different as wizard does not pop up, you have to use insert into a blank spreadsheet...but it worked perfectly. Do you miss working for Yamaha on the island?? What are you playing now?
Lee
Yamaha SX-900, used to play Thomas and Yamaha Organ's