XML/XSL

I could really use some help with testing the website that I've just upgraded from FMv6/CDML to FMv8/XSL. Now that I've eliminated all of the Web Publishing Engine generated errors, I'm running into other problems for which I can't find sufficient documentation. 1) The CDML Converter created a template to replace the FMP-LinkRecID command that is not passing tokens. The CDML command automatically passed the tokens. I'm not sure how to add token passing to either the following template or the call-template command: …

Greetings, I am trying to work out how to combine a -find with an -edit to avoid a two-step process (a -find followed by an -edit on the recid returned by the find). Basically, I want to edit a record where fieldX=value and pass the new field values (fieldY, fieldZ...) in the same query. The aim is to integrate two systems, so that one can push record edits to a FileMaker database via CWP. I want to avoid the situation where the other system effectively has to find the recid and then issue an -edit command with that recid. Could this be done using an include to do some pre-processing on a token passed in the URL? Has anyone implemented something like this? I'd r…

FileMaker is complaining "XML parsing error: Attribute 'xmlns:cm' is not declared for element "FMPXMLRESULT". But it is declared. I begin my XSLT sheet with xmlns:cm="urn:schemas-Professional-Plug-in:P2:ClipMetadata:v3.0"> Still, when I prefix any node reference with "cm:" For example, FMP 8 complains the prefix has not been declared. The XSLT does work in every parser I've tested, including Test=XSLT. It is only FMP that complains. I've even tried a second declaration here: 0 But FMP refuses to inherit that xmlns:cm declaration, calling it an undeclared attribute. Any ideas?

Hi, I am trying to import a file using an xslt, however I can't quite figure out how to reach a certain node. Can someone just nudge me in the right direction ? I am trying to learn so don't spoil me too much. Thnx. --- What I've got A FM8-file with 3 fields : invoicenr, debtornr, amount What I want to get from the xml file is the values between the values-tags. I do get them now, but only form the first tag . How do I reach the others ? I got this xml-file : <?xml version="1.0" encoding="Windows-1252" standalone="yes" ?> 2006-06-20T12:33:13 ACCOUNTVIEW 0700A 25RA …

I am using XML Version 1.0. I use a field which is global in a test to determine the current Mission (as in spacecraft) and what part of the form to present to the user, but I am unable to get the following format to work: I have sessions enabled and have tried modifying gDefaultMission with .global, but it still doesn't work. It does understand what gDefaultMission is when it is used in a gif definition, as in the definition below: ../images/-logo.gif I need to resolve this issue to translate three websites to XSLT, but I am at a loss as how to proceed. Please help!! : : : :(

specific content for this page

I have been using a Version 6 Filemaker Pro solution which I developed with an external developer in 2003. The solution is very complex, requiring the file limit of 50 files and hundreds of scripts. We developed the solution on a Mac platform, and subsequently operated it successfully on a mixed platform (Mac Server, PC & Mac clients). I am now commercialising the product, which required me to upgrade to Filemaker 8. I have also switched to PC (XP Pro) and operate a small mixed network of PC's and Macs. All of the conversion work from V6 to V8 has been done on the PC, where after around 100 hours of debugging, it now works perfectly on the PC. I h…

Hi there, I want to export values in portal as xml using a style sheet. But i can not know how to use portal via xsl. I searched previous posts but i can not solve my problem. i try the code below but it is not worked. Please help

I am new to xml importing but have a series of songs in xml that I want to import into filemaker. Format looks like this: <?xml version="1.0" encoding="UTF-8"?> Amazing Grace John Newton 1982 Jubilate Hymns Limited Amazing grace how sweet the sound that saved a wretch like me; And I was able to get a sample xsl template from the filemaker extras that sort of works. I have the fields matching but it imports no data. Here is the xsl: <?xml version="1.0" encoding="UTF-8"?> 0 YES 1 TEXT 0 0 …

Is there any reason this xml url sorts just fine when hitting Server 7, but returns only the found set without a sort from Server 8? http://myserver.com/fmi/xml/fmresultset.xml?-db=myDB&-lay=myLayout&district=1234&-sortfield.1=district&-find I've checked the custom web guides and don't see any mention of syntax being changed between versions of Server. Thanks in advance!

