Are there any options other than Pipelines (using Dropbox or something similar is not an option) that can simply import a CSV file? All I want to do is automate what we can already do manually in QB by selecting a file on the network drive and import. I was doing this 20 years ago in Microsoft Access so surely there is a low code/no code solution to this.
------------------------------
Brett Hinman
------------------------------
Question
Automatically Import CSV Files
This topic has been closed for replies.
Brett,
You might be able to set up a code page to handle this. I was able to find an older post here that has some sample code (link). It makes use of the File Web API (link) and Quickbase's V1 Import from CSV (link).
I realize this doesn't answer your no/low code request, but it might get your started if you want to go down the code route. A user could select a file on their computer, and the code page would import it.
------------------------------
Evan Westbrook
------------------------------
You might be able to set up a code page to handle this. I was able to find an older post here that has some sample code (link). It makes use of the File Web API (link) and Quickbase's V1 Import from CSV (link).
I realize this doesn't answer your no/low code request, but it might get your started if you want to go down the code route. A user could select a file on their computer, and the code page would import it.
------------------------------
Evan Westbrook
------------------------------
+7We have a 3rd party add-on called EZ File importer that can automate the importing of Excel/CSV files
https://www.juicedtech.com/ez-file-importer
You can add a file in a file attachment field and click save; our process will fire and will import the data from your file based upon a predefined column-to-field mapping. That mapping is saved in a table created in your app as part of the setup process.
------------------------------
Keith Jusas
------------------------------
https://www.juicedtech.com/ez-file-importer
You can add a file in a file attachment field and click save; our process will fire and will import the data from your file based upon a predefined column-to-field mapping. That mapping is saved in a table created in your app as part of the setup process.
------------------------------
Keith Jusas
------------------------------
Sign up
Already have an account? Login
Login to the community
Login with Quickbase US – quickbase.com Login with Quickbase EU – quickbase.eu
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.