XML/XSL

Once again I am back to this esteemed FileMaker forum for a bit of help. Any assistance will be greatly appreciated. I am using the -script and -script.param query parameters to run a FileMaker script and pass parameters to that script. My question is how do I access these parameters in my script??.........Ray

Howdy everyone! : I am not new to Filemaker (i have started with version 6) but this new task i'm up to is making me headache. In short: we have to sent a XML request with a catalogue number in order to receive a XML file with informations about pricing, availability etc... This has to be done per product or per order (i'm not sure about that). As i'm completely new to the XML/XSLT, please just let me know if this is the right way to do it: i have to make two XSLT templates that Filemaker will use, one for our XML file and one for the XML with the informations. Is there something i should concider or worry about? The XML looks simple and …

I'm quickly learning that what I want to do is not possible with IWP, which is fine. But I just can't seem to find out how do it in CWP either. I want to send users to a URL on my server with their email adress in that url as a value and then populate the email field in the XSL form that comes up. Seems pretty simple, but I'm missing something. Any help is greatly appreciated. Thanks! -- Chevell

Hey there, I am trying to import data from a German library format ("MABxml") via XML into my FileMaker solution. The original format uses fields and subfields, but it seems that this is a problem I've solved; the import works fine. However, the original format also uses the same field multiple times with different values. In the attached xml-file it is field #902 that appears twice in one of the records. I cannot find a way to solve this; ideally, the result would be that the import delivers field #902 with two values. Or do I need to merge this fields first, before importing? Any hint is appreciated. Mike DNB_Field_902_twice.xml.zip DNB_Field_902_twic…

I am new to the world of XML and XSL and am struggling with how to transform a Filemaker output which is a series of table outputs all related back to a single record of the form: <?xml version="1.0" encoding="UTF-8"?> 0 249 250 251 252 253 254 255 256 257 258 259 260 261 249 250 251 252 253 254 255 256 257 258 259 260 261 MLP John Bill James Andy Jamie Danny Chris Tom Arianna George Beth …

Hello, I would like to import a XML file in Filemaker. So I created with the help of this link and this wonderfull template: http://edoshin.skeletonkey.com/2005/10/use_modular_xsl.html a xslt file to convert to FMXMLRESULT syntax. It seems to work as I don't have any error messages but the import still doesn't work (0 record imported) for an unknown reason. Attached to this message is a zip with the 4 necessary files: - Medindex.fp7 --> the filemaker database in which I wish to import the XML data - Medindex_Product.xslt and FileMaker.xslt --> files needed for the conversion to FMXMLRESULT syntax - DownloadMedindexProduct.out.xml -->…

I am having difficulty grasping how to generate a email to the individual confirming they have registered for one of our events. I would like to generate this email when I generate the web page confirming the registration. The email would contain some basic information about the event. Any thoughts would be much appreciated.... Ray

Hi Guys, I have to write a module which exports data out of FileMaker (names and addresses) and generates a mail merge in Word. I've been investigating doing this with VBScript, but I stubmbled across an xml/xslt example by Jay Welshofer for FM6,where he exports a letter created in FileMaker to a Word document. Is it possible to create a mail merge with this technique to merge multiple records, a header and footer a document? To tak it further is it possible to create a letter in Word (Just coz I know you can create tables etc in word) and add filemaker addresses to it. We use Word 2007 over here. Dont know which way to go vbscript or xml/xslt? Dont really know …

This is such a basic question, but here goes. I am using an xml file for creating an export with the correct encoding. In single user mode, the file can live on my harddrive and the routine works as expected. However, these files will be hosted, and I would like the xml file to live on the server only. Where can this file live and be available to hosted files [and consequently the users]? What option would I select in the XML selection dialog? Any help would be appreciated. Many thanks.... *susan*

I want to use google map api to generate a map of multiple markers on a google map dynamically from the datafields returned to the RECORDLIST. I can only find a PHP solution online. Anyone have any solutions using HTML/CSS/XML/XSL and CWP web publishing engine??? I can easily map a single location, just can't seem to get the multiple markers to work. anyone?

Hi everyone, Is it possible or are there any tools that can validate data imported into filemaker from an xml file For example say I have a Contact table with fields: CONTACT: company fname lname After I export this into xml the xml file would contain nodes company, fname and lname. Sometime later my database schema changes and fields fname and lname are renamed to first_name and last_name Now if I import the original xml file with nodes fname and lname the import will still work without any errors thrown from filemaker and only company will be imported since fname and lname fields no longer exists in the database. I understand I coul…

