cancel
Showing results for 
Search instead for 
Did you mean: 

Date format in Nakisa OrgChart

0 Kudos

We have installated STVN 2.0 SP1 OrgChart only.

When using date fields in OrgChart (like begin- and enddate of an Organizational Unit) the date format is YYYY-MM-DD.

We would like to change this format in DD-MM-YYYY. In de Administrator Console I can find settings for this.

Any ideas?

Thanks,

Leo Jabaaij

Accepted Solutions (0)

Answers (1)

Answers (1)

lukemarson
Active Contributor
0 Kudos

Hi Leo,

You cannot do this in the Administrator Console, you need to code it.

If you are using the Staged version then you can just do it in the downloadSchema.xml. If you are using the Live version then you will need to amend the XSLT that controls the presentation of the section where you are displaying the date format.

I hope that helps.

Many thanks,

Luke

0 Kudos

Hi Luke,

Thanks!

I will try this, I will keep you informed about the results (with example).

Regards,

Leo

lukemarson
Active Contributor
0 Kudos

Hi Leo,

No problems. If you have any further issues please confirm whether you are using Staged or Live version. If you need some further information on XSLT you can go to the W3 Schools website:

http://www.w3schools.com/xsl/xsl_languages.asp

Cheers,

Luke

Former Member
0 Kudos

Hi Luke,

I am using the staged version of Nakisa OrgChart and would also like to change the date format. I am wondering in which part of the download schema I would make the change to truncated the date of birth to only display month and date. Thanks!

Zaj

StephenBurr
Active Contributor
0 Kudos

Zaj,

You've got 2 choices ... manipulate the data in the download schema in to the format you want OR, as Luke suggests use a modified XSLT file to format as you require.

Personally, I think Luke's suggestion is best. Ideally, use the admin console to put the DoB field in its own section and then amend the XSLT file referenced to be a bespoke version.

If you go with the download schema change, then you would add a statement into the <joinconfiguration> section to run some SQL to amend the DoB field. The field GBDAT is extracted from PA0002 but ends up in table EmpDetailsCombined (as field dob) so put a <joinstatement> near the bottom of hte <joinconfiguration> section to manipulate the data

i.e.

<joinStatement ignoreErrors="True" dbType="all"><![CDATA[UPDATE EmpDetailsCombined SET dob = ??SUBSTR(dob,0,6)????]]></joinStatement>

Obviously replace the "??SUBSTR(dob,0,6)????" part with the correct syntax as per your requirements and DB syntax.

Regards,

Stephen