XML/XSL

This is my very first look at XSL files and I need to establish the basics. I have some files that have been exported from Filemaker 8 in the XML version FMPDSORESULT. I want to display them on the web in a very simple fashion and I started this morning trying to use CSS. I have come to realise that XSL is probably the way to go but I'm working (voluntarily) for a group of local historians who have absolutely no money and are using a free website - freeola. Before I spend ages working this out, I need to know the following: do I need just the two files - the FM produced XML and an XSL file to style it? (in the same way you have html and css). And will this work…

After creating a stylesheet that works (with a great help from Fenton) I am now having issues when the xml file to be imported contains (or is supposed to contain) non-English text characters (e.g. umlauts, scandinavian characters, etc). I've attached my stylesheet (that works for English text!) Any suggestions? WebOrdersPlaced.zip

: In one of the web pages that I am posting with XSLT, I have an href which is a Filemaker Pro Field with a "&" in it. It actually contains a URL. In HTML I used Raw in the HTML. When it was translated into XSLT (using the CDML Converter), the Raw disappeared and was not replaced wth anything else. Now, the "&" comes out as "&" followed by "amp;"and the URL fails. I have looked on the web and in this forum, but I haven't found an answer as to what needs to be done to get this to work. The code follows: Please help!! Thanks.

So close... I'm able to create and update google calendar items. I'm now attempting to import calendar events from a date range. I can actually get the data in xml format but I'm now having difficulty with my xsl. Filemaker keeps choking on the google tags with " Error: "Unable to resolve prefix 'gd'. patter = 'gd:comments'(G_Cal_to_FM.xsl, 56,52) Remaining tokens: () xsl=G_Cal_to_FM.xsl <?xml version="1.0" encoding="utf-8" ?> 0 …

I am trying to import this XML file that another program produced from a PDF conversion. I am trying to import all the data and images in the PDF file. So the program converted the PDF into a XML file with images. Now I am trying to import the XML file into FM. I know I need a XSL file to help FM translate the XML file but I know nothing about XML. So could someone help me with a XSL file to import the XML file. I have attached the XML file. Also can FM import images through XML? Thanks example.zip

Hello, Im going to be trialing the xml/xslt site assistant software. Can anyone tell me characters I should not use in the name of my file, that may affect xml/xslt. Many Thanks Jalz

Hi, I need to export an xml file from filemaker which i can connect to dreamweaver cs3. I have been able to export an XML file from filemaker, however this file isn't the correct format for importing into my dreamweaver site. ..... and i have been able to read 'an' XML file from dreamweaver (a downloaded XML example from the internet) which connect using the html/javascript code supplied from the example. However of course this code isn't compatible with the xml file i export from filemaker. I'm pretty sute I have to create a style sheet to be exported with the xml file, which will then be compatible (read) by the dreamweaver code. But i don't know ho…

hi, i am trying to do an export to XML using an XSL style sheet via a HTTP request, and i receive the following error: "XSLT warning: Fatal Error at (file , line 0, column 0): An exception occured! Type:NetAccessorException, Message:Could not connect to the socket for URL '{0}'. Error={1} (, line -1, column -1)" the XSL is accessible from within FM, as I have it displaying in the Web Viewer. if i download the XSL and place it C: and specify it via File (instead of HTTP request) the XML exports correctly. the FM file is open in FileMaker Pro 8.5v2 (hosted on FileMaker Server 8.0v4). i am logging in with the 'god' password to the FM file. …

Hello Guys, Hoping someone can help me or atleast point me in the right direction. We've been using FileMaker Pro as a MIS for quite a while at our school. One of the things teachers do with FM is email out to large portions of parents. Our client email software is MS Outlook with Exchange. Everytime FileMaker tries to send an email out (to outlook in this case using the the SendMail command in scriptmaker), It comes up with a Outlook security dialog in which the user has to click allow or deny to continue. Well to eradicate all of this, I thought why not send out server based emails, after all we use FileMaker Server Advanced 9. So I trawled the net and …

Hi, I'm currently outputting an XML file using an XSLT stylesheet that contains a name and an amount figure. All works fine until the persons name contains an apostrophe. The apostrophe causes the XML to become invalid. I've looked at the translate function and can't figure out how to get it to replace the apostrophe successfully with ' , even though I can get it to do "normal" characters! At the moment I've got the following: Works: Doesn't work: So in a nutshell, what is the best way to deal with the apostrophe problem? Is translate the way to go? TIA, Andy

Hi. I need to create an XSLT stylesheet that will allow import of XML. The XML I'm importing is fairly simple (one specific scientific assay that outputs in a consistent format). I think I 'get' the basics of XML, but have never learned any XSLT. Should I ask my workplace to purchase a book for me, and if so, what do you recommend to get this project going quickly? Or are there online resources that would be sufficient? Time frame for learning & writing the stylesheet is 1-2 weeks.

