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 ------------------------------Any 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, Eric
API 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.xls
Automatically 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 ------------------------------
"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 ------------------------------transfer 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.
Exporting 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 ------------------------------
Data 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 ------------------------------When 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 ------------------------------
Suggestion to work around when ""Report too large. Maximum number of bytes in report exceeded"" error?
I want to queried all data from a table/report to save it into a local database. I've tried to export it into CSV format, however, got the problem as attached image. Please suggest ways to overcome it with: no filter applied one extracted data file only (like a svn dump file) I've read QB HTTP API and wonder if it can help to over come the "too large" issue?