Dynamically importing files.

CoreVest

I have a situation where a data source is coming in via email only, no available data connector in Domo. The file needs to be appended with a snapshot per email. Is there an automated file archive processes that Domo can provided? Basically, i would need to create a connection to pull the data from a file in a folder path, then be able to differentiate newer uploaded files to append that data. Any ideas?

betogess

Here are some ways I have solve this before:

 

#1 - Using Box / Dropbox: 

1- Create a new folder in BOX

2-Use the settings of the folder to retrieve the specific e-mail that Box assigns to that folder

3- Send/Forward those files into the Box e-mail. This e-mail will upload the attached files into the folder. The files have to be named exactly the same so they replace the previous file.

4- Use the box connector in DOMO to retrieve that file. Also schedule the datasource so it pulls the data AFTER the new file is placed in Box (this requires for you to have a specific schedule of when are those e-mails coming, if you don't know that put DOMO to schedule at the last minute of the day and update it on a daily basis).

 

* I believe this might be possible with dropbox as well.

 

#1 - CSV over FTP:

We have developed internally some windows services that deliver csv files on one of our FTP's. Then we use the CSV-SFTP connector in DOMO to retrieve a file. You can probably find a service or plugin that can do for you and send those attachments to an FTP.

 

Hope this helps.