Login  •  Register


The time is now: Sun Aug 09, 2020 8:32 am

Emaculation wiki  •  Delete all board cookies



Post new topic  Reply to topic Page 3 of 3 [ 57 posts ]    Go to page Previous  1, 2, 3
Print view Previous topic  |  Next topic
Author Message
PostPosted: Mon Jul 20, 2020 7:01 pm 
Offline
Expert User
User avatar

Joined: Thu Feb 09, 2006 10:24 pm
Posts: 6081
Location: Amsterdam, Netherlands
RanJay wrote:
If I save it as a text file, which I can, is there anyway to import it into a new program that can sort and align the rows/columns?
I tried with an old AppleWorks (successor of ClarisWorks) database. Saved it as text in AppleWorks 6 in SheepShaver MacOS9. The ascii text file opens nicely in Apple's Numbers with rows and columns intact. It will also open in MS Excel, but it looks better in Numbers. Because the "text" file is ascii text, special characters will not be displayed correctly.

I do not currently have a database application to try.

I could not make the original database open in LibreOffice as adespoton suggests and CW/AW databases does not have a CSV export option.


Last edited by Ronald P. Regensburg on Mon Jul 20, 2020 8:42 pm, edited 3 times in total.
Added some more information


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Mon Jul 20, 2020 8:35 pm 
Offline
Expert User
User avatar

Joined: Thu Feb 09, 2006 10:24 pm
Posts: 6081
Location: Amsterdam, Netherlands
Did some more tests.
- The file will open in both Numbers and Excel if it has a .txt extension.
- Special characters are preserved in Excel, but not in Numbers.
- When I open the .txt file in Excel and save it as .cvs. I can then open the file in Numbers with special characters preserved.


Last edited by Ronald P. Regensburg on Mon Jul 20, 2020 8:43 pm, edited 1 time in total.
 


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Mon Jul 20, 2020 9:28 pm 
Offline
Inquisitive Elf

Joined: Fri Jun 05, 2009 12:09 am
Posts: 33
emendelson wrote:
LibreOffice is reported to be able to open ClarisWorks databases; I haven't tried it, but it's free, so the worst thing that can happen is that you'll waste a few minutes installing it.


Thanks Ronald!
It was able to read the file and seems perfect!


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Mon Jul 20, 2020 9:29 pm 
Offline
Inquisitive Elf

Joined: Fri Jun 05, 2009 12:09 am
Posts: 33
adespoton wrote:
LibreOffice should be able to directly import the database. If it fails, export to CSV in Claris, and import that into whatever spreadsheet program you want to use (Libre, Excel, GDocs, etc.).


LibreOffice worked!
Thanks for your help!!


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Tue Jul 21, 2020 12:47 pm 
Offline
Expert User
User avatar

Joined: Thu Feb 09, 2006 10:24 pm
Posts: 6081
Location: Amsterdam, Netherlands
RanJay wrote:
LibreOffice worked!

Indeed. I tried everything I could think of to open or import the CW/AW database in LibreOffice except for the one simple method that works: Start LibreOffice and use Open... from the File menu. :oops:


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Tue Jul 21, 2020 1:52 pm 
Offline
Inquisitive Elf

Joined: Fri Jun 05, 2009 12:09 am
Posts: 33
Ronald P. Regensburg wrote:
RanJay wrote:
LibreOffice worked!

Indeed. I tried everything I could think of to open or import the CW/AW database in LibreOffice except for the one simple method that works: Start LibreOffice and use Open... from the File menu. :oops:


Yep. That's how I opened it.
Now I'm just cleaning the document up by changing the font size and what not.
Can't do the whole document at once.
There seems to be some sort of glitch where I can select a bunch of fields in a column to fix, but one of those fields might prevent me from changing all the fields I selected.
Annoying, but not as annoying as having to redo my entire database.
Once I'm finished fixing the document up, I think I'm going to export it a different way.
Right now it's a .ods file, which is not viewable by Numbers.
So I'll play around with it until I figure that out.
Thanks again for all your help Ronald!
Truly appreciated!


Top
 Profile  
Reply with quote Post a reply  
PostPosted: Tue Jul 21, 2020 2:28 pm 
Offline
Expert User
User avatar

Joined: Thu Feb 09, 2006 10:24 pm
Posts: 6081
Location: Amsterdam, Netherlands
If you rather use it in Numbers, better stop doing things like changing fonts in LibreOffice. All that will be lost in another application.

The .ods (open document) format is native to LibreOffice.

In LibreOffice you can save as text CSV, choose Unicode (UTF-8) for the font set. The CSV file can be opened in Numbers.

In Numbers you can save it as a .numbers file. Then you can edit table styles, etc.


Last edited by Ronald P. Regensburg on Tue Jul 21, 2020 2:36 pm, edited 2 times in total.
 


Top
 Profile  
Reply with quote Post a reply  
Display posts from previous:  Sort by  
Post new topic  Reply to topic Page 3 of 3 [ 57 posts ]    Go to page Previous  1, 2, 3


Who is online

Users browsing this forum: No registered users and 18 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
 

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Group