all I need is to read the content of a text file into a text field and I can’t figure out how.
Situation: I have ≈150’000 folders, each with one image file and one xml/text file with meta information about the image file. The image file and the meta data need to go into the same record.
I’ve looked for hours now, but couldn’t find a solution:
• I can’t use the import folder command, because it creates new records for each file in a directory.
• I can’t use Do AppleScript > do shell script > cat x.txt, because I can’t get the result into FileMaker.
• I can’t use the new Read File script step of FM18, because the solution is on FM16 and FM17. (I tried it nevertheless, but all I got was the filename!?)
• I’cant use a plugin (MBS would work just fine, I think).
So, what are my options? Any ideas?
I would love to insert the xml file into a container and then read the container raw data — but how? A couple of years ago, I have read about someone actually doing this, but I can’t remember where or how. That would be cool!
Any other suggestions?
Thanks so much!
Our people out in the field take photos which go directly into the container fields, we would like those photos to automatically transfer to the camera roll/gallery. I know there is an export command and that would allow the techs to export and choose the location, save image etc... But that is a tad too complicated for them.
Any suggestions on how to automate this process, the script for export field contents doesn't have a choice to save to camera roll.
Does anyone know how to fix an image from appearing too small within a container in WebDirect? In FMP it fills the container. Tried to "play" with most settings relating to containers, including margins, frame, etc. - no success. The problem presents itself in Safari in macOS Catalina, as well as Edge on Windows 10
See image attached.
I sure hope this isn't a bug! Because if it's a bug then it will get fixed... well, never.
How will I approach to delete all records in a table where the container is empty.
I tried a few scripts but ran into problems with most of them.
Loop stayed in a loop
I tried calculating container length and delete if length is zero, but the field does not calculate to a zero even if i set default to zero