XML/XSL

Jessica has a secret. It takes place at night and she tells no one, not even her family. But she can't stop; like an addict, she's hooked and feels unable to control her behavior. Jessica, by her own admission, is an Internet shopping junkie. "I can spend $10,000 in ten minutes on the Internet," Jessica says. "E-shopping is quick and easy. Once you get the swing of it, it's hard to stop." A financial planner at a San Francisco brokerage house, she asked that her real name not be used. "My job is about encouraging people to trust the Internet as a rational way to manage their finances," Jessica says. "I can't afford to have my colleagues know that I do this." And why …

Greetings, Google does not directly support xml results any longer, and I've attempted in vain for many hours to parse Yahoo local data into Filemaker XML with XSL. Does anyone know of a solid XML data provider whom I can querry with business names and get reasonable XML address, phone, etc results? Has anyone had any luck trying to parse the Yahoo local results (I get one error after another from their XML results).

I've recently been given an insight into using stylesheets and using a stylesheet that works perfectly have tried to replicate it against another XML file but I'm now getting x2 scenarios. Scenario1: When importing the Version 1 files into FP I get this error message, Expected ,,but found: id pattern = 'count(deletions/deleted id)' (ServerFolderDeletions1.xsl,17,53) Remaining tokens: ('id'')') I think this message has been caused by a space in the field "deleted id". However, after doing a find and replace on these I now get, Scenario2: When importing the Version 2 files the import proceeds as normal but no records are imported. Import Summa…

Hi all I haven't any notion on XML I have an Excel file that shows a column of cells with formatted text ( Superscript and Subscript ). When I open ( convert ) that file with FileMaker, that format is loosed. So I saved that file ( from Excel ) to XML; the XML mantains the information about Superscript and Subscript. How can I import that file ? I need a xsl ? This is an example of part of XML: xmlns="http://www.w3.org/TR/REC-html40">SrAl3[(PO4)(SO4)](OH)6 ss:Name="Print_Area"/>

Like most enquiries in this forum I'm very new to XML/XSLT etc. I've read through most of the recent topics regarding XML importing but can't locate any that covers my problem. I'm getting a third-party XML (web shopping basket order)which includes data from 2 tables (e.g. Order Details & Order Items). I know that I will have to create 2 XSLT files for each part of the XML file. My problem is that I don't fully understand how I create the XSLT to cater for XML file the way it has been supplied. Anyone out there who may be able to help? I've added an example XML file based on the data I'm likely to get Orders.zip

Is there a way to import data from an XML file by using an XSLT sheet that is imbedded in the FileMaker solution? The normal way to write such a script step is - (1) select an external XML file with the data; (2) select an external XSL file that tells FM how to interpret the XML file. I would like to avoid using a text file separate from the solution, so that the whole solution, including the XSL, is in one file. In the Script step "Import Records", under “Specify XML and XSL Options”, you may specify a Calculation instead of a file. I have tried to make this calculation - (1) a text field that contains the XSL text (2) a container field…

I have built an xsl style sheet to import the following xml data. The import completes without any errors but I get zero records imported. I think the problem has to do with the fact that I am trying to extract multiple data points from 1 XML element . I may get multiple elements but I will still need to extract multiple data points from each element. This is my first time trying to understand XML and I think I am missing something simple. Any help would be greatly appreciated. Thank you in advance. XML I'm trying to import ------------------------------ <?xml version="1.0" standalone="yes" ?> -----------------------------…

Hi Guys, I'm trying to set up a website using FMSA 8 and CWP. I used to work with SQL&PHP which was in my opinion a straightforward combination. Now i'm a little lost. The Website should roughly look like that: It has a login area and main page, working with frames etc... It should also include data representation of our FileMaker database/s. I'm stuck at the login. I can manage to code a login with php&sql. But through CWP it seems to be pretty hard. The only way i could think of to archieve this goal is through an xml-parser extension for the php-module. Correct me if i'm wrong: I need a login.html and for example a verify.php file. The login.html contain…

Hello everyone, I have no idea about XML / XSL, but am using EZXSLT to create a report in Word format, and it all works ok. However, I need to somehow include the contents of a global container field in the export, to be placed at the top of the formatted Word doc. I realise of course that it is not possible to export a container field in the same way as other fields, but is there a way of exporting the field contents to a specific path, recording the path in a script variable and then inserting that path into the output in some way? Perhaps if I pre-define the path it could be written into the XSLT stylesheet? I've no idea if what I'm asking is even …

Hello all, For added security, I would like to use the "$client-user-name" and "$client-password" in a static query command. Everything else I add to this works but not the client user name and client password. Here's an example of what I want to do: <?xslt-cwp-query params="-grammar=fmresultset&-db=DATABASENAME&-lay=LAYOUTNAME&USERNAME=&PASSWORD=&-find"?> Where USERNAME and PASSWORD are bonafide Filemaker fields holding their login data. I have these defined: I'm guessing that the replacements aren't being filled in since the page WITH this static query shows empty fields... Can anyone help?

