Jump to content

Paul Webb

Members
  • Content count

    12
  • Joined

  • Last visited

Community Reputation

0 Neutral

About Paul Webb

  • Rank
    newbie
  • Birthday 10/04/1974

Profile Information

  • Gender
    Male
  • Location
    Texas

Contact Methods

  • Jabber
    pawebb@cisco.com
  1. License Web letter

    Contacted FM support/sales and they couldn't help me after an hour of sitting on the phone. Right after that call I reached out to my sales rep via email and he emailed me back in less than 5 min with the link I needed.
  2. License Web letter

    Thanks Josh. Itching to get my hands on the new goods!
  3. License Web letter

    Anyone else not yet received their web letter with their FM16 license info? FileMaker says they are on their way but still waiting.
  4. SVG Icon Manager

    Sorry about that. Post updated.
  5. SVG Icon Manager

    The link in the initial post for the solution location changed but I found it here... Click here Whew!
  6. XML Import: Transforming XML Data with XSLT

    That did it! I don't quiet get the namespace portion of XML. Guess it's back to YouTube for me. Thanks for setting me straight!
  7. I've spent the last couple of days learning XML, XPath, XSLT trying to make this work. I feel like I am really close but something simple is off. My XSLT is not quiet right and I need some expert input. For testing I set it up to only pull in the first field. Once I have that right the rest should be easy. Below I have added the XML, XSL, and Transformed XML. You can see in the transformer portion that there is something off with my data. When trying to import into FM it just creates a blank record. I am trying to import the "Y" from the "BTK-security-complete" field. XML <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <CDETS xmlns="cdetsng" xmlns:ns2="http://www.w3.org/1999/xlink"> <Defect id="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849"> <Field name="BTK-security-complete">Y</Field> <Field name="Class">CSC.swtools</Field> <Field name="Component">other</Field> <Field name="DE-manager">bnado</Field> <Field name="Description">Lifecycle changes to Pre when a Obsolete concept moved under Pre Parent</Field> <Field name="Headline">Lifecycle changes to Pre when a Obsolete concept moved under Pre Parent</Field> <Field name="Identifier" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Field> <Field name="Is-customer-visible">N</Field> <AuditTrail id="Tue Apr 19 12:27:53 PDT 2005" defectID="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849/audittrail"> <Parent ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Parent> <Field name="ChangedBy">ksahani</Field> <Field name="ChangedOn">04/19/2005 12:27:53</Field> <Field name="Field">Defect Created</Field> <Field name="Operation">New Record</Field> </AuditTrail> <Files> <File id="DDTS_History.txt" defectID="CSCsa8849" ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849/file/DDTS_History.txt"> <Parent ns2:href="http://cdetsng.mydomain.com/wsapi/bug/CSCsa8849">CSCsa8849</Parent> <Field name="Extension">txt</Field> <Field name="FileSize">55</Field> <Field name="Filename">DDTS_History</Field> <Field name="UpdatedBy">cdetsync</Field> <Field name="UpdatedOn">01/22/2008 17:25:00</Field> </File> </Files> </Defect> </CDETS> XSL <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="xsl fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"> </xsl:output> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="10-18-2015" NAME="FileMaker" VERSION="ProAdvanced 14"/> <DATABASE DATEFORMAT="m.d.yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="k:mm:ss "/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="BTK-security-complete" TYPE="TEXT"/> </METADATA> <RESULTSET FOUND=""> <xsl:for-each select="/*/*"> <ROW MODID="0" xmlns="http://www.filemaker.com/fmpxmlresult"> <xsl:attribute name="RECORDID"> <xsl:value-of select="position()" /> </xsl:attribute> <COL> <DATA> <xsl:value-of select="//Field[@name='BTK-security-complete']" /> </DATA> </COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> Transformed XML <?xml version="1.0" encoding="UTF-8"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT VERSION="ProAdvanced 14" NAME="FileMaker" BUILD="10-18-2015" /> <DATABASE TIMEFORMAT="h:mm:ss " RECORDS="1" NAME="" LAYOUT="" DATEFORMAT="m.d.yyyy" /> <METADATA> <FIELD TYPE="TEXT" NAME="BTK-security-complete" MAXREPEAT="1" EMPTYOK="YES" /> </METADATA> <RESULTSET FOUND=""> <ROW MODID="0" RECORDID="1"> <COL> <DATA /> </COL> </ROW> </RESULTSET> </FMPXMLRESULT>
  8. Validation or Script Trigger

    Because I'm still new at this and sometimes what appears to be the obivious is not always the best way.
  9. Validation or Script Trigger

    If the user clicks in the field as though they are going to make an edit.
  10. Validation or Script Trigger

    I have two fields: Closed Date & HW Platform. Goal: If the user selects the HW Platform field and Closed Date is empty pop a custom dialog. If Closed Date is not empty then no message. I have tried a few ways to use field validation to perform the check and post a message but no luck so far. I know I could do this easily with a Script Trigger. My question is can this be done with validation? And is one or the other method better? Validation or ST? FileMaker 12 FileMaker Server Adv 12
  11. Year list drop down

    Thanks guys...Appreciate the help.
  12. Year list drop down

    I'm trying to create a list of years based on a date field in one of my tables. I am putting a dashboard together that allows the user to select the starting year from a drop down list. Each user will possibly have a different range of dates in their copy so i would like to have a drop down list of years based on the dates in a field in their copy. I hope that makes some sense and someone can point me in the right direction? Thanks
×

Important Information

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