XML/XSL

I had some images for a web page header pulled in by a CDML inline-action and it worked wonderfully. I used an Include file to make the headers on everypage the same. Now that it has been converted to XSLT it doesn't work, even though the xsl is valid and well-formed. The URL is 209.114.248.9 - you'll see roughly what the header looks like on the index page, but when you click Day-Timer (usr=Admin, pwd=joetrox2), the first search page comes up nicely except for the header images... Any ideas? Help?

Using a XSLT solution (converted from CDML). Form is presented to user (update page) with fields containing data from database. But when the user submits the form the error page is presented (with a captured error code of 957). I have looked high and low for what "Conflicting Commands" means. A call to filemaker failed to come up with answers... Any thoughts?? Brian

Converted CDML solution to XSLT using CDML Converter... The solution includes a (URL) link for deleting a user, but the user (record) is never deleted. Any ideas? mywebsite.org/fmi/xsl/addusers/delsuccess.xsl?&-db=newusers&-lay=General&-recid=1254&-grammar=fmresultset&-delete There are no errors, and the delsuccess file returns properly. Please help! Brian

After submitting a form (using XSLT - was CDML) to perform a find, I receive the following error: Could not find variable with the name of default-record (XPATH-ER0081) The line and column listed refer to a blank line. Any ideas? Brian

Hey all. I would like to script an XML import that uses an XSLT on an HTTP server and am wondering if anyone has any metrics on how much traffic i would expect my web server to see? I'm thinking no more than 10 hits a week (at most) on that xslt. The .xslt is about 22 KB; the average .xml file, maybe 50K, and never any more than 100K, i wouldn't think. I don't know what else would be relevant... TIA, Jerry

I need some insight in the nature of XML and FMP. Objective: Is to import data into FMP from a ...not sure what ya would call it. I have a parts supplier that I can use their supplied program that goes out onto the web and connects with a catalog that I search the part im looking for. This function is not http in a browser, it is through their program. In normal function when I find what I want ... I click the ORDER button and they send it. The parts company supplied a SDK for software intagration and in the nature of playing with it, the ORDER button turns into EXPORT button. I click it and a window named XML'er opens up with the data i NEED! It looks li…

Here's what we've done in the past: <- CDML Parser <-> FM Unlimited 5 <-> FM Server 5 <- | FM WSC | <---> | FMUlimited | <---> | FM Server | Apache in Linux, using FM Webserver Connector to parse the CDML. Worked just fine, although three computers in the chain was a bit overkill (more points of failure). Now, I have learned how to do the following: <- PHP / FX.php -> FM Server Advanced <- | FX.php | <-- XML --> | FM Server | This is cool, because now we have only two machines in the transaction, a DB server, and a web server. How it should be! Awesome! And PHP gives me tons more flexibi…

I am currently struggling to get a very simple XSL solution together. I am particularly stumped by the skip records/next/previous aspect of my pages. Can someone very quickly explain the syntax for getting this to work? Just to reassure me, is anyone else struggling to get to grips with xml and xsl? I have used the CDML converter without success and the filemaker site assistant without success. And to try and build a solution combining elements of both is impossible because both appear to use different syntax. I understand the principles of xml. Putting it into practice is another matter. Even the filemaker custom web publishing manual is extremely difficult to inter…

my server is http://myserver.server.com the web publishing admin config is in http://myserver.server.com/fmi/config - this works fines when i used the assistant, it save the xls files in the d:documents and settingsmemy documents now when i type the url http://myserver.server.com/fmi/xsl/sample1.xls it says that the requested stylesheet could not be found. it says in the documentation that is optional. if i have to include the part, what should i put? i created a separate website for this but it still did not work. please help. thanks!

Warning: this is a newbie post. I have a simple xml document with about 100 records that I want to import/export to/from Filemaker. Each of the 100 nodes has 3 attributes. I now realize that Filemaker can't figure out my document and I'll need an xslt stylesheet to transform my document to "the Filemaker way." My question is how to do this? Or is there something in Filemaker I don't know about that will magically do it for me??

Here's the deal: Environment: 100% Custom Web publishing - Web Browser at the user, and Filemaker 7 Advanced at the server. The Web Server = Filemaker Pro 7 Server Users need to be able to add a record to a table, which simply does some quick calculations and outputs the results to a TEXT file on the Web Server/Filemaker 7 Server host with a name calculated from the user's submission. The record add and calculations are done, I simply can't figure out the rest. After the users add a record, the reply page provides a path to open the file (basically), so I need Filemaker in complete control of the process to ensure the file is ready, named per the calcul…

i just finished instaaling the fm server 7 advanced but i still cannot set the xlst keyword in the extended privs. i'm very new on this and will really appreciate any help. what am i doing wrong, or what am i not doing? when i run site assistand, i can connect to my web server but since i don't have the xslt in the extended privs, i cannot enable it on any of my fm 7 databases. thanks!!

