GetAFreelancer.com
 
Find projectsSearch
Sign Up | Log in | Top Rated Users | Browse projects | Post Project | RSS feeds | Articles
 

Simple Monthly Report of Imported CSV Data.

   Click here to post similar project

Simple Monthly Report of Imported CSV Data. is project number 140692 posted at GetAFreelancer.com. Click here to post your own project.

Status: Closed (Selected Service Provider)
Selected Providers: selected service provider ExactSystems
Budget: $30-100
Created: 04/23/2007 at 16:46 EDT
Bidding Ends: 05/03/2007 at 16:46 EDT
Project Creator: bjacobi View PM Post PM
Buyer Rating: 10.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/1010.00/10
(4 reviews)
Description: I would like to import a CSV file into a master database once a month. I need a report developed that will analyze that data.

The data will roughly consist of fields such as: Business Name, DBA, Address, Permit Number, Expiration Date. The 'Permit Number' will be unique to each business location & is valid for only 1 year. Because permits must be renewed yearly, the CSV file I import each month will contain nearly 99% of the permit numbers from the previous month. I need a report of the 1% of those numbers that were not previously on the list.

Additional information submitted:

04/23/2007 at 20:05 EDT:
I need to know who the new permit numbers are each month while maintaining a master database. The permit number never changes for a business location, they just renew their permit yearly.

04/23/2007 at 20:31 EDT:
I will manually import the CSV data. The only querying I would need is to know who the new permit numbers were at the time of each monthly import of the CSV data. Each monthly import may consist of importing multiple CSV files. I need to know the new permit numbers at the time of the import as well as look back at previous imports & determine who the new permit numbers were at that time.

04/23/2007 at 20:47 EDT:
Here is a sample file I would be importing each month.

04/23/2007 at 21:56 EDT:
I want to keep all records imported. I don't want to only apend the records with new license numbers to the existing data. This way I can get a historical view of any one business, at any point in time.

I want to do one import a month. When I run the import I want to select multiple CSV files and import them at once. This import will be referenced as the date the import was executed.

I want a report generated, based on that import date, detailing which license numbers are new.

I would prefer this be done in MS Access or functional in Open Office.

Thank you for all of your interest!


Additional files submitted:
Liquor05Thru14Allen.CSV
Report violation
Job Type:
  • Data Processing
  • Market Research
  • Windows
Database: MS Access
Operating system: MS Windows
Bid count: 13
Average bid: N/A

 

Related project
 
Fixing website search engine Featured
posted by Money1
Budget: $30-250
 

FREE Trial project for new buyers!

 

View Project Message Board     Post Message on Project Message Board
Messages Posted: 2

If you are the project creator or one of the bidders Log in as project creator or bidder for more options

Bid on This Project

Service Providers PMB Bid Delivery Within Time of Bid Provider Rating
Bids are hidden by project creator. Log in as project creator or bidder as the project creator or as one of the bidders to view bids.
Bid on This Project

 

[ Website Design ] [ EU Freelance ] [ Post Project Free ] [ GAF Top Users ]

What is GetAFreelancer.com? ( Read about the company )

Web Development doesn't have to be expensive. Outsourcing will cut your expenses by more than 50%. Companies of any size have used our web services. If you never tried to contract work to another part of the world you have your chance today. Sign up free!

Outsource projects and save a lot of money. Getting affordable freelance work, freelance programming and custom web design done for your website has never been easier. We provide a safe escrow environment and you don't release the money until project is completed. Outsourcing is hiring an outside organization to perform services such as information processing and applications development. GetAFreelancer.com helps webmasters, web designers, programmers, software developers and business owners to develop their projects. Our site is global and we have freelancers from India, Romania, Russia, Ukraine, United States, UK and many other parts of the world. Deposit money and don't purchase until your project is completed.

Find Webmaster Resources and Webmaster Forum. Take a look at Search Engine Submission.