I have a database of topic posts stored in a CSV or MySQL file, and I’d like to import it into Stackby. Is there a way to do this seamlessly? Also, can I map the fields during the import process to match my Stackby table structure?
Yes, you can seamlessly import your topic posts database from a CSV or MySQL file into Stackby. Here’s how you can do it:
Creating a New Stack from a Spreadsheet
- Click on the ‘+Add Stack’ dropdown.
- Select ‘Import a Spreadsheet’ from the menu.
- An ‘Import a Spreadsheet’ modal will open, where you can upload your file and set up your stack.
Uploading a CSV File to a Table
- Open your desired table in Stackby.
- Click on ‘Import Data’ > ‘CSV’.
- Click ‘Choose a .CSV file’ and either:
- Drag and drop your CSV file into the upload box.
- Select the file from your computer or a supported cloud service.
- Stackby will prompt you to map the fields from your CSV to your table structure before finalizing the import.
Importing from MySQL
Since Stackby does not support direct MySQL imports, follow these steps:
-
Export Your MySQL Table to CSV
Or use MySQL Workbench or phpMyAdmin to export the table as a CSV file. - Follow the CSV Import Steps in Stackby (as mentioned above).
By following this process, you can efficiently import your topic posts into Stackby while mapping fields to match your table structure.