XML/XSL

I have the following xsl. After the xsl, I have listed the xml example. The xsl imports each "region" record perfectly. If you will notice, in this example, there are 78 and I get 78 records imported. I also, however, want to import the <list><count> record (78) and the <message><code> (0) record. Can somone modify my xsl to import those? Thanks. <xsl:template match="/"> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="" NAME="FileMaker" VERSION="ProAdvanced 12.0v2"/> <DATABASE DATEFORMAT="" LAYOUT="" NAME="" RECORDS="" TIMEFORMAT=""/&…

Hi, I'm working on an xslt that will import data into Filemaker I am working with a single existing record that may or may not contain existing data. If certain fields contain existing data I do not want to write over them when I import data from the XML file. So, I would like to pass a value to the xslt that will tell it to skip the data I do not want updated. Is there a way to do this? Filemaker script: check to see if field has data if data = true somehow pass the parameter to the xslt XSLT get the value of the parameter that was passed from the filemaker script if data = true do nothing with xml flags else process flags I can't …

I am trying to obtain lat and long info from google maps api to store into a Contact record in FM. I have successfully formatted a web viewer to return the info into an xml file formatted into the web viewer. My questions is how to I get FM to parse the lat and long info from the resulting web viewer to place into the database?

I have such a headache ........ OK, so I want to export records from my database which I will upload as an XML file to my own website. I then will have users download the file and import into a runtime I provide them. Sssooo .... I want the XML export formatted (basically) as : <?xml version="1.0" encoding="UTF-8"?> <ImageLoader> <Users> <User> <MerchantId>ANZE9ULNDLIJJ</MerchantId> <Status>No</Status> <PaidTillDate>1/28/2013</PaidTillDate> </User> </Users> </ImageLoader> I'm using this xsl to export : <!-- Added so no one wants to delete the post Fil…

Hello all, I'd like to export data from FMP that creates the following in Final Cut Pro 7: 1. a bin with clips (data: title in, out duration etc. From FMP) 2. a bin with sequences (each sequence corresponds to the amount of clips in 1, i.e. 1 clip = 1 sequence) The Sequences are always the same, except for the spot length, thus. Format: Apple ProRes 422 HQ / 1080i 25fps Sequence timing 09:59:50:00 - 09:59:56:24 (7 Sec) Colourbars + Ref Audio / From FCP 09:59:57:00 - 09:59:59:24 (3 Sec) Black (Slug) / From FCP 10:00:00:00 - ??:??:??:?? Clip (In general 20 - 40 Sec) ??:??:??:?? - ??:??:??:?? (1 Sec) Black (Slug) / From FCP I found a XSL for F…

Hallo, ich habe leider noch absolut keine Erfahrung mit FileMaker, müsste aber dringend ein XML-Dokument importieren. Mittlerweile weiß ich, dass ich dies erst mit XSLT in ein bestimmtes Format transformieren muss. Habe mir auch die Beispiele die FileMaker mitbringt angeguckt. So richtig weiter komme ich leider trotzdem nicht, da ich auch mit XSLT noch nicht ganz soviel zu tun hatte. Zum einem würde ich gerne mal Wissen für was jeweils die einzelnen XML-Templates in der *.xslt sind? Zum anderen, kennt jemand einen guten XSLT Online Parser? Hab mal versucht die Beispiele mit den jeweils einzelnen Templates zu parsen. Aber irgendwie kommt da nichts brauchbares …

Hello everyone, I've had a look around in the forum, but found there is no "XSL generator" as such so I was wondering if someone could help / guide me on generating a XSL sheet to export XML from FMP. I work at a Video Post Production house, where we have a proprietary tape archive database that can export a timecode list as CSV, the capturing software we use imports apart from some more exotic formats XML. It seems quite simple enough after ones first try maybe, but I just don't know where to start. I've attached a example DB and an example XML capture list from the capturing software. Any help would be grand Regards Ian Batch List Gene…

I am hoping someone can guide me with my stylesheet for the attached xml. I want the "Comp" (which are real estate comparable sales) to import into separate records. The import routine recognizes the mapping just fine, and I get no errors on import... except no data imports. The second Test.xml is a corrected version. Test.xml Test.xsl.txt Test.xml

We have applied an xslt file to import an xml file to our FM11 db. It works beautifully EXCEPT FM appears to strip all the visual tagging such as <hi rend="ital"></hi> and the like from the copy. How can this be overcome?

I am getting this error when creating a new record using cwp. If I hit the back button and then hit submit again, it works. Any ideas? I used the XSLT Wizard to make the pages. I just deleted a few fields, so all I have is one field. That field is not required to be unique. I have no idea what it is that I'm missing. Incidently, when I submit with nothing in the field, it also works. Thanks!

Hi Everyone, I'm having a difficult time trying to create a stylesheet to convert the attached XLM file to Filemaker format. (full disclosure, I have never created one before but after spending hours looking through this and many other websites, I seem to be stuck). Would really appreciated any help any of you could provide. (ps- the XLST file wouldn't upload, so I saved it as a .txt instead) Thanks a lot! Notification.xml Notification.txt

Dear All, I stuck on a very logical problem here. Please let me know that how can I get XSLT file of any website. So that by using this one I can extract the RSS feeds of that site. I want to store the RSS feeds in FileMaker database. I need it in hurry. Thanks in advance....

