on 09-17-2009 1:25 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
User | Count |
---|---|
88 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.