Welcome to NeoOffice developer notes and announcements
NeoOffice
Developer notes and announcements
 
 

Download or installation problems? Try these steps
Problems after upgrading to NeoOffice 2017? Try these steps


Support
· NeoOffice Support
· NeoWiki


Announcements
· Twitter @NeoOffice


Downloads
· Download NeoOffice


RSS Feeds
· Announcements Only
· All Posts


  
NeoOffice :: View topic - Erratic mouse selection behaviour
Erratic mouse selection behaviour
 
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Testing
View previous topic :: View next topic  
Author Message
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Thu Dec 15, 2005 1:12 am    Post subject: Erratic mouse selection behaviour Reply with quote

Today I was doing my Christmas card labels (late as usual), editing my addresses in Neo (for this purpose I cannot do this in Address Book) and printing labels. [If something could be done about Address Book integration ('Wink')] Eventually, I had them in the format Name, Street, Town, Country as a long list. Whenever I moused to the beginning or end of a line in the listing, the word after or before the cursor is being highlighted, which of course is not very helpful('Confused'). I do not recall this behaviour in Neo 1.1 but I may be wrong. Anybody any suggestion how to avoid this? Confused
Back to top
View user's profile Send private message
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Thu Dec 15, 2005 1:44 am    Post subject: Reply with quote

Somewhere around here there's a set of instructions from Max for exporting data from Address Book...it's not integration, but it might have saved some retyping.... Sad

Smokey

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
View user's profile Send private message Visit poster's website
sardisson
Town Crier
Town Crier


Joined: Feb 01, 2004
Posts: 4588

PostPosted: Thu Dec 15, 2005 4:16 am    Post subject: Reply with quote

Hrm, I was going to reply to the post you left with the steps you used, but it has now disappeared! Sad

At any rate, Max's steps are now lost with the demise of ooodocs Sad I was going to add your steps to the wiki; there's an article all set up, but I'd only put the URL in there, not the steps Sad

This is probably a good warning for us to audit the articles whose content still has key bits referenced in posts at trinity rather than put into the wiki itself (like large parts of the databases articles that need to be re-done anyway)....

Smokey

_________________
"[...] whether the duck drinks hot chocolate or coffee is irrelevant." -- ovvldc and sardisson in the NeoWiki
Back to top
View user's profile Send private message Visit poster's website
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Thu Dec 15, 2005 5:51 am    Post subject: Reply with quote

Smokey, when you said that there had been instructions in the Wiki for the address book export I didn't want to bloat the forum and deleted the message. I see whether I can find a copy.

Martin
Back to top
View user's profile Send private message
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Thu Dec 15, 2005 6:27 am    Post subject: Reply with quote

To export your system Address Book to NeoO download Address Book Exporter from http://gwenhiver.net/applications/addressbookexporter/index.php (donation ware). In Address Book Exporter select the Address Book group you wish to export. Select "Export using current field settings". Click on Configure Settings and select the fields you wish to export. Click "Export". This creates a file called Exported Address Book.txt.

Open file in NeoO. Go Edit>Select all. Go to Tools>Text<->Table. In the opening window select the following options:
Separate text at Tabs, Equal width for all columns, Header & Don't split table selected, Repeat Header & Border unselected. Press OK. This converts the data into a NeoO table. Select the first row of the table. Go Edit>Select all>Copy. Go to File>New>Spreadsheet and go Edit>Paste. Save as NeoO spreadsheet.

Go File>AutoPilot>Address Data Source. Select "Other external data source", click Next and click on Settings. In the General tab insert appropriate name, under Data base type select Spreadsheet, click radio button under Data source URL, navigate to the spreadsheet file you saved earlier, click Open>OK. Click on Field Assignment and associate the NeoO fields with the appropriate fields of the spreadsheet. In most cases the fields correlate to each other while other times a user-defined NeoO field may have to be used. Click OK and then Create. The AutoPilot confirms that data has now become available to NeoO. Click OK.

When creating mailing labels the address data are now available. Most of the above steps can be automated by recording a macro.
Back to top
View user's profile Send private message
amayze
The Merovingian


Joined: Oct 24, 2005
Posts: 561
Location: Edinburgh, Scotland

PostPosted: Thu Dec 15, 2005 6:57 am    Post subject: Reply with quote

Glenner wrote:
...Click "Export". This creates a file called Exported Address Book.txt.

Open file in NeoO. Go Edit>Select all. Go to Tools>Text<->Table...


I'm not at a Mac I can test this on, but if you change the file extension to .csv NeoOffice should opening it using the spreadsheet. Change the delimiter from comma to tab in the import dialogue and then save it as a spreadsheet and jump straight to the third paragraph of Glenner's instructions.

Hope that works!

Andy.
Back to top
View user's profile Send private message Visit poster's website
Glenner
Oracle


Joined: Feb 03, 2004
Posts: 241
Location: Scotland

PostPosted: Thu Dec 15, 2005 7:07 am    Post subject: Reply with quote

Amayze, it works if you save the exported file from Address Book Exporter with a csv extension. That saves on the conversion step. Thanks.
Back to top
View user's profile Send private message
Display posts from previous:   
Post new topic   Reply to topic    NeoOffice Forum Index -> NeoOffice Testing All times are GMT - 7 Hours
Page 1 of 1

 
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
You cannot vote in polls in this forum
You cannot attach files in this forum
You cannot download files in this forum

Powered by phpBB © 2001, 2005 phpBB Group

All logos and trademarks in this site are property of their respective owner. The comments are property of their posters, all the rest © Planamesa Inc.
NeoOffice is a registered trademark of Planamesa Inc. and may not be used without permission.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.07 Seconds