XML/XSL

Hello All! is there a way to get http POST variables sent by an HTML form? I know that I can get querystring parameters through fmq namespace but I need to obtain POST vars values. Tnx! :

Hi, I am having a problem with some xslt that I have been working with. I have a standard invoice db. Tables: Customers Invoice LineItems Items My custom web page is listing a customer's invoices history in a portal. When I try to creates a portal on the web, I am getting some strange results. My result is a HTML table... "*****************************" "*Invoice-Date*Invoice Total-*" "*****************************" "*Date1 * -------------*" "*****************************" "*Date2 * -------------*" "*****************************" "*----------- * Total1 *" "*****************************" "*----------- * Tota…

HI All, I have an xml form which i require for the user to enter information and then submit this to my FM Pro 8 adv db... Does anyone use this method and how did you accomplish it...sorry if this is a little blunt!!! Thanks in advance!

Hi Everyone, Below is my conditional function. Basically I just want record with status of open will be display as a link to that particular record. Otherwise just show status. I believe my "when test =" statement is not correct. Please advise. Thanks!

Hello friends, I am using XSLT with Filemaker 7. I am using a set of radio buttons on the web page which evaluates if the Billing Address = the shipping address. the set of values for the radio buttons are "YES" and "NO". the code that I am using is I also have another problem, where I am trying to display the values of a calculation field on to the Web page. the name of the field is "Tax Rate" and its value="Customers::Tax Rate" and in the "Customers" File the Tax Rate Field is defined as "NY Tax n Zip::Tax Rate" All the file references are also in place. Please suggest. Chandrajit

How to use a script? I am new to CWP with XSLT and am trying to learn how to use a link with a script. I have taken the xslt home page made with Site Assistant and want to create a login link that will take the user to proper page when logining in. Here is what Site Assistant produced: Login If my link is http://localhost/fmi/xsl/my_stylesheet.xsl?-db=my_database&-lay=my_layout&-grammar=fmresultset&-script=login_cwp Where does it go in the above xsl? Thanks in advance - Sam

HI all, as I moved to ver 8 I can no longer import the previous xml database to FMP. The "array" fields no loger appear in my import window. I include here the original .xml file (as test.xml.txt) I am trying to import and the xsl file (as test.xsl.txt) I used succesfully previously. For instance filemaker dosent seem to like the following string: the message being: XML parsing error An exception occurred!Type: NetAccessorException, Message:Could not connect to the socket for URL'{(0)'.Error={1} Line number 2 Column Number 112 the line and number are either inthe XML input whic is: or in the XSL file which is: if I earase these fi…

Here is a portion of the XSL I am trying to create for transforming my FM export into an RTF document. Just for simplicity, I've eliminated some of the RTF codes and show only the loop where I'm getting the data from the second field exported. This is text data, so the paragraphs in COL[2] are separated by vertical tab characters which do nothing in the RTF. I have a template for replacing the vertical tabs with CRLF, but I don't know where to call it so that the replacements occur. Here is the code for the template call. My problem could also be how I'm trying to call the template, but I'm so new at this that I don't understand. …

I am new to xslt. I want to add static graphic images to xslt pages. What would the code be and where would the graphic file be stored? Thanks in advance - Sam

As I promised in a old post (regarding MD5 function for my xslt pages), I'm here to explain how I finally made it (!! ).. well, Martin Brändle suggest me this link to filemaker whitepapers and in fact it is really useful. Martin also suggest this site to download a .js file to encrypt strings in MD5.. unforunately this .js doesn't work properly if executed as a server side script (it works fine client side anyway).. I don't know why. I searched through the www another script.. I found md5.js which works very very good (see attached md5.zip or download it from this page at frez.co.uk ). This script encrypt the strings with MD5 specifications.. just follow t…

Hello, First of all I would like to thank Martin for all the help. I have this calculation field in which I can see the values getting changed on a runtime, but when I try to display teh same field on teh web using xslt I am not getting any value. The code that I am using is where default record is a variable defined as Thanks in advance. Chandrajit

I'm new to XML/XSLT. Does anyone know of a way to restore the last query for the next new search? I’ve created a page called ‘products.xsl’ which contains 2 parts. The top part of it is a search engine: category (popup menu) and keywords (text field). The bottom part is a search result list. After the search, I want the last item that I selected from popup menu STAYED within the search result list instead of reset to default. Is there a way to do that? Any helps would be appreciated. Thanks! Danny

Hi all, it seems that the client-ip param in FMS7A XSLT does not work properly. According to the Custom Web Publishing Guide on p. 56, it should return the IP address of the web client. However, I always get as result the IP address of our web server, and therefore can not use it as a filter. We have here a double server setup, one server is the database server, the other the web and web publishing engine server. It might be that on a single server (db+wpe+web) the behaviour is correct. Therefore I have prepared a small test (see attachment), would you be willing to install it either in a Mac OS X or a Windows setting, and report the results here? If it's a b…

