Forgot your password?
New user?
tagrows source archive
A theme with an enhanced dock
1. Intro
Document Actions
Hello everyone!
A couple of weeks ago I had to import approx. 3500 contacts into OGo.
The contacts were exported from Outlook into a CSV file, which needed some editing before I was able to create consistent entries in both the company and the person tables.
I decided to do most of the editing in a spreadsheet (Excel, in my case) because it's good for an overview and for locating inconsistent entries (like person title not in a separate column or country information in different languages etc.). Also, I was able to locate very long lines (e.g. company name) that needed to be wrapped).
Although it was a lot of work to go through all those lines several time, it was neccessary because Outlook has much less information than OGo has.
For example: I had several freelance workers in my list of addresses. Those people didn't belong to a company, yet I wanted to add a line like "type of business" to the address entries. Outlook had a line for "job title" where this information was filled in. However, I didn't want to always add the job title to the address. So I was forced to manually split this field in Excel, where I had simple formular support that shifted the content of job title to type of business if company field was empty.
Of course, this could have been done during the import by the script, but I wanted to check the results visually. There are so many special cases - it can't always be done by simple algorithms.
To stay at the above example: I realised that even though in most cases I didn't want the job title to be part of the address, in some cases I had to fill it in: People who are members of the trade union need to be addressed with this title by law if you send them confidential information.
You will probably have similar cases when you take a close look at your data.
So, in order to have the information as consistent as possible, you'll need to play around with some spreadsheet.
Read the Features page and the HowTo to get started.
You'll find all the related files (including the script itself) if you click on "Switch to Contents View" in the navigation tab (upper left corner of this page). If you don't have this tab, click here:
Helper Script for Configuration
Image of imported Data with Lat1-Characters
Example Import File, corresponding to above configuration
--
Feel free to drop me a line if you find bugs or if you'd like to conribute. I'll also try to answer questions if time allows and I will eventually add a FAQ section to these pages.
Have fun,
Torsten
Where is the file?????
I have been looking for the script but it is no where to be found please could some post a update to tell me and others people where it is...
Where is the file?????
I have been looking for the script but it is no where to be found please could some post a update to tell me and others people where it is...
Replies to this comment
Click on "Switch to Contents View"
Or click on the links a added to the bottom of the info document.
Error on Mandrake 10.0
Hello there... I've been fussing with your script and keep running into an error. I'm wondering if I'm missing something obvious (like a python module?), or if there's something else going on.
System is Mandrake 10.0, Apache 2.0.48, OGo installed from OGo RPMS dated 8/31/2004. OGo is up and running and I am able to log into the WebUI with this username and password.
Below is a sample session:
[root@test opengroupware.org]# ./import_perscomp.py
Please enter username: xxxx
Please enter password for user rbtech: yyyy
Please enter filename: testContacts.csv
Traceback (most recent call last):
File "./import_perscomp.py", line 408, in ?
password = cfg.password)
TypeError: __init__() got an unexpected keyword argument login
[root@test opengroupware.org]#
Thanks for any light you can shed...
Rubin
I've seen a few messages posted regarding the script to import contacts, but non mention where to get it from.
Please point me out to where I can get this script from. Thanks
Replies to this comment