Завершено

Update SQL Database via CSV File

Summary

Our company recently purchased a web based report generation tool for our shopping cart. This tool is used to create ad hoc reports via SQL commands. Once the report is generated it can be saved or exported into CSV or Excel file.

One of the reason for purchasing this program is to allow us to export the shipping address information for pending orders to a CSV file. Once that file is created we would then import the CSV file into an online address correction service. The service would correct the addresses and give us the opportunity to download the corrected file.

We are seeking someone to add an update function to the report generation tool. Basically it would allow the user to select the correct Shipping Address file, which is in CSV format, and then it would update the shipping information with the correct information in the file. The database should be updated via the key: [url removed, login to view]

This is the query that we use to get the data:

Select [url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view],[url removed, login to view]

FROM ac_Orders

JOIN ac_OrderShipments

ON [url removed, login to view] = [url removed, login to view]

WHERE [url removed, login to view] = '129'

Files included in the zip file:

A screen shot of the application

The application web files (2 files) (1 aspx file and 1 [url removed, login to view] file)

The exported pending shipments file in CSV (This file is exported from the application)

The verified shipments file in CSV format (This is the file that needs to be used to do the updates)

Other Information

Programmer will not be able to run the application because of licensing files, but the code should give you a feel on what the application looks like.

Programmer will not have access to the production server. Since this application uses a licensing mechanism it only operational on the production server.

I will be available to provide any assistance.

If you have any questions feel free to ask.

Квалификация: ASP, Программирование на C#, Архитектура ПО, SQL

Показать больше csv update, sql database programmer, sql database program, service database access, seeking online database programmer, production tool, online shopping web address, online report generation, it service sql programmer, free excel program download, file download service, ask programmer online free, key shot, sql server programmer, excel assistance online, Sql reports, sql database report, sql commands, excel with sql server, csv to excel

О работодателе:
( 59 отзыв(-а, -ов) ) Redmond, United States

ID проекта: #4317446

Поручен:

ritzdigitals

Choose me. doing it just to decorate my portfolio in asp. Thanks

$30 USD за 1 день
(4 отзывов(-а))
4.7

7 фрилансеров(-а) в среднем готовы выполнить эту работу за $130

grtcoder

Gear Sir I have gone through your description and going to review the codes you provided. Please message me if my BID is considerable. Thanks grtcoder

$250 USD за 21 дней(-я)
(2 отзывов(-а))
3.3
GT1002

I am interested

$80 USD за 3 дней(-я)
(2 отзывов(-а))
2.8
systemsspark

hi i have done shipping softwares please check your pm to start

$250 USD за 15 дней(-я)
(0 отзывов(-а))
0.0
brain4u

Sir, We Can Discuss it......

$60 USD за 1 день
(1 отзыв)
0.0
wbslivera

Hello, I can help you. Thanks

$40 USD за 2 дней(-я)
(0 отзывов(-а))
0.0
jlechem77

Hello, I am a senior developer with over 10 years experience with C#, SQL, and Microsoft Office.

$200 USD за 2 дней(-я)
(0 отзывов(-а))
0.0