http://www.appnitro.com/forums/ Appnitro Software Forums Topic: export file extensions not formatted properly? en Wed, 10 Mar 2010 21:12:41 +0000 http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6389 Fri, 26 Jun 2009 21:28:07 +0000 AlanW 6389@http://www.appnitro.com/forums/ <p>Works great but had to change</p> <p><code>$clean_form_name == &#39;no-name&#39;;</code></p> <p>to</p> <p><code>$clean_form_name = &#39;no-name&#39;;</code></p> <p>Thank you! </p> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6381 Fri, 26 Jun 2009 10:20:29 +0000 redityo 6381@http://www.appnitro.com/forums/ <p>yes .. you can apply to CSV also, in "export_entries.php" go to around line 170, you'll find this code:</p> <pre><code>$clean_form_name = ereg_replace(&quot;[^a-zA-Z0-9_-]&quot;, &quot;&quot;,$form_name);</code></pre> <p>then replace with this code</p> <pre><code>$clean_form_name = ereg_replace(&quot;[^a-zA-Z0-9_-]&quot;, &quot;&quot;,$form_name); if (trim($clean_form_name) == &#39;&#39;) { $clean_form_name == &#39;no-name&#39;; }</code></pre> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6378 Fri, 26 Jun 2009 00:44:38 +0000 AlanW 6378@http://www.appnitro.com/forums/ <p>That is fantastic redityo. Is there a way to do this for csv as well? </p> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6376 Fri, 26 Jun 2009 00:33:47 +0000 redityo 6376@http://www.appnitro.com/forums/ <p>It seems you've blank form name/title, to give default file name when you've blank form name.<br /> Try to edit your "export_entries.php" file and go to around line 145 ~ 147, you will see these code :</p> <pre><code>// sending HTTP headers $clean_form_name = ereg_replace(&quot;[^a-zA-Z0-9_-]&quot;, &quot;&quot;,$form_name); $workbook-&gt;send(&quot;{$clean_form_name}.xls&quot;);</code></pre> <p>try to change with these </p> <pre><code>// sending HTTP headers $clean_form_name = ereg_replace(&quot;[^a-zA-Z0-9_-]&quot;, &quot;&quot;,$form_name); if (trim($clean_form_name) == &#39;&#39;) { $clean_form_name = &#39;no-name&#39;; } $workbook-&gt;send(&quot;{$clean_form_name}.xls&quot;);</code></pre> <p>Those code will give "no-name.xls" when you export entries on blank form name, otherwise you can simply set a form name. </p> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6374 Fri, 26 Jun 2009 00:09:07 +0000 AlanW 6374@http://www.appnitro.com/forums/ <p>No actually it is happening in IE7 also, but it is being exported as ".csv[1]" or ".xls[1]". If I take off the "[1]" and add a prefix to the file, such as "test.csv" then it opens fine. </p> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6362 Thu, 25 Jun 2009 15:51:42 +0000 redityo 6362@http://www.appnitro.com/forums/ <p>Hi,</p> <p>Hmm .. I use Firefox 3 and it's work fine in here. Anyway what is your form name and is it only happened in firefox 3 ? </p> http://www.appnitro.com/forums/topic/export-file-extensions-not-formatted-properly#post-6351 Wed, 24 Jun 2009 21:58:18 +0000 AlanW 6351@http://www.appnitro.com/forums/ <p>When I export either csv or xls files in Firefox v3, the resulting files are named simply "csv" or "xls", rather than "[filename].csv" or "[filename].xls". If I add the "." to the filename the files will autoformat when opening in excel, otherwise I have to format manually. A small inconvenience but seems like this could easily be fixed? Love this product! </p>