Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Deb007
Community profile Deb007 Level 6
Mr
United Kingdom
31 BADGES
Level 6

Level 6

Learn more
Joined the community 16-03-2016 4:34:40 AM
Online
Top badges earned by Deb007
Customize the badges you want to showcase on your profile
Re: Move Duplicated Workflow into a Campaign
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @jhoyer_sd ,There is a difference between technical workflow and campaign workflow. There are some activities supported in one and not in other. And copying activities from one workflow to another workflow(which already has activities) may cause issues at times and not recommended. If you are sure that all activities are supported in campaign workflow, you can create a new workflow inside your campaign and copy all activities from your original workflow to your campaign workflow. Cheers,Deb

Views

109

Likes

0

Replies

0
Re: Schema data type for Numeric(10,2)
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @ACCUser19 ,The data type in schema shall be double. Cheers,Deb

Views

92

Like

1

Replies

1
Re: Filter output result different when string value given with and without single quotes
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @Greeshma_Sampath1 ,It is due to SQL not ACC. The comparison operator will return different result based on the data type of operand used in your case. That's why, when you pass '3' you are getting a different result than 3. If you want a proper numeric comparison, then the field shall be numeric one or you can write some expression to cast the values if you are sure about the possible values. Cheers,Deb

Views

105

Likes

4

Replies

1
Re: Who received the text version?
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @cbalaguer ,If it is "unknown", then the format is decided by recipient’s mail software.I will let you know if found any way to figure out the delivered format. Cheers,Deb

Views

136

Likes

2

Replies

0
Re: Who received the text version?
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @cbalaguer,If the emailFormat is captured in nms:recipient schema for recipients and the delivery is configured accordingly, then it will give you an idea of how many will get html or text version. https://experienceleague.adobe.com/docs/campaign-classic/using/sending-messages/sending-emails/sending-an-email/email-parameters.html?lang=en#selecting-message-formats I am not exactly sure how to know the format delivered to the recipient. If the "Mail Formats" in delivery is selected as "Let reci...

Views

140

Like

1

Replies

4
Re: Can I use two or more data schema tables for a single email delivery?
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @a-lopez,Yes, you can query multiple tables and use an email delivery to send emails.In a single query activity you filter data from recipient and delivery log. Also, if there is a link between your custom schema and recipient, it can all be done in one activity. Else you can use an enrichment to filter data based on a join condition. Cheers,Deb

Views

83

Likes

2

Replies

1
Re: The node of path is not stored as an independent SQL field
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
It depends on your Database.Do you know the underlying DB in ACC? Cheers,Deb

Views

111

Likes

0

Replies

1
Re: how download a file from azure blob
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @aarg,As per your above screenshot, I have seen the same behaviour earlier. In the “server folder”, if you put the directory and hat codes file name it doesn’t work. But if you mention the server folder along with file name in a variable it works. You can validate that in your workflow as well. Cheers,Deb

Views

133

Like

1

Replies

0
Re: Conversion of date and time format yyyy-mm-ddThh:mm:ss:sss to dd/mm/yyyy hh:mm:ss
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @ravitejagundu ,I hope the following mat help.1.import the the field a string in data loading workflow2. in an enrichment activity add a new column of datetime type3. Write an expression to convert the string to the new datetime field. Cheers,Deb

Views

112

Like

1

Replies

0
Re: Dynamic Date in Subject and email body
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @vinay049 You can try the following.It works for me. Subject: welcome email - <%= formatDate(new Date(), "%Bl") %>Body: <%= formatDate(new Date(), "%2D %Bl %4Y") %> Cheers,Deb

Views

293

Like

1

Replies

1
Re: Dynamic Date in Subject and email body
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @vinay049 ,Have you tried using formatDate()? It shall work. https://docs.adobe.com/content/help/en/campaign-classic/technicalresources/api/f-formatDate.html?hl=formatdate Cheers,Deb

Views

326

Likes

0

Replies

3
Re: JavaScript Functions in Expression Editor
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Thanks @Malarrajan_Sundarraj .At least, It is clear that cant be accessed from console.May I know the server file name and location? Cheers,Deb

Views

161

Likes

0

Replies

1
Re: JavaScript Functions in Expression Editor
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Thanks @ShrawanSaxena for your hep.But did you get this function definition any where in Adobe Campaign, like in any JS or SQL? Cheers,Deb

Views

175

Likes

0

Replies

3
Re: JavaScript Functions in Expression Editor
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
I am looking for definition of WeekDay() function.I couldn't locate that in xtk:postgresql-functions.sql. Cheers,Deb

Views

192

Likes

0

Replies

5
Re: JavaScript Functions in Expression Editor
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
By any chance you know the js file name?I had no luck finding the one. Thanks,Deb

Views

197

Likes

0

Replies

7
JavaScript Functions in Expression Editor
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi,I would like to know where the js functions present in expression editor in workflows are defined. Need to look into some OOTB functions.I could find some sql functions in Admin->Config->SQL that corresponds to the js functions, but couldn't locate the js function definition.Any help/hint is appreciated. Thanks,Deb

