XML/XSL

Hi, Using Insert from URL, the result can be: 1. Downloaded as text into a text field (in XML format). 2. Downloaded as a text file into a container field, also in XML format, with a generic file name (efetch.fcgi). The tricky part is that the second line contains the DOCTYPE. When FileMaker reads this line, it spends up to twenty seconds there, and then progresses with the script. As there are many XSLTs, FileMaker reads the DOCTYPE that many times, extending the entire process to way over 3 minutes or so. If I manually remove the second line, the entire processing time goes down to the expected 1-2 seconds in total. In 1., I've commented out …

I seems to remember that Matt Petrowski had a video where he "flattens" layout elements for faster rendition .... Is this what you use? --sd

Hi, Just venting my frustration when trying to do the following: ------------ 1. Menu File Export Records 2. Export Records to File Type: XML 3. Save 4. Specify XML and XSL Options Grammar: FMPXMLRESULT or FMPDSORESULT Use XSL style sheet File HTTP request Continue --------------- If FileMaker already has everything it needs to build a generic XSL for the exported XML file, why isn't there an option for it? In fact, it would be much easier to have an 'XSL style sheet Builder' in Dialog Window 'Specify XML and XSL Options', should anything in the generic XSL file need to be tweaked fu…

Hi, fmforums team, I have an xml with two components: Descriptor and Substance. One Descriptor can contain many substances, yet, when I import using the Substance.xsl, it imports only the first substance for each Descriptor. How do I tell the .xsl to import the substances recursively? I'm including the following files: .xsl .xml .dtd (empty) .fmp12 Thank you,Pharmacological action.zip Daniel

Hi FMForums, I import one PubMed XML nine times, each time with a different XSL file, in order to capture all of the available content into it's corresponding fields and tables. Yet, it's very tedious to run nine imports. I'm thinking that perhaps there's a way of telling FileMaker which XML is going to be imported and then loop the import with each XSL. Can this be handled with a script? What would that script be? Very kind regards, Daniel

