icoggin

Adobe Campaign Standard Direct Mail - how to order the output by a given specific field - Adobe Campaign Standard 13-01-2022

Hello all. We have a requirement to be able to sort our mailing output by account number - so as to better see the joint accounts (with two rows) and make checking mailing proofs much easier. We don't want to filter out any rows just change the order of the output.I can see there are "windowing" or representation functions such as Desc and OrderBy but I get error messages about invalid aliases when trying to use them on the account number field and I suspect they might be meant to generate QUALI...

139

Re: Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 13-09-2021

I did get to a solution for this (or at least a part solution). Somewhere the default date was set to YYYY/MM/DD but I could not get it turned to DD/MM/YYYY format as a default. However - for Direct Mailings (DM) at least - I could get the format I wanted - for dates fields that are only sometimes populated. It does not need the expression editor for DM.The solution:edit the Direct Mail Delivery activity, Click on the Content area to edit that, click on the "File Structure" tab, Go down to the D...

196

Re: Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 13-09-2021

Thanks for the reply JyotiThe two suggestions you give under the OR parts of the reply will not work for this specific query. They only work where the data is always populated like GetDate() - they do NOT work for my specific query where the date is only populated some of the time. They are lifted from other posts and do not include the date separator I need.As for the "<%= formatDate(targetData.Date1, "%2D/%2M/%4Y") %>" option I have not tried this. I do not think it is part of what would work ...

197

Reformatting a non mandatory date field in expression editor - Adobe Campaign Standard 07-09-2021

I have a requirement to output date in the format DD/MM/YYYY. However, our Adobe Campaign Standard has a default date format of YYYY/MM/DD. I do not have system admin access and have no idea if we can change this default format. That would be good to know as a possible solution but for now I need to reformat from YYYY/MM/DD to DD/MM/YYYY. The excellent solutions such as the ones below only work for a field that is populated all the time. I need something different for a date field that is someti...

228

Re: Convert System Date to mmddyyyy format - Adobe Campaign Standard 03-09-2021

Thanks David. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time? When the date is not present the value output into the field is "00". Is there anyway to overcome this. I have tried various functions, e.g.IsEmptyString(datefield) - with and without ToString(datefield) - Iif(datefield IS NULL, Iif(Length (datefield) = 0 , etc. etc,. and nothing gets parsed.

285

Re: Date Format Function in Adobe Campaign Standard - Adobe Campaign Standard 03-09-2021

Thanks Anil. That works for GetDate() but what happens if you apply the formula to a field in which the date is only present some of the time/ When the date is not present the value output into the field is 0/0/. Is there anyway to overcome this. I have tried various functions and nothing gets parsed.

4.1K

Re: Load File Activity: Uploading new file hangs with no response - Adobe Campaign 13-08-2021

Hi Sukrity. In the end we did not really get to the root cause of it. In itself the file size was not an issue as both a colleague and myself had the issue in the end with the same sort of number as text (with leading zeroes needed). With that field altered the files loaded. with very small files it loaded but big files with that field failed to load. something else was happening.However we do not no what Adobe was doing differently to that field. Our support could not reproduce it but after he ...

602

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 04-08-2021

No worries minakshis868318 it is an obscure one as well as confidential info, I will hope to be able to get to a resolution with the support team to share back here.

630

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 03-08-2021

Sorry minakshis868318 I thought I had replied to this. I do not have system admin access to get to the audit logs. I have asked our named support people to get into them and investigate further. If nobody on the community has come across this hopefully their extra access can help us.

640

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign 03-08-2021

Thanks for the suggestion minakshis868318. I see something slightly different in the web interface but it does not get as far as allowing me to change the datatypes of the fields in file structure. It hangs when uploading the file and never gets as far. Also I need to keep it as string. It holds digits but some of them have a leading zero which is valid so it needs to remain as a text datatype.

647

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe