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

Ad Hoc Analysis to FTP

Avatar

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
alyssaf70800843
Level 1

24-04-2018

I have been trying to setup sending reports to an FTP server, but nothing appears to be showing up.  I have tested the credentials, whitelisted the IP blocks, the status bar says "Sent!", and the Ad Hoc log doesn't indicate any problems - but I am not seeing the files on my server.

Does it take a while to send? I'm struggling to see if there is a problem with how I am setting it up, or something else.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

08-05-2018

If you're able to log in to the FTP site and create a blank text file on the server, the tool should also be able to create a scheduled report.

This might be one to send to Customer Care. Provide them with the login company, user, project name, and FTP credentials. The agent should be able to troubleshoot from there.

Answers (4)

Answers (4)

Avatar

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
alyssaf70800843
Level 1

07-05-2018

I am on a Mac so I can't attempt that, but I can connect through my FTP program just fine using the same credentials.

Avatar

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile

Avatar
Coach
Employee
Gigazelle
Employee

Likes

473 likes

Total Posts

1,947 posts

Correct Reply

740 solutions
Top badges earned
Coach
Contributor 2
Validate 1
Ignite 80
Ignite 70
View profile
Gigazelle
Employee

04-05-2018

Hi Alyssa, are you able to log in to the FTP site using the credentials you have via WIndows Explorer, and create an empty text file on the FTP site? Between all those actions, there should be no issues getting a report scheduled.

Avatar

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile

Avatar
Validate 1
Level 1
alyssaf70800843
Level 1

Likes

0 likes

Total Posts

3 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
View profile
alyssaf70800843
Level 1

24-04-2018

Rob

Thank you for your help.  The system does not allow me to continue if I leave the port blank.  I am using FTP (not sFTP) and tried using the full FTP URL to no avail.

Avatar

Avatar
Validate 1
Level 2
refergusonclt
Level 2

Likes

7 likes

Total Posts

14 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile

Avatar
Validate 1
Level 2
refergusonclt
Level 2

Likes

7 likes

Total Posts

14 posts

Correct Reply

1 solution
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 1
Applaud 5
View profile
refergusonclt
Level 2

24-04-2018

A couple of things to try:

When sending to FTP via Ad Hoc...

  1. Try using the full FTP address: ftp://ftpsite.site.com
  2. Try leaving the port number empty

For SFTP (Secure File Transfer Protocol), all the information you need is here: Secure File Transfer Protocol

When sending to SFTP via Ad Hoc/Data Warehouse, you will have to have the authorized_keys file in the ...

  1. Per Adobe's instructions found here (https://marketing.adobe.com/resources/help/en_US/whitepapers/ftp/ftp_sftp_dw.html) you need to obtain the authorized_keys file which is in the .ssh directory within the root directory of the user you log in with
  2. To obtain the authorized_keys file, you have to send a request to Client Care via one of your organization's supported users
  3. Adobe will probably send back two files: (1) authorized_keys_RSA.txt and (2) authorized_keys_DSA.txt
  4. Use the RSA file but save it as a file, not as a .txt file naming it "authorized_keys"
  5. After this file is obtained, log in to the FTP site under the same credentials that are used for the Data Warehouse request.
  6. In the root directory, navigate to the folder named .ssh (if one does not exist, create one) and place the authorized_keys file there.

Hope this helps,

-Rob Ferguson