Closed

Webpage for Data Upload to mySQL using VB.NET

This project was awarded to neeraj523 for $200 USD.

Get free quotes for a project like this
Employer working
Awarded to:
Project Budget
N/A
Total Bids
18
Project Description

Please quote Price and delivery Time.

Project Title:
Webpage for Data Upload to mySQL using [url removed, login to view]

Deliverables:
[url removed, login to view] ASPX page with:
Company File Name to upload: _____________________
Address File Name to upload: _____________________
Start button

[url removed, login to view] code for Start button
Read data from the two uploaded text files
and place data in mySQL database tables.

One file being uploaded contains the Company Name and CompanyID
The other file contains the Company Name and the Address information (but no CompanyID).
The two files need to be matched on Company Name and the linking table needs to link the Company table and Address table.
There are three mySQL database tables: Company, Address and CompanyAddress
The CompanyID, CompanyName and Notes should be placed in the Company table.
The data from the Address file should be placed in the Address table along with a new AddressID

A record should be added to the CompanyAddress table which links together the Company record and the Address record.
The Company Name in the Address data should be found in the Company Table to determine the CompanyID that goes in the CompanyAddress linking table.

I am running:
Microsoft Visual Studio Visual Basic [url removed, login to view]
Microsoft .NET Framework [url removed, login to view] SP1
MySQL [url removed, login to view]

____________________________________________________________________________
Example of data that the program should produce in the CompanyAddress table.
____________________________________________________________________________

CompanyAddressID, CompanyID, AddressID,
1,5,3
2,6,2
3,8,1

___________________________________________
Test Data - Upload Data file [url removed, login to view]
___________________________________________

CompanyID,CompanyName, Notes
5,"First Factory Corporation","Use this as the main address for all employees. Call before faxing information."
6,"Acme Apple Orchard","During apple season, leave message and followup within three days."
8,"Industrial Island Inc.","Alternate bridge on Route 33. Total charges can not exceed $[url removed, login to view] per month. Check with foreman before ordering."

___________________________________________
Test Data - Upload Data file [url removed, login to view]
___________________________________________

CompanyName,LocationName,Address1,Address2,City,State,Zip,Country,County
"Industrial Island Inc.","Headquarters","321 Main Street","Suite 120","River City","NY","10101-1234","U.S.A.","Appleton County"
"Acme Apple Orchard","Aardvark Farm","2000 Aardvark Avenue","","Appleville","Alabama","70809-1011","U.S.A.","Altimont County"
"First Factory Corporation","Plant 101","101 First Street","Foghorn Park","Ferndale","Kentucky","60606","U.S.A.","Fernquest County"



_________________________________
Script that creates mySQL tables
_________________________________

# Database : db1_dev2

DROP DATABASE IF EXISTS `db1_dev2`;

CREATE DATABASE `db1_dev2` /*!40100 DEFAULT CHARACTER SET latin1 */;

USE `db1_dev2`;

#
# Structure for table address:
#

DROP TABLE IF EXISTS `address`;

CREATE TABLE `address` (
`AddressID` int(11) NOT NULL auto_increment,
`LocationName` varchar(255) NOT NULL default '',
`Address1` varchar(255) NOT NULL default '',
`Address2` varchar(255) NOT NULL default '',
`City` varchar(30) NOT NULL default '',
`State` varchar(30) NOT NULL default '',
`Zip` varchar(10) NOT NULL default '',
`Country` varchar(30) NOT NULL default '',
`County` varchar(100) NOT NULL default '',
`Latitude` double(10,5) NOT NULL default '[url removed, login to view]',
`Longitude` double(10,5) NOT NULL default '[url removed, login to view]',
`Notes` text NOT NULL,
PRIMARY KEY (`AddressID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for table company:
#

DROP TABLE IF EXISTS `company`;

CREATE TABLE `company` (
`CompanyID` int(11) NOT NULL auto_increment,
`CompanyName` varchar(255) NOT NULL default '',
`Instructions` text NOT NULL,
`Notes` text NOT NULL,
PRIMARY KEY (`CompanyID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

#
# Structure for table companyaddress:
#

DROP TABLE IF EXISTS `companyaddress`;

CREATE TABLE `companyaddress` (
`CompanyAddressID` int(10) unsigned NOT NULL auto_increment,
`CompanyID` int(11) NOT NULL default '0',
`AddressID` int(11) NOT NULL default '0',
PRIMARY KEY (`CompanyAddressID`,`CompanyID`,`AddressID`),
KEY `AddressID` (`AddressID`),
KEY `CompanyID` (`CompanyID`),
CONSTRAINT `companyaddress_ibfk_1` FOREIGN KEY (`AddressID`) REFERENCES `address` (`AddressID`) ON DELETE NO ACTION ON UPDATE NO ACTION,
CONSTRAINT `companyaddress_ibfk_2` FOREIGN KEY (`CompanyID`) REFERENCES `company` (`CompanyID`) ON DELETE NO ACTION ON UPDATE NO ACTION
) ENGINE=InnoDB DEFAULT CHARSET=latin1;

Looking to make some money?

  • Set your budget and the timeframe
  • Outline your proposal
  • Get paid for your work

Hire Freelancers who also bid on this project

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