Hi I am still stuck trying to work out how to create an XSLT from an XML file output via one of our custom systems. XML is: <?xml version="1.0" encoding="utf-8"?> project_key="PR0001" project_title="Brochure" client="A Publisher"> key="000001" name="Project stage of work" start_date="2008-01-08" end_date="2008-01-30" support_person="A Person" resources="{List of people}" project_manager="pm"/> -- end Any help on creating an XSLT would be very much appreciated. Regards C

Gathering book data with an ISBN lookup. Looking for the XSL that works with ISBNDB book lookups. Fenton? TIA!

Can't get my head around this... History My application exports two files in XML format and the files are then posted on a ColdFusion powered website. I wish to import these two files into runtime copies of my application (on a regular basis), but due to the nature of the website where the files are hosted, the URL stays the same, but the files move location as they are updated, so I cannot point to an absolute path. e.g http://www.website.com/media.cfm?mediaid=12510 when opened in a browser resolves to http://www.website.com/media/xmlfiles/p/8/myfile.xml As I said, when the files are updated, the old files remains (for rollback purposes) and …

I have a .xsl sheet that serves as both a data entry and edit form. When this sheet is called using a -new submit (the record must be created first in the FM database so various fields in the .xsl sheet can be automatically populated), a user can enter data into the entry fields, click submit, and the javascript validation works great. When this same .xsl sheet is called using a -find submit (so the previously entered information can be edited), the user can modify the data, but the javascript is never run yet the record in FM is modified according to the edits made. I need to have the javascript run every time. Any ideas on what is going on?

Hello All, Is there any way to restart FileMaker web publishing engine from a remote location? I have FileMaker Pro at my end with admin rights. Please let me know if it is possible. Thanks, Vikas

Is it possible to do HTTPS Request for web service from filemaker?

hi, i am trying to export repating values xml with a stylesheet. i am using fmpdsoresult grammar. I try writing "fmp:FMPDSORESULT/fmp:ROW/fmp:a[repeatition number]" but it does not work. i have searched past topics but cant find a solution. how do i get repeating values from fmpdsoresult grammar?? thanks

I want to use filemaker to generate the xml for an rss feed or podcast. Does anyone have any sample/example dbs

I am using the FM to ical XSLT template by myFMButler.com to subscribe to FileMaker Calendars through iCal. I am using the latest version 1.1 which is supposed to be Leopard Compatible. The issue is that when you make a change to the time / notes of an event and then refresh the calendar in Leopard the changes do not show up. It works perfectly in Tiger - Changes show up fine. If I change the day / delete or add event the changes show up in iCal (Leopard). But if I just change details of the event the changes to do not update. If I just save the xml file that is generated by the xsl sheet I can see the changes there. Any one with any ideas …

This is a small sample file that shows how to read out container fields with XML/XSLT. test_container.zip

I have several scripts that export XML in conjunction with an XSL style sheet to generate HTML. I would like at the top of each HTML file to have something like "(generated from the database on yyyy/mm/dd)" so that a viewer can easily tell how old the HTML data is that they're viewing (these are internal viewers only). The date of export is not in the XML that is exported (a surprise, that - seems quite a basic piece of info); for those of you familiar with XSL it will come as no surprise that XSL provides no built-in way to get current date; I have tried the xml-script element (to run javascript date functions) as well as the EXSLT date extension but apparently FMPro's b…

I'm sorry to be rather noobish at this subject. I need to do a http request with filemaker (8.5) and through this request communicate with xml. How can i do this?

Hi everyone, I have a very short xml file see below - it seems a really good one to start with - I know I have to have an xslt file to work with this to convert it to fmpxmlresult grammar. Are there any guides on how to write the xslt? Many thanks XML example as follows: − −

One of our systems outputs an XML formatted file. I want to import this into FM Pro 9 and process it for my own needs. Because the other system was developed by another party a while ago I don't know the XSLT... so can I do anything with just the XML file or is it possible to reverse engineer the XSLT? Cheers

I have a CWP solution that is using XML. My client has sent me a swf file to display in the web browser on his page. I can't get this file to display in the web browser (it does work using the web viewer in FileMaker, so I know the URL is correct) What is the proper syntax for incorperating a swf file? Thanks Jerry

I have a solution if anyone wants it.

I have developed an Inner Office Memo System with FMP v8 Server Advanced. The solution’s FMP back-end DB is on the server and the front-end GUI is served up by the Custom Web Publisher (CWP) in XML/XSLT technologies. I’m trying to implement a better file attachment functionality to my Custom Web Published front-end. I am currently using an ASP/FTP solution that provides end-users access to file attachments from a particular Memo. I’m not thrilled with using the FTP protocol to access file attachments but, perhaps ASPUPLOAD can give me a better way to deal with attachment handling. Another problem with my file attachment solution is that there’s no way to tell if there is …

