How Software Gets Done  


Login

Software Buyers
Request bids
Search coders
My Buyer Account
Buyer help
Buyer articles
Buyer FAQ
Latest news
 
Software Coders
Newest open work
Browse all work
Search all work
My Coder Account
Coder help
Coder articles
Coder FAQ
Latest news
 
Affiliates
My Affiliate Account
Affiliate help
Affiliate FAQ
Latest news
 
Newest Bid Requests.
Simple 1-Page Website Redesign
By BuffaloRoam on Jul 11
Max Bid: Open to fair suggestions


web server Script to launch external program
By gulyasa on Jul 11
Max Bid: $20


New Site Design to Appeal to the Masses!
By sistervisiontec h on Jul 11
Max Bid: $100


JDBC/mySQL performance problem
By demosfen on Jul 11
Max Bid: Open to fair suggestions


Simple Text Chat
By Coderking on Jul 11
Max Bid: $300


Oscomerce Contributions
By sistervisiontec h on Jul 11
Max Bid: $100


Click here to put this ticker on your own site and/or get live RSS newsfeeds

Open Work Categories.
Database 
(145 open)
   Access 
(56 open)
   MySQL 
(79 open)
   Oracle 
(10 open)
   SQL Server 
(49 open)
   Other DB 
(19 open)
Documentation / Tech Writing 
(15 open)
Data Entry 
(21 open)
Game Development 
(26 open)
Graphics / Art / Music 
(54 open)
   Graphics 
(60 open)
     Adobe AfterEffects 
(1 open)
     Adobe Photoshop 
(19 open)
     Adobe Premiere 
(4 open)
     3d Animation 
(15 open)
   Art (Misc.) 
(20 open)
   Music 
(11 open)
   3d Modeling 
(12 open)
Language Specific 
(94 open)
   ASP 
(60 open)
   ASP .NET 
(38 open)
   C# 
(39 open)
   C++ / C 
(108 open)
   Carbon (Mac OS) 
(1 open)
   Cocoa / Obj-C 
(2 open)
   Cold Fusion 
(13 open)
   Delphi 
(26 open)
   Java 
(61 open)
   JSP 
(7 open)
   Perl 
(43 open)
   PHP 
(87 open)
   XML/XSL 
(30 open)
   Visual Basic 
(143 open)
   Visual Basic .Net 
(58 open)
   Other 
(51 open)
Misc 
(28 open)
   CAD 
(3 open)
MultiMedia 
(41 open)
   Video Editing 
(6 open)
Network 
(41 open)
   Network Design 
(12 open)
   Network Implementation 
(12 open)
Platforms 
(75 open)
   Windows 
(170 open)
     MS Exchange 
(5 open)
     MS Office 
(14 open)
     Other 
(14 open)
   Darwin 
(1 open)
   Internet Browser 
(43 open)
   Linux 
(57 open)
   UNIX 
(26 open)
   Hand Held/PDA Programming 
(9 open)
Requirements 
(13 open)
Security 
(29 open)
Testing / Quality Assurance 
(18 open)
Web 
(149 open)
   Page Design 
(81 open)
   Flash 
(45 open)
   Web Services 
(70 open)
   Web (Other) 
(69 open)
Training 
(10 open)
   Computer Based 
(9 open)
Other
 
Other Sites

Download the free Rent A Coder IE toolbar!
 
Show Bid Request

From Text to Management Reports
Bid Request Id: 55538
Bookmark in my 'To Do' list
Posted by: Tony4x4 (2 ratings)
(Software buyer rating 10)
Non-action Ratio: Very Good - 20.00%
Buyer Security Verifications: Good
Approved on: Mar 31, 2003
9:29:16 AM EDT
Bidding Closes: Apr 5, 2003
6:36:12 AM EDT
Viewed (by coders): 512 times
Deadline: 4/27/2003
TIME EXPIRED
Phase:
100% of work completed and accepted. Coder has been paid.
Max Accepted Bid: Bidding is closed
Project Type: Small Business Project: $100 (USD) +
Bidding Type: Open Auction
Categories: Windows, Visual Basic, Access, MS Office
Enter chat room for this bid request
(3 active users at Jul 12, 2003 4:27:43 AM EDT)

Description:
I am looking for a system that can import 3 different fixed width text files and import them into Access. From Access the user should be able to get a date range of data in the form of a report which then can be exported into Excel.

The text files are prn type files and therefore the header type information does not need to be imported. There will be 3 different format files. All 3 files have the same code for indexing i.e. 2100 = cigarettes / tobacco. The end result is a management report with bits of information from each file.

Please have a look at the attached 3 sample files as well as a sample output file.

There should be a import facility which will allow the user to import a specific file type (i.e. purchase, sales or Mark up/down) for a specific day.

The final report needs to be in Excel so that it can be easily portable.

In Access there may need to be an additional table containing the following fields: Code Description Department. You will notice in the sample files that certain codes are grouped into departments. Departmental Sub totals and totals do not need to be imported as these will be recalculated when producung the output.

