Solved

Batch conversion of .123 files

Posted on 2014-04-02
5
274 Views
Last Modified: 2014-04-11
We have acquired a company that has several hundred files with .123 file extensions which can not be opened with excel.  Does any one know of a company or utility to do this?  There is one computer left that can open individually and do a save as but this Pc is dying and of course no there is no software to load on a new machine.
0
Comment
Question by:jmilligan73034
  • 3
  • 2
5 Comments
 
LVL 19

Assisted Solution

by:regmigrant
regmigrant earned 500 total points
ID: 39978334
Excel lost the ability to load Lotus files a few revisions ago. If you can get hold of an older copy - 97/2003 for example it should be able to read them.

however the support was always better for wk4 so you might have to do a save as anyway and I take it you are worried the machine will dies before that's complete. So first thing to do is back them up (yes I know you probably have but some people don't think about it until its too late).

I believe Open office Calc can open lotus files so at least you will have a fall back if the machine dies.
0
 

Author Comment

by:jmilligan73034
ID: 39989334
Open Office does not  seem to work with .123 files only .wk4 files
0
 
LVL 19

Accepted Solution

by:
regmigrant earned 500 total points
ID: 39992044
I've never tried it but was taking a cue from the Openoffice.org feature guide
http://www.openoffice.org/marketing/2.0/featureguide.html#interoperability

 which has this entry against issue 34806 :-

"The Lotus 1-2-3 import now also loads files of Lotus versions up to 9.7, the file type list box lists the .123 file name extension additionally to the already known .wk1 and .wks extensions. Opening a Lotus 1-2-3 file without selecting a filter type now loads the file into Calc instead of Writer."


Its reiterated at OpenWith.org:-
http://www.openwith.org/programs/openoffice.org

If these are incorrect you can raise an issue with the OpenOffice development team and they may be able to help with a previous version.

The only alternative to this would be to see if you can get that machine copied to a virtual environment or take an image of its hard drive and move it to more stable hardware
0
 

Author Closing Comment

by:jmilligan73034
ID: 39992342
Thank you.  I will close my question since my question was a "batch" conversion of 22,000 lotus files not a 1 by 1
0
 
LVL 19

Expert Comment

by:regmigrant
ID: 39993556
yes I appreciate that, I did find a routine that claims to handle batch conversions but when I investigated I found it generates errors with 123 files.
http://download.cnet.com/Fantastic-Lotus-1-2-3-Converter/3000-2065_4-75758879.html

Alternatively you could try this link and use a copy of smartsuite (which can open .123)  to create a macro:-
http://www.ecostsoftware.com/ibm-lotus/lotus-smartsuite-millennium-9-8-retail-boxed_p1842?gclid=CICM4qqB2L0CFY3HtAod5TIAUg
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

In a nutshell Dropbox is a cloud-based data storage service which synchronizes with data files on your computers. The Dropbox folk provide 2GB of free storage but if you need more you can sign up for a 50GB or 100GB subscription account. I pr…
Microsoft Office Picture Manager is not included in Office 2013. This comes as a shock to users upgrading from earlier versions of Office, such as 2007 and 2010, where Picture Manager was included as a standard application. This article explains how…
This video walks the viewer through the process of creating Hyperlinks for the web and other documents. Select the "Insert" tab: Click "Hyperlink":  Type "http://" followed by a web address to reference a website or navigate to a document to ref…
An overview on how to enroll an hourly employee into the employee database and how to give them access into the clock in terminal.

747 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