Jump to content

importing records with XML


rhkodama

This topic is 6108 days old. Please don't post here. Open a new topic instead.

Recommended Posts

  • Newbies

I want to know how to add one record to an existing database using an XML file. I did an experiment where I exported an XML file from the same Filemaker database, deleted all but one record, then edited the remaining record to make it distinct from existing records in the database. Then I tried to import it, using "File"-"Import Records"-"XML data source", specifying that it should "add new records". What happens is that all existing records are deleted and the one record in the XML file is now the only one in the database. I'm supposing I need to make some changes in the syntax of the XML file in order to append it to the existing records, but I don't know how. Thanks for any help!

Link to comment
Share on other sites

I want to know how to add one record to an existing database using an XML file. I did an experiment where I exported an XML file from the same Filemaker database, deleted all but one record, then edited the remaining record to make it distinct from existing records in the database. Then I tried to import it, using "File"-"Import Records"-"XML data source", specifying that it should "add new records". What happens is that all existing records are deleted and the one record in the XML file is now the only one in the database. I'm supposing I need to make some changes in the syntax of the XML file in order to append it to the existing records, but I don't know how. Thanks for any help!

I'm doing a lot of this lately and still fairly new at it also.... but maybe I can help some.

A couple of things.. Can you post the single record XML? What XSL stylesheet do you use to import with? (maybe not needed since the structure is the same as the file in use) Are you sure they are deleted or is it only showing the one record after import? - Try show all'' from the 'Records' menu.

Link to comment
Share on other sites

This topic is 6108 days old. Please don't post here. Open a new topic instead.

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

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