So today is a better day at the new job (wonder how long I’ll go before I don’t call it “new” anymore).
Today I had a lot of things to do. Edits to white paper, presentation, travel, formatting an excel table, another presentation, edits to excel spreadsheet.
I still have other things on my To Do list. Get my time sheet signed, fill out a sample call report for my boss to see if I know how to do it, create a weekly task template for my boss, research Garmin iQue and learn how to use it, create an index list for one boss’ file cabinets, and figure out how to import an excel spreadsheet contact list into Lotus Notes contact function (I’ve researched and don’t think this can be done – tell me if I’m wrong, please).
Update at 2:33 p.m.: Well, I just went to have Mr. Russell sign my timesheet and he protested the 1.83 hours of overtime I put down. He said that since I’m getting paid a bit more than most employees he’d like to reward me with comp time as opposed to paid OT. He said, “I remember telling you that if Mr. Sutherland and I are not here you’d be able to leave early on occasion – I’d prefer to go that route than pay overtime.”
I told him that was fine and that I’d do that from now on.
It doesn’t sound like you’re entirely fine with it…but maybe it’ll be nice to get to go home early, sometimes. đŸ™‚
I believe you can save the Excel as CSV and then do a file | import in Notes.
Ed is right that it can be done, but I don’t think that it can be done through a CSV file. I think you will have to save your spreadsheet in Lotus 1-2-3 format, but AFAIK Excel should still support that. Also, it requires some knowledge of how to make your own “private view” in Notes database that contains your contacts (which is called names.nsf). There are some basic instructions in the Notes help file, but the refer you to the Domino Designer help file for the real details. They do give you the url where you can get the Designer help.
Anyhow the basic idea is that you create the private view with columns that match the columns in your spreadsheet. The hardest part of this is figuring out what names Lotus gives to the specific fields that you need to map to your columns. A friendly Notes developer could probably do this for you in about 5 minutes, but if you’ve never done it before it may not be all that obvious — and you’ll probably want to make a copy of your contacts database to run a few tests on. Once you have the view set up with all the right columns, you go into your private view and select File – Import from the menu, and select Lotus 1-2-3 from the file type choices.
There are some 3rd-party products available that might make it a little easier, but I’m assuming you don’t actually want to spend money on this.
-rhs
More Notes Comments
Since I’ve broken the seal on commenting on the whole Lotus vs. Microsoft thing, I might as well go a step further. Here we have some innocent end user’s blog, loathing his/her inability to import some contacts into the personal…
Ed & RHS – thanks for your comments on the whole Lotus Notes thing. I was able to import his contacts into his Palm Desktop manager yesterday with my *.csv file (that was a no-brainer, it just took me a while to get around to it.) As I emailed Ed yesterday, I’ve opted to let our IT department take care of importing them into Lotus Notes.
Hi Jaynee!
Send this on to your IT department…
http://www-10.lotus.com/ldd/sandbox.nsf/ecc552f1ab6e46e4852568a90055c4cd/e56fec0e6fdacea785256a0f0077e2b5?OpenDocument&Highlight=0,outlook
It only takes about five minutes, and it will get that .CSV file into your Notes personal address book!
And please email me if you have any questions or problems.
Cheers,
Jess đŸ™‚