I'm working with InDesigns tags function to setup a filemaker xml import. While InDesign states that it can deal easily with a tree structure (by importing the root tag) it seems to choke on Filemakers raw xml. It imports the tags fine but when importing the actual xml data it gets confused by the tree structure. I manually removed all xml except that nested within the row tag (excepting of course the necessary xml headers) and InDesign was able to load and make use of the xml tags easily. I've been playing with my own xsl but am having difficulty getting a simple xsl to just display the xml encased in 1 row. Somebody must have done this! Any samples out there?

I have a IWP solution for a registration system. I am using a CWP page to just show the final registration. The user authenticates using the IWP solution. When they click on the link to bring up their registration via a CWP page, it asks again for their username and password. I know I can include a the "Get(AccountName)" in the url, but I do not know how to use the password too. I know that might not be the best since logins like that are sent in the clear. Is there a way to use a session code between the two solutions so I am not passing the username/password in the clear? Thanks! -clm

I have an XML/XSLT Solution, I am using the summaryreport.lsx from the FMSA Assistant. I am able to edit the file up and do some things with it. I am showing on the lower part of the page all participants for the conference, but I want the top part of the page to just show the school name ONLY ONCE. How do I get the XLM not to keep repeatign the school name (it wants to show the school name as many times as there is records). Here is the code i have: Any ideas? Edited: Sorry, wanted to add more: I think I need to change somethign around the line: Thanks! -clm

I currently run FM unltd 5.5 for custom web publishing using CDML. I bought FM Serv.7 Adv. but was so intimidated by the XSLT stuff I never deployed it. Besides a pro told me it had security and stability problems. On his advice I upgraded to ServerAdv 8. I am a psych prof, not an IT person, and my solutions are generally simple, but not simple enough for instant web publishing. Should I go the XSLT route or the PHP route to create my web interfaces?

I want to find a good source for importing currency rates into filemaker. XE ... Oanda ... great services for currency rates of course but ... Not free. Bank sources don't seem quite up to it. (dodgy commas, not enough currencies, wrong format, etc...) Anyone know how to find out where the BUILT IN CALCULATOR IN OSX gets its currency data. Its free and i hope its XML ... but i have not got the first idea how to find the source. Sorry if this is too off topic.

OK all. was doing REALLY well with CDML tags. I have moved a registration system for student conferences from 5.5 to 8. I need to create one CWP page that displays the ENTIRE list of students and the events they are registered in. The IWP WILL NOT display more than 25 results. We need a "clean" view of the registration which includes a portal record. Basically, I want to show: School Name Participant Name Portal Records: Event Registered Participant Name Portal Records: Event Registered Does this make sense? I just need to see an example on how to make the XML tags! Thanks, -clm

Hi Has anyone any ideas as to the best way to include an existing XML file into a parent XML file? I'm not sure which is the best way to achieve this with FileMaker after looking at xsl:import, xsl:include, xi:include, defining an entity, etc!! What I'm trying to achieve is to run one script in FileMaker that generates an XML file (parent.xml) that inserts the content of existing xml file/s (child.xml) into the final document. The structure needs to be something along the lines of... One Two Three *Child data elements need to be inserted from existing file child.xml* One Two Three I've got FileMaker and xsl producing the req…

Hi, I'm very new to Filemaker and have no idea, if what I want to do it even possible, but I thought maybe someone here can help me -) I want to export a filemaker database into an XML file and then use the XML to import information into a Flash file. Some of the text is bold or in italics. How can I make sure the the formatting will be passed on to the XML file and then to the flash file? Thanks Julie

I'm just starting to write XSLT and I can't seem to be able to call a FM script from the XSLT code. Can someone give me an example of how to use the xslt query, please? Say the FM script is called AuthenticateMe and the script steps all have full rights... With thanks

I know that this topic has been covered already in some aspects, but reading through the answers and looking at the test files, I'm not sure that my exact question has been answered. I have a website in which a user creates/updates a comment and then submits it. Under Filemaker Pro 6 Unlimited, a script is run which checks to see whether or not an email must be sent. If the answer is yes, then a Send Mail step is executed in FMP. In XSLT, it looks like I would want to have the Send Mail template always called (as the action from the submission of the comment), but only have the Send Mail portion done if a test shows it is needed. Does this make sense??? A…

I want something like this: <?xslt-cwp-query param="name=$client-user-name&-find"?> Is this possible? Thanks.

I'm trying to develop some web applications using FileMaker as the back-end. I've tried both ODBC and CWP XML API FileMaker provides, however, both of them are too CPU intensive. A single query chews up 25% - 35% of the CPU for a second making it unusable in a live web site. As such, I'm trying to come up with a different solution that will allow me to get real-time data from FileMaker to display on the product pages w/o having to query FM Server / Web Publishing Engine every single time. The only thing I've been able to come up with is to generate an RSS feed (or any static XML file really) that would act as my data source for pulling data. I could simply pa…

G'day, I am setting up my database to process credit cards using XML SOAP. When I submit the transaction, I get a response back that looks like the following (which goes into a field). Is there an easy way to reference the values here to get them into fields? In particular, I probably need to isolate the values for Authorization_Num, Error_Number, Error_Description, Transaction_Error, Transaction_Approved, Bank_Resp_Code, Bank_Message, etc. Server: Microsoft-IIS/6.0 Connection: close X-Aspnet-Version: 1.1.4322 Date: Mon, 25 Sep 2006 22:49:32 GMT Cache-Control: private, max-age=0 Content-Length: 3565 X-Powered-By: ASP.NET Content-Type: text/xml; …

