Since there is a known issue using the Plans utility in V15 and it will only let me process 20 accounts at a time without erroring out, does anyone have a SQL query to add plans and workers?
Hi Tara,
I had to upload over 6000 plans recently and encountered the same issue and could only upload 30 at a time - I worked out that it would take me days to get them all done.
I wrote some very sloppy code to get the job done (used excel to concatentate values to import into the tables so I could check my work before import).
My plans were all for the same campaign. I was able to work out the fund and other values based of Vlookup data in the excel.
I had no time to write proper code (I just had to get the job done). Ran it in Test first to work out the kinks.
I'm a ramp user and hit on some issues where even with SQL you can't update more than 1000 rows at a time.
It was fiddly but I was able to get them all up and running with a bit of prep in a couple of hours.
I can share this with you if you like. Its by no means perfect but might help if you have a lot of plans to update.
Thanks
Louise
Louise Davidson said:could only upload 30 at a time
Isn't the Plans Maintenance bug biting at 50 rows? I think we are OK to 50 plans here.
Louise Davidson said:I'm a ramp user and hit on some issues where even with SQL you can't update more than 1000 rows at a time.
At over 1000 rows SQL will (always?) lock the table. Does RAMP somehow prohibit inserts of >1000 rows? Curious... (We are locally hosted)
A cursor or the like looping through a large batch of inserts at, say, 750 rows per insert, should work well.