Track your progress in FIFA Career Mode
Try FIFA Tracker now at https://fifatracker.net/
Development in progress...
1. Download and install
2. Create Database
Create database with pgAdmin (pgAdmin 4\bin\pgAdmin4.exe)
3. Create unaccent extension
Connect to created database and crate unaccent extension
4. Install virtualenv
pip install virtualenv
5. Create virtualenv
mkdir "C:\Program Files\Project"
cd "C:\Program Files\Project"
virtualenv FT_ENV
6. Activate virtualenv
cd "FT_ENV\Scripts"
activate.bat
7. Clone FIFA Tracker repository
cd "..\.."
git clone https://github.com/xAranaktu/FIFA-Tracker.git
8. Install dependencies
pip install -r "FIFA-Tracker\requirements.txt"
9. Create "secret_settings.py" file in "FIFATracker\Fifa_Tracker" dir
Note Make sure that database name and password is correct.
10. Database migrations
It's awkward because you cannot store a null primary key in PostgreSQL database which is surprisingly possible in FIFA Database.
cd "FIFA-Tracker\FIFATracker"
python manage.py migrate players 0001
python manage.py migrate --fake players 0002
python manage.py migrate
11. Populate Database
"playernames" & "nations" tables are not included in career save. So you need to populate these tables from .csv files. Just simply navigate to your PostrgreSQL\bin folder and execute proper commands or use pgAdmin.
Commands examples:
psql -d FIFA_TRACKER --username=postgres -c "COPY dataplayernames (name,nameid,commentaryid) FROM 'C:\Program Files\Project\FIFA-Tracker\Database Data\playernames.csv' delimiter ',' csv header ENCODING 'UTF8';"
psql -d FIFA_TRACKER --username=postgres -c "COPY dataplayernames17 (name,commentaryid,nameid) FROM 'C:\Program Files\Project\FIFA-Tracker\Database Data\playernames17.csv' delimiter ',' csv header ENCODING 'UTF8';"
psql -d FIFA_TRACKER --username=postgres -c "COPY datanations (isocountrycode,nationname,confederation,top_tier,nationstartingfirstletter,groupid,nationid) FROM 'C:\Program Files\Project\FIFA-Tracker\Database Data\nations.csv' delimiter ',' csv header ENCODING 'UTF8';"
psql -d FIFA_TRACKER --username=postgres -c "COPY datanations17 (isocountrycode,nationname,confederation,top_tier,nationstartingfirstletter,groupid,nationid) FROM 'C:\Program Files\Project\FIFA-Tracker\Database Data\nations17.csv' delimiter ',' csv header ENCODING 'UTF8';"
12. Run server
Make sure virtualenv is still active. Then change dir to "FIFA-Tracker\FIFATracker" and run django server.
python manage.py runserver
Your local FIFA Tracker project will be available at 127.0.0.1:8000.