Filepath

[MikeKD]

Hi Folks,

Can anyone spot what I've done wrong with this file path?

The Events::gYellowFormFilepath contains "2017-2018" which is the name of a folder.

Macintosh SSD and Mike (X) both had spaces - I've tried with and without. Neither have worked, but give the error file "could not be created on this disk..."

"filemac:/MacintoshSSD/Users/mikekentdavies/Mike(X)/School/Concerts & Events/"
& 
Events::gYellowFormFilepath
&
"/MusicDept_YellowForms_"  & Substitute ( Get ( CurrentDate ) ; "/" ; "_" )

I'm pretty sure that all my read / write privileges are fine. There's lot's of free disk space, so I'm pretty sure I've bogged up with the file path somehow.

Cheers!

Mike

[comment]

Here's what I would do in your situation:

1. Copy the path calculation to the data viewer and observe the result.

2. Place a file (a Filemaker file) in the target folder and observe the result of Get (FilePath).

3. Work on the path calculation until it returns the same result as step 2 does.

[MikeKD]

Hi comment,

many thanks - that's another cunning plan!

Sorry for the slow reply - my laptop died and I had to reinstall MacOS.

Which has meant I've lost FM15. :-(
There's no link to FM15 on the FM website so I upgraded to FM16.
But that won't install because I've lost FM15.
And the support phone number is 9-5, week days only.

I'll try your suggestion, if this ever gets sorted!!

Cheers!

Mike

[MikeKD]

Hi comment,

All sorted now and your suggestion worked a treat. I can envisage that being a really useful technique when moving databases to different computers.

Huge thanks yet again!

Mike