Convert qb-inventory to qs-inventory.
The preferred method of installation is to use the executables located in the releases section. However, if you prefer using the Python scripts, make sure you have Python 3.9.15 installed.
If you want to run the converter from the source code, follow these steps:
git clone https://github.com/CaptainStabs/qb-to-qs-inventory.git
cd qb-to-qs-inventory
pip install -r requirements.txt
After exporting the files from the database, open them in a text editor and ensure there is no null present. If found, perform the following replacements using find-and-replace:
,null, -> ,
[null, -> [
-
Run query
SELECT citizenid, inventory FROM players;
-
Export result with TablePlus (Preferred over HeidiSQL, HeidiSQL export is untested), using the following settings
-
Move the exported file into the same working directory as
player_converter.exe
-
In the command line, run
player_converter.exe <filename>
The default filename is
players.csv
, so if you named it that, you can just runplayer_converter.exe
If you are running them through Python, dopython player_converter.py <filename>
-
Import the CSV into
players
table in database. (I converted the csv into a sql update statement)
-
Run query
SELECT * FROM stashitems;
-
Export the results as before, following steps 2-3 for inventory conversion
-
In the command line, run
stash_converter.exe <filename>
Default filename is
stashitems.csv
-
Import into
inventory_stash
-
Run query
SELECT * FROM trunkitems;
-
Export the results.
-
In the command line, run
trunk_glove_converter.exe <filename>
-
Import the resulting file into
inventory_trunk
table
- Run query
SELECT * FROM gloveboxitems;
- Export the results
- In the commandline, run
trunk_glove_converter.exe <filename>
- Import the resulting file into
inventory_glovebox
- Clone the repo and CD into each tool individually
- Run the following, replacing the path with the path to the numpy binary
libopenblas64__v0.3.23-293-gc2f4bdbb-gcc_10_3_0-2bde3a66a51006b2b53eb373ff767a3f.dll
(or whatever it is for your version):
pyinstaller --onefile --add-binary="C:/Users/User/miniconda3/envs/converter/Lib/site-packages/numpy.libs:." <script>