Free Tools for Importing Excel Data Into Notes

I've been meaning to blog about the
incredibly powerful if boringly named "Import" database/tool
from the folks at AGE Computer Consultancy
in Australia for, well, ages (sorry, couldn't help myself). There
is also a simpler "wizard" tool which was featured in Thierry
Seunevel's March/April 2007 VIEW article Automatically import/export spreadsheet
and other data with Notes wizards . In fairness,
I did mention these tools in my OpenNTF Blast
presentation from ILUG earlier this year. What finally caused
me to break down and write this blog entry was this post from Giulio
Campobassi lamenting the inability to save a Lotus Symphony spreadsheet
in 1-2-3 format. He goes on to complain:

...I will usually
want to do it so I can simplify the import and export operations I come
across. Especially in cases when configuring up client systems using an
initial import of data from the excel spreadsheet the client has been using
for the last 5 years.

Every time I read something like this
I just want to yell "STOP, you don't have to suffer!" Now that
I know you're reading this, I will no longer feel the need to yell, so
thank you for reading. You may take the cotton out of your ears.

By using either or both of these tools,
you can completely avoid the need to use the native 1-2-3 import to Notes
functions. You also get several other capabilities, and both tools
allow you to save and reuse import settings.

With the AGE Import tool you can:

Import spreadsheet data to update *existing*
Notes documents

Use in lieu of LEI or Notrix when those
tools are overkill but you don’t want to write a custom import agent

7 - Message from AGECOM....Due to the huge popularity of our Import Utility for Lotus Notes / Domino we are now investing more time in supporting and performing ongoing maintenance of the product. Hence we now charge a license fee for the product. We have, however, kept the price to a minimum - $79 (Australian).

For more details and to download the import utility click the following link:{ Link }

9 - There's a movement to radically change California government, by getting rid of career politicians and chopping their salaries in half. A group known as Citizens for California Reform wants to make the California legislature a part time time job, just like it was until 1966.

10 - By that I mean latching on to this or that latest, most innovative idea that some self styled money making guru has put out in the hope it’ll go viral and make them a lot of money off the backs of all the headless chickens who will follow them blindly down a blind alley. Its a shame but a truism nonetheless that people will follow where someone they see as an expert leads. Even if they lead them to certain disaster, which is what most of the gurus tend to do to their flocks. www.onlineuniversalwork.com

Disclaimer

This site is in no way affiliated, endorsed, sanctioned, supported, nor blessed by Lotus Software nor IBM Corporation, nor any of my past or future clients (although they are welcome to do so). The opinions, theories, facts, etc. presented here are my own and in no way represent any official pronouncement by me on behalf of any other entity.