Jump to content


  • Posts

  • Joined

  • Days Won


-Queue- last won the day on March 5 2011

-Queue- had the most liked content!

About -Queue-

  • Birthday 10/19/1977

Profile Information

  • Slogan
  • Gender
    Not Telling

FileMaker Experience

  • Skill Level
  • FM Application
    13 Advanced

Platform Environment

  • OS Platform
  • OS Version
    Win 7

Recent Profile Visitors

The recent visitors block is disabled and is not being shown to other users.

-Queue-'s Achievements

Grand Master

Grand Master (14/14)

  • First Post
  • Collaborator
  • Posting Machine Rare
  • Conversation Starter
  • Week One Done

Recent Badges



  1. Problem solved! Apparently Windows Update had never been enabled on the server. 141 updates later, it works without a hitch! Thanks for your help, Wim and Web. ;c)
  2. No XML at all. So if I access the URL in ,e.g., Firefox, it shows: XML Parsing Error: no element found Location: https://serverip/fmi/xml/fmresultset.xml?-db=TEST_XML&-layoutnames Line Number 1, Column 1 If I use an invalid query, such as db=TEST_XML&-layoutnamesd, I receive an error, as expected: <fmresultset version="1.0"><error code="4"/><product build="05/08/2015" name="FileMaker Web Publishing Engine" version=""/><datasource database="" date-format="" layout="" table="" time-format="" timestamp-format="" total-count="0"/><metadata/><resultset count="0" fetch-size="0"/></fmresultset> Using any other kind of query that should be valid (e.g., -lay=Testing&-findall) returns no XML though. The same holds true for other files with several layouts and scripts (a -scriptnames query on PSoS_Log_CWP, for instance returns nothing). I was trying to get this idea working, but it kept bailing because the results of the Insert from URL step were empty. Very frustrating...
  3. 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=""/><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, 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?
  4. Yes, well. I'm still stuck on FM 5 here and haven't even opened 7 in a couple of years, so I can't be of much assistance these days... But that's okay because I have a family to take care of now and don't even have that much time for adventure gaming anymore, let alone extracurricular programming. But it's all worth it and I can still lurk at times. : <-- still a dumb smiley
  5. Holy cow @ your blistering number of posts! I can't believe I'm still in the top ten though. : *waves* -Q
  6. -Queue-

    field label

    Try an auto-enter calculation with the field's name and format it on the layout to select all contents.
  7. I don't believe File References can be that dynamic...yet, though I don't have 9, so I may be incorrect.
  8. Or Right( Substitute( 10^(30 - Length(yourField)), "0", "." ) & yourField, 30 ) to allow easy changes to the number of periods used. You would have to use a monospaced font to ensure everything lines up nicely.
  9. Something like LeftWords( Case( AfricanCheck, "African, " ) & Case( FilipinoCheck, "Filipino, " ) & Case( HawaiianCheck, "Hawaiian" ), 9 ) should work.
  10. As far as I am aware, this is not currently possible. You may be able to use a plug-in to trigger a script to update a field's value, but I think that would still require leaving the field to trigger it.
  11. Go into Layout Mode, select all objects, copy, and paste into the other file, or drag-and-drop them if that's an option.
  12. No, once you have imported a new set of records, just run a Set Field loop to convert the date value appropriately. Since I don't know the specific script steps in FM 8, I'll use pseudo-code. Go to Record [First] Loop Set Field [datefield; Date( Middle( datefield, 5, 2 ), Right( datefield, 2 ), Left( datefield, 4 ) )] Go to Record [Next; Exit after last] End Loop For the existing records, run a Replace Field Contents in the date field with the calculation above. This will convert all the invalid dates into a valid date format.
  13. There may be an easier way in 8, but the way I would do this is by printing a report to PDF995 (or something similar) and then attaching it to the email.
  • Create New...

Important Information

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