Tuesday, October 2, 2012

File Import Utility


XML DocumentImport

This tool allows XML files on disk (local or UNC) to be imported into TaskCentre. It can retrieve a specific file specified or from a previous step, or a wild carded file name. If a wild carded selection is made it will retrieve the oldest file first so can be used to process files in the order that they are created.
When importing the file it will validate the file against a schema. This schema can be imported if it has been supplied, inferred from an XML file and if necessary manually modified to apply additional validation.
An option is present to allow file properties to be extracted and for these to be used in subsequent steps in the task.
The contents of the XML document imported can be consumed by other TaskCentre tools that consume XML such as connector tools, the XML to Recordset tool or Save as File.  

Flat File Import
The Flat File Import provide the ability to import flat files such as plain text or csv (delimited or fixed width), extract data from flat files and expose that information as either a recordset or XML for use in other TaskCentre BPM Tool, Import flat files types that have multiple record types i.e. orders and product lines within a single file and import flat files in sequence so that business applications are updated chronologically.
Common commercial uses for the Flat File Import Tool may include:
  • Integrate data that has been exported from one business application as a flat file to another business application e.g. ERP to CRM
  • Integrate accounting or sales force spreadsheet data by event
  • Integrate bank reconciliation data with your ERP solution
  • Integrate CSV or Text files exported from courier systems
  • Integrate sales data from ecommerce solutions or EDI gateways into primary business applications

C# import

libraries needed for C# to read csv and xls file

http://www.codeproject.com/Articles/8411/C-class-library-for-exporting-data-to-CSV-Excel-fi

http://www.csvreader.com/csv_samples.php

http://social.msdn.microsoft.com/Forums/en-US/adodotnetdataset/thread/0588466d-5a6b-4416-bff5-be53ad5ddc63

http://www.filehungry.com/product/windows_software/programming/components_&_libraries/spire_xls/

http://stackoverflow.com/questions/943153/converting-an-excel-xls-file-to-a-comma-separated-csv-file-without-the-gui

http://stackoverflow.com/questions/444522/import-and-export-excel-what-is-the-best-library


difference between csv and xls file

http://www.ehow.com/info_8250993_differences-between-csv-xls.html

http://answers.yahoo.com/question/index?qid=20090708004321AAjBZGF

http://www.differencebetween.net/technology/difference-between-excel-and-csv/

http://www.replicon.com/kb-4537

Wednesday, September 19, 2012

Process Model Churva

https://docs.google.com/viewer?a=v&q=cache:5N9ZGSpAnxYJ:www.dau.mil/pubscats/ATL%2520Docs/Sep_Oct_2012/Silvestrini_Parker_Sammito.pdf+&hl=en&gl=ph&pid=bl&srcid=ADGEESi31mPAIW03Z2rppnUJb2LxG1_y8K6JF08wXLS5LpD3L0hbDpzGgmf5sljPWvn_H8DYCFPzBNycuVbzmEnmpznqgxAFUV5GgflGOFlWdWcbSkHe2L6WHinsoNx5c9nXKJeyYR4L&sig=AHIEtbTfIZiknAE7Gf8xsS-4yCgEehUqcw

http://whatis.techtarget.com/definition/exploratory-model

http://www.ctg.albany.edu/publications/reports/survey_of_sysdev?chapter=8



http://www.robabdul.com/Data-Management-System-Software-Development-Cycle.asp

Monday, August 27, 2012

Additional info for RRL

http://www.databasejournal.com/features/postgresql/article.php/3288951/PostgreSQL-vs-MySQL-Which-is-better.htm

http://www.wikivs.com/wiki/MySQL_vs_PostgreSQL

http://facility9.com/2011/12/ten-reasons-postgresql-is-better-than-sql-server/

http://facility9.com/2011/12/ten-reasons-postgresql-is-better-than-sql-server/

Wednesday, August 1, 2012

Applied Sql Server CRUD Stored Procedure

