-
uploading csv data to update entire database
Hi, I'm hoping that some experienced Xano user might be able to offer a solution? I am working for a client who has a Launch account and they have a main table with a 100,000 records (each with about 25 fields). They want to be able to upload a csv file (actually 3) and update the table. Not really a problem (thanks to a…
-
📽️ Tutorial - Migrate/Sync Your Bubble Database to Xano - Part 1 🚀
Hey Xano/Bubble enthusiasts! 👋 We've just released the first part on how to migrate and sync your Bubble database to Xano via Bubbles Data API! In this video, we cover: Connecting to the Bubble Data API 🌐 Setting up your Xano database table 📝 Adding records to your database 📥️ Error Handling during the syncing process 🚩 ➡️…
-
How can I import a CSV file with a comma in a string value?
Hello everybody, I have problems importing a CSV file that looks like this: CSV-File: id,name 1,Bergmann, Marvin In Xano it looks like that: id: 1 name: Bergmann And not like that: id: 1 name: Bergmann, Marvin Can somebody please help? Thanks a lot!
-
Basic (I think) question on importing an array from one table to another
I am stuck on importing some arrays from Bubble into a Xano table. I understand that Xano CSV import does not handle arrays/lists. So I first imported the relevant arrays into Airtable and then from Airtable into a separate 'imported table' in Xano. Now I want to import what is in the array fields in the 'imported table'…
-
Airtable manual import
I have done an airtable import a few times in xano. Overall it works well. I was confused about some file types and erased some columns of data. namely image and table references. It seems the only way references get added is if the tables are imported simultaneously otherwise they do not link up with existing tables. I'm…
-
Best data practice
Hi everyone, I have the below mater table example. Attribute set A table AND Attribute set B table are the expected results. Is the best practice to import the master table (actual data has more than 600 columns and over 70k rows) into Xano via CSV and use the API filters to get the expected result? Or should I processed…