andythorne/fifa-tracker

Track your progress in FIFA Career Mode

FIFA-Tracker

Track your progress in FIFA Career Mode

Try FIFA Tracker now at https://fifatracker.net/

Development in progress...

Setup Guide for Windows

1. Download and install

• Python 3.6
• PostgreSQL 10
• Git

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.