Address book import

HCL Domino Domino Forum
1

I need to import address book in notes which is in csv format. How can this be done ?

I am migrating my users from Outlook Express to Notes and stuck up on this point.

Any help would be greatly appreciated.

warm regards,

Pankaj

2

Subject: Address book import

hi,try this :

  • open your adress book

  • go to File → Import

  • Choose structered file

  • Pick your csv file

This should work (not sure)

E.H.Y

3

Subject: RE: Address book import

Dear Joe,

Thanks for the tip. But this is not working. Can you help me with some other method.

warm regards,

Pankaj

4

Subject: Free Lotus Notes/Domino Import Utility

We have a Notes / Domino Import Utility you can freely download from our website. It supports importing from CSV files, as well as other file formats.

It’s easy to use, comes with source code, developer comments, full help information and is fully supported.

You can download it from:

Hope it helps.

Alex

5

Subject: RE: Free Lotus Notes/Domino Import Utility

Hi Alex,I downloaded your utility, i liked it (many options and nice design )

But when Itried it I had no result

I don’t know if I had done some wrong think (i tried many times)

The field mapping si correct the import runs with no errors !

But no result in the adress book (I had done the test with a csv file from Outlook Express)

I don’t know but the error must be mine… so if you have any suggestion …

Regards

E.H.Y

6

Subject: RE: Free Lotus Notes/Domino Import Utility

Aaahhhh…yes a known issue. It’s to do with the view selection formula which contains: Type = “Person” rather than form. Your records will have been imported but just not visible.

You could open the People view or the hidden $Users view and change the selection formula temporarily to be: Form = “Person” which will make the imported contacts visible and then you can run an agent on those contact documents which has the following formula: FIELD Type:=“Person”. You can then change the view selection formula back.

When you run an import the value of the ‘Form’ field gets set (based on the form you selected when creating the import profile) and the only other fields that get set are those from the import file. Hence the ‘Type’ field does not get set. This is where the ‘Custom Scripts’ come handy - they enable you to add additional fields, perform changes to data in the imported documents and more.

So for your requirement you need to create a custom script which sets the value of the ‘Type’ field. Here’s how to set one up:

  • Open the Import Utility.

  • Click the ‘Custom Scripts - By Name’ view option in the left-hand navigator menu of the application.

  • Click the ‘New Custom Script’ button at the top of the view.

  • Type in ‘Set Person Type Field’ for the script title.

  • Type in the following script code:

              ImportDoc.Type = "Person"

          Call ImportDoc.Save(True, True)

  • Save & Close the custom script document.

  • Now select the ‘Import Profiles - By Name’ view option from the left-hand navigator menu.

  • Locate and open the import profile you are trying to run and put it into Edit mode.

  • Click the ‘Custom Scripts’ tab then select the ‘During Import’ tab.

  • Click the drop-down arrow next to the ‘Pre-Defined Custom Scripts’ field and select the custom script you just created.

  • Click the checkbox in upper right-hand corner of this section to indicate that the selected custom scripts should be run.

When you run your import again and the imported contacts should now appear in the People view.

If you need further assistance please use the ‘Contact Us’ form through our website.

Alex

7

Subject: By the way…

We are currently work on a new release which will allow you to import contact records directly from Outlook & Outlook Express into Lotus Notes without the need for exporting to CSV or other format first.

Alex

8

Subject: RE: By the way…

Hi Alex,Thanks for the tip, i will try it

wating for the new release…

E.H.Y

9

Subject: Import utility now supports Outlook

The latest version of our Notes/Domino import utility is now available with added support for importing Contacts & Distribution lists directly from Outlook.

You can download it from:

Regards,

Alex

10

Subject: RE: By the way…

Dear Alex,

Thanks for this. Could you please specify some time frame when are you going to make is available. It would be a great help for people like me.

warm regards,

Pankaj

11

Subject: RE: By the way…

Should be available in the next 2 weeks. You can check our website for the new release.

Alex

12

Subject: RE: Free Lotus Notes/Domino Import Utility

Hello!

Can you give me a sample how can i get data from csv in “Pre Import Scripts”?

It’s the same your sample about customer info, but in “pre import” tab and i don’t know how to get the values from the csv in pre-import section.

Thank you very much for your help!

Andrei