Automate Adobe Classification Upload

[#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!

[silvial38314560 · Accepted solution]

Silvia,

Could you elaborate on the issue you have faced on the final step?

Best wishes,
Andrey Osadchuk | Launch Inspector, Analytics Connector, Bookmarks

[silvial38314560 · Accepted solution]

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 · Accepted solution]

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 · Accepted solution]

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

[silvial38314560 · Accepted solution]

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 · Accepted solution]

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