This discussion is archived
15464 Views 66 Replies Latest reply: May 3, 2009 6:07 AM by lbrookins
Currently Being ModeratedApr 3, 2009 5:11 AM (in response to Roger Wilmut1)Incidentally, I also found that though Pages wouldn't open a Word Processing document which contained images and a text frame, it would if added the .cwk extension.24 inch iMac (10.5.6), 14 inch iBook G4 (10.4.11), 20 inch G4 iMac (10.4.11), Asus 'eee' (Linux), G3 Beige desktop Mac (8.6)
Currently Being ModeratedApr 3, 2009 8:18 AM (in response to Roger Wilmut1)This is something I've done with almost all of my AppleWorks draw documents. I may have mentioned it here sometime ago. Yvan Koenig is working on an AppleScript to do this in batches. Just this week I've been testing it for him & it works well. I don't know if he has posted it on his iDisk yet.24" 2.4GHz iMac; 15" unibody MacBook Pro 2.4GHz; G5 2.3GHz; 3G iPhone; TV, Mac OS X (10.5.6), 2GB iPod nano, 30GB 5G iPod, 17" G5 iMac, G4/700 iMac, PB 1400, Apple IIgs
Currently Being ModeratedApr 3, 2009 8:26 AM (in response to Peggy)Evidently I was posting old news... Oh well... I hadn't realized it was possible (it was the conversion to WP first that seemed to do the trick). And of course it still doesn't solve the serious Database problem.24 inch iMac (10.5.6), 14 inch iBook G4 (10.4.11), 20 inch G4 iMac (10.4.11), Asus 'eee' (Linux), G3 Beige desktop Mac (8.6)
Currently Being ModeratedApr 3, 2009 10:52 AM (in response to Peggy)Hello
Given what you wrote, I posted the scripts on my iDisk:
At this time, the explanations aren't written.
Two scripts are available:
(1) export to Pages.
It is fine if you have no objects crossing page boundaries.
As Tables are restricted to 65 columns in Pages, if a spreadsheet frame was using more than that, a spreadsheet containing the complete frame is also created.
(2) export to Numbers.
It's interesting if you have objects crossing pages boundaries.
Alas (1), in Numbers there is no way to wrap text around a shape
Alas (2), when Numbers imports a spreadsheet containing table frames, it drops them I reported this silly feature to Apple but at this time we must live with it. So, the script pass the tables as pictures to be sure of their position and paste a true table which it exported in Pages. The user must adjust the bounds of these objects because I found no way to define the position of a graphic object in a Numbers document thru AppleScript.
For those interested by the technique, the scripts copy every objects from the Draw document into a WP or a SS AW6 document then Pages or Numbers imports these new documents.
Interesting enough, if the original Draw documents where made in old CW/AW it's not a problem. The script opens them in AW6 then save a copy in AW6 format so it may grab infos from the internals of a known structure.
To use them, save them as 'application packages'.
You may may run them and they will ask you to navigate to a folder containing the original draw documents.
You may also drag the folder containing the files on the script's icon.
I'm waiting your comments.
Those needing explanations upon scrripts use may ask about "AppleScript" in the Finder's Help.
They may also look at:
Yvan KOENIG (from FRANCE vendredi 3 avril 2009 19:52:53)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Currently Being ModeratedApr 4, 2009 1:29 AM (in response to KOENIG Yvan)I couldn't get draw2Pages to work. Having failed with drawings in landcape format, I tried again with a couple of draw documents in portrait format. They were in a folder called 'Test'.
The script opened the original, the opened a new WP document in each case. However this remained in text mode. At this point the script stopped. The report said:
iMac HD:Users:roger:Desktop:Test: can’t be identified !
iMac HD:Users:roger:Desktop:Test: can’t be identified !
In the Test folder were two new subfolders, each containing an AW document; however trying to open this produced 'Unexpected end of file'
The same thing happened with draw2Numbers: in this case the new AW document remained in Spreadsheet mode with a cell selected, all other results were the same.
The Test folder with the two originals is at
(94 kB) should you wish to try it.24 inch iMac (10.5.6), 14 inch iBook G4 (10.4.11), 20 inch G4 iMac (10.4.11), Asus 'eee' (Linux), G3 Beige desktop Mac (8.6)
Currently Being ModeratedApr 4, 2009 7:22 AM (in response to Roger Wilmut1)Thanks for the feedback.
As I always gave an extension name to my documents I didn't saw that the script fails when original documents haven't the ".cwk" extension.
I will treat them as old files and save them with the extension name so the original will remain absolutely as it was.
May you test with the same folder after adding the extension names ?
Here it behaves flawlessly.
I must switch off for two hours but I hope that revised versions will be available before 20h (french hour).
Yvan KOENIG (from FRANCE samedi 4 avril 2009 16:22:40)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Currently Being ModeratedApr 4, 2009 2:42 PM (in response to KOENIG Yvan)Hello
Yes I know it's more than 20h (in France).
I encountered problems with one of the Roger's sample files.
At this time I don't understand why it fails.
I also loose time searching a way to change the orientation of the temporary AW6 WP document in which I store the different items.
I found a soluce but it requires the availability of "Extra Suites.app" an application which add features to AppleScript.
I need those moving the cursor and clickin in the Landscape button.
The script which import in Numbers works well.
I posted it on my iDisk.
I just wish to add some refinements because I identified two potential problems.
As I wrote, Numbers doesn't import the tables embedded in a spreadsheet so if the original document contains such items, I used an auxiliary Pages document in which I store the table.
Alas, Pages has its own limits: it accepts only 65 columns in a table when AppleWorks allows 100.
So, when a table is between 65 and 100 columns, I will create an auxiliary spreadsheet with the table contents so it will be easy to pass it in the final document.
Now it's late and I am tired.
See you tomorrow.
Yvan KOENIG (from FRANCE samedi 4 avril 2009 23:42:31)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Currently Being ModeratedApr 4, 2009 3:37 PM (in response to KOENIG Yvan)The business of adding .cwk is probably a red herring: the file I couldn't open until I'd added it was an AW template, so very probably Pages can't open templates - adding the extension may have got round that.
I did wonder what would happen if the original was in landscape: the original version of the remotes had these two drawings in one document in landcape, but as it didn't work I copied them into two portrait draw documents (puzzlingly the text, which was Helvetica, changed to Times and I changed it back), but as I reported they still didn't work. I'll watch out for the revised scripts. (By the way the Numbers script didn't work for me either).
Currently Being ModeratedApr 5, 2009 12:31 AM (in response to Roger Wilmut1)The revised version of the draw2Numbers script now works fine, without the need to add .cwk to the originals.
Currently Being ModeratedApr 14, 2009 12:55 AM (in response to KOENIG Yvan)Hello
I have just downloaded the appleworks to pages package from Yvan's idisk. Not knowing much about applescript, I have open the "draw2pages.applescript" and tried to save it as a script and tried to save it as an application bundle. Whenever I do though it comes up with a Syntax Error saying "Expected end of line but found property." The word 'version' is highlighted the file that is opened.
What am I doing wrong - any help would be appreciated.
ThanksMacBook, Mac OS X (10.5.6)
Currently Being ModeratedApr 14, 2009 2:03 AM (in response to woodsbr3)You have to save from the Script Editor.
You have also to read and apply the explanations given at the beginning.
They urge you to install some auxiliary tools:
"My Progress Bar.app"
"My Progress Bar script.scpt"
If the apps are not installed, the scripts will not compile and you will be unable to save them as Script or Application (better to save as Application Bundle).
As the used aux tools are different given the operating system, I will write two versions: one for 10.4.11, one for 10.5.6 and higher.
Yvan KOENIG (from FRANCE mardi 14 avril 2009 11:01:52)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)
Currently Being ModeratedApr 14, 2009 2:31 AM (in response to KOENIG Yvan)Hi Yvan
I've tried the save as application bundle in the Applescript editor but I get the syntax error happening when I click on Save. I am running 10.5.6 - all three of the apps you mentioned came with your downloaded package - should these be placed somewhere specific on my hard drive for it all to magically work - at the moment they are just in the AWdraw2iWork folder where they where originally appeared.
BrianMacBook, Mac OS X (10.5.6)
Currently Being ModeratedApr 14, 2009 3:23 AM (in response to woodsbr3)Oops
In the explanations I wrote
(1) to be able to treat Landscape documents under 10.4.11, this script requires the availability of the application "Extra Suites.app" in the Applications folder.
but I failed to detail the locations for the tools required under 10.5.6…
If you want to get the progress bar, you must install
the application “My Progress Bar.app”
in the folder “Applications:Utilities”
and “My Progress Bar script.scpt”
in the folder “<startupVolume>:Users:<yourAccount>:Library:Scripts:”.
I will edit that and the new versions will be available on my idisk.
Yvan KOENIG (from FRANCE mardi 14 avril 2009 12:22:26)To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !, Mac OS X (10.4.11)