Skip to content
September 13, 2011

Active Directory Attribute

Attr LDAP
Name
Attr Display Name ADUC Tab ADUC Field
accountExpires Account Account expires
accountNameHistory
aCSPolicyName
adminCount
adminDescription
adminDisplayName
allowedAttributes
allowedAttributesEffective
allowedChildClasses
allowedChildClassesEffective
altSecurityIdentities
assistant Assistant
badPasswordTime
badPwdCount
bridgeheadServerListBL
c Country Abbreviation Address Country/region
canonicalName Object Fully qualified
domain name of object
cn Name
co Country Address Country/region
codePage
comment Comment
company Company Organization Company
controlAccessRights
countryCode Address Country/region
createTimeStamp
dBCSPwd
defaultClassStore
department Department Organization Department
description Description General Description
desktopProfile
destinationIndicator
directReports Direct Reports Organization Direct reports
displayName Display Name General Display name
displayNamePrintable
distinguishedName X500 Distinguished
Name
division Division
dSASignature
dSCorePropagationData
dynamicLDAPServer
employeeID Employee ID
extensionName
facsimileTelephoneNumber Fax Number Telephones Fax
flags
fromEntry
frsComputerReferenceBL
fRSMemberReferenceBL
fSMORoleOwner
garbageCollPeriod
generationQualifier Generational Suffix
givenName First Name General First name
groupMembershipSAM
groupPriority
groupsToIgnore
homeDirectory Home Folder Profile Home folder: Local
path/To
homeDrive Home Drive Profile Home folder: Connect
homePhone Home Phone Telephones Home
homePostalAddress Home Address
info Notes Telephones Notes
initials Initials General Initials
instanceType
internationalISDNNumber International ISDN
Number (Others)
ipPhone IP Phone Number Telephones IP phone
isCriticalSystemObject
isDeleted
isPrivilegeHolder
l City Address City
lastKnownParent
lastLogoff
lastLogon
legacyExchangeDN
lmPwdHistory
localeID
lockoutTime Account Account is locked out
logonCount
logonHours Account Logon Hours
logonWorkstation
mail E-Mail Address General E-mail
managedObjects
manager Manager Organization Manager
masteredBy
maxStorage
memberOf Group Membership Member Of Member of
mhsORAddress
middleName Middle Name
mobile Mobile Number Telephones Mobile
modifyTimeStamp
mS-DS-ConsistencyChildCount
mS-DS-ConsistencyGuid
mS-DS-CreatorSID
mSMQDigests
mSMQDigestsMig
mSMQSignCertificates
mSMQSignCertificatesMig
msNPAllowDialin
msNPCallingStationID
msNPSavedCallingStationID
msRADIUSCallbackNumber
msRADIUSFramedIPAddress
msRADIUSFramedRoute
msRADIUSServiceType
msRASSavedCallbackNumber
msRASSavedFramedIPAddress
msRASSavedFramedRoute
name
netbootSCPBL
networkAddress
nonSecurityMemberBL
ntPwdHistory
nTSecurityDescriptor Security N/A
o
objectCategory
objectClass Object Object class
objectGUID
objectSid
objectVersion
operatorCount
otherFacsimileTelephoneNumber Fax Number (Others) Telephones Fax Number (Others)
otherHomePhone Home Phone (Others) Telephones Home Phone (Others)
otherIpPhone IP Phone Number
(Others)
Telephones IP Phone Number
(Others)
otherLoginWorkstations
otherMailbox E-Mail Address
(Others)
otherMobile Mobile Number
(Others)
Telephones Mobile Number
(Others)
otherPager Pager Number (Others) Telephones Pager Number (Others)
otherTelephone Phone Number (Others) General Phone Number (Others)
otherWellKnownObjects
ou
pager Pager Number Telephones Pager
partialAttributeDeletionList
partialAttributeSet
personalTitle Title
physicalDeliveryOfficeName Office Location General Office
possibleInferiors
postalAddress
postalCode ZIP/Postal Code Address Zip/Postal Code
postOfficeBox Post Office Box Address P.O. Box
preferredDeliveryMethod
preferredOU
primaryGroupID Member Of Primary group
primaryInternationalISDNNumber International ISDN
Number
primaryTelexNumber Telex Number
profilePath Profile Profile path
proxiedObjectName
proxyAddresses
pwdLastSet
queryPolicyBL
registeredAddress
replPropertyMetaData
replUpToDateVector
repsFrom
repsTo
revision
rid
sAMAccountName Logon Name
(pre-Windows 2000)
Account User logon name
(pre-Windows 2000)
sAMAccountType
scriptPath Profile Logon script
sDRightsEffective
securityIdentifier
seeAlso
serverReferenceBL
servicePrincipalName
showInAddressBook
showInAdvancedViewOnly
sIDHistory
siteObjectBL
sn Last Name General Last name
st State/Province Address State/province
street
streetAddress Street Address Address Street
subRefs
subSchemaSubEntry
supplementalCredentials
systemFlags
telephoneNumber Telephone Number General Telephone number
teletexTerminalIdentifier
telexNumber Telex Number (Others)
terminalServer
textEncodedORAddress
thumbnailLogo
thumbnailPhoto
title Job Title Organization Title
tokenGroups
tokenGroupsGlobalAndUniversal
tokenGroupsNoGCAcceptable
unicodePwd
url Web Page Address
(Others)
General Web Page Address
(Others)
userAccountControl Account Account options
userCert
userCertificate
userParameters
userPassword
userPrincipalName Logon Name Account User logon name
userSharedFolder
userSharedFolderOther
userSMIMECertificate
userWorkstations Logon Workstations Account Log On To/Logon
Workstations
uSNChanged Object Current USN
uSNCreated Object Original USN
uSNDSALastObjRemoved
USNIntersite
uSNLastObjRem
uSNSource
wbemPath
wellKnownObjects
whenChanged Object Modified
whenCreated Object Created
wWWHomePage Web Page Address General Web page
x121Address
August 22, 2011

