since ‎20-06-2017
‎10-12-2019
sqwgglz
Level 2
Re: Data loading (file) errors sqwgglz - Adobe Campaign Classic
Hi Deb,Thanks for this, the File Collector activity fixed the job.Wanted to understand why this happened though?Is there a limit to the size of file the data loading (file) activity can handle?ThanksKevin
1248
Views
0
Likes
0
Answers
Data loading (file) errors sqwgglz - Adobe Campaign Classic
Trying to upload a file but two errors appear(before it says its successfully uploaded.but when I run the workflow, the dataload errors with this message:I don't understand why the file isn't loading. What do errors (4) and (14) mean: I can't find documentation on them.Any help will be appreciated.ThanksKevin
2170
Views
2
Likes
3
Answers and Comments
[ACC V6.1.1] Grouping campaign statistics by recipient sqwgglz - Adobe Campaign Classic
Hey gang.This is probably a really easy question to answer but I'm having a dumb day.Basically I want to find Recipient X and count the number of deliveries they've received, opened and clicked.So the output is something like this:Help me Adobe Gods.Kevin
1762
Views
1
Like
2
Replies
Re: [ac6.1.1] Quick Maffs... sqwgglz - Adobe Campaign Classic
Hi Deb,You know, I thought the above was such a simple solution, it wouldn't work, so I didn't even check it.Wish I did now, as it worked perfectly Thanks!Kevin
1153
Views
1
Like
0
Answers
[ac6.1.1] Quick Maffs... sqwgglz - Adobe Campaign Classic
Hi gang,Sorry for the Big Shaq joke in the title, and for the potentially easy question but I want to make an Enrichment workout a sum using a field on my system and an integer I give it.Has anyone had any luck doing this kind of thing?I have a field named points that changes all the time and I want to find people who have less than 250 and give them the amount they'll need to reach 250.Hope this makes sense.Thanks!Kevin
1936
Views
2
Likes
2
Answers and Comments
Re: Auto-reply email setup? sqwgglz - Adobe Campaign Standard
Hi florent, This is what I'm looking for actually - a generic auto-reply that is sent to the recipients responding to either the sender or reply address?Is it at all possible to set-up?ThanksKevin
1004
Views
1
Like
0
Answers
Re: [AC6.1.1] Changing display properties in QR Barcode sqwgglz - Adobe Campaign Classic
Thanks for your help guys.Didn't think this was something we can request. How do you ask Adobe for this? Through neolane support?
4523
Views
0
Likes
1
Replies
[AC6.1.1] Changing display properties in QR Barcode sqwgglz - Adobe Campaign Classic
Hi guys,Wondered if anyone has had any success changing the current white and black QR codes into something different: say a white code on a dark blue background.Also does anyone know if there’s a border built into the generated QR code image or not?Thanks!Kevin
4830
Views
2
Likes
4
Replies
[AC6.1.1] Stats for Forwards and deletion without open. sqwgglz - Adobe Campaign Standard
Hi there,Hoping someone can help.Has anyone been able to pull the following stats from Campaign.- Forwards (rec has forwarded email to another email address)- Deletion without open (i.e. rec has deleted the email before opening)ThanksKevin
518
Views
0
Likes
0
Answers and Comments
Journal entries sqwgglz - Adobe Campaign Standard
Hi all,Wondering if anyone knows the list of activities the journal picks up or if you're able to edit this?I ask because the Test function in Flow control doesn't and I'd like to see this pull through here.ThanksKevin
621
Views
0
Likes
1
Answers and Comments
Re: Adobe Campaign Standard Query for Birthday sqwgglz - Adobe Campaign Standard
Hi Marcel,Doing it your doesn't take the year into consideration.You say birthday (i.e.DD/MM) but it's actually the date of birth (i.e. DD/MM/YYYY) so saying X date is equal to date of birth would almost always pull incorrect information (as it's very unlikely a recipient will have a date of birth in 2018!)
1480
Views
1
Like
0
Answers
Re: ACClassic v6.1 - Coalescing "birthday fields" into one delivery. sqwgglz - Adobe Campaign Standard
The function you describe wouldn't work as it doesn't take into account the year.i.e. DateOnly(today) would look like 13/07/2018 and no-one subscribed would have a birth date in 2018!The loop function is interesting though...
938
Views
0
Likes
0
Answers
Re: Introduce yourself sqwgglz - Adobe Campaign Standard
Hiiiiiiii,I'm Kevin, I've been working with ACS for just over 2 years as a ... email marketing specialist?Work in a team of three supporting 6 national brands. I've posted a couple of "has anyone ever worked out how to do this?" kind of questions in the forums already and I'm happy to add my own weird findings as I find them too. Looking forward to e-talking to you all Thanks
24144
Views
0
Likes
0
Replies
ACClassic v6.1 - Coalescing "birthday fields" into one delivery. sqwgglz - Adobe Campaign Standard
Hi everyone, I asked this a couple months back so I'm re-writing in the hopes someone can help with this.Our company have a bespoke table that holds up to 10 friends/family members' names and birthdays:And I've created a birthday journey for all of them that will send an email to them if they met my criteria (in this case their birthday is in 14 days). Problem is it looks like this:Ew. Right? It's very hard to read and if one of these fails for any reason the rest won't get sent.The dream would ...
1749
Views
0
Likes
3
Answers and Comments
Re: Adobe Campaign Standard Query for Birthday sqwgglz - Adobe Campaign Standard
Hey, I know this is a little old but It might be better to look for people who have a birthday coming up instead by using the AddDays function. For birthdays in 2 days for instance, use:Month(@birthDate) = Month(AddDays(GetDate(), 2) and Day(@birthDate)=Day(AddDays(GetDate(), 2)
1484
Views
0
Likes
0
Answers
Re: Send a birthday email about the "correct birthday" sqwgglz - Adobe Campaign Classic
If anyone has any suggestions as to how if can be done (if at all possible) do let me know
1202
Views
0
Likes
0
Answers
Re: Send a birthday email about the "correct birthday" sqwgglz - Adobe Campaign Classic
Sorry for late reply. Yes it's for Campaign Classic.
1205
Views
0
Likes
0
Answers
Send a birthday email about the "correct birthday" sqwgglz - Adobe Campaign Classic
Let me explain:We have a Loyalty table that holds up to 10 friends/family members' names and birthdays.I want to be able to send an email that looks at all those records and pulls out the family member and birthday that meets my criteria (i.e. birthday is in 14 days) as well as enrich the email with that guests' personalised information (i.e. name or age).i.e. I have the Query I want, which will find anyone's birthday 14 days from now: but how do I find out which of the 10 meets that criteria so...
2641
Views
1
Like
5
Answers and Comments
Re: Error while evaluating document sqwgglz - Adobe Campaign Standard
Hey all,Sorry for the late reply.So I found out that the preview system wasn't working, but on sending a full test to myself, the above actually worked and calculated the points correctly.We can mark this as closed.ThanksKevin
681
Views
0
Likes
0
Answers
Re: Inserting other personalisation fields while creating a landing page sqwgglz - Adobe Campaign Classic
Hi thanks both for your reply, I didn't realise changing the Properties on the flow would change the fields the App could look at.To answer your question Florent, yes, all fields would be related to the recipient. So when they click on the link, they're taken to a web page that displays their information to print out. Here's a screen grab from the Page element. The fields with "%%" around them are the fields I'd like personalised. I've managed to find the membership no, first name and last name ...
1430
Views
0
Likes
0
Answers
Inserting other personalisation fields while creating a landing page sqwgglz - Adobe Campaign Classic
Hey gang,I've been reading creating a landing page here as I'm trying to make a "printable voucher", however I can only access the recipient table, which doesn't hold the data I want to personalise the page with. Is it possible to link to other schemas/tables or am I stuck with just the recipient table?ThanksKevin
6388
Views
3
Likes
13
Answers and Comments
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Thanks Amit,Option 2 worked for me perfectly. ThanksKevin
1543
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Hi Jyoti,Thanks for reply so quickly.I added DateOnly() to the enrichment..but all it did is set the time as 00:00:00.. I was thinking of using formatdate() in the delivery but it will only work with system date... any other suggestions?ThanksKevin
1410
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Note: I was expecting dates like this:
1403
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Hi Jyoti,Interestingly, I sent it to myself and the dates did compute as you suggested, though not as I intended.Any ideas how to change the format to something else?- Kevin
1395
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Thanks Rajesh, I'll see if I can replicate.
1408
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Thanks for this Rama,It's a little hard to see your screenshot in its entirety.Would you be able to upload a larger screenshot?ThanksKevin
1405
Views
0
Likes
0
Answers
Re: Enrichment Help sqwgglz - Adobe Campaign Standard
Hi J-Serge,Yes, my screenshots were from the delivery inside my workflow.Any other suggestions?- K
1424
Views
0
Likes
0
Answers
Enrichment Help sqwgglz - Adobe Campaign Standard
Hey everyone,Hope someone can help.I'm trying to enrich an email with some custom date fields which will act as the validity dates for the customer - I've added these in an enrichment.Here's my workflow - you might be able to workout that it's a birthday trigger email.You'll see inside my split is nothing insane:And here's my Enrichment:When I hit "Edit Additional data.."And going back to the Reconciliation table:Note: I wasn't sure if this was necessary or not but hey ho!Anyway, when I add thes...
8250
Views
0
Likes
16
Answers and Comments
Re: Error while evaluating document sqwgglz - Adobe Campaign Standard
shrawans31530030 unfortunately not.
609
Views
0
Likes
0
Answers