since ‎24-05-2017
‎10-12-2019
RamaRajesh
Employee
Re: Enrichment Help
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Kjac,Once you create the instance variable, you may not able to use the instance variable directly in the delivery (you can use it in the alert activity within the WF, though). Instead, create a variable (step 4) in the delivery properties (shown below) and use the script delivery.variables._var[0].stringValue = instance.vars.AKTEST in the delivery script (step 3).Steps:1. create a workflow (not a campaign with a workflow in it) with the type of delivery, shown below (which can be available o...

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Enrichment Help
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Here is the code for you from the screenshot.var query = xtk.queryDef.create( ); var resultSet = query.ExecuteQuery(); for each (var row in resultSet) { logInfo("From temp schema : " + row.@newFirstName); instance.vars.AKTEST = row.@newFirstName; logInfo("From instance variable : " + instance.vars.AKTEST); }

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Changes to mirror page code
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Adhiyan,This is amazing. Could you please share the screenshots, if available. I know this requires a lot of accesses and permissions to restart the services. But, this will be very useful at times.Thanks,Rajesh

Views

674

Likes

0

Replies

0
Re: Enrichment Help
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,I have also faced this problem where the target variable from Enrichment is not available/usable, sometimes (not sure of the reason though). I use a workaround for this and below is the process. Please see that the alias has been modified inside Enrichment output columns and the new field is called @newFirstName.Also referring to schema of enrichment the temporary table can be referenced using schema temp:enrich.Inside JS code activity, perform a queryDef call on this temp schema and then rea...

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Changes to mirror page code
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,Once the email has been deployed, i do not think we can make any changes.Thanks,Rajesh

Views

650

Likes

0

Replies

0
Re: Introduce yourself
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,My name is Rama Rajesh and I am working as a Sr. Technical Consultant (Adobe Campaign) at Adobe Systems, India. I have done my graduation from BITS, Pilani and I have 9 years of rich campaign management experience. I am an Adobe Certified Campaign Developer and Business Practitioner with experience into Database Marketing, Direct Marketing Analytics, Campaign management and Post Campaign Analysis using tools like Adobe Campaign, Adobe Target and Adobe Analytics.Thanks,Rajesh

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: Stock Alert during delivery - Technical understading
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Gunjan,Try to explore the technical workflow for Stock management. You may find some information there.Thanks,Rajesh

Views

996

Like

1

Replies

0
Re: AC v.6 Include again in the workflow excluded users
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Day0:Inclusion: Select customers whose Purchase date on or before current date - 7days and purchase date on or after current date -14daysExclusion: Exclude customers users who have already received another email in the same day (for example: birthday mail, product mail) Day1 and so forth:Inclusion1: Select customers whose Purchase date on or before current date - 7days and purchase date on or after current date -14days+Inclusion2: [Yesterday’s targeted population: Select customers whose Purchase...

Views

598

Likes

0

Replies

0
Re: SFTP deletes files automatically once processed
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Good to hear!Thanks,Rajesh

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: SFTP deletes files automatically once processed
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Gunjan,The File collector monitors the arrival of one or more files in a directory and activates its transition for each file received.The File transfer activity lets you receive or send files, test for file presence, or list files on a server. The protocol used is either Amazon Simple Storage Service (S3), FTP or SFTP.Other details about File collector and File Transfer can be found at the below link.Event activities I will check and get back to you, if there is an option not to delete the f...

Views

(val/1000)?string[".0"]}K

Likes

0

Replies

0
Re: SFTP deletes files automatically once processed
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Gunjan,If you are using File Transfer, you can follow the below process.The Advanced parameters... link lets you access the following options:Delete the source files after transfer- Uncheck this optionThanks,Rajesh

Views

(val/1000)?string[".0"]}K

Like

1

Replies

0
Re: Documentation on gettign started on Adobe campaign
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,The below link should help you.https://docs.campaign.adobe.com/doc/AC/en/browseAC.html Thanks,Rajesh

Views

698

Likes

0

Replies

0
Re: Adding Account # to an external Url for email campaign
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
That was for Adobe Standard version. For classic version (6.1.1 or 7), concepts should remain the same. I will check and let you know.

Views

821

Likes

0

Replies

