jwnacnud

Yes, this one works as well.

Yes, this one worked perfectly. Did you alter the stylesheet?

Yes, this worked just fine.

The target application is an Amazon Seller Central Product Feed. We use this feed to create new amazon listings and to revise quantities and prices on amazon.

I have to provide feeds to 3 different channels and may have gotten them mixed up. So, attached is the source xml as exported from FMP (test_xml.txt). It has one additional field that the previous attachments don't have, the last one. Also attached (textworks.txt) is the same date that has been exported as a .mer file, opened and then closed within OpenOffice, and is ready for uploading to the website. It looks like that last field had carriage returns in the XML file and they were converted to VT (vertical tabs?) in the tab-delimited file that came out of OpenOffice. Whatever they were turned into, they work when importing into the website. test_xml.txt.txt testworks.txt

Thank you for the correction. It is a Tab-delimited file that I am making. I am submitting two files here for perusal. The first (this_file_works) was exported from FMP as a .mer file, opened in OpenOffice and then saved as tab-delimited. The second (this_file_doesnt_work) was exported from FMP as an xml using the stylesheet that I posted. Can you help? I need to get the 2nd file to output just like the first so I can eliminate the extra steps after exporting. Incidentally, Excel, OpenOffice for Windows, and OpenOffice for Mac all require different processing steps to create the same type of file. That's why I want to use xml with a stylesheet, to eliminate that for my clients. this_one_works.txt.txt this_one_doesnt_work.txt

I am exporting to XML and producing a Tab-Delimited file. Everything exports well except for text fields that have multiple lines in them. How do I make the stylesheet handle the multiple lines per field so they stay in the same field? Example of multiple lines: This tool is 18Volts. This tool has no charger. Also, how do I change the stylesheet to enclose each field with double-quotes? Thank you Fenton for your excellent help on this earlier. You provided a stylesheet that works very well. Here is the stylesheet that I have: <?xml version="1.0" encoding="utf-8"?> xmlns:fm="http://www.filemaker.com/fmpxmlresult" exclude-result-prefixes="fm" >

I am running FM10 Server and need to be able to allow my clients, (mac and PC) to be able to store images in the same shared location. Currently, these images are stored within the FM Database. However, I really need to be able to sync the images to a website as well. So, I was thinking that I could store them in the database, as normal, and then schedule a script that exports the updated images to a shared location and then I can have another program running that will keep the image location synchronized with the website. However, Export Field Contents is not available server-side. Any ideas?

I have Filemaker Server 10 Advanced running on a mac. We have multiple users on mac and windows that need to be able to upload images to the server. I want to store a reference to the images instead of keeping them within the database. How do I script so that the images go to the right folder on the server when uploaded from a windows or a mac machine.

I was able to figure out what you did and replicate it. Thank you very much for you help.

No problem, that's plenty. I will just keep plugging away at it. Thank you!!

Thank you. Your example works beautifully. I have spent the lasat 45 minutes trying to integrate what you did into what I have - unsuccessfully. I will keep at it, but if you have a few moments, could you make it work in my sample? I can't seem to get it working. (I hate to ask because you've already done so much to help). I sell routerbits and saw blades if you happen to be a woodworker. I can certainly help you out that way (routerbitworld.com). Not a plug for the website, just to show that my offer is real. Not just working out of my garage. Thank you.

Could you show me an example of what you mean?

I have attached a sample of this solution that I am working on in the following thread: http://fmforums.com/forum/showtopic.php?tid/215067/

I don't know if you saw my response earlier. How about on the server. I am running FMP Server 9 on a mac mini. If I am on a windows terminal and I run a script like this, will the server save the image locally, or will I need to logon to the remote share to save the image?

Thank you for the heads up. I have removed the password.

