?
Solved

Creating a 123 document from HTML

Posted on 2003-10-24
16
Medium Priority
?
253 Views
Last Modified: 2008-03-17
I have managed to setup my JSP so that when it is called, it automatically save the the data to a file.  I did this by setting the content type of the JSP as follows :

<%@page contentType="application/x-javascript; charset=ISO-8859-1"%>

This allows me to save the file.  I can then load it into Lotus 123.  Is there any way that I can bypass the having to save the file first, and just load the data straight into 123 from the browser ?

When I call this JSP, I want to be able to load the data straight into 123.

Any ideas, or is this impossible ?

Jim
0
Comment
Question by:jah99
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
  • 2
  • +3
16 Comments
 
LVL 15

Expert Comment

by:jimmack
ID: 9613570
Can you set the content type to something the your browser understands?

You can do this for Excel.
0
 

Expert Comment

by:Dutch_guy
ID: 9613597
You should change your contentType to open directely in Lotus123.

If you would change it to:

application/vnd.ms-excel

it would open in Excel.

Or try the following (example is written in ASP):

Response.ContentType = "text/plain"
      Response.AddHeader "content-disposition", "attachment; filename=Batch-"test.csv"

You would have to change the .csv with the file extension Lotus123 uses.
0
 

Author Comment

by:jah99
ID: 9613966
Do you know how to create a file in a format the EXCEL or 123 understands.  If you just change the application to vnd.ms-excel is saves the file with the .xls extension, but when you try to open it, it doesn't recognise it as an excel document (I guess because it isn't).
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 15

Expert Comment

by:jimmack
ID: 9614000
As far as I remember, you need to output the data as though you were going to display it in a table.

Just outputting the table with the vnd.excel MIME type should allow excel to open the result.
0
 

Expert Comment

by:Dutch_guy
ID: 9614116
Excel should open the file.

Maybe you have an old version of Excel?

The thing is, the outputted Excel file is not a true Excel file. It''s just a HTML table which Excel can open in Excel.

 

0
 

Author Comment

by:jah99
ID: 9614278
Our company only has Excell Viewer, this may be why it doesn't work.   I need this to work with Lotus 123.
0
 

Expert Comment

by:Dutch_guy
ID: 9614437
Try on your local computer to change what program a .xls extension should open.

If you change temporarily that a .xls file should be opened by Lotus123, you can see if Lotus123 opens the file immediately.
0
 
LVL 10

Expert Comment

by:NetGroove
ID: 9623779
You can test with this mime types:
application/x-lotus-123
application/lotus-123
application/vnd.lotus-1-2-3

But this will only work if browser has the 123 viewer or the application installed localy.

Good luck,
NetGroove

0
 
LVL 19

Expert Comment

by:webwoman
ID: 9634734
What VERSION of 123? It's been around for a LONG time, and I wouldn't be surprised if some of the older file formats for it aren't compatible with Excel, and I really doubt it can read HTML.

If you're going to be generating things dynamically like this, you might want to consider changing/updating software.
0
 

Author Comment

by:jah99
ID: 9640380
Its release 9.6 which is reasonably new.  I've tried adding the 3 mime types as described by NetGrove.  None of them seem to save the file in a format which 123 can open.  I'm starting to think that Explorer and 123 are destined never to talk to each other.
0
 

Author Comment

by:jah99
ID: 9640568
I've been playing around.  

vnd.ms-excel  - opens and excel document
msword - opens a msword document

but

vnd.lotus-1-2-3 - does not open a 123 document
vnd.lotus-wordpro - does not open a wordpro doc.

Do you have to set up the mime types in explorer ?
 
0
 

Expert Comment

by:Dutch_guy
ID: 9640629
As i mentioned in an earlier post, just change the mime type of a .xls file temporarily to open with Lotus123.

Then when you open the file with: "vnd.mx-excel" it should open in Lotus123.

Or you can try:

Response.AddHeader "content-disposition", "attachment; filename=test.csv"

Then replace test.csv with the extension Lotus123 uses.
0
 
LVL 10

Expert Comment

by:NetGroove
ID: 9835578
Hello Jim,

do you need more support on this?

0
 

Author Comment

by:jah99
ID: 9848982
I have tried the suggestions you put above ie using mime types of :

application/x-lotus-123
application/lotus-123
application/vnd.lotus-1-2-3

I do have 123 installed on my PC, and none of these work.  Any ideas ?

0
 

Accepted Solution

by:
modulo earned 0 total points
ID: 10722469
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Today, the web development industry is booming, and many people consider it to be their vocation. The question you may be asking yourself is – how do I become a web developer?
When crafting your “Why Us” page, there are a plethora of pitfalls to avoid. Follow these five tips, and you’ll be well on your way to creating an effective page.
In this tutorial viewers will learn how to embed Flash content in a webpage using HTML5. Ensure your DOCTYPE declaration is set to HTML5: "<!DOCTYPE html>": Use the <object> tag to embed Flash content.: To specify that the object is Flash content, d…
The viewer will learn the basics of jQuery, including how to invoke it on a web page. Reference your jQuery libraries: (CODE) Include your new external js/jQuery file: (CODE) Write your first lines of code to setup your site for jQuery.: (CODE)

719 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question