Jump to content

NYC Newbie

  • Content Count

  • Joined

  • Last visited

  • Days Won


NYC Newbie last won the day on May 22 2011

NYC Newbie had the most liked content!

Community Reputation

-1 Poor

About NYC Newbie

  • Rank
  1. consultant, Thank you so much for your kind reply. A script step takes care of any repeats and doubles in the bookID field. Fortunately Filemaker offers ways work get around a client's prescriptions without creating a conflict between developer and client. I have already implemented the substitute formula in the script referenced above. I will try your formula and see if it negates the need to add to the double checking script.
  2. Consultant, Thanks for your reply, the bookID, as calculated, works for the user who wants an intuitively easy way to ID a product rather than look up a bunch of random numbers. I am still looking for assistance on my original inquiry regarding replacing / substituting blank spaces in a text calculation.
  3. I have a book database with individual and unique bookIDs for each title. This bookID field is auto-entered by calculation of first two letters of title, author, publisher and price. bookID=Middle(title;1;2) &Middle(author;1;2)&Middle(publisher;1;2)&GetAsNumber(price) This bookID will also be used as a SKU number which prohibits empty spaces. This presents a problem for titles such as "A Day in the Life of Ivan Ivanovich" which yields a bookID of "A SoPe5". I would like to substitute the empty space with an underscore, e.g. "A_SoPe5". Is it possible to achieve
  4. Actually, no, the issue isn't the same. The previous thread asked for help constructing an XSL. After perusing other XML posts and studying their files, I've cobbled together an XSL but it doesn't work well. This thread is asking for insight on why the XSL isn't working, and how to avoid new record creation - I want to import into current record in FM.
  5. Hi. I in-elegantly posted a week ago without attaching my files. This time the files are attached. It's basically an XML order with buyer info and items ordered. I've also attached an XSL file that doesn't quite work. I've perused this forum for examples, but none are structured similar to my xml. I'm importing an XML response containing one record (buyer data), and varying number of child records (order items). The child records ('vendor bookid') is located in a portal within the db layout. So far, the first field ('email') imports successfully, but the rest doesn't. In addi
  6. consultant, thanks for the quick response. hadn't thought about splitting up the imports, good idea. but here's the issue, i get many responses some with just one order item, some with twenty. there is no fixed amount. what is the code language to loop the multiple items? this is what i'm scratching at. thanks.
  7. I have an xml response that I'd like to filter thru an XSL and import into filemaker. It contains the info for a standard order - buyer contact and several items ordered. Here is a sample response file - <?xml version="1.0" encoding="ISO-8859-1"?> <orderUpdateResponse version="1.0"> <purchaseOrder id="87047440DONOTIMPORT"> <buyer id="3392278"> <email>somebody@internet.net</email> <mailingAddress> <city>Manassas</city> <code>22204</code> <country>USA</country> <na
  8. I have an ecommerce site in which the inventory is also listed on another metasite (i.e. amazon, ebay, etc..). The metasite maintains its own separate inventory. I need to send a xml to the metasite's webservice whenever someone buys an item on my website. The purpose of this xml is to delete the item off the metasite immediately. I am using FMStudio for FX.php and Filemaker Pro 11. The delete xml will be generated upon payment confirmation from the buyer. It is autogenerated as a webpage. I also have a php page that sends a 'file_get_contents' to the webservice sucessfully -
  9. I'm looking at Send Event and DDE Execute. Are these the way to go?
  10. I am using Filemaker Pro 11 and wish to script an export XML file directly to a remote server. The export function seems to only permit local placement of files. Is there a way to script this so that the file will be uploaded to my webserver automatically? I'm trying to eliminate manually opening up an ftp program, scrolling around, etc...
  11. The XML file was accepted as is successfully. No need to work out the additional empty lines and missing tabs. Thanks for the help!
  12. Removing spaces, tabs, returns still yields the same two carriage returns when indent="yes". As for the reasons for a little space or two at the beginning of each line, eh, I dunno. I'm just following the API documentation example I was given - the provided sample XML shows small indentations. Well, lemme try to post the XML file to the webservice and see if it is successful or if I get errors because of the spacing issue. Again, thanks for all the help. It's been a tremendous aid.
  13. Ugh, it didn't show up again on my reply! Ok, here's another go at it - <?xml version="1.0" encoding="ISO-8859-1"?> <Website> *space*<UploadList> *space**space*<itemID> the item goes here </itemID> *space**space*<title> the title goes here </title> *space**space*<category> category goes here </category> *space*</UploadList> </Website>
  14. Wow. Thank you so much. By the way, I tried it with <xsl:value-of select="fmp:COL[1]/fmp:DATA" /> too. Same result. Any reason I'd choose with or without "fmp:DATA" suffix? Also, I'm still at sea with the spacing issue. I'm getting two carriage returns when I specify indent="yes" - ergo getting a full empty line between each line of code. I get NO spacing at all when I specify indent="no". Also the resulting XML needs to indent one or two spaces on a few lines as follows (sorry the spacing format didn't show up on my original post) - <?xml version="1.0" encod
  15. I would like to export to XML using an XSL stylesheet. But I'm such a newbie and unsuccessfully learning my way around the "for-each" and "value-of" verbiage. And I'm not doing such a great job with spacing either. I need a carriage return for each line and a single space indent here and there. The indent="yes" results in two carriage returns - one of them a fully blank line. There are 3 fields for each record I'm exporting - itemID, title and category. The output must conform to the following format - <?xml version="1.0" encoding="ISO-8859-1"?> <Website> &
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.