since ‎10-09-2019
‎24-08-2020
hugol_vallejo
Level 1
Re: How to Truncate a table? hugol_vallejo - Adobe Campaign Classic
Thanks MilanNever had used the SQL activity, so that was an easy one. Thanks for the quick reply
94
Views
0
Likes
0
Comments
How to Truncate a table? hugol_vallejo - Adobe Campaign Classic
Hi everyone I am trying to truncate the contents of a custom table in the Adobe Campaign database. I created that table to hold a set of data that is imported on a daily basis from an external file,but I need to truncate it before loading the data set. I know I could use the Update activity to delete records, but that requires an input. I could build that input by querying all data in the target table first and pass it to the Update activity, then the Update activity would delete the records fro...
107
Views
0
Likes
2
Answers and Comments
Seeds list randomly at delivery template level hugol_vallejo - Adobe Campaign Classic
Hi all I have this requirement to add a seed list to our main delivery but distribute the seed addresses randomly across the main output.I have uploaded the seed addresses and added them to the Delivery template, but when I execute the delivery all seeds addresses appeared at the top in the Delivery log window, so I am guessing they were placed at the beginning of the output list. When importing seeds in the email template directly, there is no option to select the insertion order. So I tried to...
123
Views
0
Likes
1
Answers and Comments
Re: Can I keep the system live during Bulk Update? hugol_vallejo - Adobe Campaign Classic
Thanks Craig.. make sense! Cheers
284
Views
0
Likes
0
Comments
Can I keep the system live during Bulk Update? hugol_vallejo - Adobe Campaign Classic
Hi everyone We are planning to perform a full refresh of the Adobe Campaign database using an external file that will be loaded through a workflow. Several attributes of the Recipient schema will be updated, along with their subscriptions. Missing accounts will be created too. The ideas is to request a full back-up to be taken before we start and stop all the pipelines that feeds data in and out of Adobe Campaign. From the testing performed in staging for this bulk update, and some benchmarks of...
343
Views
0
Likes
2
Answers and Comments
API logs Adobe Campaign Classic hugol_vallejo - Adobe Campaign Classic
Hi thereI am trying to troubleshoot a piece of JS code that controls the API endpoint in Adobe Campaign Classic. We have an external system pushing subscriber data using the API but recently we have been seeing a disconnection between the two systems, possibly because the parameters that the external system is passing through are incomplete, however the vendor insists all the data passed in the payload is correct. To check the data coming through into Adobe Campaign, I would like to log all the ...
1429
Views
0
Likes
1
Answers and Comments
Re: Do I Need a DB backup before making changes to DB structure? hugol_vallejo - Adobe Campaign Classic
Hi Prem KumarThanks a lot for your prompt response, that's great news
1543
Views
1
Like
0
Answers
Do I Need a DB backup before making changes to DB structure? hugol_vallejo - Adobe Campaign Classic
Hi allJust wondering if it is really necessary to take a planned DB backup before applying a change to the recipient extended schema? DB is about 10M records, I would not want to lock it by the schema update We do have a planned backup/deployment in conjunction with Adobe in a few weeks but I need to add a field now for an urgent requirementCheersHugo
2615
Views
2
Likes
2
Answers and Comments
Likes from