I'm trying to import some form information but I can't get the checkboxes info to transfer. I setup a simple test file and have a separate XSLT. All the other fields I got working alright. But if there is more than one box selected none of the choices transfer. I'm sure it's a syntax issue. My code looks like this: <?xml version="1.0" encoding="utf-8"?> White Mark 323-1111 pp100 All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull boy. All work and no play makes Jack a dull …

Hi, I wonder if XSLT based web page can be constructed without Server version. Only XML file (with FMXMLRESULT grammar) can be processed by xsl? Finding, sorting, ... etc? Thanks in advance Osman Cabi

Hi! I have a problem. We are having a simple order/invoice system that we use. And we have an online store hooked up to it. Now that we have alot of buisiness on the web we are geting a problem. When and order is created inhouse and on the web at the same time it happens that the both orders get the same ordernumber. Can you prevent this with some kind of row lock? The highest orderno is stored in a global and internally we acces it by a script and from the web via XML. Best Regards Joakim

How can I validate that all fields in a form are filled in before the form is submitted? I'm using xslt and FM8. I have a vague knowledge of PHP and javascript, but realize that one of those are probably the best way to do this. Thanks in advance for your help.

I am exporting to a Word Doc with XML and an XSL Stylesheet... Things are actually going quite swimmingly. I am in the home stretch for this particular report. My final obstacle is a '|' pipe delimited field that I need to convert to 1 a line per paragraph. This portion of the XSL is below: ... The problem is that it is returning the first line for each IF set you see. (assuming I have 4 IFs) So with a field: "1|2|3|4|" It returns: 1 1 1 1 Instead of: 1 2 3 4 Anyone see what I am doing wrong here?

I have a script currently setup to pull tracking information from FileMaker via ODBC. The SQL is as follows: SELECT Ship_Via, TrackingNumber, InvoiceNumber FROM Tracking WHERE DateShipped = '10/12/2007' AND TrackingNumber IS NOT NULL AND Email_Sent = 'No' AND Ship_Via IS NOT NULL This always worked great right up until we reached 10/10/2007. Then I'm getting an ODBC error that says it can't display what the actual error is...so that's always nice. Any day before that works fine, but any double digit day in October doesn't work. I found another guy on a thread (different site) with the exact same problem, no answer ever came of it. As such, I'm trying to…

I thought I'd start fresh on this part... I am importing data via XML into my database. Here's what I have: 1 record with several items of data importing using my XSL Stylesheet. Repeating data into separate fields... Simplified example of XML data nodes: Data coming into each field: ItemName,DatePurchased, LastSaleDate, Cost, ListPrice, shelf1, 1/1/2007, 2/2/2007 ,$10.00,$20.00 shelf2, 1/1/2007,(Empty so no node present),$10.00,$17.50 shelf3, 1/1/2007, 2/2/2007 ,$10.00,$20.00 But it looks like: Field1 field2 field3 field4 field5 shelf1, 1/1/2007 2/2/2007 $10.00 $20.00 shelf2, 1/1/2007 2/2/2007 $10.00 $17.…

I want to know how to add one record to an existing database using an XML file. I did an experiment where I exported an XML file from the same Filemaker database, deleted all but one record, then edited the remaining record to make it distinct from existing records in the database. Then I tried to import it, using "File"-"Import Records"-"XML data source", specifying that it should "add new records". What happens is that all existing records are deleted and the one record in the XML file is now the only one in the database. I'm supposing I need to make some changes in the syntax of the XML file in order to append it to the existing records, but I don't know how. Than…

