Solved

Creating a 123 document from HTML

Posted on 2003-10-24
16
204 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
16 Comments
 
LVL 15

Expert Comment

by:jimmack
Comment Utility
Can you set the content type to something the your browser understands?

You can do this for Excel.
0
 

Expert Comment

by:Dutch_guy
Comment Utility
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
Comment Utility
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
 
LVL 15

Expert Comment

by:jimmack
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

 
LVL 10

Expert Comment

by:NetGroove
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
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
Comment Utility
Hello Jim,

do you need more support on this?

0
 

Author Comment

by:jah99
Comment Utility
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
Comment Utility
PAQed, with points refunded (500)

modulo
Community Support Moderator
0

Featured Post

Do You Know the 4 Main Threat Actor Types?

Do you know the main threat actor types? Most attackers fall into one of four categories, each with their own favored tactics, techniques, and procedures.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
JavaScript communication inside a IFRAME 9 46
Urgent Help with HTML CSS Positioning 9 20
SVG Star 4 16
Bootstap Icons 3 18
Foreword (July, 2015) Since I first wrote this article, years ago, a great many more people have begun using the internet.  They are coming online from every part of the globe, learning, reading, shopping and spending money at an ever-increasing ra…
Building a website can seem like a daunting task to the uninitiated but it really only requires knowledge of two basic languages: HTML and CSS.
In this tutorial viewers will learn how add a full-size background image to a webpage using CSS3. Create a new HTML document with an internal stylesheet.: In CSS, define the html element to have a background image. Use a high resolution image.: In t…
The viewer will learn the basics of jQuery including how to code hide show and toggles. 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…

772 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

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now