Discussions

Expand all | Collapse all

Automatically upload CSV data into QuickBase every one hour

  • 1.  Automatically upload CSV data into QuickBase every one hour

    Posted 12-03-2015 16:38

    I know this topics already talked about a lot, but I am very new to Computer business. I want to import CSV file to QuickBase. I watched Youtube and I could do manually, but my boss wants to automatically upload CSV data into QuickBase every one hour, so what is the best way to do this? Could someone explain to me step by step.


    Thank you so much


    Kazu



  • 2.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 12-03-2015 17:04
    Kazu,
    This is currently not possible to do in native QuickBase.  You would need to contract with a third party developer to do this for you.

    But, There is a native product called QuickBase Sync which does automatically Synch with certain other data sources such as SalesForce.com and QuickBooks and about half a dozen others on a scheduled as often as once per hour.  At the time they announced QuickBase Synch, they said that the next Synch they were working on was a way to automatically Synch from a CSV file.  So, I would expect that sooner rather than later, they will announce that capability, but no one outside QuickBase knows when that will be ready to launch.

    If you have budget for a third party provider, contact me off line via the information in my Profile and I can suggest some 3 party QuickBase partners you could contact.  or just wait a few months and hope that QuickBase Sync to CSV does get announced.


  • 3.  RE: Automatically upload CSV data into QuickBase every one hour



  • 4.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 04-04-2018 16:01
    Anyone know if this is possible yet without a third party? I've been playing around with google drive for the past two days and it's not working for me since i cannot edit the spreadsheet in Drive without losing the .csv format. Very frustrating.


  • 5.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 04-04-2018 21:18
    Released in Jan 2016, Quick Base Sync for CSV enables you to add or replace data in a table from the most recent CSV file in a Google Drive folder:  https://www.quickbase.com/quickbase-blog/4-steps-to-connect-quickbase-with-critical-business-data-in...


  • 6.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 04-04-2018 21:27
    Thanks for the reply Mark. Unfortunately the QuickBase Sync does not work for our application since i cannot edit the CSV file directly in Google Drive. We would need to export the file from Drive, edit in excel, save as CSV, upload to drive then "re-link" the document to Quickbase. This does not save us any time.
    If Google Drive would let me edit the file that is uploaded in CSV format, all would be great. Unfortunately that is not the case here.


  • 7.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 04-04-2018 21:51
    Got it. Could you use Box instead of Google Drive?  Box Edit may enable you to edit and save a CSV file using Excel.


  • 8.  RE: Automatically upload CSV data into QuickBase every one hour

    Posted 04-04-2018 21:56
    I think you could continue to use Drive, but you wouldn't modify the CSV file directly in Drive. You would need to use the Google Drive app to sync the CSV file to your computer, where you could edit and save it with Excel (w/o having to change the file type). The updated file would then sync to Drive (then to QB).