Exporting data from multiple tables into a single CSV
Is it possible to export data from multiple tables into a single CSV? My thought right now is to build a 'combined table', and use automations to populate that table with the records I want from the other 4 tables. Then it's a simple report on that new table. Is there a way to accomplish this without actually having all the records in the same table? ------------------------------ Mike Tamoush ------------------------------19Views0likes4CommentsAny interest in an open source set of SSIS components for MSSQL?
Hello - Wondering if there are other users of Microsoft SQL Server who might be interested in a simple set of SSIS components (connection manager, data source, and data destination)? I realize there's a commercial ODBC driver out there (which looks great), but I found myself in an odd situation where, for specific reasons, buying software is off the table, but investing time is OK. I've already got some basic stuff working and my intent is to polish it up enough to be useful without needing to know the API: Connection manager for attaching Data source for querying Data destination for writing back (No generalized ODBC like integration where you can do mass deletes) For the data source I'm also going to add something I've found useful on other projects, which is emitting "maybe kinda close enough DDL" for generating your target tables (it just abuses SMO). I've already got this working and it applies some basic rules (sanitizing column names, prefacing the individual address fields with the parent name prefix, etc.) as well as does some very rudimentary guesses on data types. It's mean to be an assist, not an operation you completely trust. I already wrote a generalized "auto sync" process that says "get everything from a database" (simple C# app - creates and runs DDL, merges data over, etc.), but I'm in the process of taking subsets of that and putting things into simple SSIS components. Basic SSIS process - set up the connection manager with your API key and select the database, then in the data source, choose your table. That's it. Done. It's meant to be easy. The only "API-ish" bit I'm exposing (mainly because I'm lazy) is the query. For right now I'm planning on that just being a string you enter. (EX:https://help.quickbase.com/api-guide/index.html#samplequeries.html) I don't want to have to get too far into the weeds right now in building a custom UI for that. I'm currently testing on SQL 2016. If anyone else is interested in testing later, please let me know. I'm happy to ship out a sample DLL. Right now I've got the data source implemented as I try to figure out how MS wants the destination written. Code will eventually get to GitHub once I finish wrapping some basic UI elements around things. Thank you, Eric17Views1like5CommentsAPI Tool In Excel
Here's an Excel based API tool I created that allows you to test various Quickbase API's. It was developed as groundwork for a far more ambitious Quickbase/Excel project I?m working on. So if you need something to create, test, or just play with API?s against your Quickbase apps, this may meet your needs. Enjoy! Ken http://home.surewest.net/firch/Quickbase/QB_API.xls62Views1like21CommentsAutomatically Import CSV Files
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 ------------------------------16Views0likes3Comments"save as spreadsheet" erasing my leading zeros
I have a Text field that contains numeric account numbers that generally start with Zero (ie: 04201345). They show fine in Quickbase, but when i "Save as Spreadsheet", the account number field always erases the leading 0, (IE:4201345) Is there a way to make sure those Zero's stay all the time? ------------------------------ Jamie Brown ------------------------------17Views0likes4Commentstransfer data from live to development app
I currently have a live app that my company is working with. We needed to make some new changes to the app so I copied our current live app with all of its data to a test app. From here I have made all my necessary upgrades, how can I now transfer my live data into my test app? I want to do this and then just rename my test app to be the functioning one moving forward. Is this the wrong way of doing this? Sorry still quite new at quickbase.13Views1like5CommentsExporting QR Codes in bulk for label making and inventory
Hello All, I use quickbase to keep track of industrial equipment as well as inspect and keep records of said equipment. Each piece of equipment has QR code linked to it directly in quickbase. I am trying to export both the data and the images so II can print them out with a Brady labeler. My issue right now is the only file format offered is CSV which does support images. I am curious if anyone else has run into this issue and has a solution. ------------------------------ Phil Heron ------------------------------98Views0likes8CommentsData import error
Each week, I import (clipboard) a specific type of data to the same table in my app. Today I attempted to import as I always do, and was presented with this error: "The following required fields are missing from your import data: `Deliverable Cycle Month`" (it does this for different req'd fields if I add the one it mentions to the clipboard import). The app hasn't changed and the import data format hasn't changed. Has something in Quickbase changed that would cause this error? ------------------------------ Matt Makris ------------------------------38Views0likes2CommentsWhen importing a file into a child table in QuickBase, the parent lookup fields are not appearing in the import mapping options.
I am trying to import a file into a child table in QuickBase. After importing the data, I am unable to see the relationship between the child record and the corresponding parent record in the parent table. ------------------------------ manohar vankireddy ------------------------------36Views0likes14Comments