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.