Excel output truncated (255 chars only) - Workaround? - Oracle Application Server Portal

Hi,
we have a problem with several columns being truncated when the output format is excel (QBE- Report and SQL-Wizard).
It works fine when the output format is html, but we do need the export ;).
Any suggestions?
Thanks and best regards,
~dietmar.

This is the limitation of Excel.
Pls refer to the Bug1521814.
It says:
There is the limitation in EXCEL in handling the data in sylk format.
Try the following:
Enter some text (more than 255 charaters) in a cell and save it as sylk file.
Now open the saved file in notepad. You will see that the text is truncated
to 255 characters. Now add few characters to the text in the sylk file and
save it and try to open it in EXCEL. You will get a error message and it does
not show the text in the EXCEL. 

Hi all,
Has anyone found any sort of workaround for this problem? I'm desperate...
Regards.
Anton.

Related

Text file output

Hi all, how would I go about generating a text output file? Plain text with columns fixed width apart. The only output options I see are PDF, HTML, Excel, RTF and XML (data). Thanks! 
Hi,
You can go with etext templates
Refer the link Below:
http://blogs.oracle.com/xmlpublisher/2008/06/etext_from_kevin.html
Best Regards,
Mahi

Parsing Excel file

Hello all,
I would like to read the data from excel sheet but only when the text is bold. I don't know it is possible or not. So if the text is bold in any of the cell in excel sheet only that data should display to my page
thanks...
Vishu 
Go here, see if it helps you http://jakarta.apache.org/poi/hssf/quick-guide.html

Prevent Excel from suppressing leading zeros