I am looking to export data from a layout called webdata in a database called Books from our FM Server 11 Advanced using the XML functionality of the Web Publishing Engine. I have a layout which is based on the main Books table with all of the fields I need. What I'm looking to do is to get a list of in print book records. We have a seperate table which has mutliple records for each book to track when the statuses were active. This table includes a field to indicate that this is the current status and have verification set up to ensure that only one record per book is marked current. Using a table occurance of the status table I am able to filter down to just the cur…

LS, I am trying to build a xml-file based on an xml-result export. I want it to look like : <data> <record> <ID>1</ID> <name_last>Miltenburg</name_last> <name_first>Joost</name_first> ... </record> </data> I have the xml-result : (part) <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="id" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="name_last" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="name_first" TYPE="TEXT"/> ... </METADATA> What I want is to dynamically get…

Hello, I'm trying to troubleshoot getting results from the web publishing engine. I've created a script that will return results as expected (24 records for my test), but when I try to run the script from a webpage, I get the fieldnames returned but no results. There are other calls using the WPE that work fine and I believe the URL is correct. It's below so others can see if it's correct. http://corkwood/fmi/xml/fmresultset.xml?-db=ocp_fmp_webinterface&-lay=ocp_fmp_webinterface&-script=Digital_Edition_Update&-script.param=30103333&-find I've rebooted the server. Running FMSA 10.0.1.64 on Win Server 2003 SP2. How do you troubleshoot somet…

I am trying to import PubMed XML data that is obtained by a http request for example: http://eutils.ncbi.n...088&retmode=xml ... and have had some success for simple data with an XSL file copied at the end of this post. This is used on a solution posted some years back on this forum by Fenton Jones (http://fmforums.com/...-filemaker-pro/) My problem arrises with repeating fields, specifically the author list. I need to convert ********************* <AuthorList> <Author> <LastName>Brown</LastName> <ForeName>Simon G A</ForeName> <Initials>SG</Initials> </Autho…

Hi, I have a calculated field that contains the xml code I need to export. The problem is that when I export it the "<" and ">" tags are transformed into "&lt;" and "&gt;" How can I get the xml code from my field into the final xml file ? I must also say that I use an XSL template to modify my code to the desired format. Here is the code in my calculated field as I see it in my FileMaker: <dealer_id>4527</dealer_id> <ownersvehicle_id>O17068</ownersvehicle_id> <type>car</type> <category>used</category> <body>5_doors</body> <brand>Renault</brand> <mo…

I need help importing xisbn worldcat xml data into filemaker. Here is a sample of the xml returned from http://xisbn.worldcat.org/webservices/xid/isbn/9780230418899?method=getMetadata&format=xml&fl=* <rsp xmlns="http://worldcat.org/xid/isbn/" stat="ok"> <isbn oclcnum="726087703 751704411" form="BC" lang="eng" title="Mastermind." author="Mickey Rogers, Steve Taylore-Knowles, Dorothy E. Zemach ; concept development: Mariela Gil Vierma." publisher="Macmillan" city="Oxford" url="http://www.worldcat.org/oclc/726087703?referer=xid">9780230418899</isbn> </rsp> I need to extract : Title Author Publisher ISBN Year …

I've spent a few days and just can't figure this out .... 2 basic problems. Desired result : <Database> <Item> <Price>14.95</Price> <SKU>12345</SKU> </Item> <Item> <Price Currency="USD">7.95</Price> <SKU>12346</SKU> </Item> <Item> <Price Currency="USD">14.95</Price> <SKU>12347</SKU> </Item> </Database> I'm almost fine with each 'Item' section but...... 1. I can't get the <Price Currency="USD"> to show. I only get <Price> Should I even be using a template? I don't know why I can't figure this out .... U…

I am a self-taught filemaker developer. Have been doing filemaker for years and recently learned PHP to use CWP. My site is up and running on the web and doing well. In fact, it is doing so well we need to automate the order entry process with our supplier. Our supplier recently added the ability to accept electronic orders via XML. They use the automotive industry standard. I need to do 3 things with XML: 1. Enter quote requests and receive the answer. 2. Enter a new order and receive confirmation. 3. Check order status and receive confirmation. My question is whether XML is fairly easy to learn or whether I would be better off hiring someone to just …

Hi. I searched around the web for this but cant quite get a definite answer. I'm developing an ios app and my boss would like to setup and use filemaker as the backend for it (since he has other uses for filemaker too). I was thinking of using the xml api to request data such as regular records and images (through http/rest calls) but would it allow me to add/update records or create new layouts/tables as well? Thank you in advance. ;)

I am doing XML exports from multiple tables and the resulting XML is working well when I concatenate the XML data into a single file. I have done a lot of reading here about exporting related tables from grandchild to parent and vice versa and it gets a bit over my head fairly quickly. Given where I'm at right now, it seems most efficient to use document() to combine these XML exports via XSLT but I haven't found any examples of how to do that. Could anyone share a simple example of that using FMPXMLRESULT? Thanks.

Is anyone using Chapparelle Software's XSLT Stylesheet builder for FileMaker? This piece of software will convert a "marked up" Word document into an xslt stylesheet which then can be used to create Word documents from exported xml data from FileMaker. I was wondering if it could create stylesheets that would mimic FileMaker reports that had subsummary parts.

Dear All, I have successfully imported the XML files into the database. But I just want to know that, "How can I encode the Binary data into Image in a container". The image data is in binary formate in XML file. I have imported it. And finaly want to convert it into image file using FileMaker in a container field.

