Encerrado

eInvoice Import 001

Console app (command line) DOT NET application written in VB or C#. to complete the following steps. SQL Server connection information and import file path are to be supplied as command line parameters. The command line will be simiolar to the BCP and ISQL utilities, although, not nearly as comprehensive.

1. Read **BillI** record from the **ElectronicInvoice** table on the SQL Server. All table3 definitions are supplied in the design document.

2. Get the filename from the **InvoiceFilePath** field of the record.

3. Unzip the Access MDB file into a temporary data location.

4. Establish a database connection to the MDB file.

5. Copy the data from 13 Access tables to the corresponding SQL Server tables. The data elements of these tables are nearly the same. Any translations are very simple and defined completely in a document that will be supplied to complete the project.

6. Set **ImportComplete** to “1??, set **ImportDatetime** to the current time, and update the **InvoiceNumber** field on the **ElectronicInvoice** record.

7. Delete the temporary MDB file form the file system.

8. Terminate the program.

## Deliverables

1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request. 3) Complete ownership and distribution copyrights to all work purchased.

## Platform

Windows 2000, Windows XP, Windows 2000 Server. MS .NET Framework.

Habilidades: PHP

Ver mais: einvoice, elements design line, visual software code update, get translations, dot net sql, console sql, php mdb read, import access database php, copy windows command line, mdb import, application written visual basic, update sql form application, visual basic delete access, simple database app windows, net console application, sql mdb, unzip php, copy app source code, update sql server file, command line written, import database access php, simple import, simple visual access project, visual unzip, unzip visual

Acerca do Empregador:
( 25 comentários ) United States

ID do Projeto: #2970021

49 freelancers estão ofertando em média $490 para este trabalho

psergei

See private message.

$467.5 USD in 14 dias
(444 Comentários)
8.6
TakeRealUK

See private message.

$425 USD in 14 dias
(760 Comentários)
7.0
keycomvw

See private message.

$425 USD in 14 dias
(39 Comentários)
6.5
vw957170vw

See private message.

$425 USD in 14 dias
(31 Comentários)
6.3
saurabhguptavw

See private message.

$637.5 USD in 14 dias
(41 Comentários)
6.1
vstarvw

See private message.

$425 USD in 14 dias
(12 Comentários)
5.8
dotnetdeveloper

See private message.

$467.5 USD in 14 dias
(64 Comentários)
5.6
mocak2

See private message.

$425 USD in 14 dias
(41 Comentários)
5.4
furty

See private message.

$425 USD in 14 dias
(41 Comentários)
5.4
terryfvw

See private message.

$425 USD in 14 dias
(18 Comentários)
4.9
HGDiaz

See private message.

$425 USD in 14 dias
(30 Comentários)
4.8
gilbertdickinson

See private message.

$425 USD in 14 dias
(2 Comentários)
4.7
phvw

See private message.

$850 USD in 14 dias
(3 Comentários)
4.2
aspexpert20

See private message.

$594.15 USD in 14 dias
(13 Comentários)
4.0
andrei21vw

See private message.

$425 USD in 14 dias
(6 Comentários)
3.9
mikejoz

See private message.

$722.5 USD in 14 dias
(9 Comentários)
3.9
esystemsengvw

See private message.

$425 USD in 14 dias
(12 Comentários)
4.0
always99vw

See private message.

$510 USD in 14 dias
(22 Comentários)
3.4
intelligencelab

See private message.

$510 USD in 14 dias
(10 Comentários)
3.3
bubbla

See private message.

$425 USD in 14 dias
(22 Comentários)
3.1