Lotus .123 converter


M

Melissa

Does anyone know of any simple way to convert .123 files over to Excel in
some sort of Batch method? So far I have not had much luck.
 
Ad

Advertisements

C

Carey Frisch [MVP]

Conversion Utilities from Lotus 123, Wordperfect, Freelance files to their corresponding MS Office
http://www.experts-exchange.com/Applications/Lotus_Smart_Suite/Q_21030166.html

--
Carey Frisch
Microsoft MVP
Windows XP - Shell/User
Microsoft Newsgroups

-------------------------------------------------------------------------------------------

:

| Does anyone know of any simple way to convert .123 files over to Excel in
| some sort of Batch method? So far I have not had much luck.
 
M

Melissa

This really does not explain how I would do it in batch and this discusses
..wk4 format. I am looking to convert thousands of files from .123 - .xls
 
H

Harlan Grove

Melissa wrote...
Does anyone know of any simple way to convert .123 files over to Excel in
some sort of Batch method? So far I have not had much luck.

Microsoft provides *NOTHING* to do this. Excel can't open .123 files,
and there are no add-on filters for it to do so.

There are only 3 pieces of software that can work with .123 files:
Lotus 123 itself, Quattro Pro version 10 and later (for sure, and
possibly version 9), and DataViz's ConversionPlus. Of these, Lotus 123
itself is far & away the best at converting .123 files into .XLS files.

If you have thousands of .123 files to convert, then you must have had
Lotus 123 to have created them. If so, use it to convert these to .XLS
files. You'll lose LotusScript code modules, database @-functions with
criteria arguments, and most formulas that use 3D range references. No
way to avoid those losses.

Also, if you have 123, you could use 123 macros to write formula
listings of each workbook as text files. These would be very useful
when recreating formulas that were lost on conversion. As for
LotusScript code, there's no alternative to manually saving each module
as separate text files because there's no object model for the
LotusScript Editor, so no means of automating the process of saving
LotusScript code to text files.
 
M

Melissa

This is just so amazing to me as to why you cannot convert .123 to .xls with
ease!! Why is this? Does anyone know? Is there some sort of special code
behind the scenes or is it a ware between microsoft and lotus? I am talking
about 25,000 spreadsheets that I need to convert!!

I did find Conversion Technolgies. They are Microsoft partners, but they
are not cheap.
 
Ad

Advertisements

G

Gordon

Melissa said:
This is just so amazing to me as to why you cannot convert .123 to
.xls with ease!! Why is this? Does anyone know? Is there some sort
of special code behind the scenes or is it a ware between microsoft
and lotus? I am talking about 25,000 spreadsheets that I need to
convert!!

Am I to assume that you /need/ *ALL* 25,000 spreadsheets all at once?

Presumably you do NOT. So just convert them as and when you need them. They
won't go away unless you physically delete them.

If you don't have Lotus any more you might look at Open Office
(www.openoffice.org) I have a feeling that will open 123 files and will save
as xls files. (Got it at home but not at work so I'm not 100% sure on that
one)
 
H

Harlan Grove

Gordon wrote...
....
If you don't have Lotus any more you might look at Open Office
(www.openoffice.org) I have a feeling that will open 123 files and will save
as xls files. (Got it at home but not at work so I'm not 100% sure on that
one)

Don't *FEEL*. Investigate.

