Jump to content

Recommended Posts

Posted

Hi All, Having tested integration of people people data using the SQL User Import utility as per the Hornbill wiki, we have to import about 60k records. Is there any record limit on the utility?

Posted

@Joe

We have not come across one with our imports, but not quite as many as that.

What are you using as the source? We always used SQL Server or MySQL as the source rather than importing from a csv file, as that many using the odbc CSV driver might be asking a lot.

The other thing to note is that unlike the Request Importer you can not use multiple API Keys or concurrent sessions, so it will be a sequential process.

My habit with these things has always to do them in batches making sure you use a 'order by statement' in the select query so that you can easily back out or restart a batch from a know position.

Cheers

Martyn

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 account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...