How to export boolean values as Yes / No from Export to CSV from Taskspace search form result set

Hello All,

We are displaying bollean values as YES / NO in search form result set (through form template configuration). But when we use OOTB feature of taksspace to export the result set data to CSV we get the boolean values 0 and 1 and we expect to get as Yes / No the way it is getting displayed to form.

Can we get boolean value as Yes / No (atelast True / False) but not as 0 and 1 , as end users will not understand what is 0 & 1.

Find more posts tagged with

Comments

christopher.imes

Please consider moving this question to the proper forum as-is (no need to recreate) for maximum visibility. Questions written to the users' own "Discussions" space don't get the same amount of attention and questions can go unanswered for a long time.

You can do so by selecting "Move" under ACTIONS along the upper-right. Then search for and select: "Documentum" (Developer Network) which would be the most relevant for this question.

Kothari

Only way i can find of, re-writing (CSV Read - Prepared by ExporttoCSV Component/ Write) CSV file with required metadata. Or customize the CSVFormatter.class

PanfilovAB

You should implement ITableDataFormatter interface and override rowIterator methods in component like:


public Iterator<Row> rowIterator(List<String> columnNames) {
    Datagrid datagrid = (Datagrid) getControl("gridname");
    return TableDataProviderUtil.getRows(datagrid.getDataProvider(),
            columnNames,  ITableDataFormatter instance);
}

public Iterator<Row> rowIterator(List<String> columnNames,
        String rowSelection) {
    Datagrid datagrid = (Datagrid) getControl("gridname");
    return TableDataProviderUtil.getRows(datagrid.getDataProvider(),
            columnNames,  ITableDataFormatter instance, rowSelection);
}

Kothari

Can you explian more in detail ? I have Boolean values which need to be exported as Yes / No ( String).

Do I need to work on Datagrid ? to change these values to 0 or 1. and CSVFormatter should work.