Error importing or exporting tables with Chatbot
# 🤝help
a
ID report: 0ab0a6ad-e912-45b3-b28d-93af3367dd1d There is no way to import a charbot with tables, it alwayd throw an error

https://cdn.discordapp.com/attachments/1147196301587517440/1147205401096491058/image.png

I had to create a new report, because i deleted previous chatbot looking for a way to reimport. New ID report: 74554fa9-3f92-402e-9fc1-622bdaae2d7e
g
@User The workaround for me is to export the table data to CSVs, then delete the data in the tables. Then export / import as normal and then reimport my table data into the original table and copied bot if needed. Pain in the backside but it works.
a
Thank you @vovi, but i cannot access to that backup. I tried to uncompress bpz and deleting table with each registry, but im not sure how to compress again and try to re import

https://cdn.discordapp.com/attachments/1147196301587517440/1147213673224478791/image.png

I got the original exported file but it doesnt work on importing, the thing is how to drop tables in BPZ file and then compress again in order to import a chatbot without tables
The most importan is preserver flows and ai task with code
g
ah i see. Thankfully I tested import / exports before I needed them and realised there was an issue with tables
a
Yes, problem with bpz is that are existing tables inside

https://cdn.discordapp.com/attachments/1147196301587517440/1147215533431857282/image.png

g
interestingly i just tied exporting a bot with multiple populated tables. I then created new bot and imported the BPZ ad it worked! I reckon they might have fixed something becasue a few days this was definitely broken. I think I still have a broken one. I will see i can spot any difference
a
I did that but always get same wrong message
I think if i have files with table component and no rows, i could compress to BPZ, do you have any idea about this format?

https://cdn.discordapp.com/attachments/1147196301587517440/1147217083785019543/image.png

g
according to 7-zip its a standard zip file. I would try opening the archive file in 7-Zip, deleting the table .jsonl files, resaving and see if that imports. Backup the bpz file first of course.
yep, i confirm this works. The import worked and just told me there are tables int he databse which are not used anymore and I can remove them. it works!
a
Did u use 7zip to compress? i will try
g
open it in 7zip and just delete the files you dont want and it auto saves. No need to uncompress / recompress, although you can. Its a standard zip format just with a BPZ extension
a
Yes, thats all i lost some registry but i managed to keep my code and flow that i did so far
Thank you so much
I think the problem was that export procces insert more columns that table model, maybe somebode have to fix it

https://cdn.discordapp.com/attachments/1147196301587517440/1147243958355890320/image.png

There are more than ten columns, but my model has only 4 columns
Why null values? I have no idea
2 Views