Based on the inspiration on a thesis last year. this topic helps developers to optimize the use of database via C#.. With the combination of CRUD and Stored Procedure has security that can prevent sql injection.

http://en.wikipedia.org/wiki/Stored_procedure

http://searchoracle.techtarget.com/definition/stored-procedure

http://databases.about.com/od/sqlserver/a/storedprocedure.htm

http://www.sql-server-performance.com/2003/stored-procedures-basics/

http://www.databasejournal.com/features/mssql/article.php/3082201/Implementing-CRUD-Operations-Using-Stored-Procedures-Part-1.htm

http://blog.sqlauthority.com/2007/04/13/sql-server-stored-procedures-advantages-and-best-advantage/

http://stackoverflow.com/questions/274411/do-stored-procedures-really-boost-performance-in-ms-sql-net

http://searchsqlserver.techtarget.com/news/1052737/Why-use-stored-procedures

http://searchdatamanagement.techtarget.com/definition/CRUD-cycle

http://social.msdn.microsoft.com/forums/en-US/architecturegeneral/thread/c6864235-5645-4632-93be-15d4d9bd286d/

http://developtime.blogspot.com/2012/04/performing-crud-operations-with-stored.html

http://sqlblog.com/blogs/paul_nielsen/archive/2009/05/09/why-use-stored-procedures.aspx

Thursday, July 12, 2012

TMC Traffic Navigator in Davao City- by Celine Olea

The Metropolitan Manila Development Authority (MMDA) has a new monitoring system which is the MMDA Traffic Navigator, it was released last November 2011. So, we decided if we can create this kind of system here in Davao City. Base on our research this kind of development has not applied in Davao City. These would be a big help in our Traffic Management Center.

http://mmdatraffic.interaksyon.com/system-view.php
http://mmdatraffic.interaksyon.com/line-view-edsa.php
http://mmdatraffic.interaksyon.com/map-view-edsa.php

Thursday, July 5, 2012

Final Concept: Heart Rate Monitor

We finally come up our final concept since we already found a SDK (Software Development Kit) and other hardware monitoring tools for it.

http://www.zephyranywherestore.com/hxm-software-developer-kit/

http://www.zephyr-technology.com/resources/sdk

We can't decide whether we'll use android based or any platform.

Sunday, July 1, 2012

Won’t find porn in the Windows Phone 7 by Celine Olea


Windows phone is cracking down on racy window mobile apps. Windows Mobile decided to imitate the "no porn policy" of Apple. Windows Mobile don't allow apps containing 'sexually suggestive or provocative' images or content in their phones. This is about presenting the right content to the right customer and ensuring that apps meet their standards. And all applications that is being offered will need to surpass a certain application certification requirements inorder to ensure the assurance of the app.


With this, i has a great advantage on childrens and teens that are using windows mobile. This will refrain from downloading pornographic images or contents that are not suitable for their ages. :)


Reference:
http://windowsteamblog.com/windows_phone/b/wpdev/archive/2012/04/30/four-ways-we-re-improving-marketplace.aspx

Wednesday, June 27, 2012

Back up and Restore feature Windows Phone 7 by Armand John Virrey

With the use of Zune desktop software it can provides back up on the phone but it only requires when there is a phone update. Other than Zune there is now way it can be back up or restore manually. This can help WP users if there is need of reformatting the WP or replacement of the phone itself. But it will only back up contact, messages and some important files that WP users keep.

Refrences:
http://techie-buzz.com/mobile-news/windows-phone-wish-list-2012-2.html?tb_spage=true

Tuesday, June 26, 2012

heart rate monitor in Windows Mobile 7 by Joshua Colanggo

