Chiuso

mySQL Field Editor

Questo progetto è stato assegnato a dghq123 per $250 USD.

Ottieni preventivi gratuiti per un progetto come questo
Datore di Lavoro impegnato
Budget del Progetto
$30 - $250 USD
Offerte Totali
6
Descrizione del Progetto

Please carefully review the attached mock-up of the UI.

Two main functions:

1. The user selects an existing field and is then able to recode that field into a new field.

Eg. 1=2, 2=3, >2=4, <-1=5, Else 6

2. The user selects one or more fields and creates a mathematical expression that computes a new field. Possible mathematical functions include add, subtract, divide, multiply, minimum, maximum, mean, frequency, mode, variance, standard deviation, range, absolute value & log10.

Eg. V1+V2/2

Eg. mean(V1,V2) + ABS(mode(V1,V2))/2

These recoding and calculations would be saved and scheduled to run regularly on the old source field to insert new data in the target field.

Features:

- Each rule should be run at scheduled intervals

- Each saved rule should be capable of being opened and edited

- A basic GUI to connect to multiple SQL databases

- Can add new tables & save newly generated fields to these new tables.

- The user can select which table to insert the new field into

- Lists recent fields used for quick selection

- Autocomplete & suggest variable names in search boxes

- Clicking a field name in the search box inserts the field name into the recode or calculation.

- A preview window to see the active table, with the ability to search in any field

Assegnato a:
Competenze Richieste

Stai cercando di guadagnare dei soldi?

  • Stabilisci il tuo budget ed il tempo limite
  • Metti in rilievo la tua proposta
  • Fatti pagare per il tuo lavoro

Assumi Freelancer che hanno fatto un'offerta per questo progetto

    • Forbes
    • The New York Times
    • Time
    • Wall Street Journal
    • Times Online