Playing external mp3 from file path

[pianoman]

I all,

I have a (text) field in my Music Database that has the full file path for every mp3 of my external HDD (around 50.000 classical music mp3s).

It would be wonderful if I could use this file path (in text format) to open externally (or internally) the related mp3 file on my external hard drive in a (hopefully) simple way.

I have Filemaker Pro 16 Advenced and I'm a real newbie at this...

 

Many thanks in advance.

 

[comment]

See if this helps:
https://fmforums.com/topic/105723-playing-an-mp4-file-using-an-url/?do=findComment&comment=478163

 

[pianoman]

1 hour ago, comment said:

See if this helps:
https://fmforums.com/topic/105723-playing-an-mp4-file-using-an-url/?do=findComment&comment=478163

 

Thanks. The ideia was not using a container field because that makes me "insert" each mp3 into the field (a lot of work!).

I already have the file path in that field so I was hoping there was a simple solution...

 

[comment]

2 minutes ago, pianoman said:

The ideia was not using a container field because that makes me "insert" each mp3 into the field (a lot of work!).

I am afraid you are missing a central point of the suggestion made in the other thread: the idea is to take the OS file path you have and use it in a calculation field to produce a Filemaker path.  If you set the result type to Container, it will behave just as if you had inserted each mp3 into the field - i.e. you can double-click it to play.

Note also the other two options mentioned there.

 

[pianoman]

4 hours ago, comment said:

I am afraid you are missing a central point of the suggestion made in the other thread: the idea is to take the OS file path you have and use it in a calculation field to produce a Filemaker path.  If you set the result type to Container, it will behave just as if you had inserted each mp3 into the field - i.e. you can double-click it to play.

Note also the other two options mentioned there.

 

Sorry. I didn't realize that. I'l look into it then.
Thanks again

 

[pianoman]

Just looked into it and realized it's too much for me...I need more specific instructions because my level of Filemaker programming is prety basic...

I got HERE and I suspect I'm near but couldn't get a result. And to get it worse my scripts are in portuguese.

[comment]

Scripts have nothing to do with this. Try defining a calculation field as =

"movie:/" & Substitute ( Path ; "\\" ; "/" )

and select Container as the result type.

[pianoman]

1 hour ago, comment said:

Scripts have nothing to do with this. Try defining a calculation field as =

"movie:/" & Substitute ( Path ; "\\" ; "/" )

and select Container as the result type.

It worked !!!!!

Thank you! thank you so much for your precious help!