Hello everybody,
we are using BIP 10.1.3.4 and want to export records identified by building groups in Excel format.
The Problem is that building groups has a fixed length of four characters, only digits from "0000" to "9999". Excel suppresses all leading zeros, therefore the first building groups are to short, e.g. instead of "0010" only "10" is displayed.
I tried the answer to threat "Character drops zeros when exported to Excel" (Re: Character drops zeros when exported to Excel with use of fo statements:
<fo:bidi-override direction="ltr" unicode-bidi="bidi-override">
<?XML_ELEMENT?>
</fo:bidi-override>But this doesn't have any effect. Since BI Publisher doesn't create native/binary Excel rather than XML like files I checked the output with a text editor. The content is written correctly in XML tags.
Other solutions like wrapping the field in quotes ="<?XML_ELEMENT?> cannot be used because the file is to be imported by another software. If no one has any further suggestions we will try to program a CSV interface.
Thank you,
Stefan 
Hi,
Can you paste your XML here , so that we can have a try.
Best Regards,
Mahi 
Hi,
The syntax <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?XML_ELEMENT?></fo:bidi-override> is showing the ouput as required for you . I tried it just on my template.
Please check the XML data and your template once.
Best Regards,
Mahi 
Mahi,
you're right! Vetsrini told me to put the fo statements into a form field.
Wrongly I used three form fields, one for each pair of brackets. But now I put the whole statement into one form field and it worked!
Thank you, and also to Vetsrini!
Stefan 
That was great ,
Am glad that, i was able to help there for you. 
Srini,
I tried the solution (<fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?FIELD_NAME?></fo:bidi-override> in RTF template) and the excel was able to retain the leading zeros after running the xml report from Oracle Apps. However, when I select the cell contents in Excel output and paste it in notepad, I find a special character prefixed and suffixed to the cell contents. As a result users are unable to use copy-paste functionality to search for the field in application.
Please let me know, if you faced anything similar to this.
Intesh 
Hi.
I've the same problem. I can't use the copy-past and search.... is there a solution?
Thank you
R. 
Hi,
Copy-paste functionality to search for the field in application, when using <fo:bidi-override direction="ltr" unicode-bidi="bidi-override"><?FIELD_NAME?></fo:bidi-override> in RTF template doesnt work.
So, I have followed the approach of changing the XML tag on the RTF to ="<?FIELD_NAME>" This makes the excel output retain the leading zeros and the copy-paste approach to search in application works as well. This definitely makes excel users happy. The only downside to this is that if the report is run in PDF format, then PDF doesnt understand this special tag and would display as ="010266" (if say field content was 010266) in the output. The only solution, I could think of as of now, for PDF requests will be creating a new template with XML tag as <?FIELD_NAME?> However this increase the custom footprint.
Just wanted to share my research.
-Intesh 
Just correcting a typo. The XML tag should be changed to  ="<?FIELD_NAME?> The earlier solution missed the "?" at the end It works perfectly fine

Display RTF content from BLOB

Hi,
I have some RTF data saved to DB as BLOB. So, I am looking for a way of how I can take this BLOB data and display it as RTF (which is the original format that was saved to DB) to a page.
Could someone give me a hint on this?
Thanks 
You can try af:richTextEditor for the display. Check out http://docs.oracle.com/cd/E21043_01/apirefs.1111/e12419/tagdoc/af_richTextEditor.html for more info.
Timo 
Thanks Timo..
I am doing that, but how can I convert the BLOB data to "RichText Format" ? I think I can use Output formatted, but still I need to convert this BLOB data to HTML.
Do you have any idea on this?
Thanks 
Have you tried to put the blob data into the rich text editor as is?
Timo 
Yes, i did that initially. This is what I am getting.
{\rtf1\ansi\ansicpg1252\uc1\htmautsp\deff2{\fonttbl{\f0\fcharset0 Times New Roman;}{\f2\fcharset0 Tahoma;}}{\colortbl\red0\green0\blue0;\red255\green255\blue255;}\loch\hich\dbch\pard\plain\ltrpar\itap0{\lang1033\fs16\f2\cf0 \cf0\ql{\fs54\f2 {\b\i\ul\ltrch TEST TEST TEST}\li0\ri0\sa0\sb0\fi0\ql\par} } } 
I just realized that this stuff {\rtf1\ansi\ansicpg1252.... is because the BLOB is for an MS Word RTF. Now, I think I need to convert this to Text.
Help pls ...

Limitations in excel output

TIM,
Recently I have seen many threads regarding issues on excel output,
The XHTML output has lot of limitations,
Most of the users are aware of it, but seems like many are not…!
Many threads related to excel output(APPS) remained unanswered
few threads from last 3days
some of the data for same records is going on to the next page in excel??
Performance Issue generating excel output with huge XML data
Performance Issue generating excel output with huge XML data
EBS - XMLP 5.6.2 - OPP Performance... - Excel Output
EBS - XMLP 5.6.2 - OPP Performance... - Excel Output
Excel output in EBS?
Excel output in EBS?
could you post something on these limitations and enhancements coming up the way.
That could help many user on this forum.
Thanks
ss 
Hi, I'm not Tim, but thought I would post something I discovered today regarding this topic.
I was not getting the pop-up window that allows selection of output type Excel. This was uing IE7 browser. All it would do it start to open a window, and then beep at me, and close the window.
Then I tried using both Netscape and Firefox, and with those browsers, it opened the pop-up window that allowed me to open in Excel.
Does anyone know why this difference would occur between various browsers?
Thanks
Paul 
Hi Paul,
We've run into a similar problem with IE7 as well. If this happens to be the same problem, it can be fixed with the following:
1. Select 'Tools' -> 'Internet Options' -> 'Security' (tab) -> 'Trusted Sites' -> 'Custom Level' (button) -> 'Downloads' from the browser menu.
2. Set 'Automatic prompting for file downloads' to 'Enable'.
3. Save the setting and close the browser window.
4. Start a new browser session and try again.
Hope it helps.
Ed 
Ed,
Thanks! My colleague just found the same thing. It works now!
Paul 
Just wrote up a Q&A blog entry today - http://blogs.oracle.com/xmlpublisher/2008/05/05#a946 
Hi Tim,
We have a requirement to display the period name (the default format being MMM-yy) in our report.
When the report output is RTF , HTML or PDF, the output is displayed as intended. But when the same needs to be displayed in an Excel report output, it gets converted to a date.
This works fine if we have leading spaces after the field. But our requirement is not to have any spaces in the report.
Kindly suggest.
Regards,
Sujatha
PS: I have posted in your blog too. Posting here for an early response 
Hi Sujatha
So Excel formats to different date format to that required? Or makes a complete mess of the formatting?
Without the spaces you are limited to the html we generate and its limitations. The only option I can think of is to write a global macro that would reside on the client Excel and would reformat the date contents you want converted.
Regards
Tim
http://blogs.oracle.com/xmlpublisher 
Hi
I want Image to show on Excel output in EBS
I gone through Tim's Blog about "Excel Limitation Q&A"
but I am not getting which path is to give for
1)Base image URI and 2)Image file directory In Administrator Tab
I kept Image file(comlogo.gif) is in OA_MEDIA.
In rtf template I have created dummy image and in web tab I have given url:{'${OA_MEDIA}/comlogo.gif'}
but it gives small red 'x'icon in excel
can someone pls help me for this issue
Thanks
Rahul
Message was edited by:
user576181 
Can anyone suggest any link or steps to achive this?
Rahul
Help me please !!!
Message was edited by:
user576181 
In Admin Tab
Base image URI >> I am giving image file directory path
Image file directory >> same path as above
but how template will access this path? what I should write in template?
Rahul 
I am giving
Base image URI = http://cvd-erp-dev-01.limac.com:8011/OA_MEDIA/comp_logo.gif
and
Image file directory = /u11/orafindv/findvcomn/java/oracle/apps/media/comp_logo.gif
Is it correct?
Now please suggest me what should I write in rtf Template?
shall I take dummy Image? or something in form field?
Thanks In advance 
Can some one put light on this please.... :)
Rahul 
Hi,
Paste an image in the template where you would like your image to be displayed in the output. Double click the image. In the "Web" Tab of the the image properties write this:
url:{concat(CP_URL,'/','logo.gif')}
where CP_URL contains my unix directory path where my logo.gif file resides.
CP_URL is a placeholder in my rdf and hence is part of my XML output. 
Hi
Thanks for your reply
This will work for PDF output .But when I select EXCEL output I am getting
small red cross in place of Image.
Rahul 
Hello Tim,
First time posting a message in this forum. We have a report that we export to Excel for users to analyse it futher. Report consists of all percentages with % sign at the end of each value in the cells. Negetive numbers are highlighted in red enclosed in brackets with % sign at the end. All numbers are rounded to one decimal in the source query, so the XML data has values rounded to one decimal. When we export the report to Excel, all positive numbers are rounding to 2 decimal points and negetive numbers to one decimal point. When exported to PDF, all values are rounded to one decimal. Is there a way to fix this in Excel output?
Thanks in advance.

Categories

Resources