10 posts in this topic
I have a simple Applescript that works in Script Editor
tell application "Keyboard Maestro Engine"
do script "Search the Web"
I add this same script (with escape chars) to my RESOURCES::A_SCRIPT field inside FM.
The RESOURCES table is not connected to the other tables in the graph.
"tell application \"Keyboard Maestro Engine\"
do script \"Search the Web\"
I've tried this with this field being defined as a Global Storage Field or not. Similar problems with both.
I have an FM Script called EXECUTE:
Perform Applescript (RESOURCES::A_SCRIPT)
When I run this FM Script I get an error message:
"Error: -2741" / "Expected EOL but found Command Name"
I've have tried rebooting my Mac.
Fairly trivial (but annoying) problem here!
I've just transferred all Invoice PDFs to their respective container fields - which is externally stored (non secure) on the FMS Server.
However the first PDF in the table had an '_1' at the end of the filename on the server. When I cleared the field and re-added the PDF it then has '_2' at the end, and so on.
The underscore disappeared when I transferred the container from 'Invoices/' to 'Invoices2/' but the problem remains when I transfer back to 'Invoices/'.
It doesn't happen to any other PDFs/records, just this first one in the table. Any ideas how I can 'reset' this?
By Franco Pagano
fmp 14 last release.
i put this applescript in a global field and also all the fmp field are global.
i don't understand wy it doesn't work, if the applescript var are set as ... "set ServerDisk to "afp://126.96.36.199/dati" ... it work.
Were i am wrong?
set ServerDisk to field ("ServerDisk_as" as text) of table ("__AS" as text)
set ServerFolder to field ("ServerFolder_as" as text) of table ("__AS" as text)
set VarAccount to field ("VarAccount" as text) of table ("__AS" as text)
set VarPw to field ("VarPassWord" as text) of table ("__AS" as text)
tell application "Finder"
display dialog ServerFolder
if not (disk ServerDisk exists) then
mount volume ServerFolder as text as user name VarAccount with password VarPw
I'm working on a function to extract text from a .txt.gz file in a container field:
//SM_TextFromGZIP ( containerFieldName ) import java.util.zip.GZIPInputStream; import java.util.io.*; GZIPInputStream gunzip = new GZIPInputStream(fmpro.getContainerStream(containerFieldName)); InputStreamReader reader = new InputStreamReader(gunzip); BufferedReader pr = new BufferedReader(reader); String line; String finalOutput = \"\"; while ((line = pr.readLine()) != null) finalOutput += line; return finalOutput; When I run this, I get this from the SMLastStackTrace function:
java.io.IOException: com.prosc.fmkit.types.FMBinary$FMContainerInputStream.read() returned value out of range -1..255: -117 at java.util.zip.GZIPInputStream.readUByte(GZIPInputStream.java:250) at java.util.zip.GZIPInputStream.readUShort(GZIPInputStream.java:237) at java.util.zip.GZIPInputStream.readHeader(GZIPInputStream.java:140) at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:56) at java.util.zip.GZIPInputStream.<init>(GZIPInputStream.java:65) at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method) ... Any thoughts on a fix or alternative solution?
My old fp7 solution had some fields that store the path to external pdf files, the files were stored in the same server machine and the path were like "file://oldserver/folder/file", the pdf files are shown in the solution through a webviewer field. The solution is developed under the 'separation model'.
I just converted the solution to FM15 and I moved into a new server, at present I have both servers up and running, so the fmp12 database with fields pointing to "file://oldserver/folder/file" still shows pdf files as expected.
Given that I want the paths to point to a certain folder into the new server I'm trying to find the right path to the new location of files but so far I haven't been able even thought I made sure that users fmserver and fmsadmin have full permissions on the folder that stores the pdf files.
On the other hand I've seen that FMS15 creates a folder named "RC_Data_FMS" with a subfolder for each fmp12 file where the external container data is meant to be stored. Am I forced to store my pdf files in there OR somewhere else in the network?
Thank you in advance.