I thought maybe I better start fresh but this does relate back to the Post: Importing from Amazon Web service with the ISBN (Topic#185162) I can't thank you guys enough for all the posts I've read on XSL and Amazon and also Calculations. Using this info I've been able to set up my own Listing/Catalog database for inventory (mostly books and some CD's/DVD's which I sell on several sites) using Amazons AWS for product info. I've been able to set up my image download to put a face on a title... so to speak. But I had to use a plugin ($) since I'm Windows XP. I wish I could create my own but maybe in time. My only other desire …

Hi, First of all: Sorry: I'm a french speaker. I try to import data from Amazon into FileMaker but without success I found the example from Jay Welshofer on http://www.filemaker.com/products/technologies/xslt_library.html but it's no more compatible with the actual Amazon Web services. I found posts on these forums with great contributions from Fenton. Though I tried to custom the examples given, i didn't get a result. So, is there anybody with successfull stories in this topic ? Has anyone actual exemples of Amazon import into FileMaker by ISBN ? I use this kind of URL (is it the correct way ?) to get the info: http://web…

Does the "-edit" query command it's job in the xslt document() function. Are there restriction?

This need I have seems so common that I can't believe that a two day combing of the Internet has turned up dry. My need is fairly simple. I'm making a charting application in Flex that is using FMPro as a datasource. I retrieve the data I need via URL. Filemaker is returning results like this: 02/01/2007 02/01/2007 321A {...repeats record tag over and over...} But what I want is this: 02/01/2007 02/01/2007 321A I'm fairly certain this is accomplished with XSL, but I'm no XSL programmer. Does someone h…

Hi, I am just working on saving word document from filemaker with the help of xml export. But I am very poor on xslt. I can repeat records or portal rows perfectly. But it is not enough for me. I want to make sub-summary partition like repeating in my document. How can I revise for-each tag to use like sub-summary? I also want to use number fields to count or sum. Thanks in advance. Regards Osman Cabi

Hi, I've been looking at exporting FM8 data to an XML file using the FMPDSORESULT. The file needs to be in this format, with element tags, to be read by other apps after exporting the data. I've got the export working OK to a point in that any data from the main table is exported fine and has the element tags wrapped around the data but I'm scratching my head as to how to get related data exported too. The database has one student table and related tables are linked by StudentID. The required XML tree is as follows: (one element per pupil record in student table) (unique) (child of pupil, only ever 1 repetition) (child of pu…

Just getting started with XML in combination with FM. I used filemaker site assistant te generated some xsl files (eg. home.xsl). When addressing this file with my browser (eg. http://192.168.123.101/fmi/xsl/my_templates/home.xsl) it generated an errorcode, which refers to "unsupported XML grammar" and outputs following in my IE browser: <?xml version="1.0" encoding="UTF-8" standalone="no" ?> View Source for full doctype...)> - When checking home.xsl with XMLspy, there is following message: "Unable to locate a reference to a supported schema type (DTD, W3C Schema) within this document instance." How do i get…

Does anyone know if it's possible to change an XML-export file name via a script ? preferably using a field or variable ? At the moment I can create one unique name, or could create a series of names and save them to individual scripts, but I can't seem to find a way of just changing the name from a field in one script. Any ideas ? :B

We just updated to 9.0 and have encountered several new issues with custom web publishing when it comes to encoding of XML. We serve via http: XML data which in 8.0 was encoded to ISO-8859-1. Now in 9.0 is defaults to UTF-8 and to change this we have to create a XSLT style sheet with the encoding method specified. We are good on that. But now, the XML being published when validated on our SQL server gives us an interesting new port error. FMP appended a port :0 Has anyone encountered this and how do you change this? Seems very inside and obviously there are not any settings for this. It is coming from the web publishing setting. //FMI//DTD fmresultset//EN…

Greetings all, I was tasked with converting our FM5 server over to 8. The files went fine, but trying to replicate what some older webcompanion files were doing through custom web publishing is giving me some trouble. I see this is a popular question on the web, but I work in a school, and don't subscribe to the pay sites, so hoping you could help. Everything I've done so far is pretty much out of the box. Converted the files to .fm7 ran the files through the Filemaker Site Assistant. Modified the html portions of the xsl files to make them look pretty and whatnot. Everything works as desired to this point with the exception of the editrecord.xsl file when …

I've made a database that contains a portal. I've made a CWP solution for this database and the records of the portal are displayed when you browse the record of the parent database. Now I want to make a link that brings you to a page that displays the related record. Can somebody get me started because I've searched the web, the manual and this forum and I can't seem to find the solution thx

Hi Guys, Kind of weird... I can get this to return what its meant to (so all my xml settings are correct): http://***/fmi/xml/FMPXMLLAYOUT.xml?-db=Basic_Relational_One&-lay=People&-view But this one keeps returning missing parameters (and i'm going off the fm examples) http://***/fmi/xml/fmresultset.xml?–db=Basic_Relational_One&–lay=People&–findall I can also get other basic calls to fmresultset.xml working like -view etc... just not the one directly above which returns a missing parameter error. [color:blue]EDIT[ That was the case for the first few days i tried it, but now its working.. What could have been causing the erro…

I am new to XML/XSL and am trying to get an if statement to work but I can't seem to get the language right. I want to show a link based on the contents of a field in my database. ie: if there is no data in the field I don’t want a link (or image to the link) to be displayed but if there is any data in the field (the data in the field would be a link)I want it to be displayed as a link. Any help would be greatly appreciated. I have found this forum to be very helpful in the past.

I'm doing imports from the Amazon ECS. For the most part all of the parts and peices are easy enough to get at, but there are a couple little details that are evading my grasp. #1 Amazon makes available the item description, such as the text that would be on the back of a DVD cover. However, it puts it in with the editorial reviews, rather than as its own separate node. Like thus: - --Amazon.com --- ----Like a dream, Howl's Moving Castle carries audiences to vistas... --- -- - --Description --- ----In Hayao Miyazaki's latest animated masterpiece... --- -- So basically what I want is just the "Content" portion of the one t…

Every time I want to use an xsl style sheet I have to specify it manually first. I've tried abolute & relative paths under both file & http requests. In all cases it will work if I select or type in a path to the xsl sheet, but stops working if I close and restart the file. When trying to import for the first time without specifying the file location manually the program locks up and I have to restart. Upon restarting the correct path is still stored and written correctly but I have to respecify (the exact same thing that was stored) in order for the import to work. Am I forgetting to do something silly or is this a bug? Thanks in advance for your help!

XSL style sheet. I'm trying to output something like this: I can modify evrything but not sure how to get this. I'm getting... (nothing... here) My xsl: Any help is appreciated. Note: not sure why my xsl here looks different than entered. I'm sure you experts will though.

I am asking if anyone here has had any experience using xml to plot multiple locations on a google map or similar online map. I am trying to do this and I just realized it might be possible with xml. I just don't know how to use it. Thanks

Hi I am trying to use XML in one of my solutions and was wondering what all the different XML queries were. I know of add, delete and edit. Thats it, I am hoping there are more and if so, could someone point me to a white paper or something along those lines where there is a list of all the queries. Thanks Jeff England

I have migrated my filemaker databases and XSLT solution over to a new server. Shortly after using the XSLT solution on the new server, I get the following error... The XML page cannot be displayed …A message about an invalid character in the text content… The file in question…home.xsl And what appears to be the in valid character…MZ This error displays after I click on a link to the FileMaker Site Assistant generated home.xsl file. So, I'm not even connecting to the back-end database yet. The error message seems to be coming from my IE browser. The servers in question are both IIS version 5. The only obvious difference is the OS. One is runnin…

I moved a Filemaker Pro 8 application from my Mac to a Windows 2003 Server, configured the email in the Admin file, but no mail gets sent. Is there any permission/setting that I am missing? I put back in the trace for error messages and it gave me a 10213 error, which I think is an SMTP error message, but the same one works on Mac! I am out of ideas. HELP!!!

G'day all, if anyone has ever been interested in getting data out of the Database Design Report, or wanting a primer on how to use XSLT in FMP, or even just a how-to about XML, I've written a series of articles on my blog that describe the XML formats used by FileMaker, describe how the DDR works and document the XSLT required to get real data out of the DDR. It's in 3 parts Part 1 talks about what XML is and how the DDR uses that to show data about your database. http://www.goya.com.au/node/105 Part 2 describes the import format that FMP requires and details how FileMaker data of records and fields is generated in XML. http://www.goya.com.a…

There is a new example at the XSLT library: XML Cache http://www.filemaker.com/products/technologies/xslt_library.html It shows how to set up an intelligent XML cache for predefined queries that have large result set. It may improve CWP performance considerably.

Hello, I am trying to import the attached XML file into FileMaker. My understanding is that I need a FileMaker compliant xslt file to do that. I am trying to find-out if there is an easy way to produce an xslt from the xml file. I used XMLFox Advance (an xml editor that reads xml files as relational databases) and created the attached xslt for my xml file, however it does not work when I try to open xml file in FileMaker using this xslt. I think it needs some modification to be compatible as a FileMaker accepted xslt. Or maybe it just doesn't work that way and I need to write an xslt form scratch. I would appreciate any help/suggestion I can get. Many than…

Once again, I am converting my systems with email to XSLT. Thanks to Martin Brandie, the problem of the formatting of the multiple recipients in the to portion was resolved. My read of the documentation (what little there is) tells me that I should move the cc addresses up to the to portion. Is this the only way?

I'm trying to develop a document management system. My network scanner completes a batch and generates this xml file. (Because I know nothing about XML...) when importing this file to FMP it generates errors I don't know how to respond to. My need is so simple I'm wondering if there is an equally simple solution to this problem. (I acknowledge I need to learn XML, but I'm trying to keep it off my "drop everything - do this now" list). From the batch folder I need to import the pdf (123.pdf) and place it in a container, store the path to the file, and also the barcode value (ie CCC3334445555) to their respective fields. Anything other data from the xml file is irr…

Hi! We have an SQL database and wants to use XSLT to add data from that database into Filemaker, but it goes deadly slow. Is there anything you should think of using XSLT? Or is there a faster technique to use? // Joakim Sjöberg, Johnér Picture Agency

Hi i trying to include a captcha in a stylesheet, http://www.archreality.com/jcap/#j1, but i cant do it. can anyone help me? tks

Hello, We use filemakers XSLT custom web publishing to create our web sites but we would like to allow clients to login via a normal web form. We have researched a number of ways but cannot figure out how to create a normal web form that will authenticate a user. We cannot use guest accounts, we must have clients login. I have looked at this page http://edoshin.skeletonkey.com/2006/12/how_to_bypass_t.html but I can't seem to get it to work with CWP since it's used for IWP. Any suggestions or ideas would be appreciated. Thank you, Dustin

Hello, Can you put to me on the track to obtain at exit one to file Excel after an interrogation of the FMS by xslt? I try fmxslt:set_header() but ... nothing (translate by goole, sorry) Thanks

I have survey pages created via XSL style sheets that users fill out. I have also created an XSL thank you page that I would like to have load after the user hits "submit" and a new record is successfully created in the database. I cannot figure out how to do this. Right now, I have a javascript running that opens a popup window with the thank you page after the user hits submit. This is confusing for the user, as the page underneath the popup, the one they filled out, reloads itself (and clears out all fields), when they hit "submit." This makes the user wonder whether the submission was successful. Does anyone know how I can tell the XSL page to load a diffe…

Once I returned to my work environment, I was able to get the email to work once again (reference topic of getting email to work in different environment), except for the fact that I am unable to specify more than one email address in the toemail field (i.e., it works with only one recipient). I have tried the following, to no avail: ; blank space paragraph marker Any idea what the magic separator should be???

Stupid question: I am getting the following error when trying to import the XML attached lower in the message. I am real new to this and this is a project I am helping someone else on. I am not using any XSL style sheet on the import. ------------------------------------ XML parsing error: Atribute 'regionalmanagername' is not declared for element 'region' Line Number: 2 Column Number: 130056 ------------------------------------- <?xml version="1.0" encoding="iso-8859-1" ?> - - - - Westboro Motors, Inc.</p><p> - - 271 Turnpike Rd. Rte. 9</p><p> - - www.westboromo…

The Library of Congress has a site that you can retrieve information about books, by inputing isbn, author, title, etc. It outputs the data as XML (MARC record??). I want to be able to retieve this info and have it come into my FMP database. Can anyone show me specifically what I need to do to 1) request the info and 2) find a stylesheet already made to import it into my FMP database. I'm don't know XML, but I do know FMP. Thanks!

