Automation of FTP files to Cloud Provider

[p_verkooijen]

Because SaaS has no FTP connectors available (yet) I tried to create an automation that retrieves several .CSV files from a FTP and store them into a OneDrive so I can access them in the Qlik script.

However I get stuck because I cannot find the correct information on how to setup this kind of flow.

Tried something like below, but I think this is not the way to go

If anybody could help me, or point me in the right direction?
Thnx

[Emile_Koslowski]

Hi @p_verkooijen ,

I think the "Copy File" block from the Cloud Storage connector would be the best solution here.

Can you try the following? (I've attached an export of the automation to this message)

[p_verkooijen · Accepted solution]

Hi @Emile_Koslowski 

Thank you for the example, did manage to create a flow (just recently)

Needed to add a check if the item is a filetype. Because "List files on FTP" lists all items including directories.

Steps

• List Files on FTP
• Check if item is a File
• Open File on FTP
• Copy to OneDrive folder
• Move to Processed on FTP
• Reload App
• Move to Processed folder on OneDrive

To bad there is still no Google drive block available.

[GuilhermeSchneider]

Hello @p_verkooijen 

Also I think it is extremely necessary that the automations must have connection with google drive.

In case you want to do the process described above but with google drive, we had a simmilar problem in the company that i work for because automations don't handle the google drive connector. We found a different solution to use google drive in our scripts: we installed the google drive software that keep sync some files then we connect direct (using the google drive connector) in the app to get the files.

Regards,

[p_verkooijen]

@GuilhermeSchneider thank you, Google Drive in Automations only exists as a idea. Last status is unplanned because of "extraordinary requirements"

https://community.qlik.com/t5/Suggest-an-Idea/Add-Google-Drive-connector-to-Qlik-Application-Automat...

Kind of strange that we can use Google drive when using Webconnectors or direct connectors for loading data, and it is not available using Application Automation.

[GuilhermeSchneider]

Yes, here at the company that i work for, we have been waiting for that connector since automations were launched.

[p_verkooijen]

@GuilhermeSchneider a bit late asking, but could you give a like to the idea? https://community.qlik.com/t5/Suggest-an-Idea/Add-Google-Drive-connector-to-Qlik-Application-Automat...