Jump to content

Search the Community

Showing results for tags 'xml'.

More search options

  • Search By Tags

    Type tags separated by commas.
  • Search By Author

Content Type


  • Custom Function Library

Community Forums

  • Community Resources
    • Community Articles, Tips, & Techniques
    • FileMaker Marketplace Discussions
  • FileMaker Security Management
    • Security Concepts
    • Intellectual Property
  • FileMaker Server Administration
    • FileMaker Server 16
    • FileMaker Custom SSL Certificates
    • External Server Authentication
  • FileMaker Go & Mobile Strategies
    • FileMaker Go for iPhone & iPad
    • iBeacon Support
    • FileMaker IOS App SDK
  • FileMaker and the Internet
    • FileMaker REST API
    • FileMaker Cloud
    • FileMaker WebDirect
    • Custom Web Publishing
    • Other Internet Technologies
  • FileMaker Interface Features
    • Cards & Window Management
    • Interface Design Discussions
    • Layouts
    • Themes and Styles
    • Button, Popovers, Button Bars, SVG Icons
    • Tab and Slide Control Panels
    • Portals
    • Web Viewer
    • Conditional Formatting
    • Custom Menus
    • Value Lists
    • Tool Tips
  • FileMaker Schema & Logical Functions
    • Managing Scripts
    • Calculation Engine (Define Fields)
    • Custom Functions Discussions
    • FileMaker Query Language or FQL
    • Relationships
    • Charting
    • Remote Container Fields
    • Finding & Searching
    • Importing & Exporting
    • External Data Sources
    • Advanced & Developer Features
    • Reports, Printing & Publication
  • Brain Food
    • The Left Brain
    • Upgrading & Migration
    • Data Analysis
    • Development Standards
    • The Separation Model
    • Relational Database Theory
    • Damaged / Corrupt File Problems
    • OS Level Database Automation
    • Hardware & Networking
    • Bar Codes (Printer, Scanners, Software)
    • Accounting Solutions
  • FileMaker Discussions
    • FileMaker Pro 16
    • FileMaker Pro 15
    • Legacy FileMaker Platform Discussions
  • Geist Interactive Product Support Forums
    • Visit Geist Interactive
    • Visit Modular FileMaker
    • FMPerception
    • Generator
    • fmQBO
  • 360 Works Official Product Support Forums
    • 360 Works General Support
    • MirrorSync by 360Works
    • SuperContainer by 360 Works
    • ScriptMaster by 360 Works
    • FTPeek by 360 Works
    • 360Works Email Plugin
    • DocuBin by 360 Works
    • Zulu – FileMaker, iCal & Google Calendar.
  • FM Forums Affiliate Sponsors
    • SyncServer Pro by LinearBlue
    • Open Source Frameworks
    • Monkey Bread Software (MBS Plugin)
    • FileMaker Plug-Ins
    • ISO FileMaker Magazine
    • User Group Central - Sponsored by FMPug.com
  • FM Starting Point - By Richard Carlton Consulting
    • Visit FM Starting Point
    • FM Starting Point - General Discussions
  • FileMaker Classifieds
    • FileMaker Product & Service Announcements
    • Professional FileMaker Training
    • Services for Hire
    • Services Wanted
    • Solutions Wanted
    • Tools Of The Trade
  • The Water Cooler
    • Member Lounge
    • Wants & Wishes
  • FM Forums Operations
    • FM Forums Feedback & Site News
    • Site Instructions
  • FileMaker Platform


  • Captain's Blog
  • FileMaker Weetbicks
  • FileMaker Security Blog
  • The FileMaker Rift
  • HOnza's Bits @ FMForums
  • SeedCode
  • CampSoftware, Hal Gumbert
  • FileMaker Hacks
  • Skeleton Key's Blog
  • Wing Forward Solutions
  • 360Works Articles and Tutorials
  • GoBillit
  • Filemaker - an amateur's view
  • Linear Blue
  • Surya Kanta Mekap's Blog
  • eXcelisys' Blog
  • Manjit Behera
  • Blue Feather's Blog
  • RCC's FileMaker News and Bits
  • Thorsen Consulting
  • DB Services Blog
  • FileMaker Magazine
  • Eye on FileMaker
  • Dev Talk
  • The Philosophy of FileMaker
  • Button Bar Icon - Text Alignment Issue


  • Samples
  • Solutions
  • White Papers
  • Plug-Ins
  • FMGo

