Working on importing/migrating from another database
I'm just starting to experiment with migrating data over from Postgres. I see that "each row's entries are interpreted either as a (floating point) number or a string." Got it. However, when I do the import (csv), every value ends up in convex with quotation marks around it. This is messing up my boolean fields. How can I find/replace/update all rows/fields where I have a boolean so that it removes the quotation marks?
2 Replies
Thanks for posting in <#1088161997662724167>.
Reminder: If you have a Convex Pro account, use the Convex Dashboard to file support tickets.
- Provide context: What are you trying to achieve, what is the end-user interaction, what are you seeing? (full error message, command output, etc.)
- Use search.convex.dev to search Docs, Stack, and Discord all at once.
- Additionally, you can post your questions in the Convex Community's <#1228095053885476985> channel to receive a response from AI.
- Avoid tagging staff unless specifically instructed.
Thank you!
two options off the top of my head:
- do the import from json or jsonl (not csv) which allows booleans https://docs.convex.dev/database/import-export/import#single-table-import
- after importing, change the data from string to boolean with a migration https://www.convex.dev/components/migrations https://stack.convex.dev/intro-to-migrations
Intro to Migrations
There are as many ways to migrate data as there are databases, but here’s some basic information to set the stage.
Data Import | Convex Developer Hub
Import data into Convex