I'm new to the web end of FM and am trying to edit a record using a similar URL below: "http://192.168.123.101/fmi/xml/fmresultset.xml?–db=employees&–lay=departments&–recid=13&Country=USA&–edit" The documentation seems a bit sparce on the details and my questions are 1. Is the "-recid" the internal FM record ID or is that one that is user defined? 2. If it's the internal ID, does there need to be a find performed first to capture the internal ID, then do the edit step or is there a way to accomplish this in one URL? What does the URL look like if you can use a user defined field? 3. Are there some good examples somewhere to l…

Hi I have fms9a running on a SBS 2003 server IIS. XML requests through any OS/browser combination work great ONLY if the guest account is enabled for XML. Any request in any OS/browser either from within the local network or externally all popup Username / Request box with the URL request of the form http://username:[email protected]/fmi/xml/fmresultset.xml?-db=mydb&-layoutnames the username/password are in full access group (same group I put guest in to test), I have tried others pressing cancel gives me a 401 Access forbidden error. Any idea why this is not working ? Thanks Glenn

I guess the question is any ideas on how to change this so that if an exported field is empty I don't get an extra $newrecord but do still get the $newrecord needed at the end of each record??? Note: setting Qu to '0' if empty is not an option.... Example: ItemName Price Qu Product1 $9.95 Product2 $7.95 Product3 $8.95 This may not show but there is a tab after each price before the return/new line Yet I get: ItemName Price Qu Product1 $9.95 Product2 $7.95 Product3 $8.95 Here's the stylesheet section....... <xsl:choose> &lt…

All I want to do in life is unbind the enter key in my find page. I created web pages using the Filemaker XSLT Site Assistant. The database is a simple "Approved Volunteer List". Our employees search names on that list before they let strangers into our schools, but they keep typing the name and pressing "enter" which gives them an error. I want them to have to click on the "Find Record" link. By now you have come to the conclusion that I am lower than just a novice or begginner. Please help.

I just can't quite see this one.... In this instance I have 2 ITEMS and 6 ITEM but sometimes I only have 1 ITEMS. If I want to import all 6 records <ITEM> ..... and they come in under ITEMS but not the same one... where do I put another for each? Or must I do something else?? XML <ITEMS> <ITEM>1</ITEM> <ITEM>2</ITEM> <ITEM>3</ITEM> <ITEM>4</ITEM> <ITEMS> <ITEM>1</ITEM> <ITEM>2</ITEM> <xsl:for-each select="Response/ITEMS"> only gives me 2 records. <xsl:for-each select="Response/ITEMS/ITEM"> gives me no…

LS, I am currency data from an xml file into a FileMaker file. I have never had any problems with this until now. The general question is : how do I import number data into a FM database ? Specifically, how do I process the decimal data ? ( say 123.45 ? ) How does FileMaker store this internally ? I ask this because in when using system formatting[on] in Dutch regions one would use a comma as the decimal separator. So, can I always supply a point (.) as the decimal separator or should I follow the system setting for the Machine ? Usually I do something like this : <xsl:value-of select="translate((($amount * 100000000) div 100000000) , '.' , ',')"/…

Anyone know how this works when exporting related fields? I have no problem exporting using a stylesheet when I'm exporting just from the one table, but if I include related fields, and hence have more than 1 related records per main record, I only get one related record in the resulting XML, not the whole lot. Here's my XSLT stylesheet, which is very happy with "local" fields only, but I need to get it to drill down and process all the related fields instead of just the first one: <?xml version="1.0" encoding="UTF-8" ?> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="fmp"> …

I have an XSLT which I use to import some XML data in SOAP format. Works great in FileMaker 11, but when trying it in FileMaker 9v3 I get the following error: XML Parsing error: Attribute 'xmlns:soap' is not declared for element 'FMPXMLRESULT' In the XSLT which works in FM11, I do have an xmlns definition: <xsl:stylesheet version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:soap="http://schemas.xmlsoap.org/soap/envelope/" > However, I need this, because if I remove it, then I get a different error: "Unable to resolve prefix 'soap'" which happens when I count the records as I'm using the soap namespac…

Yeah I know ..... My head is mush and I have to finish. I've been removing the "&" from names and titles in my XML BEFORE import .... but I don't really like it. Is it possible, and if so how, to import something like..... <name>Smith & Wesson</name> ...so that it's the same in my field after import? Can be changed in the stylesheet or where to allow it without getting an error?

Just like is done in this previous topic "Geocoding using Google Maps API", I'd like to get the Long/Lat coordinates using Bing Maps API. Does anyone have any experience with this?

Hi, I've just export my data using xml. Is there a way for me to export the data using the field's name "Field_1" instead of <COL><DATA> in the contents? Thanks. Kent <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE>0</ERRORCODE> <PRODUCT BUILD="06-11-2010" NAME="FileMaker" VERSION="ProAdvanced 11.0v2"/> <DATABASE DATEFORMAT="Yyyy-m-d" LAYOUT="xsl" NAME="xsl.fp7" RECORDS="5" TIMEFORMAT="h:mm:ss a"/> <METADATA> <FIELD EMPTYOK="YES" MAXREPEAT="1" NAME="Field_1" TYPE="TEXT"/> <FIELD EMPTYOK="YES" MAXREPEA…