I am using CWP to create a form that has an inline frame. The main page has the details of a move request, the inline frame has the people moving. The related fields of the two databases are the recid. Somehow, i need to pass the recid to the inline frame so that when users are added in that frame, they are added with the correct related recid. Unfortunately, when xsl renders the page, the recid is not there until after submit. So, I either need a new way of linking the tables, or a clever way to do it. Let me know what you think. Thanks! -- Chevell

Hi Everyone, Where to start... Ok so I am starting to get a regular updated external data source supplied to me in the form of an XML file, after hours of head hurting it seems I need an XSLT in order for Filemaker Pro to import/recognise the data. This is where the plane flies over my head and I'm lost on a lonely deserted island. Does anyone have XML knowledge that they could lend and hand with? I have a demo XML file if it helps?

On my xsl web page I have a portal with a time field, but the time is formatted in 24 hour format. How do I get it to display in 12 hour format? I know there are time formatting functions, but it's not clear how to apply them (this XML/XSL stuff is new to me.) This is the code: [b][/b] The 'eventdates::Time_Start' field is the one that needs formatting.

I have an XSL document that transforms my XML document just fine -- except in FileMaker 8. The whole process works fine in TestXSLT, but... FM accepts both documents, offers to map the Results to the proper Field that exists in the database, returns no errors, reports that it has added one Record, etc. But after all is said and done, the new Record has no data in the Field. There is a whole lot of nesting in the XML, so I declare exactly the element I need by using the //ElementName XPath function. Here is a snippet. 0 0 The field DataSource should contain the attribute of the node DataSo…

I recently had to publish a filemaker database to tiered list menus on web. One menu changes options on another menu, for example you choose "United States" on one menu and then another menu is populated with all the states in the US. Maybe a better name would be cascading list menus. I don't know. Anyway, it took me a while to put it all together, so I wrote an article about it and posted it on my website. I hope this will help somebody save some time: http://www.flamingvan.com/community/filemaker/menus

I have a form that I created with Adobe Designer. It says that I am able to populate it with xml. I exported my data from FMP and tried to import it to the pdf form, but it didn't work. Anyone know how to do this? Thanks.

I've got a few value lists attatched to a field with radio and check boxes both. i'd like to find a way to display them without them just running one after another. I tried adding a tab after each entry in the list itself, or return characters, etc. None of them worked. Any ideas? Thanks!

Apple's Final Cut Pro is able to save its data as an xml document. Filemaker Pro can import xml, but I have yet to be successful. Any suggestions and/or people who have tried this successfully? Tangier

Previous I asked if anyone had any examples on how to e-mail with XSLT. Martin sent me the test_email example and I can make it work but I have problem. I want user to enter information in the a form. This form adds and new record. One of the fields that is added is the customers e-mail address. I want to take that e-mail address from the form and send the person an e-mail. All the code I see hear lets you dynamically change the subject and the body but none let the sender name be added dynamic. This is a huge problem for everyone of my applications. I will not know who the e-mail needs to go to until the user fills in the form. Does anybody have an example of th…

Hi, i have a problem. I've just started using the XSLT availablity from filemaker and now i would like to use some javascript inside my xslt. As filemaker, xml, xslt is not my background this is causing me some frusticleastion. Problem is, it don't work for toffee. I've tried some of the online exmaples etc. But have had no luck. I can get it to work if i use ONE javascript function. But when i need to pass one value into another function nothing happens. I have >< symbols in it also and can not get nothing to work. I am now fed-up. Can anyone provide a short or long example of what is the best approach to using javascript inside my XSLT that uses more than one func…

Hi there I used to use this js to provid a close window button inmmy HTML / CDML pages It doesn't work in my XSLT pages. Does anyone know why that would be and how I should go about fixing it? Thanks heaps!!

Recently I have read an article regarding the usage of filemaker in vfx house. Link I wonder how it would be possible to send a http POST request to the server and get xml back fitting into apropiate field in FMP.

i have a db that i'd like to search by date but i dont want an edit box in which the user freely enters a date. i want the date seach field to be 3 radio buttons. the values would be a)search the last month b)search the last 2 months and 3)search the last year i'm using fmxslt:get_date() and trying to manipulate the date so it reflects the 3 choices. is there a way i can manipulate the date i get with fmxslt:get_date() to do what i want? does anybody have any other ideas on how i can do this? thanks