Since the web does not create the best looking documents for printing, is there a way in CWP to have FileMaker Pro generate a PDF for the user to download and print? Can a FileMaker Pro Advanced Server on OS X be scripted to Print to PDF and have the document available for downloading to client machines somehow?

http://fpas.neenah.k12.wi.us/fmi/xsl/curriculum/detail_ptr.xsl?-lay=Objective_A&-recid=1814&-find What is the needed code to present a text field on the web as it was typed in FMP Client? I have a text field to present Rubric/Scoring Guide information, that has been typed as an outline, yet when the text field is displayed on the web, it appears all the paragraph RETURNs have been stripped out. I would like this field to appear correctly to the reader, yet I don't know how. Can anyone give me some assistance? thanks,

Dear Forum, I have a relational database which I want to export to XML, to be used in Flash. Now, my question is, how should a relational database be exported in XML. Given my understanding of databases, XML and database are very different. Databases use records and relations, while XML uses nesting to achieve about the same, ie many to many relations. This is roughly my idea about these concepts. Anyhow, how would you export a relational database to XML ? Up to now i have 2 ideas, one is to generate/calculate a big join file at the database side, and export this file to XML. Not to elegant. The other is to export the simple/flat files seperately and d…

Neenah Joint School District Curriculum Search Page | NJSD Curriculum Home | Teaching Resources | NJSD Home | search_results.xsl Department: - No Selection - Course Number: Course Title: …

I am trying to import some data returned in XML format from QuickBooks qbXML. I have no trouble getting the data from the rows to import, but I really need to match up a bit of data as an identifier. The data is contained in the attributes line in the "InvoiceAddRs requestID="xxxxxxx"..." where the xx's represent the number. Can someone tell me how to extract that item to use for a matching records import? Attached is the actual return. I am building this aspart of an FMP6 application Thanks DflyReturn.zip

I am publishing fp7 database using XMl/xsl (custom web publishing). I have a search and search result page. these are .XSL files. I want to implement pagination in searchresult page. Result page should include Previous- Next link for navigation. Thanx

Hello, Does anyone know if there is a standard xslt document that can import the xml library from iphoto ?? I tried to create something but i cannot retrieve the album names. all i get now is the path to the thumbnail and the original photo. I want to be able to import photos from a certain album.

Well, not exactly XML specific, although this is going into an xslt page. I've been asked to build a web form for a user who must do all data entry using a numeric keypad. I would like a way to substitute the behavior of the Enter key with the Tab key - so she can "tab" through the fields using the Enter key on the numeric keypad. I don't think accesskey tags will work here. Of course, this might mean the behavior of the "submit" button will be broken, but I'll deal with that after I find out whether the above request is even possible. Any ideas? thanks in advance, Colin

Where can one get some helpful XSLT assistance? I am trying to convert a solution from FileMaker Pro Unlimited and CDML to FileMaker Pro 7 Advanced Server and XSL. XSL is all new to me, and I am finding several things difficult to do. Create a popup menu based on a value list (nothing has worked for me). Display a graphic from a container field (I just get the code to appear, but no graphic). It all seems so much more difficult than before. Is there another forum things like this are discussed? Am I just doing this too quickly, and no one else has tried yet? Any help is appreciated. I am not getting any from FileMaker, nor are there any books on …

when exporting using xml in single user mode I set the xsl in the same folder as the FM files, but when the files are hosted where does Filemaker on the client look for the xsl file? I could find no documentation anywhere on Filemakers site, manual or help. I did find someone that wrote, in OS X Filemaker would look in the Users/user/Documents folder. But FM does not find the xsl file. Any ideas for OS X, OS 8/9 and Windows? (FM 6)

I need some help with custom web publishing and don't know where to turn. So, what I am proposing (especially if there are other education people here), is to open source our solution so I can get an understanding of XSLT and how all this works with FileMaker Pro Advanced Server. So, I need to know how to go about this. I can post my .xsl files on my web site, or bundle them up with the fp7 databases for others to look at. What I haven't figured out so far: 1) How to create a populated popup menu on the web. 2) How to show a detail record with an accompanying related list of records on the same web page. The database is a Curriculum Database with Wis…

I understand that FileMaker does not support an XML POST, only GET. But many XML services require you to be able to submit via POST, often one using HTTPS. Am I understanding correctly? I would like to learn how to integrate services like UPS Online Tools, Apple GSX, and so forth into my FileMaker solutions. Would Beverly Voth's book help me here? I noticed Apple publishes some documentation and even a modified version of the FileMaker Solution Framework (FMP6) at http://aboutgsx.info.apple.com/integration/. Rather then using XML from FileMaker, they're going from FileMaker to AppleScript to some custom Java application (source code included) and fina…

