Bulk adding/updating Plans

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?

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

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

Children
No Data