In Progress

Import odds file(s) into database - TASK2

Task1: DONE!

Import files specified in a launch screen into 2 database tables so 1 entry in MATCH and 1 entry in ODDS for every second of the match

Import file contain 2 lines per second - one for each per player. Merged to 1 entry per second with both players

([url removed, login to view])

Task2: THIS TASK

2a) Error correction. [url removed, login to view] / startodds2 is today the first odds with inplaydelay: 5

Instead it should be the last odds wih inplaydelay: 0 (the 2 lines before)

2b) Error correction. [url removed, login to view] / endodds2 must be the last odds imported with inplaydelay: 5

2c) It seems the last odds with inplaydelay: 5 is not imported. as long as p1back1 and p2back1 > 0 they can be imported.

2d)

-Add 3 inputfields to the launch screen

1) Ignore similar odds (Yes/No) Default: No

2) Ignore similar data (Yes/No) Default: No

3) Overwrite (Yes/No) Default: No

->

1) Yes: During import do not insert data into ODDS if p1back, p2back2,p1lay1,p2lay2 was the same as previous inserted data

2) Yes: During import do not insert data into ODDS if all the fields: p1back..->..p2lpm was the same as previous inserted data

3) Yes Allowed to re-import an existent match. Before import it will delete the match and all connected Odds data

Task3: Next task

Skills: PHP

See more: freelancer insert data, freelancer insert, freelancer delete, freelancer 2d, delete freelancer, default freelancer, 2d freelancer, import mysql, import database, database freelancer, delete mysql tables, database players, default player, mysql delete tables, merged, mysql data import, html import, php player match, import data database, data entry screen html, html import data, today screen, data entry projects html, data entry html projects, import files

About the Employer:
( 41 reviews ) Skanderborg, Denmark

Project ID: #1251343

Awarded to:

StarDeveloper3

I'm interested in your project. Please check your PM.

$70 USD in 2 days
(80 Reviews)
5.8