ASP.NET MVC View Engine Comparison

ASP.NET MVC View Engines (Community Wiki)

Since a comprehensive list does not appear exist, let’s start one here on SO. This can be of great value to the ASP.NET MVC community if people add their experience (esp. anyone who contributed to one of these).  Anything implementing IViewEngine (e.g. VirtualPathProviderViewEngine) is fair game here.  Just alphabetize new View Engines (leaving WebFormViewEngine at the top), and try to be objective in comparisons.


System.Web.Mvc.WebFormViewEngine

Design Goals:

A view engine that is used to render a  Web Forms page to the response.

Pros:

  • ubiquitous since it ships with ASP.NET MVC
  • familiar experience for ASP.NET developers
  • IntelliSense
  • can choose any language with a CodeDom provider (e.g. C#, VB.NET, F#, Boo, Nemerle)
  • on-demand compilation or precompiled views

Cons:

  • usage is confused by existence of “classic ASP.NET” patterns which no longer apply in MVC (e.g. ViewState PostBack)
  • can contribute to anti-pattern of “tag soup”
  • code-block syntax and strong-typing can get in the way
  • IntelliSense enforces style not always appropriate for inline code blocks
  • can be noisy when designing simple templates

Example:

<%@ Control Inherits="System.Web.Mvc.ViewPage<IEnumerable<Product>>" %> <% if(model.Any()) { %> <ul> <% foreach(var p in model){%> <li><%=p.Name%></li> <%}%> </ul> <%}else{%> <p>No products available</p> <%}%> 

Bellevue

Design goals:

  • Respect HTML as first-class language as opposed to treating it as “just text”.
  • Don’t mess with my HTML! The data binding code (Bellevue code) should be separate from HTML.
  • Enforce strict Model-View separation

Brail

Design Goals:

The Brail view engine has been ported  from MonoRail to work with the  Microsoft ASP.NET MVC Framework. For  an introduction to Brail, see the  documentation on the Castle project  website.

Pros:

  • modeled after “wrist-friendly python syntax”
  • On-demand compiled views (but no precompilation available)

Cons:

  • designed to be written in the language Boo

Example:

<html> <head> <title>${title}</title> </head> <body> <p>The following items are in the list:</p> <ul><%for element in list: output "<li>${element}</li>"%></ul> <p>I hope that you would like Brail</p> </body> </html> 

Hasic

Hasic uses VB.NET’s XML literals instead of strings like most other view engines.

Pros:

  • Compile-time checking of valid XML
  • Syntax colouring
  • Full intellisense
  • Compiled views
  • Extensibility using regular CLR classes, functions, etc
  • Seamless composability and manipulation since it’s regular VB.NET code
  • Unit testable

Cons:

  • Performance: Builds the whole DOM before sending it to client.

Example:

Protected Overrides Function Body() As XElement Return _ <body> <h1>Hello, World</h1> </body> End Function 

NDjango

Design Goals:

NDjango is an implementation of the  Django Template Language on the .NET  platform, using the F# language.

Pros:


NHaml

Design Goals:

.NET port of Rails Haml view engine.  From the Haml website:

Haml is a markup language that’s used  to cleanly and simply describe the  XHTML of any web document, without the  use of inline code… Haml avoids the  need for explicitly coding XHTML into  the template, because it is actually  an abstract description of the XHTML,  with some code to generate dynamic  content.

Pros:

  • terse structure (i.e. D.R.Y.)
  • well indented
  • clear structure
  • C# Intellisense (for VS2008 without ReSharper)

Cons:

  • an abstraction from XHTML rather than leveraging familiarity of the markup
  • No Intellisense for VS2010

Example:

@type=IEnumerable<Product> - if(model.Any()) %ul - foreach (var p in model) %li= p.Name - else %p No products available 

NVelocityViewEngine (MvcContrib)

Design Goals:

A view engine based upon  NVelocity which is a .NET port  of the popular Java project  Velocity.

Pros:

  • easy to read/write
  • concise view code

Cons:

  • limited number of helper methods available on the view
  • does not automatically have Visual Studio integration (IntelliSense, compile-time checking of views, or refactoring)

Example:

#foreach ($p in $viewdata.Model) #beforeall <ul> #each <li>$p.Name</li> #afterall </ul> #nodata <p>No products available</p> #end 

Razor

Design Goals:

Pros:

  • Compact, Expressive, and Fluid
  • Easy to Learn
  • Is not a new language
  • Has great Intellisense
  • Unit Testable

Cons:

  • No documented API

SharpTiles

Design Goals:

SharpTiles is a partial port of JSTL  combined with concept behind the Tiles  framework (as of Mile stone 1).

Pros:

  • familiar to Java developers
  • XML-style code blocks

Cons:

Example:

<c:if test="${not fn:empty(Page.Tiles)}"> <p class="note"> <fmt:message key="page.tilesSupport"/> </p> </c:if> 

Spark View Engine

Design Goals:

The idea is to allow the html to  dominate the flow and the code to fit  seamlessly.

Pros:

  • Produces more readable templates
  • C# Intellisense  (for VS2008 without ReSharper)
  • SparkSense plug-in for VS2010 (works with ReSharper)
  • Provides a powerful Bindings feature to get rid of all code in your views and allows you to easily invent your own HTML tags

Cons:

  • No clear separation of template logic from literal markup (this can be mitigated by namespace prefixes)

Example:

<viewdata products="IEnumerable[[Product]]"/> <ul if="products.Any()"> <li each="var p in products">${p.Name}</li> </ul> <else> <p>No products available</p> </else> <Form style="background-color:olive;"> <Label For="username" /> <TextBox For="username" /> <ValidationMessage For="username" Message="Please type a valid username." /> </Form> 

StringTemplate View Engine MVC

Design Goals:

  • Lightweight. No page classes are created.
  • Fast. Templates are written to the Response Output stream.
  • Cached. Templates are cached, but utilize a FileSystemWatcher to detect  file changes.
  • Dynamic. Templates can be generated on the fly in code.
  • Flexible. Templates can be nested to any level.
  • In line with MVC principles. Promotes separation of UI and Business  Logic. All data is created ahead of  time, and passed down to the template.

Pros:

  • familiar to StringTemplate Java developers

Cons:

  • simplistic template syntax can interfere with intended output (e.g. jQuery conflict)

Wing Beats

Wing Beats is an internal DSL for creating XHTML. It is based on F# and includes an ASP.NET MVC view engine, but can also be used solely for it’s capability of creating XHTML.

Pros:

  • Compile-time checking of valid XML
  • Syntax colouring
  • Full intellisense
  • Compiled views
  • Extensibility using regular CLR classes, functions, etc
  • Seamless composability and manipulation since it’s regular F# code
  • Unit testable

Cons:

  • You don’t really write HTML but code that represents HTML in a DSL.

XsltViewEngine (MvcContrib)

Design Goals:

Builds views from familiar XSLT

Pros:

  • widely ubiquitous
  • familiar template language for XML developers
  • XML-based
  • time-tested

Cons:

  • functional language style makes flow control difficult

source:

http://stackoverflow.com/questions/1451319/asp-net-mvc-view-engine-comparison

August 18, 2011

SSIS Prefix Naming Convention

For Task

Task Prefix
For Loop
Container
FLC
Foreach Loop
Container
FELC
Sequence
Container
SEQC
ActiveX Script AXS
Analysis
Services Execute DDL
ASE
Analysis
Services Processing
ASP
Bulk Insert BI
Data Flow DF
Data Mining
Query
DMQ
Execute DTS
2000 Package
EDP
Execute
Package
EP
Execute
Process
EPR
Execute SQL SQL
File System FS
FTP FTP
Message Queue MQ
Script SCR
Send Mail SM
Transfer
Database
TDB
Transfer Error
Messages
TEM
Transfer Jobs TJ
Transfer
Logins
TL
Transfer
Master Stored Procedures
TSP
Transfer SQL
Server Objects
TSO
Web Service WS
WMI Data
Reader
WMID
WMI Event
Watcher
WMIE
XML XML

For Component

Component Prefix
DataReader
Source
DR_SRC
Excel Source EX_SRC
Flat File
Source
FF_SRC
OLE DB Source OLE_SRC
Raw File
Source
RF_SRC
XML Source XML_SRC
Aggregate AGG
Audit AUD
Character Map CHM
Conditional
Split
CSP
Copy Column CPC
Data
Conversion
DC
Data Mining
Query
DMQ
Derived Column DER
Export Column EXP
Fuzzy Grouping FZG
Fuzzy Lookup FZL
Import Column IMPT
Lookup LKP
Merge MRG
Merge Join MRJ
Multicast MLT
OLE DB Command CMD
Percentage
Sampling
PS
Pivot PVT
Row Count RC
Row Sampling RS
Script
Component
SC
Slowly
Changing Dimension
SCD
Sort SRT
Term
Extraction
TEX
Term Lookup TLK
Union All UAL
Unpivot UPVT
Data Mining Model Training DMT_DST
DataReader
Destination
DR_DST
Dimension
Processing
DP_DST
Excel
Destination
EX_DST
Flat File
Destination
FF_DST
OLE DB
Destination
OLE_DST
Partition
Processing
PP_DST
Raw File
Destination
RF_DST
Recordset
Destination
RS_DST
SQL Server
Destination
SS_DST
SQL Server
Mobile Destination
SSM_DST
August 11, 2011

Add new row for repeating table in infopath 2010 programmaticaly

Post it here, so I can remind easily.

Here is the example of code for adding row:

for (int i = 0; i < ids.Length; i++)

{

DataRow selected = tables.Rows[Convert.ToInt32(i)];

if (i == 0)

{

XPathNavigator xDataName = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorName”, NamespaceManager);

xDataName.SetValue(selected[0].ToString());

XPathNavigator xDataGender = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorSex”, NamespaceManager);

xDataGender.SetValue(selected[1].ToString());

XPathNavigator xDataCompany = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorCompany”, NamespaceManager);