We are currently using v6 of FM to host web pages. We need to start doing some delivery in foreign languages. For this our best solution is going to be FM7 with its Unicode support. I have a question about my transition over to XML: Our current solution relies HEAVILY upon very specific web page layout and design. For example: 1. Tables. Certain cells are encased in [FMP-If] statements to indicate whether or not the cell contents get displayed. The table and cells are all set to specific widths and heights. 2. Use of text boxes encased in [FMP-If] statements. Text boxes are again place in specific places on the page using specific dimensions. 3. Check …

Which format do you think is better to use? I personally like the DSO format because the XSLT is much easier to write, i can just match on the element names. With XML result every field is in a tag and the field names are in a header. This means I have to use all kinds of XSL tricks to make sure that my stylesheet works if the order of the fields is different in the export. The problem is that it appears that FileMaker has deprecated the DSO result format. Why? Should I really not use it?

I would like to enter some HTML into a field in my database. Then export using XML/XSLT to produce a web page. Unfortunately, the export escapes all the HTML tags. Is there any way to turn this off during the XML export so that I get the actual characters? Any suggestions on alternative ways of doing this? (i.e. Inventing a new syntax and transforming that syntax. Oh fun.)

How can i import XML data into repeating fields in FM6? I was able to export repeating fields to XML in FMPXMLRESULT grammar, and it looked like this: ... <RESULTSET FOUND="1"> <ROW MODID="1" RECORDID="1"> <COL> <DATA>some data</DATA> <DATA>different data</DATA> <DATA></DATA> ... </COL> </ROW> </RESULTSET> ... But i wasn't sure of its usefulness. Additionally, immediately after exporting this file (without a stylesheet) i try importing it (again, without a stylesheet--no transformation is needed, because it's FM's native…

Hi Everyone, I have a problem with XML Import. i try to import data from : http://bankisrael.net/heb.shearim/currency.php?curr=01 This is an XML page with the daily dollar rate. I want only 2 fields : the rate and the change date I want to implement it by script. When I try to import the data I get an error = XML Parsing Error Is anybody know what can I do about it ? Thanks Nes

It has to be possible-- to do an import and let FileMaker Pro line up the fields from the XML file with the fields in the table I'm importing into. But how?

Is it possible to insert images into my container field or even an http:// reference via FMP XML import? Thanks!

Has anyone been able to use Flash MX Professional 2004 XML Connector Data component to connect to FileMaker Unlimited?If so, would it be possible to get a sample? Is it possible to start a Flash to FileMaker subject group under the Internet Heading in FMForums?

I have an XML file that is generated by FINAL CUT PRO 4.5 ( A sequence XML Export) that contains data that I would like to import into a FILAMKER DB That I am Developing. The XML Output file from Final Cut Pro contains a LOT of Data, and I can see the parts of the data that I want when I look at the XML File with a TEXT App. I have discovered that you need a "STYLE SHEET" or XSL file that FILEMAKER Needs when importing. The Questions is... How Do I make a "STYLE SHEET" that can extract only some of the required data from the XML File? I am a beginner as far as XML is concerned, I have search the web only to get more confused with XML. I have a ver…

Is there a way to get the path to an image into the XML you export from FM?

