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

icoggin
Community profile icoggin Level 2
Job title here
Location here
11 BADGES
Level 2

Level 2

Learn more
Joined the community 12-05-2021 6:50:24 AM
Offline
Top badges earned by icoggin
Customize the badges you want to showcase on your profile
Re: Reformatting a non mandatory date field in expression editor
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

85

Likes

0

Replies

0
Re: Reformatting a non mandatory date field in expression editor
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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 ...

Views

86

Likes

0

Replies

0
Reformatting a non mandatory date field in expression editor
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

114

Likes

0

Replies

3
Re: Convert System Date to mmddyyyy format
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

145

Likes

0

Replies

0
Re: Date Format Function in Adobe Campaign Standard
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

117

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no response
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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 ...

Views

273

Likes

0

Replies

1
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

301

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

311

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

318

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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. ...

Views

312

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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

Views

330

Likes

0

Replies

0
Re: Load File Activity: Uploading new file hangs with no...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

350

Likes

0

Replies

0
Load File Activity: Uploading new file hangs with no response
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

418

Like

1

Replies

15
Re: Adobe Campaign Load File. File structure change ignored
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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 ...

Views

133

Likes

0

Replies

0
Re: Adobe Campaign workflow Load File WDB-200001 error
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

136

Likes

0

Replies

0
Re: Adobe Campaign Direct Mail content want to display pe...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

158

Likes

0

Replies

0
Re: Adobe Campaign workflow Load File WDB-200001 error
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

207

Likes

0

Replies

2
Re: Adobe Campaign Load File. File structure change ignored
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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.

Views

214

Likes

0

Replies

0
Adobe Campaign Direct Mail content want to display pence, i.e. 1 as 1.00, 2 as 2.00 etc.
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

197

Likes

0

Replies

2
Adobe Campaign workflow Load File WDB-200001 error
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

228

Likes

0

Replies

3
Adobe Campaign Load File. File structure change ignored
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

246

Likes

0

Replies

3
Re: Please suggest this error's solution: The schema for...
Avatar
Affirm 3
Level 2
icoggin
Level 2

Like

1 like

Total Posts

22 posts

Correct reply

3 solutions
Top badges earned
Affirm 3
Ignite 5
Give Back 10
Ignite 3
Give Back 5
View profile
icoggin
- 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...

Views

251

Likes

0

Replies

0
Likes given to
Likes from