xDataCompany.SetValue(selected[2].ToString());

XPathNavigator xDataNOKS = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorNextKin”, NamespaceManager);

xDataNOKS.SetValue(selected[3].ToString());

XPathNavigator xDataDrugs = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorTakingPrescription”, NamespaceManager);

xDataDrugs.SetValue(selected[4].ToString());

XPathNavigator xDataCert = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorHUETSOLAS”, NamespaceManager);

xDataCert.SetValue(selected[5].ToString());

XPathNavigator xDataLast = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorDateLastonFacility”, NamespaceManager);

xDataLast.SetValue(selected[6].ToString());

XPathNavigator xDataInduction = MainDataSource.CreateNavigator().SelectSingleNode(“/my:myFields/my:Visitors/my:VisitorsGroup/my:VisitorInduction”, NamespaceManager);

xDataInduction.SetValue(selected[7].ToString());

}

else


{

string myNamespace = NamespaceManager.LookupNamespace(“my”);

using (XmlWriter writer = MainDataSource.CreateNavigator().SelectSingleNode(

“/my:myFields/my:Visitors”, NamespaceManager).AppendChild())

{

writer.WriteStartElement(

“VisitorsGroup”, myNamespace);

writer.WriteElementString(

“VisitorName”, myNamespace, selected[0].ToString());

writer.WriteElementString(

“VisitorSex”, myNamespace, selected[1].ToString());

writer.WriteElementString(

“VisitorCompany”, myNamespace, selected[2].ToString());

writer.WriteElementString(

“VisitorNextKin”, myNamespace, selected[3].ToString());

writer.WriteElementString(

“VisitorTakingPrescription”, myNamespace, selected[4].ToString());

writer.WriteElementString(

“VisitorHUETSOLAS”, myNamespace, selected[5].ToString());

writer.WriteElementString(

“VisitorDateLastonFacility”, myNamespace, selected[6].ToString());

writer.WriteElementString(

“VisitorInduction”, myNamespace, selected[7].ToString());

writer.WriteEndElement();

writer.Close();

}

}

}

August 31, 2010

Newbie Made Mistake on SAP part 1

I wanted to make a new program on SAP but always was getting this notice.

which means i had to input SAP license key while I just use SAP license trial for 90 days and it still have activated.

Then ding…

The solution came up while I was “googling”

The program named should be all started with “Y” or “Z”.

And voila~~ what a stupid mistake.

Follow

Get every new post delivered to your Inbox.