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 classifieds...mods, please forgive me? i just thought it would fit in both places

[Edited on January 28, 2006 at 4:03 PM. Reason : oops]

1/28/2006 4:02:27 PM

you can do this easily in access. Or php/mysql. Or Java/sql.

And it's going to cost you several thousand bucks.

1/28/2006 5:54:38 PM

Im pretty sure Access does this or something really close OOB

1/28/2006 5:59:47 PM

Quote :

"Im pretty sure Access does this or something really close OOB"

i'm sure it does to...but the people who want this want it completely automated, and don't want to have to buy licenses for access on all their computers (considerably more expensive)

also, unless someone wants to point me in the direction of some online resource that gives me a step-by-step on how to do this in access (not access for dummies), then this is my alternative

1/28/2006 7:16:54 PM

Quote :

"it's going to cost you several thousand bucks."

based on what?

1/28/2006 7:37:04 PM

based on what I know he wants this to do. It's a pretty trivial thing to do knowledge-wise, but I've done and estimated contracts on so many similar projects, any reputable individual or firm is going to charge thousands for it. In the 3-5k range most likely, probably a little more if you want a standalone Java app.

1/28/2006 8:20:52 PM

damn I'm in the wrong profession...

1/28/2006 8:54:50 PM

well, we'll see...i've got 3 people interested and two have sent their resumes...i've yet to post this around the campus, just tdub

1/28/2006 9:04:31 PM

will you post what you finally end up paying? Just currious.

1/28/2006 9:52:11 PM

key word - "contracts" hence the $$$.... but yes this the most basic form of what I deal with on a daily basis in a .NET environment - just remember that you will usually get what you pay for

1/28/2006 11:12:32 PM

I'll do it!1

1/28/2006 11:13:38 PM

programmers are cocksuckers for the most part. if i charge 10k i can mod my xbox!!!1

1/29/2006 12:21:50 PM

bttt...i've got 5 or 6 people with solid resumes, so i will be setting up interviews this week, i believe...if anyone else is interested, shoot me a pm

1/30/2006 4:54:03 PM