Hello World Rhino ETL

Nov 25

Rhino-Etl is an Opensource framework for doing Extract Transform and Load of data (ETL) in C#. There are other commercial ETL products that can do this as well. I have mostly used Microsofts SSIS. It is easy to get started with SSIS and it has good performance. But in my humble opinion is it hard to keep track of the changes in the SSIS projects. All logical rules...

Read More

My chinese javascript sorting plugin is added to the datatables jQuery component on GitHub

Jul 23

Allan Jardine accepted the pull request I did. See here http://datatables.net/plug-ins/sorting#chinese-string. Yipee I am a contributor. On Github I first made fork on the plug-in repository. That copied it all to my GitHub repository. After that I made a local repository with GithHub for windows. The first thing I did was a branch on my local repository called...

Read More

ClosedXML det enkla sättet att exportera till Excel

Jul 23

I flera projekt har jag använt ClosedXML för att spara i Excelformat. Kan verkligen rekommendera den. Den förenklar OpenXML formatet betydligt. För ett exempel. Gå till den här demositen och klicka på Excel så laddas data som man ser till Excel. Lagerhantering. ClosedXML finns att hämta ned via Nuget eller codeplex. Det är bara att skriva: Install-Package ClosedXML...

Read More

Powershell run sql scripts

Jul 18

In my work today I have to run many sql scripts that other have written. We are talking 100 of them. They are configurations, T-SQL code changes, moving data, patches from developers. They can be in nested directories. Some times some of them fail for different reason. I have used Powershell for this. But decided now to try to refine the script and also make it...

Read More

排序中国汉字字符 javascript – Datatables – jQuery

Jun 27

为了学习为jQuery 的 组件数据表写插件 ,我为其做了一个专门的网站http://sorting.lcube.se/ 。您可以尝试为不同的术语排序。我打算解释中国字符的排序,并告诉大家我的排序方法和在此期间遇到的麻烦。 我遇到的第一个问题是,我认为三是在二之后出现的。我曾经深信这是一个错误。但通过仔细思考之后,我意识到数字3三的部首里的笔画数少于二的部首数量,二的部首里有两个笔画。 今天,在JavaScript只有少许的几行代码 。诀窍是使用 localCompare ( 参考 )。然而众所周知这一功能在不同的网页浏览器存在这问题。DataTables 的作者Allan Jardine给我指出了这一点。我会在我的博客上进一步探索看是否给汉字排序带来问题。...

Read More