Views

216

Likes

0

Replies

10
Re: How to Filter Data from a single schema based on geography
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @bhaskarc1289447 ,You can create three different named rights(cus:inaccess,cus:slaccess,cus:chaccess) for the geos and assign the named rights to operator groups for the specific geo.the add the following sysfilter to the schema. Cheers,Deb

Views

156

Like

1

Replies

0
Re: How to Filter Data from a single schema based on geography
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Sure.May I know, how many possible values are there in geography schema and some samples? Cheers,Deb

Views

181

Likes

0

Replies

2
Re: How to Filter Data from a single schema based on geography
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @bhaskarc1289447 ,You can achieve this using sysfilters. Cheers,Deb

Views

185

Like

1

Replies

4
Re: First time I am setting up an AWS file transfer, help
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @TakL ,From the error it seems you haven't set up the server in the External Account.You can get the info from AWS team.Also the "server folder" set up in the File Transfer activity shall be the simple folder path. Cheers,Deb

Views

106

Likes

0

Replies

0
Re: Any solution to save message center mirror pages ?
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @roro_coeur ,Is it just the mirror pages you want to download specifically or the emails?There is an option to archive emails by keeping an inbox in BCC. https://experienceleague.adobe.com/docs/campaign-classic/using/installing-campaign-classic/additional-configurations/email-archiving.html?lang=en Cheers,Deb

Views

107

Likes

0

Replies

1
Re: Workflow duplicated but get data schema warning error
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @TakL ,I had the same issue in past.It mostly happens in during copy paste where the reference between activities with their name is lost.Try to make a duplicate(instead of copy paste) of the workflow that is working properly and edit the duplicate workflow. It shall work fine. Cheers,Deb

Views

131

Likes

2

Replies

0
Metadata in Control Panel SFTP Key Management
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Description - There is no Metadata captured when adding anew key in Control panel SFTP-Key Management.Why is this feature important to you - In a bog project if you need to remove or amend any of the keys in the list it is almost impossible to fig out out. How would you like the feature to work - if there can be few more columns added like Date added(readonly), Modified(readonly), Modified By(readonly) and description it will be easy to manage.Current Behaviour - It has only two columns user nam...

Views

35

Likes

2

Replies

0
Re: New Experience League Community game features and FAQs
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Experience Cloud
Gamification is a great ide.Thank You.

Views

2.8K

Like

1

Replies

0
Re: ☕[Adobe Campaign Community Q&A Coffee Break] Sep 2nd, 8am PT: Arthur Lacroix, Product Marketing Manager☕
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi,Are there any features available in V7 that will be obsolete in V8?Is there any migration guide doc for this? Thanks,Deb

Views

235

Like

1

Replies

1
Re: Error while Data Loading (File)
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @Aks333 If there is no encryption and Decryption, then we don't need to use the pre process file option.Can you try using a file collector activity instead of uploading from local machine and in the data loading activity select the option, "specified in transition"? Cheers,Deb

Views

158

Likes

0

Replies

0
Re: Error while Data Loading (File)
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @Aks333 ,Are you using and encrypted file? If so, you need to1. select the "Pre Process File" option.2. Use '|gpg --decrypt /x/x/xxx.pgp' command to decrypt or 1. use it with a file collector activity.2. select the "Pre Process File" option.3. set <%= vars.filename %> in the command Cheers,Deb

Views

167

Likes

0

Replies

3
Re: Error while Data Loading (File)
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @Aks333 ,Are you picking up the file from sftp or it is one off file from your local machine?It will be difficult t solve the issue without looking at the config of the data loading activity.If you are uploading a file from local make sure it is uploaded to server before running the workflow. Cheers,Deb

Views

177

Likes

0

Replies

6
Re: Coupon Module Status on the Coupon Value table does not change from Available to Consumed when assigned
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @hetfidd,We had the same issue and the only solution could come up with was to create a different scheduled workflow to update the status.The status is stored in "nms:couponValue" schema. All the used coupons are linked to a broadlog record.If the status is Available and message-id>0, then you can set the status to "Consumed" or you can extend the "nms:couponValue" and set to different enum value according to you requirement. Cheers,Deb

Views

118

Like

1

Replies

0
Re: Double quotation marks got inserted when importing a...
Avatar
Contributor
Level 6
Deb007
Level 6

Likes

72 likes

Total Posts

115 posts

Correct reply

30 solutions
Top badges earned
Contributor
Shape 1
Establish
Springboard
Give Back 100
View profile
Deb007
- Adobe Campaign Classic
Hi @alik98709228 ,I guess you are using a data loading activity here.When you set it up by default it sets the data type as string and hence you are seeing double quotes.If the "Auto-detect Format" doesn't work you need to click on "click here to change the file format"(as mentioned by Cedric) and change the data type as required. Thanks,Deb

Views

165

Like

1

Replies

0