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

Automate Adobe Classification Upload

silvial38314560
Level 1
Level 1

Hello Adobe Community!

 

I'm working on automating the classification upload to Adobe through FTP but I can't make it work.

1. I need to upload extra details about some IDs so I scheduled a weekly report from our data base to get that info, that report goes to our local FTP server (in a CSV (tab delimited) no header format).

2. In that local ftp server I have the header file (.txt) that is merged with the CSV file into a .tab file using a script.

3. Finally, we have another script that puts the new .tab file and the .fin file into the relevant Adobe FTP location.

 

Apparently there is some issue with this final step. Are you aware of any blockers that might prevent the file upload? Or is there a better way to automate this process? 

 

Thanks a lot in advance!

classification import FTP
1 Accepted Solution
Andrey_Osadchuk
Correct answer by
Community Advisor
Community Advisor
Silvia,
Could you elaborate on the issue you have faced on the final step?
 
Best wishes,
Andrey Osadchuk | Launch Inspector, Analytics Connector, Bookmarks

View solution in original post

6 Replies
Andrey_Osadchuk
Correct answer by
Community Advisor
Community Advisor
Silvia,
Could you elaborate on the issue you have faced on the final step?
 
Best wishes,
Andrey Osadchuk | Launch Inspector, Analytics Connector, Bookmarks

View solution in original post

silvial38314560
Level 1
Level 1

Hi Andrey,

 

I the ops team provided me with a very simple script: 

open sftp://stepstone-saongroup-jobs_5374697:password@ftp3.omniture.com/
put evar29_IJ.tab
put evar29_IJ.fin
exit

 

I've checked the files I can't find why they're not being uploaded to Adobe's ftp. I download the Classifications template and create all the files according to what Adobe suggests.

 

Thanks!

Andrey_Osadchuk
Community Advisor
Community Advisor
Once both files are on the FTP, the backend may start processing them right away (or with a delay). When this begins, both files get automatically deleted from the FTP so you will not be able to find them. I advise you to go to Classifications > Import > FTP and check if your email address is set for receiving notifications. This will allow you to be aware when the files get processed and whether they failed or not.
Andrey_Osadchuk
Community Advisor
Community Advisor
BTW, double check the user name for the Adobe Analytics FTP. The one you mentioned does not look correct.
silvial38314560
Level 1
Level 1
Hey! I do have the notifications enabled and they are sent to two different emails. I know it works because I receive the email when I do a manual upload and a copy of the SAINT file is saved in adobe's ftp.
Andrey_Osadchuk
Community Advisor
Community Advisor
Then it looks the FTP credentials may be incorrect or the script can't establish the required connection (maybe the network request gets blocked...)