Exporting CSV creates blank row

computerzworld

Hello,
I am exporting CSV file using PHP. But it creates first row as blank. Under what condition it generates blank row? Because the same code works if I run it seperately. Thanks in advance...

Weedpacket

Without seeing the code, who can tell?

computerzworld wrote:
Because the same code works if I run it seperately.

As opposed to what? If you run it joined to a chihuahua?

computerzworld

here is my header..

$file_name = "contacts.csv";

		header("Content-type: application/octet-stream");
		header("Content-Disposition: attachment; filename=\"$file_name\"");
		header("Cache-Control: cache, must-revalidate");
		header("Pragma: public");

after that i have echoed data like this....

echo '"First Name","Company","E-mail Address","E-mail 2 Address","E-mail 3 Address","Home Phone","Business Phone","Mobile Phone","Home Fax","Business Fax","Pager","Other Phone","Home City","Business City","Other City","Web Page","Title","Middle Name","Last Name","Job Title","Department","Birthday","Anniversary","Spouse"'."\n"; 

for($j=0; $j<count($data); $j++)
			{

			echo "\"".$data[$j]['name']."\",";
			echo "\"".$data[$j]['company']."\","; 
			echo "\"".$data[$j]['email1Address']."\",";
			echo "\"".$data[$j]['email2Address']."\",";
			echo "\"".$data[$j]['email3Address']."\",";
			echo "\"".$data[$j]['homePhone']."\",";
			echo "\"".$data[$j]['businessPhone']."\",";
			echo "\"".$data[$j]['mobilePhone']."\",";
			echo "\"".$data[$j]['homeFax']."\",";
			echo "\"".$data[$j]['businessFax']."\",";
			echo "\"".$data[$j]['pager']."\",";
			echo "\"".$data[$j]['otherPhone']."\",";
			echo "\"".$data[$j]['homeAddress']."\",";
			echo "\"".$data[$j]['businessAddress']."\",";
			echo "\"".$data[$j]['otherAddress']."\","; 
			echo "\"".$data[$j]['webPage']."\","; 
			echo "\"".$data[$j]['title']."\","; 
			echo "\"".$data[$j]['middleName']."\",";
			echo "\"".$data[$i]['lastName']."\",";
			echo "\"".$data[$j]['jobTitle']."\",";
			echo "\"".$data[$j]['department']."\",";
			echo "\"".$data[$j]['birthDay']."\",";
			echo "\"".$data[$j]['anniversary']."\",";
			echo "\"".$data[$j]['spouse']."\"\n";
		}

Yes but as I have said this code works if I run this seperately..

computerzworld

that problem got solved🙂 acutally there was a plugin which was creating this problem becuase it was not properly formatted... I applied source formatting on its code & it worked🙂 now i am facing another problem.....I 've exported the csv compatible to outlook 2007 format using this export & tried to import in outlook & i got the error like

A file error has occurred in the comma separated values(Windows) translator while initializing a translator to build a field map.
Outlook was unable to retrieve the data from the file "C:\Documents and Settings\admin\Desktop\contacts.csv" . Verify that you have the correct file, that you have permission to open it, and it is not open in another program.

I don't know why this error is coming because all the fields in the csv are exactly compatible to the csv that is required for outlook. Please help me. Thanks once again...