If you have the lotus 123 drivers for excel (last time I did this was with office 2003) you can open this file and save as excel or csv.įrom the notes odbc you will create a connection to your domino server. there somewhere along the way it will ask for the export format, pick Lotus 123 (yeah I know but you will get the best export fidelity). Goto File->Export and pick in the export view (sorry doing this from memory) you will pick the current view, column heading. Then from the notes client open the view you just created. One way to export the data from a domino database is to create a view with all of the fields displayed as you want them.
I'm on the fence with moving away from Domino, but moving to MS CRM.
Lotus notes 8.5 manual portugues pdf#
There is a company called RIVIT that will convert it all to a PDF format (DCOM), but I think that Adobe also has the same capability, it just might be a larger file format. If you are looking for a way to archive the Lotus Notes CRM application to a stand alone system there are a couple of options available. The data in the Domino database can easily be accessed through ODBC, and imported into the correct locations in your new CRM application. If you do not have developers helping you set up your Microsoft CRM system, you should contract someone.
I don't recall what that number is, but you will be notified, if you have hit that limit. The other issue you will run into is a limitation on the number of rows you can select. You could also be dealing with "response" documents, in the same view, and you don't want to export those at the same time as the "parent" documents. It can get confusing when you try to export data that way. When you do this, you have an option to split the value into multiple rows of data, causing duplication of selected records. The problem you are identifying, sounds like there is a multi-value field, that is being categorized. Sorts are fine, but categorizing will create spaces in your data. If you are going to use "copy selected as table" method, you want to make sure you are using a 'Flat' view. If your company had kept up with the newest versions of Notes and Domino, and if you had a developer maintaining your CRM application, you probably wouldn't even consider the Microsoft CRM.