I calculate URLs to video streams within FM, but when I try to display them via XSL (only in a portal, it seems), the encoding is incorrect and the page tries another db query rather than linking to the calculated URL. When I view source in the returned page the URL reference is corrctly formed but the browser goes back to the db server rather than the calculated link. I read in another post about url_encoding but cannot figure out where to put it in my code. The code generated by CDML Converter follows: Thanks for any help!

I asked this one last week but still no joy, so this is a re-post hoping that others might contribute. My attachment is a simple example and, theoretically, should import a container. The test suite is complete with all files. Many thanks in advance XML_Test.zip

Hello all, I'm trying to sort some XML code.. I know < xsl:sort> tag but the circumstances are different and I don't think I can use it. Basically my xml is the result of an xsl transformation. so, I need to sort $myxmlnodeset. Is there any way to do this? Thank you

The help system clearly indicates that a CONTAINER may be specified as an element in an XML import. (although export is not permitted). My XML skills aren't good, but I can read the XML, but just can't see how to specify an image as the required content for the DATA element. Any one know how to do it? Many thanks

I have a password retrieval form in which the user submits his email address and zip code in a form. I'm guessing that because of the @ sign, Filemaker is processing the find as "find one character" as it does in the application interface and unless the user encloses the email address with quotes, the query finds no records. I hate to ask users to enclose their email address in quotes... I've attempted several "fixes" with encoding the main thrust but have run out of ideas. Is this a question of how the field is set up in Filemaker or a matter of encoding on the XSLT end? Do I need to pass this string as a script.paramater and paste into the field? If it's …

Hello all, I would like to pass two strings to a script and can do so with a URL but not with a form. The link that works is: results_test.xsl?-db=mydb&-lay=mylayout&-script=DateRange&-script.param=01/01/2005...01/01/2006&WebID=&Password=&-findFixed Date Search The form that does not work is: results_test.xsl Can this be done using a form? If so, what am I doing wrong here? MORE INFO: The script takes the left-most 10 digits and the right-most 10 digits, parses them and pastes them into two date range search fields which yield a result in a portal. I only have to find one record to di…

Hi All, I have been slogging through Fenton Jones' great tutorial for bringing in ASP xml data into FileMaker. I have hit a wall with the project and wanted to submit my work to see if someone might have a better way for me to reinvent this wheel. So my goal is to pull specific pieces of data from various Apple machines (G3, G4, Intel, etc) from their respective system profile data. To control for the varieties of OS's and ASP builds, all of the machines are booting to 10.4.x volumes. I have built an Automator App to pull only the specific SPDATATYPES into a generic xml file (not the .spx ASP output). So far so good. Using the examples on this board, I have cons…

I had someone write 4 XSLTs based on a sample xml file so that I can import the xml data into filemaker. On my mac the process works perfectly... -Select the XML file the xsl and so on. When I try this on a windowz box I get the following error... Now I'm no xml expert but the XSL was written on a PC and I am told the person whom wrote them tested them on a PC and they parsed fine. What is going on?: Thanks

Hello, Is it possible to script an import from an XML data source? The Import Records script step doesn't seem to have an option to import XML files. Am I missing something? I'm currently using FMP Advanced 8.0v3. Do I need to upgrade to 8.5 Advanced? Regards, Sean

Hi there, I am having trouble matching the contents of a second XML file to be merged with my export via XSLT / FMPXMLRESULT. I have a bunch of records for individual pupils each with a key field (UPN). I then have a separate xml file (in FMPXMLRESULT format) with a list of exclusions - COL[1] of each record contains the UPN key field as a match field with the pupil records. COL[2] of each record contains the data I need to insert (exclusion start date). Each pupil could have none, one or many exclusion records depending on whether or not they have ever been excluded from school. Here is an excerpt of what I have so far: - This seems…

I am using XSLT pages to collect demographics for a user. In one of the selections the user chooses a campus they are associated with from a pull-down menu. Based on their campus selection I want to present them with the departments associated with that campus so that they can choose one. I am not sure how to go about this. The campuses and departments are located in the database files. Any assistance would be greatly appreciated.........Ray

I am trying to import xml-data coming to me in ISO-8859-1 format. I have problem importing files when: - content of a field include i.e. "&". Can not open the file at all - content of fields include Swedish characters "å, ä ,ö". Can open but don't import the characters correct. A file can look like: <?xml version='1.0' encoding='ISO-8859-1'?> 2006-10-26 10:41:46 vartannat lysrör lyser i skärmtaket 1491060 BELYSNINGSSYSTEM (EX, UNDER SKÃRMTAK; ANNAN SS BELYSNING)

Hello, Ok so the webviewer is great and i now find myself wanting to use web data everywhere, but its time to be honest to myself and say that if i want to pull in currency data the best way to do it is with XML and not the webviewer. Problem is i can't get my head around it. I want to import xml data from a bank feed and the European Bank seems the logical choice and yes the FM website has an example ... but its great and useless all at the same time because even though you can get the data you can't change the comma and make fm read the data as a number. So next best thing is the Canadian Bank who have a feed ... but i really dont know where to begin…

