Export Project to Windows not including Extra Files (Sqlite database and Text file) - Issue 1

dassa

Hi, I am missing files when I export my project as a Windows exe. I am using Sqlite as a database in my project with the database residing in the development project folder(res://Data/). The folder shows in the editor window but you cannot access or see the contents of the folder from the editor(I assume Godot does not recognize this file type).

When exporting I am listing a filter of additional resources to include as Data/. however when exported the database file does not seem to be included - when running the exe it loads and runs but does not display any data.

I have got round this by copying the Data folder into the export location and everything now runs, however this is not a viable solution with final distribution of the product.

Also have the same problem with a text file (holds startup information).

Any assistance would be appreciated.

TwistedTwigleg

Did you specify the file types in the export tab? If the files are not a file type Godot recognizes by default, then you will need to tell Godot to include them in the export. I believe there is a field for this, after which you can add something like: *.sql, *.json if you wanted to include SQL databases and JSON files (for example).

dassa

Thanks for the response.

Yes I have listed the extra files in the filter field of the Export screen. I have tried several combinations: - Data/.db, .txt as well as Data/Basil.db plus other variations... No exe compiles seem to pick up both the database or text file/s. I have also tried moving the database and text files from a subfolder into the res:// folder, again nothing is copied to my exe location.

Any other suggestions ? If this is a bug, how can it be addressed as it raises problems with the distribution of my project ?

TwistedTwigleg

Are you packing the .pck into the executable? If so, maybe that is causing the issue? You could also try exporting to a zip and then you should be able to open the zip to see the game resources and see whether the files are being included or not there.

I think the files need to be in the res:// folder to be included in the Godot export, in addition to having the extra files stuff filled in the exports. I'm not sure if you need to specify the folder though, I think you can just add a filter for just the file extension.

dassa

Answers to your queries - - I am not packing the .pck file into the executible - I have exported a zip file and all files are listed includeing the db file - I have moved the text files and db file under res://

With the db file in the project directory and when creating the Windows exe, it creates four files - the exe file, the pck file, the sqlite library and the .db file but with a zero file length. I am getting no errors in the console window with the compile.

To make the program run, I am just copying the database file into the compile directory and all runs as expected. This means it is picking up other ini text files (needed to make it run).

How do we move this forward ? For distribution I am looking at the possibility of a third party windows install script/program to package all needed files. Any suggestions ?

TwistedTwigleg

Hmm, that’s strange that the files are included but without any data, or at least not much. I’m not sure, but I would recommend maybe asking on other Godot communities (Reddit, Discord, Facebook) and see if anyone there potentially knows. You can also maybe see if the developers on the Godot chat have any idea.

I wish I could provide a solution, but I do not know what is causing the issue nor what to suggest. I will keep an eye out for potential solutions though and will post if I find or think of any.

dassa

Thanks for the time taken to respond.