I admit, I could easily have over looked something simple (a given) but I don’t get why almost no one seems to have pointed out that ubuntu is different from Debian or other GNU/Linux distributions in that they name the package myodbc a bit differently?

I was following some of the reference material for connecting open office’s base2 to a mysql database and use the tools to build something with it, you know … for fun.

See … in Ubuntu GNU/Linux Instead of calling the package myodbc they call it libmyodbc, this was a bit confusing an took me awhile to figure out to properly configure odbc to work with my mysql database.

I love apt

# apt-get install libmyodbc mysql-client mysql-server unixodbc odbcinst1debian1 libmysqlclient12

I had wanted for some time to test the oobase2 functionality I had heard about in open office’s database frontend component which offers the ability to connect, open and work with a MySQL database inside open office via an odbc connection.

ODBC / MySQL Settings for Ubuntu

$ cat /etc/odbcinst.ini
[MySQL]
Description = MySQL driver
Driver = /usr/lib/odbc/libmyodbc.so
Setup = /usr/lib/odbc/libodbcmyS.so
CPTimeout =
CPReuse =

$ cat /etc/odbc.ini
[leads]
Description = Leads MySQL database leads
Driver = MySQL
Server = localhost
Database = leads
Port = 3306

# /etc/init.d/mysql start
# mysqladmin -u root create leads -p
# isql -v leads graham publish
# oobase2

The Reason

Now I had a real reason … not like they care. I need a lead / contact management system.

Specifically to document and track … Employment Opportunities, Employment Firms, Employment Contacts, Opportunity Status, Opportunity Details. I could also use a call log, notes, and a bunch of other little things.

This all started from a perspective of job seeker, new to the scene, trying to document the people, companies, contact, job details one really should track when looking for a job and talking with a lot of different people about a lot of different jobs. Hint: Headhunters get really really rude and upset if they find out you have already been applied for a position by another staffing firm! Lesson Learned …

Tracking it all by hand is just insane

I don’t really believe it is possible to track 100% all of the information involved all the time, or track it all and give a good interview over the phone at the same time. That said, with good tools you can make a sizeable dent at the problem, I’m not beat yet.

Though, if you are like me you could easily submit over 35 different entries online via email, website (via any other of the hundreds if not thousands of smaller job sites that require registration but do very little for a person after registration), or talk with over 25 different people over the phone in a single week and complete over 5 different in person first round interviews. They really expect you track all of this yourself, including the over 75% of them which you never hear from again and gain employment through all of it.

It gets worse

All of these sites, firms, companies, every one of them want a lot from the job seeker but rarely provide very much to the masses who frequent them. Case in point, where is the web service support from these companies to help a job seeker from duplicate submission or job status tracking through out the interview / employment process? Your little more a short term commodity to them or something …

These people should be offering tools to help the job seeker rather than treat them like rats in the maze. From wishlist, submission, followup, closed or hired … few really offer much more than resume spamming services and badly at that …

I actually had someone ask for my ssn over the phone in a cold call, I was horrified. It just served to remind me … it’s a cement jungle out there.

Demand more ..

I just want them to at least offer more for my information I am giving out, they make a lot of money off of us and our information.

They compete against each other but few are raising the bar of services offered.

All I want is all the about my information, my submission information + timestamps made available via authenticated ssl xml so I can suck it into my own web based tracking app / service.

What more harm can they do by giving us back the information we have access to already, in an actually useful format? They already spam the world with the details of our lives without real thought or planning.

The reality is this is the way it is and it’s hardly going to change any time soon, you can’t fake or make people care about the people who use your service like job seekers, if you view them as a sea of things to be used rather than empowered and teamed with …
I would not want to work for them :\

Looking for something like this …

Man must have had developed tens of thousands of them over the course of time. I did not see a single one which was targeted towards my needs or purpose, let alone licensed as free or open source software written with a web application or GNU/Linux kid in mind… grrr.

Updated: Proof that I am not alone and that the industry will (all be it slowly) move in this direction. Just look for the job sites providing rss feeds for jobs and more people to insist on open xml formats to encompase employee / job information.

References:
OpenOffice.org 1.0, ODBC, and MySQL ‘How-to’
Connecting Openoffice.org’s Writer and MySQL on Debian GNU/Linux
OpenOffice Base And MySQL
Adding New User Accounts to MySQL