Solved

Batch conversion of .123 files

Posted on 2014-04-02
5
277 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

I recently resolved a client's Office 2013 installation problem and wanted to offer an observation that may help you with troubleshooting similar issues. The client ordered three Dell Optiplex system units with the Windows 7 downgrade option inst…
Microsoft Office Picture Manager was included in Office 2003, 2007, and 2010, but not in Office 2013. Users had hopes that it would be in Office 2016/Office 365, but it is not. Fortunately, the same zero-cost technique that works to install it with …
This video shows the viewer how to set up and create Footnotes in their document. Click on the References tab: Select "Insert Footnote": Type in desired text:
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…

863 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

26 Experts available now in Live!

Get 1:1 Help Now