Word AutoCorrect import macro

[Zarius]

Thanks to patb for the original module, I've just tried to clean it up a bit and make it more general - it should work on any version from StarOffice 7 to OpenOffice 2.x (you will need to select the autocorr dat file appropriate to your version however, I haven't automated that yet - search for "edit me").

I've tried to get rid of all the dispatcher calls (excluding copy & paste, as I don't see a way around them), but haven't worked out how to remove the top two lines of the word autocorrect backup file without leaving a hanging paragraph break.

See original thread here for more details: AutoCorrect import macro?

[raywood]

I use Word. I have about 7,400 autocorrect entries. This doesn't (yet) run afoul of the 10,000-entry limit in OOo Writer. But as you can imagine, I won't be typing those entries into Writer manually.

I may eventually have time to figure out how to use the macro shown here. It looks like its author put in a lot of work, and my sense is that it will take the knowledgeable user a long way towards easing his/her transition from Word. Unfortunately, I am not a knowledgeable user.

I'm not new to scripts and such. I took my first (and only) programming course in 1979 (BASIC), and I worked a lot with scripts in the following 10-15 years. Nowadays, though, I'm sorry to report that I am a bit short on time, not to mention technically rusty. As a practical matter, I don't and won't know how to adapt the proffered macro to my situation.

For me, and probably for some others, the absence of an easy way to import the Word AutoCorrect list is a deal-breaker. I just do too much writing to try to get by without the full list.

What's the chance that someone could devise a better solution? The Word macro produces a table of entries (e.g., "teh") and their replacements (e.g., "the"). Can Writer (or a Writer macro) be adapted to import that table more straightforwardly?

[bobloblian]

A note for those that come across this thread that have as little experience with macros as I had two days ago, which was none. My charge was to migrate xp/msoffice to vista/openoffice. In order for all of this to work for me, I had to correct a few syntax problems first. They were almost all related to spaces where there shouldn't have been any. As I remember, the offending spaces were highlighted, deleting them carried on.
I got several errors about undefined functions. I am not sure what the correct way to fix that kind of problem is, but I worked around it by searching for the code relating to the functions and inserting them into this macro. If the line throwing the error has a StringWithCapsFollowedBy(), then search google for "function StringWithCapsFollowedBy". Most of them I found in macro organizer under openoffice.org macros=>tools=>strings. Just copied the function from there and pasted to the end of this macro.
For the big finale, the joinAC part kept giving me all sorts of grief about unsupported URL type. My final solution was to comment everything except the if-exists parts at the top, and the rezip part at the end, and renaming the documentlistpart1 file to documentlist.xml. no big deal for me since this was a fresh install and the original documentlist.xml was empty.
In the end, success was mine, and it tasted sweet.
Hope these couple of tidbits saves somebody a few of the hours it took me. And many many thanks to patb and zarius for providing this, much appreciated. Three cheers for each of you

[Tommy27]

[raywood]

In case anyone is still curious, the 10,000-entry limit existed in an earlier version of StarOffice and/or OO Writer. See e.g., http://www.amazon.co.uk/Sun-Microsystems-0614647643195-StarOffice-7-0/dp/B0000DG2N4

Also, for those who are searching for info on importing Word AutoCorrect entries into OOo Writer, the present thread appears to be a continuation of an earlier thread at http://www.oooforum.org/forum/viewtopic.phtml?t=10248

Since I'm not familiar with writing or modifying Word or OOo macros or code, I tried a method described in that older thread, with some variations. I wrote up the complete process I used in my blog. See http://raywoodcockslatest.blogspot.com/2008/06/importing-autocorrect-entries-from.html

[Tommy27]

actually the autocorrect entries limit seems to be 65214

if you reach that number the autocor.dat file crashes and all the entris previously stored are deleted. (tested on OOo 2.4.0)

i had a backup copy so i didn't loose my data.

i opened an issue here:
http://www.openoffice.org/issues/show_bug.cgi?id=87672

a workaoround to prevent the 65214 crash is described there in more detail.

[rmdemi]

Hello,

Thanks to Patb and Zarius for creating and modifications this module. I modified the macro module.

I put Modified code and application document (autocorr.odt) new forum site adress is;

http://user.services.openoffice.org/en/forum/viewtopic.php?f=21&t=7368

Code modifications is;
* Calc section, cut, copy, paste sections canceled. No more file operations.
* Now detectlocale function converts two byte locale strings to five bytes correct forms. Such as fr, tr to fr-FR, tr-TR
* File picker dialog added for selection backup word file
* If user hasn't acor_xx-xx.dat in user path macro copies it from OOo share path.
* İf writer has same autocorrect entries like word These entries doesn't insert to writer. So we prevent duplicate entries in writer auto correct list.

Now code is fully automatic like word macro.

Sincerely,

[Tommy27]

does anybody knows if it's possible to do the opposite...

i mean, can you export OOo autocorrect into MS Word?