XML/XSL

With CDML i used [fmp-field:field1, format] to format a number. Now how can i do? I tryed to use FileMaker CDML Converter but nothing... Help me! Ciao

First I would like to thank Jerry (Quintech) for his help in the other forum with this issue, he re-directed me here. I actually just had a breakthrough in being able to import weather XML data into Filemaker during an import. The XML link I used to get the live data is http://weather.gov/data/current_obs/KOWD.xml I have also attached the XSLT that I used to do this to translate into the correct grammar for Filemaker (I think that's what it's doing, I'm still new to XML/XLST). I just want to make sure that is a logical way of doing this. I think the next task for me is going to be writing a script to auto-import this data into the appropriate fields for whenever a new r…

I converted some cdml files with filemakers convert cdml to xsl. On my web-page I have a textarea to type words into and beside that another textarea field then a submit and clear button below. A person goes to the site, enters some words in the first textarea, then selects submit. When submit is selected I want to have the info which was entered placed in my database and perfom a script. Then my database makes calculations etc. on this and places the ending results in another global field in my db. I then want to bring my results back to my page and place them in the second textarea. Should I be able to use the converted cdml file with the forms as is? Am …

Can anyone help? I want to use XSLT to perform a "find" request followed by a "new" request (conditional upon the find request returning zero records - error 401) all via one button click by the user. The user will submit about 10 fields but I only want to perform the find on one of those fields. If the find request returns zero records then I want to create a new record using all 10 of the fields originally submitted. Hope that makes sense!

I'm trying to export my Filemaker data to endicia using an XSL stylsheet to XML. It was working find until I tried to add another attribute. I must confess I am almost clueless with XSL - I've just been trying to plod through it. I've been trying for 30 minutes to post the code but the browser just interprets it and shows nothing so I've attached the question and code in a text file. I'm sure it is an easy fix for you guys. Please take a look at it. Thanks, Carey

Hi, I am currently working on a library database to catalogue and track loans for books and cds. A great time-saving feature for adding new records would be the option of searching the Amazon web services database for matching records based on the ISBN or UPC of the item then importing the relevant data into the library database. I've had a look on the Amazon Web Services website, which is very technical for an XML novice like me. I've also tried out the sample database from this address: xslt library but it doesn't work (I updated the Amazon associates id and the stylesheet location as appropriate). That file seems to be a few years old so perhaps the format i…

Hi all I have almost successfully moved my CDML pages to XSL, but I am still unable to get paragraph breaks in my fields. Do I have to use a substitute calculation or can I do it directly in the XSL page. Any clues would be greatly appreciated. TIA Stephen

Is it possible to pass a -script parameter directly from an XSLT query? In other words, when using the '-script' in a query, is it possible to include a parameter which can then be used in the script by invoking the 'Get( ScriptParameter )' function? Thanks for the help, Adrien

We have a customer who has to log into their corporate site in order to get to a link that will bring them to our website. Since they are already logged into their corporate site we do not need them to log into our website when they get there (they are already a secure user). So we are looking to include the username and password into the link they will click on to get to our website. Is there any way to include those parameters into a link or a way to turn off authentication all together? The catch is when logging into the database through filemaker we still want the authentication to appear for our developers and employees. So we can't just open the database with a…

On some of our web sites it prompts us to log into the database (which is normal) for the first link that hits the database. later in the site, seems to happen after a search which returns a container and some data, the prompt will appear again. Any thoughts on why this is happening? Thanks, Nick

I'm not new to FMPro, but new to XSLT. I've used the FM Site Assistant to get me started on just showing the information. I understand how to go in and edit the information a bit and how to change how it's displayed. But then I wanted to pull the formatting from FM like the IWP does. I read a bit and found this in fmsa7_custom_web_guide.pdf "You can incorporate a FileMaker database

This one is driving me batty. I'm trying to transform Amazon's AWS XML into FileMaker's FMPXMLRESULT. The transformation is happening successfully -- everything looks perfect in Oxygen -- but FileMaker seems to be pulling Amazon's root xmlns into its node, thus throwing a validation error when trying to import (see picture here: Import Error). Here's an example of the XML: <?xml version="1.0" encoding="UTF-8"?> <ListLookupResponse xmlns="http://webservices.amazon.com/AWSECommerceService/2005-03-23"> <OperationRequest> <HTTPHeaders> <Header Name="UserAgent" Value="Mozilla/5.0 (Macintosh; U; PPC Mac O…

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

Is three an easy way to get started on requests to connect filemaker pro 7 to the USPS webtools?