file->import records->xml data source...->http request=http://tsesc.com/xmlexport.aspx?type=dtod&date=13850715 error: XML parsing error: Unknown element 'pe' Line Number: 2 help me please.

xsl file contents: <?xml version="1.0" encoding="UTF-8" ?> exclud e-result-prefixes="fmp"> 0 xml http request address: http://www.tsesc.com/xmlexport.aspx?type=dtod&date=13850702 error: XML parsing error: Expected equal sign Line Number: 4 whats wrong? help please.

Hi there, I'll start develop new web site with xslt. But the problem is some data are been outside of the FileMaker. The user enters the product id than i'll get product name (if the product exist) by a sql query. I'll use FileMaker for all other database necessity. Only i have to get product name with sql. Is it possible? Thanks in advance cabi

Hi there, I am pretty new to XML / XSL so apologies if this is a dumb question. I have used an XSL file to output data as XML from FMP8 in fmpxmlresult format. The XSL file I am using is this: - It seems to work ok and produce an output file that looks like this: - Quite simple! I want to format the output using a CSS (or XSL) style sheet which I would normally do by adding the following line to the top of the XML file. <?xml-stylesheet type="text/css" href="housepoints.css"?> But if I include that line in my XSL file, it does not appear in the output (XML) file. Can anyone suggest what I am doing wrong…

Hi, I need some help to import xml in FileMaker. I've the whole content of a book in xml format. The book has six sections: Using a FileMaker provided xsl sheet I can map the different sections to the FileMaker fields (section 1 to 6) and it works great. The problem I have is that each section contains other tags, such as , etc... . When importing the file, FileMaker strips them out automatically, which is bad for me. Am I doing someting wrong? Is there something I missed? Many thanks for your help, Guy

Any idea about how to upload a file using cwp, preferrably to a containerfield, else to a directory on the webserver.

Finally diving into xslt and hoping to learn something... If I have a node like this: Stormy Monday Smoke on the Water Blue Monk and there will never be more than one tune of each type of genre, then what is the most efficient way of extracting the jazz element? I am using this code: So, the result is "Blue Monk" But, it seems to me that there is probably a much more efficient way of getting this same result. Any suggestions?

record_detail.xsl Search id:

Cannot find declaration of element problem I seem to be having a problem working with and importing a xml file. I believe it has to do with the beginning 2nd line. It seem to be goofing up FMP XML imports. <?xml version="1.0" encoding="UTF-8"?> ......and lots more xml........ with this file in Exchanger xml I get a "Cannot find declaration of element 'GetCategoriesResponse' " When I remove the "xmlns="urn:ebay:apis:eBLBaseComponents" and use it as such <?xml version="1.0" encoding="UTF-8"?> ......and lots more xml........ my fmp xml stylesheets work as expected. My question am I doing something wrong and I…