Hello all, For my customer, I need to import exchange rates into filemaker pro. So I found the website of the European Central Bank to be quite handy for this. They deliver the currency enchange rates in a XML file which you can access by simply entering the URL. Main problem is that filemaker doesn't seem to import the file since it probably needs a XSL file in order to know which data should be imported in which field. I am quite advanced when it comes to exporting data out of filemaker pro trough an XSL file in order to create XML files. But getting data in is really new for me. Maybe anyone has some tips for me? The URL for the XML file is: http://…

Is there anyway to specify the proxy server in filemaker 8 advanced? In most Asian & Middle East countries you have to go through a proxy to conect to the internet.Therefore it is impossible??? to send an http request to access xml data from Filemaker.Or am I wrong? Thanks for your answer in advance

I am just at the beginnings of trying to figure out how to use Filemaker to manage all of our (small office) audio as well as play it. Can FM 8 access the itunes xml file and parse it? I would like to get the iTunes data into Filemaker, but also play from FM. We can view and play music on our LAN using iTunes, but can't copy it to another machine

I am trying to create via export an xml document (my first try at xml anything) to a developer using flash from FMP7. I can export data OK in text and text exports. I export in grammar and it works. When I do the export as XML (and it lets me go all the way through), all I get is my stylesheet with no data. (Style Sheet attached) Obviously I am missing something. Any clues? XMLExport.txt

We are small k-8 school needing some help in a student information system. There are several current solutions running, of course in different databases, visual fox pro, mysql 5, and Filemaker server advanced 8. Using the below product we would like to map the data between the systems using xml and xslt. Altova MapForce uses web services WSDL and SOAP to do this. Does anyone know if Filemaker 8 adv. server would allow us to accomplish this or has done anything similar ? Filemaker pro tech help has lead me to believe 8 adv. server is not SOAP compliant. Altova MapForce http://www.altova.com/products_mapforce.html

Is there a way to convert XML to URL in a FM database? We generate an XML from a custom XSL in FM and then we want to convert that XML into URL. Is that possible? Is there a way to convert directly to URL without going through the XML steps? I'm new to this so any help would be great, thanks.

I am using Martin’s example that shows how XSLT can retrieve data from a password protected Filemaker database. It works great and returns the XML data into a variable called xmltree. My question is – how the heck can I transform this information into something that is formatted for display? I have tried using the xsl:value-of select="fmrs:field[@name...", etc. But, the HTML returned contains no field data (though I can see it unstructured if I use “copy-of select=$xmltree”) Even after many hours, I am still not able to crack this. Can anyone help? Thanks, George

Once upon a time (FMP 5.5 and CDML) I could submit multiple records using a simple javascript function and inline frames. Now I'm using FMP Server 8 Advanced and CWP Has anyone figured out how to develop a xsl style sheet where the user can modify multiple records i.e., submit multiple forms on a single page? Or maybe there's a way to do this inside FMP

Hi, i have to import this xml file, i can import all the data from pict node, but i don't find the way to import the image node, can someone help me? thank so much i attach my xml and xls file mosaic.zip

Image Upload Client Key Item ID Image

Hi Is there an easy way to use a url to add a record to a fmp database. We have an update script on our mac clients that currently runs this to log an update occurence in a mysql database, passing it the date and asset no(host name) of mac. I would like to get this to log innto an fmp table.

I have a XSL website up a running. It is hosted on our server and clients are able to log in and use with no issues over the internet. It is a simple database that is used for inventory and shipment tracking. I am at a complete loss for how to offer clients a dashboard widget for them to look up this info. I have looked at the filemaker widget but I might as well be looking at san script. Any thoughts, help, direction would be much appreciated. Thanks in advance. Brad

Maybe this is a stupid question.But somehow I cannot figure this out.I have a xml file exported from filemaker 8 having just 2 fields ,Model code & qty.I need to import this in to filemaker database from the web.The idea is that our clients in other countries using Filemaker allways have the latest data.Or is there a easier way to do this? Help appreciated. Thanks a million in advance.

I have created pages using the site assistant. I need to change a field to be multi line, this is a comments section and look wise it will be better if it only goes for about 50 characters and then goes to the next line. When I change this is dreamweaver it gives me the error [color:red]The element type "xsl:for-each" must be terminated by the matching end-tag "". (XML-0030) File: addrecord.xsl Line: 217 Column: 16 What am I doing wrong?

