Team Trio.
Tuesday, October 9, 2012
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
|
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
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
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/
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
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
Subscribe to:
Posts (Atom)