2 posts in this topic
Hi Gang, long time no see!
Anyway, I am attempting to use Insert From Url to pull in some XML data and am having no luck with it.
When I use a url such as "https://ipaddress/fmi/xml/fmresultset.xml?-dbnames", I receive the expected result:
<fmresultset version="1.0"><error code="0"/><product build="05/08/2015" name="FileMaker Web Publishing Engine" version="220.127.116.113"/><datasource database="DBNAMES" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="4"/><metadata><field-definition auto-enter="no" four-digit-year="no" global="no" max-repeat="1" name="DATABASE_NAME" not-empty="yes" numeric-only="no" result="text" time-of-day="no" type="normal"/></metadata><resultset count="4" fetch-size="4"><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>FMServer_Sample</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>LatestUpdates</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>PSoS_Log_CWP</data></field></record><record mod-id="0" record-id="0"><field name="DATABASE_NAME"><data>TEST_XML</data></field></record></resultset></fmresultset> When I attempt to query the TEST_XML file, however, e.g., "https://ipaddress/fmi/xml/fmresultset.xml?-db=TEST_XML&-layoutnames", nothing is returned. TEST_XML is a simple one-table (called TESTER) file with one field ("id"), one layout ("Testing") and a handful of records. It is set to auto-login as [Guest], which has the [Full Access] privilege and only the fmxml Extended Privilege.
The server is running Windows Server 2008 R2 Standard, SP1 and FM Server 18.104.22.1684, with everything enabled in the Admin Console. I am using Advanced 13.0v9 and Pro 13.0v9, though I receive an empty result in FireFox and IE also.
Am I missing something obvious?
I am trying to write a script that let me display multiple fields of the same tables and create a button that run that script.
for example a button to show the current address and another on to show the previous address, or some thing like that.
I don't know if this idea is doable or not.
Thanks in advance for your help and advice.
I am using filemaker pro 13
"This is the first time I'm setting up a script to run on a server with the help of a schedule, so I will probably make a lot of strange mistakes, but how hard can it be?
Hard, obviously. :|"
I have a script that check for new files in a folder, process them, export some data and move the files to a new destination. It works flawless with the Filemaker Client.
On the Server I can't get it to work! I'm using the BE_ListFilesInFolder step.
The folder that I want to check is the following (the FMServer User have both read and write privileges on all mentioned folders):
This is outside the server Documents folder, so just to be sure I tried to change it to:
C:\Program Files\FileMaker\FileMaker Server\Data\Documents\In\
I get the same error on both.
I have tried to use a field as the path as well as hardcoded as well as variables in different combinations:
BE_ListFilesInFolder ( System::FMIn Folder )
BE_ListFilesInFolder ( "C:\Program Files\FileMaker\FileMaker Server\Data\Documents\In" )
Set variable($folderpath) and then BE_ListFilesInFolder($folderpath)
I have tried a zillion different ways. With the Client it works. From the server it does not. I GET CRAZY!!!
What have I missed?
...or should I just skip the Filemaker Server Schedule and do this with a client instead?
[Windows 2012 r2, FM Server v22.214.171.124]
Hi, I'm importing records and have a date field that i need to use to set my Fiscal year, month, week based on the fiscal year starting February 1st and ending January 31st.
Any ideas or sample i might be able to take a look.
Thanks in advance.
By Joost Miltenburg
We recently migrated from FM14 to FM15 and suddenly some invoices come out strange after the saveAsPdf script step . ( see pic ). When in preview mode everything seems to be ok and is printed to a printer ok.
Theme : Classic, Font used : Calibri size 11 and 12.
Problem occurs on Mac 10.11 and Win10 with FM15.
When I do a print ( to preview ( mac )) and then save as pdf everything is also ok, so it seems to be related to the FM pdf renderer.
However, not every invoice has this issue, but I wonder how data could cause this behaviour.
Best regards !