I'm working on a way to get shipping rates, create shipments, and download shipping labels, and manifests, from CanadaPost, using REST and the MBS plug-in. I'm new to certificates and REST so this is extra fun! I've tested a CanadaPost REST example request in SoapUI and got it to work. I'm now trying to replicate this within my FMP test file, but its not quite exactly the same as in SoapUI (I'm not seeing cacert.pem being used by SoapUI), and I'm getting an error: <?xml version="1.0" encoding="UTF-8"?> <messages xmlns="http://www.canadapost.ca/ws/messages"> <message> <code>415</code> <description>Backend Unsupported Media …

Hey All, I know that I need an XSLT to transform the XML output from FMS to generate an RSS feed, but I'm not sure where to start. Does anyone have a pointer on either a template to use or a site to learn how to write the XSLT to generate the RSS? ---Backstory--- I need to generate an RSS feed of products to be ingested by a 3rd party application. Thanks in advance.

Hi I trying to export a record in XML that also contains a portal with multiple records. When I view the exported XML file the main record is complete but only the first entry in the portal is exported. My question is it possible to achieve this in Filemaker and if so what do I need to change on my XSL file. The portal fields are: <FruitSpecs> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <Fruit> <Name><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></Name> <Qty><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></Qty> …

I'm trying to import an XML with the XSL, but it's not working. I'm not exactly sure what my issue is.. let alone if what I'm trying to do can even work with style of XML. Currently I've been using xpath to loop thru and get all the records but due to the large number of records this can take a very long time I've attached the example xml and xsl. Inventory.xsl Inventory.xml

Dear helpers, I managed to write an XSLT for an export job out of FMP a few years ago, thanks to Beverley's book and a lot of patience. It's been working without fail ever since! Now I need to import an XML file in to FMP 18 with FMPXMLRESULT, using Oxygen 9 to test the XSL product. I have multiple issues. I would like to start with the seemingly simplest. In an example of xml <a> <b> <c> <c1></c1> <c2></c2> </c> </b> </a> I feel I should be able to navigate to my node of interest by writing eg <xsl:for-each select="a/b/c/c2"> but th…

Hi all I am interested to know if there's any suggested reading and/or viewing that can help me achieve the following. I have a webrelay device on my network that controls a magnetic door lock. The device supports XML and HTTP GET requests. I have created a basic map of the property in filemaker and want to use a button to toggle the control the relay (thus locking or unlocking the door) and return the device status'. Conditional formatting will indicate whether the lock is energized or not, with a separate field indicating whether the door is closed (inputstate). The XML (state.xml) file on the device is as follows... <?xml version="1.0" encoding="utf-8…

Hi, How can I make use of <OtherAbstract Language="spa"> and <OtherAbstract Language="por"> in the XSL to specify the (OBJECTIVE, METHOD, RESULTS, CONCLUSIONS) fields to import? Here is a snippet of the Pubmed XML: ----------------------------------- <PubmedArticleSet> <PubmedArticle> <MedlineCitation Status="MEDLINE" Owner="NLM"> <Article> <Abstract> <AbstractText Label="OBJECTIVE" NlmCategory="OBJECTIVE">to describe...</AbstractText> <AbstractText Label="METHOD" NlmCategory="METHODS">descriptive correlational...</AbstractTe…

Hi. trying to setup an automated workflow which would pull info from a FM document and create a properly named folder on a data server which would than have automated scripts for subfolders. a coworker setup a FM document for his needs and I would not like to duplicate efforts. I need to ID the fields he made so I can take the data from each named field and send it into a workflow. He exported an XML file for me, however, the fields he named do not keep the name, it keeps the data I want but I cannot isolate it. here is sampling of XML export: <COL><DATA>WE to produce. ETA TBD</DATA></COL> <COL><DATA>F_CCDL-01247-3…

When I'm exporting an xml from a script thats running on a Windows server it's adding <CR><CR> after each line. It's not doing that when I export it local on OS X. I'm using the same XSL. Any clue? Thanks

Hey Folks, I just barely have started getting into this stuff, and I took on two projects simultaneously; one XML from MS Access and one XML from FMP. One of the tricky things is I am also using a script to make 20 (or more) pages from a template page to import into, for both projects. The MS Access import I have working beautifully, everything goes where I want it. FMP not so much. In order to get the script to work, I had to have a "flat" XML, so I have used the FMPDSORESULT method. What happens is that after the first page on the import, my nodes get out of order and there are blank text frames and everything gets spread further and further apart over s…

Hello, am I getting desperated time is running and I need to send a XML to the finance department, encrypted with public/private key. I have got both keys, and the XML File. I can find how do I lock the XML file using public/private key? Please any tip will be welcome.

Hi, I am totally new in xslt. I have the following xslt and I tried to export as xml. I got an error. "SAXParseException: invalid document structure". Is there a problem in my structure? What's the proper structure? <?xml version='1.0' encoding='UTF-8' ?> <xsl:stylesheet version='1.0' xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns:fm="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fm"> <xsl:output version='1.0' encoding='UTF-8' indent='yes' method='xml' /> <xsl:template match="/"> <cityforcast> <xsl:for…

I've got a simple ( I hope) export as xml issue Here is my current .xsl that is erroring.. My issue is Line 9.. I'm not sure how I need modify the Attribute of Pages? <?xml version="1.0"?> <xsl:stylesheet xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" xmlns:xalan="http://xml.apache.org/xalan" version="1.0" exclude-result-prefixes="fmp xalan"> <xsl:output method="xml" version="1.0" encoding="UTF-8" indent="yes" xalan:indent-amount="2"/> <xsl:template match="/"> <JDF xmlns="http://www.CIP4.org/JDFschema_1_1" Status="Ready" Type="ProcessGroup" Version="1.2"> <ResourcePool>…

I have an rss feed that returns data like this: 2009 LLCs, Corporations, & Business Legal Updates 2009 Personal Finance Legal Updates 2010 LLCs, Corporations, & Business Legal Updates 2010 Personal Finance Legal Updates 2011 Personal Finance Legal Updates 2012 Wills, Trusts, and Estates Legal Updates If I click on one of the links I can see the XML. I need to import all of the XML into my database. I have done XML/XSL imports before, but it is throwing me off because of the RSS List. How do I go about this? Right now I do a copy/paste on view source, put all of that into Notepad++ and then scrub the data. I use that for an import into a Filem…

Hi Im looking at importing xml sheets into a database that gets generated by a digital platemaking machine after each cast is run. I would like the FM import to generate a new record for every Name element but each record must contain the Job and Plate element information as this stays the same for each cast run. Is it possible to use these xml sheets as they are or would they need changing. also does anyone one have a example I can look at to understand how it needs to be set up to import into FM RUN71-60X50-155DLC-PRIORITY16.xml RUN73-80X50-155FSC-PRIORITY17.xml RUN75-80X50-125FSC-PRIORITY18.xml RUN76-80X50-125FSC-PRIORITY18.xml XML.fmp12

I'm very very very newbie on xml. What I need to understand is if it's possibile export in this way. I use a xsl stylesheet to export from FM. I was able to use the <xsl:for-each to export details in the way I want: <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <Details> <Code><xsl:value-of select="fmp:COL[2]/fmp:DATA"/></Code> <WTN><xsl:value-of select="fmp:COL[3]/fmp:DATA"/></WTN> <Date><xsl:value-of select="fmp:COL[4]/fmp:DATA"/></Date> result: <Details> <Code>0280c1&l…

The attached XML file works fine as a 'file' import. But when importing via http (using the same XSLT file), the import gets a parsing error. The xml file and the parsing error description are attached. What's different when importing via http vs. a file import? Where/what is the expected 'white space' when doing the http import? RM5currentRelease.xml

I've attached two files. The first one is INVOICE, that is generated by every establishment when you purchase, and is in xml format. The second one is XSLT file, that is provided by government fiscal institution and is used to "translate" xml. PROBLEM DESCRIPTION: when I try to decode xml using attached xslt scheme on any online xml-converter website the output looks fine. BUT when importing to Filemaker, I receive an error: "XML parsing error: invalid document structure". I would appreciate any help with the issue. Thanks. XML input.xml XSLT scheme.xslt

Hi Im after a bit of help please I have a small test database that I'm trying to figure out if its at all possible to export a single xml file to give me a result like this: <?xml version="1.0" encoding="UTF-8"?> <JOB> <PrimaryKey>88B2BDCE-A0B2-41EB-B190-0480DF3AD6A9</PrimaryKey> <WTN>3453</WTN> <Customer>Bosch</Customer> <Colours1>Red</Colours1> <Colours2>Blue</Colours2> <Colours3>Yellow</Colours3> <Colours4>Green</Colours4> <Colours5>Pink</Colours5> </JOB> everything is working correctly apart from the Colours fiel…

Dear all, I've just create a script to export my records in multiple xml file (one xml for each record) applying also an XSL stylesheet. So, if I use the style.xsl taking from my computer ("source" button when filemaker ask me to select the file) it works. If I put the same file online, it doesn't work giving me a SAXParseException error: internal error in NetAccess (occurred in an unknown entity, at line 0, column 0). In the same folder where I have the style.xsl there are other xsl files that works, but they are used to "import" process (from XML to FILEMAKER, while in this case I'm working to an export process, from FILEMAKER to XML, I don't know if this coul…

Hi all, I'm completely new to XML and I'm making an XLST for an XML feed into my Filemaker database. Surprisingly, I got the basics down rather fast, but I'm really stumped on a few fields. See attached XLST, sample dataset and Filemaker test database. Referencing the XSLT metadata, the import works perfectly fine for the nodes named 'titleId' down through 'dealType' as well as the nodes under 'licensingWindow'. However I can't seem to get the values of a few other nodes. The trouble for me is that the nodes are nested in as child nodes that aren't named uniquely and I just can't figure out how to get their values. Example: <titleListingTe…

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

Hi All, Happy Sunday! I'm trying to build a layout that contains 5 containers so my employees can drag and drop XML files into each container and then I can run a script to export those XML files and import them into my filemaker database. I'm struggling to get the data exported from the containers and imported back. What is the best way to do this? Export container via $path then import $path file? Thank you so much in advance.

I'm doing an export of a table with 5 fields to an Excel file with an XSL stylesheet to control the formatting of the Excel data. So far it's working well - I just need to add some additional formatting for a few of the cells. I'm looking for help with examples/syntax for setting the following attributes: - making a cell bold - changing the font size of a cell - making all columns set to auto resize so they fit the contents of each column (same as double clicking the divider between 2 columns) All fields I'm exporting are text fields. Thanks, Steve

Hello, I've done quite a bit with FileMaker in the past, but have never jumped into the XML arena. Now I have a need to do so, and I'm really needing some help with something I'm sure is quite basic...but still foreign to me. I have an external data source which export XML in a very specific format (see attached). I need to import that into FileMaker so I can manipulate the data, do some various lookups, etc. Once I've made my changes in the data, I need to export in the exact format it was when imported so the external data source can properly import. Not sure if it makes sense to import into 2 tables (workflows, workflow steps) or just a single table. I'm open…

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"&g…

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 XS…

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…

Hi, I want to import some xml into FM via an xslt. I've done this lots of times, but setting up this particular xslt is giving me fits. Can anyone help me out? What I want is for each DataRow to be a record. Each ColData should be a particular field. When I perform the import using the xslt that I've got, it imports the right number of records, but all of the fields are empty. I think the problem is in the way each ColData element has a colID value. I've never seen it set up this way before, and that's probably where I'm going wrong. How do I get each of these to be a field? How do I deal with the fact that each row doesn't always have a value for al…

Good afternoon everyone. I need to open a .xlsx file by pressing a button I have tried with a script, where I establish a variable $ filename = e: \ Works \ Josram \ Presup \ AAVSA \ slopes 345 7 Apr 14.xlsx And using the command "Send DDE Execute" The service name = "c: \ Program Files \ Microsoft Office \ Office16 \ Excel.exe" But when you run it, it just does nothing Can someone tell me that I'm doing wrong? I don't need to import o export a file. I only need, when i click a button Excel runs and open the .xlsx file Thanks in advance regards Pedro

This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to sitemap and vice-versa. https://github.com/TyrfingMjolnir/fmpxmlresult2sitemap

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&…

fmpxmlresult2nodeexpress This is an XSLT stylesheet to convert from FileMaker's fmpxmlresult to JSON route node for ExpressJS, no records involved. Fieldnames as parameters; use a layout to limit the amount of fields used. I used a slightly modified version of this script to generate 280 nodes in the same API. When it comes to naming of the API I always use singular for nodes that are able to manipulate data, and plural for reports that risk responding with more than 1 record. car by :id will usually have full CRUUx/CRUD implementation and return 0 or 1 items http://localhost/api/car/1234 Showing which cars are parked in a…

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</EventReco…

I am not so good in making XSLT files, maybe someone can help me to translate the file below to filemaker 9 or know where i can find information how to do this file. <?xml version="1.0" encoding="utf-8"?> Edinburgh University Press y.y x.x 20090618 eng T40 02 02 0748621237 03 9780748621231 15 9780748621231 BB Traditions in World Cinema 01 African Filmmaking North and South of the Sahara 1 A01 Armes, Roy Prof. Roy Armes Emeritus Professor of Film Middlesex University

https://github.com/TyrfingMjolnir/FMPXMLRESULT2psqlCOPY

https://github.com/TyrfingMjolnir/fmpxmlresult2SwiftyJSONModel

https://github.com/TyrfingMjolnir/fmpxmlresult2xcdatamodel

Hi there, I tried to import data from an xml into Filemaker using an xsl. It work fine with most of the variables, however I could not master to import all subsets of the abstract, which is organized like this in the xml: <Abstract> <AbstractText Label="BACKGROUND" NlmCategory="BACKGROUND"> </AbstractText> <AbstractText Label="METHODS" NlmCategory="METHODS"> </AbstractText> <AbstractText Label="RESULTS" NlmCategory="RESULTS"> </AbstractText> <AbstractText Label="CONCLUSIONS" NlmCategory="CONCLUSIONS"> </AbstractText> <Copyrigh…

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:style…

I'm having trouble importing a file which has the odd double quotation mark dotted around the xls file. eg T-shirt, "logo" (M). The quotation mark messes up the import and I've tried using Substitute (field;["\"";""];["( ";"("];[") ";")"];[" ";" "];[" ";" "];[".";""];[",";""];["-";" "];[".";" "] etc) but it deletes everything between the quotation marks - I just want the marks removed. Obviously, I can do find/replace in the spreadsheet but I would like to do this on import and in case I forget. I have looked around at this without much luck. Also, worth noting that I have another field in the spreadsheet which has lots of quotations because the contents are mad…

http://jensteich.de/fmfaq/export/xslt-for-simple-cases/ <!-- xslt stylesheet importing xml data into FileMaker for easy cases like: <root> <record> <field1>....</field1> <field2>....</field2> <field3>....</field3> <... any number of fields ... </record> ... any number of records 'root', 'record', 'fieldx' can be any names. ~jens

I'm using &#0x0D; and &#0x0A; for CR/LF in a script for export in CSV-format which is to be imported in a Windows based system. The receiver on the other side of the fence tells me that these codes are wrong. His best guess are &#xD; and &#xA; but everything is open for other suggestions. When my CSV are opened in Excel Win there are double LF. I encolse a copy of the file. Mac with El Capitan and Filemaker 11 Pro Advanced 11.0v4. My current script: <?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"> …

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 i…

I'm a complete n00b (and probably stay a n00b because I don't use it very often) in creating a xsl file to use for creating a very simple xml file by making an export from Filemaker to xml. But I found a sample file and changed this file a bit to get what I need. I only have one issue I can't figure out hou to fix. This is the xsl I use; <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fm="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fm"> <xsl:output method="xml" indent="yes"/> <xsl:variable name="rename"> <item from="EAN" to="EAN"/> <item from="Internal_Re…

Hi all, I have modified a solution I found in these forums to put together this StylesheetZD2.xsl to extract data from the attached input file AUSdelta152761211111.xml (onix), but I am having trouble figuring out how to import data from a repeating field. For example, with this stylesheet I can only extract the first "contributor" <COL><DATA><xsl:value-of select="contributor/b035"/></DATA></COL> <COL><DATA><xsl:value-of select="contributor/b038"/></DATA></COL> <COL><DATA><xsl:value-of select="contributor/b039"/></DATA></COL> <COL><DATA><xsl:value-…

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" /> …

Hi everyone, I need your help about my xsl file: When I open 2 files with FM, FM does not show data on the table. However, I have full table with data when I remove namespace of the first line of XML file. Please give me some hints about it. I also attach files for testing. My original xml file looks like: <CompositionPlaylist xmlns="http://www.digicine.com/PROTO-ASDCP-CPL-20040511#"> <Id>urn:uuid:2e57edb1-d897-4d6e-ab98-f8f02a1f8055</Id> <AnnotationText>DARKNESS_FTR_TEMP_2D_S_EN_51_2K_IOP_OV</AnnotationText> <IssueDate>2014-09-25T17:50:40-00:00</IssueDate> <Issuer>CO3</Issuer> <Creator>ClipsterD…

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" x…

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 …

Hi. Am a beginner, so please bear with me ... The purchaser of our products have gone EDI XML, and I would like to be able to extract some information from their order XMLs, into a FMP database. Have searched the net and found xslt templates that I have tried to tweak, but for some reason I am not getting any data into the FMP file ... only empty fields. Here is the source xml ordre_4500644900_20150925093113.xml - and here is an example (only testing a couple fields to see if it works) nytest2_header.xsl I am sure there is something very simple I am missing in the reference side of things. Does it matter if the source file uses ns0 before each node? Do I need to …

We are being supplied xml file that we will need to import the data for orders. I've uploaded the example file of the xml and the xslt that I'm using to try to use. The issue I'm having is trying to grab anything that after the ItemOut like SupplierPartID or Description Any Ideas? Thanks ============ <ItemOut lineNumber="1" quantity="100" requestedDeliveryDate="2014-10-20T16:17:27.300-05:00"> <ItemID> <SupplierPartID>9069</SupplierPartID> </ItemID> <ItemDetail> <UnitPrice> <Money>0.0</Money> …

I'm trying to import the following XML data: <?xml version="1.0" encoding="utf-8"?> <customers xmlns="http://acme.com/schema/v1_2/customers.xsd"> <customer ID="1"> <city>Monterey</city> <name>Herbson's Pices</name> <orders> <order ID="ORD2"> <num>1</num> <date>12-01-2002</date> <amount>23.54</amount> <items> <item> <productID>ABC123</productID> <quantity>1</quantity> …

(Posted too quick, should probably be moved to Importing & exporting > XML/XSL) Hi All I'm trying to import and XML data source but am having problems getting the data in. I can download the XML locally and import it with my XSL without a problem. I've also tested the URL generated by the script on http://www.freeformatter.com/xsl-transformer.html successfully. I can view the URL in a web viewer object OK. It fails when I try to import AND when I try to insert from URL into a text field. I've tried various combinations of encoded/decoded characters in the URL but no luck yet. Open to any suggestions (except download it locally and then import it... I could sc…

Using FMS14, I currently publish XML output which is parsed by our promotional Web site (we're the public library, publishing a list of events, and hired a developer to write that for us within DotNetNuke). Since I have this working, I'd like to publish the same data, organized differently, as an RSS feed. I understand that I want to pass it through a style sheet, but don't know where that would be mounted. (I'm also pretty clear on how this would work if I were manually exporting, but my real goal is for this to be published, and updated, live.) Is this hard to do? The sample data is mounted here with the credentials u:read pw:only

SalesOrder_MagentoSales.xsd SalesOrder_MagentoSales.xsdHi and thanks in advance if you are reading my issue. I have data in filemaker that i need to export to XML so my ERP system can pull it in and create a Sales order. I have the XML Schema and also have a sample XML of what it should look like. The missing piece is i don't have a XSL style sheet and not sure where to start or how to create one. I been looking a many sites and many post, but feel I'm getting more confused than anything else. Can somebody point me in the right direction or possibly help me create the XSL Style sheet? I'm a visual person and have tried looking for videos or instructions, but not luc…

I'm working on an XML export from a Products table using a simple XSLT stylesheet with FileMaker Pro/Server v13. I've been asked to make one change to the export to include the date the file was generated in YYYY-MM-DD format. For example it currently starts like this: <?xml version="1.0" encoding="utf-8"?> <contacts> <contact> and they would like it to now start like this: <?xml version="1.0" encoding="utf-8"?> <contacts Date="2015-06-02"> <contact> My XSLT skills are pretty basic - can anyone show me how to include the date via XSLT? Do I need to create a field just for this purpose or can XSLT do this for me without ne…

I suspect this is an easy solve I am trying to nest a <xsl:for-each> loop within another <xsl:for-each> and getting a blank field in my resulting FMP table for one of them ( ie the Release ID ) within my example, the other 3 fields work ok. Could someone please look at the sample xml & xslt files and see if I can be pointed in the right direction ? I am creating a FMP solution for a historical research project for work ( a musical history radio show ) and I am importing a huge xml file from the Discogs ( music collection ) website - they kindly provide a monthly dump of their xml data, and it must be said their xml / schema is a total mess. I am reorgani…

I am getting nothing more than the 'XML/XSL information is not enough to proceed with import/export' error when importing the attached XML file with the XSLT file. The XML file is a cut down version of a data download I need to be able to import monthly. I would be very grateful of any help as to where I am going wrong. Thanks in advance. clients-transform.xslt CRM_Download-test.xml

All, Getting my hands dirty with CWP XML for the first time. Running FMS13 What i want in the end to for FMGo to exchange data with FMS13 via xml rather than having to open a FileMaker session as such on FMS13 from FMGo : very shaky internet connection on both ends... So i'm finding that activating cwp xml is not so terrible in the end and even getting to like the way it works. The only thing i cant get to understand is authentication: >tests from a web browser accessing a URL in the vein of http://someHost/fmi/xml/fmresultset.xml?-db=someDB_db&-lay=myLayout&-findallworks okwhen granting xml permissions to guest account > expectably, dis…

I would greatly appreciate any knowlege about the feasibility of a potential project: Is it possible to build runtime solutions for both Mac and Windows that incorporate XML imports? (Assuming the requirements for both runtime and XML import are met in the Filemaker App.) If anyone has experience with this, could you let me know if it's: Not possible. Possible but you really don't wanna go there. Relatively straight forward.

Hello all, I'm grafting an XSL to generate text in Final Cut Pro 7, it works fine except I need the carriage return "&#13;" Like so <value>Client:&#13;Agency:&#13;Product:&#13;Clock Number:&#13;Title:&#13;Duration:&#13;Aspect:&#13;Audio Type:&#13;Language:</value> Trouble is that the result is: "&amp #13;" I've read in Filemakers "Developing FileMaker XSLT stylesheets" PDF (Page 69) that I need to use the function: fmxslt:break_encode(String value) and to disable-output-escaping attribute of the <xsl:value-of> and <xsl:text> elements set to “yes” (disable-output-escaping="yes"). Could…

Hi All, I was tasked with building a solution to communicate with a web service. I have to my disposal : FMAdv 13 Fmnexus plugin WDSL for the web service. Server certificate for this web service With this solution I have to post xml to the web service ( over https ) and then parse the xml again. The producing and parsing of the xml should not be a problem. However, I am not sure of three things : 1. Is the filemaker 13 http-post function capable of posting xml ? or is this just a simple tool ? 2. Does anyone know the state of the FMNexus plugin ? The website where we used to be able to get the plugin just says it has not been tested. 3. Is there a better a…

I have a xml file I would like to import into Filemaker 12, however I find that I will need a XSLT file to make this work. I do not know much about XSLT files, and have picked up a "for dummies" book covering this, but still have a few questions I could use help on. I have an XSD file that would be used for validation of the XML file, does this file play any roll in the creation of my XSLT file? Is it possible to import the XML file so that the data is divided into multiple tables that I have in my database? Is it a better idea to import the XML file into a single staging table, and then query that table to populate my production tables? Last question, i…

We need to create an XML file from data of Filemaker 12 to import it into an online bookkeeping solution. Tried to do it using Excel but the XML is too complex for Excel. So, if I understand well I have to write a XSLT-stylesheet to convert Filemaker XML to the one I need. Can someone provide me with a link to a tutorial I could use? Been to W3-school but...I need some real Filemaker examples to understand cause I'm a bit lost here. I have a xsd-sheet is that of any use? Thank you for reading and eventually answering this question.

Hopefully, this post will help someone trying to integrate their solution with the BigCommerce API. FileMaker can update the status of an order on BigCommerce by sending a URL to this PHP, transforming a GET call URL to a PUT call for the BigCommerce API v2. The file is hosted on an internal server for security, and requires the cURL library. The key is the curl_setopt ($ch, CURLOPT_CUSTOMREQUEST, "PUT"); line to change the normal POST process for adding data into a PUT process for changing data. <?php // Converts a GET encoded URL to PUT for BigCommerce API v2. -Rob Caldwell 3/2013 // Requires cURL library for PHP on the server. // Strongly recommend loading…

Dear friends, Every time I'm so surprised how little data and examples there are online on filemaker server side xml requests / query's. Specially in combination with XSL. My case: 1. Customers come and ask me... please send results as xml and it should look like "this". 2. The results should be a result of a query they do on my server (so I supply a sort of webservice) 3. I can get them to send parameters, even do some pre scripts, get the results, but their browser wil show them the ugly FILEMAKER GRAMMER Result set. I need to be able to change the way the results look in a simple and easy manner. And the result should be passed back as a result of a htt…

I am getting an error importing my xml with my custom stylesheet. Where am I going wrong? I am importing the following xml: <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <schools> <school> <name>Abraham Lincoln High School</name> <type>public</type> <enrollment>402</enrollment> <city>Denver</city> <state>CO</state> <districtId>55</districtId> <district>School District No. 1 In The County Of Denver And State Of C</district> </school> <school> <name>A…

[Edit: added xslt example] Hi all, Given I have an xml like this: <row1> <node1>text1</node1> <node2>text2</node2> <node3>text3</node3> </row1> <row2> <node1>text4</node1> <node3>text5</node3> </row2> Where node1..n are matched to fields 1..n accordingly, how do I force the xml-import to create an empty field2 at second row instead of putting the value of node3 into it? I have tried constructs like this: <xsl:choose> <xsl:when test="(/results/issues/issue/coverDate) or (not(/results/issues/issue/coverDate))"> <xsl:for-each select=…

Have a very strange issue, we're building an application for browsing some of our FileMaker data in an external app, reading has worked fine but now that I am writing back changes, I've hit a bit of a wall. Basic queries with "-edit" and a valid recid are succeeding, as long as no values are changed (i.e., if I edit and save without changes it works fine), but if any field is specified with a new value, I get back error 507. This is supposed to be a calculation/validation error, but we have both checked independently (myself and another developer at my company) and there is not validation on any of the fields we are trying to edit. An example of the url syntax …

L.S., I read that XML/XSLT were being deprecated after FMS11 for custom web publishing... What does this mean for me ? We have a connection with a website that pulls data from our FM system. To create the correct xml format we are using xslt to do the transformation. Will this stop working when we go to fms-server 13 ?

Oh how I despise XSL sometimes ......... Short version : I'm importing multiple offer listings from Amazon and have a working stylesheet. I'm trying to set several variables for each record .... no problem on the others which just pull the first position. Example : <RESULTSET> <xsl:attribute name="FOUND">1</xsl:attribute> <xsl:for-each select="amz:GetLowestOfferListingsForASINResponse/amz:GetLowestOfferListingsForASINResult/amz:Product/amz:LowestOfferListings/amz:LowestOfferListing"> <xsl:variable name="MIN_Landed"> <xsl:for-each select="..//amz:Price/amz:LandedPrice/amz:Amount"> <xsl:sort data-type="number"…

Can someone help me with the following: I want to extract <loc>, <lastmod> and <priority> from this xml: <?xml version="1.0" encoding="UTF-8"?> <urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9"> <url><loc>http://www.myurl.com/</loc><lastmod>2014-04-03T15:51:51-05:00</lastmod><priority>1.0</priority></url> <url><loc>http://www.myurl.com/for-sale/TX/100/79109/173-Main-094451242</loc><lastmod>2014-04-07T03:09:00-05:00</lastmod><priority>0.7</priority></url> <url><loc>http://www.myurl.com/for-sale/TX/100/79109/146-Main…

Below I have pasted my XML and below it my XSLT, I am new to XSLT and hope that I am close to fixing my problem. When importing to filemaker, only the first 3 fields are importing, how do I get all of the fields to import? <Meta> <Attribution Url="http://www.this.org">Content provided byThis</Attribution> <ContentType>Article</ContentType> <CopyrightOwner DocID="This Copyright">2ff58aea-95</CopyrightOwner> <DocID>ART-2004</DocID> <UpdateDate>2013-03-27</UpdateDate> <PublicationDate>2013-03-27</PublicationDate> <ControlWords> <Category MCVID="1898" Title="Pr…

I've got a project that I think would benefit from the use of being able to import and update fields from an external source like XML. In this case Stock information. I'm pretty new to importing XML data and couldn't get anything to work for me. I suppose I just don't fully understand the mechanics of the process. I did some research and found that you can query Yahoo Finance and it will return XML data: http://thesimplesynthesis.com/article/finance-apis Is it possible to update one record at a time, and also update all the records at once? What's needed to do this? Is there a base template to start from? How are fields linked? XML template file? If there ar…

Hi there, I'd like to write a script that generates an RSS .xml file from FileMaker and saves it to a server. I was thinking that perhaps I would write a script that would generate the XML by looping through the records in question, and would pass the XML to a variable. Then, maybe save the variable to a global field, and then export one record (only exporting the global field), and saving that to a text file titled: filename.xml I have a feeling there is a much better way to do this..does anyone have any advice for me ? thanks :

Hi All, Urgent Solution needed. I want to integrate my FileMaker solution with apple GSX. I have made an application like the working of Apple GSX. At the end of the day, i need to update it to the Apple GSX site. When i create a service record in my filemaker app, then after a click on submit button, it also has to be submitted in to the apple GSX creating a service record. Thanks for your advance.

I'm attempting to setup my first XML query into our FMP Server (12). I have a layout that has a script associated with it to execute on layout enter. The only thing the script does is set to browse, go to the layout, execute a find (all records with a certain date). But, I can't get the sytanx of the query correct. I always get errors, mostly 4. So, I tested just loading a small table and that query is fine. Here is that query: http://filemaker/fmi/xml/fmresultset.xml?-db=Fill%20Rate&-lay=KPI3&-findall Here is the query of the one that doesn't work (the layout with the query associated with it) http://filemaker/fmi/xml/fmresultset.xml?-db=Fill%20Rate&…

This may not be the best way to do this OR describe the issue ....... but I feel like I'm ever so close. I can almost get the output but I have one section coming in as blank. Also I'm sorry for the length of this post. Just trying to give all the needed data .................... I hope. I'm exporting 4 records with 4 fields ... but only using 3 fields per line in the exported file.. (Posted at the bottom is an example of the FM export data) My desired output is a tab delim. text file with headers such as this : sku id status Parent-SKU1 0123456789 Update Parent-SKU2 0123456789 Update Child-SKU1 0123456789 Update Child-SKU2 …

So, we are a looking to open up a database to Geckoboard for dashboarding. I'm reviewing the Custom Web Publishing with XML document. What I can't figure out is what I'm referencing. We want to XML publish calculated information, such as a percentage from the past day, week, or year-to-date. Am I building a layout with calculation fields in a new table or a report to then base this XML off of? I have the database and I have already done some "raw queries" to existing layouts, but I guess I'm missing the point on the summary/calculated data portion. If anyone can point me to an overview of this outside of the PDF I referenced above, that would be great. Sor…

It is almost 10 years since I last worked with XML and then only as part of a Masters module. I am now retired and busy planning trips in our motorhome for which I create a list of ‘favourites’ for my navigation app. I have previously done this using Excel but it is rather tedious so I looked out my copy of Filemaker Pro v9 which is brilliant for manipulating the ‘Points of Interest’ files that can be downloaded. And then export as XML and do an XSLT transfom on the fly. To avoid having to hunt through a long list of sites I wish to group them and have given each record a group designator field. The data will be sorted first before export so the XSL file will…

Hello, after solving my XML import I'm tring to export the whole stuff :-) So is it possible to use "field names" in the xsl instead of <Titel><xsl:value-of select="fmp:COL[9]/fmp:DATA" /></Titel> Looking in the exported XML without using an xsl there is a Metadata block with the field names. So this would be much more readable and errorproof than counting the Data <Titel><xsl:value-of select="fmp:COL[name=Titel"]/fmp:DATA" /></Titel> Regards Michael

Hello all, Im a newbie with XML and XML import into filemaker. But I've suceccfully found some sample and got them to work with my own data. But unfortunatly there is a small part of my data which got not imported :-( This is a sample of the source XML: <?xml version="1.0" encoding="utf-8"?> <App Titel="Basic Cooking"> <Rezept xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="rz2_app.xsd" verwenden="ja" timestamp="15.03.2013 09:59:31" id="7742-1142_161_2"> <Metadaten> <Buchtitel>Basic cooking</Buchtitel> <Reihentitel>224 GU Basic cooking</Reihentitel> <ISBN>97837742…

Hi forum, I am developing a solution called Litlink used to work with bibliographical data on a rather complex level. What I'm trying to achieve is this: the user has defined authors and books and generated so-called "cards" containing quotations and commentary. He has combined a set of those cards into a project and defined the sort order. Now I want to create a word document that contains the quotations as a paragraph of the style "Quotation", the commentary as a paragraph with the Style "Standard" and the calculated bibliographical reference as a footnote linked to the quotation. I saw that the word file format is basically a zip-file that contains among other…

I am attempting to export XML and transform it - from Filemaker, to be usable in Word. For straight fields- no problem. For related data - I have it working, but once I start to attempt any sort transform, that's where I get unstuck. I have 3 columns that I want to format as follows ( as a table - it would actually be a table within a cell - BUT, perhaps someone has a better suggestion that a table within a cell ? ): Nr. Name Type Call-Sign 1 Jones Extra BRD2 2 Trucker New GF21 3 Brint Extra ASD2 I have got the Name column working fine... I just need the Nr. column ( position () ) and the other 2 columns to work...they always ret…

Hi All: I have recently had a query from a colleague where he wants to exchange data with FileMaker Server via HTTPS Post of xml data. Has anyone been able to set something like this up, as a two-way data exchange? I imagine that it might not be possible via HTTPS, but perhaps as HTTP? Any suggestions are welcome, as I have not seen any evidence that this is possible. Thanks in advance Stanley

Hello guys, I have a big problem importing data from a xml file to my FM database. I have a XML file that is given from a provider and it doesn't have the structure of my FM database (find attached a example of the XML file). I've created a XSL file to catch some data from the XML (find attached a example of the XSL file) but when I start to import data it doesn't works and I don't get any errors or messages. In the other hand, I think I'm able to do the XSL for the header ("cabecera" in spanish) of the XML file but I'm lost with the rest of the file. Could someone help me? Thanks in advance and sorry for my english. alcanzia.ziptest.xml

Hi I'm trying to create a moderation database that can feed a screen in a conference from a twitter rss seach term. I have got the rss feed by using pixsy - http://search.twitter.com/search.rss?q=%5B%23capitalstb%5D I have created what I believe is a valid XSL file to map the elements I need from the feed into a table. My script is Import Records [http://search.twitter.com/search.rss?q=capitalstb; capital_twitter.xsl; Add; Mac Roman] I've tried running the xsl from a local file and from a local http server but still get no entries, so I guess the xsl mapping isn't correct. Can any one help? Thanks Jonathan capital_twitter.xsl.zip

I am exporting child records together with their parents to an Xml file from filemaker whilst i am sitting on the child records.MY problem now is when i want to import them into another database i want to import the parents separately and the children separately the parents are now coming in duplicates.So i need help in elimanating the duplicate parent records when importing into the secondary database. Any help would be appreciated please

So this may be a novice problem but I don't have enough experience yet to know how to do it using a Filemaker script. If I can't do it using a FM script can I call program in another language from a FM script that can do it. I don't have control over what is installed on the computers our software is run on so I'd like to do it without having to install yet another piece of software to make it work. I need to take the XML created by FM Export and convert it into another XML file and save it to a specific location on the local computer. I want to do this by taking the XML created by the FM Export execute an XSLT file on it and get a different XML file as output then…

Frustrated !! I'm downloading an XML feed submission results file from Amazon using Scriptmaster (since the site now uses https for MWS) and saving the file to the local drive. I'm then attempting to import the saved XML file using an stylesheet on my site. I was able to do this initially but now I keep getting the same error : "An exception occurred! Type:RunTimeException, Message: The primary document entity could not be opened. Id=C:........" I can't figure out what changed or why the problem. Any ideas or comments are appreciated ......... Sample XML <?xml version="1.0" encoding="UTF-8"?> <AmazonEnvelope xmlns:xsi="http://www.w3.org/200…

I have a xml file and want to import data in filemaker application, but when i using import data through xml each and every time it hangs the fm application. this is my xml file and fm app fields are same as customers elements. <?xml version="1.0" encoding="UTF-8"?> rajan kumar rsgss 09693741616 [email protected] FM developer developer!

Hi Folks, I am trying to export some data in xml format from filemaker using XSLT. I want to display the same data in three places on the xml. I was displaying the data once by using for-each tag. <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <xsl:for-each select="fmp:COL[3]/fmp:DATA"> <marker> <name> <xsl:value-of select="."/> </name> <xsl:variable name="pos" select="position()" /> <comment> <xsl:va…

I have attached the XML Response. I am trying to get all data elements in one row and in one table. The index for this particular row is ID 6018 which is Colorado, Denver, Montbello. I can get the region and links just fine. What I am having trouble with is the repeating elements for charts an pages Out of Charts, I have table field names for (i) Median Condo Value, (ii) Median Home Value, (iii) Dollars Per Square Feet, (iv) Dollars Per Square Feet and so on. However, you will notice those are returned as the <name> field in each element. For charts, I need the URL of those names. Out of Pages, I need the Neighborhood, City, and Nation values …

I am importing XML data. If I want to import the URL of the following XML: <charts> <chart> <name>Median Condo Value</name> <url>http://www.zillow.com/app?chartType=affordability_avgCondoValue&graphType=barChart&regionId=11093&regionType=6&service=chart</url> </chart> Then I use this select statement: <COL><DATA><xsl:value-of select="//charts/chart[name='Median Condo Value']/url"/></DATA></COL> Here is my question. I want to import a Data element that has a "&" in the <name> field. For example: Normally for the XML be…