I understand how to add a record to a FM7 database using a URL and XML and have successfully done so. What I want to be able to do is create a record in a FM7 database without specifying a response page (sort of a "silent post"), but I cannot figure out how to construct such a URL. Is it possible to do this and, if so, what would such a URL look like? Thanks in advance for any help. William

I am working through importing 1000+ XML files exported from FirstClass. I have a working XSLT doc, that works with FMP8 when I use the Open-XMLSource menu. I now have these questions: 1-Is there a way to automate importing from a folder of 1,000+ xml files? I know I can script the import in FMP, but I don’t know how to loop through a folder – is that possible? 2-I was able to import all the fields from the XML FC file, but they have some info that is stored in the of the record, and has no field ID. Is there anyway to import that info? A way to call it in the stylesheet? 3-Is it possible to retain formatting when exporting to XML and back into FMP (bold, …

Please bare with me, I am new to XML and have a basic question. I've got a networked solution where we export to XML using an XSL stylesheet that is located in a specific folder (inside the FMP Application folder) on each person's computer. How do I name the path to the stylesheet, so if we add a new computer it can have any name or someone changes the name of their computer and still find the stylesheet? Thanks for your assistance

As most api's are switched off in a runtime is it possible to publish to web via xml in a runtime app? Have an app that is low cost on a high userbase (1/2 users in each company x 400 companies), they want the facility to view data on the web when they are out of the office.

How can I enter a set of break delimited values into a field by using a query? For example, I have the following: areas_of_education=GED/High School?2 year College degree (Associates)?4 year college degree (Bachelors) I want the '?' in the above string to equal breaks so that the values show up as checks in checkboxes. Thanks, Moses

No matter how much I modify and try, I still can't add a new record to my db using xml url syntax. I can find anything and everything, but every attempt to add a new record returns an error code "6" (File is read only). This happens even when I set up a full access account, with full privileges, and xml as an extended privilege. This url works perfectly: http://localhost/fmi/xml/fmresultset.xml?-db=register&-lay=register&-findall This generates an error: http://localhost/fmi/xml/fmresultset.xml?-db=register&-lay=register&-new Any ideas as to some accounts, privileges, or privilege sets bugs that won't allow new records? Thanks in advance!

Question, is there a program that is better for editing XML then Dreamweaver? I've had a few issues using this and was wondering of there is anything better.

hi is possible to obtain the server ip with a xsl file?

Hey I have a system that is exporting data to be used by another system. We have decided to use XML. Some of the fields that are exported contain illegal characters (from user input). Specifically control k, control t and control y. These key combinations are illegal and the resulting XML can't be imported into FMP (or other systems). Really, try it. So I added script steps on the fields that my users can free text so that these characters will be substituted with blanks. Now my question, after I did all this painfull scripting, I realized I might be able to do the same thing by exporting with a style sheet. Any of you guru's out there …

How would I get a value list to appear on some fields. This will work rational to the login used. Also, Will this slow the database down? We have a database in version 6 and find that is it very slow loading the search page because of this.

I have an FM database with two tables and a relationship based on the OrderId field of both tables. Some OrderId's have mulitple pieces in their shipments, each with a tracking number from FedEx. When generating a default FMPXMLRESULT, the XML created lists the multiple shipments for each order. When trying to create an XSL to do the same and to match the customer's XML format, it only lists the first piece's tracking number and not the others. Is there something additional I need to add to the XSL in order for it to recognize the relationship? Attached are the FMPXMLRESULT and the customer's formatted XML. Any help would be greatly appreciated. customer.txt FMPXM…

Anyone know how to check that fields are not empty when submitting a form. When searching via a form and not entering a value, you will find all records. I want people to search for two different values where both has to be correct to find their record. So far everything ok exept for when they leave one of the fields empty, then they will find it anyway.

Having problems getting sessions to work. I have created the session and have set_session_object but am not able to retrieve anything from the session on the next page. Do I need to carry something over to the next page? Does the session need to be carried from page to page?

I am trying to access secure environmental variables on a remote server by using the document() function. Does that make sense? I am working with 2 servers. One of the servers authenticates users by certificate. If a user has a certificate and they access a page on the server with https, then a script can access certain variables for that user. I have a perl script that can create some xml for a user. The other server holds the filemaker documents. I want to put a XSL document on this server that has the following code: For some reason this won't work, even though it says it will in the CWP guide. I get the following error: [color:green]The…

I have attached a few files that have been generated with SiteAssistant. editrecord.xsl recordlist.xsl utilities.xsl I would like to have the edit page return to the orriginal found set after an edit is saved. Currently it list only the edited record. Archive.zip

I want to be able to export the found sent in a returned search on my site. After a search the site goes to a list of the records, this is the found set I want to export. Is there a way to do this? I've have a look at other threads that make out that it can be done but aren't specific. I created the site using the Site Assistant so it is not very complex.

I've created a site using the Site Assistant. This database is managing more then 500000 records and I want to stop people doing a search when the search fields are blank. When this happens it takes loads of time to return a result because it is finding all records. Is there a way to stop this. Or This database has many differnt access names (one for each client), is there a way to tell it to only find the records applicable to the person who's logged in? I think my 2nd request would be better so that the find can be a kind of "find all" option. But what ever is easier. Any help!

I have a database with one photo per record. The photos are kept on a remote server. I use a Filemaker field to record the URL to the remote jpeg file. This worked great with CDML: I created an IMG tag, and as the SRC just referenced the appropriate Filemaker field. However, I can't figure out how to do this in XSLT. I tried the code generated by CDML Converter, but it didn't work. Any ideas?

Martin and board, one slight problem w/ the emailing thing using IWP and xslt. The problem is that if user has pop-up blockers there is no way to dynamically determine if the email was sent? In other words, even though FMSA now gives a notice that "the script attempted to open a url...", the user doesn't get any further indication that the email was not sent. Stephen from FMWebschool posted a php example that used php (http://fmforums.com/forum/showpost.php?post/194290/). IWP called a php page that sent the email. If the email was actually sent, it retuned a successphp page, if not an error php page. The benefit of this is that since php controlled the actual email, succe…

(From Topic #173828) Thank you for your response, what follows is a copy of my FMXMLRESULT along with the customer's requested XML format. You'll notice that they are not complicated and I'm somewhat embarassed that I couldn't figure it out on my own. I'm new to both FileMaker and XML. FMXMLRESULT.txt customer.txt

I'm had two ego blows in one day. I've used XML for a few years and planned to do a demostration of importing XML into FM8.2. Instead, FM8 refused to import the XML, reporting an error on the 3rd to the last line of the file. I've stripped the file down to perhaps 10 or 12 lines (from 600+) and FM8 continues to report an error on the 3rd to last line. I just don't see it. The XML example seems well-formed, appears to match the DTD, has closing tags throughout, but FM8 rejects it without giving a specific reason. Has anyone experienced this? Any ideas? Thanks.

I have a client who is attempting to send a DataFeed formated XML to another vendor(via FTP). It has various products. The vendor needs the XML formatted as shown. Why is this so hard? (in FM7) All it is is an export of my fields over an over (a flat file). I guess I need some sort of XSL but I have no idea how to create it. I just don't know where to start. Any thoughts? Thanks in advance <?xml version="1.0" encoding="UTF-8" ?> - - Adidas FootballcJersey This is a skill cut, game worn, 2002 Notre Dame jersey N 399.00 1 217 Blue #s 76-99 Blue Jerseys http://www.vendor.com/images/ UN…

The XSL stylesheet I'm trying to create is pulling in extra data because I don't know how to point it to the specific node I need to process. Here is the stylesheet text: <?xml version="1.0" encoding="UTF-8" ?> 0 …

Has anyone developed a way for filemaker to get real time USPS ship rates from the web?

My bank is changing the file format of downloaded Quicken transactions from QIF into the newer QFX, which appears to be XML. Does anyone have an XSLT already written to do the transformation for importing into FM? Here is the basic data structure of the transaction list in the QFX file: 20021010000000.000[-6:CST] 20060219000000.000[-6:CST] CHECK 20030821000000.000[-6:CST] -161.00 082902757020000000003122050200323300001 1461 CHECK CHECK 20030821000000.000[-6:CST] -10.50 082902757020000000003122050200323300002 1466 CHECK …

Hi! I need help in xslt sessions. I need to set two diferents global fields in my DB. I think that when you do this you open a xslt session and it's not necessary use the command create_session("session name"), but i'm not sure. if i create new record setting the global fields, i open a session?? How i can know if the session is open?? Apear in the FM Server Admin??? In the next request the relations with the two global fields will be ok?? Anyone have documentation (good) about xslt sessions?? I activate the XSLT sessions in FMS8A and in the Publishing Engine. Sorry for my english i'm spanish and it's my first post and i'm a bit ne…

I'm trying to create a xsl form with a radio button in it, as well as a text area instead of a text box. I need to buy a book on this language or something! CDML was so much easier. Anyhow, does anyone have a quick and dirty way of doing this so that I can get these forms finished and then worry about making them pretty after the fact with a class or a book or something? Thanks in advance!

Hi all, i import an xml file used for a flash website, i have no problem with the importing process but with exporting. I have to export the SAME file i've imported, or flash will doesn't understand it. It is possible? if yes, how? Thank for you help, and forgive my bad english ps: i attach my xml amd xls file mosaic.zip

Im looking to create a widget that works with dashboard or konfabulator. I have downloaded the kit to help make widgets but my little knowledge of java seems to be an issue. I am working with Filemaker server 7 running under OSX 10.3.9. The server and all the XML code work wonderfully. The database is searched over the internet via Web Publishing. I am looking to have the widget look to the "inventory" information so clients can get that info from there desktop rather than a web browser. Has anyone ever contimplated this topic? Any help would greatly be appreciated. Thanks in advance. Brad Music Connection musicconnection.net

Thanks to Martin Brandle for creating all the files necessary and your extensive support and hand-holding throughout! Thanks also to John May from Point in Space for the final tweaking to get it working! OVERVIEW: A good way to get emails generated from IWP via a click of an IWP button, w/o triggering the user's email application, w/o php/ lasso, etc., and w/o a plug-in. The only immediate downside that I can see is that due to the fact the openurl script step requires a new browser window to open, pop-up blockers have to be turned off. I noticed that with FMSA 7, there is no notification that the email was NOT sent if pop up blockers were enabled. That's a MAJOR pro…

can you generate emails with xml/xslt and FMSA or do you need middleware such as php to do so?

Does .net work with FMP? FMP is XML, and so is .net, so why can't I find anything on the internet about this?

I'm researching XML importing using XSL from file and FM bring to me message: XML parsing error: Element 'xsl:for-each' is not valid for content model:'(ROW)*' What should I do? XSL looks: <?xml version="1.0" encoding="UTF-8"?> 0 …

Hello all! My question is: is it possible with just 1 query update a recordset of n records? I explain better: I have an e-commerce application, I would like to turn a flag from no to yes when the order is confirmed. If i have a recordset of 10 records it is not simple to change my flag 10 times with an external http call (calling an xml document in a variable for example). Something like an UPDATE SQL statement.. I hope my question is clear.. and I hope there will be an answer too (please.. don't tell me it is possible only via script!). Thank you!

Can someone help, I need to know how to display a token value

I am familiar with css, and how I can global format the html tags. But how do I do it will xsl. The examples that I have seen don't deal with Font-Family, size etc. do I create a separate style file (like css) and link it to all the pages. Any help would be appreciated.

I am trying to create a link to files stored in container fields. What I want is for the customer to see the record on the web and be able to click on the "link" to the stored file and have that start downloading. I have worked out what the link is, if I put it in the browser it downloads everytime. I just don't want people to have to cut and paste this into the browser. The link is stored in a calculation field in the database. I currently have this appear on the xml layout for the record. If you need more info let me know, but I think this covers it. Any help?

Hi, I would like to import my .xls file to filemaker pro v5. I followed the instructions as shown on the web, but nothing came out. Hence, I download the Filemaker pro 8.0 trial version. I tried opening the file in it. However, it popped up with this error message: "This action cannot be performed because the required table is missing". What is the required table? How can I resolve this? Can anyone kindly guide me what to do? adara

I'm trying to integrate FileMaker and MS Word using the excellent EZXslt. I've managed to get a working XSL stylesheet and the exporting works beautifully under MacOS X. I'm having problems with Windows and I believe the problem lies within FileMaker. It looks like FileMaker makes mistakes when encoding certain high ascii characters. Here's an illustration: On export, most apostrophes (that is ') are correctly exported as <'> but others are exported as <‚Äô>, which then yields no result in MS Word for windows. It could be that the problem comes from some deep corruption withing the "Contacts.fp7" database that I use for some of the dat…

Why is it that the get_short_time_format() function returns this message: java.lang.NoSuchMethodException: For extension function, could not find method com.fmi.xslt.ExtensionFunctions.get_short_time_format([ExpressionContext,] #NODESET). Checked both static and instance methods. I am able to use other funtions. For example, the get_time('short') function works. This is my code: Thanks, Moe

Hi everyone, I'm getting an error 200 when trying to add a new record. Does this mean I need an authenticate page? (login page) If so, is it possible to post the coding example? Thank you.

Hello all, I'm new to xml and was trying to find out if there is an easy way to generate an xslt from an existing xml, for FMP. Any hints or comments?

Could someone please post an example of how the basic search page should look before the user hits the submit button i.e. all the html within a few fields. I am very new to this and have tried putting together parts from the forums but to no luck. Thank you.

Hi all, When using characters such as ö / Ü etc. my xml gives a failure: "H䪡n Hellstr�> which should be: "Håkan Hellström"/> How can I solve this? greetings, KIP

Hi I am trying to set up a database that will import amazon data by just entering the ISBN and AWS grabbing the rest. I've read the following post but had no luck. http://fmforums.com/forum/showtopic.php?tid/153601/post/162185/hl/amazon/#162185 It imports 0 records when using the link below with the xslt from John Lorin Welshofer. (amazon_lite.xslt) http://webservices.amazon.co.uk/onca/xml?Service=AWSECommerceService&Version=2005-03-23&Operation=ItemLookup&SubscriptionId=0525E2PQ81DD7ZTWTK82&AssociateTag=aaaronorg-20&ItemId=1903083087&IdType=ASIN&ResponseGroup=ItemAttributes Here is the xml amazon generates: <?x…

Does anyone know if there is a way to script an XML import using and HTTP request into FileMaker 6? Our shopping cart support XML requests and it would be a great way to import recent orders. The only thing is that it would need to be scripted so our customer service department could perform the function easily.

I am using Filemaker7 with XSLT. I use the following lines of code to represent a radio button from a value-list on the web page. But there is no way that I can select a particular radio button as default. In HTML I could use something like: Please suggest

Filemaker pro 7 (winxp and osx) I have products in a database that I need to upload to my Volusion shopping cart The shopping cart requires a CSV file with header rows. My question: How to export the products AND a header row. I was helped very kindly about 6 months ago with an XML Stylesheet that worked very well for Tab-Delimited files. If anyone knows how tweak the XSLT to that it outputs CSV, here it is: <?xml version='1.0' encoding='utf-8'?> exclude-result-prefixes="fmp" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> …

I am using CWP with XSLT to add and edit records in a FMP7 database hosted on FMP7 Advanced Server with IIS. In the FMP7 database, I have a number of fields where validation criteria are set up, such as not empty, unique, valid date etc. If the user submits data which will not validate via the web interface, I get and error 500 - as anticipated - but there is no information about which field has failed validation, so I can't tell the user which field to correct. I'm considering using client-side javascript for the obvious things like not null, valid date etc but I can't see how to check for the server based validation items like 'unique'. Can anyone point me in …

FMI has posted some XSLT tips and tricks for FMS8A in their knowledge base: http://filemaker.custhelp.com/cgi-bin/filemaker.cfg/php/enduser/std_adp.php?p_faqid=5734 Except for server-side scripting, these hints also apply to FMS7A. If you want to use server-side scripting in FMS7A, consider the "Extending the functionality of FileMaker Server 7 Advanced Custom Web Publishing with Server-Side Scripting" white paper on their white paper list.

I'm in the process of switching my postage solution (for 7000 orders/year) to Endicia. Their Mac version is finally up to snuff, and their latest beta even integrates customs forms into the labels. Good stuff. I can export via XML and get Endicia to process the file. It then automatically generates an output file that I need to re-import to Filemaker. I really only need two lines: An order ID match field ("Package ID"), and then the tracking number ("PIC"). However, I get a parsing error, which is undoubtedly the result of my total lack of knowledge of XML/XSL. I got the XSL for the export from this forum (with a little cutting and pasting to correct for my fi…

Can someone (Martin?)help me out here; Im stuck on the final hurdle. Ive got the stylesheet to do about 90% of what I wanted, thanks to your earlier example Martin. What I've been trying to figure out, is how to get colours in each cell at the bottom of my html/spreadsheet (i.e. Management & Packaging) in grey, with the say a different colour (yellow) for Jalz and the email value. Using the , selects and colours the entire row. I have attached a sample HTML_Test1 to show you the result I am after, from FileMaker I can populate the value grey in cell 24, and yellowm in cell 25. But how do I colour a single cell in setad of a row? I will in the meanti…

Hi all, I have been trying to import from XML to Filemaker but I'm getting an error message. While importing I'm using "Import XML Data Source..." then File and specify the XML file location. The problem is I keep getting this error message "XML parsing error:" I must be doing something wrong. Any help or pointers is greatly appreciated. Eventually I'd like to script this process since the XML file is generated from transaction in our website. I have attached the file "Serviceticket.xml" Thank you. ServiceTicket.zip

I am having problems getting Filemaker to serve up the correct photo when being pulled an xml request thru XSLT. In a nutshell, its always serving up the photo from the first record of a found set - no matter what recid I call for. I believe that the url request is correct. Here's 2 examples: 1) Below is the url for the image src that is being generated. (I added the domain info to all so you can click & see) http://www.adlineagency.com/fmi/xsl/cnt/data.jpg?-db=6255%20Site%20Database&-lay=NewsListPage&-recid=28&-field=Photo1(1) My request is asking for a photo from record 28 - which should be a photo of a building entrance - but instead …

In the Customer Web Publishing Guide, sessions are described, but there is no example that I have found that explains how they are used in the stylesheets. i.e. Invoice-Home 11/15/2005 true However I do not understand how the session is then created. eventually I would like to be able to pass session objects through the stylesheets, in an effort to create a web based invoice system. I realize that the only way to add items to the correct invoice would be to use session objects. Can anyone help me out, as far as my best course of action. Right now I have the stylesheets viewing data, adding custome…

Hi Guys, I've been trying to get to grips with XML, by downloading the various examples from XML Central and reading the guide FMP 6 Developer Guide to XML/XSL by Beverly Voth. Im stuck on a very small thing, which any one with real xml experience will find very easy to answer. Ive got my code listed below: Im exporting fields A through to Z, where the Z field (position() 26) contains a colour value. The data might say Yellow, Red, White etc. My question is, how do I alter my line 3 to check the value of the field and call the necessary coloured variable. I have created variables underneath my stylesheet w…

I'm trying to pull some values from a FileMaker database using XSLT and retain the field formatting. I want all of the html tags to show up and format when the page is rendered in the browser. The problem is that the tags just show up on the page (they don't format anything.) I tried fmxslt:url_decode(), but this didn't help. Does anyone know of a way to have html tags that are saved in a database field actually apply the formatting when the page is loaded on the web?

I am trying to include the username and password into a link so that the dialog box does not come up to enter them manually. I have seen some syntax on this topic but could not get it to work. http://username:password@hostname:port. Does anyone know how to get this to work? Thanks, Nick

I'm using XSLT to search a field named 'email' that contains email addresses, and I want it to be a case insensitive search. I've already set up the field to convert all letters to lowercase. I could use javascript to convert the field input to lowercase on submission, but I'd like to avoid using javascript. Anyone have any ideas? Thanks.

My xsl works fine in Oxygen when debugging - it dutifully adds numbers as content to the file produced, i.e. I've got a sample dataset XML from my database. However, when I run this same XSL file direct from FMP, I get no numbers in the output. I've added a format statement, but still no number output. essentially my code is the following (my for-each is complex as it is derived from an xsl:key data grouping, but essentially walks through the records).

I have a solution which sends notification emails at various stages of a production cycle. I developed it on my home network and have now installed it on a twin-processor XServe running Mac OSX server. All aspects of the solution work as planned at home with the exception of the email notification part which occasionally will leave a browser waiting on the page that contains the XSL email tags to load. The actions associated with the page that should load are all carried out (a change to a field, a script and the email) and the page will sometimes load after a gap of several minutes. I've tried different SMTP servers, I've disabled the script, I've switched back…

When I export my FM data via XML and look at the text file the export has created, all the angle brackets of my painstakingly implanted HTML format codes, such as italicizied text or bolded text, turn into < and > This is a problem because when I import the text file, the angle brackets are "protected" by the < and > coding and thus are not interpreted as the paired HTML text format codes that I intend them to be. The codes show up in the text instead of enhancing the text. How can I prevent this substitution from happening? Thx for help.