Form Browser exports corrupt XLS.

[dcleckley]

Hello and good day.  I have installed Form Builder and Form Browser.  Both seem to work fine.  I can see the records that are submitted via the contact form when I administrate in Form Browser.  

The issue that I am having is that the XLS is corrupt when I export.  I've tried Excel viewer, and I've uploaded to Google Docs.  Both fail to recognize the file, or cite it as corrupt.  


Here is what I'm running:

----------------------------------------------

Cms Version: 1.7

Installed Modules:

   * CMSMailer: 1.73.14
   * FileManager: 1.0.2
   * MenuManager: 1.6.2
   * ModuleManager: 1.3.3
   * News: 2.10.4
   * nuSOAP: 1.0.1
   * Printing: 1.0.4
   * Search: 1.6.2
   * ThemeManager: 1.1.1
   * TinyMCE: 2.6.5
   * ABFlashGallery: 0.2
   * FrontEndUsers: 1.8.2
   * SelfRegistration: 1.3.2
   * FormBuilder: 0.6.1
   * FormBrowser: 0.3


Config Information:

   * php_memory_limit:
   * process_whole_template: false
   * max_upload_size: 2000000
   * default_upload_permission: 664
   * assume_mod_rewrite: false
   * page_extension:
   * internal_pretty_urls: false
   * use_hierarchy: true


Php Information:

   * phpversion: 5.2.4-2ubuntu5.7
   * md5_function: On (True)
   * gd_version: 2
   * tempnam_function: On (True)
   * magic_quotes_runtime: Off (False)
   * E_STRICT: 0
   * memory_limit: 24M
   * max_execution_time: 60
   * safe_mode: Off (False)
   * session_save_path: /var/lib/php5 (1733)
   * session_use_cookies: On (True)


Server Information:

   * Server Api: apache2handler
   * Server Db Type: MySQL (mysql)
   * Server Db Version: 5.0.51a


----------------------------------------------

[dcleckley]

I have completed a thorough search of the forum, but have not found anything related to this issue.  Any suggestions?

[dcleckley]

Besides using the provided export functionality via Form Browser (XLS) is there another automated function or module that I can set up for the end user so that they can extract the data in Form Browser?  ...that is, if I cannot find a resolution to the above issue?

[dcleckley]

I have completed another search through the forum.  I have also uninstalled / reinstalled the module, this time using the file manager's unzip functionality so nothing was lost via ftp.  The system works the same.  Any suggestions?

[dcleckley]

I have ensured all files are present.  Not sure if there are any other steps that I can take.

Essentially there are records ready to export.  The function seems to work, until you attempt to open the file.

[dcleckley]

I have yet to resolve this issue since 2009. Is there anyone who can assist me. I have tried this over several installations and cmsms versions.

[dcleckley]

I changed the file type to csv and it worked for Google Docs, but the fields are not separated in the excel file. How is the managed?