I'm just starting out with xslt and I have a problem with the formatting of dates. I have a database where the date is formatted DD/MM/YYYY When I look at the records in the browser, all the dates are formatted MM/DD/YYYY I've tried to get it work with fmxslt:convert datetime... but I'm stuck.....so what I want is to have an input field with the date in the format DD/MM/YYYY as it is in the database Here's the code of my input field Can anyone help me out?

Hi! I heard the new v4 version supports Web-XML-Queries with OR-relation (not only AND) on one field. Is this true and is there documentation available? immwi

I'm working on trying to get a small amount of data out of Filemaker through XML using a web browser. Following the little bit of current information for this, I managed to quickly come up with the following URL for what I needed: http://myserver:80/fmi/xml/fmresultset.xml?-db=sample&-lay=sampledata&ID=142&-find With a [Guest] account enabled in FMP, this works just fine. However, as the databse is also shared on the network, and since this data shouldn't be accessed by everyone, I don't want to leave [Guest] turned on. Therefor, to handle passwords on files, I found a document that told me to structure the URL like this: http://account:p…

Hi, I wonder if anyone can shed some light on something rather worrying... I have some XSL's written so that we can import XML files from a data-supplier they work fine except for a few which came through last week. Please see the attached image for the error, if I re-import previous and some new XMLs they still import fine but there is a batch that don't. I had them resent and tried parsing them through Validator and TestXSLT and they seem to be valid!! I can provide samples if required.