Runtastuc Heart Rate Monitor (http://wmpoweruser.com/runtastic-heart-rate-monitorthe-first-to-support-windows-phone-7)  the application lack some emergency feature like an automated calling for help because when you suffer a heart attack you can easily lost consciousness and it also means lesser chances of surviving. What I was thinking is to add a feature wherein an auto dialer or somewhat emergency feature that will quickly notify the patient's doctor, even 911 and contact person. It will also notify the curent location of the user and any information needed for quick response.

ePayment using NFC in Windows Mobile 7 by Joshua Colanggo

Just like Singapore's cash card (http://www.nets.com.sg/consumers/nets_faqs.php) there's no need to carry cash. In fact Globe Telecommunications already had this service last 2006 but its only for MRT (Mass Rail Transit) (http://www.mb.com.ph/node/101355). The goal is to create a quick way of paying for transactions like in taxis, cashiers, or any payment transaction. All you need to do is top-up your account and it can be used for payment. It's like reloading your mobile phone and the credits will be consumed for sms and calls.

Monday, June 18, 2012

Windows Mobile by joshua colanggo

My colleagues are looking forward in an Android based development so I decided to look for other opportunity in mobile development using Windows Mobile platform as there's only a few developers working for it. To make our thesis unique and independent. Unlike Android, iOS and not to mention Symbian, there are thousands of developers compared to the Windows' recently debuted Windows Mobile 7 platform. As I read some whereabouts and thoughts of how Windows Mobile development goes, it's like building an application software using Visual Studio 2008 and if you're familiar with C# or VB.net then you're good to go.

http://msdn.microsoft.com/en-us/windowsmobile/bb264318.aspx

http://msdn.microsoft.com/en-us/windowsmobile/bb975138.aspx

http://archive.msdn.microsoft.com/WM6YourFirstApp

http://msdn.microsoft.com/en-us/library/bb158619.aspx

http://msdn.microsoft.com/en-us/library/bb677133.aspx


Update: as Windows Mobile 7 was released a new and more advanced IDE was also made. Visual Studio 2010 for Windows Phone *express version is also available.

As described in this article:

http://mobile.tutsplus.com/tutorials/windows/introduction-to-windows-mobile-7-development/

There are two ways of developing an application software for Windows Mobile 7, as the development process for the latest version of Windows Mobile is now different as it employs Silverlight for data driven software and XNA if you want to venture out for game development.

Android Invasion


Android is basically a Linux based operating system developed by Google specifically for the mobile applications.

Good thing about Android is that it is easy to use and since it is open source, there is a great opportunity for freelancer developers. Unlike the iPhone application development, which is done in objective C, Android application development is usually done in Java, although various C/C++ libraries are utilized by various components of the Android system.

Android SDK is equipped with all the necessary tools and application interfaces required to start the Android application development in JAVA language.

Important features of Android platform include tools which are easy to handle and understand, support for WiFi, Bluetooth and 3G, and availability of integrated Google applications.

Android Application Developer provides a quick, high excellence and cost-effective resolution to all customers willing to add essence to it.

Sunday, June 17, 2012

It's time for android!!!


Thou thinking ideas on what to do in our thesis instead I made a research on how and what is android. Android is a software used on mobile devices that runs a operationg system making it similar like a portable personal computer. Some applications that have the same functions on what we use on our computers like MS Office. In order to make this kind of application we need to use Android SDK that includes Java SDK and Eclipse IDE. So learning the basics is important in order for us to create an application if we have already an idea.

References:
http://developer.android.com/sdk/requirements.html

http://www.ibm.com/developerworks/opensource/library/os-android-devel/

http://developer.android.com/guide/basics/what-is-android.html

food for thought:
1. seeing some examples it has similar syntax with C# even thou it uses Java.

2. By this week or next week we already an idea on our thesis

3. Any recommendations where can install the SDK windows 7 or ubuntu?

by Armand John Virrey

Thursday, June 14, 2012

Android SDK: Laptop Finder App


Laptop finder application

In our own idea it is a concept in which,  it can locate any kinds of computer through Wifi access and also on 4G system (It was suggested by our supervisor in our OJT).


This is just our idea, it is not final yet. :)