Thursday, July 16, 2009

Just an Update

 

What have I been up to over the last couple of days? Well I was trying to understand the ASP.NET MVC framework and how it works. I have been hearing a lot about (seeing/reading a lot about?) the ASP.NET MVC framework and wanted to gauge whether I should switch over to MVC framework for my latest project. After all, its supposed to be more maintainable, supports TDD and gives you greater control over the html which is generated. Plus my friend who will be helping me with this project is a java developer and the web application to him means MVC.

However, having seen a couple of videos where a sample data driven application was built using MVC, I realized that for now I am sticking with webforms. I am just so used to it that it will take time to switch. And I don't have the time. Not right now! Switching over to MVC has its obvious advantages, but the time taken to learn it just outweighs those advantages. So webforms it is for the time being.

Now that I decided on webforms, I started getting my hands dirty doing database design. A part of it is proving to be more challenging than I initially thought. Anyway I have decided on the db and now plan to upload some data to validate the design. This is a real pain. The data is available as static text and I need to manually recognize various fields from that text and write (cut and paste) those values in a spreadsheet. This is such a pain. I wish I did not have to do it manually, but cant help it. Of course I am looking at ways to automate the whole process but I think it will take time. Right now I just need to get the data in the database so I can continue building my app.

Of course I will also need to build a utility to upload data to the db from excel. Reminds me of the pdm_upload utility that came with Service Desk. That experience of bulk data uploading is going to come handy now :). So I got my hands full for the time being. That's good! There are a whole lot of other things to take care of as well.

12 comments:

  1. This collating data into excel is proving to be very painful... A lot of donkey work if you ask me...

    ReplyDelete
  2. Will develop the excel upload utility later.. putting data into excel is just tooooooooooooo boring.. gonna develop admin screens for data upload from front end first...

    ReplyDelete
  3. Why can't you make a script to read the db and write it out as a simple csv file? I am guessing the db data is ordered correctly.

    I had to actually do the same not a db but from a really strange cern/fortran 77 formatted output file recently.

    Cheers
    Rahul

    ReplyDelete
  4. That's the catch Rahul. There is no data in the db. I have to put data in the db. I am getting data from various websites and it is not present in a structured(normalized?) form. Its present as simple sentences. This makes sense to us humans but alas not machines. Recognizing data in these sentences would be a pattern recognition problem I think. e.g Ram and Shyam have a savings bank account and current bank account respectively at the Indiranagar and Koramangala branches of ICICI bank respectively. Here Ram and Shyam (customer table), savings and current (account type table) Indiranagar and Koramangala (branches table) and ICICI bank (banks table). Now the sentence can be framed in any order so right now I am manually entering data. Hope you got what I am trying to say. Thanks for sharing your thoughts.

    ReplyDelete
  5. This comment has been removed by a blog administrator.

    ReplyDelete
  6. Your blog keeps getting better and better! Your older articles are not as good as newer ones you have a lot more creativity and originality now keep it up!

    ReplyDelete
  7. I'm the sort of guy who passions to seek recent stuff. Right now I am manufacturing my personal photovoltaic panels. I'm making it all alone without the assistance of my staff. I'm utilizing the internet as the only path to acheive this. I encountered a truly awesome site that explains how to contruct photovoltaic panels and wind generators. The internet site explains all the steps involved in solar panel construction.

    I am not sure about how correct the data given there iz. If some people over here who had experience with these works can have a peak and give your feedback in the page it would be great and I'd extremely treasure it, because I truly would love to try [URL=http://solar-panel-construction.com]solar panel construction[/URL].

    Tnx for reading this. U people are great.

    ReplyDelete
  8. I just found the website who reviews about
    many
    home based business reviews

    If you want to know more here it is
    home business opportunity
    www.home-businessreviews.com

    ReplyDelete
  9. good, i just added even more new emo backgrounds 2 my blog
    http://www.emo-backgrounds.info

    ReplyDelete
  10. So I was being totally retarded the other night and going through random websites and suddenly my computer was infected with some kind of virus thing with spyware and whatever. I don't know what's wrong with my computer, so I try to go to system restore, but system restore is infected and I can't restore anything :c. I just got a pop up telling me that spyware is infected or whatever. What's that mean and how can I fix it :c... I'm like freaking out :'c. [url=http://gordoarsnaui.com]santoramaa[/url]

    ReplyDelete
  11. I would appreciate more visual materials, to make your blog more attractive, but your writing style really compensates it. But there is always place for improvement

    ReplyDelete
  12. Not bad article, but I really miss that you didn't express your opinion, but ok you just have different approach

    ReplyDelete