Bulk adding/updating Plans

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 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!

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

Hi Louise,

Would you mind sharing your code with us too? We are working on updating hundreds of plans next week.

Thank you,
Lital 

Hi Louise,

We are also running into trouble uploading plans. If you're still willing to share your code, I'd greatly appreciate it.

Thanks!