Error importing or exporting tables with Chatbot Botpress #🤝help

Error importing or exporting tables with Chatbot

aloof-afternoon-36582

09/01/2023, 3:48 PM

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▾

aloof-afternoon-36582

09/01/2023, 4:24 PM

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

great-yak-37157

09/01/2023, 4:51 PM

@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.

aloof-afternoon-36582

09/01/2023, 4:57 PM

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

aloof-afternoon-36582

09/01/2023, 4:57 PM

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

aloof-afternoon-36582

09/01/2023, 5:00 PM

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

aloof-afternoon-36582

09/01/2023, 5:00 PM

The most importan is preserver flows and ai task with code

great-yak-37157

09/01/2023, 5:01 PM

ah i see. Thankfully I tested import / exports before I needed them and realised there was an issue with tables

aloof-afternoon-36582

09/01/2023, 5:04 PM

Yes, problem with bpz is that are existing tables inside

aloof-afternoon-36582

09/01/2023, 5:04 PM

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

great-yak-37157

09/01/2023, 5:06 PM

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

aloof-afternoon-36582

09/01/2023, 5:09 PM

I did that but always get same wrong message

aloof-afternoon-36582

09/01/2023, 5:10 PM

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?

aloof-afternoon-36582

09/01/2023, 5:11 PM

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

great-yak-37157

09/01/2023, 5:17 PM

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.

great-yak-37157

09/01/2023, 5:20 PM

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!

aloof-afternoon-36582

09/01/2023, 5:23 PM

Did u use 7zip to compress? i will try

great-yak-37157

09/01/2023, 5:25 PM

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

aloof-afternoon-36582

09/01/2023, 6:45 PM

Yes, thats all i lost some registry but i managed to keep my code and flow that i did so far

aloof-afternoon-36582

09/01/2023, 6:45 PM

Thank you so much

aloof-afternoon-36582

09/01/2023, 6:57 PM

I think the problem was that export procces insert more columns that table model, maybe somebode have to fix it

aloof-afternoon-36582

09/01/2023, 6:57 PM

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

aloof-afternoon-36582

09/01/2023, 6:58 PM

There are more than ten columns, but my model has only 4 columns

aloof-afternoon-36582

09/01/2023, 6:58 PM

Why null values? I have no idea

2 Views

Previous Next