icoggin

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

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...

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

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 ...

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

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...

114

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

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.

145

Re: Date Format Function in Adobe Campaign Standard - Adobe Campaign Standard

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.

117

Re: Load File Activity: Uploading new file hangs with no response - Adobe Campaign Classic

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 ...

273

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

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.

301

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

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.

311

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

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.

318

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

I appreciate the support David. Its a credit card number field that is the issue so I cannot share. It does not get as far as uploading for the execution or file structure so the defintion of the field in Adobe has not even been set. It is a 16 digit field displayed as text (some start with a leading zero). It took some testing to find the credit card number field. If I removed the column the file upload worked, now I ahve tested it further to see what value(s) in that field might be the issue. ...

312

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

It wont be possible to share the file or even the offending column by itself due to confidential data items. I have also tried as a .csv this does not upload either with the same issue

330

Re: Load File Activity: Uploading new file hangs with no... - Adobe Campaign Classic

I can upload the same text file but with one column removed and it works. the column it therefore must fail on is a 16 digit numeric field stored as text. I have worked out that much but not what it is about that column which fails.

350

Load File Activity: Uploading new file hangs with no response - Adobe Campaign Classic

Hello all has anyone come across this one? I have plenty of space. Other files can load and this file looks like a completely ordinary 1.6k lines of tab delimited text. No column headers are very long or contain spaces or odd characters. If something was wrong with the file I would expect to see an error message from Campaign? I upload new file from local machine and all I then get is the Uploading "xxx.txt" message and nothing at all happens. If I click on "Confirm" the file has not been upload...

418

Re: Adobe Campaign Load File. File structure change ignored - Adobe Campaign Standard

In case someone searches on error message codes. I also got this again and the different error message for this: BAS-010048 The field 'Day' with value '30-13-52' in '30-13-52' is too long. Maximum of 2 characters.Again the sort code field was automatically detected as Date and then was again not picking up my change to Text. I had copied the workflow, deleted and re-added the activity all to no avail. But I overcame the error when I deleted the sort code field and manually added in a field with ...

133

Re: Adobe Campaign workflow Load File WDB-200001 error - Adobe Campaign Standard

Hi EwelinaKolacz. I do this on Adobe Campaign by clicking on Marketing Activities. I usally then change to List view ("change display mode" icon in the top right corner just below the user porifle icon) and I select on "workflow" in the tick boxes in the bottom left. Then enter in whatever the name is in the search box and hit enter. Once found, hover the mouse over the workflow and three icons appear on the right hand side. The middle of these is a "duplicate element" button (like two sheets of...

136

Re: Adobe Campaign Direct Mail content want to display pe... - Adobe Campaign Classic

Thanks LaurentLam. I was wondering if I would have to adopt such an approach. New double field created and used only for the segmentation. Old text field used in output. It works well.

158

Re: Adobe Campaign workflow Load File WDB-200001 error - Adobe Campaign Standard

Hello all - an update this which may help anyone coming across this in future. I spoke to my Adobe help and he indicated that the workflow or part of it had been corrupted. The workaround was to duplicate the workflow and start using the new copy. I did this (and also in the copy deleted the Load File and added a new one) and when I Started that copied workflow it went succesfully past the block and no more WDB-200001 error. Then deleting the old workflow and renaming my copy back to the origina...

207

Re: Adobe Campaign Load File. File structure change ignored - Adobe Campaign Standard

Thanks David It is definitely something like that. Clearing the cache and restarting will do the trick I expect. It eventually went away also after other edits and saves and restarts which I guess must have updated the cache.

214

Adobe Campaign Direct Mail content want to display pence, i.e. 1 as 1.00, 2 as 2.00 etc. - Adobe Campaign Classic

The input file has the field as a "0.00" (etc.) string but I need to check in a segmentation if the value is > 50. I cannot get the workflow to run without in the Load File activity, column definitions changing the field to as numeric. I use Float (double precision) to keep the decimals (i.e. the pence)Later I need to output this field into the Direct Mailing and need it displayed as "0.00" (etc.) again. I can use the function ToString on the field but it still displays as 0.So I was trying to u...

197

Adobe Campaign workflow Load File WDB-200001 error - Adobe Campaign Standard

Hello all. I had a recent workflow stopped working after a while with an error (see below) on the Load file step which had previously worked. I’m pretty sure I did not change that process although I did change other ones in the workflow. I tried deleting the Load File step and adding a new one back in. No change to the error message.Error Message: WDB-200001 SQL statement 'INSERT INTO XtkWorkflowEvent (iEventIdentifier, tsCreation, tsProcessing, sActivity, iStatus, iKeepResult, sTransition, iWor...

228

Adobe Campaign Load File. File structure change ignored - Adobe Campaign Standard

The issue I have seen several time is this. In a workflow, in the Load File process. I "Upload a new file from a local machine" this has UK sortcodes in it (e.g. in format 30-20-10). This file has about 60 columns so on the "File Structure" step I use the "Detect structure from new file" option.Then the UK bank sortcode field is auto-detected as a "Date". Before the Load File is saved and the workflow is run. I got to "Column Definition" and change the datatype for that sortcode field to "text"W...

246

Re: Please suggest this error's solution: The schema for... - Adobe Campaign Standard

This was a useful pointer. I had a workflow which did all sorts of enrichments and reconciliations, including one to Profiles. So on the face of it a different problem. What it was doing was using a reconciliation step to another schema. On the Reconciliation activity it had Identification option "Identify the document from the working data" checked and a target and join elements selected. After that I needed to have a later reconciliation step to profiles where it's identification option "Ident...

251

Likes given to

User

Count

Likes from

User

Count

Learn

Documentation

Community

Support

Resources

Adobe account

Adobe