okay, i posted before that i wanted someone to simply write some macros for me to pull some data into access...i have since realized that what i want it considerably more complex and involved and i've come to the realization that what is a stand-alone program written that can pull information from a comma-separated values file (a text file containing csv's is of course what i am referring to)

the file that will have to be read will contain two bits of information that will identify it - a number representing a location (in the format of 1600 being location one, 1601 being location two, etc.) as the first value in the string of csv's and a date in the form of 20060101 (which of course is january 1, 2006) which is the second value in the string

following those two values are several hundred additional values which will either be numbers or completely blank - i want each of these values to be in their own category (or subcategory), so that they can be indexed and searched by location and/or date range

additionally, these files will change on a daily basis (but will contain the same number of values), so i want the program to STORE all the old values...obviously, what i want in the end is a searchable database of information that i pull in on a regular basis

i used to program a long time ago and this is WAY beyond me...but it's exactly what i found fun about programming - being able to start from scratch and create something on your own...this is a paid gig (probably not hourly but on a project-completion basis), it will look good on your resume and since the program will PROBABLY need to be updated on a fairly regular basis, you will of course be the person who will be paid (again) to make the changes

i would prefer this done in java since it's platform-independent, but if you'd prefer to write this in something else (php, sql?, c++) give me a heads up and we can talk about it

oh, and i'm going to post this same thread in tech talk...mods, please forgive me? i just thought it would fit in both places

1/28/2006 4:02:03 PM

1. this is not hard
2. perl exists for shit like this
3. get rid of the flat files
4. i hope you get someone who knows how to design a database

[Edited on January 28, 2006 at 5:41 PM. Reason : sdf]

1/28/2006 5:41:23 PM

^ God, I admire you.

1/28/2006 7:07:34 PM

i never said it was hard...which is why some lucky college kid is going to make some money doing something fairly easy

1/28/2006 7:14:19 PM

I'll do it in java for 300....I've wrote very similar database programs like this b4. I figure it will take 20-30 hours to complete. PM me if interested

1/29/2006 10:42:50 PM

$10/hr?

1/29/2006 11:05:29 PM

^^write it in Object Rexx, Object Rexx is extremely useful for using sql commands for dropping data into a database. Less than half a day. Rexx is also platform independant easy to learn and is a lot like perl very flexible on the scripting structure.

http://www.oorexx.org/

[Edited on January 30, 2006 at 12:01 AM. Reason : .]

1/29/2006 11:57:59 PM

Quote :

"i never said it was hard...which is why some lucky college kid is going to make some money doing something fairly easy"

how much money are you talking about?

1/30/2006 12:58:16 AM

i'm not posting a set amount because as there are so many people interested, i am planning on taking bids...i've got 5 or 6 people with solid resumes who i will be scheduling for an interview...once they understand more clearly what the parameters are, they can more accurately give me a bid

1/30/2006 4:53:24 PM