I'm trying to import XML data into FileMaker 9 (or 11, can use either) and I'm running into an issue. The XML file references an XSD file which doesn't exist (I've contacted the vendor and they are 'working on it'). If I don't use any named tags in the xpath selection commands and just hard-code things by position, e.g. <xsl:for-each select="/*/*[position()=2]/*[position()=1]/*[position()=5]/*"> then it works. However, I think this is brittle as any change in the order of tags in the XML file will break it. I'd much rather use named tags for selection, e.g. <xsl:for-each select="soap:Envelope/soap:Body/abcxyz:Person/abcxyz:Addr…

OK, first of all I'm new to this. I've managed to extract in xml all the records in my file using http://localhost:471/FMPro?-db=filename.fp5&-format=-dso_xml&-find But now I need to split this one file into separate files for every record, where every records starts with

Ahoi there everybody ! I’m doing a presentation, for a database in FileMaker 10. So the presentation to get much more dynamic in it, I’m using Fusion Chart…which I recommend to everyone: http://www.fusioncharts.com/FileMaker/ Now! The main problem with Fusion Chart for FileMaker it’s that it don’t have Gantt type charts, but Fusion Charts free contain some different Gantt charts. Main idea it’s to export records in XML format. Here it’s the problem. Can somebody help me to XML style sheet so the export to fit the file below ? Gantt.xml

Hi, I have a script that imports xml from a local file. the xml file is an fmpresult format. The strange thing is that on some computer it is working and on some (50%) it is not and I get xml parsing error. I cannot find what is wrong. The file is the same on all machines. All machines are Windows machines. tnx

Hi ! I am trying to import a xml-file like this, but FileMaker errors. It has something to do... with this part in the xml : xsi:noNamespaceSchemaLocation="eExact-Schema.xsd" When I manually remove this part, the import works perfectly. I might be able to do this with the Troi-Fileplugin, but I'd rather solve the problem at the heart/root. My questions : - what is this xsi-thing ? Is the value : 'noNamespaceSchemaLocation' common ? - How do I solve the problem ? ----sample xml----- <?xml version="1.0" encoding="UTF-8"?> <eExact xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="eExact-Schema.xsd"…

As a Newbie in Filemaker, I'm having a hard time trying to import a XML feed from a web service, transform it with a XSLT stylesheet and import it in a Filemaker DB. The import script is giving me an error: "Invalid Document Structure" Any help will be grateful! The document structure is <itemList> <Item> <product_id>Product ID</product_id> <manufacturer_part_number>Manufacturer PN<manufacturer_part_number /> <product_dateadded>M/D/YYYY</product_dateadded> <category_ids>0123</category_ids> <product_shortdesc>Product Short Desc</product_…

hi guys. I can't get result document to work when using XSL. It tells me the href has already been created. I think my foreach is wrong xml is root/dept/sub-dept. with multiple dept and muliple sub-dept in them. <xsl:for-each select="//dept/sub-dept"> <xsl:variable name="nameOf" select="sub-dept"/> <xsl:variable name="filename" select="concat('output1/',$nameOf,'.html')" /> <xsl:value-of select="$filename" /> <!-- Creating --> <xsl:result-document href="{$filename}" format="html"> </xsl:result-document> </xsl:for-each> appreciate the help thanks

Hi all. I am experimenting with Filemaker's XML export options to produce formatted HTML using XSLT in conjunction with CSS. Wow thats a lot of abbreviations in one sentence! I am a beginner using XSLT and have a good basic understanding of what you can do with it, and how it works. I have got about as far as I can on my own with playing around with the examples disributed by filemaker and other examples I have found on the web. In the file I have attached there is the database and the XSLT style sheet I am using, together with a example XML to HTML export that it produces. I have also included a HTML file of how I want the HTML to be formatted. Can …

