Categorised Columns and Lotusscript

HCL Domino Domino Forum
1

Hi AllI have an interesting problem with categorised views that are being exported to XML.

The export works using viewentries to parse the view for export, and uses columnvalues to extract the column value for a particular entry.

Due to some bad data entry, some of the categorised columns are a mixture of cases (text that is). This is not such a large problem in Notes or using the web applet, as the system seems to arbitrarily pick one of the text case values to display as the category.

When exposing the columnvalue, however, the value from the underlying entry is used, which is correct as per the value on the back end document. This means that the exported XML is a mishmash of cases, and looks a real mess.

Does anyone have any ideas on how the export could mimic the displayed view more accurately?

TIA and regards

Scott

2

Subject: Categorised Columns and Lotusscript

It sounds like your easiest route is going to be to change your column formulas to force them into the types you want. E.g. if you always want a date/time value:

@TextToTime(@Text(yourField))

3

Subject: RE: Categorised Columns and Lotusscript

Thanks for your responses chaps. In the end the end I went the other way, and turned on Case sensitive sorting on the categorised columns and told the users they have to check the data before exporting !

Thanks

Scott

4

Subject: I remember seeing an Iris today aritcle once about writing an agent to fix mis-capitalized category entries

Addressing the cause instead of the symptom would be the way I’d try to go! HTH!