< ? php include( '../top1.php' ); ?> Error Codes: FileMaker Error 729 - Errors occurred during import; records could not be imported

Software Venture Consulting

FileMaker Pro downloads & Resources
FileMaker Custom Functions
FileMaker Web Viewer Examples
FileMaker Pro & Lasso Consulting
Training
FileMaker Books
FileMaker Articles
FileMaker Error Reference

Free Web Tools
Free FileMaker Tools

Personal Pages
Videos
Adventures
Links

Shopping Cart
Shopping Cart

Search:

Free Newsletter
Signup


Contact


Privacy Policy



FileMaker is a registered trademark of FileMaker, Inc. in the U.S. and other countries.

 

 Reference: FileMaker Error 729

FileMaker Error 729 : Errors occurred during import; records could not be imported

FileMaker Error Codes

Lasso Error Codes

MySQL Error Codes

Windows System Errors


About this database
This is a free public resource. It is unmoderated and operates on the "public virtue" system. I hope you find it useful!

User Contributed Notes

2006-09-18 20:40:00
Matt Sawyer

One of the most useless error codes ever devised. We know theres an error, a hint would be good

This is my note and I want to edit it | Report an inappropriate comment

2007-04-06 09:19:01
Ross Mackintosh
DataMate Solutions, LLC

I have been getting this error alot on a current solution. When I imported ALL fields I got no error. When I selected only desired fields, I got 729... Even weirder I tried process of elimination. First imported all fields no problem, took fields out of the import step a few at a time and it worked still. So I guess we have learned nothing :)

This is my note and I want to edit it | Report an inappropriate comment

2010-04-13 08:33:51
E.J. Sexton
TourTech Systems, Inc. http://www.tourtools.com

I ran into this problem when I was duplicating scripts and then modifying the "Import Records" script step for different tables. For some reason, the script step was not working for duplicated scripts.

When I deleted the "Import Records" script step and recreated it, the problem seemed to go away.

This is my note and I want to edit it | Report an inappropriate comment

2011-03-04 07:23:25
Kelly
n/a

I have this issue even when not using a script and importing a sample CSV file. It will import 3 of 10 records.
A new database with the same file works so it must be somewhere in this file. (not the data/format)

This is my note and I want to edit it | Report an inappropriate comment

2011-10-31 12:07:11
Wendy

I got error 729 when attempting to import into a locked record. Was expecting 301, but I suppose 729 makes sense.

This is my note and I want to edit it | Report an inappropriate comment

2012-02-26 17:11:39
Atalanta

I was banging my head about this lovely code. I tried not importing the fields that were validated and still got the error. Since I had a shared field (I'm importing to modify a found set) on the layout I tried to enter data into the field and got a much more useful error - Record is in use and unable to be modified. Ah HA! Once I exited the record (in the file that was to receive the imported data), it worked!

This is my note and I want to edit it | Report an inappropriate comment

2012-11-06 02:42:30
Gull-Britt Nylund
Norsult

Hi,
I got this error 729 by a customer as (wrongly) a field was imported into a field defined as having unique value. It worked for years correctly, and then suddenly the field to import contained a value already existing in the table.

This is my note and I want to edit it | Report an inappropriate comment

2013-02-11 07:28:40
anonymous

This error can also occur if an attempt is made to edit a database while someone is editing a record. Even if the "Waiting to Commit Changes" pop-up is canceled, this error can still occur as long as the database management window is open. Tested in FileMaker Pro Advanced 12.0v3 connected to FileMaker Server 12.0v3.

This is my note and I want to edit it | Report an inappropriate comment

2013-12-11 22:53:09
Peter Roots

Suddenly had this vague error on a scripted import, and a manual import would not work. When I tried to create a new record manually I then got the message that another user had Manage Database open; after they'd got out all was fine again.

This is my note and I want to edit it | Report an inappropriate comment

2014-05-12 13:09:04
Mike Beargie
Anvil Dataworks http://www.anvildataworks.com

We had a client experience this error in their file. It was due to the import destination having a field that requires a unique value. There were duplicate "names" in the source data for import, and we could prove that the record with the later creation would not be imported because the name was not unique.

Solved by removing the unique requirement temporarily and showing the client how to search for dupes.

This is my note and I want to edit it | Report an inappropriate comment

2014-08-22 13:42:24
Mike Beargie
Anvil Dataworks http://www.anvildataworks.com

We encountered this issue again on an import records script step. An ODBC / ESS table was the destination for the import, but the ODBC user had read-only access to the destination table.

This is my note and I want to edit it | Report an inappropriate comment

2015-11-29 10:44:07
Chiyoko Yoshida
chiyoFM, LLC http://www.chiyofm.com/

I just encountered this error with FileMaker 14. A scripted import brought in the data but I got this error. Turns out it was due to externally stored containers. My import script step need the option to "Preserve external container storage" checked in my case. This got rid of the error in my case. Hope it helps someone in the future.

This is my note and I want to edit it | Report an inappropriate comment

2015-12-21 12:21:04
Alex SL
http://filemaker1.ca

On my FileMaker database, I had a field with required not empty value. Since the import had empty values for this field, I got that 729 error.

This is my note and I want to edit it | Report an inappropriate comment

2016-04-22 17:46:49
Alex S

Alex SL I don't know how you figured this out but I also just got this error. It totally prevented me from importing by hand instead of script. Thanks for taking he time to post here guys!

This is my note and I want to edit it | Report an inappropriate comment

2017-09-13 08:00:51
DigitEL

Appears the following...

If importing with 'Perform Auto Enter options...' selected, check Field Definitions...
- No 'Always' Validation use 'Only During Data Entry', definitely causes props
- Consider disabling all Validations as possible
- Consider disabling all auto-enter calculations as possible
- Avoid LookUps in destination file if no relationships exist from destination file to where source file obtained lookup data
- Consider converting calculation fields to text/number/date data fields especially if destination file is for data storage
- In Import Field Mapping disable import from any fields that are not necessary to destination file purpose
- Summary fields seem ok if reference only internal data fields and can be useful...

Import of even 1 record may not work if any of above is in play...
I suspect if even one validation, lookup, calc, or relationship errors then import stops...

HTH
EL

This is my note and I want to edit it | Report an inappropriate comment

2017-10-05 06:17:21
Hubert

I can report another strange one with the import script step throwing error 729.
- The first import script step imports only one record from an xml source into a table to verify the xml source file.
- If the check succeeds and after a user confirmation a second import script step imports the data from the same xml source (options: updating matching records, adding remaining records).
- This throws error 729 on the second import; however, only on some windows machines, never on Mac's - the first strange behaviour.
- One user of an affected Win machine then waited about 15min(!) before confirming the import - it then worked. How strange is that?

I can only assume the script cannot access the file and therefore fails.

Hubert

There is some good news: This issue goes away with FM16...

This is my note and I want to edit it | Report an inappropriate comment

+ Add your own note
< ? php include( '../bottom.ssi' ); ?>