Delphi : Insert Spreadsheet to Table

En curso Publicado Jan 18, 2015 Pagado a la entrega
En curso

Need form to insert spreadsheet into SQL table using DevExpress Spreadsheet Control.

Form Requirements:

TeamViewer or Logmein

I will build nice UI for you. You only need be concerned with code and function.

Map Columns

1) Map Table Columns to Spreadsheet Columns using Combo

Check and Highlight

2) Create Functions to verify data in Spreadsheet matches datatype of Table Column and highlight exceptions on spreadsheet (per column only to be easier)

Error Handling

3) Cancel or uncommitt insert (save) on error.

User Rollback

4) Create function to delete last import (save)

Identification

Additional fields will be added to the insert/save to identify and link list

to available queries

DateImported : date saved

ImportedBy : shows who list imported by (available from mainform query (ill show how)

CompanyNo : Links list to a company in a different table

Company : Name of the company (same query)

Contact : I think you should be understanding by now :)

In summary we are saving a sheet to a table with a few extra fields from query

Continued work on features and bug fixes on a continued basis if i like your work

Be skilled master with

Delphi XE

Devexpress Spreadsheet Control

ADO Components

MemData

MSSQL

Delphi Arquitectura de software SQL

Nº del proyecto: #6992043

Sobre el proyecto

3 propuestas Proyecto remoto Activo Jan 21, 2015

Adjudicado a:

tekwiz2

Dear Prospect Hiring Manager. Thank you for giving me a chance to bid on your project. i am a serious bidder here and i have already worked on a similar project before and can deliver as u have mentioned I have Más

$12 USD / hora
(1 comentario)
0.0

3 freelancers están ofertando un promedio de $18 / hora por este trabajo

ENRICOJ

I AM A DATABASE DEVELOPER AND CAN DO THE JOB IN 24 HOURS. I AM GOING TO CHURCH NOW ,BUT AS SOON AS I AM BACK I WILL BE ABLE TO START REGARDS ENRICO

$16 USD / hora
(0 comentarios)
0.0