Does anyone know of a way to "force" a XSLT stylesheet to update any changes you've made to it? This is for a FM7SA that is in production mode with stylesheet caching turned on. I've noticed that sometimes stylesheets won't show updated changes you've made for several hours. Also, it'd be preferable to not have to restrat the CWPE for these stylesheets to update. Thanks!

I am trying to download data to a simple text file using XML. For two fields, I would like to be able to refer to the field names in the XSL stylesheet and arrange them as follows: Record01_Field01 Record01_Field02 Record02_Field01 Record02_Field02 etc. Eventually, I'll want to make a text header for the file that includes total number of records, etc., as well as text headers for each record, but for now, I simply want to be able to download basic data. As you can imagine, I am very, very new to XML. Thak-you, Charlie

I have an XML structure as follows: <?xml version="1.0"?> R XXX51 XX051 . . New ABN . . I'm using the sample file msdso_elem.xslt that comes with fm7 to process it. How would I modify it to create a flat file. Right now it only reads the order_records and places all the data in one field named order_detail. In other words, what's the best way to process this structure and import it to filemaker as a flat file? Any help or samples appreciated

:pounce: Need help - explanations 1. If any solution- routine - error check in fmp > 6 for testing is computer connecting on Internet or not ? 2. How to cline some html text which is grabbed from internet that only text information stay in input field ? Mean clean commands; elements; functions and ... all other what isn’t real text information inside some fm > 6 db. Something with Replace or Substitute calculation ? :worship:

Does anyone know where returned emails go with FM7SA? Is there an error generated or anything when an email cannot be successfully delievered? Thanks.

I have a simple XSLT results page that displays a portal with one field per row. The rows are separated by a break tag. The problem I am having is that the portal rows are duplicated - that is I get my expected results followed by the same number of break tags. I originally had my portal rows displaying as table rows, but simplified it to try and resolve my problem. I have attached my XSL file (Prec_1.xs1) result 1 Break tag result 2 Break tag result 3 Break tag Break tag Break tag Break tag Any ideas why I have the additional portal rows?? prec_1.xsl.zip

Hi all Just a quick 'tip' for converting FP5/CDML solutions to FP7/XSLST. I am in the process of converting a reasonably complex (for me anyway) system. I was having alot of performance issues and spent alot of time messing around, almost giving up. The solution consists of about 8 FMP files, that I haven't consolidated, I just did a straigt conversion and fixed any breakages. The problem that was causing the speed issues was bad file references. So, the first thing you should do when converting your 5 databases to 7 is FIX YOUR FILE REFS. This changed the requests from being painfully slow, to acceptable... (still a touch slower than CDML, but hey, FMP7 is…

Hello All, Does someone know a way to get data from my local filemaker database in a remote ASP server which does not support writing to it's SQL server directly and only has webservices and a website to enter data manually ? I need to enter many records each month manually on it's asp website while I have all information ready in filemaker. Thanks, Marcel

Hello all, I'm busy trying to extend XSLT/CWPE functions using javascript (as a server side scripting language). <?xml version="1.0" encoding="ISO-8859-1"?> <?xslt-cwp-query param="-grammar=fmresultset"?> xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:fmrs="http://www.filemaker.com/xml/fmresultset" xmlns:fmxslt="xalan://com.fmi.xslt.ExtensionFunctions" xmlns:fmc="http://www.filemaker.com/xml/cookie" xmlns:xalan="http://xml.apache.org/xslt" xmlns:fmp-ex="ext1" exclude-result-prefixes="xsl fmrs fmxslt fmp-ex"> and this is my js function declared and defined int function helloWorld(…

Hi. I'm pretty new to custom web publishing so I used the site assistant to generate a few stylesheets so I could see how it works. I had site assistant generate all possible pages (insert, update, find, browse, home page, etc.) and for the most part it works pretty well. However, I randomly get sent to an error page after clicking a link or button. Here's what the error page looks like: ----------------------------------------------- FileMaker Custom Web Publishing with XSLT An unexpected error has occurred File: /fmi/xml/fmresultset.xml Line: Column: Note: If a source file and line number are indicated, this is the location…

I am building a web page via xsl with FMSA7. And i want to make rss feeds which update online. How can i do that? Adam Djuby

does anyone know why my date formatted field sorts as text not as date. It does this when I use the FileMaker Site Assistant to generate my pages? Is there away to correct this. Thanks

Hi, I want to import currency from http://www.tcmb.gov.tr/kurlar/kurlar.xml but filemaker returns an error. The error is sourced by bank or should i do somethink to prevent this error. Thanks in advance Adam

