Jump to content
Salesforce and other SMB Solutions are coming soon. ×

Record import limited to 19,950 records


henryw
 Share

Recommended Posts

I am importing records from a Progress Database. I cannot import more than 19,950 records. I did an identical import into Excel and all 44,000 records came in fine. Is there way to correct this?

 

Henry

Link to comment
Share on other sites

There should be no such limit on importing into a FileMaker database. Is there an error or does it just import the 19,950 and show you the found set?

 

What is the Progress Database? Is this a FileMaker file? If so, does the found set in that file contain 19,950 records? If so, show all records (or close the file) and try the import again.

Link to comment
Share on other sites

There should be no such limit on importing into a FileMaker database. Is there an error or does it just import the 19,950 and show you the found set?

 

What is the Progress Database? Is this a FileMaker file? If so, does the found set in that file contain 19,950 records? If so, show all records (or close the file) and try the import again.

 

There is no error. If I perform a query that sets the condition of all records newer than where the last import ended the reamining records are brought in.

 

The Progress Database underlies Hagen, a print management software. No, it is not a Filemaker file. Progress is a database similar to Sybase.

 

Henry

Link to comment
Share on other sites

If I perform a query that sets the condition of all records newer than where the last import ended the reamining records are brought in.

I'm afraid I don't know what you mean.

 

After importing, what's does the import summary say? Does it list any errors? What's the found record count?

 

No, it is not a Filemaker file. Progress is a database similar to Sybase.

Perhaps there's a character in the text that's causing the import to stop.

Link to comment
Share on other sites

I'm afraid I don't know what you mean.

 

After importing, what's does the import summary say? Does it list any errors? What's the found record count?

 

 

Perhaps there's a character in the text that's causing the import to stop.

 

Three is no error. I understand if no one has hit this issue before. Is there a way to write a dynamic period of time into the "WHEN" of a query> I could work around this limitation if the query simply pulled all records frmo the last year. I can write the query with a static date to reference I just don't know how to specify "current year".

Link to comment
Share on other sites

You should be able to do your query in your Progress Database, selecting those records you wish to export into FileMaker. How this is done depends on your DBMS.

 

In any case, I've never seen a limit to the number of records that can be imported into a FileMaker file, so I'd conclude that either your source only contains that many records, or there is a problem with the data at that point. Without your files or cooperation, I can't troubleshoot further.

Link to comment
Share on other sites

This thread is quite old. Please start a new thread rather than reviving this one.

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share



×
×
  • Create New...

Important Information

Terms of Use