since ‎11-05-2017
‎10-12-2019
eriku40433679
Level 2
Re: External Accounts and MySQL
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Thanks, I'll ask ops to have the server rebooted. Cheers,Erik

Views

570

Likes

0

Replies

0
External Accounts and MySQL
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi all,We have an external account configured to connect to MySQL. We've had to recently change the credentials so I've updated the account and password. Testing the connection also seems to be working fine. However, using the generic query editor on a schema that uses the account still tries to use the old credentials. Do I need to have the server rebooted or something?Thanks,Erik

Views

692

Likes

2

Replies

2
Re: Attaching a file generated by an export to a delivery
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi Jon,How do I go about setting up the file transfer activity to the midsourcing server? Do I need to set up an external account and where do I get the details to connect to it?Thanks,Erik

Views

5.8K

Likes

0

Replies

0
Re: Renaming Folders
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
This was caused by how the operators were created. When the admin first created the operator accounts, they had set the folder restriction on a per user level instead of applying group level permissions. For some reason, renaming the folders breaks these permissions and the operator accounts need to be updated, and the folder re-selected for it to work again.

Views

569

Likes

0

Replies

0
Renaming Folders
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi all,I have an operator group that's allowed access to only one folder just under the root path (e.g. /myfolder1) . Everything is running fine, but there is a recent push to organise all the different base folder names to standardise them so i renamed it to something more descriptive /My Folder 1/. Unfortunately, all operators in the operator group that had only access to this one folder is showing an access denied error on login. Users with access to other folders are able to log in with no p...

Views

652

Likes

0

Replies

1
Re: Attaching a file generated by an export to a delivery
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hoping someone can help with the last bit of info I need.Thank you,Erik

Views

5.8K

Likes

0

Replies

2
Re: Attaching a file generated by an export to a delivery
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Thanks yassinen, wodnicki. How do I go about uploading the file programatically? The original forum question and responses didn't mention an activity to have the file uploaded to the midsourcing server after the csv is generated via the Data Extraction (file) step. I can confirm that the file is in the .../public/export/myfile.csv.Thanks

Views

5.8K

Likes

0

Replies

0
Attaching a file generated by an export to a delivery
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi all,I'm trying to achieve the same thing as Raaghu on his thread here: Campaign Delivery- Attachment Unfortunately it seems that my delivery is failing and can't upload the file to the mid sourcing server.Do I have to prepare anything before the send? I can confirm that the file exists, as the file is present in the .../export folderThanks,Erik

Views

6.1K

Likes

2

Replies

6
Re: Webapps behind an ip whitelist
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Thank you for the help Jon! This is wonderful.Cheers,Erik

Views

585

Likes

0

Replies

0
Re: Custom/Sequential Ids
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi Pierre,This is excellent! Thank you Pierre. I didn't think of using a custom function for this. I was expecting the platform to have made it a bit more accessible because of the availability of counters. This is perfect.Cheers,--Erik

Views

928

Likes

0

Replies

0
Webapps behind an ip whitelist
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi,We have an on-premise installation of campaign and have a whitelist set up on the load balancer so only select ip addresses get to log in and use it. The approach however, prevents webapps from being publicly accessible. Is there a way for us to safely expose the /webapps easily or is this more an OPS/IT question rather campaign? I can only think off setting up Apache with modproxy on some box who's ip has been whitelisted on the elb. Anyone got a similar set up? How would the open/link track...

Views

757

Like

1

Replies

2
Re: Custom/Sequential Ids
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi Jon,Thanks for responding, I've thought about that approach as my backup. Apologies, I missed a detail in my requirements. The prefix text needs to be flexible. If I define it in the schema, I wouldn't be able to change it on the fly. temp may be brand1tempxxx, brand2tempxxx, etc..It's a start though. I could have the default set to tempxxx so they're added to the table that way on the insert step then filter for the temps generated immediately after and prepend the brand name. Any other way ...

Views

845

Likes

0

Replies

0
Custom/Sequential Ids
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi all,We have a system where we populate the account number field with the CRM id. We then use the account number as a foreign key to other schemas in campaign. My problem begins in scenarios where when we load entries that will never be loaded in CRM, so I must make up some unique account number for them, prefixed with some unique identifier like temp001020 or something. Account Number remains a varchar field.I've tried to setup a sequence in the database and added a calculated field in the en...

Views

2.0K

Likes

3

Replies

4
Re: Predefined Filter Permissions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Oh... I didn't think it was that simple. Hahaha. Thanks!--Erik

Views

567

Likes

0

Replies

0
Predefined Filter Permissions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Classic
Hi,How do I go about setting up predefined filters that only members of a certain group can see or use?Thanks,--Erik

Views

695

Likes

0

Replies

2
Downloading older versions of the AppMeasurement Library
Avatar

eriku40433679

eriku40433679
- Adobe Analytics
Hi all,How do I go about acquiring older versions of the library? Checking the code manager section in analytics's admin tab only gives me access to version 2.9.0. We're limited to 2.8.2 as we're using a tool that unfortunately doesn't support the latest one yet.Thanks!--Erik

Views