So, let me start from the beginning... I have had this ongoing project to get a report out of filemaker into Word format. Well, I have been able to slowly wrap my brain around this thing (atleast 90% of it, anyway). First, I created XML. This that is generated by a proof of concept DB. This code is created on the fly by calculation field and is fully qualified XML code (AFAIK). Next, I created the XSL Stylesheet that transforms the XML to WordML. The stylesheet does successfully transform the XML to WordML and it does it well, without errors. That is to say that it is error free on my system running the transform from the command line as well as from Filema…

In my FileMaker Pro solution, I would like to be able to reliably import date values from an XML file using an appropriate .xslt file. In the XML schema the date entities are defined to be xs:date. Most commonly I would have the format of 2009-11-25 and similar but since xs:date can optionally include timezone info, the value might be any of the following formats 2009-11-25+2:00 2009-11-25Z 2009-11-25+00:00 or even -2009-11-25 (I'm not sure why a leading dash is permitted in an xs:date.) For my needs I will be ignoring any time zone information and expect only 4 digit years, but I haven't found a good way to handle converting to the user's locali…

Need help with the proper method of formatting RDF xml grammar in a xslt to convert to FMRESULTGRAMMER for an import. (DISCLAIMER: I know enough xml to pull in simple feeds. I am NOT well versed in XML otherwise) My issue is with defining the items into a list that can imported. The current feed gives references to each feed item found, and then uses the "rdf:about" to identify each entry listed in the "rdfSeq". Is there any place I can go to see an example of a FM XSLT with grammar related to converting RDF content?

I am new to XML, but experienced in FM - I am trying to set up an XML import via HTTP, however, as soon as I push the “continue” button (after entering a HTTP address), I get an immediate response: XML Parsing error: An exception occurred! Type:Runtime exception, Message: The primary document entity could not be opened. Id=C:Documents and Settings... Any ideas??

Hi, I want to export excel file with formatting. Using xsl style to generate Excel XML is ok. But it is not native .xls file. This file will be used another application. So it may require orginal xls file instead of excel xml. Is it possible to generate native xsl file (like save as excel or export as excel) from filemaker with stylesheet? Thanks, Osman

Hi there... I'm producing XML code to export data out of a fM file, I use a calcuation field to represent the XML code of each record and then I export that field to a file... very simple and works. Normally, I dont have much trouble, but the XML does not have the same validation I have implemented in my FM file, so sometimes I produce XML files rejected in the other part(Empty fields etc...) I could program that validation inside my calculation field but since I am provided with an .XSD file, I wonder if it would be possible to use that schema to validate my XML code inside my FM solution. ¿Any suggestion, example of use of .XSD code in Filemaker?

I apologize in advance for needing such easy help, but although I know FMP very well, I know nothing about XML. I've tried to learn from other posts, but I just don't get how to create the XSL that will import the attached XML file. I would like to have the following data that would go into a single table with fields of the same name: DateTime JobName ImageName Profile Calibration CLSID_Wedge Device Filter Light Angle Backing Row Column L a b Any help or point in the right direction would be awesome. Job_0037_Job_Strip.zip

Let me preface by saying I am a FileMaker newbie.. : We have an ecommerce web application written in PHP/MySQL. Our internal order processing is written in FileMaker. Right now orders are manually input into the processing from the web. We are trying to automate that. He have played with secure ODBC and XML to accomplish this. What is the best way to do this securely, ie data encrypted at all times? I appreciate any assistance you might offer.

Data source get request with example xml api: http://www.campaignmonitor.com/api/method/client-getlists/ Would importing XML (with a XSL) with a HTTP GET request request work? (with set mapping) Is it just using the 'import xml' function with a correct XSL? How would i go about doing a SOAP request is it just the same but needing a different XSL? thanks! rafal (scratching head over xsl) more example: http://www.campaignmonitor.com/api/required/ http://api.createsend.com/api/api.asmx?wsdl

Anyone else having trouble with this? It worked in FMP pre-10 (or so I thought). I'm trying to merge some pre-processed XML with another FMP Export and XSLT.

Hi All, I'm needing help in exporting my data to a excel format. I did download the attach example of xslt provided by FileMaker and Jay Welshofer. In FileMaker I have a layout that has columns fo data. At the bottom of the layout I have a footer that displays totals. I need the totals appear a the the bottom of the excel file. Some of the total fields have data in them that does not appear in any other field How can do I do that. Any help is appreciated! msxml_hgsales_report.xslt.zip

I am a newbie. My client uses FileMaker 6 and I am attempting to import data stored in mySQL via phpadmin to an XML file, then into FileMaker. On import to filemaker, I get the error: XML parsing error: Unknown element "cliniciansmember' Line: 288 col number:26 I am attaching the XML file (saved as txt) in case someone will look at it and tell me my problem. I hope you can help. We are expecting around 900 registrants for a conference and would like to not have to enter them all by hand. : Thank you in advance for any help. Linda onlineregistrations_4_.txt

Hey all, I'm trying to import some data via XML from a webpage (via script step), and I'm running into an interesting dilemma: There appears to be no way to define source fields to update matching records! The XML file I'm grabbing has a single piece of information I'm interested in, and at least one field I can match on. I've created an XSLT definition to translate the XML output, and the import format is apparently fine, but I do not have the option of defining the import criteria as there's no listing for the source to assign for matching and updating. Any help would be appreciated. :bang:

I have an endnote library that I would like to convert into a fm database. The obvious endnote options for exporting, like tab delimited, don't work because the data columns are f** up due to variable numbers of author, keywords, etc. in each record. It looks like the only option is to export as xml and use a xslt file to make it filemaker-friendly. I have read stuff on xslt and looked at examples but I have no idea where to begin. Can someone give me some ideas about how to get started? Thanks.

I would like to use the following codes to calculate the total value of BR_PA. The result I received is NaN. When I went online to find out what is wrong, I realised that it is because no value is contained in some of the nodes and also because my values contain decimal point. How do I resolve this issue? SOS select="$bayerList[position() <= $halfIndex]"/> …

Hello, I'm trying to output a field in HTML (via XSLT) this field data are 'formatted' using some tab (CTRL+TAB) in .fp7 file but the XSLT transformation ignore those TABs treating them as simple space (nbsp; like). Is there any way to show the correct tabulation instead? I tried using translate(filed_text, ' ','& nbsp;') but it didn't work.

Hi, I am construction XSL-XML web page for my FileMaker solution. But the problem is browsers printing capabilities. Browsers add title, and date into the header and footer of the page. But I want to print only that I want to print. I think if I generate an pdf file, there is no such a problem. If user click print button, a pdf page instead of HTML opens, and directly prints. But I am not sure can I prepare a pdf directly from web query? Is it possible? How can I find example style sheet for generating PDF directly from web browser? Thanks in advance Regards F. Osman Cabi

Hi, A supplier is making their catalog available as a XML file via http. It's 29.1 MB and consist of child elements. I like to do a one-way sync with our Filemaker catalog file.I need ideas on which would be the best approach. Thanks

I have an XSLT page that calls an XML file created in Filemaker Pro Server 9. I am having trouble getting some data to display dynamically. Right now I’m using an xsl template to display a specific hard coded on any page that calls the template: 7/08 However, that date is also stored in a separate table from the main data and I would like to display that data rather than the hard coded template. I thought I could do it as simply as this: But nothing displayed. I also tried this and also have no luck. � I'm thinking I must be referencing the node incorrectly? It''s possible that it's a FMPro thing, but…

Hi Colleagues I need a problem, because I´m working in a Tourism Software Developer Company in Costa Rica. We have a filemaker system specialized in Tour Operator Companies... All reports habe been designed using XSL,and works very well...but I need to show images residents in a web page... I need help please... - - - - -

Hi Guys, Can someone tell me whether we can place filemaker generated xml files in wwwroot (or documents on the Mac) or do they HAVE to be placed xslt-template-files folder. Thanks Jalz

I'm trying to parse data using the Geocoding Web Service (from Google Maps or Yahoo Maps for example) to find the specific latitude and longitude for an address. The Request URL is formulated as follows: [color:purple]http://local.yahooapis.com/MapsService/V1/geocode It's easy enough to form a sample Request Url as follows: [color:purple]http://local.yahooapis.com/MapsService/V1/geocode?appid=[color:red]YD-9G7bey8_JXxQP6rxl.fBFGgCdNjoDMACQA--&street=701+First+Ave&city=Sunnyvale&state=CA using data from fields in FileMaker (note: [color:red]you need to apply for and supply your own APPID for your application as shown in red) The Response field…

Hi all - Very much a newbie to XML/XSLT in Filemaker, so I'm not even sure if I will be supplying the proper info here. I'm trying to create a stylesheet in order to import data from a file that has info formatted like this: PS3569.T3868 C79 1999 Assuming I want the PS3569.T3868 info imported, how do I reference just that field in the stylesheet? I've played around with variations of this: and But these don't seem to work (the second one returns just the letter "a" but it makes me feel like I'm on to something Thanks in advance for advice and help. Again, I'm very new to this so let me know if more details are re…

hi all, this may be easy, but i'm having a hard time finding out the how... i have records that need to be exported on a regular basis, in a particular format. this is where the XML schema comes in... i have a http reference to the XML schema, and i have it available in a word doc too. how do you reference this XML schema when exporting records from within FileMaker? i appear to get a prompt to select a stylesheet, but not the XML schema... do i need to have a stylesheet, that references the schema? i'm using Pro 9 Advanced on Windows XP. any tips would be appreciated. jd.

Hello all, I am new to XML exports but experienced in Filemaker. My question is this, I want to create an export file from Filemaker which will meet a DTD set out by a third party website for upload to their listings automatically. From what I can gather the best way to do this is to create a XSTL sheet and use the FMPXMLRESULT option. Does this seem right? Alternatively, I was going to create a text based export but am having difficulites with carrrige returns and formatting. Has anyone experience of this? Any help greatly appreciated, John

I have been trying to achieve this but am hitting a wall. Where exactly and how could I declare the following entity With this code <?xml version='1.0' encoding='utf-8'?> exclude-result-prefixes="fmp" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform"> seller-id gtin isbn mfg-name mfg-part-number asin seller-sku title description main-image additional-images weight features listing-price msrp keywords product-set-id store-code category-id Thank you

I am sorry to say I am in over my head with xslt. So I am here to ask the experts. I am using Filemaker to create an XML to send to postage printing software (Dazzle). After the postage is printed Dazzle creates an output.xml file I would like to import back into Filemaker. I do not get errors with what I have but I do not get any information either. The import returns empty. Thanks in advance for any help. The output file is: PRIORITY 1 RECTPARCEL FALSE 5 9 12.0 1 TRUE 87.00 Swimwear 0038005 Jim Foster 411 Winfield Cir Somewhere GA 55555-2222 jimf@solart…

Hello, When I'm trying to use instant XML publishing on the company network, with internet explorer 8, I just get an error page. With Firefox, I get an authentication dialog saying "Enter user name and password for http://'my-server-name'" I've tried to enter there - my network login/password - my filemaker (admin) login/password) etc And nothing work. BUT : If I just click on 'Cancel', I get another authentication dialog saying "A user name and password are being requested by http://'my-server-name'. The site says: "'my-db-name'"" There, I enter my filemaker login, and I get the XML I want. The problem I that I have no id…

I have a script that downloads, via FTP using the SmartPill PHP plugin, a set of XML files. I've written an XSLT stylesheet to transform this into the FMPXMLRESULT XML that FileMaker expects when importing an XML file. If I have downloaded the file and import it manually it works. If I have the SmartPill PHP plugin download the file (saving it to /private/tmp/ on Mac OS X Leopard with FileMaker 10, BTW), it imports successfully. However, when I try to import the file within a script, the Import script step gives the following error: "XML Parsing error: An exception occured! Type:SMLPlatformException, Message, Could not open file: filemac:/Half Dome/private/tmp/3660.xml, L…

MY XML structure looks like this: xmeml/bin/children/bin/children/clip bin/children is repreated because items exists in a folder (or bin), which exists inside another folder (or bin). Sometimes the path is "bin/children/clip" anbd sometimes it will be "bin/children/bin/children/bin/children/clip" is there anyway of doing this that will allow me to use one stylesheet for these different variations?

I suck at using the search option in here so once again I'm sorry. I am putting up my XSL for getting Amazon info for whomever since I really got it and developed it with the help of so many here to begin with anyway. I started with what I already had and am trying to edit it. SSssooooo here's what I want to do..... Get 1 record with the ISBN, Lowest New price, Lowest Used price (which I already get) Then take each offers - Merchant ID, Condition, Subcondition, Note and Price Putting them into the fields: merchantID1...Condition1..Subcondition1..Note1 ..Price1 merchantID2...Condition2..Subcondition2..Note2 ..Price2 merchantID3...Condition3..S…

I'm merging two files into one and wonder if there is a quicker way to rebuild TO's in the relationship graph, perhaps by using XML data?

I am new when it comes to creating a style sheet to be used when importing xml data. I have read through the previous posts and I have changed my code numerous times and I am still not having any luck. I would appreciate any help! XML Data: <?xml version="1.0" encoding="ISO-8859-1" ?> - - 5465182 xxxx 2 $249.62 G5465182 $47.05 $296.67 COLUMBIANA, OH 1-800-333-9974 WILSON, NC 1-800-545-3017 $1,680.50 $1,445.23 $14.35 $70.58 $320.20 $94.11 $343.73 900 1700 …

Is there a way to integrate a FM solution with Federal Express? I would like to send package info to Fed Ex, and receive price, label info from Fed Ex. Can this be accomplished with XML? Has anyone done this? Where do I begin?

Hi, we are working with another software vendor and need to provide data to their database in the form of an xml file. The xml file needs to be in a specific format. I assume I need to create an xslt stlyle sheet to convert the data in the format they require. How do I do this? I have tried to look at a number of resources both online and on my filemaker database (examples provided by FileMaker) and I can't figure out how to do this. Most of the documentation I found was converting information to an html table. I don't require this. I just require an xml file with the data in it. My database has three fields (for the sake of simplicity). Article, Aut…

I am hosting a number of databases on FMSA 9. When performing the following query: https://myserver/fmi/xml/fmresultset.xml?-db=myDatabase&-lay=Data%20Entry&-find Firefox renders the following: Internet Explorer renders the following for the same query: The XML page cannot be displayed Cannot view XML input using style sheet. Please correct the error and then click the Refresh button, or try again later. The download of the specified resource has failed. Error processing resource 'https://myServer/fmi/xml/fmresultset.dtd'. I can't find anything on [color:red]fmresultset error 959. Has anyone seen this…

I used the Site Assistant to generate XSL for my database, and the auto-generated addrecord.xsl always errors out when I click on the add record button. I am new to XSL and everything I have tried has not worked. I have attached all my XSL files plus a copy of the database with fake data. I am a little over my head right now and would really appreciate any advice. username ITS password test fakedata.zip

I created a script that is to be executed via xml to give a result. When I test the script within filemaker it works fine. When the same script is initiated with a URL and the same parameter is passed in, the record count is fine and all but three of the fields are correct. The three fields are blank. I have very minimal experience in dealing with xml, but if a script is running within FMP, shouldn't you end up with the same result regardless of where the script is initiated? The URL is calling the same layout as the script begins with. Thanks, John

I am not a programmer, and know very little about XSLT style sheets. I have some xml information that i need to import into filemaker pro 10. Can someone show me how to do this? Here is my sample XML code: <?xml version="1.0" encoding="UTF-8"?> 14790973 2009-02-24T21:45:17Z 2009-02-24T21:47:03Z 133003 Everyone A Bunch of info 5843393 23 John Doe Lane Ln. Parkland FL 33076 Work Magazine 378067 Book 378068 John Doe 14790972

I need to understand how an xml file needs to be formatted so that when I do an xml data source import into Filemaker I can get multiple child records. For example: the xml file contains people data (name, address etc) and it contains people's item data (spoon, fork, knife). The spoon, fork and knife data are 3 children records to the one "people" record. This is the child section of the xml: I know to first import into the parent table then switch to the child table and do another import. I know to use the parent key field in the second import so that the records keep their relationship to the parent. What is happening is that I get o…

Hi all Can anyone tell me how to do a stylesheet that will replace some text with a carriage return or other character? I have a field that I am exported with representing the returns required. I would like to end up with a text file with the text replaced with a return or ^m ... is this possible. At the moment my style sheet does nothing to format the text file outputted. This is my first attempt at a stylesheet. Any help would be greatly appreciated. Cheers ZP

Hi all, Has anyone had experience talking with RosettaNet? I cant seem to find anything that would help me out? I know rosettanet used xml documentation. Can you give me any pointers? thanks Ricky

I am attempting to write code to import information from Amazon via XML...I have some experience writing XSL code for FileMaker import (was able to do it with Yahoo Merchant Solutions), but I have hit a snag with Amazon I haven't been able to overcome. Here's what I've got...First, a sample of the XML code returned by Amazon: <?xml version="1.0" encoding="UTF-8"?> True B000KL8SZ8 B000KL8SZ8 Jakks Toy BIG SHOW DELUXE AGGRESSION 5 WWE JAKKS FIGURE And here is the XSLT stylesheet I wrote to parse the information: <?xml versi…

Hi Guys, Does anyone know of any good beginner/intermediate books with good examples that I can buy to further my knowledge on the subject. I've bought Bevs FM6 XML/XLST book which is good and the penny's dropped using some of the examples but I'd like to further my knowledge of the XSLT side of things, as my main aim is to communicate with other systems. Many Thanks Jalz

I am using Filemaker Pro to export XML to produce listings in InDesign for information submitted by various organizations. My listings database is linked to another database in the following manner: The listings for each month are in one database, and the usual suspects who submit the listings are in another Contacts type database. The listings DB pulls information from the related Contacts DB based on a key field to cut down on data entry, and puts it into portal fields. It pulls the id number from this related database, and stores that as well for each record. (I use this as a link to related record button --a quick way for our data entry folks to look up the relat…

I have a calc field with xml code and i would like to test whether that xml is valid or not. At the moment i am using oxygen to validate my output but I would like to do it inside my filemaker solution. Any suggestion??

I have a flash file that is driven by an XML file that was created via a MYSQL & PHP site. I would like to port these functions to Filemaker. Having read the XML Filemaker manual, I am unable to understand if filemaker can produce the right file that the flash page needs. I attach the file in the hope that someone can tell if this is an easy hing to create for filemaker or I am just dreaming. lotm.xml.zip

I am trying to import data from an .xml file generated by a program from the google aps library called xlm-dir-listing. I am not having any success at import i think because the .xml data does not conform to the fmpxmlresult.dtd How do i transform the xml-dir-listing output .xls data to conform to the Filemaker dtd requirements before triggering the import? Any thoughts on how i can get this to work? TIA Kris

Hi, Is there anyone who know a good freeware with which I could convert XHTML tags and content to a XML file? Thank

Hi all, Has anyone tried to exchange data from these two systems? I'm especially interested in users logging into the Ektron system, and retrieving personal (based on accounts and privileges) data from a FileMaker based system. Many thanks Jalz

I'm wanting to update my xsl's for a potential move to FMPXMLRESULT - as DSO is depreciated. I lament the loss of DSO - it was so easy to create an xml document where all of the field names were tags with all of the data contained within. Is there any dynamic way to say with an xsl - match the data to the appropriate element? My starter xsl below. FYI - I use this stylesheet to tag InDesign documents for data merging. <?xml version="1.0" encoding="UTF-8"?> xmlns:fmp="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fmp">

Dear Sir, I am trying to develop a login form (via flash) using the xml query string. AS I do not want to use the basic http login request, I must enable the guest account in filemaker pro. WHen I do send an xml query via browser as this one: http://127.0.0.1/fmi/xml/fmresultset.xml?-db=FMF&-lay=Web&-script.prefind=webrelogin&-script.prefind.param=%7Clogin%7Cpass&-findall the login and password parameters are sent to the webrelogin script,which must perform the re-login script step. What it happens is that, being the guest account enabled,the error code sent back by FMS is always "0" (=no errors), while I should get an appro…

Hello all, is there any way to restart only fmscwpe.exe process via command line? The latest FMS version (9) runs only one service which drive all processes so if I restart the service itself I restart both database server and publishing engine but I need to restart only the latter. Any idea? Thank you in advance(d).

Hi Guys ! Some of you smart guys probably know the answer to this, but my mind is turning to clay right now. I am doing an export where I want to make a couple of .csv-files using carriage return line feeds (CRLF) (off course). On the mac the style-sheets produce the CRLF's but on windows there appears to be an extra carriage return. How can this be ? Does formatting of the layout play a part in this ( the checkbox with the export dialog ) ? TIA ! Joost PS. The CRLF-variable gets interpreted when posting it seems. -------- PART OF THE SHEET -------- <?xml version='1.0' encoding='UTF-8' ?> xmlns:fmp="http://www.fil…

I am trying to concatenate large sets of ID's into one return-delimited value. To do this, I'm exporting the records in XML format and then using a stylesheet to collapse all the rows into one record upon import. The transformation works fine using my trial copy of oXygen XML Editor, but FileMaker is crashing every time I try importing through the stylesheet. oXygen will give me the transformation results and that XML imports into FMP without a problem. I have oXygen using the Xalan processor, which is what I understand FMP is using. Can anyone shed some light on this? I am stumped. I've included samples of the exported data, the stylesheet, and the transforma…

Hi, I am generating a XML file via XSL stylesheet. I declare output encoding as "ANSI" but my generated XML file encoding is UTF-8. (To check file encoding, I open the xml file with notepad. I select save as from file menu. The encoding field is filled with UTF-8 automatically.) I have added following code in my stylesheet but it does not work. I tried to delete some special letters in Turkish alphabet data in the fields. Then it worked. But I have to use Turkish letters and my file must be ANSI encoding. How can I do that? Thanks in advance. Regards My Entire XSL Stylesheet, may be helpful. <?xml version="1.0" enc…

Hi, I am try to generate XML file with a stylesheet. But there is a small problem with my data in FileMaker. My name field contains apostrophe, FileMaker export this field successfully, but in the other application that I will import xml file gives error. May be I can replace special characters (' to ') using additional calculation fields but I wonder if is there any easier way within xsl stylesheet. Is it possible to change special characters via xsl functions or methods? Thanks in advance Regards F. Osman Cabi

I have a simple xsl to strip away filemaker specific tags upon export of my data. This lets me import it into InDesign as tags. I'd like to insert some labels - and otherwise transform the xsl upon export. I'm running into issues - possibly because my tags are generated on the fly. The stylesheet below attempts to add in the word 'Department' before the data found in the tag. <?xml version="1.0" encoding="UTF-8"?> xmlns:fmp="http://www.filemaker.com/fmpdsoresult" exclude-result-prefixes="fmp"> Director: ---- this approach also does not w…

This post follows one I made time ago and it is concerning the ability of using xml

Hello, I hope that some of the gurus that are in this forum can give me a clue about the following matter. I am interested to a particular aspect concerning flash filemaker integration via XML. I have red about XML URL SINTAX and this is the question: I want to develop a flash login form where,before connecting to the server,users must authenticate and that would be used to show error messages when username/password or both are invalid. XML URL SINTAX does not tell how to handle it, but only how to get and send data via XML. I mean that I have not find the way to send, VIA URL,username and password for authentication. Can someone give me a…

Dear All, I have used the XSLT Site assistant to generate a site based on a flat file. The only problem was that I had some rather large text fields whilst the site generateor produces pages with single line input. To rectify this, I went into dreamweaver and changed the input tags to the textarea tags. As soon as I have done this, whenever I try and edit a record, it does not display the contents that are in the database. When I change the tags back to input, whhen I try and edit a record it works fine. Can someone advise please. Kindest regards Jalz //FMSITE GENERATED CODE FIX() …

Hi, I'm trying to figure out how to read XML data from my server. Is there any snippets available? I want to generate a KML with a link to my server. Thanx

Hi, I'm essentially using the configuration described on the following web page to send emails via XSL from the server (FMS9A). http://www.grahamsprague.com/server_side_email/server_side_email.html In short, the user clicks a button to run a script. The script creates a record in an "Email" table containing the email fields. It then opens the web address to the XSL (send_email.xsl, attached), which attempts to send the email. It works fine, except when one of the email fields contains a special character (for example, an ampersand in the Subject). In that case, I get error 10202 ("Message SMTP fields error") from the send_email() function. Do I…

Hey guys, I can find reference to this command in the XSLT Reference, but not how to use it. I want to use to insert the client IP into a field in the form I'm using. My code is as follows. submitter() submitter I'm not great with XSL, but this seems pretty simple, no? If i just use the command by itself, I get the right IP posted in the form itself. I just can't seem to get it into the input field. Any help is GREATLY appreciated. …

Hello all, Ive generated a xsl site for my small database of 5 fields using the FileMaker site assistant. the generated pages work fantastic (unlike php straight away). How do I apply a css stylesheet to the xsl grammer generated? Im guessing its not quite as simple as php and html? Thanks Jalz

Hello, anybody used xslt (v 2.0) tag to group a recordset? It seems FMSA9 support the latest xslt version so I was trying to use this very helpfull tag but it doesn't seems to work. I'm using fmresultset grammar and a XSLT structure like this: the result is always empty (but for-each-group seems to be recognized). Can You give me any help, please?

Hi, I have to import data directly from xml scheme below: <?xml version="1.0" encoding="iso-8859-9" standalone="yes"?> 1 07B01AD05AC0000001 Travma 2/KalemId> 07B01AD05AC0000001 Baska I have modify example rss import xsl file to import from my xml file. XSL file content is beleow: <?xml version="1.0" encoding="utf-8" ?> 0 But when I try to import this xml file, FMP gives error; XML parsing error: Invalid Document Structure If I delete xmlns a…

Hello All, I've got a Word document, which I would like to create a dynamic footer for. The fields for the footer are in a FileMaker database hosted by FileMaker Server Advanced 9. I was thinking I could use XML to merge fields. Has anyone used Word to merge fields from FM using XML and is it more robust then ODBC? Thanks Jalz

Hi, I am using XML export to generate word files. But older office versions (Office 2000 and Office XP) can not open this kind of files. How do I handle this problem? Is anyone knows any alternative office application to browse and edit WordML files. Or should I export in any other format, but how? Thanks osman cabi

I have an xml file and a style sheet i downlaoded from a web site that uses xml and xsl but when i import it into filemaker, it gives me errors and won't do it. attached are the files im trying to import. character-sheet.zip

An external user is trying to import data to a non-FileMaker database getting data through a xml-query. http://user:pw@host:port/fmi/xml/fmresultset.xml?-db=database&-lay=layout&field=content&-find When trying against our development server (Win2003/FMSA9) it worked fine. We made exactly the same fields/accounts/layouts at a customers server (Mac OS10.?/FMSA8). The difference we get in the requests is the path to fmresultset.dtd. From our development server the path is http://host:port/fmi/xml/fmresultset.dtd. From customer server we get only /fmi/xml/fmresultset.dtd. Hence it is not possible to import data at third party. Any suggestions?

Hi there, I've setup an XSLT style sheet to import the contents of these XML branches into FM: ... ... However I'd also like to import the id statements that are within the tags. How would I go about extending my XSLT style sheet? Here is what I use, which aside from not importing the ids works perfectly well: <?xml version="1.0" encoding="UTF-8"?> 0 Any input greatly appreciated! …

This is a shopping cart type xml file. I'm using a calc field to create the URL request to send and it can handle up to 50 items at a time. The URL creates the cart and XML I'm scripting as an import... Import Records data source = XML my calc field = http request my style sheet = XSL stylesheet unchecked - 'preform without dialog') When the script runs I can copy/paste the URL from the pop up and it opens in the browser. However if I "continue" I get an "XML/XSL information is not enough to proceed with import/export" error. If I save hard copy and change the path to it it comes in ok. If I reduce the URL to…

Yes, I'm XSL Illiterate so laugh if you must... One problem is that I've never figured out how to move back up the nodes or how to handle a circumstance like this: ... I need to get multiple records to import when there is not a -for each- of the first fields... The important fields are: - - - Which I want to import into a global fields and the multiples come from - - I want to get 2 records from the below for import update matching the ISBN's : − − 10999877787 m26VY4oJhr8= m26VY4oJ1y9lj3D www.url.com $31.38 $31.38 0425213757 …

I'd like to store some parts of XML documents in text fields, then combine them and extract them via XSLT acces with a stylesheet. My problem is, FileMaker is transforming each entity in the output (< to '<'). So I do not have any XML more in the output, but text. Is it there a way to manage that in the export params? Of course, I can use an XSLT stylesheet to have the right output, but then I need a second stylesheet to produce the HTML output I'd like to have. Is it there a way to reparse the output in the same stylesheet? Sorry fot this very basic question (I'm new in XSLT), but if someone could help me... :P

I'm a total newbie, so sorry for asking a dumb question (I have searched and read for a few hours now and whilst my head is buzzing, I'm no further to a solution). How do I export a text field, containing placeholders for CR and TAB, to XML so that when the xml gets pulled into the browser, they affect the actual formatting, i.e. the show up as indents and ? I have read up about unicode, stylesheets etc, but I need a simple step-by-step intro. Thanks so much for devoting time to answering this.

I have an app that accepts xml data for import. This is a typical line in the xsl style sheet for the export: What would the xsl line look like for this: UPS Ground In other words, I need Filemaker data in place of the "12.00" and "$2.00" in the above xsl line. I can't get the syntax right.

Hello all, I've read the Filemaker Custom WP guide but I cannot find any command to exclude duplicate in a specific field. In fact I was looking for a parameter like "-sortfield.1=filed" or something like this.. Is there any way to omit duplicate record via filamaker query? Thank you.

Success! Invitations have been sent to the following people: ()

I have everything set up with the sheet as a file .xsl and working fine. I'm wondering if instead of calling it by using the 'Use XSL style sheet' and choosing 'File' if it can be done any other way? My thought was setting up a text field with it in there and calling by 'Calculation' with the field as the calc. Silly question probably but I've put a lot of work into getting this stylesheet just right and am looking for some way to protect it. Thanks... off to a funeral. Will check in later.

hello, i am totally new to filemaker pro. but i need a way to a template file for final cut. i hav tons for timecode logsheet. how can i export from filemaker to xml and import into final cut as xml , so that i can batch capture. thanks alot. i hope there is a template i can use. please advise.

Hello, I am trying to edit a FileMaker record using browser. When I click Edit button, I want that a new page should appear where the "existing values should appear" in editable mode. I am able to do it for records in text boxes using following code: Document Title: docName() Now, the problem is that I am not able to do the same thing for a text area using the following code: Comments: …

I'm trying to set up a relogin button on my xsl pages. i've made a script called "relogin" and this performs the re-login script step in the filemaker database. But my filemaker indicates it is not web compatible??? When I run the script on the xsl page nothing happens, I don't ge prompted for a password or login. I've searched the manuals and it is just mentioned that you need to use the relogin script step but nothing else is mentioned. I've searched the forum and the internet but can't seem to find a solution.... Can anyone help me out.....

Can anyone give me an example of the invalidate_session function. I can't seem to make it work. I want to create a hyperlink in my template that invalidates the session and then points you to the stylesheet "home.xsl" I'm trying to logout the web user so that he needs to re-enter his password....

Without the need for my customers to buy Server advanced with ODBC, I know that FileMaker Pro supports XML Queries. The problem is I cannot find an example of how to query FM Pro with a http request. This fourm,Google and FM Pro help did not help with finding an example. Does anyone know how to get data from FileMaker as XML? For example, http://127.0.0.1:592/fmpro?db=mydata&getxmlRequest Am I making sense? Thanks in advance, Jim.

How can I make fields required on a web form using XSL?

Forms in general. How to edit delete and view records. Use Global fields.

On client of mine needs (for several reasons) to sincro (basically It'll send all customers info) an other DB throught XML but using SOAP (web service). That means, more or less, from FMP export by XML > send to a SOAP service that must start the transmission. Any ideas How this can be done? Any ideas will be appreciated !!!

I have a FMS 9.03 Server advanced setup on Windows 2003 server. The Filemaker server and the web server run on 2 different physical servers. This all works fine except I cannot get FMButlers iCal XSLT to access any database. I get error: Access is denied at http://web3/fmi/xsl/vcal/vcal.xsl?-db=IT_Documentation&-lay=Document&SOX_Note=0&-find&-grammar=fmresultset with this login and password. We have a virtually identical test environment setup, except the Test server hosts both the web server and fms server. The ical XSLT works on this OK. I have checked the XSLT test page on the production server and privileges etc. Any ideas TIA Craig