This may be a n00b question posted elsewhere, but I couldn't seem to find the answer here. When I use the 'sum' function in the XSL files produced by the FM Site Assistant, there is some code that checks if any of the fields is not a number. If so, it reports "N/A". Here's the code: Here's the problem: If a record has no data in the field that is being summed, or if there is non-numerical data, such as some dashes, the sum function returns "N/A". I've tried substituting the following for records that don't have numerical data in that field: but that only affects the output, which the sum function doesn't care …

In December, 2006, I got dynamic email to work in XLST, thanks to Martin Brandie and Mikhail Edoshin. Now I am at home recovering from knee surgery and the same setup gives me either a 10200 or a 10203 error. I changed the SMTP server so that I am using the one that I use for my home email. Here is the send email that fails at home: select="fmxslt:send_email('[email protected][email protected]&subject=test','test')"/> Please help!!! Shirley

I need to be able to find based on multiple criteria in a form and I'm running into a problem. The user should not be able to proceed if they don't fill in both fields, but the form is going to the action page instead of the error page if they leave either or both fields blank. I've tried adding the -lop "and" and also the fieldname.op "eq" to no avail. I don't have this problem in my inline statements, just the form. Any ideas what's wrong? hitlist.xsl Please enter your Make and Model. Make Model …

Hi, I'm fairly experienced with Filemaker, but I'm new to XLM/XSLT. I'm trying to convert some CDML pages, and I'm stuck. The purpose is a database of software users. A user adds a record with name, phone, etc. and choses software from a (value) list. On submitting, he's taken to a reply page which should look up the software in a related table and return the URL link to the software. The records add correctly, and the software name is passed to the new page, but the link doesn't get appended. The code, as converted from CDML by the CDML converter looks like: http://glenmount.bc.edu/SWFiles/ select="$default-record/fmrs:field[@name = 'name']/f…

