• Open Menu Close Menu
  • Apple
  • Shopping Bag
  • Apple
  • Mac
  • iPad
  • iPhone
  • Watch
  • TV
  • Music
  • Support
  • Search apple.com
  • Shopping Bag

Lists

Open Menu Close Menu
  • Terms and Conditions
  • Lists hosted on this site
  • Email the Postmaster
  • Tips for posting to public mailing lists
XML Filemaker
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

XML Filemaker

  • Subject: XML Filemaker
  • From: Wayne Melrose <email@hidden>
  • Date: Fri, 7 Jul 2006 22:14:24 +0200
The other day I posted a question about getting info from Filemaker Server without using Filemaker Pro.

Tim Mansour suggested using curl. xml and parsing the result with XMLlib..

My problem is a lack of experience with XML and understand how to properly use XMLLib.

I know I could work this out with a simple bit of XML although I find the result from filemaker really difficult to understand.

Essentially what I am going to do is pull just one record at a time from filemaker, and display each of the fields in my application. So what I am hoping to do is just separate each of the field values from the xml.

If this makes sense to anyone could you please point me in the right direction, I have a sample of the xml from filemaker attached (I hope thats OK?) If anyone can point me in the right direction to getting the details out, I would really appreciate it.

Thanks

Wayne


<?xml version="1.0" encoding="UTF-8" standalone="no"?><!DOCTYPE fmresultset PUBLIC "-//FMI//DTD fmresultset//EN" "/fmi/xml/fmresultset.dtd"><fmresultset xmlns="http://www.filemaker.com/xml/fmresultset"; version="1.0"><error code="0"></error><product build="03/01/2005" name="FileMaker Web Publishing Engine" version="7.0v5"/><datasource database="MegaprintJobTrack" date-format="MM/dd/yyyy" layout="basiclayout" table="MegaprintJobTrack" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="27392"/><metadata><field-definition auto-enter="yes" global="no" max-repeat="1" name="ClientName" not-empty="no" result="text" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="ClientContact" not-empty="no" result="text" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="JobNumber" not-empty="yes" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Sales" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="machine" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrePress" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrePressStart" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrePressFinish" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Print" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrintFinish" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrintStart" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrintRipMode" not-empty="no" result="text" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="PrintMaterial" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="SquareMetres" not-empty="no" result="number" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrePressNotes" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="PrintNotes" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="FabricationNotes" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Fabrication" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="FabStart" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="FabFinish" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Colours" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="clientnumber" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Quality" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Product" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="ApprovalMethod" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="WIP" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="JobStatus" not-empty="no" result="text" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="priority" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="WIPcomments" not-empty="no" result="text" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="idagImorgen" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="progress_archive" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="DeliveryDate" not-empty="no" result="date" type="normal"/><field-definition auto-enter="yes" global="no" max-repeat="1" name="LastProductionDate" not-empty="no" result="date" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="OrderDate" not-empty="no" result="date" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="DispatchRequirements" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Transport" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="DispatchTaping" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="SourceMedia" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="Description" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="WordDoc" not-empty="no" result="container" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="salesapproved" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="datedump" not-empty="no" result="date" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="RUBmaterial" not-empty="no" result="text" type="normal"/><field-definition auto-enter="no" global="no" max-repeat="1" name="price" not-empty="no" result="number" type="normal"/></metadata><resultset count="1" fetch-size="1"><record mod-id="44" record-id="43949"><field name="ClientName"><data>Via Scandinavia AS</data></field><field name="ClientContact"><data>Knut Bukve</data></field><field name="JobNumber"><data>27088</data></field><field name="Sales"><data>Ida Hansen</data></field><field name="machine"><data>3300</data></field><field name="PrePress"><data>Wayne</data></field><field name="PrePressStart"><data>3:07:57 PM   7/4/2006</data></field><field name="PrePressFinish"><data>3:32:21 PM   7/4/2006</data></field><field name="Print"><data>Boas</data></field><field name="PrintFinish"><data>10:54:58 AM   7/6/2006</data></field><field name="PrintStart"><data>3:45:08 PM7/5/2006</data></field><field name="PrintRipMode"><data>PVC_BQ.env</data></field><field name="PrintMaterial"><data>Duk frontlit 450g 320 cm</data></field><field name="SquareMetres"><data>12.918</data></field><field name="PrePressNotes"><data>jeg har en print av hvordan den skal se ut. Legger den også i kassa</data></field><field name="PrintNotes"><data></data></field><field name="FabricationNotes"><data></data></field><field name="Fabrication"><data>Stian</data></field><field name="FabStart"><data>13:06:577/6/2006</data></field><field name="FabFinish"><data>14:48:26   7/6/2006</data></field><field name="Colours"><data>PMS 485.</data></field><field name="clientnumber"><data>11640</data></field><field name="Quality"><data>god</data></field><field name="Product"><data>banner</data></field><field name="ApprovalMethod"><data>Email</data></field><field name="WIP"><data>arkiv</data></field><field name="JobStatus"><data>arkiv</data></field><field name="priority"><data>I dag</data></field><field name="WIPcomments"><data></data></field><field name="idagImorgen"><data></data></field><field name="progress_archive"><data>arkiv</data></field><field name="DeliveryDate"><data>07/07/2006</data></field><field name="LastProductionDate"><data>07/06/2006</data></field><field name="OrderDate"><data>07/04/2006</data></field><field name="DispatchRequirements"><data>I Plast</data></field><field name="Transport"><data>Ring Kunde nar ferdig</data></field><field name="DispatchTaping"><data>Nøytral Tape</data></field><field name="SourceMedia"><data>27088</data></field><field name="Description"><data>ordrenummer 96783</data></field><field name="WordDoc"><data></data></field><field name="salesapproved"><data>approved

</data></field><field name="datedump"><data>07/07/2006</data></field><field name="RUBmaterial"><data></data></field><field name="price"><data>7.617,61</data></field></record></resultset></fmresultset>
 _______________________________________________
Do not post admin requests to the list. They will be ignored.
Applescript-users mailing list      (email@hidden)
Help/Unsubscribe/Update your Subscription:

This email sent to email@hidden
  • Follow-Ups:
    • Re: XML Filemaker
      • From: Emmanuel <email@hidden>
  • Prev by Date: Re: parsing a large text file
  • Next by Date: Re: XML Filemaker
  • Previous by thread: Re: Jon's CommandsX 3.0d3 - more
  • Next by thread: Re: XML Filemaker
  • Index(es):
    • Date
    • Thread