0
Re: Adding Account # to an external Url for email campaign
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,If you are using Adobe Standard, the link below would help you for personalizing urls.Adobe Campaign Help | Personalizing URLs Thanks,Rajesh

Views

820

Like

1

Replies

0
Re: Schema for 1 operator Group
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
More information on the link below.https://docs.campaign.adobe.com/doc/AC/en/CFG_Editing_schemas_Protecting_schemas.html

Views

831

Likes

2

Replies

0
Re: Schema for 1 operator Group
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Yes, System filters let you manage the read and write permissions of entities detailed in schemas:readAccess: provides read only access to schema data.writeAccess: provides write access to schema data.&These filters are entered at the main element level of the schemas and, as shown in the following examples, can be formed to restrict access:Example 1:Here, the filter is used to disallow write permissions on the schema for operators without the named admin permission. This means that only adminis...

Views

867

Likes

3

Replies

0
Re: Implement testing and validation processes to ensure only authorised changes are promoted to Higher Environments
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,The package export wizard is accessible via the Tools > Advanced > Export package/Import Packagae... menu of the Adobe Campaign client console. There are three types of exportable packages:User package: it enables you to select the list of entities to be exported. For example: Export all recipients with average purchase amount>$50Platform package: it includes all added technical resources (not standard): schemas, JavaScript code, etc. Example: Exports the forms and schemas in your namespace.A...

Views

642

Like

1

Replies

0
Re: Implement testing and validation processes to ensure only authorised changes are promoted to Higher Environments
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Data packages let entities of the Adobe Campaign database be displayed via files in XML format.Each entity contained in a package is represented with all of its data.The principle of data packages is to export a data configuration and integrate it into another Adobe Campaign system.Below is the diagram for packaging:You can also find the documentation at Data packages

Views

592

Like

1

Replies

0
Re: I want to know the answer to the question about writing XML.
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Thanks Adhiyan!

Views

749

Likes

0

Replies

0
Re: I want to know the answer to the question about writing XML.
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
It should be option D.

Views

738

Likes

0

Replies

0
Re: Query filter "current date - N hours"
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Other useful list of functions for everyone's reference, below.Adobe Campaign Help | List of functions

Views

(val/1000)?string[".0"]}K

Like

1

Replies

0
Re: Query filter "current date - N hours"
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Example below:Select the less than operator. In the Value column, click Edit expression. For date processing, go to the Formula type window, enter "1" in Current date minus n days.Click Finish

Views

(val/1000)?string[".0"]}K

Like

1

Replies

0
Re: Deleting value
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
I know the sql way of doing it. Sorry, I am not aware of any other way.

Views

835

Likes

0

Replies

0
Re: Deleting value
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,Please try the below sql. Modify the sql with your table name and column name. All the values of the given column in the table will be deleted.Thanks,Rajesh

Views

846

Like

1

Replies

0
Re: Creating Ad-hoc tables
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,A table can be created out of an existing table (schema) of the data model or a new one (new schema). Once the table is created, we can upload the data by querying the existing table or using a flat file.A list can be created out of an existing table by querying (select all recipients from recipient schema where country= USA) it. Or, by creating a list and updating the list with flat file data.So, a list can be created out of the adhoc data which is not present in the data model, already.For ...

Views

(val/1000)?string[".0"]}K

Like

1

Replies

0
Re: Creating Databases and tables using SQL Commands
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi,creating the data model and the tables- As far as i know, It is possible only by creating a schema (xml, which defines the structure of a table) and updating the database for this schema creates a table out of that. PostgreSQL is used to query the tableAnyone- Correct me, if i am wrong.Thanks,Rajesh

Views

(val/1000)?string[".0"]}K

Likes

2

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
And finally the report looks like below.

Views

(val/1000)?string[".0"]}K

Likes

2

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Thomas,Please find the below report created out of a workflow.Thanks,Rajesh

Views

(val/1000)?string[".0"]}K

Likes

3

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
Hi Courtney,Please find the screens below.Thanks,Rajesh

Views

(val/1000)?string[".0"]}K

Likes

3

Replies

0
Re: Adobe Campaign Delivery Reporting
Avatar

RamaRajesh

Employee

RamaRajesh
- Adobe Campaign Standard
We could certainly pull the # of complaints or screamers by email. Below is the screenshot for reference.

Views

(val/1000)?string[".0"]}K

Like

1

Replies

0