AnsweredAssumed Answered

Return Text file of field values of multiple Records via URL

Question asked by AnswerFeedback_1 on Oct 22, 2012

Title

Return Text file of field values of multiple Records via URL

Your post

      I would like to send a query to FileMaker 12 Server Advanced via a URL (no web page form involved)

     The resulting field values for each record found would then be placed into a text file.

      

      

      

     Start of Record

     <Time>[TimeFieldValue]</Time>

     <Date>[DateFieldValue]</Date>

     <Name>[FullNameFieldValue]</Name>

     <Title>[TitleFieldValue]</Title>

     <location>[LocationFieldValue]</location>

     <Misc>[OtherInfoFieldValue]</Misc>

     End of record

      

      

      

     The results in the Text File would look like this:

     <Record> <Time>1:00 PM</Time><Date>7/14/2012</Date><Name>John Smith</Name><Title>Owner</Title><location>Texas</location><Misc>Likes Baseball</Misc></Record>

     <Record> <Time>3:00 AM</Time><Date>3/6/2012</Date><Name>Chris Martin</Name><Title>Manager</Title><location>Texas</location><Misc>Pilot</Misc></Record>

     <Record> <Time>3:10 PM</Time><Date>5/2/2012</Date><Name>Chad Barton</Name><Title>Sales</Title><location>Ohio</location><Misc>Videographer</Misc></Record>

     <Record> <Time>1:40 PM</Time><Date>9/13/1992</Date><Name>Stacy House</Name><Title>VP</Title><location>Texas</location><Misc>Owns Cabin</Misc></Record>

     <Record> <Time>8:50 PM</Time><Date>10/18/2011</Date><Name>Kim Miller</Name><Title>Sales Manager</Title><location>New York</location><Misc>French</Misc></Record>

     <Record> <Time>12:00 PM</Time><Date>10/2/2012</Date><Name>Felix Unger</Name><Title>Marketing</Title><location>Texas</location><Misc>Rotary Member</Misc></Record>

     <Record> <Time>11:00 PM</Time><Date>1/22/2012</Date><Name>Tommy Miles</Name><Title>Janitor</Title><location>Texas</location><Misc>Works Late</Misc></Record>

      

      

      

     What implementation method would you suggest to do this?

     CDML did work, but is no longer supported.

     XML seems to only send back files predefined by FileMaker (which has a lot more text than I can handle)

     php - I can't seem to find how to send the URL command and on-the-fly URL query

      

      

      

     Suggestions?

      

      

      

     Thanks

     Zorba

Outcomes