I'm new to filemaker so bear with me, I've done countless searches but have really not found an answer. My company has a large catalog database in filemaker, they want to show certain elements of the database online. ie. pricing, description and image. They do not want this live. They just want to output the information into an xml or php/mysql database and populate the webpage from that. The prices always change so we need to be outputting monthly and then updating the website. The graphic designer has a nice page layout, The layout calls for an image in one table or div tag, the pricing in another table or div tag and then the description in another table or div,…

Hello, I am using XSLT with a FileMaker Database. I have converted the CDML files running in FM 6 to XSLT using CDML converter. I have been able to solve most of the conversion errors, with the exception of a few. In one of the XSL files I am declaring a form like the comment has been added to facilitate understanding followed by a few the next page i.e. customerverify.xsl gives all the data right but in case there is some data that is missing or if there is some required filed that needs to be filled up, the -token.error does not work. Could you suggest an alternative to this, coz the CDML converter has given its output in…

Hello friends, I am trying to display values from a portal, but theres is nothing that is working. The code that I am using is something like this: I am presently in a table called "Orders" and I am trying to display values from a portal in this table which contains fields from a table called "OrderItems"

Does anyone know how to use the count function within xsl? I know have the following structure: The xml should show something like: But how? Thanks in advance. Kip

When creating an application that is meant to run inside FileMaker, you can pass parameters to a script (via the "optional script parameter" field). Is there a way to do this when you are using CWP? I see that with the -script command you specify the name of the script. Also, you can append the ".prefind" or ".presort", but I can't seem to find a way that a parameter will get attached to the script you call. Does anyone know how to do this?

