http://www.andresorrego.com/portal Software Development Fri, 02 Sep 2011 03:58:54 +0000 en hourly 1 http://wordpress.org/?v=3.3.1 http://www.andresorrego.com/portal/?p=27 http://www.andresorrego.com/portal/?p=27#comments Fri, 02 Sep 2011 03:52:25 +0000 aorrego http://www.andresorrego.com/portal/?p=27

(Read More...)]]> There is a new cool directory web-app for the Morgantown area. Point your smart phone’s browser to msm.m37.me and you will find a simple but very nice and useful application that will allow you to find businesses around Morgantown, and see all kinds of details including the hours of operation, phone, and address information. What’s interesting about this app is that it is specifically designed for smart phones and there is no need to zoom-in here and there to find the important information you are looking for. Check it out!

]]> http://www.andresorrego.com/portal/?feed=rss2&p=27 0 http://www.andresorrego.com/portal/?p=10 http://www.andresorrego.com/portal/?p=10#comments Fri, 10 Sep 2010 16:16:00 +0000 aorrego http://www.andresorrego.com/portal/?p=10

(Read More...)]]> I’ve been playing around with new ideas for designing a database for new projects. Usually I get pen and paper and start working out a database diagram that for one reason or another ends up looking more like a class diagram. After looking at it for some time, tweak it a bit, think about it, I then realize that I am not sure how to proceed… do not know how to easily put the data in the database. Lately I have been somehow successful populating a database by using an excel workbook following this process:

1. For each table (each class if you came up with a class diagram) use a sheet and list all the columns (attributes).
2. After you are done with 1) for all tables, create a new sheet and copy-paste all columns to a new sheet.
3. Start filling out the sheet generated in 2) creating rows with as much information as possible. If you see that more attributes are needed, add new columns in the main sheet and the table sheet.
4. From the main sheet, copy-paste the rows into the table-sheets accordingly.
5. Eliminate duplicate entries in table sheets.
6. Save each table sheet as a separate CSV file
7. Open PhpMyAdmin and select the appropriate database
8. Create all the tables populated in the Excel workbook
9. For each table, select the table name, click on import, locate the table csv file and enter its path into the “locate text file” field, skip the header column of the CSV by entering “1″ into the “partial import” field, select CSV as the “format of imported file”, and click “Go”.
10. If there are no issues with the format and contents of the CSV files, you should now have a fully populated database.

]]> http://www.andresorrego.com/portal/?feed=rss2&p=10 0