Deliverables:
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.

2) Installation package that will install the software (in ready-to-run condition) on the platform(s) specified in this bid request.

3) Complete ownership and distribution copyrights to all work purchased.



Platform:
Win98 & XP
VB
Access 2000
Excel 2000


Must be 100% finished and received by buyer on:
Apr 27, 2003 EDT
Deadline legal notes: All times are expressed in the time zone of the site EDT (UT - 5). If the buyer omitted a time, then the deadline is 11:59:59 PM EDT on the indicated date.

Additional Files:
This bid request includes IMPORTANT additional attached files. Please download and read fully before bidding.



Remember that contacting the other party outside of the site (by email, phone, etc.) on all business projects < $500 (before the buyer's money is escrowed) is a violation of both the software buyer and seller agreements. We monitor all site activity for such violations and can instantly expel transgressers on the spot, so we thank you in advance for your cooperation. If you notice a violation please help out the site and report it. Thanks for your help.
 
Bidding/Comments:
All monetary amounts on the site are in United States dollars.
Rent a Coder is a closed auction, so coders can only see their own bids and comments. Buyers can view every posting made on their bid requests.

See all rejected bids (and all comments)
Name   Bid Amount 
 
Date   Coder Rating  
CodeHorse
(4 ratings)
in Watford, Herts
United Kingdom
Bid id: 596,548
 
$100 (USD) Mar 31, 2003
11:56:18 AM EDT
 10
(Excellent)
   
My bother and I work as a team. We have done a lot of work like this, though we are new to RentaACoder.

The price offered is a 'loss leader' as we need need to get some good ratings.

I am already working on the import routines.

Hope to hear from you.

David Smith
 
 
 
 
  See 2 private reply(ies)
to/from CodeHorse.
 

CodeHorse
(4 ratings)
in Watford, Herts
United Kingdom
Bid id: 599,665
 
$100 (USD) Apr 2, 2003
1:06:41 AM EDT
 10
(Excellent)
   
Just a quick update.

Parsing of the Mark Up/Down is complete, together with data transfer to Access DB.

The parsing routine will now need slight modification to handle the Profit and Purchases reports.

Once that is done, I will write the Excel routines to produce the final report.
 

CodeHorse
(4 ratings)
in Watford, Herts
United Kingdom
Bid id: 599,958
 
$100 (USD) Apr 2, 2003
5:13:20 AM EDT
 10
(Excellent)
   
Further update.

Design of the queries to extract data for the final report is in progress.

An issue with respect to the Access DB has arisen:-

What is the lifetime of the Access data? Will all data be added to the same Access DB, with manual archiving as appropriate? Or would you prefer to be able to choose a named Access DB on each run, re-using a DB if it exists, or creating a new one if it does not exist?
 

This bid was accepted by the buyer!
CodeHorse
(4 ratings)
in Watford, Herts
United Kingdom
Bid id: 600,158
 
$100 (USD) Apr 2, 2003
8:07:25 AM EDT
 10
(Excellent)
   
Update with Access DB, and test-bed illustrating Mark Up/Down file parsing.
Attached File
 
 
 
 
  See 15 private reply(ies)
to/from CodeHorse.
 




Quick Bid Request Search
 Advanced Search
Newest Open Work
Latest News  
Credentials


 

 
Rent A Coder upholds the rigorous business practices required to be both a BBB member and Square Trade vendor.
  • All customer issues addressed within 2 days
  • Openly disclosed pricing and return policies
  • Participation in mediation at buyer request
  • Superior selling track record
This site is verified through its parent company, Exhedra Solutions, Inc.
 
Top Coders.

Anuj Gakhar
Rated a 9.97 on 102 jobs 
Securenext
Rated a 9.96 on 109 jobs 
Buddies
Rated a 9.82 on 80 jobs 
Andrei Remenchuk
Rated a 10 on 13 jobs 
Codman
Rated a 9.97 on 149 jobs 
Michael Sharp
Rated a 9.97 on 181 jobs 
D-N-S
Rated a 9.93 on 37 jobs 
markesh
Rated a 10 on 22 jobs 
teleCODERS
Rated a 9.93 on 67 jobs 
Tometa Software, Inc.
Rated a 10 on 10 jobs 

See all top coders...

(What makes a top coder?)

Top Exam Scorers

 
Other
Rent A Coder is PayPal verified through its parent company, Exhedra Solutions, Inc.

Created in partnership with:

 

Affiliate Sites
Latest News | About Us | Kudos | Feedback/Contact    Affiliates | Advertise    Privacy | Legal

Copyright © 2001, Exhedra Solutions, Inc. All rights reserved.
By using this site you agree to its Terms and Conditions.
"Rent A Coder" (tm), "Safe Project Escrow" (tm) and "How Software Gets Done" (tm)
are trademarks of Exhedra Solutions, Inc.