2. PHPRunner General questions
  3. [SOLVED]  Export Problem
This topic is locked
[SOLVED]

 Export Problem

 		2/24/2013 5:19:12 PM
PHPRunner General questions
A
 Andrew S author

I am using php runner 6.2 build 14199 and have an application which records work orders using php/mysql
When inputting work order, Work Order Details field is type BLOB and input for the Text Area is using the Basic Rich Text Editor.
Everything is fine with one exception.
User wants to be able to export certain details to excel which has been working fine. Now wants additional information included on the export functionality including Work Order Details. No problem I thought ... just add the field to the export page.
When user exports, all fields appear with the exception of the Work Order Details. No errors just blank where the details should appear within excel 2007.
I then tried exporting to Word and instead of blank get LONG BINARY DATA - CANNOT BE DISPLAYED in place of the Work Order Details. Does anyone know of a work around for this? i.e. is it possible to convert prior to exporting or something similar?
The actual details are text not images just formatted nicely with bullet points and paragraphs if necessary.
I look forward to any assistance with regard to this.
Thanks in advance.

Andrew S
Sergey Kornilov admin 2/24/2013

Andrew,
the suggestion is to use a text field instead ob BLOB. MediumText field type will work here just fine.
A
 		Andrew S author 2/25/2013

Many thanks for quick response. Works fine now I have changed field type to medium text.
Just for information, when exported to excel all html shows i.e.
. Quick way to remove is to use highlight the column concerned and then using find and replace, find <*> and replace with a space. This removes all html.