Day to day good stuff I find regarding my work

Saturday, April 22, 2006

Monday, April 17, 2006

Wednesday, April 12, 2006

Support for Turkish or not in Livelink 9.2

main reason is that it takes time to support more languages but if you are willing to take the cost you get maybe a better user support.,.,..

1) Right now you have a "pure" english version of XXXX exception vacation request that is written in Frensch supporting more languages that you don't know by heart means you need more people to maintain
example: check the language of the Turkish form

2) English is the company language of xxxx. If I work in Turkey and would like to use the form it needs also to be a english version ==> double the number of forms to support. Compare all emails
in Danish ….

3) Development of UTF applications in Livelink nothing we have experience of and I think it is
better supported in 9.5
The XXX application now supports UTF in the database which I understand means that you can store and search on most of the characters When doing applications in non English language my feelings that the development environment in Livelink 9.2 is a little bit shaky to support UTF development.
I have had problems with the frensch characters and hanging Livelink etc.
http://xxxx/Lists/Tasks3/DispForm.aspx?ID=222

see also the development forum on Knowledge
https://knowledge.opentext.com/knowledge/llisapi.dll?func=ll&objId=3545465&objAction=view&show=0

4) Problem adding the texts with HTML codes, takes time and creates error and difficult to support
Best and easiest way I have found to add foreign characters to WEBforms is using character entities
example character small sharp s = ß ß
as the Turkey language has 6 characters that are not present in ISO 8859-1 :
Dotted uppercase "I", dotless lowercase "i", upper- and lowercase "G" with breve accent, and upper- and lowercase "S" with cedilla.
as Turkey use ISO 8859-9 (Latin 5)

you need to add them as Codes
HTML code character Description
Ğ Ğ G Uppercase "G" with breve accent
İ İ I Uppercase dotted "I"
Ş Ş S Uppercase "S" with cedilla
ğ ğ g Lowercase "g" with breve accent
ı ı i Lowercase dotless "i"
ş ş s Lowercase "s" with cedilla

The text I created for the Turkey form looks like this

Sevgili xxx Nordisk Türkiye Çalisanlari,


Bu form ile, varolabilecek sorularinizi, sorunlarinizi, karşılaşabileceğiniz zorluklari daha iyi dinleyebilecek, sorulariniza cevap vermeye ve çözüm önerileri ile gelmeye çalisacagiz.Coğrafi lokasyonunuz sorun olmadan, bu formu iş veya personel ile ilgili her türlü konuda kullanabilirsiniz. Gönderdiğiniz soru veya konular, ilgili kişi tarafından ivedi şekilde değerlendirilecektir.


ISO 8859-1
http://en.wikipedia.org/wiki/ISO_8859-1
ISO 8859-5
http://en.wikipedia.org/wiki/ISO_8859-5


Added Question in Knowledge

Move Excel to SQLserver

Introduction to Excel Services,

Start look at

Office 2003 XML Reference Schemas
http://www.microsoft.com/office/xml/default.mspx

How to import data from Excel to SQL Server
http://support.microsoft.com/default.aspx?scid=kb;en-us;321686

Loading and reading the Microsoft Excel file contents using C#
http://www.codeproject.com/useritems/Excel_Application_in_C_.asp

Convert Excel to XML file/XML Schema, and validate Excel against XML Schema
http://www.codeproject.com/csharp/excel2xml.asp

Using the Excel 2003 XML Tools Add-in Version 1.1
http://msdn.microsoft.com/office/default.aspx?pull=/library/en-us/odc_xl2003_ta/html/OfficeExcelXMLToolAddin.asp

Office 2003: XML Reference Schemas
http://www.microsoft.com/downloads/details.aspx?FamilyId=FE118952-3547-420A-A412-00A2662442D9&displaylang=en


SQL DTS
http://www.sqldts.com/

Tuesday, April 11, 2006

Demo of office and ribbons

http://www.microsoft.com/office/preview/ui/demo.mspx

Thursday, April 06, 2006

Ndoc problem

Ndoc

Got a problem generating documentation. Fixed when restarting and did some changes to the assembly ...



Request for the permission of type System.Web.AspNetHostingPermission, System, Version=1.0.5000.0, Culture=neutral, PublicKeyToken=b77a5c561934e089 failed.

at System.Security.CodeAccessSecurityEngine.CheckTokenBasedSetHelper(Boolean ignoreGrants, TokenBasedSet grants, TokenBasedSet denied, TokenBasedSet demands)

at System.Security.CodeAccessSecurityEngine.CheckSetHelper(PermissionSet grants, PermissionSet denied, PermissionSet demands)

--------------------

Wednesday, April 05, 2006

Cool tools for c#

nDoc for documenting the code...
and GhostDoc that automatically generates C# documentation based on the name and parameters of what you are documenting.


FxCop code analysis tool FxCop Blog

DevMetrics measure complexity of code

see also Must have tools

O/R Mapping NHibernate

ScottGU List of cool tools

Maybe also Eight tips to make you more efficient as an ASP.NET developer

PROCESS MAPPING BY TUBE

Cool idea of using the tube layoyut for describing processes.

http://www.kaywebs.co.uk/process_maps.htm