Log Base Two

Jott To Facebook

http://apps.new.facebook.com/jotttofacebook/

Jott to facebook

Ok I just wrote a quick web application that will update your facebook status by calling Jott.

For all of you who do not know what Jot is here is a little description I found of them:

Jott is a communication and organization service which converts your voice to text.  With one phone call within the U.S. to 866-JOTT-123, or in Canada to the appropriate local access number, you can send emails and text messages to contacts, set reminders, post to web services such as Google™ Calendar and Blogger™, and manage your to-do list

And you can update your facebook status!!

I have seen some people on the internet looking for such a program. This is a very new project so please email me if you have any problems/suggestions/questions.

In the next phase,I am going to create a profile box that contains all the recent jotts. So ‘Jott To Facebook’ users can jott directly to each other’s profiles. I would rather jott directly to the wall but I don’t see any call in API for that.

Posted in Programming | Comments Off

MS-DOS Dataflex to SQL

For a job, I had to migrate an old MS DOS based Dataflex database to PostgresSQL. After a few months, I found a way to get the table structures and the data out of the files. Once I had the data, I wrote a few scripts in Ruby. One of them converts the Dataflex file layout to multiple SQL create table statements. Another one, converts the data extracted from the database to insert statements. They work very well and I have used them about 4 times for conversions and have gotten the process down to just a weekend, therefore, minimizing down time for clients.

If you are planning on attempting this task yourself here are some valuable tips:

1. Do not export or record OVERLAPs. They are in essence the way dataflex recognizes multiple column primary/foreign keys.
2. Export your data to Line Delimited Format. Not CSV or Tab separated.
3. Don’t edit columns or tables until all the data is migrated.

I might edit this post later to give some examples.

If you would like to contact me, please click the contact link to leave me a message.

Posted in Programming | No Comments »