Newbies rhkodama Posted October 3, 2007 Newbies Share Posted October 3, 2007 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 More sharing options...
Cabinetman Posted October 3, 2007 Share Posted October 3, 2007 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 More sharing options...
Recommended Posts
This topic is 6178 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 accountSign in
Already have an account? Sign in here.
Sign In Now