Import CSV / JSON

Rowy allows you to import CSV / JSON (or TSV, from URL) files to your Firebase database. You can import to an existing Firestore datastore or create a brand new collection right from Rowy.

Steps

1. After creating a new table, click on the Import Data button.

2. Select CSV as the data source.

3. Click on Continue to start the import process.

4. Select the columns to be imported to Rowy, click Continue.

5. Review the data to be imported and click Finish.

Importing Rows with Custom ID

Generating a row with a Custom Row-ID helps set custom Document-ID of the row on the Firebase Firestore. The row will be displayed on the top while it is being edited. Later, it will appear at a different position in the table.

The difference is that the user is given the liberty to choose the Row ID and the position of that row is set accordingly.

Applications of Custom ID

Let us understand it's applications with the help of some examples:

Case 1: Accessing data from another collection

Let's say we have a Derivative function that fetches data from another collection.

const regionDoc = await db.collection("touristAreas").doc(row.touristArea).get();
return regionDoc.get("region");

The db parameter can access your Firestore to access any collection or document.

The above line above would find the collection named touristAreas in your Firestore Database, and try to search for a document with its Document-ID matching the value in the field touristArea in your current collection. This would return the region field of the found document.

Case 2: Bulk updating fields via Import

Importing data via a CSV file is the way to go for bulk updating data in your table. Make sure you're using Custom-ID for your data as described below. Export the data from your Rowy table as a CSV file first. This will incorporate the same column names as the ones in the Rowy table.

Thereafter, add data to it and import it back again into your Rowy project (make sure you have selected the same field as the Document-ID). This will let you update the records.

Bulk Updating Fields

For Bulk Updation, try initializing the data as a CSV import as well. This will help match the Document-ID to that in the Firestore collection. If you try to update records that were not added via the import CSV method, it will result in duplicates.

Changing Auto-generated ID to Custom ID

If you have your Document-ID auto-generated, you can perform the following options to set custom IDs:

• You can export your table to a CSV file using the export option in the top right menu.
• Create a new table and import the data via the same CSV file.
• While importing, if you scroll down, you'll see an option for setting Document-ID.
• Choose Pick a column and select a column you want to keep as the Column-ID.

• Going forward, when you add a row, you can select the option to add a row With Custom-ID so it asks you to provide a Document-ID everytime.

Supported Field Types for import via CSV

Potentially, import by CSV will support all the field types supported by Rowy (check them out here). However, for now, we support the following field types:

Text

	Name	Description	Data Type
	Short Text	Text displayed on a single line.	string
	Long Text	Text displayed on multiple lines.	string
	Rich Text	HTML edited with a rich text editor.	string
	Email	Email address. Not validated.	string
	Phone	Phone number stored as text. Not validated.	string
	URL	Web address. Not validated.	string

Select

	Name	Description	Data Type
	Single Select	Single value from predefined options. Options are searchable and users can optionally input custom values.	string | null
	Multi Select	Multiple values from predefined options. Options are searchable and users can optionally input custom values.	string[]

Numeric

	Name	Description	Data Type
	Number	Numeric value.	number
	Toggle	True/false value. Default: false.	boolean
	Percentage	Percentage stored as a number between 0 and 1.	number
	Rating	Rating displayed as stars. Max stars is configurable, default: 5 stars.	number
	Slider	Numeric value edited with a Slider. Range is configurable.	number
	Color	Color stored as Hex, RGB, and HSV. Edited with a visual picker.	Color

Date & Time

	Name	Description	Data Type
	Date	Formatted date. Format is configurable, default: yyyy-MM-dd. Edited with a visual picker.	Timestamp
	Date & Time	Formatted date & time. Format is configurable, default: yyyy-MM-dd HH:mm. Edited with a visual picker.	Timestamp

Code

	Name	Description	Data Type
	JSON	Object edited with a visual JSON editor.	object
	Code	Raw code edited with the Monaco Editor.	string