Use curl to add record to database

[Craig Taylor]

Hi

Is there an easy way to use a url to add a record to a fmp database. We have an update script on our mac clients that currently runs this to log an update occurence in a mysql database, passing it the date and asset no(host name) of mac. I would like to get this to log innto an fmp table.

[Martin Brändle]

If you have FMSA this should not be a problem. Please consult the FMSA Custom Web Guide for construction of the URL.

[Craig Taylor]

Hi

I have tried using the following url to add a record to a test database:

http://10.10.10.2/fmi/xml/fmresultset.xml?–db=test&–lay=Updated&AssetNo=1024&–new

the database test is enabled with full privs with guest access.

No records are being added, not sure why its not working or logging any errors?

Thanks

Craig

[Martin Brändle]

Did you add the fmxml extended privilege set?

[Craig Taylor]

Yep. it has all priv sets enabled

[Martin Brändle]

What is the error in the XML that is returned when you execute the query in a browser?