I am stumped on this one. A very simple solution. I just want to be able to add new records to a very simple database. I have attached the XSL Templates. Why can I NOT add new records. Everything 'seems' to work, except no new records are added. I have set the Accounts and Privileges for the Guest account to [Data Entry Only], which should allow Guest to Create New Records. volunteers.zip

Not Displaying. Here is some back ground....Using a 6-file database converted from 6.0 to 7.0 (files NOT merged into 1-table in 7.0). The database works fine after some post conversion mods. I converted the CDML using FM's conversion program and have been making needed post conversion modifications as req'd. On one particular page (Registration) I have a number of pull-down menus to select pertinent registration data from. All of the fields that use Value-Lists with custom values work fine. The one that uses Values-From a-Field in a different file (table) does not work. I have substituted custom values for this field and they work fine. The CDML worked OK when …

Hello, I posted my xsl sheet and it opens great However I would like to change the page color, fonts, insert a jpeg (eye candy) into the xsl. Can someone tell me how to customize the page a bit? I tried using dreamweaver but it corrupts the document Thanks in advance, Don

For anyone that's interested, here is a simple xsl file that uses server-side sessions. No database is needed for it to work. I made it while I was learning how to use them. Feel free to take and use for your own purposes. session_demo.zip

I have an addiction. It's Halo 2 on xbox live. I'd like to pull the XML feed of my game stats from bungie.net I go to open file, I select "show: XML sourc..." and paste in my xml feed (http://www.bungie.net/stats/halo2rss.ashx?i=366142&k=559558504) It works fine as a 'live bookmark' in firefox. Then the dialog box always comes up "parsing error...unkown element:'description'...Line: ## Row: ##" I have access to both FM 6 and 7 (i'm at work right now - slow day) currently on Jag, but we have a couple computers on panther. I've searched around on a few different web sites, looking for help, but I didn't have any luck. any help would be app…

I'm up against a time crunch and I need to show the client the basic concept. I've decided to modify the complex_table.xsl that comes with FMP. I've already made some changes but need help with the following: One of the fields need to be displayed as a huperlink, ie: a href="http://server/clientb/georgesresume">Got to Resume< I need to know what the code is and where does it go. I have found the following but don't where it goes. xsl:for-each select="urls/url" br/ xsl:element name="a" xsl:attribute name="href" xsl:value-of select="@address" /xsl:attribute> xsl:value-of select="@desc" /xsl:element /xsl:for-each TIA, Mark

Hi, How can i change date format for inputs in forms into d/M/yyyy form? Thanks Adam Djuby

Ok, I have now come to grips that CDML is dead. FINE! Now what? All of my solutions are built for 6 Unlimited, which you can't buy anywhere anymore. So, if i want to roll out this solution to any new clients, I'm up the creek. So, I guess its time to learn the new technology. Basically, I'm using JavaSctipt enabled HTML pages with CDML tags to submit, query and modify the database online. The backend of the system seems to work just fine in FMP 7, so I'm not worried there. I just need a new web front end. Is XML/XSLT the way to go here? We're talking some pretty basic CDML tags. Nothing fancy. The JavaScript and the database itself does all the fancy stuff. Any help, a nu…

OK, here's the Skinny. I have created XSLT files using the Filemaker Site Assistant, no problems editing, there's some tricks, but I have those down now for making them look how I want. The issue I'm having is thus: I have a layout in Filemaker. At the top of the record is a header area that contains 4 fields like so: Job Number, Jobs::Job Name, Jobs::Job Ship Method, Jobs::Job Ship Date. (please note, the Jobs::field name references a related field based on the Job Number itself). In the Body there are these fields: Element Number, Element Name, Element Size etc.... in the actual line items from the record area, it has the job name, number etc. How…

I have recently converted my CDML solution to XSLT and am going through and fixing it up. In my CDML solution I had a Javascript to produce a Summary of a found set of records. It is a simple JS that writes a the heading (Summary Field) and data if it is different to the previous record, otherwise just writes the record data. eg Type 1 object 1 object 2 object 3 Type 2 object 4 object 5 object 6 I have redone the script for XSLT, but for some reason when i add the 'esle' part to my script i get nothing - that is the script appears to evaluate (if I view page source), but nothing is written to screen. It works if I only have the 'If' statem…

Hello, Here is the xml that i am pulling into my database: [color:"red"](?xml version="1.0" encoding="UTF-8" ?) - (gesmes:Envelope xmlns:gesmes="http://www.gesmes.org/xml/2002-08-01" xmlns=http://www.ecb.int/vocabulary/2002-08-01/eurofxref) (gesmes:subject>Reference rates(/gesmes:subject) - (gesmes:Sender) (gesmes:name)European Central Bank(/gesmes:name) (/gesmes:Sender) - (Cube) - (Cube time="2005-04-21") (Cube currency="USD" rate="1.3058" /) (Cube currency="JPY" rate="140.27" /) (Cube currency="CYP" rate="0.5822" /) (Cube currency="CZK" rate="30.196" /) (Cube currency="DKK" rate="7.4494" /) (Cube currency="EEK" …

I am passing information in a token that contains a space. for example:(-token.racing=Kodak Racing) When i ouput my token the results are as follows: Kodak+Racing. How would I go about getting rid of the special char? Thanks, Nick

I use server7 advanced with custom web pages. In my databases I use the date format "yyyy-mm-dd", but on my web pages the date is viewed as "mm/dd/yyyy". How can i specify that the date format on the web pages should be "yyyy-mm-dd"? /Henrik

Hi xml guru

I am trying to export some records with and XSL but it only seems to export it to the filemaker program directory and not the actual directory in the export. Any ideas why this is?

I'm relatively new to XML export from FMP, but I'm not able to control well the 0D or 0A characters I insert in the [text] output. When I request 0D;, I'll get the one 0D output as expected. When I request 0A, I'll get 3 characters output (0D-0D-0A). This is causing problems (too many blank lines) when I import the resulting [tagged] text into InDesign CS. [The 0A is important for one section to hold separate lines of a paragraph together as a unit in InDesign.] I'm using WinXP, FMP 6.0v4. With MacX everything works as expected (6.0v4 FMP). [note: when I say 0D or 0A I mean an entity as #x0D or #x0A] Any suggestions?

Has anybody tried the upload of an XML file to FMS7A with subsequent XSL transformation? Which plugin/CGI script/other software is necessary? Has anybody already a working example and is willing to share it here? The XSLT part is clear for me. Or in another context: Has anybody tried to build SOAP services with FMS7A CWP? TIA, Martin

Hi, I recently converted cdml into xslt(cdml converter). It open the page fine in a browser but it does not display the search result on the result page (after clicking "submit" )Is there something I'm missing? p.s I didnt get any errors

I would like to have FileMaker send an email to a specific person when a new record is created (or modified). My code right now looks something like this: -input name="-edit" type="submit"- -xsl:attribute name="value">Save Record -xsl:variable name="send_mail" select="fmxslt:send_email('[email protected][email protected]&subject=Reservation Added','New Reservation Added for:')"/- -/input- What I would like, is to put the Title of the Tradebook after the line "New Reservation Added for:". So, I want to mix the static text with a field submitted and have it emailed. Possible? If so, how? tia

There is a new FMI White Paper on "Extending the functionality of FileMaker Server 7 Advanced Custom Web Publishing with Server-Side Scripting" and two jar-Files (bsf.jar - Apache Bean Scripting Framework, js.jar - Mozilla Rhino JavaScript module in Java) in the Technology section of http://www.filemaker.com/support/whitepapers.html It describes how extension functions in scripting languages like JavaScript can be written for XSLT. These functions are then executed server-side. For further information: There are also chapters on extension functions in XSLT in the books "XSLT - Programmer's Reference" by Michael Kay and "XSLT Cookbook" by Sal Mangano. …

Hi! I'm new to XML but trying out FM Site Assistant and it works OK. Does anyone know the correct syntax for linking a CSS file to a XSL file? Tried both LINK href="mystyle.css" rel="style sheet" type="text/css" and ?xml-stylesheet href="mystyle.css" type="text/css"? without luck. Read on W3C that the latter could be placed anywhere in the prolouge but nope. And I tried putting the CSS file in both the web root and in the xsls-template folder (what is correct?). Regards!

Hi Everyone, Brought a filemaker v. 6 database up to version 7. The v6 file had been served on the web using Custom web publishing with some CDML code. The CDML conversion tool barfed up lots of errors, and it's output wasn't useful. Wondering if anyone can help me with the following CDML form code that I had inside an html file (see attached) This code was contained inside a file called 'index.html.' When a browser requested this page, the form would load in the client browser, then the user would fill it out and click 'submit', which would add a new record to our FM database. I cannot get this to work under CWP in FMP server 7. I have everything installed…

Hi there I have been able to display portals to other tables within my XSLT web published file, the problem I have is displaying portals to tables in another (XSLT published) file. Do I need to add some code? I don't get any errors, nothing displays?? Any help would be appreciated. Thanks

I have a Filemaker 6 CDML solution which I am trying to convert to xsl. Everything goes all right until I come to the page where there is a choice of 3 pages using radio buttons. On the previous page, user has logged in using username & password and this value has been passed to this page ok. The code I am trying to use for the radio buttons is as follows: ........usual header stuff form method="post" xsl:attribute name="action"FMPro xsl:attribute input type="hidden" name="-db" value="mydatabase" input type="hidden" name="-lay" value="mylayout" input type="hidden" name="-recid" value="{$default-record/@record-id}" ............. input type="radi…

A simple question: XSLT / CWP I want to use an image instead of the usual type="submit" button in a form. So instead of... input name="-find" type="submit" value="edit" I want to use... input name="-find" type="image" src="http://www.whatever.com/images/whatever.jpg" At the moment this does not work. Any ideas?

Hi! I try to import xml data into a FM database (laboratory analyses into medical records). As you might imagine, I have several problems... I learned that I have to use a XSL stylesheet to translate XML to filemaker FMPXMLRESULT grammar. I have found some examples for doing so. So far, so good... However, I was unable to find out how to import XML data that uses attributes instead of simple fields, e.g. the following nested (and nasty... ) example: (Test Id="PROBNP" Text="NT-Pro BNP" Unit="ng/l" High="84" Ref="bis 84") (Value Ind="1")1234(/Value) (/Test) I have attached an example file with a complete analysis report. So, my specif…

The Swiss Post Bank delivers Account information in XML format. But FileMaker stops with a parsing error. What has to be changed in the XSLT file? Thank you in advance

Hello, I am a complete newbie to Filemaker. But I am picking it up gradually. My question is I am trying to transfer data between our filemaker database and the USPS using XML for address verification. The USPS Form is in: (AddressValidateRequest USERID="xxxxxxx" PASSWORD="xxxxxxxx") (Address ID="0") (FirmName)XYZ Corp.(/FirmName) (Address1)(/Address1) (Address2)6406 Ivy (/Address2) (City)Greenbelt(/City) (State)MD(/State) (Zip5)(/Zip5) (Zip4)(/Zip4) (/Address) (/AddressValidateRequest) Their is also a server that …

I take it that I need all files that make any calls/references to any .xsl files wether it is only a link to open an .xsl file, add data, search or anything else need to be placed in the library/filemaker server 7/web publishing/xslt-template-files? And all graphics, pdf's for downloads, css, javascripts, and of course html files and any other kind of files need to be in the web site defined in my apache settings? Also, should I be working on my files while on the server instead of my own machine because will I not have to redirect all my files to the appropriate place when moved to the server? Thanks for all previous help as well, Doug

I actually have two pieces of code I need help with: First: ?xslt-cwp-query params="-db=GFS&-lay.response=web_specs&-grammar=fmresultset&-encoding=UTF-8"? If so could you also disect the meaning of each part please. Second: fmxslt:break_encode(.) I know what the period stands for but I do not know what this function does. Thanks, Nick

Having used site assistant to generate the xsl files, the error message "Could not find template named: store-find-request (XSLT-ER0007) appears after the find records page. The xsl files requested were: Find Record, Browse one record and edit record (no delete & Add). Many thanks for any help, Drew

When i was using Filemaker web companion and cdml tags embedded html format files i was validating the form inputs with javascript. But now in xsl format files how can do validating? Please help with an example....

I am trying to use external authentication for Custom Web Publishing and am a bit lost on the set up on both the external server side and a little on the Filemaker side. Are there any documents out there that take you through step-by-step setup for this? Or does anyone know how to set this up? Thanks, Nick

Hi, I want to divide a number to an other number but i cant. I try both of the "/" and ":" chars as a division operator but they did not work. (There is no problem with +,-,* operators. I can use them) What is the division operator in xsl? Thanks Adam Djuby

I'm having trouble figuring out how to import the value of a checkbox or radio button into a word document and have it apear as a checked checkbox in the word 2003 document. I'm new to XML and Filemaker and any help would be apreatiated. Here is a snipit of the XSLT code. --------------------------------- <w:fldChar w:fldCharType="begin"> (I think this is where the value of the check box is, starting at the <w:fldData> tag. This value changes when I modifiy the check box in the word documnet. But when I try to imort this value from filemaker it makes the document unreadable.) <w:fldData>/////wEAAAAUAAYAQwBoAGUAYwBrADUAAAAAAAAAAAA…

Is it possible to have many databases using one set of xsl stylesheets? I just got our CWP solution up and I can't get my mind around this one... Currently I am specifying the db as a parameter in the xslt-cwp-query tag, but I'd like to reuse the stylesheets for different dbs in the same site. i.e., DB1 uses /xslt-template-files/searchDBs.xsl and /xslt-template-files/listDBs.xsl DB2 also uses xsl sheets above or is it better to: DB1 uses /xslt-template-files/db1/searchDB1.xsl and /xslt-template-files/db1/listDB1.xsl DB2 uses /xslt-template-files/db2/searchDB2.xsl and /xslt-template-files/db2/listDB2.xsl TIA, Tony

I apologize for not knowing how to post actual code? I tried using the instant ubb code of code but no go. So if you would like to tell me how to place actual code in my post that would be great as well. I am trying to put a textarea field in my xsl page so a person can type info that will then go into my fm 7 database. I have my input text fields working fine but am not sure of the syntax for a textarea field. So if you could bare with me and think of M being < and W being > the following would be a regular input text field created by site assistant. Minput size="50" type="text"W Mxsl:attribute name="name"WBriefDesc(Mxsl:value-of select="positio…

Should I be able to run an index.html file by placing it in the library/filemaker server 7/web publishing/xslt-template-files/ and then in my browser localhost/fmi/xsl/testhtml/index.html When trying the browser says the requested url /fmi/xsl/testhtml/index.html was not found on this server. Is it because it is a .html file? Because I can run a .xsl file from the same directory. Thanks, Doug

I am just switching over to FM7, I tried exporting some fields using the DSO XML result, and I got the following error message: "The XML page cannot be displayed Cannot view XML input using XSL style sheet. Please correct the error and then click the Refresh button, or try again later. Reference to undeclared namespace prefix: 'S'. Error processing resource 'file:///T:/DIDO/Temporary/XMLExportFromFM7ExportF... xml version="1.0" encoding="UTF-8" ?!-- This grammar has been deprecated - use FMPXMLRESULT instead --F..." The XML result does not include the name of the fields, like the DSO result does, instead, it uses "Col" and "Data". Am I do…

In Filemaker 6 using CDML you could have the following code [FMP:Include ...]. Does anyone know what the syntax is, if any, for this with XSLT? If not could you also please tell me. I am experimenting now and would like to know either way. Thanks, Nick

It seems when I try to make any change at all to a file created with site assistant, I get an error. For example, I created a simple home, add and browse using site assistant. Which works. But if I go make any change at all in my home.xs file I get a nbsp not declared error. I am editing my xsl pages in dreamweaver, is that my problem? Is it possible that it is not being saved in the correct format? Thanks for any help, Doug

Hi, I want to make a search page to search a specific field in DB. This may be more of a html question but how can I gett the text to search for from the form and then build the quesry string to find what I need? Very stuck on this problem. I have been trying javascript but stil no thing. Thanks. tarek316

Hi all, I have a question for the xml experts over here, because I am stuck with it:( I am building a database that keeps track of submitted audio files for the napster music store. They want the tracks delivered with an xml file and they have submitted a xml format where we have to live up to. Since the xml export function in filemaker pro is not the way Napster want's it, an simple export script will not work. So I've build an calculation field that outputs a complete xml file as a text file on the desktop. Next to it I use UpCast (check versiontracker.com) to create a real xml file for it. The problem after the export is that lot's of openening and closing t…

What I am attempting to do is to display the category heading if they are different from the previous record. i.e. Category Heading 1 Record Record Record Category Heading 2 Record Record Category Heading 3 Record . . So I figured to use 2 <xsl:variables>, one to keep track of the current record's category heading and another 1 to keep track of the previous record's category heading. The current record category heading is placed in a <xsl:variable name="category">. This is found in the <xsl:for-each select="/filemaker:FMPDSORESULT/filemaker:ROW"> tag. This works correct however the problem is when the variable that keep tracks…

Does anyone know of a stylesheet that will import data from an XML property list file into a filemaker database?

I try to import an xml file, that is created by a Filemaker Pro 6 XML export, but now I would like to import the file in FM again (in same database, only different location) Now I do need an XSLT file to import the XML file again, but I can't figure it out how to write it. The XML file contains just 'flat' records and no subrows. I'll attach the XML file (compressed as .zip) Anybody? RecImp.xml.zip

I have an XML/XSLT inventory database that my clients access. They have the ability to see only the data that pertains to them via a calculation in the permissions. The problem this has created is that when a client runs an inventory report and sets the display to show max records they get tons of blank lines. The blank lines are records they are unable to see due to restricted access. This is quite annoying as for some clients they get 1000's of blank records. Any thoughts?

Hi, all. I am importing some XML into a large FM solution. One of the XML elements references another element elsewhere in the file: I can import the <Miscellaneous> element into FM using one transformation, then import the <Bequest> element into another file using a different transformation, do some multiplication, and i come up with a total value for the bequest of 42000. Document/Transaction/Client/Matter/Assets/Miscellaneous/Value = 56000 Document/Transaction/Client/Matter/Bequests/Bequest/AssetPercentage = 75 56000 * ( 75 / 100 ) = 42000 This is cumbersome. I cannot change the original XML. Is there a simpler method …

Me again (so many questions!) What is the simplest way to display a container field image when displaying a list of data as part of a xsl for-each type of statement (like a display record page). I am using xsl value-of statements for all the text and number fields. I can get the image to display by hard-coding the url (see code) I tried to reference the recid using a variable but that didn't work. I've seen some very complex solutions for what should(?) be a simple step (I assume). Any comments? Do I need to use concat to build the url? Can anyone show me an example?

I've searched through the archive and can't quite find an answer to this issue. Any help would be appreciated. Here's the background info: FMPro 7 Advanced shared via CWP. One file, multiple tables. One table is Projects; another table is Personnel. I can get the Personnel related to Project to display, no problem using the following code: <xsl:when test="count(fmrs:relatedset[@table='Personnel']/fmrs:record)>0">

I am using fm site assistant. All that is in this database is 0 scripts, 1 layout, 2 fields, "Firstname" and "Lastname". I am trying something as simple as can be, I thought. When I run assistant all I am selecting is view, showallrecords and add records. It will showrecords just fine. But if I select add, I get an error occurance of 6. Can anyone help me out with this? Shouldn't filemaker assistant be able to at least create something this simple and work? Thanks for any help, Doug

Anyone know the answer to this? I am trying (still) to receive data from an external web server via POST. I made up a simple form to test this process. with the form action providing the url to the XSLT page and a bunch of hidden attributes providing the data (text only). If I include name="submit" for the button input, it does not work. Does anyone know why? That makes it hard to work with external web servers, etc. Thanks. <html> <head> <title>Test Form</title> </head> <body> <form method="post" action="http://127.0.0.1/fmi/xsl/events/thanks.xsl?"> <input type="hidden" name="ewayTrxnNumber" value="118"…

Hello all, I am working on planning a project to develop a FM 7 application that will connect to eBay's web server system. I want to be able to both POST listings and GET listing information as auctions progress. At this point, I think I understand how I will need to go about GETting xml data from the eBay server, so my question is really about how I can POST data to the eBay server. My bible (Special Edition Using FM 7, by the Moyer Group) tells me that "In looking for FileMaker-ready services, then you're looking for Web services that support simple XML over HTTP via GET requests." If this is true, then does this mean that POST requests via HTTPS are impossibl…

What is a good book to learn xslt being used with filemaker or do they exist? What are some web-sites that have good tutorials of xslt involving filemaker? Thanks any suggestions, Doug

Someone correct me / enlighten me if this is wrong..... Can I create a script in my filemaker databse that can be executed by the user on the xsl / xml page? For example... I want to write a script that will email a client their full inventory that is in my warehouse. Can they click a link on the web page that will do this? If so what is the code to run a script? Once again I thank alll of the XML /XSL / Filemaker gurus who are nice enough to help us newbies out.

I am using fmsa 7 and xslt. In my index.xsl file I have some text etc. Now I am wanting to place a hyperlink in my index.xsl to call a script in my database and then call the file calc.xsl. I cannot figure the correct syntax. Could someone give me the syntax for a hyperlink for my .xsl page if I have: Name of file I am calling in my hyperlink: calc.xsl Database name: my_database Layout name: my_layout Script to call: my_script Thanks for any help, Doug

Is anyone aware of a program similar to Altovia's StyleVision 2005 that runs on OSX without requiring Microsoft's Virtual PC software?

I thought a good place to start with xml would be to convert on e of the old CDML solutions that came with FMP5. So I took the employee example and converted it. For the most part it works, but none of the icons that sit in a folder call IMAGES load here is the conde search.xsl?-db=Employees&-lay=Detail&-view

Hoping that someone can enlighten me on creating a progress bar for my database. Some searches take up to a min. and I would like the client to know that the search is progessing. Any help is appreciated. Edit: Let me add that this is a XML /XSL database. I would like th eprogress bar to show in there web browser after performing the search and before the data is presented to them in the browser. Thanks Brad

Hi Can anyone give me a clue here? I have constructed a type of shopping cart solution using CWP (FM 7). In talking with a payment gateway company, they can process the payment via a GET request and return xml (I'll need to use xslt to transform it into FMPXMLRESULT. My problems... 1. FileMaker can't import xml from https data sources. 2. You can't trigger an xml import script from CWP. Has anyone else tried this (successfully) or am I wasting my time?

Hello all you XML junkies..... Hoping someone can give me a rundown on the following. I have a simple form that when submitted an email is sent out to the address that I specified in the script. Instead I would like the email to go to the user who has submitted the form. Each user has a unique login that is set up in FM accounts and Privleages. Any clue where to start on this. I am an advanced filemaker user but a newbie with this xml stuff. here is the current code.... xsl:variable name="email_status" select="fmxslt:send_email('[email protected][email protected]&subject=Music Connection has received your edited BOM', concat('Music C…

Hi, How can i format my number fields into my desired format. I want to make my number fields with thousand separator as i can make in FileMaker number settings. example raw data : 8527863,45 formatted data : 8.527.863,45 Thanks Adam Djuby

I am using Netsuite CRM software and I'm compelled to convert Filemaker files to smbxml (an xml version of Oracle's Netsuite program). Problem is when I export xml using FM7, the DTD of Netsuite cannot seem to validate the xml export. I'm using xml spy to validate the exported FM file but it does not even contain the right data structure (i.e. headers and body) of a correct xml acceptable for smbxml import to Netsuite. Any clues as to what could be wrong? Thanks. Rick- an xml Newbie

Hi Guys, Im trying to produce a report similar to the one in this attachment, with a similar range of colours etc. I have setup my FileMaker 6 table to include the rellevant fields, i.e. product, artwork rec etc etc. These are entered within a portal. Are there any sample files I can disect, or do you know of any plugins I can have a go at creating reports like this. Thanks Guys Jalz

Are there any known problems with Safari accepting cookies? This code works fine with Mozilla-type browsers, but not with Safari: <?xml version="1.0" encoding="UTF-8"?> <?xslt-cwp-buffer buffer-content="true"?> . . . &l;xsl:variable name="someuser" select="fmxslt:set_cookie('someuser',$record/fmrs:field[@name = 'CookieValue']/fmrs:data[1],2592000,'','')"/> . . My Safari browser is configured to accept all cookies, but the cookie is not set. Martin

I have tried everything under the sun...hoping someon can help out. I am attempting to email results from a form. The email shows up perfectly. The subject line is perfect..... the info in the Body of the email i cannot get correct. Here is my code for the email: (note that 'Sel' & 'Title' are fields in my database) The result of this would be--- SelTitle---- with no breaks. How can I get the email to format with all my data broken into seperate lines. xsl:variable name="email_status" select="fmxslt:send_email('[email protected][email protected]&subject=Music Connection has received your BOM&',concat('Sel#:',fmrs:resultset/fmrs:record/…

I am trying to email out a stylesheet as the body of the email. It does not seem to work if the sheet has to hit the db first. Does anyone know a solution to this problem?

I don't suppose anyone has taken the time to design an xslt for importing the design report. Just hoping before I start rolling up my sleeves.

Hello all, I have a script that sorts and exports 19 records into an XML file so a page layout program can import them. The export order and settings are stored in the script of course. Sometimes Filemaker produces the error code 719 - Error in Transforming XML using XSL (from Xalan) - and the FM dialog box will come up saying "XalanDOMException caught. The code is 9." Then without changing ANYTHING, I'll export again using the script and there will be no error. It almost seems random. But What is XalanDOMException code 9??? I tried http://xml.apache.org/xalan-c/apiDocs/classXalanDOMException.html#z89_0w8, but it wasn't very clear. Thanks so much. -Jordan

Using the -edit grammar to add new record to a portal in an xslt template. Is there anyway of validating fields before the records is added? I want to make sure none of the fields are left empty. I only have 5 fields for the user to enter data into. Name School Month Day Copies Just want to make sure I don't get a lot of records added where the fields are left empty.

Frustrated XML/XSLT newbie here with a question - Can anyone recommend a powerful, non-java XML/XSLT program for OS X? I've been working on transforming FileMaker Developer's DDR report XML files, which are up to 25MB in size. I've tried the popular java XML processors (Oxygen, Editix) and they are much too slow to use... when trying to open the huge DDR output files, I gave up and force-quit Oxygen after 13 hours (!!) of the "beach ball" wait cursor. Editix simply tries for a while then says it can't open the file. I've also been using the public domain "TestXSLT", which sometimes works but generally behaves too much like public domain software for me to get a…

Hi, I am so so new on filemaker 7 and xml/xsl publishing. I am using macos x server 10.2.8. I install Filemaker server advanced and configured but i cant run xsl pages. the error message appears "FILE-ERR0001" my servers ip adress is http://194.27.20.155/fmi/xsl/a.xsl (i use the example xsl on electronic documentation to test xsl is running or not a didnt make any changes) and here is the example codes http://194.27.20.155/fmi/code/a.xsl can anybody help me? what is the problem that couse this error? thanks Adam Djuby

Hello I have used filemaker Assistant to output a XML page. When I go to sort the table on some of the fields I get an error: " An invalid XML character (Unicode: 0x3) was found in the element content of the document.

I run a couple of newssites powerd by Filemaker 6 (I am still using CDML) an would like to offer a RSS-feed for the visitors. What is the best way to create and serve the requierd XML-file with updated headlines. I have never used XML before so I

I am trying to send an email using the fmxslt:send_email() function and am having problems figuring out the proper syntax. Anyone know the sytax for sending out emails using xslt?

Hello, I use Filemaker 7 Adv. Server with Custom Web Publishing. My question: How I can insert a image (myLogo.jpg) in my xsl page (home.xsl ? Where I put the .jpg ? What I write in my .xsl page ? Thanks for your help! David

I have created a -find form in xml. When I click to "find" my records I do not get any information returned and the link look like this... (IP here)/fmi/xsl/ceg/pmhome.xsl? The rest of the link is missing. Anyone have any thoughts on this?

fm web assistant is a great start to show some xsl code, but how do you add some formatting to give the pages some style?

I

Hi I'm new to XML / XSLT CWP. Trying to put together a website with shopping cart. The client's existing payment gateway provider does have an XML service... "You POST an XML document using your own valid SSL certificate." Would that be using a FileMaker Export XML script??? Would you activate the script via a hidden attribute within a form? "We then POST the resulting transaction in XML back to your web site." How would this work with FileMaker? Anyone able to help me understand how you would do this? Thanks in advance.

I have converted over a database and am now starting to convert the corrisponding web pages. When I view the index.xsl page in my Safari browser I see the page is being rendered but I also see the code to my link instead of the blue-underlined text. When I try and view the same page on my pc I see the actual code for that page. Does anyone know what is going on?

Hi all, I saw QuinTech's post and sample file to Molloy in the forum here, and I have a similar newbie question. I want to keep my book collection in FileMaker. I saw that amazon has tools for this, and their site can create an XML file for book data. I want to be able to type in my book's ISBN number and have FileMaker 7 pull all the data from amazon about my book so I don't have to enter the title, author, etc. Just as a test, I wanted to pull just 3 fields from the online XML data file Amazon produces. (I wanted to pull the "Author", "Binding" and "Title".) I am confused as to how to properly setup the XSL style sheet to pull just the field data I n…

I am trying to take what information is provided to the send_email function and make it dynamic (pulling data from a submitted form). I chose to use the concat function... xsl:value-of select="concat('fmxslt:send_email(', "'", '[email protected]?subject=', $netid, '&[email protected]', "','", 'email_template.xsl', "',", '/,true())')"/ While the concat works (creating the correct output), the information is displayed to the screen - unprocessed by FMserver. I tried setting the string to a variable "send_email_now" and then use xsl:value-of select to call it out. This, also, caused the function to simply display on screen (unprocessed). Is what …

After a form is filled out, I have a response page (addsuccess.xsl) presented to the user. The data is placed into the database successfully, and I would like an email sent out automatically. Using the following code, I get an XPATH error "Prefix must resolve to a namespace: fmxslt

I would like to have a Summary Report sort by school year Month. So, I have a value list set up with August, September, October, etc In the XSL for my Summary Report, I have the following lines generated from the Site Assistant. xsl:comment>Display records in the current group-by section xsl:for-each select="fmrs:resultset/fmrs:record[generate-id(.) = generate-id(key('_records-group-key', fmrs:field[@name=$_groupby-field-name]/fmrs:data)[1])]"> xsl:sort select="fmrs:field[@name=$_groupby-field-name]/fmrs:data[1]"/> xsl:variable name="_records-group" select="key('_records-group-key', fmrs:field[@name=$_groupby-field-name]/fmrs:data[1])"/> …

I have an xsl template that displays a record detail with a portal table. The portal table has 5 columns. I would like the user to be able to sort by column by clicking on the header link, but I don't know if it is possible to sort on portals. If it is possible, what would the syntax be to sort by a portal column? I tried this but it didn't work xsl:if test="fmrs:resultset/@fetch-size != 0"/> td valign="top" class="class"> a> xsl:attribute name="href"> xsl:variable name="sort"> xsl:text disable-output-escaping="yes">browserecord.xsl? xsl:text>-db=Tradebook+Titles&-lay=Entry& xsl:text>-sort…