Track your progress in FIFA Career Mode
Switch branches/tags
Nothing to show
Clone or download
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
Database Data Support for FIFA 19. Oct 21, 2018
FIFATracker Transfer History for FIFA 19 Nov 18, 2018
.gitignore Support for FIFA 19. Oct 21, 2018
README.md update readme Apr 12, 2018
requirements.txt Support for FIFA 19. Oct 21, 2018

README.md

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

2. Create Database

Create database with pgAdmin (pgAdmin 4\bin\pgAdmin4.exe) pgAdmindatabase

3. Create unaccent extension

Connect to created database and crate unaccent extension unaccent

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

secret_settings

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.