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
BedrockMission!

Learn more

View all

Sign in to view all badges

SOLVED

addin custom table

Ramaswami
Level 4
Level 4

Hi Team, 

 

i have a requirement where i have give some data in excel like - empid, firstname, lastname, job description, category. 

for example 

empidfirstnamelastnamejob descriptioncategory
1abcefglkgefp
2dkfdkfjdkfkdfj

 

These respondents i need to load into adobe and i need to send emails for them with the survey link like below : 

Email body : 

Hi <firstname>

some bla bla bla ....

survey link : https://dfdjfdjf.com?category = <insert category>

 

So ideally i am thinking of ideas- 

1. do i need to create a new custom table for it and load the data in there and create a delivery template like above. But if i do like that on delivery template i think we can only allow the recipients from recipient schema and adding any other schema we need to look over target mappings which needs some work to be done and it's not suggestable as far as i read in the documentation. 

2. the second thing i am thinking is to map the columns given to recipient table for example 

first name -> recipient tables firstname

last name -> last name

job description -> some column in recipient 

category -> some column in recipient 

this way i don't need to check for anything directly import the recipients and send the email. 

 

Let me know which is the best way to do this. 

1 Accepted Solution
InMo
Correct answer by
Level 3
Level 3

Hi @Ramaswami,

 

Second option is best way as per me. First one is doable but required a lot of work.

 

Regards

View solution in original post

8 Replies
InMo
Correct answer by
Level 3
Level 3

Hi @Ramaswami,

 

Second option is best way as per me. First one is doable but required a lot of work.

 

Regards

View solution in original post

isahore
Level 3
Level 3

Hi @Ramaswami,

There is also another simpler way by which you can send the survey email to the email addresses listed in the file.

You can simply read the file in a workflow using the data load activity, and send the email directly to those email addresses. Just make sure to change the delivery mapping to "external file".

 

This way you won't have to create any custom schema or add these records into your recipient schema, and you can still use the other fields from the file for personalization (firstname, category, etc.).

 

Regards,

Ishan

Ramaswami
Level 4
Level 4

Hi @isahore,

 

i tried that way and i am getting some error like below : 

 

Ramaswami_0-1593968990587.png

 

Ramaswami_1-1593969023523.png

 

delivery error : 

Ramaswami_2-1593969082777.png

 

Ramaswami
Level 4
Level 4

hi @isahore,

 

i tried further like below and i am seeing some error: 

 

Sample file : sample.csv

Ramaswami_0-1593971392936.png

 

workflow : 

Ramaswami_1-1593971418195.png

 

Ramaswami_2-1593971447128.png

 

continous delivery : 

 

Ramaswami_3-1593971491738.png

 

 

delivery : 

 

Ramaswami_4-1593971572675.png

 

Delivery error : 

Ramaswami_5-1593971621614.png

 

logs : 

 

Ramaswami_6-1593971651938.png

 

 

 

 

 

 

 

 

isahore
Level 3
Level 3

Hi @Ramaswami,

You will need to upload the local file to the server as well. You might need to add an enrichment activity between data load and delivery activity (just to include any mandatory missing attributes, e.g. @email. This attribute missing from the targetSchema leads to an error in some typology rules).

Let me know if that helps.

 

Thanks,

Ishan

Ramaswami
Level 4
Level 4

Hi @isahore,

 

i have added enrichment activity too. 

 

Ramaswami_0-1594067900561.png

 

loading the local file into server : 

 

Data loading activity : 

Ramaswami_2-1594068290013.png

Ramaswami_3-1594068333987.png

 

at delivery 

Ramaswami_1-1594068244183.png

 

 

Ramaswami_0-1594068217805.png

 

Still i am getting the below error on delivery. seems there is some folder issue: 

 

Cannot open file '/usr/local/neolane/nl6/var/<instance name>/C:/Users/Ramaswami.Shakuntala/Documents/S3 downloads/sample file.csv' with read access (errno=2, No such file or directory)

 

Ramaswami_4-1594068409947.png

 

 

 

 

isahore
Level 3
Level 3

Hi @Ramaswami,

 

Try using the recurring delivery or a simple delivery instead of the continuous delivery. You should see the delivery mapping something screen like this:

isahore_0-1594154653944.png

and the workflow somewhat like this (as you have done already):

isahore_1-1594154785384.png

Let me know if that works.

 

Thanks,

Ishan

 

Ramaswami
Level 4
Level 4

Hi @isahore,

 

I wanted to use 'continous delivery' only we need to send emails for every week and don't want to fill up deliveries for each send. 

I used continous delivery without the query and enrichment activity : 

Ramaswami_0-1594224926928.png

 

Ramaswami_1-1594224955517.png

 

delivery : in the delivery i am uploading the file. 

 

Ramaswami_3-1594225046000.png

 

and i was able to send the deliveries like this and i am recieving emails but i am getting some error in contionus delivery though i don't see any problem in deliveries. 

in the logs i am seeing this: 

 

Ramaswami_4-1594225149056.png