|
Originally Posted by Carl(WNY)
|
|
I don't seem to have the choice in Lotus Organizer 4.1 to export the file in the (.csv) format. The only choies it gives me are 2 different (.txt) formats (ACSII Delimited, and ANSI) and two (dbf) formats Foxpro and and dBase... Do you think I have to by a program just to do this one time? 'Cause once I do this, I probably won't use Lotus anymore.
|
The program is pretty expensive for a one time use, I had other laplink products and I still think it cost about 30.00 USD.
You can try to do it manually, it will take some time. Export your information into all of those formats, the ascii delimited and the dbase .dbf are probably going to be the most helpful. I suspect you have some illegal characters in some of the fields, which are causing the records after that to not parse correctly.
export the files.
Now using excel or lotus 123, open the exported file. Look at how all the different formats come into the spreadsheet. The one that looks like it parsed the most number of records and fields correctly is the one that you should work with. Also on the delimmited file, try exports using different delimmiting characters, if that is an option. The spreadsheet program may ask you how you want the information displayed, you want each field in the record displayed in a separate column, and you want field names in the first line.
Now you need to do some homework about what characters are allowed in fields and therfore, how the columns need to be named.
You may also notice that some things seem to line up perfectly and then suddenly everthing will be in one cell, or a name will be split. Take out the offending characters to get things lined up again. Obviously this could take some time, if you are slow and patient, it is very doable.
Save this as a file type that outlook likes and mapping the field names in the exported file (corrected if needed) to the field names in Outlook, you should be able import without a problem. I don't think this technique will work with the notes. Feel free to PM me if you have questions.
If you stick with lotus, as I said I use version 5, PDASync is worth it and works well.