I miss the support from 'back in the day'.

There was a list of PAL scripts to grab that gave enough information to adapt to your needs, and hopefully learn a bit of coding. I don't know where that list went to.

I am looking for a PAL script that would go through your database and Capitalize the song titles and artists. I can't find that anywhere.

Any ideas?

It would be WAY faster to utilize a direct MYSQL update on the database, using phpMydmin or workbench, rather than using PAL. PAL would take forever, 1 second per iteration. I would not recommend using (PAL.LockExecution), as this could freeze your SAM while executing if you have a large number of tracks.

If you don't want your sweepers, station IDs etc affected use the where clause to limit the update to songtype ='S'



HIGHLY recommend backing up the database before attempting mass updates.

_________________
- Rob Oyler, SVS

I have over 2000 tracks. I am NOT using MySQL. I am using Firebird.

This is a DEMO setup and not online so time is not an issue.

I am importing about 600 new tracks from my personal music and it was not taken care of well in Title format. So I am trying to clean it up.

Would you suggest changing to MySQL? I have no problem saving the music category files and reimporting it.

I just am not real familiar with MySQL and wouldn't know which of the database options I need to start with. I can play with that as well.

Thanks for the response.

You can use Firebird as well, but you'll have to look up the SQL Syntax differences yourself and modify the SQL query to work with that.
The table structure is the same in every database, Firebird is just a lot harder to handle.


These days I'd recommend using MariaDB instead (which is a drop-in-replacement for MySQL) so you don't fall into a trap of buying anything from Oracle. They're making it harder every day to find the open source version of MySQL.


The backup option of SAM for Firebird is copying the firebird database file to a separate location. You can't import a Firebird database file into MySQL/MariaDB, though.

_________________
Benedikt Bauer - SVS (Spacial Volunteer Support)

Shop for readymade PAL scripts by countrywesterndj - Or get a custom script made by me (or others)

My Project:
Send "Now Playing" from SAM to Twitter and/or Facebook | Sourcecode