678

Like

1

Replies

1
Re: Data loading (file) custom date formatting
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Thanks for the info kapilsharma0101. I reckoned it would come down to a javascript step. I assume updating the enumeration (even if it wasn't dangerous) wouldn't let parse it properly would it?

Views

752

Likes

0

Replies

0
Data loading (file) custom date formatting
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi folks,I'm sure I'm not the first one to ask this question but I don't see any information on the documentation nor the forum with regard to custom date formats for this workflow step. As per the screenshot, the format field is a drop down and I need to parse in a strangely formatted UTC timestamp with. Does campaign have the ability to parse out only the relevant bits I'm after or do I have to tell the ETL guys to follow campaign's formatting?Thanks,--Erik

Views

1.4K

Likes

0

Replies

3
Re: Existing HTML Templates into Web Forms
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi guys,Since I haven't heard back from anyone after 5 days and couldn't find any thing specific in the docs, this may not be how Adobe intended the feature to be used. I'd like to share our workaround for anyone else who have to do the same thing. Please share your idea if you have a better one.We decided to keep the original form generated by Campaign but made it invisible via CSS. We then used our original HTML template as a static container in the Web app and used javascript to map the value...

Views

563

Likes

0

Replies

0
Existing HTML Templates into Web Forms
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi guys,We have a pre existing form that we want to host host within Campaign as a Web App form and serves to control certain fields of the recipient record. The raw html form has custom css and javascript to drive behaviour similar to Bootstrap CSS components butweI would like to tie the values of these components into the recipient fields.Is there an easy way to achieve this with out first starting with the HTML generated by campaign and having the design agency work around it?Thanks,--Erik

Views

984

Likes

0

Replies

2
Re: Updating a record from within a Javascript Step
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Excellent. Thanks Amit! Works like a charm. Hard coded the schema name as per your inline instructions and it works just fine for this specific workflow.I'd like to know if there's a way for me to use the schemaName variable I've already extracted on the first line to make the collection variable a bit more flexible?Cheers!

Views

1.4K

Likes

0

Replies

0
Updating a record from within a Javascript Step
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi guys,I'm trying to perform some string manipulation on the result set of a previous query. I'm using an intermediary Javascript step to contain the logic.var schemaName = vars.targetSchema.substr(vars.targetSchema.indexOf(":") + 1); logInfo(schemaName); var query = xtk.queryDef.create( ); result = query.ExecuteQuery(); for each (var e in result) { logInfo(e.@description + e.@id); // manipulation and assignment logic goes here // db update logic goes here}// better if the db update goes ...

Views

3.2K

Like

1

Replies

4
Re: RegEx Replace in Expressions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Thanks Amit, Florent. We've gone the route of least resistance and had the ETL guys take care of cleaning up the data before we load it into campaign. Going to try your suggestion when things calm down a bit.Cheers!--Erik

Views

632

Likes

0

Replies

0
Re: RegEx Replace in Expressions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Thanks Florent. If that's the case, maybe I can have a script read in the results of the query and have it write to a new column after processing, and use that for the comparison? Does the javascript engine used by AC have regular expressions implemented? Actually I'll make a quick check. hahaha!Cheers!--Erik

Views

631

Likes

0

Replies

0
RegEx Replace in Expressions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi all,I need to clean up a varchar phone number of all non-numerical characters to compare against the SMS logs. I was wondering if there was a way to do so easily, maybe preprocessing or a computed field?Thanks!--Erik

Views

1.3K

Likes

0

Replies

6
Re: JS object fields in expressions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Ahh. That's why. I've gone a different route to solve my problem but this is good to keep in mind for future implementations. Thanks for the help Marcel.Cheers!--Erik

Views

766

Likes

0

Replies

0
JS object fields in expressions
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi all,I'm building a lookup javascript object whose values I want to use in an enrichment activity as a calculated field. Here's an example of what i want to happenVariable:instance.vars.variableA={key:'value'};---Expression$(instance/vars/@variableA[@columnFromTargetingDimension])Hope I'm making sense. I need to read the associated value from the javascript object based on a field from the targeting dimension but i'm having problems with the syntax or if this is possible in the first place. I'...

Views

1.5K

Likes

0

Replies

2
Re: Variables in Update activity
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Will do. Thanks for all the help Vipul! Cheers!--Erik

Views

435

Likes

0

Replies

0
Re: Variables in Update activity
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi Vipul,Hahahaha! XDWe just cloned our tables on a dev instance and tried the script variables in a Query activity against an FDA table and it is working fine. Not too sure what's happening with the actual instance we're using, so it definitely seems to be an environmental issue.Sweet! How can I get my hands on 8850? I might build myself a new sandbox. Cheers, and thanks.--Erik

Views

394

Likes

0

Replies

0
Re: Variables in Update activity
Avatar

eriku40433679

eriku40433679
- Adobe Campaign Standard
Hi Vipul,Interesting. I'll take a closer look.Seems this is also the case when it comes to query activities against an FDA table? Can you confirm? We're on an old build, version 8594, if that helps.Cheers!--Erik

Views

427

Likes

0

Replies

0