Forum Discussion

JoeAcunzo's avatar
JoeAcunzo
Qrew Trainee
5 years ago

Pipelines CSV Handler Using SFTP for Data Source

I need to monitor a folder in an SFTP folder, and import the file into a (non-connected) Quickbase table once it arrives.   Then need to move the file to another folder indicating it was processed. ...
Pipelines
SherrieDrummond's avatar
SherrieDrummond
Qrew Member
4 years ago
I have this question as well. Would really be handy.

------------------------------
Sherrie Drummond
------------------------------
JoeAcunzo's avatar
JoeAcunzo
Qrew Trainee
4 years ago
Hi Sherrie,

I ended up writing a Windows app I call QuickbaseImporter that is driven from command-line parameters (no user interface).  It can import from any folder accessible to Windows (including local drive, network drive, Dropbox, Drive, etc. if exposed as a Windows folder).  You can specify the table and fields to import into on the command line.  It can easily be scheduled to run with the Windows Task Scheduler.

If you are interested in more details, contact me at the email/phone below.

------------------------------
Joe Acunzo (SoftTechExperts)
Quickbase Solution Provider
joe.acunzo@SoftTechExperts.com
------------------------------
  • SherrieDrummond's avatar
    SherrieDrummond
    Qrew Member
    4 years ago
    Thanks Joe! I ended up using a sync'd table directly from SFTP. It seems to be working for now. Thanks again, s.

    ------------------------------
    Sherrie Drummond
    ------------------------------