I am trying to create an RTF via XML. I want to group first by column 1, then by column 2, but I can only seem to get column 1 headers. The problem seems to be with how I create a second key. {rtf1macansicpg10000cocoartf102 {fonttblf0fswissfcharset77 Helvetica-Bold;f1fswissfcharset77 Helvetica;f2fnilfcharset77 Verdana-BoldItalic; f3fnilfcharset77 Verdana;f4fnilfcharset77 Verdana-Bold;} &cr; f0b &cr; f1b0 &cr; &cr; &tab; &tab; &c…

I've tried the example XSLT file that was on the Filemaker webpage (msxml_single.xslt and msxml_multisheet.xslt) to convert to XML for Excel, but it seems to be incredibly slow. I had to kill FM because my first attempt to export all the records was still running after about 20 minutes and had only exported less than 100 out of 9000 records. Even trying with only 500 records, it's taking several minutes. I just want the data to be exported with column headings -- nothing fancy. Apparently the XSLT I'm using is extremely inefficient for just that. While I could spend a lot of time trying to figure out how to optimize the XSLT file to speed things up, I figured…

Does anyone know if it is possible to use XML to tie a FileMaker database to the System Wide Address Book in OS X? I am creating a solution that will have a customer list (don't they all) and would like to have the name, company, phone number and email data reside in the System Wide Address Book while keeping the address info in the FileMaker database. The goal would be to utilize iSync to sync the address book data across multiple computers and devices with zero effort beyond developing the intial databases. Any hey, if not XML, is there any other way to do this? Will this be a feature in FileMaker 7? Thank you, James

I have a large number of items like this: <row> <class>TYPE A</class> <field1>foo1</field1> <field2>bar1</field2> </row> <row> <class>TYPE A</class> <field1>foo2</field1> <field2>bar2</field2> </row> <row> <class>TYPE B</class> <field1>foo3</field1> <field2>bar3</field2> </row> I'd like to separate out all the "class" fields and come up with something like this: <class name="TYPE A"> <row> <field1>foo1</field1> <field2>bar1</field2> &lt…

hi guys, we'd like to exclude certain fields from an xml-export, using an xslt. these fields can be identified by its value: it's always 0 (zero). what would be the code, to achieve this? thanks in advance. michael.

Hi, We are trying to convert one of our FMP client-server application to Web application. We are not sure what tool should we use to build the web front end, but one of our considerations is XML and FMP 7 files as a back-end. We know we need to have FMP Server Advance to serve FMP 7 file. We have never done Web Application before, but we willing to learn new technology that not only help us to do the job now but give us a potential grow in the future, some kind of the industry standard tool. I wonder if someone give us some advise/information such as: 1. XML editor that has debugger cabability 2. a Graphic Visual XML tool. 3. or any thing that we need to…

I'm having some trouble on how to get out multiple <data> that is contained in a single <col> element. It only prints out the first <data> element when a <col> element has multiple <data> elements. The 9th <col> has the related <data> and in some cases may not have any. What I am atempting is the format below: Question Text 1 Question Text 2 related data 2a related data 2b related data 2c Question Text 3 Below is an example of the XML file: <?xml version="1.0" encoding="UTF-8" ?> <FMPXMLRESULT xmlns="http://www.filemaker.com/fmpxmlresult"> <ERRORCODE> 0 &lt…

I've been working on an XSLT and I'm getting different results in the HTML page produced. In creating my XSLT, I have been using TestXSLT http://www.entropy.ch:16080/software/macosx/#testxslt. When I export my data from Filemaker using the same stylsheet I get different results on the HTML page. As far as I know FileMaker uses Xalan-J as its XSLT processor which TestXSLT has as an option for XSLT processor to choose from. I'm not quite sure on how to best approach the different results. Using TestXSLT's Xalan-J, I get the results that I need and exporting from FileMaker I get a whole different result. Any advice would be appreciated. Thanks.

Can anyone help me to understand how I can script a unique file name when performing an xml export. I would like to automate an export which creates a file with unique and meaningful name. Ideally I would like to take data from a single record's field and insert that as the filename. For example if I am exporting a client record I would like the xml export file to be named "smith.xml".

Hi, Is there a way I can export a field with a line break in it in an xml output? For example, I have Name and Phone as fields, and a calc field, NamePhone, that concatenates the two: Name & "P" & Phone (where P is the line break character.) If I export NamePhone the line break is ignored. I've also tried Name & "&#xA;" Phone Where &#xA; should produce a line break, but on export the & is converted to &amp; I've tried enclosing it in quotes too, but that doesn't work. Is this possible?

Hey, I've got some FileMaker xml output (FMPDSORESULT style). I have a list of people and their phone numbers... ... <CriticalGroupMembers.PersonName> <DATA>Bergman, Carrolyn</DATA> <DATA>Brill, Daniel</DATA> <DATA>Brill, Helen</DATA> </CriticalGroupMembers.PersonName> <CriticalGroupMembers.PersonHomePhone> <DATA>999-999-9999</DATA> <DATA>320-999-5644</DATA> <DATA>716-999-4844</DATA> </CriticalGroupMembers.PersonHomePhone> ... I want to transform this with an xslt…

I'm new at xml/xlst. I'm proficient at CDML. I'm not understanding where the xslt file goes....(web folder) and how this all ties to getther. The samples that FileMaker provides only work on windows. Viewing XML web sites only work on windows? I need some Help. I have a client that wants to update to 7. 7 does not use CDML. I have been reading the FileMaker Dev 5.5 book on xml. Is there a step by step sample file on how to set up a simple web page on the Mac OSX?? Thank you for your time. Todd Dignan

does anyone have a sample of a FMP webiste using XML and not CDML?

Has anyone tried creating an RSS feed from an FMPro XML export?

I was wondering if there was a way to have a runtime solution update a central database with new records. I have a rather complex estimation solution and I want to be able to create a central reporting tool for them. I want to avoid using email if possible (unless it sends by itself - not going in the user's outbox). I've been reading on XML and stylesheets - is there a way for FM export to a web enabled database via XML? I imagine that people have wanted to do batch uploads of records - I just can't find much info on it. -------------------- Sam Newnam SystemSam Technologies, LLC

Well Ive got my new database exporting into an XML schema called MODS. I'm happy this works, really. anyway now the problem, I wanted to take the information stored in these xml documents and disply them as simple xhtml. this should be fairly simple via xslt, but i cant get the xml information to properly display. I've attached a extremely simplistic version of a MODS document, and a hacked version of a XSLT example from w3.org. can anybody point out where my error is (I'm kind of at an impasse and can't further develop my project until i get this XSLT happening. thanks ahead, -d mods_xslt.zip

OK, I'm a latecomer, having upgraded from FMP 3. I've done a few solutions back then and want to get my feet wet with XML and QuarkXpress. I usually learn by digging into a small project. In this case, I want to setup an interface to create business cards for my company, which will feed the XML into QXP6 and create a pdf proof. Reading up on avenue.Quark, it says I must use a DTD. OK, the only DTD I see is FMPDSORESULT and its sister, FMPXMLRESULT. None of those look like what I want to end up with, which is something like: <name>Sam Walton</name> Instead it looks like <data>Sam Walton</data> and all the other fields. And the examp…

I am trying to create an XSLT from a Word document so I can create a similar word doc direct from FM6. I understand that there are some 3rd party tools to do this but would like to know if I can produce one myself without needing to spend hours learning code. Does anyone have any advice on what I need to do? A secondary question is whether I can produce a PDF automatically from FM6 either directly or via FM scripting. Thanks.

Currently I have a stylesheet that will take exported FMPro data and convert it into an html file with a simple table: one row per record with three columns to match the date. For example: ___________________________________________________ |image source info 1 | image name 1 | description 1| ___________________________________________________ |image source info 2 | image name 2 | description 2| ___________________________________________________ What I would like is for each record to span two rows, like this: ___________________________________________________ |image source -> | image name 1----------> | |inf…

I am having trouble getting an xml import to work in Dev6. I have a test db with the field "Company", and an xml file (attached) using the xslt file (also attached). I have gone through it, using an xslt that works for a different application and source, but I can't get it to actually import the record. Any hints or suggestions would be appreciated. It appears the attachment went missing so I re attached it 09 May 2004 TroubleXML.zip

since word 2003 files are completely XML now, using Word's particular grammar, one can script an FM 6 export and use an XSLT file to create a word document without any other importing or programming. there is an example of this on FileMaker's website. the issue i am having is creating a Word document that has the same number of instances as the number of records exported. has anyone worked with Word 2003 and FMP much? any tips on transforming the exported file into a word document with multiple instances? thanks! chris

All the examples I'm finding online and in my books seem to assume that I want to take xml, process it with an xslt, and create html output. (Even this XML forum is under the 'Publising FM Online' heading). Of course, xml isn't just for creating html output. What I'm having trouble with (beyond some really basic stuff) is taking xml, processing it with an xslt, and creating a new form of xml as my output. To be more specific, I need to export output from FM (using FMPDSORESULT style), and use an xslt to turn it into an xml file that can be read by another program -- MindManager ProX5 from Mindjet in this case. The problem I'm having is that the xml that MindM…

I've read through a lot of the posts in this forum, but still not sure how I would create (and use) an XSLT template to allow me to import data from an XML file. Here's a link to a sample of the data I'd like to be able to import. Thanks for any guidance anyone can offer! Jeff FileMaker Version: Dev 6 Platform: Mac OS X Panther

Hi, I want to download information from a FM website using XML. The website however user the web security database for added security. When I try to import data using a HTTP request I get an exception saying "could not open file". I know the problem has to do with passing a username and password inside the HTTP request. What I am trying to do now is http://username:password@ipaddress/FMPro?-db=Study&-format=-fmp_xml&-findall This works fine directly from the webbrowser but it does not work from filemaker. Is there any way or workaround to pass the username and password from the web security database in such a XML import request? FileMaker …

With FP6, when I export in xml format a text field where I put somme html tags (like <b></b>) , they where be transformed into "& lt;b& gt;" and "& lt;/b& gt;". Il found a solution : I put "<![CDATA[]]>" at the begin of the text. I know, this is not a right xml syntax, it'is more a bug of the FP6 version, but it works. With FP7, this solution will no work anymore. How export text fields in xml format with usefull html tags inbedded ? (sorry for the wrong english syntaxe ;-) FileMaker Version: 7 Platform: Mac OS X Panther

When exporting as XML using an XSL stylesheet, you are offered the opportunity to locate the XSL by using data in a field (HTTP Request or Field Request). I assumed that, because I was trying to locate a file on my own computer, this would be some sort of URL address that started with "file:///" instead of the usual http://. But this doesn't seem to work. Anybody know what information should look like which steers Filemaker to access a particular XSL file? I thought it would look something like this: file:///HardDrive/Documents/Folder/Stylesheet.xsl/ But that doesn't seem to work. Version: v6.x Platform: Mac OS 9

Hi, How does one get portal infomation from dso output via standard xsl ie <FMPDSORESULT> <ROM> <dave.stuarts> <DATA>New Zealand</DATA> <DATA>Canada</DATA> </dave.stuarts> </ROM> <FMPDSORESULT> I would assume you could navigate to it via <xsl:value-of select="FMPDSORESULT/ROW/dave.stuart/DATA"> or a for loop or using an array type structure DATA[0] but I can't get it to work. Thanks in advance

i'm trying to get on FileMaker's XML_Talk mailing list to no avail. i've tried signing up and sending to the address, but it tells me i don't have an authorized email account and gives me a web link to go to a posting page that says, "No Access". when i go to my preferences on the website, my email address i'm sending from is in there and it shows all of my subscription information. what gives? webcrossing's technical support hasn't gotten back to me yet, if they ever will. thanks for any tips on how to get on this list!

I am trying to wrap my head around the lose of CDML. Below is a write-up about 'FMP7 Server Advanced'. I am not sure of the potential of XML/XSLT. I understand that one is the data and one is the style sheet for the data. I sense that XML is a static data file (exported) for someone to grab and manipulate, But can it dynamically serve web pages like CDML. Can it find, edit, add, and delete records the way I could with CDML? In short what are the required pieces to create a dynamic HTML front end to a FMP7 back-end. ------------------------------------------ Why isn't CDML being supported by FileMaker Server 7 Advanced? FileMaker Server 7 Advanced u…

I am unable to generate a html output using a stylesheet with the following request .../fmpro?-db=XML&-lay=web&-format=-dso_xml&-styletype=text/xsl&-stylehref=new.xsl&-findall. However, using the export as XML option in FMP with the same stylesheet, generates the correct output. Please guide me. Mariusz Version: v6.x Platform: Mac OS X Jaguar

I have little problem understanding how to use XSL. This is what I have done: I created filemaker database with few fields and 3 records, then I created XSL file and did File->Export records->XML->XMLDSO and applied my XSL to it. I got file that looks like HTML, but with .xml extention, IE complains to it's syntax if I try to open it in IE. Am I suppose to rename it to HTML? And to create an online system that talks to running database, how do I get it to work with XSL? I don't want to keep exporting records. I'm attaching files that I have created. Version: v6.x Platform: Windows XP xml.zip

I got involved building a shopping cart for someone and they are using Orbital Gateway by Paymentech to verify credit card transactions. This is good news in that I don't have to be quite as concerned with security as if I was trying to do it within FileMaker. This site will accept an XML post action. I am picturing having the total from the cart entered into a form that the user then adds their credit information to. Would I then write the xml information into the action, or how should the information from the form get transmitted in the form of the post to the site?

Hoping someone here can help me..I know almost nothing about XML/XSLT, and am trying to import a very very simple XML doc into filemaker.. this is what my XML file looks like <?xml version="1.0" encoding="UTF-8" standalone="yes"?> <Root> <plate_code>34-101</plate_code> <plate_code>34-101</plate_code> <plate_code>34-103</plate_code> </Root> I just want the plate code to be entered into a field within filemaker while importing. guessing I need an XSLT to do that? any help would be appreciated! thanks

Hi All, I am new to Filemaker XML. I am wondering if FileMaker can create an XSD file based on my FM solution? Ultimately i'd like to use the XSD to generate .NET DataSet classes.. Is this possible with FM or with 3rd party software? Also, Is it possible using the FileMaker API that people use to create plugins for FM to create a native data Adapter to FM?? Are their any OleDB drivers for FM? What is preventing someone from writing these? rw

I have a form I am trying to submit and am using xsl. I need a way of editing the last portal row and the field in the last portal row. For editing the last portal row I have used <xsl:value-of select="fm:COL[7]/fm:DATA[last()]"/> in everything I use but for a field that I am editing in the portal I need the number, that is the last portal number. Is this possible? name="Evalrespond1::ShortAnswerResponse. Justin Grewe Platform: / Version: Windows XP Professional FileMaker Version: Filemaker Pro 6

Is there a way to query FMP from a web form and have it generate an XML file instead of just returning XML data?

In CDML there is a tag of Evalrespond1::RegistrationID.[FMP-CurrentRecordNumber]. I NEED to use xsl on this and I need this tag. I can get the Evalrespond1::RegistrationID, but how do I get the Current record number and have it at the end of <input type="radio" name="Evalrespond1::MultipleChoiceResponse" value="5"/> in an xsl document? Thanks a lot. Justin Grewe

I'm using FM5.5 and pulling data via XML. One of the fields in the FM database contains a photo. I've found an example layout and html format on the FM system that builds an image tag from some ID number of the photo such as: [img src='http://domain.com:8080/FMPro?-db=k3contacts.fp5&key=35544&-img'] That works great. However, that number 35544 (which is obviously unique for each picture) is nowhere to be found in the FM database. I can retrieve the recordID which is a unique key for the record but I don't know how to extract the unique photo number via XML. Can anybody show me an example of how to build a layout so I can extract the info from XML…

I'm trying to duplicate a sample I found on the FileMaker Site - One2Many example where a single XML file is imported into 2 FileMaker files using 2 different XSLT files. I seem to have a problem with one of the XSLT files - when I run the import, the Parent records are imported into the main FileMaker file but the Child records never make it into the related file. I think the problem is in the Venue.xslt file. Any help would be most appreciated! I have attached the files ziped. Thanks - Eric ESMxml.zip

my boss said that at some point someone demostrated an XML link between FMP and MapQuest at some FileMaker function. has anyone heard of this or done any integration between MapQuest and FMP? thanks in adavance! chris

Can anyone tell me if it is possible to import xml and have the records import data only if there is a match of one of the fields? If so, what is the key? Thanks

When switching to jre 1.4.2 I have a problem to generate a new transformer using: TransformerFactory transformerFactory = javax.xml.transform.TransformerFactory.newInstance(); Source xsl = new StreamSource(...); transformerFactory.newTransformer(xsl); The exception thrown is ConfigurationTransformerExcpetion: A location step was expected following the '/' or '//' token. This exception does not occur in earlier JDKs and in any case it occurs only for part of my XSL files. Is there a change in the XSL format that causes this exception?

using an xslt (with a good deal of help from Dan Brill) I can get a list of Customer names from QuickBooks imported to FMP. What I would like to do is have that list in a return delimited format to use in a global for a value list, without making 100's of records. I want to use that for the user to select from the list to update or sync the FM and QB files. Can this be done? Perhaps using XPath functions or something to get the list in one chunk vs many records?

My question is this: I have example database on filemaker that I have students names. I have a script that takes a student and adds a project for them to do in another database through a relationship. So in my xsl file I have a form that displays each row of students in the first database and has a button that you can add a project to each student. After I click on the submit button the results are displayed in XML. I have to use the fmp_xml format in the form in the xsl document because otherwise it wont work. How do I have the results of the request be shown in a xsl stylesheet? Thanks. Justin

Can someone give me some information of <fo page master and other fo commands? This is probably my solution to my recent post but do I have to what do I have to include in order to use it and how would I set it up? Is there a fo="www.fo.com or something in the stylesheet instructions? Thanks. Justin Grewe

I have two questions that I have been trying to find an answer to for months now. The first is displaying pictures that are in the filemaker container fields. The latest thing I have done is make a seperate field and call it pictureurl and have it in the xsl stylesheet by: <xsl:value-of select="pictureurl" disable-output-escaping="yes" so it works as long as I enter in the xml location of the picture manually. I need it to automatically calculate the pitureurl once I insert the picture into the caluculation field though. Is the way to do this by using the external function web-to-html or something of that nature? My second question is about text wra…

why this gives me an error : <xsl:attribute name="style"> <xsl:value-of select="display:none"/> </xsl:attribute> the problem is in the select value why is that?what can i do? thanks in advance peleg

Hi, I'm trying to parse a XML file to get the "RECORDID" so I can edit the db record using the CGI -edit parameter. The RECORDID is an attribute of the node <ROW>. Can someone show me how to parse the file to get that attribute? Here's the XML code- <?xml version="1.0" encoding="UTF-8" ?> <FMPDSORESULT xmlns="http://www.filemaker.com/fmpdsoresult"> <ERRORCODE>0</ERRORCODE> <DATABASE>TestWebEvents.fp5</DATABASE> <LAYOUT /> + <ROW MODID="6" RECORDID="44524"> ...(code) </ROW> </FMPDSORESULT> Thanks!

I have several thousand records in my FM db which are created from "cut and paste" methods in various fonts and sizes. I am looking for a style sheet which converts my data as formed (and added to each day) for xml EXPORT to replace "bad characters" then be read by server which has SQL (windows) environment. The "bad characters" are four; the apostrophe, the start quote (NOT using smart quotes), the end quote and the smart quote (both start and end are same). I am told it will take only two lines added to a stylesheet. Interested in finding developer who sells that stylesheet but prefer I test it first to see if it works.

i want to check in xsl if a substring is containded in a string for example does "fre" is in "sdfgsdfgfrezzzz"? 2) where can i find something like help index pf all the available functions in xsl? thnaks in advance peleg

Hi I want to sum up the bundle prices for which bundle id are equal. see the following flat XML. I am writing a xsl which transforms the flat xml into another xml. please tell me the logic and syntax of summing only the bundle prices which have equal bundle ids. mainly i want a logic and syntax of xsl and xpath. i am attatching the xsl file also. <ROWSET> <RESPONSE> <SERVICE_TYPE_ID>1</SERVICE_TYPE_ID> <SERVICE_TYPE>credit</SERVICE_TYPE> <SERVICE_TYPE_DESCRIPTION>Title Services</SERVICE_TYPE_DESCRIPTION> <PRODUCT_CATEGORY_ID>1</PRODUCT_CATEGORY_ID> <PRODUCT_CATEGORY>Mult…

i have an xml that i read the item tage every time in the end o the exml i have an <errorCode> tage ! how can i check that's it's there and read it's value? (i dont get that errorCode always but in certain condition's which i dont control!) : <item xsi:type="ns2:DRSpecData"> <DRType xsi:type="xsd:string"></DRType> <fax xsi:type="xsd:string"> 04-6560111</fax> <FName xsi:type="xsd:string"> &#1488;&#1489;&#1512;&#1492;&#1501;</FName> <plcType xsi:type="xsd:string">&#1495;</plcType> <licID xsi:type="xsd:string">14335</licID> &#1506;&#…

i am running in a for-each loop can i in the loop access directly the first and last child even after i left the first child and still didn't get to the last child? thanks in advance Peleg

Hi there, I understand from the filemaker documentation that the filemaker 6v4 uses Xalan XSLT style sheet processor. But I wanted to know the version of this processor. Can I update the processor to it latest version if it is available somewhere. (Where it is available?) Thanks a lot. Hameed

Hi there, First of all I am very new to XSL/XML. I have been asked to export a set of filemaker data into a formatted Excel sheet. I understood that FMP/XML with XSLT could do that. I had a quick look at the XSL examples which comes with FMP 6. Now I am testing it with the following XML I have a simple XML (a part cut/pasted from FM's XML export) as follows: <ROW MODID="0" RECORDID="1"> <col><DATA>aaa</DATA></COL> <col><DATA>bbb</DATA></COL> </ROW> <ROW MODID="0" RECORDID="2"> <col><DATA>ccc</DATA></COL> <col><DATA>ddd</DATA></COL> …

I want to be able to post Job Adverts directly from Filemaker onto an online job board using XML. I know nothing about XML but the site has supplied me with the necessary raw code and the following instructions: 'Using a HTTP POST program add a HTTP Header called SOAPMethodName with a value PostAdvert_IT' Is it possible to use TROI URL plugin to achieve this and if so how do I go about getting it to work? As always any help on this matter will be really appreciated. Kind regards Nick

I am utterly frustrated right now. I have 2 databases, I export one database to an html file named "notes.html" using XSLT and the resulting html file turns out fine. The second database, I export the records to another html file using XSLT as well. The XSLT file of the second database has a <xsl:copy-of select="document('notes.html') /> Where notes.html file is the html file generated from the XSLT of the first database. For some freaking reason, there are times when the notes.html appear in the resulting html file of the second database and in some cases it doesn't. I can't seem to figure out what is causing this irregularity. With just a plain html f…

How do I go about getting the value of a field from the previous row from which my XSLT for loop is currently on. I need a way to get the value of a field 'category' from the previous row to compare to the current value of the field 'category' Below is my sample code: <xsl:for-each select="/filemaker:FMPDSORESULT/filemaker:ROW"> <xsl:variable name="category"><xsl:value-of select="filemaker:category" /></xsl:variable> </xsl:for-each> Any ideas/suggestions would be appreciated.... Thanks.

Is it possible to check for the ERRORCODE element not equal to 0? If so, how? Just starting out with FMP and XML/XSLT and need to do some error checking for users accessing FMPDSORESULT XML data with a XSLT style sheet. Thanks!!

OK, I have a XML/FileMaker Pro reference book that says I can call scripts from in a database with the -script parameter, but it doesn't give any details on how to do this. Can anyone point me in the right direction? Thanks

I export a set of record into an html file using XSLT and there are occassions when the user enters html tags in the field such as creating a link <a href="#">link</a>. However after the export using the XSLT file, the html tags that they placed in the field are exported as actual text as oppossed to html tags as they should be. I looked at the source code of the generated html file and it seems that the "<" is converted to &lt; and ">" is converted to &gt; Is there any ways that the users can place some html tags in the fields yet after the export to html still retain their tags as actual html and not convert the tags to special characte…

Hi everyone, I'm hoping that someone can tell me how to use a line break in xsl. I have tried various code, but it only generates errors. Here is my code... <xsl:stylesheet xmlns:xsl="http://www.w3.org/TR/WD-xsl" xmlns="http://www.w3.org/TR/REC-html40" result-ns=""> <xsl:template match="/"><xsl:apply-templates select="SQL/Result" order-by="@StockNumber"/></xsl:template> <xsl:template match="Result"> <OPTION> <xsl:choose> <xsl:when test=".[TempStockOut='Y']"> <xsl:choose> <xsl:when test=".[stockIDAndDescription='Y']"> <xsl:attribute name="value…

how can where i recive and xml to know that <tag> name? i know how to read it's length xmldoc.childNodes(0).childNodes.length so how do i read it's tag name? thanks in advance Peleg

I am planning on web enabling some databases. I know XML is really the best way to go, but I don't know where to start. Can anyone suggest any good introductory tutorials, books etc. to get me going with basics and beyond. Thanks

The state of Ohio (like almost EVERY state) has their very own "Academic Content Standards" for the different subject areas. For years, I've wrestled with parsing their Word versions into usable FileMaker files. Finally, the state has published them in XML format. It would seem trivial to load the files into FileMaker and have them ready to go. Well...no such luck. There are several files available (depending on the subject) but they all give a variation of the following error: XML parsing error: Unknown element 'indicator_statement' Line Number: 8311 Column Number: 29 I've opened each of these files in XML Spy, snooped around where the error is…