Found 76 results

  1. I need some help in determining if I am missing something crucial here or if there is a limitation or bug in the function BE_ApplyXSLT from the BaseElements plugin. I am using version 3.3.4 (which is the latest) on Mac OS X 10.11.6 using FileMaker 15 Adv. and 16 Adv. I am unable to get any output from the transformation, nor any error. According to the documentation, the command shall return either 0 when successful or an error. Link In my testing it only returns blank, and gives no error even when no output file is generated. It should not return blank in cany case according to the docs. (I suspect there may be a documentation error and that it actually returns blank when there is no error.) No error is found using Get(LastError). BE_GetLastError returns 0. The function format is this: BE_ApplyXSLT ( xmlPath ; xslt ; outputPath ) Here are the input parameters I have used: BE_ApplyXSLT ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml" ; BE_ReadTextFromFile ( "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl" ); "/var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html" ) I have verified that the files exist and that both the XML and XSLT are valid. All files are in UTF-8. I can transform the XML with this XSLT using other methods without errors. I have also tried having the XSLT in a variable. As I understand it, BaseElements uses the libxml2 engine. I have tried doing the transform from the command line directly and it works as it should: xsltproc -o /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/output.html /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/HTMLvisning/Stylesheet_Full.xsl /var/folders/y6/1yf76qcs5y91h_w4j27hxp980000gp/T/S10.2/ABC_nota_108.xml It also works fine using the XMLLib OSAX in AppleScript. Unfortunately, I need Windows support also so I would like to get the BaseElements function to work. I hope somone can shed some light on what may be going on.
  2. Hi FMForums Community, After exporting PubMed records in XML format (where the default file name is pubmed_result.xml), the first two lines within the file must be removed in order to import pubmed_result.xml into FileMaker (14 Adv, MacOS Sierra) using a custom .xsl file. Within the ArticleIdList subset there is the ArticleId, with multiple IdType. I am including the relevant XML and XSL portions. ---------------- XML <PubmedArticleSet> <PubmedArticle> <PubmedData> <ArticleIdList> <ArticleId IdType="pubmed">27167443</ArticleId> <ArticleId IdType="pii">S1806-37132016000200162</ArticleId> <ArticleId IdType="doi">10.1590/S1806-37562016000000114</ArticleId> <ArticleId IdType="pmc">PMC4853075</ArticleId> </ArticleIdList> </PubmedData> </PubmedArticle> </PubmedArticleSet> ------------------ XSL <COL> <DATA> <xsl:for-each select="PubmedData/ArticleIdList"> <ArticleId> <xsl:for-each select="*"> <xsl:value-of select="." /> <xsl:if test="position()!=last()"> <xsl:value-of select="'&#xD;'"/> </xsl:if> </xsl:for-each> </ArticleId> </xsl:for-each> </DATA> </COL> ------------------- The result I'm getting after importing is: 27167443 S1806-37132016000200162 10.1590/S1806-37562016000000114 PMC4853075 But I would like to include the ArticleId IdType attribute to make it look like this: pubmed: 27167443 pii: S1806-37132016000200162 doi: 10.1590/S1806-37562016000000114 pmc: PMC4853075 In another topic within fmforums.com there was a suggestion to use @ to capture multiple attributes within a subset. Something like: <xsl:value-of select="ArticleId/@IdType" /> What should the xsl contain in order to make pubmed: pii: doi: and pmc: visible? Many thanks in advance. Kind regards, Daniel
  3. MirrorSync.xml import

    Trying to set up mirror sync for the first time using FM15 Pro (Not advanced). I have got past the set up of where the database is, the issue is when I try and set up the , as I don't have Advanced I have to import the MirrorSync.xml file directly, when I click continue I get an error that says, 'XML/XSL information is not enough to proceed with import/export', no matter where I put this file it fails. Any body had this? and what did you do to get round it?, be great if I could get rid of this sooner rather than later.
  4. I am having some trouble getting my XSLT file to work. I have followed many of the posts on here and have referenced https://www.w3schools.com/xml/xsl_intro.asp https://www.w3schools.com/xml/tryxslt.asp?xmlfile=cdcatalog&xsltfile=cdcatalog I seem to be able to get the examples to work and have had success with the example files for metars.cache.xml weather meter readings, but can't see why my own isn't working properly when it looks the same to me. Any guidance would be gratefully received. I am not new to Filemaker but this is my first attempt at importing and exporting data to/from our solution in XML which meets the UK Government standards. My XSLT seems only to match fields but not actually import and records. I have attempted referencing the template match to root with <xsl:template match="/Message"> but this causes an "Invalid Document Structure" error in Filemaker, which doesn't seem to be a problem with the w3schools try xslt page. I have reverted back to the format in the meters.xslt example file and now hope that somebody can help!! metars.cache.xml meters.xslt ILR-99999999-1617-20160229-144401-01.xml ILRLearningDeliveryImport.xslt
  5. Hi I'm trying to develop an interface between my filemaker database and a SOAP service. No where in the wsdl is there any authorisation so I believe I need to send my username and password before the SOAP envelope. I'm trying to do that with Scriptmaster but there are only three input parameters none of which appear useful for generating or inputting the HTTP authorisation Basic that needs to be in place. I can't see the fedex modules which may have had the parameters I needed. Can anybody help/advise or suggest another plugin I should use. Many thanks for reading this.
  6. Hi everyone. Could someone help me? I am so close to having this working and we've spent the last two days trying everything, and we're stumped. We built this xslt template and it's associated xml file... and filemaker opens up like it's all good, allows me to map the fields, all good, then we hit import and it only does one file and there is no data in any of the fields. These two files are the short sanitized version of the data, the original xml has 600 records... but this is exactly the structure, and I'm wondering if anyone can tell us what we are missing.? Again, no data arrives in the record, and it only does one record even thou we have 600. (I know this one will only be a single record). Any guidance from the group would be so appreciated. Thanks. Steve.user-export-short.xslt SteveXML RecordShort.xml
  7. fmresultsetjson.xsl

    Version 1.0.0


    XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl


  8. View File fmresultsetjson.xsl XSLT to convert Filemaker's REST web-service XML response into clean JSON https://twitter.com/alantrewartha 2017-03-06 Adapted from the original Six Fried Rice XSLT here http://sixfriedrice.com/wp/products/filemaker-to-json-converter/ Changed: * single quotes to JSON-standard double-quotes * removed "fieldDefinitions" block (personal preference) * stopped every field value being presented as an [ array ] even when not a "repeating field" * added whitespace escaping code The white-space escaping code was entirely cribbed from https://github.com/doekman/xml2json-xslt/blob/master/xml2json.xsl Submitter AlanTrewartha Submitted 03/06/2017 Category Solutions FM Version FM Version: 0  
  9. I have a xml export via XSLT working successfully to generate the correct XML file. I've noticed the XML file has no indenting which makes it hard to read - I was wondering if there's an easy way to include the indenting in the result xml file as part of the XSL file? Here's what the XML looks like now: <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <item> <title>Slashdot</title> <link>http://slashdot.org/</link> <description>News for Nerds, stuff that matters</description> </item> </channel> </rss> I would like it to look like this: <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <item> <title>Slashdot</title> <link>http://slashdot.org/</link> <description>News for Nerds, stuff that matters</description> </item> </channel> </rss> Here's what the XLS file looks like: <xsl:stylesheet xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.1" exclude-result-prefixes='fmp' > <xsl:output method="xml" doctype-public="rss" doctype-system="http://www.scripting.com/dtd/rss-0_91.dtd" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="fmp:FMPXMLRESULT"> <rss version="0.91"> <channel> <title>Latest News</title> <link>http://localhost/</link> <description>Recent news articles</description> <language>en-us</language> <xsl:for-each select="fmp:RESULTSET/fmp:ROW"> <item> <title><xsl:value-of select="fmp:COL[1]/fmp:DATA" /></title> <link><xsl:value-of select="fmp:COL[2]/fmp:DATA" /></link> <description><xsl:value-of select="fmp:COL[3]/fmp:DATA" /></description> </item> </xsl:for-each> </channel> </rss> </xsl:template> </xsl:stylesheet>
  10. 0x0 - illegal xml character

    LS, Sometimes user copy/paste data from other systems, I guess. Anyway the data in the FM field contains a 0x0 character. Using this character in a xml/xslt exports crashes the export. Anyone have an idea on how to get rid of this character ? ( either fm-script or xslt will do ! ) Thans in advance ! Joost
  11. XML to RDF using XSLT

    I am beginner to xml /rdf /xslt . I have an XML file and want to transform into RDF file using XSLT.i did not get the desired rdf format by xslt file. Please help me to improve my xslt file My XML file is <?xml version="1.0" encoding="utf-8" standalone="yes"?> <Events><Event xmlns='http://schemas.microsoft.com/win/2004/08/events/event'> <System> <Provider Name='Application Hang'/> <EventID Qualifiers='0'>1002</EventID> <Level>2</Level> <Task>101</Task> <Keywords>0x80000000000000</Keywords> <TimeCreated SystemTime='2015-08-08T09:47:28.000000000Z'/> <EventRecordID>3005</EventRecordID> <Channel>Application</Channel> <Computer>AAAA</Computer> <Security/> </System> <EventData> <Data>LiveComm.exe</Data> <Data>17.5.9600.20911</Data> <Data>bd4</Data> <Data>01d0d1be80c57fd9</Data> <Data>4294967295</Data> <Data>C:\Program Files\WindowsApps\microsoft.windowscommunicationsapps_17.5.9600.20911_x64__8wekyb3d8bbwe\LiveComm.exe</Data> <Data>7443f7db-3db2-11e5-8261-a45d36cd4a42</Data> <Data>microsoft.windowscommunicationsapps_17.5.9600.20911_x64__8wekyb3d8bbwe</Data> <Data>ppleae38af2e007f4358a809ac99a64a67c1</Data> <Binary>55006E006B006E006F0077006E0000000000</Binary> </EventData> </Event> My XSLT File is <xsl:transform version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform'> <xsl:template match='Correlation'> <Correlation-patricia> <xsl:apply-templates /> </Correlation-patricia> </xsl:template> <xsl:template match='TimeCreated'> <TimeCreated-patricia> <xsl:apply-templates /> </TimeCreated-patricia> </xsl:template> <xsl:template match='Task'> <Task-patricia> <xsl:apply-templates /> </Task-patricia> </xsl:template> <xsl:template match='Keywords'> <Keywords-patricia> <xsl:apply-templates /> </Keywords-patricia> </xsl:template> <xsl:template match='ErrorCode'> <ErrorCode-patricia> <xsl:apply-templates /> </ErrorCode-patricia> </xsl:template> <xsl:template match='Provider'> <Provider-patricia> <xsl:apply-templates /> </Provider-patricia> </xsl:template> <xsl:template match='Opcode'> <Opcode-patricia> <xsl:apply-templates /> </Opcode-patricia> </xsl:template> <xsl:template match='ProcessingErrorData'> <ProcessingErrorData-patricia> <xsl:apply-templates /> </ProcessingErrorData-patricia> </xsl:template> <xsl:template match='DataItemName'> <DataItemName-patricia> <xsl:apply-templates /> </DataItemName-patricia> </xsl:template> <xsl:template match='System'> <System-patricia> <xsl:apply-templates /> </System-patricia> </xsl:template> <xsl:template match='Security'> <Security-patricia> <xsl:apply-templates /> </Security-patricia> </xsl:template> <xsl:template match='Event'> <Event-patricia> <xsl:apply-templates /> </Event-patricia> </xsl:template> <xsl:template match='Execution'> <Execution-patricia> <xsl:apply-templates /> </Execution-patricia> </xsl:template> <xsl:template match='EventID'> <EventID-patricia> <xsl:apply-templates /> </EventID-patricia> </xsl:template> <xsl:template match='Channel'> <Channel-patricia> <xsl:apply-templates /> </Channel-patricia> </xsl:template> <xsl:template match='Computer'> <Computer-patricia> <xsl:apply-templates /> </Computer-patricia> </xsl:template> <xsl:template match='EventData'> <EventData-patricia> <xsl:apply-templates /> </EventData-patricia> </xsl:template> <xsl:template match='Binary'> <Binary-patricia> <xsl:apply-templates /> </Binary-patricia> </xsl:template> <xsl:template match='Version'> <Version-patricia> <xsl:apply-templates /> </Version-patricia> </xsl:template> <xsl:template match='Level'> <Level-patricia> <xsl:apply-templates /> </Level-patricia> </xsl:template> <xsl:template match='EventRecordID'> <EventRecordID-patricia> <xsl:apply-templates /> </EventRecordID-patricia> </xsl:template> <xsl:template match='EventPayload'> <EventPayload-patricia> <xsl:apply-templates /> </EventPayload-patricia> </xsl:template> <xsl:template match='Events'> <Events-patricia> <xsl:apply-templates /> </Events-patricia> </xsl:template> <xsl:template match='Data'> <Data-patricia> <xsl:apply-templates /> </Data-patricia> </xsl:template> </xsl:transform>kindly help me to convert XML to RDF .....
  12. When exporting XML as fmxmlresult.xml when does FileMaker populate the content of the layout attribute? Usually it looks like <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Yet sometimes it looks like this <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="menu" NAME="Menu.fp7" RECORDS="51" TIMEFORMAT="k:mm:ss "/> Then again when querying the XML RPC it always look like this <datasource database="Menu.fp7" date-format="MM/dd/yyyy" layout="menu" table="Menu" time-format="HH:mm:ss" timestamp-format="MM/dd/yyyy HH:mm:ss" total-count="0" /> Asking the question myself, answering the question myself as well. Checking the following checkbox populates the LAYOUT-attribute of FMPXMLRESULT
  13. Unfortunately, the EXCEL data storage within xml-files is very complex, and as noted by others, it is virtually impossible to handle complex (and even very simple) data without the program EXCEL itself. I just discovered a new CAVEAT relating to the scribe plugin. Reading an EXCEL document with ScribeDocReadValue(), real numbers are always returned as 'integer string' without comma, and it seems impossible to get a meaningful value out of this. '29.84' -> 2984, '2984' -> 2984 (nothing to say about '2.3' -> 22999999999999998, etc.). Although not documented, I tryed to address the field with a name ('Bill') instead of a cellcode 'C14'. Interestingly, this returned no error, if the name was defined in EXCEL, but a null (empty) value! Next try. The Excel calculation =TEXT(C14,"standard") returns the real number in a beautiful text format. However, scribe returns ERROR: Scribe returns ERROR for a any Text calculations, e.g. for 'C15' = 'Jane'; 'C16'= '=C15', ScribeDocReadValue ('C16') = ERROR. Probably scribe just can NOT access the 'SharedStringTable', nor any other secondary source tables (– this has other bad effects. If you write any values to an Excel 'fill down' range with Scribe (that is, through the backdoor), Excel will never recognize and evaluate these values correctly, etc. etc.) What about the real numbers, then? I only found one solution: Defining an additional cell with a calculation like 'C16'= ROUND(('C14'+1000)*10000000000000,0), or (more generic) defining TWO additional fields calculating the INT and MOD part of the number. What an abonimably atrocious workaround! However, I really wonder WHERE the 'comma' position is stored in xlm-EXCEL, and, eventually, if you guys at 360works may plan to retrieve this information in a next version. That would be great! Thanks Markus @Excel for Mac 2011, v14.3.6, OS X 10.8.4, Java 7 25 (Build 1.7.0_25-b15), FM 12.0v4 Adv, 360Works Scribe v1.262
  14. Import XML file

    Attention: Before posting in the general discussion forum please review the other forums that would best suit your topic. If you cannot find one then you may delete this text and post your topic in this forum. Hi all, I need to import into filemaker table an XML file as this: <?xml version="1.0" encoding="utf-8"?> <Account> <Field APIName="WrntyID">6029065</Field> <Field APIName="ExternalID">1761A</Field> <Field APIName="Name">sayIT SA</Field> </Account> now I'am trying to create the xls file. This is my xls file.... <?xml version='1.0' encoding='UTF-8'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="WrntyID" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ExternalID" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Name" TYPE="TEXT"/> </METADATA> <RESULTSET> <ROW> <COL> <DATA><xsl:value-of select=“Account/Field[1]" /></DATA> </COL> <COL> <DATA><xsl:value-of select=“Account/Field[2]” /></DATA> </COL> <COL> <DATA><xsl:value-of select=“Account/Field[3]” /></DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> This instruction <xsl:value-of select=“Account/Field[1]"/> doesn't work. What is the right syntax to retrive the value of the first TAG FIELD? Then the second end so on...? Many thanks Anna
  15. Apparently, I deleted my original post. Beverly said I should, "update with any auto-entered FM primary key into the child foreign key via the temporary relationship" I am thinking this is correct but have never done this before. Can someone help me understand how to do this? Here is a simplified version of my xml: <!-- some of the data from the attribute tags goes in the Claim table --> <result check_number="01574380" eraid="2182629" paid_amount="34.00" paid_date="2016-02-05" payer_name="" payerid="" prov_name="" prov_npi=""> <!-- some the data from the attribute tags goes in the Claim table --> <claim from_dos="20160201" pat_name_f="BARNEY" pat_name_l="RUBBLE" pat_num="38170" prov_npi="" total_charge="200" total_paid="20"> <!-- some the data from the attribute tags goes in the Line Items table --> <charge charge="200" chgid="71245" from_dos="20160201" paid="20" proc_code="92004" thru_dos="" units="1"> <adjustment amount="160" code="45" group="CO" /> <adjustment amount="20" code="3" group="PR" /> </charge> <claim " from_dos="20160201" pat_name_f="BAM BAM" pat_name_l="RUBBLE" pat_num="38171" total_charge="720" total_paid="11"> <charge charge="150" chgid="71248" from_dos="20160201" paid="11" proc_code="76514" thru_dos="" units="1"> <adjustment amount="139" code="45" group="CO" /> </charge> </claim> </result> Here are the tables I am working with Patient table patient_number - ties to transaction and claims tables Claims table patient_number invoice_number - ties to transaction table Trans patient_number invoice_number - ties to claims table and line items table Line items table invoice number - ties to transaction table I will only be updating existing records not creating new ones. Oh, I can use the patient_number as a match key in the claims table but don't know how to import into the line items table using the method Beverly described. Sorry if this doesn't make sense. I am still learning about Filemaker and relational databases.
  16. Help with XML stylesheet?

    I have been given the task of trying to import our postal information which we receive as XML files into Filemaker. I've been searching the forums for the last few days and I've found several examples which I've tried to build off, but I'm still not doing something right. We have no experience working with XML files so I can't quite figure out where I'm going wrong. When I try to import my XML file into Filemaker using the stylesheet I created, It looks like all the fields are mapping right, but I don't get data in any of the fields. I get the following pop up message: This is the stylesheet I have built so far, the sample XML data we were provided is attached. Can anyone point me in the right direction as far as what my problem is and what I need to fix? As an aside, I know I have the CustomerReferenceID field importing twice. Given the sample data we received we're not quite sure which fields we will actually need to import so I'm using one of those entries as a placeholder. <?xml version="1.0" encoding="UTF-8"?> <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="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/> <!-- DEFINE FIELDS --> <METADATA> <FIELD NAME="Mail Date" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Customer Reference ID" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Job Description" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Permit" TYPE="TEXT" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Total Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Postage Affixed" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Net Postage" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Quantity" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Affixed Amount" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> <FIELD NAME="Metered-Stamped" TYPE="NUMBER" EMPTYOK="YES" MAXREPEAT=""/> </METADATA> <!-- IMPORT DATA --> <RESULTSET FOUND=""> <xsl:for-each select="PostageStatement"> <ROW MODID="" RECORDID=""> <COL><DATA><xsl:value-of select="ClosingDate"/></DATA></COL> <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL> <COL><DATA><xsl:value-of select="CustomerReferenceID"/></DATA></COL> <COL><DATA><xsl:value-of select="PermitNumber"/></DATA></COL> <COL><DATA><xsl:value-of select="TotalUSPSAdjustedPostage"/></DATA></COL> <COL><DATA><xsl:value-of select="PostageAffixed"/></DATA></COL> <COL><DATA><xsl:value-of select="NetPostageDue"/></DATA></COL> <COL><DATA><xsl:value-of select="TransactionAmount"/></DATA></COL> <COL><DATA><xsl:value-of select="RatePostageAffixed"/></DATA></COL> <COL><DATA><xsl:value-of select="PermitType"/></DATA></COL> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> xml.zip
  17. Hi everyone, I am new here. I just began working with a project that has been using FileMaker Server 9 and Pro 9. The current architecture uses one machine deployment but the machine is quite ancient and doesn't support any micro-frameworks that eases my web development duties. I wanted to split this architecture to a multi machine deployment this ancient machine having only the Database, another better machine having a webserver and/or a web publishing engine. The reasoning behind this being that I can use a webserver(Gunicorn + Flask) and use PyFileMaker to obtain my data from the DB using XML. I, however, realize that the web publishing engine is required at the database to publish my XML data which in turn requires a web server running(apache). This goes back to the same one machine deployment. Am I missing a point here? Thank you so much for taking your time to read this. It would be truly awesome if you could help me with this question. Thank you once again and have a good day. Regards, Arjun
  18. Hey Guys , I've been going crazy trying to get this work, but just don't know what I'm doing wrong... This is the xml exported from FM Pro v14 <?xml version="1.0" encoding="utf-8"?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="10-26-2015" NAME="FileMaker" VERSION="ProAdvanced 14.0.4" /> <DATABASE DATEFORMAT="D/m/yyyy" LAYOUT="" NAME="TEST_v02.fmp12" RECORDS="2749" TIMEFORMAT="h:mm:ss a" /> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Shot" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="ShotInCut" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LustreSrcINFrame" TYPE="NUMBER" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LustreSrcOut" TYPE="NUMBER" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LustreStart" TYPE="TEXT" /> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="LustreEnd" TYPE="NUMBER" /> </METADATA> <RESULTSET FOUND="4"> <ROW MODID="0" RECORDID="22355"> <COL> <DATA>abc0198</DATA> </COL> <COL> <DATA>abc0198_cpa_v090_ww_v002</DATA> </COL> <COL> <DATA>1016</DATA> </COL> <COL> <DATA>1076</DATA> </COL> <COL> <DATA>98471</DATA> </COL> <COL> <DATA>98531</DATA> </COL> </ROW> <ROW MODID="0" RECORDID="22357"> <COL> <DATA>abc0198</DATA> </COL> <COL> <DATA>abc0198_cpa_v090_ww_v002</DATA> </COL> <COL> <DATA>1016</DATA> </COL> <COL> <DATA>1052</DATA> </COL> <COL> <DATA>98569</DATA> </COL> <COL> <DATA>98605</DATA> </COL> </ROW> <ROW MODID="0" RECORDID="22359"> <COL> <DATA>abc0198</DATA> </COL> <COL> <DATA>abc0198_cpa_v090_ww_v002</DATA> </COL> <COL> <DATA>1016</DATA> </COL> <COL> <DATA>1057</DATA> </COL> <COL> <DATA>98630</DATA> </COL> <COL> <DATA>98671</DATA> </COL> </ROW> <ROW MODID="0" RECORDID="22608"> <COL> <DATA>xyz0570</DATA> </COL> <COL> <DATA>xyz0570_cpa_v0008</DATA> </COL> <COL> <DATA>0</DATA> </COL> <COL> <DATA>26</DATA> </COL> <COL> <DATA>111424</DATA> </COL> <COL> <DATA>111450</DATA> </COL> </ROW> </RESULTSET> </FMPXMLRESULT> This is the XLST I Made: <?xml version='1.0' encoding='utf-8'?> <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> <xsl:template match="FMPXMLRESULT"> <xsl:for-each select="RESULTSET/ROW"> <clipitem> <name> <xsl:value-of select="COL[2]/DATA" /> </name> <in> <xsl:value-of select="COL[3]/DATA" /> </in> <out> <xsl:value-of select="COL[4]/DATA" /> </out> <start> <xsl:value-of select="COL[5]/DATA" /> </start> <end> <xsl:value-of select="COL[6]/DATA" /> </end> <file> <name> <xsl:value-of select="COL[2]/DATA" /> </name> <pathurl>"filepath"</pathurl> <timecode> <rate> <timebase>24</timebase> </rate> <string>00:00:00:00</string> <frame>0</frame> <displayformat>NDF</displayformat> <source>source</source> <reel> <name> <xsl:value-of select="COL[1]/DATA" /> </name> </reel> </timecode> </file> </clipitem> </xsl:for-each> </xsl:template> </xsl:stylesheet> This is my result: <?xml version="1.0" encoding="UTF-8"?>0abc0198abc0198_cpa_v090_ww_v002101610769847198531abc0198abc0198_cpa_v090_ww_v002101610529856998605abc0198abc0198_cpa_v090_ww_v002101610579863098671xyz0570xyz0570_cpa_v0008026111424111450 This is what the result should look like: <clipitem> <name> abc0198_cpa_v090_ww_v002 </name> <in> 1016 </in> <out> 1076 </out> <start> 98471 </start> <end> 98531 </end> <file> <name> abc0198_cpa_v090_ww_v002 </name> <pathurl>"filepath"</pathurl> <timecode> <rate> <timebase>24</timebase> </rate> <string>00:00:00:00</string> <frame>0</frame> <displayformat>NDF</displayformat> <source>source</source> <reel> <name> abc0198 </name> </reel> </timecode> </file> </clipitem> <clipitem> <name> abc0198_cpa_v090_ww_v002 </name> <in> 1016 </in> <out> 1052 </out> <start> 98569 </start> <end> 98605 </end> <file> <name> abc0198_cpa_v090_ww_v002 </name> <pathurl>"filepath"</pathurl> <timecode> <rate> <timebase>24</timebase> </rate> <string>00:00:00:00</string> <frame>0</frame> <displayformat>NDF</displayformat> <source>source</source> <reel> <name> abc0198 </name> </reel> </timecode> </file> </clipitem> <clipitem> <name> abc0198_cpa_v090_ww_v002 </name> <in> 1016 </in> <out> 1057 </out> <start> 98630 </start> <end> 98671 </end> <file> <name> abc0198_cpa_v090_ww_v002 </name> <pathurl>"filepath"</pathurl> <timecode> <rate> <timebase>24</timebase> </rate> <string>00:00:00:00</string> <frame>0</frame> <displayformat>NDF</displayformat> <source>source</source> <reel> <name> abc0198 </name> </reel> </timecode> </file> </clipitem> <clipitem> <name> xyz0570_cpa_v0008 </name> <in> 1016 </in> <out> 1057 </out> <start> 98630 </start> <end> 98671 </end> <file> <name> xyz0570_cpa_v0008 </name> <pathurl>"filepath"</pathurl> <timecode> <rate> <timebase>24</timebase> </rate> <string>00:00:00:00</string> <frame>0</frame> <displayformat>NDF</displayformat> <source>source</source> <reel> <name> xyz0570 </name> </reel> </timecode> </file> </clipitem>
  19. I have a client that would like to use MS Access to connect to a table in a solution hosted on FMS 14.0.3. What I'm reading suggests that was possible with .fmp5 and .fmp7 but is no longer available in .fm12. I've tried to use Access and both (mac) Excel and (windows) Excel to connect via ODBC to the FMS hosted table and I can construct the query and see the fields, but when I submit the request I get an error. Is it still possible to connect Excel or Access to FileMaker 14.0.3 (hosted)? The error I get appears on the attached screenshot. Is anyone currently doing this? Thank you in advance.
  20. Hi i made a export from my calculated xml data. Using a simple stylesheet to export my calculated field and clean up the FMP xml code. <?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="fmp"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes"/> <xsl:template match="/"> <xsl:value-of select="." disable-output-escaping="yes" /> </xsl:template> </xsl:stylesheet> I only need 1 field to be exported. That contains all my xml data. When it is done, in the xml the xml start with a 0. Therefore the xml is not working. It is my first xml export project. What do i do wrong ?
  21. A client of mine wants to tie their solution to Converge (https://www.myvirtualmerchant.com/VirtualMerchant/). They offer an XML option, so it look feasible, but I was wondering if anyone else has tied a Filemaker solution to Converge's API? Also, with the new EMV Chip Cards, does anyone recommend any particular payment gateway for Filemaker? Or do the new chip cards not affect anything? Any and all info about payment API's most welcome. FM Pro and Server 14, Mac OS X environment. Thanks!
  22. 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>
  23. I need some help importing a RSS 2.0 XML into FileMaker Pro Adv 10. I'm trying to modify a xslt file that came with FM. When I use this xslt it tries to map the parent Recipients and not the child Recipient. I'm stuck and could use a hand. Any thoughts on what to modify or add would be much appreciated? Here is the xlst: <?xml version="1.0" encoding="UTF-8"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0"> <!-- File: msdso_elem.xslt Transforms data in an ELEMENT based MSDSO grammar into the FMPXMLRESULT grammar, suitable for import. =============================================================== Copyright © 2002 FileMaker, Inc. All rights reserved. Redistribution and use in source and binary forms, with or without modification, are permitted provided that the following conditions are met: * Redistributions of source code must retain the above copyright notice, this list of conditions and the following disclaimer. * Redistributions in binary form must reproduce the above copyright notice, this list of conditions and the following disclaimer in the documentation and/or other materials provided with the distribution. * Neither the name of the FileMaker, Inc. nor the names of its contributors may be used to endorse or promote products derived from this software without specific prior written permission. THIS SOFTWARE IS PROVIDED BY THE COPYRIGHT HOLDERS AND CONTRIBUTORS "AS IS" AND ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE COPYRIGHT OWNER OR CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF ADVISED OF THE POSSIBILITY OF SUCH DAMAGE. =============================================================== --> <xsl:template match="/*"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="" VERSION=""/> <DATABASE DATEFORMAT="M/d/yyyy" LAYOUT="" NAME="" RECORDS="{count(/*/*)}" TIMEFORMAT="h:mm:ss a"/> <METADATA> <xsl:for-each select="/*/*[position()=1]/*"> <FIELD> <xsl:attribute name="EMPTYOK">YES</xsl:attribute> <xsl:attribute name="MAXREPEAT">1</xsl:attribute> <xsl:attribute name="NAME"><xsl:value-of select="name()"/></xsl:attribute> <xsl:attribute name="TYPE">TEXT</xsl:attribute> </FIELD> </xsl:for-each> </METADATA> <RESULTSET> <xsl:attribute name="FOUND"><xsl:value-of select="count(child::*)"/></xsl:attribute> <xsl:for-each select="child::*"> <ROW> <xsl:attribute name="MODID">0</xsl:attribute> <xsl:attribute name="RECORDID">0</xsl:attribute> <xsl:for-each select="child::*"> <COL> <DATA> <xsl:value-of select="."/> </DATA> </COL> </xsl:for-each> </ROW> </xsl:for-each> </RESULTSET> </FMPXMLRESULT> </xsl:template> </xsl:stylesheet> Here is the XML: <?xml version="1.0" encoding="utf-8"?> <rss version="2.0"> <Recipients> <Recipient> <First_name>Adam</First_name> <Last_name>Smith</Last_name> <Address1>123 main street</Address1> <Address2 /> <City>Lakewood ranch</City> <State>NY</State> <Zip>10012</Zip> <Country>USA</Country> <Cust_Phone>941-555-1212</Cust_Phone> <Company_name /> <L_num>Z3116-01</L_num> <Qty>50</Qty> <Promo>G147571</Promo> <Toll_num>1-888-238-0030</Toll_num> <email>sample@aol.com</email> <email2>bobjones@adt.com</email2> <repName /> <repPhone /> <CustomText>Adam Smith</CustomText> <IntOrderId>230839</IntOrderId> <OrderDateTime>2015-10-07 14:26:44</OrderDateTime> </Recipient> </Recipients> </rss>
  24. Hello, all. As most developers know, FileMaker stores a lot of its code pieces in XML snippets. I wanted to see and store these XML snippets so I have created a simple FileMaker app for doing so. Check out my latest blog post at http://iamandrewdavis.com/index.php/2015/09/01/filemaker-code-storage/ to see what I have done. In my sample app, you can scrape FileMaker's internal XML from the clipboard and store it in a table. It's a great way to store scripts, tables or layout objects. If you have any problems, let me know in the comments.
  25. LS, We currently have this worker machine running, but I want to get rid of it. The worker runs a FM-script every 5 mins and exports some data, which is then uploaded to an ftp server and then processed by the website. The script does several xml-exports. It starts by searching for certain products , then it exports the data to and xml file ( xml-result ). After that is does a go-to-related script-step ( matching all records ) to commercial descriptions of the products and then exports this data as an xml file. We go back to the found set of products and then repeat the proces for more related product data. As said, all data is exported and the uploaded to an ftp-server. Preferably I would like to keep the xml-result structure of the data as the website is already familiar with this structure. How do I go about doing this migration. I was able to perform an xml-query and get my result. The thing is : how do I proceed with these goto-related records finding ? Or should I just go with PHP ? Much thanks in advance !

Important Information

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