Additional fields in billing_excel.php

[hannesjo]

hi all, i know the billing_excel.php is not a standard feature of mantis_bt but its a very nice and little plugin to export the billing information to an excel sheet.

so, there is an arry in the billing_excel.php

Code: Select all

		# get the fields list
		$t_field_name_arr = array( lang_get( 'id' ), lang_get( 'summary' ), lang_get( 'username' ), lang_get( 'time_tracking' ), lang_get( 'time_tracking_cost' );

si, i tried to add more fields like

Code: Select all

		# get the fields list
		$t_field_name_arr = array( lang_get( 'id' ), lang_get( 'severity' ), lang_get( 'priority' ), lang_get( 'summary' ), lang_get( 'username' ), lang_get( 'time_tracking' ), lang_get( 'time_tracking_cost' ), lang_get( 'date_submitted' ), lang_get( 'updated' ) );

it works fine, it i export to billing page to an excel i will see the caption of the extra fields priority, severity, date_submitted and updated.

i also add the related rows in the billing_excel.php

Code: Select all

<Row>
  <Cell><Data ss:Type="Number"><?php echo $t_item['bug_id']; ?></Data></Cell>
  <Cell><Data ss:Type="String"><?php echo $t_item['severity']; ?></Data></Cell>
  <Cell><Data ss:Type="String"><?php echo $t_item['bug_priority']; ?></Data></Cell>
  <Cell><Data ss:Type="String"><?php echo $t_item['summary']; ?></Data></Cell>
  <Cell><Data ss:Type="String"><?php echo $t_item['username']; ?></Data></Cell>
  <Cell><Data ss:Type="Number"><?php echo $t_item['sum_time_tracking']; ?></Data></Cell>

<?php if ($t_cost_col) { ?>
  <Cell><Data ss:Type="Number"><?php echo string_attribute( number_format( $t_item['cost'], 2 ) ); ?></Data></Cell>
<?php } ?>

  <Cell ss:StyleID="Date"><Data ss:Type="DateTime"><?php echo $t_item['date_submitted']; ?></Data></Cell>

but the additional fields ive added are empty....there is nothing in it
i know, i have to add the specific date format in the <styles> section

Code: Select all

<Style ss:ID="Date">
<NumberFormat ss:Format="Short Date" />
</Style>

but it dosent work...

any ideas?

regards.