В роботі

Data validation

We run a gym and want tools to detect data anomalies such as bad date of birth or monthly payment failures,

STAGE 1

A basic website (or code / script we can host) allowing the user to select the (local) gym database file (in Access format), and this is checked for data anomalies, as per a simple list of rules we have pre-prepared, such as:

* Member age is <13years or >99 years.

* Barcode ID is <1000000 or >2000000

* State field <> NSW

* Etc

A report is prepared showing all anomalies by rule category, and (also) by member name. We have about 13 of these very basic rules, and may want to add more at some later stage if possible.

Stage 2

Users can 'also' upload a txt file showing the member payments from a third party payment system. A secondary report is then provided which reports anomalies such as:

* Member has not paid this month, or has paid a non-standard amount

* Mismatch on ID's or name fields etc

We currently have five of these very basic checks to be done.

The report should show anomalies by rule and (also) sorted by member name/ID.

These reports should be visible on screen in a basic HTML table, and able to be copied and pasted to Excel or Word easily. Samples of both files (Access database and [url removed, login to view]) are readily available.

Навички: Веб-служби Amazon, Техніка, MySQL, PHP, Управління проектом, Архітектура ПЗ, Тестування ПЗ, Веб-хостинг, Управління веб-сайтами, Тестування сайтів

Показати більше: sorted data, data host, 1000000 website, Gym management, data validation, upload excel file php database, validation script php, html table txt, php detect system, php excel database report, validation file, format html table, excel list files add, gym management system website, pre data, excel validation list, access data html table, html barcode, file validation, validation system, script validation php, excel table word, access database monthly reports, excel html table, php upload excel file database

Про роботодавця:
( 44 відгуки(-ів) ) Coffs Harbour, Australia

ID проекту: #3528730

Доручено:

mirelush27

See private message.

$102 USD за 40 дні(-в)
(20 відгуків(-и))
4.1

13 фрілансерів(-а) подали заявки на цю роботу; середня заявка - $135

brightsolnslx

See private message.

$170 USD за 40 дні(-в)
(311 відгуків(-и))
6.5
liumy1985

See private message.

$85 USD за 40 дні(-в)
(150 відгуків(-и))
5.6
shekhar20

See private message.

$97.75 USD за 40 дні(-в)
(57 відгуків(-и))
5.4
ubunto

See private message.

$148.75 USD за 40 дні(-в)
(73 відгуків(-и))
4.9
rshyethmusthafa

See private message.

$170 USD за 40 дні(-в)
(27 відгуків(-и))
4.7
DelphiMaster

See private message.

$106.25 USD за 40 дні(-в)
(7 відгуків(-и))
4.4
valeravlasyuk

See private message.

$170 USD за 40 дні(-в)
(1 відгук)
3.9
billpurkins

See private message.

$102 USD за 40 дні(-в)
(18 відгуків(-и))
2.8
DeepakDadarwal

See private message.

$144.5 USD за 40 дні(-в)
(6 відгуків(-и))
2.4
penguin2009

See private message.

$85 USD за 40 дні(-в)
(0 відгуків(-и))
0.0
Deeraf

See private message.

$170 USD за 40 дні(-в)
(0 відгуків(-и))
0.0
prajwalit19

See private message.

$170 USD за 40 дні(-в)
(0 відгуків(-и))
0.0
hr2009

See private message.

$127.5 USD за 40 дні(-в)
(0 відгуків(-и))
0.0