Hi, I am trying to add <![CDATA[ in my xsl but it gives me an error message. Is there a way to add this so i can import chinese characters for my website? Thanks. Kent <?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"> <xsl:template match="/"> <xsl:for-each select="fmp:FMPXMLRESULT/fmp:RESULTSET/fmp:ROW"> <book><xsl:text> </xsl:text> <Field_1> <xsl:text><![CDATA[</xsl:text> <xsl:value-of select="fmp:COL[1]/fmp:DATA"/> …

MS Word allows automatically numbered headings, such as, 1.1, 1.2.1, 1.2.2, etc. Using WordML, is it possible to force the heading number to any numbering I want? I'd like to specify, for example, 1.3.2, then 1.4.1.1, then 1.4.1.2, then 1.5.1. Any ideas? And, if this isn't the best place to post, I'm open to suggestions for a better forum. Thanks, Mike

This topic is only slightly related to XML/XSL but I'm coming up short asking The Google. Has anyone used Filemaker data such as a teacher, list of students and course name, exported and transformed to XML via XSL, to create a Google Group? Ideally, I could create a private group, setup up the teacher as the moderator, the students as participants and name the group according to the course name. I've been unable to find a specification for Google group creation using XML tags. I'm not interested in trying to write a Google App. Thanks.

Hi guys ! I am trying to supply some xml-document using the FileMaker XML/XSL possibilities. Now it seems the software from the other side asks me to supply <elem xsi:nil="true"/> in stead of a <elem/>. What do I have to do add to my stylesheet to create empty like this ? TIA ! Joost

We have a web server, it is a webshop and I want to embed a FileMaker generated site, but when I use the iframe tag, Opera and other browsers say "The website does not permit its content to be displayed in a frame. It must be displayed in a separate window." How can I sat in an XSLT the HTTP Header "X-Frame-Options"? I think I had to use the "fmxslt:set_header" somehow?

Hello I'm trying to export the shippments from FM6 to UPS WorldShip. It can be done by .xml file. But the result of my export "para_ups.zip" and the .xml necesary "New Feature - Shipper Account Number Auto Import.zip" doesn't match. Can somebody help me to create one XSL? Note: In New Feature.xml Appears the section, but i don't need to create Invoices in ups software, so i don't need that segment. Thank you!!! New_Feature_-_Shipper_Account_Number_Auto_Import.zip para_ups.zip

I have an xml response that I'd like to filter thru an XSL and import into filemaker. It contains the info for a standard order - buyer contact and several items ordered. Here is a sample response file - <?xml version="1.0" encoding="ISO-8859-1"?> <orderUpdateResponse version="1.0"> <purchaseOrder id="87047440DONOTIMPORT"> <buyer id="3392278"> <email>[email protected]</email> <mailingAddress> <city>Manassas</city> <code>22204</code> <country>USA</country> <name>Some Dude</name> <phone>703444 5555</phone> …

I was wondering if anyone know how I go about solving parsing errors when importing XML data created from a mysql database. I often get errors like "XML Parsing Error 'nbsp' was not found Line # 89 Column # 79" Thanks

I am using Filemaker Pro 11 and wish to script an export XML file directly to a remote server. The export function seems to only permit local placement of files. Is there a way to script this so that the file will be uploaded to my webserver automatically? I'm trying to eliminate manually opening up an ftp program, scrolling around, etc...

I would like to export to XML using an XSL stylesheet. But I'm such a newbie and unsuccessfully learning my way around the "for-each" and "value-of" verbiage. And I'm not doing such a great job with spacing either. I need a carriage return for each line and a single space indent here and there. The indent="yes" results in two carriage returns - one of them a fully blank line. There are 3 fields for each record I'm exporting - itemID, title and category. The output must conform to the following format - <?xml version="1.0" encoding="ISO-8859-1"?> <Website> <UploadList> <itemID> the item goes here </itemID> <…

:bang: Once again after hours of playing and trying to learn I just can't seem to get it! I know it's not that hard so if someone will point me in the right direction I'd appreciate it. The attached is a basic XSL style sheet and example from which I can apply my new found knowledge (I hope) to my others. I only want to import from the xml response certain records into my database and ignore the rest. So basically I only want to import those matching certain predefined criteria Examples: PublicationDate=Jan 2011 or ProductGroup=Books or Format=DVD I believe it will involve the 'for-each' but I'm not sure where. ?? and does it involve the t…

We purchased some hardware in our office that comes with software that outputs data as XML. I have been trying to build an XLST style sheet to import it into a filemaker database but am struggling to get it going. I just cant get my head around the references in the data file, I got a basic style sheet creating the field names but no data comes into the database when created. Some help and guidance with this would be great. I attached a sample data file that I am trying to import. flow data.xml

Hello, I'm trying to edit record with FMRESULTSET but column with the dot(.) in it's name is giving me a lot of problems. Update to column name in the database is not an option. I have following problem with the XML result set: http://<<servername>>/fmi/xml/fmresultset.xml?-db=EXPORTER&-lay=NEW_CMP&-recid=2704&Rating.n=1&_Subcategory=Corporate+Pension&_Category=Investor&-edit Like you can check from the previous example I want to update following columns: _Rating.n, _Subcategory and _Category. The problem is related to the "Rating.n" column. If I remove this column from the query, it works, but all columns with …

Hello, I'm trying to configure email using xslt. I followed the tutorial GrahamSprague. Anyways, I've tried several different smtp servers and combinations of settings and each time I get a 10200 "unknown messaging error". Does anyone know what exactly the problem is? Thanks -Andrew

I'm trying to use custom web publishing to export data as XML, do that I can access it via a web application on a different server. I'm completely new to this so I have no idea what I'm doing. I have set up a user account in my database with the fmxml privilege, and FileMaker Server Admin shows that my database is accessible via XML (and XSLT). I would have though that I could access the server via a web browser, something like this: http://server/fmi/xml/fmresulset.xml?-dbnames http://server/fmi/xml/fmresulset.xml?-db=customers But when I do this, I get an XML document back containing an error (error code="954"). Am I doing something really obvious wrong?

I hope someone can help me. I've spent about 12 hours trying to figure this out and I'd pull out my hair if I had any. I have two tables (Category) and (Images) (*See picture of tables.) and my XML output should look like this.... <root> <category id="1" title="toys" name="toys" parent_id="-1"> _____<images> __________<image id="1" title="ball" colorize="true" imageUrl="domain/ball.jpg" category_id="1" description="ball, toy" /> __________<image id="2" title="car" colorize="true" imageUrl="domain/car.jpg" category_id="1" description="car, toy" /> _____</images> </category> <cate…

Hello All, I have been playing around with this XML and XSLT for a while and feel like I am banging my head against the wall. I have an XML file generated by FMDiff and I'm trying to pull the data into a FileMaker file. Attached is the XML that I have. FMDiffTEST.xml What I am trying to pull in is just the differences and of those: toplevel, action, old, new So in the example below there would be two records - toplevel = functions, action = delete, old = Trim4, new = "" toplevel = functions, action = insert, old = "", new = uID_Create Copy Any help would be greatly appreciated. Tom __ <functions toplevel='yes'…

I have a xml file import to mapforce. Does anyone know how to convert it to xlt. Is there any particular procedures I need to follow? Thanks. Kent

Hi! I'm new to XML and I need some help with exporting an XML file using a XSL stylesheet. I need the XML file to look like this: <?xml version="1.0" encoding="UTF-8"?> 205848 FleaBass Flea JUNIOR Touring Bass - Punk Bass - Green and Pink I've tried using this stylesheet but it doesn't work: <?xml version="1.0" encoding="UTF-8"?> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" exclude-result-prefixes="fmp"> Can anyone please help me? Johan

Hello, My truck accessory company uses Google's Merchant Center to put our items in their google product search. One way to upload your items is using XML (which is what I use). To put all the items from my filemaker database into an XML format I use a PHP page which disguises itself as an xml page. And just basically echos the xml in the google format. I have over 20k items and my method is time consuming. One because the php times out since I have so many tiems so I have to break down the database into bits. I've been looking into exporting the database and all the fields that I need in XML straight from the database. But how would I place the fields with…

Trying to get a URL command to find a record in my DB and run a simple script against it, but keep in getting a 958 'Parameter is missing' error. Here's my command: _ttp:///fmi/xml/fmresultset.xml?-db=OLEDB&-lay=TrainSession&-script=ModInc&-recid=1-find (When I preview this it looks like there's a space in "Mod Inc' - it's not like that in my command) I've tried replacing the -recid with a field name and still no dice. Script has full admin access and only increments a number field (before committing the change). I'm able to edit the record using XML URL commands, so the permissions and security don't seem to be an issue. What have I got …

I'm using iSpring Quizmaker to build a (HTML hosted SWF) quiz and send the result to FM via an XML URL command: http:///fmi/xml/fmresultset.xml?-db=&-lay=TrainSession&-recid=1&ScorefromQuiz=100&-edit. Run manually from a browser its great, DB updates fine. However when run from the SWF quiz iSpring creates, it doesn't, even though it's reported as having posted OK in the logs. The only difference is that I have a 547 reported at the end of the log line rather than a 7704 (when it is successful). :0 - -"/fmi/xml/fmresultset.xml?-db=OLEDB&-lay=TrainSession&-recid=1&ScorefromQuiz=100&-edit" 200 547 (Same Info Logged in Web…

Hi new to all this and posted same info on the (wrong_ post. Can anyone help: Hi I am designing a database which weill export a list of companies to be exported via XML as a web page. I have the following code at the top of the xsl sheet for my record export: xmlns:xsl="http://www.w3.org/1999/XSL/Transform" version="1.0" xmlns:fmp="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fmp"> method="html" encoding="UTF-8" version="1.0" omit-xml-declaration="no" media-type="text/html" doctype-public="-//W3C//DTD XHTML 1.0 Transitional//EN" doctype-system="http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitiona…

I am trying to find a simple XSL example file for exporting from FileMaker. I have reviewed several examples and have templates for exporting to CSV, A general XML dump. What I am really looking for is a simple guide or other simple tutorial that will let me understand how to export a specified set of fields from a group of records as a xml. Thanks

Sorry to add to the noise here with another "help me" post. It seems there are so many of us with XSL questions. I am creating XML from Filemaker database that is essentially a calendar of events. There's an event parent with child elements like eventtitle, eventdate, etc. One such child is a category for the listing. I would like to process the XML so that the category remains on the first instance for an event and is "stripped" on subsequent repetitions. This is for placement in a layout application so that there are headers between each category but not with every event. Can someone point me in the right direction? I have attempted to do this at the so…

I am trying to import some stock quotes from a webservice and getting an error that my XML document is not correct. Can someone look at this XSL stylesheet and tell if there is something wrong with it. I sort of put it together based on another one that worked. I am attempting to import XML data into a table and specifying the name of the webservice in the HTTP request of the Import records and selecting this SXL stylesheet to format it. <?xml version="1.0" encoding="utf-8" ?> 0

Hi, I use exported XML to transfer data from FM to another application that processes it. The exported XML contains very sensitive data and is easily accessible by the users. How can I encrypt the exported XML and then decrypt it by the other application? any tips? Thanks a lot in advance!

What is the prefered method, if I want to reexport to XML in the same format as the sourcefile. Is there a way to get the same structure (without the filemaker mumbojumbo). Like this: Source XML (with a transformation to the fmresults.xslt) goes in - Manipulation in Filemaker - Export to XML with same format as input file... Cheers Lars

I'm struggling with my first dabble at XML importing to FM. I read some docs, tried this intro intro and it sort of made sense, so I ran it against my Formstack XML source but it just comes up with an error XML parsing error: unable to open primary document entity'' Clearly not working, so I tried to roll my own, and that has got me stuck... I was trying to adapt comment's contribution but I'm stuck on how Formstack integrates the data, specifically the three questions in the form. I want to gather both the submission data as well as the three custom fields. This is my trying to learn the ropes on a simple test form so I can try it on other FormStack fo…

I am searching for a xslt template for craigslist.com feeds. I have tried to get my head around the RDF tags but my limited time just hasn't been enough to decipher how to do this. Does there exist a good example for FileMaker to import craigslist feeds? Thanks in advance for any help.

I'm using FileMaker 11 Advanced, and I'm exporting data as an XML file. This exports fine, but on certain records I have foreign characters that are exported and tripping up the ultimate XML import into another application. I'm trying to find a way to "clean up" the text in FileMaker so that these foreign characters don't corrupt the XML file. Some of these problematic characters appear in FileMaker to be: Ê ¥ ...and so on. Is there a way to strip out foreign characters in FileMaker before generating the XML file? Or perhaps an program/online site that will allow one to convert an XML file with these types of problematic characters to…

I recently got help from Fenton and comment on a stylesheet problem I had. Subsequently my third-party and amended his file so that it only includes records from x1 table. I thought that this would be a simple task and just alter the stylesheet accordingly. However, when I set up the import in FP I can see the import mapping dialog but when I run the import no records are imported. I've attached both an extract of the xml file plus the stylesheet I've created. Can anyone see where I'm going wrong? Stylesheet_v2.zip

A third party wants to supply their data in XML form and I need to create a stylesheet to complement this in order to import into my Filemaker 11 database. Attached is a demo file. I have very little experience of using XML and the way the file itself appears is not in the way that I familiar with. If anyone out there can help me a.s.a.p. I would be most grateful. data.zip

I have given up on Google Directions, as it works, but only sometimes, due to the query limit and the domain that I am using. I switched to MapQuest and I get a result everytime, but only in my browser. I have an XSLT stylesheet and FM accepts it at first, even lets me specify the import order, but when it comes time to import, it fails. I have a file: directions.fp7 - field: narrative (text) I have a MapQuest key: lalalala(obviously an example), and I have the wildcard setup in the API key account so it shouldn't care which domain is requesting it. I have an XML Data Source: "http://www.mapquestapi.com/directions/v1/route?key=lalalala&…

Hello Folks, I have been struggling with an XSLT transformation problem. We have an XSL which is 2,116 KB in size. It works when XSL is about 1 MB. It also works in some servers, but as soon as it is deployed on a Widows 2003 server, this starts timing out the request. from Event log it is :" Event code: 3001 Event message: The request has been aborted. Event ID 1309" The XSLT works fine on local machine as well as the other server. To transform the XSL, we are using the simple standard code like "XslCompiledTransform xslTransformer; xslTransformer = new XslCompiledTransform(); xslTransformer.Load(sXSLTransformPath); StringWriter sw = new String…

Hi I'm new to XML and I need some help with xsl style sheets. I have an xml file that is generated from our webpage that I need to import to filemaker. I don't understand how to make an xsl style sheet for this file. Can someone please help med? Johan <?xml version="1.0" encoding="UTF-8"?> Bas-Elbas-Epiphone Thunderbird Goth 118151 00000000003245.0000

Hi ! I have this xml-file 20100525 DJ2 inv_nr 20100525 trn_date {27-05-2010} sub_nr 242868 So... How do I get the of 242868 from the the tag when the 'sister'-tag when the value is 'sub_nr' ? I can kind of do a brute force /AVXML/EBUSMSGSRQ/EBUSTRNRQ/ROWADDRQ/FIELD/NAME to get to that level , but how do I go to …

Hi All I have an XML file... I am using the XSLT file that came with FileMaker and I can get the xml to import fine. The problem that is causing me grief is that being new to XSLT, I cannot find how to only import the data that has a type="act". I'm sure this is simple... can anyone help?

I am testing a mapping solution and I have the following: 1. A list of location addresses. 2. A XSLT stylesheet (it actually works) 3. A well formed xml request to Google Maps Directions API 4. A FM solution that captures this data. Everything works, so the problem is this; Everytime I work working on this solution, it just up and stops after a little while and dies until a day or two has passed. Yes, I copied the URL for the XML into my browser and I get a result of "OVER QUERY LIMIT". Ok, I sign up for an API key (note that the DIRECTIONS API instructions page clearly states you don't need one, but anyways). I try again, nothing. I don't un…

Hi All, I have an XML file I need to convert to FMPXMLRESULT for import into Filemaker. I've written an XSLT, and for the most part it's working, but one thing is tripping me up. I have one value in the header of the original XML that I want placed in every row of the resulting FMPXMLRESULT XML, and for the life of me I can't figure out how to do it. The value I want from the header is "Title" which contains the text "112_Version 6/17/10." I've set up a column for it in the XSLT named "Version_Name." Here's the original XML: <?xml version="1.0" encoding="UTF-8"?> 112_Version 6/17/10 V1 3 0 0 48600 3037+08 00:33:44:…

Hi all, I am in trouble with xml exports. I get "An invalid XML character (Unicode: 0xb...) was found" error message. Some special characters break xml export process. And it is too hard to detect invalid chars in the records. I have figure out two of them (code 11 and 29). For that two characters i am using substitute function to delete them. Code 11 and 29 are solved now. But I dont know when will I met a such error for another invalid char later. I want to solve this case forever. But first i need list of invalid characters. Such a list is present in somewhere? Thanks in advance. F. Osman Cabi

Working on my XML/XSL Filemaker project again and am wondering how to implement the format-number function to get currency format from Filemaker Data. I understand the syntax of the format-number command, just not how to apply it to the field data coming from Filemaker. This gives me what I want: as it returns 12,345.67. But that's obviously static text. Here's the XSL for the field I want to apply the formatting to: So where do I put the format-number? Thanks for any help! Mike

Something with this XSLT stuff is not clicking. I've looked at tons of samples but none quite match what I need. I've attached my XML data document. I want to import Page Number value and the Key value, but only on the entries where the "Field" value = SKU_ID VALUE". For example...see entry index 9 and 19. I know the XML is formatted a bit strange, but I don't have any control over it. Can someone help me with the formatting on the XSLT file? Page_Data.xml.zip

Help! I have a layout in FMP that shows a date field in the header. It performs a find before showing the layout so that the value is the same for each record. I want the layout in XSL to also show the date in the header section, but I can't get it to show a record value in the header. I've used the Filemaker XSLT Assistant (In FMP 10 Server) to create the original pages, but I still can't get the info from a field (that's in each record I'm going to show) to show up in the header of the page. Any ideas? Thanks! Mike

I get regularly get order data provided from a third party in XML and until recently I have not had any issues, but now I am getting import error messages - but only intermittenty. The error messages read either; XML parsing error: Invalid byte ‘a’ at position 2 of a 3-byte sequence Line Number: 1 Column Number: 22 or; Filemaker Error Message; SAXParseException: invalid byte ‘n’ at position 2 of a 3-byte sequence (Occurred in entity File Location at line 1230, column 23.) I thought, perhaps, that having recently upgraded to FP11 it might have something to do with that, but a colleag…

I have an XSL sheet for creating CSV data files. It strips any extra return characters and commas from the data and creates the CSV without having quotes around all the data. The trouble is I need to have carriage return+line feed as the EOL char. For some reason I am getting two carriage returns + line feed. Please see attached CSL file. Any help greatly appreciated! data.xsl.zip

I must have a mental block with XML/XSLT. I need to do an XML import (I think). I've played with the FM supplied example and looked at several other resources but can't make the transition to my situation. Can someone help? The spec I have is attached. The 'download' is what I need to 'import' into an FM file. Where do I start? What do I need to do? I would be happy to have everything go into a single table. Any direction/help would be appreciated. XML_spec.pdf

Have no idea if this is where to post, but I can't decipher the following language: 'Typically, folks use HTTPS over TCP/IP (POST & GET methods) to connect to the API pages to upload & download data, as you would any typical web service. How to do this would depend greatly on the programming language used. For each exclusive URL we include the appropriate method to connect in the page name, so there’s no confusion.' I had to buy a link into a web-based application to satisfy some potential clients and have to upload a couple of Filemaker-created files to this application. They gave me a '.asp' link and the instructions above. I have no idea what to do. T…

Given this XML... <?xml version="1.0" encoding="ISO-8859-1"?> AB:123456 AB ALPHA BETA 123456 FUNK FUNKINESS MEDINA FUNKY COLD MEDINA AB 123456 FUNKY COLD MEDINA AB 123456 FUNKY COLD MEDINA WITH 14 SILVER SPARKLY THINGAMAJIGS This is the best Medina you've ever experienced. Really redefines the concept of Medina in all its funkiness. FUNKYCOLD.JPG http://www.example.com/images/FUNKYCOLD.JPG ht…

Hi all, New to xml to filemaker pro transformation and import. Help would be much appreciated. I am trying to import the following xml: <?xml version="1.0" encoding="UTF-8"?> Monterey Herbson's Pices 1 12-01-2002 23.54 ABC1231Oregano23.5423.54 2 01-06-2003 …

Hi all, I have been looking for a solution to add header labels to an excel file export. I found a post with a sample style sheet which will work fine if I can just figure out how to edit it so that it doesn't skip a row between each record. Can anyone tell me how to edit this thing? <?xml version='1.0' encoding='UTF-8' ?> xmlns:xsl='http://www.w3.org/1999/XSL/Transform' xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm"> Col1,Col2 Again I am just looking to re…

The new FileMaker 11 Snapshot Links look like a nice way to track a found set and could be stored in a container field for future reference but I would like to get more out of it. I am wondering if you could import the individual elements from the Snapshot file into separate FileMaker fields and later merge separate Snapshots to create a combined found set or new Snapshot Link? Playing with the Snapshot file in a text editor it looks like you could merge separate Snapshots by confirming that they used the same "baseTableID", updating the "rowCount" and combining the record numbers from each Snapshot Link. I am not very familiar with FileMaker XML imports a…

Hi: I have been able to figure out some XML importing in the past with data coming from a much simpler file. This XML file has me really confused since the data for this file is broken up into sections and sub sections. I am wondering if anyone could help me figure out how to build the proper XSL file to facilitate importing this XML file. The first section is file information and I need part of that information included on a column in each row. The second section is ownership information and again I need part of that information included in a column on each row. The last section is lot information which is further broken up into a sub section for each owner…

Hello, I want to know if it's possible to import gzipped xml in Filemaker 10 or 11? I've got it working with the local decoded xml and xslt, the next step is to make it work with a direct URL request. Therefore I must also send the "Accept-Encoding: gzip" header. How can I do that in the Import XML HTTP request field? Thx, Paul

Hello, I have this (part of a) xml file of which I want to import the artist name and join. ABC Featuring Contessa Lady V The Night You Murdered Love The difficult part is that I want to import integers as because in Filemaker I have related table Artists (ID and Name field). I haven't got a clue how I can do that. So while importing via a xslt, is it possible to lookup the ID value of 'ABC' and 'Contessa Lady V' in the Filemaker Artist table and import the ID values only? Any help appreciated! Thx, Paul

OK, so I have done a little XML and can import material from simple feeds. I have a few apps I have written and they run fine. I paste the feed, select the style sheet, and import. No problem. Starting last Thursday, I began a new file for a new project and I needed some RSS imports so I did as I always do, I copied a stylesheet that works, checked the tables just to make sure the field names line up, closed the sheet, pasted the RRS address into the import, selected the sheet and this is where the problem started. When I went to Specify Import order, FileMaker begins to send up a error that: I started poking around and trying again, moved the sh…

Hi all, Is it possible to create one parent record and then create multiple child records based on the XML file? Ricky