Plucky

Hi I have a FM script that exports an XML file into a networked drive. This file then gets imported into an External Workflow Server. ( Not Filemaker ) I know the external server has a Web Service and can use POST and GET methods as I currently send requests from the server to my Filemaker database. What I would like is to send this Filemaker XML using one of these methods rather that dropping files into a networked drive that first must be mounted on the users desktop. Is it recommended to use Insert from URL to achieve this or am I better off using another method. I have attached a description of what the external Server can receive. Any help on this would be much appreciated.Web Service.pdf

Im trying to request a access token and Im receiving the following error message. {"messages":[{"message":"Unexpected token % in JSON at position 0","code":"1630"}],"response":{}} Its just a test database hosted on a windows server v19 and Im connecting via a Prepress workflow Server that has a 'Interact with Web Service' module I can retrieve a list of hosted files but as soon as I change to a POST method and supply Authorization it errors. I've checked the u/p and that's correct. Ive tried different variations of suppling the login details and all comeback with same error. The response from the GET hosted files: {"response":{"databases":[{"name":"ESKO"}]},"messages":[{"code":"0","message":"OK"}]}. Any ideas what Im doing wrong?

Hi I have it working now using your demo. Thanks for sorting this for me.

Now it seems to be adding everything on one element. Archive.zip

Hi Ive tried it but the result comes out blank. Archive.zip

Hi I trying to export a record in XML that also contains a portal with multiple records. When I view the exported XML file the main record is complete but only the first entry in the portal is exported. My question is it possible to achieve this in Filemaker and if so what do I need to change on my XSL file. The portal fields are: <FruitSpecs> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <Fruit> <Name><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></Name> <Qty><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></Qty> </Fruit> </xsl:for-each> </FruitSpecs> trial.xsl

That did the trick. Thanks for your help.

Hi I thought I had to use an Insert from URL, Just added the link to the HTTP request window in the Import Records script step and that's worked fine. I'm ok with importing elements but how can I import the the 2 x attributes. <?xml version="1.0" encoding="UTF-8" standalone="no"?><MACHINE Generated="2021-06-28T15:16:06+01:00" device="Boris"><IDLE>FALSE</IDLE><IP>172.16.3.202</IP><QUEUELENGTH>14</QUEUELENGTH><TIME unit="sec">12419</TIME></MACHINE> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:output method="xml" version="1.0" encoding="utf-8" indent="yes"/> <xsl:template match="/MACHINE"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <!-- Job Fields --> <FIELD NAME="IDLE"/> <FIELD NAME="IP"/> <FIELD NAME="QUEUELENGTH"/> <FIELD NAME="TIME"/> <!-- define more fields here --> </METADATA> <!-- IMPORT DATA --> <RESULTSET> <xsl:for-each select="MACHINE"/> <ROW> <!-- JOB data --> <COL><DATA><xsl:value-of select="IDLE"/></DATA></COL> <COL><DATA><xsl:value-of select="IP"/></DATA></COL> <COL><DATA><xsl:value-of select="QUEUELENGTH"/></DATA></COL> <COL><DATA><xsl:value-of select="TIME"/></DATA></COL> </ROW> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet>

Hi I'm trying to import xml data into several fields using Insert From URL. I can get it to all appear in one field but I need it to be distributed into several. <?xml version="1.0" encoding="UTF-8" standalone="no"?> <MACHINE Generated="2021-06-28T14:19:20+01:00" device="Boris"> <IDLE>TRUE</IDLE> <IP>172.16.3.202</IP> <QUEUELENGTH>11</QUEUELENGTH> <TIME unit="sec">9780</TIME> </MACHINE> Is there a way to populate the following fields from tagging onto to my Insert From URL script. MACHINE, IDLE, IP, QUEUELENGTH & TIME I can save the xml into a file and import that way using a .xsl file but I wanted to do this all in one script.

I don't understand how it works but it does Thanks for helping me on this.

Hi I’m trying to calculate how many jobs employees complete on a day sorted by shift. We have 3 Shifts: Early Shift - 06:30:01 to 14:30:00 Evening Shift - 14:30:01 to 22:30:00 Late Shift - 22:30:01 to 06:30:00 I have 3 fields CompletedJobTimestamp CompletedJobTimestamp_TimeONLY CompletedJobTimestamp_DateONLY I'm not sure if I should be converting "CompletedJobTimestamp_TimeONLY" to seconds and running a if statement to see if it falls into 1 of 3 ranges to give it an Early, Evening or Late result. Then I can sort using this result under a date search. The problem I have then is the late shift runs into the next day's morning. Any ideas on the best way to approach this.

Hi comment I've noticed that my current solution doesn't always run and errors out every now and then. I have hundreds of files being moved and renamed daily and this part gets done on a windows shared volume. I was hoping that I could just have the files saved in one folder that triggers a script that imports the current contents of a folder no matter of its name.

I have a solution that imports xml files throughout the day . The way its set up is when a xml file gets dropped into a networked folder titled with its Job No ( 90001.xml, 90002.xml, 90003.xml ) an AppleScript is triggered and moves the XML file to a new folder and renames it to ImportXML.xml. The AppleScript then triggers a FM script that imports the xml into a solution and then then AppleScript deletes the .xml file. What I would like is Filemaker to be able to import using the original job number ( ****.xml ) and loop through everything that’s in the folder and to delete once imported. Any ideas if this is possible in Filemaker or maybe a 3rd party plugin.

Hi I have a database hosted on a FM Server ( v19 ) that contains multiple Carafe charts on a dashboard layer. Connecting to the hosted database works fine from my Mac but as soon as I connect using an iPad and view the Dashboard layer it refuses to open and display. All other layouts display it's just the ones that contain the Carafe JS charts. Do I need to install a plugin on the server allowing iOS devices to display the dashboards? The Server is running on a Windows Server 2019vm

Thats worked. Thanks for this.