Import xlsx to Notes? Watch out for the upcoming "Notes Import Export Library"
One of the features that have been missing in standard Notes, is the ability to import- and export directly to Excel. Yes, you can write some code achieve this, typically via OLE Automation (CreateObject ...), but that needs a programmer every time. With older versions of Excel, you could also go the long way via conversion to the 1-2-3 Workbook format, but again, pretty cumbersome.
The upcoming Notes Import Export Library (IEL) can import- and export the newest Excel 2007/2010 files with the xlsx file extension, as well as the older "97-2003 compability mode" files with the xls file extension. This can even be done without having Excel installed at all!
Seeing the highly visible field mapping above, you know exactly what gets imported- or exported.
With it's easy field mapping, hopefully pretty intuitive, everybody can quickly import a spreadsheet. Since IEL is a standard Import/Export library, it shows up in the standard Lotus Notes client Import- and Export dialog boxes, as shown below;
Note the new file type Excel 2007++ ...
Below you see a screenshot from the main import dialog box, where a couple of columns from the spreadsheet has been been mapped to some fields in Notes;
As soon as the import- or export starts, it all happens in a separate thread, so you can go right back to your work without having to wait for the job to finish. Below you see the import progress;
IEL contains some other cool features too!
- Rename target
field names. Don't like the field name in Notes? Or is the column header
in Excel too cryptic? Rename it!
"When, when, when?" you ask
Target release date is Sunday, October 23rd, 2011.
Possible to test? Yes!
For the beta-lovers out there, you might head over to the home page of IEL and download the current beta. Remember - beta versions is work in progress!