AnsweredAssumed Answered

Data Upload from Excel

Question asked by jveilleux on Apr 27, 2011
Latest reply on Apr 27, 2011 by jveilleux

Summary

Data Upload from Excel

Product

FileMaker Pro

Version

Advanced, version 11.0v3

Operating system version

Windows 7

Description of the issue

I've had to upload several thousand records, matching some and adding others.  Most upload OK, but I had some 500 that had 'errors' and did not get uploaded.  But when I repeat the upload, I'll have several (10 or so) that will upload and the rest contain 'errors'.  When I repeat the upload, I get a few more each time.  I recently got a new Dell Computer (Optiplex 780) with Windows 7.

Steps to reproduce the problem

Generate list of records to be uploaded in Excel
Import Records
select file (I've done it with both Office 2007 and Office 2003)
Match fields as needed

Expected result

All records uploaded.

Actual result

Several records do not upload.

Exact text of any error message(s) that appear

Import Summary:
Total records added/updated:  577
Total records skipped due to errors:  529
Total fields skipped due to errors:  0
Table created:

Configuration information

No

Workaround

Screenshot is in Microsoft word format

FMP_RecordUpload_Problem.png

Outcomes