Hello all, I need to create a PDF with Filemaker web publishing engine and I need some help. I know that I must use FOP ( objects in xslt stylesheet) 1. Do i need to install a FOP engine on my machine or do Tomcat provide it? 2. Where could I find an easy tutorial? (I'm a beginner with this kind of transfromation). 3. have you some example to share with me? Thank you in advance!

Hi, from sunny Costa Rica in Central America, I need to create a hyperlink using xsl based a fmp database 8.0... I need some help about these theme... Thks a lot Alejandro Barquero Proyecto Nautylus A.B. S.A.

Hi from sunny Costa Rica! I need to put into groups some information like a name of group, inside subname of group, and finally a subname description.. Thks for your help! Alejandro Barquero

This is not exactly an XML/XSLT question but it is what I am using. Is there a straight-forward way to create a form to do a range search such as "start date" and "begin date" or "greater than X" and "less than Y"?

[color:gray]How can I use fmxslt:session_encode_url() to encode form data. The documentation and the site assistant shows how to do this for URLs but there is no information on encoding form data. [color:black]I think I need to clarify this. When using href the query string appears in the browser's address line. When submitting form data, only the page shows, not the query string. How do I get a form's query string to appear in the address line?

Used the FileMaker Site Assistant, I created a web site which gives you the typical files (home.xsl, recordlist.xsl, browserecord.xsl, etc). I want to modify the home.xsl file so that beside taking you to the findrecords.xsl and recordlist.xsl it will also display all new records added in the last 30 days (it is a stock catalog). I have added all the I would like the home.xsl to display all the records in the table where a field is NOT blank, but I can't get it to perform that function. Not sure what I need to do. Somehow the home.xsl needs to look up the information in the table, and I am guessing, store that in the @fetch and @fetch-size? I wou…

Going from FMP to cXML. cXML output should look like the following for the Header section (file has many sections with similar element:attribute pairs) [color:blue] [color:#FFFFFF]--[color:blue] [color:#FFFFFF]---- [color:blue] [color:#FFFFFF]------[color:blue]007[color:blue] [color:#FFFFFF]----[color:blue] [color:#FFFFFF]--[color:blue] [color:#FFFFFF]--[color:blue] [color:#FFFFFF]----[color:blue] [color:#FFFFFF]------[color:blue]1463[color:blue] [color:#FFFFFF]----[color:blue] [color:#FFFFFF]--[color:blue] [color:#FFFFFF]--[color:blue] [color:#FFFFFF]----[color:blue] [color:#FFFFFF]------[color:blue]9647[color:blue] [color:#FFFFFF]-----…

Hi, I would like to import 2 records of data from a XML file but each record has 2 subsections (each subsection has different fields and each has a different number of subrecords (please see the example below)). Can someone please explain how to stucture the XSLT file to import 100+ records and not the first 2 records with only the 1st data item of each subsection. eg. Record 1: "name": A Subsection 1: "code" a1, "seq" a11, etc "code" a2, "seq" a21, etc "code" a3, "seq" a33, etc Subsection 2: "size" aa2, etc "size" aa3, etc Record 2: "name": B Subsection 1: "code" …

Hi Everyone, I was just writing a little Database for a book archiv. I want to import all the info on a book from the isbn-database at http//isbndb.com I am using the import script to send out a query but I always get the following error message: XML-Parsingerror Attibute 'publisher_id' is not declared for element 'PublisherText' Row: 8 Column: 32 A querye example is: 'http://isbndb.com//api/books.xml?access_key=WNCZC8HT&index1=isbn&value1=3110165228' Thank you very much for the help! Sebastian

So I've got to get my FMDB to talk to Ariba via cXML. cXML provides a DTD, but when I try to use that as a stylesheet when exporting my FMDB via fmpdsoresult, the dtd file is unselectable. Do I not use the dtd, but rather craft a stylesheet xsl? which turns the FMDB XML into the required cXML? Do I use the dtd to validate the resultant cXML file? Really not sure what I need to generate the cXML file. TIA, day

I am using HTTP request to Import a RSS feed into my Filemaker 8 database. I'd like to use an automated script to follow the URL in the RSS feed and import that webpage/html into the database as well. This is necessary because the URL links to classified ads which only remain on a site for 7 days, however we want to follow them up 2 weeks later. Is there a method or plugin that allows this? I believe a plugin called HTTP GET did this, but is no longer available. Is this a function of FM8.5? I've read the marketing doco but it isn't clear if this functionality is available. Thanks in advance for advice and help, KIWIPAUL

Some advice on XML imports requested Hi everyone I am a little behind with FMP, I am on 5.5. I wanted to ask if I am understanding correctly that the newer versions of FMP will import XML files and create a data base from them reflecting the parent, child and leaf nodes with the attributes. Is this similar as say when I import a excel spread sheet type import. From my reading so far it looks like I have to set up a style sheet to map the incoming data to. Tips or advice as to should I upgrade to FMP 6,7 or 8 or I am just understanding wrong. I am just learning XML so I may not be explaining this totally correct, please bear with me. Thanks …

I want to display a 'global' on a web page, but since creating 'globals' in a FP database changes with each user, I created a separate table and created a 'constant' link between the two tables to (in essence) create a global. Anyway, I want the Global place on top of a RecordList.xsl web page, but I don't know the syntax to display the reference. The table is called Globals The field is called Field I know, very original -) I should only display once, then under it the list of all the records available. So, I will put this in my recordlist.xsl template I have tried (without success) the following Didn't work. I…

I am trying to make a xslt stylesheet to import xml data where the amount of data is different each time. Data for a Filemaker field can be 0 -> unlimited times in different xml files. Ex 1) data1 data3 Ex 2) data data1 data2 Anyone have a hint how to do?

I have a database of Courses that I want people to register on the web. Using the FileMaker Pro Site Assistant, I created the XSLT templates and then modified them to create our 'look'. All is good so far. The courses have a status. Either Open or Closed. What I want, is when people choose Show All Courses, the list should only show those courses that are Open. So, I am looking at a way of doing this (showing all courses that are open, and NEVER showing courses that are closed). The Show All Records link is a template file from Utilities.xsl, so I know it is in there that I must fiddle -) How would I modify this line if the field is labeled '…

I'm trying to put an email address into a token. The @ keeps converting to its hex code: %40, then every time the token is carried to the next page, the % also converts to its hex code %25, so eventually I end up with %25252540 when it should just be an @. I would like to try inserting the &___; code for it initially to see if that solves the problem, but I can't find it anywhere (I can find the ampersand code for just about everything else but that). Does anyone know it? Or does anyone have any other ideas on how to solve this problem?

I don't know enough about xsl to figure this out, just enough to know how to mess things up. I am working on a Registration database. I have a page that will display the Courses (Recordlist.xsl) I have a page that will display the detail of the course (Browserecord.xsl) The link that takes you from the RecordList.xsl to the BrowseRecord.xsl displays the recordid just fine. I want to now go from the BrowseRecord.xsl to an AddRecord.xsl so a user can Register themselves for the course, but the code I am using doesn't work, and I don't know why. Register for this Event and the Utilities.xsl code looks like this: …