I have a solution (or need one) that takes events with a start and end date and then displays the overlapping (concurrent) events. The relationship to show the concurrent events works as expected, displaying only items where there is an overlap, no problem there. My question is that I want to be able to show the elapsed time between the main (focus) event and the concurrent event. I am uploading a sample database to clarify my question. Within the example database, when viewing the focus item, "Went To Disneyland" in Item View, it correctly displays the concurrent items, "Undergoing Cancer Treatments" and "Age 4". The start dates for the concurrent items are correct. However, the field ElapsedTimeDays is not correctly calculating the number of days between the start date of the concurrent items and the start date of the focus item. How do I fix that so that I can display them in a portal, as any focus item can have an number of concurrent items. Thank you in advance. if needed, the UID/PASS is admin/admin, but I have it set to autologin. Concurrency_Elapsed_Time.zip

Thank you for pointing that out. I had a similar concern since number of days is the only accurate time interval that I can determine (it is always 24 hours, well, plus a little) However, these time measurements need only be approximates as they only serve to give context to the event. For example, when you arrive late to a movie or play, it is helpful for you to know how far into it you are. When you go to see a soccer match, you frequently look at the score board to see how far into the game you are. Why, it gives you context. In a related calculation, knowing the remaining time also helps to give context to a game. From a historical perspective, if you are researching anything that has already happened, (that has a start and end date) such as world war 2, it is helpful to know that the US bombing of Hiroshima occurred precisely 567 days after Pearl Harbor was attacked, or 776 days after World War 2 began, and also to know that the bombing of Hiroshima occurred precisely 115 days before the end of the war. (these dates are in no way accurate) With that said, for accuracy (in this approximation) I would stick with stating the number of days and also restating in terms of years. (442 days or 1.21 years) If I can PM you I'd be happy to send you a sample of the database that I am working on . I'm sure you'd see the solution immediately.

I have a calendar program that calculates the elapsed time from a concurrent event until the focus event. For example, while I was 19, I went to disneyland. If the trip to disneyland happened on 1Jun2008, the calculation would tell me that I had been 19 for 0 years, 2 months, 13 days. This works fine. However, when I try to add other events that happened during that same time period (the year that I was 19) the events are displayed in a portal but the elapsed time only calculates for the first line item. Any ideas why. I have attached an image with a different example. In this example you see the title, start date, and end date. On the right are the events that are concurrent to this event "Senior Prom". The event, Senior Prom, happened while I was Age: 18, a Senior in High School, living in the house in Dugway. The context items are each on a line in a portal, as is the elapsed time calculation to the right. It is only calculating the elapsed time for the first context item. Why?

Please, I am just looking for how to make something like a Journal database where all the journal entries are stored in the same table but when a user logs in, they can only access the records that they created. Do I need to use a script for this or does record level access work for this. I understand best with an example. Something super simple would work. Simple table with the following fields: ID CreatedBy Content

What is a join table and how do I use it. I've been filemakering for 10 years and have never used a join table. It sounds like I about to be enlightened.

I have many products and each product can exist in multiple categories. I have a product table and a category table. I access the category table via a portal. I have many people adding and changing the categories so I need to find out which items have been modified to update the website. I need to have a checkbox in the products table set anytime a category is added or updated? I have used evaluate in the past but cannot seem to figure it out with a related record. If there is a better method, let me know.

I have my master layout that shows prices. New prices are added to the pricing table and old prices are saved. I need a calculation that will fill a checkbox when a price is changed in the related table. I can get it to work in the current table, but not a related one. Any ideas?

Your example was very helpful. I am almost accomplishing what I need to do. One more question, because I think you'll know the answer. If product C is a combination of (2) of product A and (3) product B, how can I thrown in a multiplier to make the price of product C correct? Thank you in advance.

I have FMP Server 9 and need to be able to insert an image into a container field within the database using a script. This script needs to then export a the field contents to a folder on the server. This folder with get synchronized with our FTP server with Rsync. I access the database from work and from home and need the export field contents script step to work on the server. Help!?