[dallaskruse]

I have 12 tablets. All with 700+ PDF charts on them. Each tablet has the same songs but different charts for those songs.

Drums
Bass
Guitar
et al

they all read different parts.

I was able to control them using Master-Slave but ONLY when we have matching setlists. If the singer called an audible, they'd have to dig through the "SONGS" tab and that was cumbersome.

I just tried using a Custom tag on the master and slave for a song and then I changed to that song, the slave called it up because the Custom tag was the same for both tablets. This is huge for me.

NOW....is there a way to Custom Tag all songs on import? Or do it somehow on my PC before import?

Example:
PDF title is "Africa (A) - CHART - Drums.pdf"

Is there a way to strip the title name and populate the CUSTOM field to read "Africa"?

[dallaskruse]

Can anyone think of a solution on how to tag the Custom Field of my PDFs with just the name of the song so I don't have to do them all manually?

[Zubersoft]

Unfortunately, not at the moment. I don't support extracting fields from file names and I don't currently support extracting metadata from PDFs (both are on my list of things to do).  

Mike

[Zubersoft]

Okay, I lied, you probably could do this with some SQL queries fairly easily. You could just run a query that updates all songs by replacing their custom field with the song title. Is that all you want to do?

Mike

[dallaskruse]

Okay, I lied, you probably could do this with some SQL queries fairly easily. You could just run a query that updates all songs by replacing their custom field with the song title. Is that all you want to do?

Mike

In a perfect world, I'd like to take the TITLE and copy the song name to the CUSTOM field and remove anything before the "("

TITLE: Stand By Me (Db) - CHART - CONCERT
CUSTOM: Stand By Me


I'm trying to do this with the companion app and it's working but since I get disconnected from my tablet about every 2 minutes, it's gonna take me a lot of time to manually type in the song name into the CUSTOM field.

I can't stay connected to my tablet for more than a couple of minutes. Haven't figured it out and it's really annoying.  

I'm using VMWare Fusion 10 / Windows 10 on my MacBook Pro.

[Zubersoft]

Running SQL queries on the database is the way to go for something like this. I just tested the following and it works:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

This will strip everything after "(" in the Title. It will only impact titles that have a "(" in them. So execute the first query:

Update Songs Set Custom = Title

then execute:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

and I think you'll get exactly what you are looking for.

Mike

[dallaskruse]

Running SQL queries on the database is the way to go for something like this. I just tested the following and it works:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

This will strip everything after "(" in the Title. It will only impact titles that have a "(" in them. So execute the first query:

Update Songs Set Custom = Title

then execute:

Update Songs Set Custom = trim(substr(Title,1,instr(Title, "(") - 1)) WHERE instr(Title, "(") > 0

and I think you'll get exactly what you are looking for.

Mike

that worked perfectly.
I was able to access my Tablets using ANDROID FILE TRANSFER.

I've never done any SQL before so this was a first.  But I got all my tablets synced.