Hi, I've been experiencing what seems to be erratic behavior using XML urls to get data from a FM database using FileMaker Server 8 Advanced. While a url like this (formatted here for readability) returns some records: http://account:[email protected]:80/fmi/xml/FMPXMLRESULT.xml.? -db=database.fp7& -lay=layout1& fieldTwo=xyz& -find If I replace it with something like this below, it no longer finds any records, even though fieldOne is a text field containing 1, for every record in the database, and it's present on the layout, and it's also from the same table as the layout context table. (Also, I can see this field in the results of…

I am using XML/XSLT with FileMaker Server 7 Advanced and occasionally during testing I'm getting the error page showing: "An unexpected error has occurred" File: /fmi/xml/fmresultset.xml Line: Column: If I wait a minute and try again I don't get the error. It will occur later as I continue testing. It is inconsistent. Any idea what is going on here?

I recently started learning XML/XSLT. The FileMaker documentation is very unclear about where to place non-xslt content (images, html files, javascript libraries)on the server so it can be referenced by xsl template files. Sorry if this is vague. I thought I should start simple and then elaborate as necessary. An answer to this question is needed urgently. Also if anyone knows of any great resources for learning about FileMaker and XML/XSLT together I would appreciate it. -Thanks

Hi all, I'm fairly far along in an XSL based Web solution using FMPSA8, but there's ONE thing I just don't get. I have a place where the user is assigning a value to a related table which is then supposed to update the current layout. In FMP it works perfectly. On the web, it changes the data, but the page doesn't refresh. I know this is something simple (If I only understood the XSL/XML as well as I understood straight FMP!) but how do I force a refresh when going back? Or maybe I'm going about this the wrong way... Can I recall the previously found set from another table-occurance after assigning the value I'm assigning in a related table? Sorry if this m…

FileMaker 6.0v4 Windows XP sp2 Please note that Quantech needs a solution to this problem ASAP and is prepared to pay if you have a viable one. I have a Filemaker 6 solution that imports and exports XML files and applies an XSLT to them. This works perfectly in a single-user standalone version, in a single user bound solution and in a multi-user Host version. It fails, for a number of reasons which I'll explain below, in Guests and Clients. The folder structure for the standalone and hosts is: All the Filemaker fp5 files go here: C:Program FilesQuantechQuantechV6 The various XSLT scripts live here: C:Program FilesQuantechQuantechV6…

I am using server advanced and I am getting a variety of erratic errors. Some do not make sense. For example on a search page I get the following error in Firefox but not in IE: An unexpected error has occurred File: Line: Column: Here is an error that appears sometimes but not others in Firefox or IE: The resource http://XXX.EDU&-find could not be loaded because the content-type was invalid (MCS-605) File: start.xsl Line: 85 Column: 300 Line 85 uses the document() function. I thought the problem was occuring because I was on a dual processor server but now I have a new machine with 1 processor. What could be happe…

Hi everyone, How can I get raw xml from FileMaker Pro 8.5 or FileMaker Pro 8.5 Avanced using the web http Instant Web Publishing interface? Thank you, Ronnie Serr

G'day! I'm trying to build credit card processing into my database. I'm starting out with the bank's testing environment and I'm using the demo file included with the Plug-in. I've entered the URL: https://secure2.e-xact.com/vplug-in/transaction/rpc-enc/service.asmx I've selected "POST" and put the following in the "Extra data to send" field... POST /vplug-in/transaction/rpc-enc/service.asmx HTTP/1.1 Host: secure2.e-xact.com Content-Type: text/xml; charset="utf-8" Content-Length: 2813 SOAPAction: "http://secure2.e-xact.com/vplug-in/transaction/rpc-enc/SendAndCommit" <?xml version="1.0" encoding="utf-8"?> xmlns:xsi="http://www.w3.org…