While OOo Calc in the 2.0 beta opens .123 files, it screws up worksheet
names (so it's likely it shares the same flawed code with Gnumeric -
not meant to be derogatory, it doesn't pull worksheet names correctly,
so it is flawed, but at least OOo and Gnumeric are trying, something
which can't be said for MSFT).

Good enough to pull data out of .123 files, but not easy.

As for LotusScript code, no joy.
 
H

Harlan Grove

Melissa wrote...
This is just so amazing to me as to why you cannot convert .123 to .xls with
ease!! Why is this? Does anyone know? Is there some sort of special code
behind the scenes or is it a ware between microsoft and lotus? I am talking
about 25,000 spreadsheets that I need to convert!!

Why? Perhaps because Microsoft believes you have to use their software
no matter how many features it lacks. In brief, Microsoft intended to
finish off their competition (Lotus Development Corp and Borland) with
Office 97. Given that goal, it'd be wise not to support any new
functionality in either 123 or Quattro Pro, including any new file
formats.

All it takes is just a wee bit of cynicism and there are no mysteries
left in understanding why Microsoft does what it does.
I did find Conversion Technolgies. They are Microsoft partners, but they
are not cheap.

Cheaper by far to buy Lotus SmartSuite version 9.6 or 9.7 (the current
version is 9.8, but older but not too much older versions are still
available and much cheaper than 9.8) and use that to convert .123 files
to .XLS files because you could then use 123 to automate the process. I
suspect you'd need to convert each file manually using ConversionPlus
or similar software.

If you'd need help writing such macros in 123, that's a discussion for

microsoft.public.excel.123quattro

or

microsoft.public.excel
 
M

Melissa

We currently use Lotus Smartsuite 9.8, and Yes we would like to convert atll
25,000 all at once.. some of our users would never figure out how to do a
save as.. they do good to save them to the network. I need this to be as
simple as possible, but it sounds like no matter what I do it is not going to
be fun. I found another software called ABC Amber lotus converter. Anybody
have any opinions on this software?
http://www.thebeatlesforever.com/processtext/abclotus.html
 
H

Harlan Grove

Melissa wrote...
We currently use Lotus Smartsuite 9.8, and Yes we would like to convert atll
25,000 all at once.. some of our users would never figure out how to do a
save as.. they do good to save them to the network. I need this to be as
simple as possible, but it sounds like no matter what I do it is not going to
be fun. I found another software called ABC Amber lotus converter. Anybody
have any opinions on this software?
http://www.thebeatlesforever.com/processtext/abclotus.html

This is a new one. Looks like they have a free 30-day demo, so why not
download it and try it out on a large and complicated .123 file?

That said, I'd still expect 123 itself to do a better job converting
the trickier bits.
 
Ad

Advertisements

J

jody.goldberg

There's no shared code between the projects (although I'm working to
change that).
Can you send over details of the problem so that we can fix it ?

Thanks
Jody
 
H

Harlan Grove

(e-mail address removed) wrote...
There's no shared code between the projects (although I'm working to
change that).

Good luck.
Can you send over details of the problem so that we can fix it ?

I've submitted it through bugzilla.

[See MSFT software users, one advantage of free/open source software is
that you don't have to pay for the priviledge of reporting bugs.]
 
G

Gordon

Harlan said:
Gordon wrote...
...

Don't *FEEL*. Investigate.

I /did/ say (if you read my post CAREFULLY) that I have OO at home but NOT
at work. the inference being, that when I posted the reply, I was at work .
!.
 
G

Gordon

Melissa said:
We currently use Lotus Smartsuite 9.8, and Yes we would like to
convert atll 25,000 all at once..

Wow. Do you have 25,000 employess who all use one separate spreadsheet each
, or one employee who uses 25,000 spreadsheets or any combination in
between?

Come on, if your users can't do a "save-as" how the hell do they use
spreadsheets? Perhaps a little bit of confidence in the ability of your
users wouldn't come amiss rather than a rant as to why you can't "convert
25,000 spreadsheets all at once". "Save-as" is a VERY VERY BASIC operation.
 
H

Harlan Grove

Gordon said:
Come on, if your users can't do a "save-as" how the hell do they use
spreadsheets? Perhaps a little bit of confidence in the ability of
your users wouldn't come amiss rather than a rant as to why you can't
"convert 25,000 spreadsheets all at once". "Save-as" is a VERY VERY
BASIC operation.

Experience shows it's not the low-level data entry types who won't do a
thorough job of converting files. It's the SVP who forgot to convert his
kid's little league stats spreadsheet who blames the IT department for not
converting his sensitive files.

Sound IT practice requires something like this be done in batch by IT, not
users.

No one ever lost their job by assuming their users were lazy morons and so
did this sort of thing for them. People have lost their jobs for making the
false assumption that none of their users were lazy morons.
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top