Hi, I am not new to FileMaker since I used it from the very first version, but I don’t know how to handle the new complex languages there are such as XML and so on. I need to import in FileMaker a large video database the database in English or in Latin Chars, I need to import it in FileMaker where I can add additional information in 2Byte chars (Traditional Chinese). With Unicode Filemaker finally works well ao no problems here. The problems are the Import from the XML file. Although I verify the original XML file (it's a UTF-8 file) with OXYGEN I learn the file has no errors and it is well formatted. FileMaker just doesn’t want to import it. It finds errors w…

Hi, I am developping web pages by using xsl style sheets. But it is too diffiult to write xsl & html codes for .xsl files Is there any editor or tool which has design mode which shows output of the codes (like dreamweaver or other web editors) Thanks in advance. Adam Djuby

Does anyone know of a way to call a XSL template from clicking a form button? Also, is there a way to determine if a form checkbox is checked using XSL:If Test? What I'm trying to do is to have a template with a loop in it that will run for each record in the found set. It will also add a record to the DB if a certain box in a form is checked on the page using something like: I need the $hawkid variable to be based off a text field in the form as well. Anyone know how to do this? In theory this should all work fine, the problem is just being able to incorporate the form elements into this. I've also attached the XSL file I'm working wit…

I have figured out how to set cookies and retrieve them. The porblem is I seem to only be able to do one cookie. I set a cookie and was able to call it back. I tried to set another cookie and I have not been able to get it back. And when i do a get_cookies it only shows the first one. I am looking for any information about cookies and how they are used and any rules/syntax that people know about. And if you could answer the multiple cookie question in the process that would be great. Thanks, Nick

Hi, I'm trying to edit multiple records on a single form in an XSLT template, using a simple loop to display each returned record within the form. The page loads fine, displaying the current data and allowing changes, but then the changes are not saved when I submit the form... Is it impossible to edit multiple records in one form? Sorry if this has been addressed already, I did look around for earlier posts but didn't find anything. Thank you!

We have a client who has set up web page delivery via XML/XSLT from FMU 5.5 on PC. It keeps stalling - FMU has to be restarted continuously. He wants to switch to v7 instead of paying for FMU 6 (which probably should fix his problems), and has done a reasonable job of converting his databases to v7, plus has installed FMSA7. He can demonstrate that all the server stuff is working. But now his XSLT won't deliver the data from the dbs. Can someone point me to exactly where I should look as to why FMU5.5's XSLT won't work with FMSA7's? Or if this is not a simple fix, could someone also let me know that? Thanks, Michael

Hi, Sometimes, when importing XML data in FMPXMLRESULT via http, for example http://www.someserver.com/document.xml FM imports data very fast and perfect, but sometimes, without any logic, FM shows the color cursor "ad eternum" and have to force quit the application. Someone have any idea? What's wrong? Thanks

I would like to be able to format my results pages so that the first 30 found records will appear in one column and the second 30 (if any appear in the second column. I will max my results to 60 so that only 2 columns are requried... Any help is appreciated Thanks

I have a database that is running through IWP on the Internet. When person submits their information, the session remains open. Id like to end the session by getting the user to a XSLT page that would kill the session. I have created some XSLT pages from the server using the Filemaker Site Assistant. But Im not sure where to incorporate the following code: fmxslt:invalidate_session(String session-name) anyone have a sample or a link to help?

I have recently been working my way through re-creating the front end of my application using XSL. Though I seem to have control over the actual XSL, there are still a few things that I am unsure of. How exactly does one create and manage sessions? I know you must call the "fmxslt:create_session()" function, and give it a session name. I assume you include this on the first page the user sees after logging in. After that, how do you make sure the session is maintained after additional queries are made? The Custom Web Publishing Guide also mentions that you must use content buffering when using sessions, but I'm not sure exactly how to do this. Mainly, I was usin…

Hi, Is there any feasible way to group set of record based on a field. I want to make a list which show one record (does not matter) from all groups. Thanks Adam Djuby

I am facing problem when accesing through custom web publishing. When i disable the guest a/c in hosted database, and access though browser a http auth window opens and asks for username/password. when i give username/password it does not takes. Even if i give the administrator username/password it does not takes. I am using Filemaker Server Advanced 7 Os: Windows 2003 Sever Pls help regarding this problem. Thanks Debabrata Pati

One problem I am noticing while working with XSL is the browser's tendancy to load a page from cache, when I need it to be making another query to the database. For example, if I have the user scrolling through records, it will query the database the first time I view these records. But, if I navigate to the same record more than once, it is only loading the page from cache, and not querying the database again. This is a problem if a script or something else has modified that record. This problem is also occuring on a page where the user can click a link which executes a script. If the link is clicked once, it works. Any additional clicks and the browser just r…

In my application, there is a screen that has a portal on it. The relation to the portal is based on a global field (gNo). I then let the user click on a button that calls a script which changes the value of gNo, and the data displayed in the portal changes accordingly. Now, I am working on making this screen using XSL (transforming XML to HTML). I have created a link which calls the script, and this seems to properly change gNo, but it does not seem to change it more than once. I know that if you want to update a global field, you have to use the .global syntax in order for the value to be tracked during the current session. Is the problem occuring because I call a …

In my original FileMaker application, I have a number of portals where each "column" in the portal is clickable. Based on which column was clicked, I call a script to either do something as simple as a navigation command, or perform a more complicated script step. I have two questions, related: What is the best way for displaying portal data? What is the best way to duplicate the clickable functionality? Currently, I am using the HTML Menu/List (as a list) to display portal contents. This works great when there is only one piece of data to display. It lets me limit the portal to a set number of rows, and has a scrollbar, so it is essentially a portal. There are obvio…

I have ordered the XML cookbook, but havent received it yet. Therefore this post! I am filtering some data from a filemaker 7 export through a stylesheet the following way: However above returns only the first record of the 10 matching records To get the rest of the data I now use this: (and repeat this 10 times....) I know there should be a better way of getting these records...but how? Anyone? Fenton? Greetings, Kip

Hi everyone, With no value in fields, after users click on search. All the data are been display. Therefore, I want to make some fields be require before users perform a search. I know Javascript is able to do this. I'm wondering if there's anything in xslt or xml that check fields as well. Thanks

On page 648 of the "Filemaker Pro 7 Bible" does it say: Opening an XML Data Source to Create a New Filemaker Pro Database" Well is that really it, isn't it just a new table in a new base without the relations defined or any scripting whatso ever??? --sd

Hi, I used document() to load a new node set into a variable, and now I can display all the values as 1 string. Can anyone show me how to loop through the node set, or select specific field values from it? Thanks. My code:

I have been unsuccessful in the process of making some parts of the text bold or colored. Did anyone used or with this function? The desired fields are sent correctly with the fmxslt:send_email function. I just need to do some cosmetics on the text. Thanks for reading my post, Bogdan

Hi everyone, I have a little problem in importing xml data to filemaker. On macintosh (Mac OS 10.35), when I try to import the data I have this following error message "exception occurred Type: Transcoding exception Message Could not create a convertor for encoding : iso-8859-8" If you have an idea/solution please tell me .. Thanks

Hi there, I am very new to all the transformation of XML to HTML using XSLT but was wondering if someone could take a stab at leading me in the right direction. I have been trying for the past 12 hours to create something which I am sure must be able to be done with utter ease but it is just eluding me as to how to do it. My problem is this : I work for a commercial production company as the Senior Producer where we create radio adverts. With each advert we have to supply the details of any music tracks used for PRS details. Basically in the simplest form I have a table in the database called Music Details which stores the ad title, music publish…

I am using FileMaker authentication. However when I use the following syntax it does not log the user out. In both Safari and IE (mac) the user can click on the back button or the login button and automatically be logged back in. I thought it is suppose to end the session immediately. I am sure I am doing something wrong. Tim Brown

Hi I am struggling a little with XSL. I want to add a record with some data already entered. I have two fields, Charge and Type. For each recorded added from a particular page I want Charge to be "C" and Type to be "B". Do I have to create the record and then edit it, or can I use the add page to include this data. Any advice is appreciated. TIA Zippy

I'm trying to send an email (containing information from the deleted record) whenever a record is deleted. Here's the story. Every record represents an appointment with a professor. Whenever the professor can't make the scheduled appointment, he/she can cancel the appointment. With such cancellation, the student should receive a cancellation email stating that his/her appointment (with all the pertinent details: time, location, date, etc.) was cancelled. The problem: since the record has already been deleted, how to pass along all the record fields to the send email XSL stylesheet? I use the send_email function to send email: [...] …

Was wondering if you can incorporate a cascading style sheet into xml pages. I have a CSS but have not been able to get it to work. thanks, nick

Hi I have a web page with a simple table that shows data from FMP6 database (inlineAction table). I need to summarize each column and display the result in the buttom of the table....thats all.... can some one please post an example code of how do I do that in JS or XML...

Hi, I think I may have taken a wrong turn. Just recently found a need to import XML into my FM 7 database. Started looking in the FileMaker Professional Training book for info on XML. In the CWP section they use the fmresultset grammar. Tried to find info on this new grammar and found very little, except when referenced with FM Server Advanced. I noticed that fmresultset was not an export option with FM 7. Then it finally dawned on me that maybe fmresultset XML could not be imported into FM7. Am I correct? Should I be focusing on using XSLT to transform my XML to FMPXMLRESULT instead? Thanks.

Hi! I have setup an working enviroment with FMSA and apache server. When I try to share my own database it is only shared with Istant Webpublishing not XML. My question is this, how do I make my database enabled for XML? Plz help me.. // Jocke, Sweden

Months ago, we were on FileMaker Server Advanced 5.5 and we were using CDML on the web publishing engine and it was working fine. Now, I'm happy to see that FileMaker makes improvements on the way of standards with the changes made on SQL, XML/XSL on WPE, etc. But, I'm really disapointed by the performances of XSLT on my FileMaker Server Advanced 7 on my dual 2.7GHz PowerPC G5, 1.5GB SDRAM, with Mac OS X Tiger. So no problem with the server! Performances were improved everywhere on FileMaker 7 databases, and with SQL, but not XSLT... Okay, just to say how it is bad I've converted from CDML a simple webpage that directory our contacts and gives in…

I am in the process of replacing the IWP elements of my FileMaker application with some Custom Web Publishing instead, using XSLT. The problem I have is with form submission. For example, if I want a user to be able to create a new record, I would have them fill out an HTML form and click the "Submit" button. Then, based on the information entered into the form, I would construct the URL that gets sent to FileMaker (containing the -new and -script I need, and all the field=data pairs, and finally the new .xsl page i'm directing the user to). This is the part where I have trouble; right now, I have my "Submit" button direct to a PHP page, where I use php to process t…

Can someone tell me why this does not work? I want to insert a form within a relatedset record (records from the table "items") which allows the user to edit the "quantity" field. I am getting error code="101" (record is missing). item-edit.xsl edit Thanks!

I am creating a web search for emaill addresses, but when entering the address it is necessary to enter it like this: "[email protected]" Is there a way to escape the "@" in the XSLT? Thanks, Moe

Error 957 (Conflicting Commands) Could someone provide some insight as to what this error means? Setup: FMSA7.03 on OSXS 10.3.8, using XSLT for CWP (and IWP for some solutions) BKND: Solution for our Business Office to notify our IT department of users (new, terminated, or change in status). Solution WAS CDML, and was converted to XSLT. Error occurs upon submission of changes (user picks from list of users, is then presented with HTML form, makes changes/additions, and submits the form) I really believe there is something wrong with my XML/XSLT (not a server/database issue) code, but I am not sure what to fix. I was hoping that if I better understood what…

Using the FileMaker Site Assistant, I generted a simple stylesheet that does a find on a database. The generated code provides a drop down menu for each field to select the desired operator. <tr> <td align="right" width="25%"> <b>ShortName: </b> </td> <td align="left" width="5%"> <select> <xsl:attribute name="name">ShortName.op</xsl:attribute> <option selected="selected" value="eq">Equals</option> </select> </td> <td align="left"> <input size="50" type="text"> <xsl:attribute name="name">ShortName</xsl:attribute> …

Attached is the XSL file we use when adding records to our database. I want to add a button at the bottom of the sheet for "Save and Email". I want this button to send an email with Subject=Store and Taken by, Summary of Problem, and Equipmentneeded in the body of the email. Can anyone lend some insight into how to do this? addrecord.zip

I have recently had to move from using Remote Access to having an xsl front end for an application. One feature did the following: Based on a set of data, call the Export Records script step (using an xsl file), to create an rtf file. Then, call the Insert File script to put the file into a container field. I am having real trouble reproducing this functionality using CWP. I am using XSLT to create the HTML front end for my application, but cannot seem to find a way to get this functionality. I know the two script steps in question are not web compatible... Any suggestions?

Hello all, I have two layouts related to the same table, one is called 'detail' and the other (obviously -) ) list. Both of the layout contains a field (text unformatted) called 'Description'. I publish this field on the web (one page to obtain a list of records, the second page to display the detail) using fmxsl:break_encode() function. I really don't know why but the detail descritpion is well formatted (the code shows all the tag properly ex: < br /> or special chars like & etc..), the list version encode the source so I get < br /< and &am;amp; in my HTML and the reulst is that the browser display < br /> or &.. I though…

Can someone tell me why this does not work? I want to insert a form within a relatedset record (records from the table "items") which allows the user to edit the "quantity" field. I am getting error code="101" (record is missing). <xsl:for-each select="/fmrs:fmresultset/fmrs:resultset/fmrs:record"> <xsl:for-each select="fmrs:relatedset[@table='items']/fmrs:record"> <table border="0"> <tr> <td><xsl:value-of select="./fmrs:field[@name='items::item_name']/fmrs:data"/></td> <td> <form method="post"> <xsl:attribute name="action">item-edit.xsl</xsl:attribute> <input name="-db" …

Simple Question: Does the CWP support it? Is there anyway I can use it? (well obviously if it supports it, then I can use it.)

Hi I used the FileMaker Site Assistant to create a website. I found that if I add a scrollbar to the text field in fmp7 the assistant creates a textarea field instead of a text field. This is exactly what I want. The problem I am having is when I go to edit the textarea field none of the data shows up. The fields that are formated as checkbox or text work correctly but not the textarea fields. Here is a code snippet generated by the assistant: skills()

I need to export some data from my FMP7 database. It needs to be in an XML format so I can upload it to a web based data base(my E-Commerce web Site) The only data I need is the Product ID, and the on hand count. The XML need to look like this: <BVC2004> <Products> <Product> <ID>99-1V</ID> <InventoryAvailableQty>0</InventoryAvailableQty> </Product> </Products> </BVC2004> The only data is the <id>= my produnt part number and <InventoryAvailableQty> = my on hand count. I will need to export many records at once. Thanks, …

Some of our clients vendors are entering information in textarea boxes which reside inside a form. <textarea name="t_ProductDesc" rows="12" cols="92" wrap="virtual" color="#003300"> <xsl:value-of select="$default-record/fmrs:field[@name ='t_ProductDesc']/fmrs:data"/> </textarea> These vendors are entering data using Macs and our clients are viewing the information in Filemaker on PCs. When the vendors enter a "return" and submit the form it shows up as a square in the field on a PC when you look at it in Filemaker. I have already tried wrapping the above in a fmxslt:url_decode but because it is in a textbox it doe…

Hi, i try to make a form to search a range value with the old cdml i used <select size="1" name="-op"> <option value="gt">greater than</option> </select> <input type="text" name="field1" size="10"/> <select size="1" name="-op"> <option value="lt">less than</option> </select> <input type="text" name="field1" size="10"/> Now with xsl i tried to do <select size="1" name="field1.op"> <option value="gt">greater than</option> </select> <…

I am trying to validate data on entry in a number of fields to less than 28 characters using java. I know it can be done but just haven't been able to get the syntax correct. Does anyone have the syntax?

I am new to filemaker. I have created a simple database. Using the site assistant, I have created XSLT templates for a search page. I want the search to require all matches. That was simple. I added this line: <input name="-lop" type="hidden" value="and"/> Everything is working great, except for one thing. I have a set of checkboxes for the field 'CITY', and within the checkboxes I want to use OR logic, so that people can search on 'Washington' OR 'New York' OR 'Seattle', etc. I have tried many approaches. Scripting, for example. But I can't see how to pass arguments to FM scripts. Does this make sense? Does anyone have an answer?

<xsl:choose> <xsl:when test="$abc=' ' "> ...false </xsl:when> <xsl:otherwise> ...true </xsl:otherwise> </xsl:choose> Is this the correct way to test if variable abc has a value (ie. I want to test if a token has been passed)? Thanks

Alright, so I'm new to custom web publishing, and I've been following the white papers on how to set it up. So far (what I've done sucessfully) is: -Update FMSA and the WPE to v3. -Enable the WPE for xml/xslt - Followed the instructions in the Custom Web Publishing Guide (white papers) in chapter 2: Preparing databases for CWP which are- step 1: Create a new extended privilege using one of the following key words for the type of CWP tech you want to allow for the database- step2: Assign the new extended privilege to one or more privilege sets. step3: Assign the privilege sets that include CWP entended privilege to one or more accou…

I am using Filemaker 7 Pro and Filemaker 7 advanced to host databases. I use Filemaker site assistant to export the file into xslt code then I take the xslt code and try to change the background, but when I do try this and drop these files back on the server to host the database I get an error. When I change the code I am using either Dreamweaver or notepad, but either one makes any difference when I drop it back on the server because the file errors out when viewed on the web. If I change the file and preview it in Dreamweaver it works exactly the way I want it, but not when I go drop it back on the Server. Could someone please help.

Hi all. My presence in the XML forum can only mean I want something again. Working in FMP XML grammar, I am trying to determine the position of the first field name to start with the string Transact. I have been able to create a variable that gives me the field name, but I cannot figure out how to get the position. My efforts thus far: <xsl:variable name="firstTransactionField"> <xsl:value-of select="//fmp:FMPXMLRESULT/fmp:METADATA/fmp:FIELD[substring(@NAME,1,8)='Transact']/@NAME"/> </xsl:variable> This, as I mentioned, will return me the name of the field. How do I modify this to return the position of the field within the …

On one of our site there is an a field that we apply a value list to in the form of checkboxes. In this case there is only one value in the value list. so either they can check it or uncheck it. The problem is if they do not check anything and the box is previously checked the database will not update the field with nothing. In other words if there was something in the field (so the box is currently checked) and they uncheck the box (so now there are no boxes checked at all) and submit the form, the database will not erase what is in the field and make it blank. Any thoughts on why this is? Thanks, Nick

I was trying to use code I found from this forum to send_mail after adding a record. This is my calling page to send the mail. My data gets added the the database but the "email_status" is never true(). Any idea what the problem is, I tried 2 ways of doing this. The 1st way . <xsl:variable name="record" select="/fmrs:fmresultset/fmrs:resultset/fmrs:record[1]"/> <xsl:variable name="subject" select="$record/fmrs:field[@name = 'title']/fmrs:data[1]"/> <xsl:variable name="description" select="$record/fmrs:field[@name = 'description']/fmrs:data[1]"/> . . <td><xsl:value-of select="$subject"/></td> <td><xsl:val…

I am using the javascript properties, history.go and location.href in the following code. The history.go works fine, the location.href partially works. It sends the user back to the confirm_events.xsl page but does not execute the rest of the string. Any help will be much appreciated.......Ray <xsl:attribute name="onload"> <xsl:choose> <xsl:when test="$current-action = 'new'">history.go(-1)</xsl:when> <xsl:otherwise> location.href = &apos;confirm_events.xsl?-db=Web_TA_Pre_Reg_DB&amp;-lay=Registration Evaluation Form-2&amp;-error=confirm_events.xsl&amp…

Hi Using FMPro7 Server Advanced on PC When users enter data into a textarea field via the web, all of the returns they make when entering data via the web show up with rectangles at the end of each line within filemaker. Anyone know how to prevent this or at least remove it? Thanks!

To finish my projectd, I need to learn the in's and out's of XSLT and Custom Web Publishing. Instant Web Publishing falls short. I've read all I can about XSLT in the documentation and the 1 example enclosed with Server Advanced. Are there more examples of XSLT and Filemaker out there I can learn from? I find its the best way for me to learn. Cheers, Mark

Can someone fill me in on how to display data from a portal using XSLT? I tried this... <xsl:for-each select="fmrs:relatedset[@table='line_items']/fmrs:record"? <xsl:value-of select="fmrs:field[@name='line_items::item_desc']/fmrs:data"/> </xsl:for-each> No error reported and the results were included in the XML resultset tree - but not displayed in the final HTML. Portal exists on the layout with the field item_desc in the portal. Thanks

While using the document() function (in XSLT) to load an additional XML document, I've encountered the following sporadic error message: The resource [i]http://...[/i] could not be loaded because of an unexpected error (MCS-604) I'm not sure why this seems to occur. Sometimes, the XML document loads fine. Sometimes, I get the above error message. Any clues on what could be causing this error message? Could it be tomcat and not FMS? I'm using FMS 7 Advanced on Mac OS 10.4. Thanks for the help, Adrien

I'm trying to understand how to have a web server insert data into a FileMaker database. The data is coming from a perl-based shopping cart, and we have FileMaker Server Advanced. The goal is that as orders are entered on the existing shopping cart, the perl script "pushes" XML at the FileMaker server creating a new record in the database. I'm finding that resources are hard to come by.

I am wondering if anyone has any information that could point me in the direction of learning how to generate an RSS feed using FileMaker. I do not need a dynamic connection between FileMaker and the web, only to generate the correct XML syntax for the XML file. Any help would be most appreciated.

Has anyone had any luck on using the UPS XML interface? Are there are files out there to help with this? I am looking to work with Package Tracking, freight est, and days in transit calc, and maybe others if I can get these 3 to work. Any pointers or examples would be great. Shawn

Hello I was wondering if someone could explain to me why the attached code is duplicating each entry twice. The data is found in file A which shows data B through a portal. So say there are 20 portal rows. The attached code will display all 20 rows with data and then will continue to put another 20 blank rows below it. I suspect it is the for-each but so much of this a black box to me. Maybe now would be a good time to mention I have put in an order for Beverly's book : ( and martin if you have a book out there that I do not know about...) Thanks. duplicate_rows.zip

After making a selection on my index.xsl page, in my case an "Institution", I bring up the people found for that institution and display name, phone, email etc from my database. At the top of my page I am wanting to display "Our friends from (and whatever institution was selected being in a href). I am wanting the institutionurl, which is a field in my database, in the actual value in my href. For example, say North Carolina was selected on my index.xsl page, I want the top of my page to show: Our friends at North Carolina. And if selected it goes to www.unc.edu or whatever the link happens to be in the institutionurl field in my database. Here is what I tr…

Using fmxslt:set_cookie (String name, String value) works just fine. However, using the other set_cookie function -- fmxslt:set_cookie (String name, String value, Number expires, String path, String domain) -- does not work. Not even the examples given in the XSLT Reference work! Example: <xsl:variable name="storing_cookie" select="fmxslt:set_cookie ('foo', 'bar', 1800, 'my_cookie', 'yourdomain.com') "/> Has the syntax changed? Is there an errata out there? Did anyone manage to use the latter set_cookie function? Thanks, Adrien

I am trying to include field values in the subject area of the fmxslt:send_email function. This is a problem as the function does not allow the value-of because the value-of function is used to perform the fmxslt:send_email function. Is there any way to get field values into this email function? thanks, nick

Hi everyone, I've been beating my head against a wall trying to figure this problem out. I'll try to simplify the problem to explain it better. I have a FMP database that I want export to XML. I have 2 tables that I want to export that have these fields: Curatorial table ----------------- curtitle thumb Curatorial_detail table ----------------------- curtitle body media Obviously the "curtitle" field links the 2 tables, and this is a one-to-many relationship with one Curatorial record having many Curatorial_detail records. I would like to export these tables into an XML file that is in this format: **********************XML F…

I am looking to add an instant web publishing feature to the weather data that I mentioned the other day. Currently I have a database that successfully takes queries in from the web and puts them into their respective fields. What I am looking to do is add a couple of fields for these web-submitted records. Is there a way to add the XML into the HTML code so that it performs the search and then enters into the fields via the web submission? Sorry if this is a little unclear.

Hi all, Can anyone help me? I want to know how can i do a list of found records with the link next/previous page i display the records with this code <xsl:for-each select="/fmrs:fmresultset/fmrs:resultset/fmrs:record"> <xsl:variable name="record" select="current()"/> <xsl:value-of disable-output-escaping="yes" select="$record/fmrs:field[@name = 'field1']/fmrs:data[1]"/> - <xsl:value-of disable-output-escaping="yes" select="$record/fmrs:field[@name = 'field2']/fmrs:data[1]"/> <br /> </xsl:for-each> is possible to have an xsl example? sorry for my bad english Thanks, Hide77

I have a FMPro 7 solution running on FMSA to the web via CWP and XSLT I have three privilege groups: guest: read only access admin: full access contributer: edit/create access (can't delete) If I turn off guest access, everything works fine as far as who has access to which records and commands. Once I enable guest, it defaults to that whenever a user goes to the site (which is exactly what the documenation says it will do). The documentation says to use the re-login script to allow a user to login as someone other than guest. I've played with "Re-login" and could only get it to work by creating a stylesheet with a user field and a password field…

Hi, I do not know a lot of XSL. However I need to find a way where I can filter data from FMPro7 in order to generate a xml file correctly. In my database I have a field with five possible values: m, v, mv, an, nv In my xsl stylesheet I want to filter these values to a simple "yes" or "no" In the xsl I want to do something like this: <artist> when fmp:COL[8]/fmp:DATA[1] = m <xsl:attribute name="MALE"><xsl:text>yes</xsl:text></xsl:attribute> <xsl:attribute name="FEMALE"><xsl:text>no</xsl:text></xsl:attribute> when fmp:COL[8]/fmp:DATA[1] = v <xsl:attribute name="MALE"><xsl:text>no</…