file:/jobs/temp/fmp/converted.csv is an invalid path.
Valid are relative paths:
or absolute paths
but yours is an invalid combination.
This was an error of mine, as later in the thread became obvious. FileMaker begins absolute paths with the name of the HD. Very unconvenient, by the way.
I did actually give that a go too - I should have mentioned that.... I think I just pasted in one of the things that I tried....
If it makes any difference, /jobs/temp is actually a symlink to /Volumes/STORAGE_01/project_data/temp
But I'm pretty sure I've tried explicitely stating the path as well as through the sym link.
I doubt that FileMaker is able to follow sym links.
Okay. When I'm back in the office tomorrow, I'll check it again having the file I'm trying to import on the local drive. Will let you know how it goes.
Nope. I don't think it's the symlink that's causing it.
I'm now putting it into:
And it's still telling me that it can't find the file....
I tried to export some FM data to filemac:/private/tmp/converted.csv and got an error message. Obviously FM is not allowed to write and read that folder :(
I'm not convinced that it's a file location thing...
I just tried /Users/hugh/converted.csv too, and that doesn't work either....
I'm going to give it another go using XML rather than CSV....
Sorry for the trouble, I have got it now.
FileMaker uses different paths as you see when you evaluate
Get ( TemporaryPath ) = /Macintosh HD/private/var/tmp/folders/501/TemporaryItems/FileMaker/
Remedy: Extract the name of the Disk from this function[*], store the result in a $ variable together with you desired path and use this variable as export path.
[*] Left( Get ( TemporaryPath ) ; Position( Get ( TemporaryPath ) ; "/" ; 1 ; 2 ) )
Fantastic! That works wonderfully, thanks!
I've now got my python script writing to /private/tmp/ and FMP reading from filemac:/MacHD/private/tmp/
I'm going to have to rename my main volume back to Macintosh HD, though - this needs to be able to work on a few machines. It's a shame that / doesn't work as the main partition, with /Volumes/$VOLUME/ for the others....
Ah well - at least this is actually working now! Thanks for your time and effort!
Hello, do you know if is there a way to script an import of a specified worksheet from different .xls files?