Attached is a modified version of the bexcel editor with expanded sqlite import/export suport:
I made these edits to the bexcel editor to make it easier to do mass modifications on the client side. When working with bexcel files alone you cannot write queries to transform data or make mass modifications easily. With this you can export the data make the changes in your favorite sqlite tools then import those changes back on the client side. Thanks to all the original bexcel developers who made this awesome tool in the first place!
Known Issues
- Export creates a folder named "DB_DUMP" which contains a ".sqlite3" file for every table in the ".bexcel" file.
- Import can take the contents of a ".sqlite3" file and overwrite the values in the currently open ".bexcel" file. You need to have a ".bexcel" file open before doing this.
- You can use a db file with multiple tables in it, but there hasn't been a lot of testing with this so YMMV.
You must be registered to see links
You must be registered to see links
You must be registered to see links
I made these edits to the bexcel editor to make it easier to do mass modifications on the client side. When working with bexcel files alone you cannot write queries to transform data or make mass modifications easily. With this you can export the data make the changes in your favorite sqlite tools then import those changes back on the client side. Thanks to all the original bexcel developers who made this awesome tool in the first place!
Known Issues
- Exporting duplicate tables does not work, one table will be exported and it will be the last table that exists in the ".bexcel" file.
- Importing duplicate tables does not work, it will likely result in both tables being overwritten with the data that was meant for one table.
- Adding new entries to the bexcel file will not work, this is just for modifying existing data.