I am not sure if I am going to word this correctly, but here it goes

I have two scripts, both of which work perfectly:

export.php - this extracts data out of a DB and passes it via a form to another script that imports the data into a web based CRM using their API. There are as many as 5 - 10 K records that are being passed to the import.php

import.php - This inserts the data into the online CRM's database via SOAP. I have been testing it, limiting the number of inserts/updates. It can handle small amounts of data that it is being passed. There are around 30 fields being passed.

I was wondering, and vbullitin does this in some of their maintanance scripts, How I could set a vaule so this script will do as a set number of records at a time, say 250, and then refresh, and move onto the next 250, and so on, and so on

Does anyone know of a tutorial or might have done something like this in the past and can give me an idea.

Too much code to put in here, I am attaching these in a zip file

Thanks in advance to anyone who replies to this!

Mike

    Well, you'd probably have to do a loop. Start a persistent connection to the database, start the loop with a counter. Execute 250 queries, refresh, execute 250 queries, refresh.

    You could download SMF (www.simplemachines.org) and look at their private messaging system. If you send over like 500 it splits it up and does exactly what you want (even adds a button to manually refresh if needed).

      Write a Reply...