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
This sounds (unsurprisingly) excellent.
We're we at a SQL training session at a conference on year when we asked Annie Rolph about the 1000 rows?