Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Creating a 123 document from HTML

Posted on 2003-10-24
16
Medium Priority
?
256 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
  • 5
  • 4
  • 2
  • +3
15 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Independent Software Vendors: 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

When it comes to write a Context Sensitive Help (an online help that is obtained from a specific point in state of software to provide help with that state) ,  first we need to make the file that contains all topics, which are given exclusive IDs. …
Originally, this post was published on Monitis Blog, you can check it here . In business circles, we sometimes hear that today is the “age of the customer.” And so it is. Thanks to the enormous advances over the past few years in consumer techno…
HTML5 has deprecated a few of the older ways of showing media as well as offering up a new way to create games and animations. Audio, video, and canvas are just a few of the adjustments made between XHTML and HTML5. As we learned in our last micr…
This video shows how to quickly and easily deploy an email signature for all users in Office 365 and prevent it from being added to replies and forwards. (the resulting signature is applied on the server level in Exchange Online) The email signat…

783 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