crowbartools
[Feature Request] More Robust Viewer database spreadsheet/*.csv import option
Describe the problem The Viewers Database tab in Firebot contains a number of default database values for each viewer including Join Date, Last Seen, View Time, Chat Messages, and points values for any number of currencies added in Firebot. If a user wishes to mass edit this database (for example, because they have a *.csv export from another bot including valid values for all of these fields) their only option is to click each individual viewer and manually edit every field value. For databases with hundreds or thousands of viewers this is not a very realistic task.
In addition, the existing Import Viewers tool (1) only works with StreamLabs AnkhBot export files and (2) appears to only grab Viewer Name and View Hours, ignoring the Points column in that export *.xlsx. I've opened a separate issue for that problem here. . This feature request is a little more involved than the linked feature request, but if this one is completed, it will also automatically resolve the linked feature request #2788
Describe the solution you'd like I would like to be able to import either a *.csv or *.xlsx containing all of the fields supported by Firebot's Viewer Database. So if I import a *.csv with Viewer Name, Join Date, Last Seen, View Time, Chat Messages, and Points Values, I would like all of those to get included in the import.
If my imported file includes a Points column that is not already included in the Currency tab of Firebot, a new Currency will be created automatically as part of the import with default settings so that the values can be populated.
I understand that Firebot would need to be able to interpret this using a standard format so I'd envision when you click "Import Viewers" it would link you to a template file you'd need to fill out with the columns in the proper order. If you need specific formatting on values like the Join Date or View Time (looking at Firebot's DB it looks like it's using Mins rather than Hours and then converting to Hours on the front end, for example) those formatting instructions could be posted in the Import Viewers popup.
Additional context As mentioned in Feature Request #2788 , DeepBot, a ~9-year old premium bot that has been receiving ongoing updates, has seen its main developer go MIA, and it is expected DeepBot will hit end of service in October or November 2024 when its certificates expire. All DeepBot users were just given a heads-up about this and it's likely many of us will be coming to Firebot. Being able to import our entire user database would be very helpful for that process. DeepBot supports exporting our Viewers, Join Date, Last Seen, View Time, and Points Values, and since all of those columns are already supported in Firebot it'd be great if we could get all of those imported as well.
We've found some other problem with the Importer Tool that I'll open as a separate issue, but in the meantime, we have a short-term hack solution to the problem of importing viewer databases.
https://github.com/codemage/firebot-deepbot-importer/releases/tag/v0.0.2
This is a custom script written by Taronin to take an import CSV and add/replace records in the Firebot viewer database. It is designed to work with the DeepBot export CSV specifically, but a user from any bot should be able to copy their bot info into the CSV format and get it to import as well. The link includes a Readme with details on how to complete the export from Deepbot if anyone else is searching and finds this thread.