Kinook Software Forum

Kinook Software Forum (https://www.kinook.com/Forum/index.php)
-   [UR] General Discussion (https://www.kinook.com/Forum/forumdisplay.php?f=23)
-   -   impossible to import large .csv file (https://www.kinook.com/Forum/showthread.php?t=4043)

igoldsmid 06-01-2009 03:59 PM

impossible to import large .csv file
 
I have a .csv file with simple text, representing business contact records.

It has 10 columns and 350,000 rows (with some duplicates).

I tried importing it into UR Pro - (I have the latest version).

I started the import at midday, and the following morning at about 9am it was still not showing any signs of finishing - 21 hours later and counting. And indeed in the meantime, locked out of UR.

I tested the file with another information manager - Zoot, and it worked fine

So I gave up with UR.

Any ideas?

Thanks

igoldsmid 06-02-2009 04:08 AM

just imported the same file into a trial of ASKSAM - it completed successfully in just over an hours - therefore the file seems not to be the issue here...

kinook 06-02-2009 07:29 AM

UR uses a SQL database system and is optimized for searching, not inserting, so it could take a while to import that many records. You can still access other databases during the import by double-clicking the .urd file in Windows Explorer.


All times are GMT -5. The time now is 05:41 AM.


Copyright © 1999-2023 Kinook Software, Inc.