Find Jobs
Hire Freelancers

Webpage for Data Upload to mySQL using VB.NET

$100-300 USD

In Progress
Posted over 18 years ago

$100-300 USD

Paid on delivery
Please quote Price and delivery Time. Project Title: Webpage for Data Upload to mySQL using VB.NET Deliverables: VB.NET ASPX page with: Company File Name to upload: _____________________ Address File Name to upload: _____________________ Start button [login to view URL] 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 7.1.3088 Microsoft .NET Framework 1.1.4322 SP1 MySQL 4.1.11 ____________________________________________________________________________ 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 [login to view URL] ___________________________________________ 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 $10.00 per month. Check with foreman before ordering." ___________________________________________ Test Data - Upload Data file [login to view URL] ___________________________________________ 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 '0.00000', `Longitude` double(10,5) NOT NULL default '0.00000', `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;
Project ID: 36980

About the project

18 proposals
Remote project
Active 18 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

About the client

Flag of UNITED STATES
Los Angeles, United States
0.0
0
Member since Dec 3, 2005

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.