Jump to content

Plucky

Members
  • Posts

    57
  • Joined

  • Last visited

Profile Information

  • Industry
    Print / IT
  • Gender
    Male
  • Location
    Essex, UK

FileMaker Experience

  • Skill Level
    Intermediate
  • FM Application
    19

Platform Environment

  • OS Platform
    Mac
  • OS Version
    Big Sur

FileMaker Partner

  • Certification
    Not Certified

Plucky's Achievements

Enthusiast

Enthusiast (6/14)

  • First Post
  • Collaborator
  • Conversation Starter
  • Week One Done
  • One Month Later

Recent Badges

0

Reputation

  1. That did the trick. Thanks for your help.
  2. 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>
  3. 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.
  4. I don't understand how it works but it does Thanks for helping me on this.
  5. 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.
  6. 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.
  7. 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.
  8. 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
  9. Plucky

    Array help

    Thats worked. Thanks for this.
  10. Plucky

    Array help

    Hi Im just started to implement some javascript charts into my Filemaker db and I've run into an issue with an array. My loader script creates the 3 x variables. The $sales variable looks like it's working for each individual record as it loops through ( {"month":December","sales":"777"} but the $data variable cannot create the Array. It displays in the debugger as [[],[],[],[],[],[],[],[],[],[],[],[]]. I think it should look like this: [{"month":December","sales":"777"},{"month":November","sales":"256"}]. Any help on this would be much appreciated as I'm pulling my hair out.. Graph.fmp12
  11. Hi I'm trying to set up a script that sends email via SMTP Server from a database hosted by FM Server and it keeps crashing my Filemaker when I run the script. If I run the database local it works fine. Is there a setting I need to set for the server to be able to run the script? Windows Server 2019 Datacenter VM Server version: 19.0.1.103
  12. Hi Is there a demo solution available containing dashboards and graphs that's free to download. I'm looking at introducing a dashboard to my database and would like to see one running and how it was set up.
  13. Plucky

    XML Import

    I will give it a go.
  14. Plucky

    XML Import

    Hi Comment I'm probably asking to much now but Is it possible to import the xml elements and have FM split between two tables. Table one (XML) would have the Job and Plate fields and the second table (Portal) would be a portal and contain the Name fields. XML.fmp12 names_import.xsl
×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.