Expand my Community achievements bar.

Join us at Adobe Summit 2024 for the Coffee Break Q&A Live series, a unique opportunity to network with and learn from expert users, the Adobe product team, and Adobe partners in a small group, 30 minute AMA conversations.
SOLVED

Automate Adobe Classification Upload

Avatar

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!

1 Accepted Solution

Avatar

Correct answer by
Level 10
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

Avatar

Correct answer by
Level 10
Silvia,
Could you elaborate on the issue you have faced on the final step?
 
Best wishes,
Andrey Osadchuk | Launch Inspector, Analytics Connector, Bookmarks

Avatar

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!

Avatar

Level 10
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.

Avatar

Level 10
BTW, double check the user name for the Adobe Analytics FTP. The one you mentioned does not look correct.

Avatar

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.

Avatar

Level 10
Then it looks the FTP credentials may be incorrect or the script can't establish the required connection (maybe the network request gets blocked...)