Solved

Creating a 123 document from HTML

Posted on 2003-10-24
16
249 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
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!

 
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

Don't Cry: How Liquid Web is Ensuring Security

WannaCry is just the start. Read how Liquid Web is protecting itself and its customers against new threats.

Question has a verified solution.

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

This article demonstrates how to create a simple responsive confirmation dialog with Ok and Cancel buttons using HTML, CSS, jQuery and Promises
Find out what you should include to make the best professional email signature for your organization.
In this Micro Tutorial viewers will learn how to create navigation buttons that change on rollover, using CSS (Continuation of the CSS Image Sprite tutorial) Create a parent ID for all the list items       - Specify position: absolute and display: block…
In this tutorial viewers will learn how to position overlapping items using z-index in CSS. They will also learn the restrictions on the z-index property.  Create a new HTML document with an internal stylesheet.: Create a div in CSS and name it Red.…

734 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