since ‎16-09-2016
‎01-02-2020
domintune
Level 1
Re: Split column based on whether the field contains non...
Avatar

domintune

domintune
- Adobe Campaign Classic
I was unable to fix this permanently, I was forced to query the RDBMS for values not containing ":" for example. This is a mere bandaid for what I was trying to achieve but at least we can run BAU import again.

Views

1.4K

Likes

0

Replies

0
Split column based on whether the field contains non numeric values
Avatar

domintune

domintune
- Adobe Campaign Classic
Hi, I'm working on an import workflow, the data I'm receiving isn't clean. I need to map a string field into a long field. However the source RDBMS field contains values that has non numeric. I'm trying to manage this with either a split or a test but I'm getting nowhere as ISNAN(fieldname) isn't supported (apparently). Does anyone know how to work with this?

Views

2.4K

Likes

0

Replies

2
Re: Block Delivery Execution using SMTP Test
Avatar

domintune

domintune
- Adobe Campaign Classic
Hi Soura,I'm unsure why you wouldn't want to execute the delivery? The best way to be sure would be to do so.Thanks,Dom

Views

7.5K

Like

1

Replies

1
Re: Creating and configuring new folder hierarchies quickly
Avatar

domintune

domintune
- Adobe Campaign Classic
Thanks for getting back to me guys, really appreciate it!So I kinda gave up trying to find a solution on the internet. I ended up doing this manually. I calculated it was something in excess of 35,000 check boxes in the end. I feel like the answer is somewhere in between both of your replies.andreyt99885240​ I've had trouble with this, normally I build it out in our Staging environment and subsequently importing to Main. There are always issues with the operators/operator groups.Jean-Serge Biron...

Views

4.3K

Likes

0

Replies

0
Re: Creating and configuring new folder hierarchies quickly
Avatar

domintune

domintune
- Adobe Campaign Classic
I have subsequently created the folder structures manually. The fastest method I've found thus far is to manually create each folder but using keyboard shortcuts to create lists, folders, generic folders, personalisation blocks and campaign/delivery templates.I'm now working on a workflow that updates permissions from a CSV. Has anyone done this before? I've calculated that I will need to ensure that 35,000 tick boxes are ticked/unticked. Which is quite a laborious task.

Views

4.3K

Likes

0

Replies

1
Re: Creating and configuring new folder hierarchies quickly
Avatar

domintune

domintune
- Adobe Campaign Classic
I just want to bump this up as I've investigated this further and came up blank.

Views

4.3K

Likes

0

Replies

2
Creating and configuring new folder hierarchies quickly
Avatar

domintune

domintune
- Adobe Campaign Classic
Hi I work at a charity organisation with 25 different marketing silos who break their folder structure up by year. Each folder has its own unique Plans, Programmes, Folders, Deliveries. Lists, Campaign and Delivery templates. Each with their own respective permissions.Every year we will need to setup new folders for these teams with all the permissions and sub directories. This is really time consuming to setup and quality check.Does anyone know a super quick way of doing this or is it literally...

Views

4.7K

Likes

0

Replies

5
Likes from