I am working on a solution that records employee overtime data. Periodically I will export records to our payroll system. The payroll system is very specific as to how imported data must be formatted. Someone suggested in this forum to export using xml and transform it using an xsl style sheet. This sounds like the best answer to this requirement. Problem is I have no experience writing style sheets and do not have any xsl editor. Can anyone recommend an inexpensive (preforably free) xsl editor (windows xp) and where I might get a crash course in style sheet writing. Also, which FM xml grammar is better suited to a task like this, fmpxmlresult or fmpdsoresult…

Hi guys... I need to convert unformatted number like this...345677.5 in this presentation.... $ 345,677.50 I been used decimal-format and format-number in xslt but I don`t receive my expecting result.. Please help me...Thks... Ale B.

I need to reverse the order of a results page and am not sure if it is done in the xsl or server side. Also if you need additional info let me know. Thanks, Larry

Is in FMSA8 Custom Web Publishing something like was in Filemaker Server 5 - databases with users and passwords who can log in to database? I would like to make a database with usernames and passwords for website users who can login to their accounts. Something like online shop with basket. Is it possible to log in to shop database with username stored in another (users) database?

I've built a XSLT stylesheet (GMintoFMP.xlst.txt, FileMaker.xlst.txt) that works fine when using an java XML processor. The resultant XML file (GMintoFMP.xml.txt) can be imported into FMP via the IMPORT script. But, the same stylesheets don't work within FMP. Instead, I get a dialog box that says: Empty expression! Remaining tokens: () I can get the same message just when clicking on the "Specify import order" button on the Import Records script step. Any ideas on what is triggering this? How to debug this? Thanks for your interest and help. C GMintoFMP.xslt.txt FileMaker.xslt.txt

I have been working mainly with PHP lately and am wondering if any of you XML wizards know this - I'm trying to query the URL used to access a XSL file hosted under FMSA 8v4. I want to look at the current URL and if the 'www' is specified, then do something. The same xsl page accessed without the 'www' prefix will do something slightly different... I tried some variances of this ... but this is not working. Perhaps it is not possible to use a javascript constant (window.location...) inside xslt!? Thanks for any help!! In Kindness Stephen Knight

My clients are consistently receiving an Error 102 on a XML-Xslt web site "find" page created with Site Assistant. I (interestingly enough) can not make the error work and the page works flawlessly from my PC. Since this is a "field missing" error I have checked for all possibilities on all related pages. This includes spelling errors, field name errors and so forth. I have researched this error enough to wonder if the error is really some other problem that resolves to 102. I wonder about this because I have read some threads that indicate 102 is displayed when there are server issues. I have also checked the FMI documentation and discussed this briefly …

Hello, I'me trying to import an xml file to FileMaker using an xsl style sheet in order to match the fmpxmlresult grammar. The data I want to import is a book made out of 6 chapters, structure looks like: There are 6 fields in the fm database which are supposed to take the corresponding elements. This content is exported as XML from QuarkXpress. In the xsl file if I use the element everything works perfect. However I have some nested tags in each node; those might be and for example. Using the element erases all the nested tags which is not what I want. In order to prevent this, I replaced this command by which produces alm…

Sorry to bother you again, but I have one last snag to unravel to finish my website. I need to edit the first (and only) record in a portal. First, I create a new parent record and records in two portals simultaneously: wsflibrary cart.xsl?-db=LJMorders&-lay=orders&-token.1=&-token.2=&-token.3=&-token.4=&-token.5=&status=open &orderdetails::resourceID.0=&contacts::more_info.0=yes&-new This was working. Then, in an effort to get part 2 below working, I switched the lower and upper portals in the database and now, I'm getting an error=101 for part 1. Now for part 2: The results page for the above edits one of the n…

Hi I'm developing an XSLT custom webpublishing solution that needs to use a single sign on product called Ubilogin. I have successfully added ubilogin to the tomcat server, but I need to get hold of the login name that can be retrieved from the HttpServletRequest, that is used/stored by the tomcat server, using the method getRemoteUser(). I have looked how one can add java code to an XSLT document using xalan-j, but I have yet to figure out how everything fits together in this complex puzzle. Has anyone added some java code to the tomcat server in order to be called from xalan-j in an XSLT document?

Good Day! I have hit a barrier here; what I am attempting to have FileMaker calculate the "as the crow flies" distance from a base point to ANY/ALL of the other locations I have in FileMaker. (i.e. Base1 -> Loc1 Base1 -> Loc2 Base1 -> Loc3 ... ) I can do this because I have imported all of the Lat/Long coordinates for these address in the database, but what I also ned to do is export these locations to a map service as simple map-marker with additional informations (i.e. Location Description, Photos, etc.). + Google Earth -- I have done this, and it works! + Yahoo! Maps -- I was able to, BUT I have over 50,000 locations and e…

Hi All, I am doing an export of invoices with invoice lines. 1 to many off course. However, the format that is required calls from data of the parent record to return in the child records. How do I do this ? I can't figure out how to addrress the coloms in the parent. Or maybe there is a better way ? TIA

Hi all, I am exporting FMI data in xml-result format, but I run into this snag. The result format is xml as well I have for instance the colom "debtornr" (containing DEB1" which I have to transform in xml to I have been trying something like <Account code="" status="A" type="C"> This gets accepted but results in the escaping code of <(the 'lt' thing) something I don't want. or trying to escape with : < which gets rejected. Any ideas or better ways of doing this ?

Hello, I have been trying to get this XML data: http://www.ecb.int/stats/eurofxref/eurofxref-sdmx.xml into a table called "Exchange_Rate" with the fields: 1. Currency_ISO_Alpha_3 (eg: GBP,EUR,USD) 2. Value (eg: 1.4647858) 3. Date_as_Text (eg: 17-01-2007) (one exchange rate per record) I just can't get my head around the xsl needed to achieve this. I would ideally like to be able to query the data for specific date ranges. I would really appreciate any help with this and would love a an understanding of the components of the xsl sheet that is required in order to attempt this myself in future. best Stuart

Can someone help me figure out what the parsing error of: ****************************** XML parsing error: Attribute 'regionalmanagername' is not declared for element 'regon' Line Number 2 Column Number 6620897 ******************************* referrers to? Do I need a .XSLT file to convert this? Here is the code i receive from the website in the request. - - dealer name street address website address osas code - program contact 1 name program contact 2 name program email 1 program email 2 - - I am very new to doing this…

I've been working on some xsl files and they are doing what I want. I had planned on securing the files with a processing instruction but I just read on this forum that I cannot do what I had planned --- using the client user name in the static query. So I have found that my pages are easily spoofed by cutting out part of the query in the URL. Is there a way to make certain fields required in an xsl file? In other words, if my query contained &client_id=7012..., is there a way to stipulate in my xsl file that the client_id field HAS to be queried and answered? If not, can someone point me in the correct direction? I am new to XML and do not understan…

I am putting up a lot of auctions on a swedish auction site, and the program to put it up uses xml files. well, they are named pxml, but it's basically a xml. I have discovered that I can automate a lot of the steps and fill in the information I use every time automatically very fast with filemaker, but I have yet not been able to export properly to xml. I have a rather large filemaker experience, but zero xml and xsl-experience. So this far, all my tries have gotten nowhere fast. Can anyone help me on just the basics on how to output my filemaker database to the following: 420970309 The title here my reference 161701 7 0 …

Sorry to bother you again so soon, but I have one last snag to unravel to finish this website. I need to edit the first (and only) record in a portal. First, I create a new parent record and records in two portals simultaneously: wsflibrarycart.xsl?-db=LJMorders&-lay=orders&-token.1=&-token.2=&-token.3=&-token.4=&-token.5=&status=open&orderdetails::resourceID.0=&contacts::more_info.0=yes&-new This was working. Then, in an effort to get part 2 below working, I switched the lower and upper portals in the database and now, I'm getting an error=101 for part 1. Now for part 2: The results page for the above edits…

I know this topic has been covered numerous times in this forum (I've read them all and tried to implement the suggestions), and I know it's covered in the CWP Guide, but I have tried everything I can think of and find and nothing seems to solve the problem. I have a page that is supposed to create new records via a form. Upon submission, it goes to the results page with no errors, but no new record is created. There are two privileges sets defined, one with full access and the Guest with Data Entry Only. Both have FMXSLT extended privileges. I have set the owner to fmweb and the group to fmsadmin, both with rw permissions (I have no way of knowing if this informatio…

Is it possible to make a XML-query where I find numbers greater than or less than a number or date? http://server/fmi/xml/fmresultset.xml?-db=database&-lay=layout&ID>132&-find

Hi, I need to import an xml-file from the web. The problem is that the dir is locked by an htaccess file. I have the username and password but the syntax http://username:[email protected] does not work. Any idea? Thanks in advance Christian

I limited the 'maximum number of characters' in a field to 100 and I do not 'Allow the user to override during data entry'. Despite this, when the user enters more than 100 characters in that field, Filemaker displays a message to that effect. How do I limit the number of characters entered to 100 and not have any message appear from Filemaker display its message? Thank you for your help.

Hello, When I tried importing an XML file into Fm I got an "XML parsing error" stating that the element 'unit' is unknown. At line 631 and Column 10. This is my first attempt at handling data supplied as XML. I have just enough knowledge to realise that I may need an XSLT file to 'prep' this source's data to be ready for importing into FM. An example of the XML data that gets returned from a HTTP GET is shown below: <?xml version="1.0" encoding="utf-8"?> 2007.01.08 AED 10 7.1756 per 10 currency units 2007.01.08 ZAR 10 3.6930 per 10 currency units This data…