Em Andamento

DataGrabber

We need a locally installed application (.EXE) that - at a regular interval (every hour between 8 AM and 8 PM - checks a local database for updated records, processes the information and uploads it to a specified URL.

In this particular case the application concerns a Microsoft Access database.

In this database there are 4 tables that are of interest to us.

The first table contains regular client information. Name address etc. The first column is labeled **client number**

The second table comprises 5 columns. Client number, Client type (3 possibilities defined in table 3), Subscription type (40 possibilities defined in table 4), End date.

Table 3: defines client types

Table 4: defines subscription type

There is one complication: the originating database does not show when a record was updated, consequently the application has to mark uploaded information as "processed" For this we will have to create an additional field in the second table.

The application we need has to do following:

Check table 2 for new entries

Find the corresponding [Client type] and [Subscription type] in table 2 and change the numbers used into strings

Find the corresponding client’s address in the first table

Collate this information into one set of data and upload it to a URL

Mark found new records as processed

The information is uploaded to a MySQL database.

The work includes an installation programme (InstallShield???) That installs the ODBC driver and the application. During installation we enter

Location of database

Name of database

URL

Username

Password

Copy of the subject database (56 Mb) will be made available

If this works we will in future need similar products for other database engines (like Advantage)

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):

a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.

b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.

3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).

## Platform

Windows ME, 98 XP

MySQL

Habilidades: Engenharia, Microsoft Access, MySQL, PHP, Arquitetura de software, Teste de Software

Ver mais: mark coder, programme site web, datagrabber, url username password, program exe access, url exe, odbc code, change database access exe, exe password, windows program date change, mysql password desktop application, client access odbc, check processed, php exe desktop, create form enter data mysql, installshield application, microsoft access check, program exe access database, find address username, mysql odbc, find server location, local database software, change database exe, find windows username, record checks

Acerca do Empregador:
( 2 comentários ) Netherlands

ID do Projeto: #2985567

Premiar a:

softncode

See private message.

$255 USD em 10 dias
(64 Avaliações)
6.0

22 freelancers estão ofertando em média $221 para este trabalho

RaiseSolutions

See private message.

$318.75 USD in 10 dias
(31 Comentários)
7.4
baskvw

See private message.

$297.5 USD in 10 dias
(136 Comentários)
7.2
DebasisB

See private message.

$297.5 USD in 10 dias
(145 Comentários)
7.0
brsofts

See private message.

$255 USD in 10 dias
(274 Comentários)
6.6
suthernsoftware

See private message.

$255 USD in 10 dias
(62 Comentários)
6.6
jawadh

See private message.

$255 USD in 10 dias
(80 Comentários)
6.0
mzcomputers

See private message.

$340 USD in 10 dias
(9 Comentários)
4.7
icewall

See private message.

$255 USD in 10 dias
(32 Comentários)
4.6
ender81

See private message.

$170 USD in 10 dias
(19 Comentários)
4.0
ekandeel

See private message.

$255 USD in 10 dias
(17 Comentários)
4.0
liniedreapta

See private message.

$127.5 USD in 10 dias
(34 Comentários)
3.8
akhin

See private message.

$170 USD in 10 dias
(7 Comentários)
3.3
happyprogrammer

See private message.

$255 USD in 10 dias
(8 Comentários)
3.4
goldenscript

See private message.

$85 USD in 10 dias
(9 Comentários)
3.1
sarc

See private message.

$335.75 USD in 10 dias
(3 Comentários)
2.2
ivarsvw

See private message.

$85 USD in 10 dias
(3 Comentários)
1.9
innocentfriend

See private message.

$85 USD in 10 dias
(2 Comentários)
1.4
anwarkhanvw

See private message.

$178.5 USD in 10 dias
(0 Comentários)
0.0
vw1679114vw

See private message.

$161.5 USD in 10 dias
(1 Comentário)
0.0
tensidesoft

See private message.

$127.5 USD in 10 dias
(1 Comentário)
0.0