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
Hi Louise!
We are also having this major problem and I would love to take a look at the code you used for the import as it looks like we will need to figure out how to add these in the backend.
Thank you!!
I would love to see your code!
I went ahead and wrote a process for this. I have not yet written out the step part of the procedure but the plan and worker portions work. It involves local staging tables as well as a need to import to a temporary table then insert into the staging tables. It also includes default values for our organization that would need to be updated but I would be happy to share!It's not perfect and absolutely must be tested but may be a good starting place!
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?
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.
Hi Louise, I too would like to see your code for import. We are only able to upload 10 at a time and it is very frustrated.
Does it apply to Step uploads as well?
Thank you,
Tatiana
Hello all, I just wanted to pass along the news that the Plans Maintenance defect is resolved in service pack 15.2.31, which is now available for downloadwww.tessituranetwork.com/.../Tessitura-v151-Download
thank you so much for this!
We upgraded just to get this functionality fixed and it's working great for us!