Show Data -> Backup to Excel

Everytime I go into the Backup to excel on the selected records I'd like to save, the records go into a spreadsheet nicely and each in their own line, but they're like the example listed below..

Test1 test1 test 1 test1
.................................test2 test2 test2 test2
...............................................................test3

(you have to ignore the .'s they're just to put in space) It won't put the next record in column 1. Am I doing something wrong?

Post edited by: Shazam0527, at: 2007/08/23 16:22<br><br>Post edited by: Shazam0527, at: 2007/08/23 16:23

No faith in your developer huh!? I fixed it.

For those who are having this problem, open up your admin.chronocontact.php form and look for the backup excel function and find these lines.

$datacol = 0;
	$rowcount = 1;
	foreach($datarows as $datarow){
		foreach($table_fields as $table_field){
			$sheet->writeString($rowcount, $datacol, $datarow->$table_field, 0);
			$datacol++;
		}
		$rowcount++;
	}

Replace it with

$datacol = 0;
	$rowcount = 1;
	foreach($datarows as $datarow){
		foreach($table_fields as $table_field){
			$sheet->writeString($rowcount, $datacol, $datarow->$table_field, 0);
			$datacol++;
		}
		$datacol = 0; // <-- add this line
		$rowcount++;
	}

Post edited by: bonh, at: 2007/08/23 17:03

Post edited by: admin, at: 2007/08/23 19:49<br><br>Post edited by: GreyHead, at: 2007/09/07 11:15

Hi,

Yes, there is abug at RC1, bonh, Thanks for posting a quick and excellent fix for this issue😉

Cheers

Max