This article is part of our Product Feature series. Click here to read the first article.
We’re going to cover all the different ways to import data into Drop. We’re going to assume you know what a Dropbase pipeline is and how to set it up. Check out this article for a refresher on pipelines if you’d like.
The first way to import data is the simplest: drag and drop (DND). In order to create a new table, you drop a file into the Table column, give it a name, click upload file, and then click load to database.
That’s the scenario without any cleaning steps. If you do have some cleaning steps you want to apply, check out this article to see how to set them up. All the above steps apply as well, you just have to add the cleaning steps you’d like.
And once you’ve imported in data the first time to create a table, importing newer data of the same schema is almost exactly the same.
The only difference is that you get to see Column Mapper match the newer columns to the source, and apply any cleaning steps.
In addition to DND, you can also manually create the table schema first and then grab your data later. You can use this method to ensure that the schema in Dropbase is exactly what you want. Then, if the first file you import has columns that are spelled or ordered a bit differently, mapping them to the already existing columns in this schema is a breeze.
Now for two fun ways to automatically collect your data whether they’re coming from business partners, customers, or other team members. We covered this topic in depth in a previous article, but read on for a condensed version of it.
Dropmail feels like magic. It eliminates traditional the email workflow of receiving data in an email attachment, downloading it, cleaning, and then uploading it to your database every single time. Here’s how.
Dropmail creates a unique email id that your external data sender (like a supplier) sends the data to, instead of you. When your supplier sends the data as an email attachment to the Dropmail address, the data gets automatically added to a previously created data pipeline. All you have to do is click “Approve”.
Sometimes, email isn’t enough. Gmail currently has a 25 MB limit on email attachments before it’s linked as a finicky Google Drive link. So instead of going to your email inbox each time, and reminding your data sender for this week’s data, you can use Dropzone instead.
Dropzone gives your data sender the ability to upload data to Dropbase directly without going through email or a online file storage provider. They merely have to drag and drop their file in, and you get an approval notification on your pipeline.
Those are all the way (for now) to get your data into Dropbase. The great about all these import methods is that you can automate the entire ingestion and cleaning process with the help of pipelines. If you’d like to check out these import features and all of the others in Dropbase, sign up for a trial here.
Go back to ← Product Feature 04: Dropmail