I have a CWP solution that allows users to edit a "page". Users would like to be able to make certain words within a section of text bold, italic, etc. (like what I could do right now using this forum). What is the best/simplest way to provide that functionality? (I wouldn't mind requiring users to know HTML if they wanted to take advantage of the feature - so an web-based editor is not required... just understanding what encoding is needed for this to work I think)

Hi, I'm new to xml/xsl. I'm running FMSA 7 and have my databases ready, and already using some simple custom web publishing pages. (I got that far!) However now I just want to be able to make a simple edit function. I can't find any examples of a simple xsl file and I'm having trouble getting my head around the custom web publising guide from Filemaker. Could someone please help!? More specifically below. I would like to find a record with a field "JobNumber" and edit the contents of its field "ClientName" Any help would be appreciated. Wayne.

Hi Folks, I am a beginner of XSLT and I am working on a function to export a MS excel file by XSLT from FMP 8. My report format in filemaker contains sub-summary (sort by a category field), body, and trailing summary. I have a summary field placed on both sub-summary and trailing grand summary, I have already figured out how to do the sub-summary in XSLT, however, I still don't know how to do the trailing grand summary. Actually, I do not want to export a static summary number, I want the XSLT would pass a formula to Excel to do the grand summary there. Any ideas will be much apprecidated! Thanks, Jarvis

How difficult is it to allow a user to download a PDF report from an XSL web based FileMaker Pro database? I have a web site created with XSL on our FileMaker Pro 8 Server Advanced (8.0v4). I would like to give the user the capability of creating a Stock Requisition on the web, but the printout wouldn't look that good. I would rather the report generate a PDF version for the user to download and print. Possible without purchasing additional modules?

This field works withing filemaker but when I export the database to an xsl format the field just remains empty. The only way I have been able to get the date to show up is by setting the field to "modification date" which creates a problem when someone goes to edit the record. Anyone know how to fix this problem?

I would like to format a field on my web page as currency. How is this done in xsl?

We have lists that are sorted, nothing strange. Works perfectly on the test server. But on the "real" server it the sort function works at times, but at times it does not. The records displayed are correct, but not sorted. (i.e. yesterday afternoon). This morning it worked perfectly, but now the lists are not sorted. Any suggestion about where to search. FM server? FMSA console?

I have one more issue to resolve. I'm not receiving email from the website; there are no error messages -- the email just never arrives. The code in question is below and the website is now live at http://www.motorwarehouse.net. To execute this code, you need to go to the Engine Kits link and purchase a kit. Once you have completed the checkout, the email SHOULD be sent to you, the customer as well as me. Thanks in advance for your help. ...

Hello, I really don't know if this is even possible, but I thought I'd ask. I have an XSLT page in which a user enters an ID number and selects a checkbox for an available time slot. When the user hits the submit button, the page runs a javascript to make sure the user has entered an ID number and selected a time. However, I want to be able to verify that 1. the time slot selected is available (meaning I want to see if the FMP field is empty), and 2. I want to verify that the user ID matches the value of another FMP field. I have no idea how I can get a FMP field value within a Javascript. Is this possible? Thanks for your help! Tom

Hi, i'm trying to modify the keypress buffer using javascript of an xsl generated value list from filemaker. I have the script in the head, but I can't figure out how to trigger it in the select statement. I've included my code below. requestor() Select One requestor Select One I think i just have the script being called in the wrong place. Getting source on the final generated page doesn't even have mention of the function call. Any help would be greatly appreciated. Thanks!

Hi, Couple of problems I'd like ideas and suggestions for please... Firstly... I've got an XSL styleheet that imports xml data in the FMPDSORESULT format into FMPXMLRESULT and sucessfully create records in a FileMaker database. I'd like to know how to change data elements using xslt before they get to FileMaker. I have a date formatted in the xml doc as yyyy-mm-dd. This is obviously not going to play well with FileMaker's default dd/mm/yyyy format. How can I change the format of the data using my stylesheet so that it swaps things round and inserts the /'s? Secondly, how can I get xsl to check and ignore any duplicate records? All records have a uniqu…

At the end of my rope here In an XSLT style sheet to format text with a specific font when creating an RTF document- Using this language to create a formatting command: RTFcodeFontname "> and as the formatting command: &RTFcodeFontname; ...what would I use as the "RTFcode" for an RTF formatting code? I've been able to use this language structure to format everything from size to line spacing to color, but I cannot find an example where it is dictated how to format text as a specific font. Thanks!

Hi, I have spent a lot of time today trolling the forum for the best way to attack this project - without any clear idea how to start. I am trying to pull data out of the Apple System Profiler xml file, specificallly, just the hardware info and import into a single record in filemaker. I think I'd like to script it, as the XML structure will be the same accross all machines (all have same OS version). I've been trying to constuct an XSLT from looking at the Profiler XML data, but I am having troulbe with the nested nature of the data. I'll be pulling in say, 20 attributes (machine name, HD model, memory, etc. etc.) I am hoping this makes sense and I am lookin…

From Filemaker XSLT Library you can download the examle files for "XML Import One To Many" by Marcel De Maria. "This example shows how to import data into a portal. Using two separate imports from the xml document and using two separate style sheets". http://www.filemaker.com/products/technologies/xslt_library.html What I want is also to do the reverse: Export a record and its multiple portal rows I can export with FMPXMLRESULT and get a record and its multiple portal rows in one xml file but I need a XSLT that can produce an xml file like the "VData.xml" in Marcel's example: "XML Import One2Many". The point is that I want to mail one record and its many re…

Hi there, I am programming a online payment script for my filemaker database. The way I did it is to export the xml and the html in an on the fly file that need to be opened and submited. (it create a simple form with all the info needed then the user need to click submit on the page and it comes back with the info if it get ok or declined). So I am at the point that the file is created allright trought the xml export but when the script open url kicks in the file doesn't open. If I go in the system and click myself the html fle created it works fine. I realized that I cannot open any local .html file trought the open url script in filemaker. Iknow it's far fr…

Hi I've been having a bash with XML and getting data into FM 8.5 and it's been going OK so far. In brief I've got a URL that returns xml data into a web browser and I can save the file to my desktop, use FM and an xsl stylesheet to import the various elements into new records and fields, everything works fine doing it this way. However, when I try and attempt the logical extension of this rather long winded process by using the http and xsl options available from the import script step I get an error as follows: XML Parsing Error An exeption occured NetAccessorException, Message could not connect to the socketfor URL '{0}' Error=1 Line Number: 0 Colum…

I am in the process of constructing a WebSite using FileMaker 8 and XSLT. I need to export two different .txt files based upon the result of the XSLT output. The .txt files will then be passed onto another Mac for processing into an InDesign document (this is done using AppleScript and a third-party program). If I use then all I get is a textfile which can be downloaded. I need to have the textfile placed in a folder on the Web Server for further processing. If I could call the export script step then I am sure I could figure out a way of doing this, but unfortunately this is not possible using CWP. Is there any way that this can be done? Any help or…

hi. i have a database of countries with several fields. the first field is the countryname field followed by fields about that country. i have a script that exports the selected file or all files to xml with xsl template with an html output. it works fine. however what i want it to be able to export each country with it's own html output page and not all countries printed on one html page! what i do now is to find each country then run the script but it takes a lot of time since i have too many countries on the database. anyone has an idea about how to output each in its proper html page possibly named with the country? the script now looks like this: Perform Fin…

Some may have noticed in the ReadMe of the FMSA 8.0v4 updater that the Xalan-Java XSLT processor was updated to version 2.7.0 (from version 2.4) I have written a demo that shows the use of EXSLT extensions functions with XML/XSLT CWP. See attachment. As always, my demos are quick and dirty (no fancy styling of database and XSLT files). Feel free to try it out. test_exslt.zip

I am new to xml importing: I have a whole bunch of data that is in the following format: <?xml version="1.0" encoding="UTF-8"?> This song This guy And I used a filemaker xsl stylesheet that matches the fields but enters no data. The trouble lies in that the data I have has no designation. So in the xsl - I delete a foreach in the first segment that now connects the fields but enters no data. I am sure there is an easy solution to help me - so if an expert could take a few seconds and point out the error - I would really appreciate it. here is the xsl: <?xml version="1.0" encoding="UTF-8"?> 0 …

Hi, I am having difficuties with import number and date field data. So, I read all data in text fields and parse them with a FM-field, but there should be a better method I think. For instance, I get 200.25 in a xml field. However, in filemaker 200,25 is needed to correctly recognised as number, but using the same stylesheet in US should work correctly. The same for a date field in xml. I get 20060616 this a date, but I need something like 16-06-2006, but in US this would be 06-16-2006. How do I tackle these problems in general ?

After reading the Custom Web Publishing Guide and all the old threads here on send_email and using concat to embed a field reference, I'm still getting an error message. I'd love some advice: code: ... error message: java.lang.NoSuchMethodException: For extension function, could not find method com.fmi.xslt.ExtensionFunctions.send_email([ExpressionContext,] #STRING). Checked both static and instance methods. (XSLT) I did read in one thread something about an additional template needed, but I didn't understand the logic or if it applied in my case. Currently, this send_email function is at the end of a form that uses a hidde…

I have a field that is a company's website, and I'm trying to figure out how to write XSLT code to turn it into a hyperlink. For example: This shows the web address as text and a URL, but the URL is http://mysite.com/fmi/xsl/browserecord.xsl/www.mylinkedsite.com Of course, I just want the URL to be http://www.mylinkedsite.com, but I can't seem to make it do that.

Wondering if someone can help... I'm trying to pass a token through a few steps using the site assistant's built pages. I can pass it through the first time fine. What is the syntax to pass the value of the token once it has a value? Example: The first pass through the template: browserecord.xsl? -lay=WebProjectSingle& -recid= &-token.0= &-find=-find This works fine. Now the second pass: editevntlist.xsl? -lay=WebEvntlist& -recid= &-token.0= &-find=-find Obviously my syntax in the bottom example is wrong. I just…

I have imported data into my database though XML and the data shows on client but when I go to IWP the data does not show in the database. I have IWP turned on for data sharing. Does anyone know why the data imported by XML would not be visable though IWP but is on client? Thanks, Scott

How to write XSL if the XML using attribute, for example: Tove Jani Thanks a lot in advance.

I posted 3 problems the day before yesterday. Yesterday, I posted an update with one problem solved and another larger in scope. Now, I'm posting another update and an urgent plea for help: 1) I found a way to resolve this issue. 2) Since my original post, problem #2 seemed to grow in scope. However, I've resolved the additional, seemingly related, issues. Now I'm back to my original unresolved issue below: I have an often-used xsl:choose command that compares a field with a text string that doesn't work and I can't see why. A similar comparison between a token and a text string works just fine as did the comparison between the field and the text string in …

I posted 3 problems yesterday. Here's an update: 1) I found a way to resolve this issue. 2) I have an often-used xsl:choose command that compares a field with a text string that doesn't work and I can't see why. A similar comparison between a token and a text string works just fine as did the comparison between the field and the text string in CDML. ... KitKitPart Number Since my original post yesterday, problem #2 is growing in scope. It turns out that anytime I try to use a field reference for anything other than viewing the field, it doesn't work. Such as the two below: setting a token to the value of a field doesn't work and setting a field in a …

Hi, just trying to substitute out all the XML reserved characters but i'm having a really hard time doing it. There seem to be more than what is stated (e.g. ' vs ‘ vs ’ and different types of quotes etc.) Anyone know of a really long custom function that will make my field contents absolutley xml safe (or alternatively some way to specify to ignore these characters through xslt?). Any direction regarding this would be much appreciated. Cheers, ~Genx