Hi Jürg, it seems that you calculate the data in the fields from an xml-text from a field, correct? Why don't you use xml/xsl-import? It is possible and actually no difficult at all to import from xml directly, using an xsl-file. After the import you can discard the xml-file, or when you import directly from an URL, you don't even have to do that.
I made an example a while back to import xml directly from the web into filemaker. The website I placed it on is in Dutch, but the example is in english as are the in file(s) comments. This particular example imports currency-rates from the European Central Bank against the euro, but the technique used is easy transferable to your own project: Currencies.zip
If you script the entries (Set Field ... ) then removing the original XML source will not change the values.
There is also import of the XML with XSLT, but you may not need it if what you have is extracting what you want.
-- sent from myPhone --
Have you seen the XML.Import function in MBS Plugin?
Imports any XML and build tables & fields automatically.
Wow! Thanks for the quick replies
I'm going to check out Import Records, although creating the XSL sounds like it could be time consuming! And thanks Menno for that sample file - that's going to be a big help.
Christian - I hadn't seen that feature of the plugin so I'll be sure to check that out too - thanks!
XSLT may or may not be time consuming, but once created can be used again and again 'as - is' unless the database structure and/or XML source schema changes.
You have the correct auto-enter calcs, correct? you can use them with Set Field(s) in Script and not have to change anything else.
I think I'll give the XSLT thing ago first and see how it goes. We're receiving cXML files so the XML schema is solid and won't change from under my feet which makes it worth investing my time.
To answer your question: yes, the auto-enter calcs are fine and have been for a long time now, I just don't think it's the best tool for this particular job. As you say, I could script it but I'm leaning towards importing the XML as it's something new to me and I like to learn new tricks (Next on the list is Virtual List so stand by for more questions from me about that!!!)
Thanks for your help as always.