Import xlsx to Notes? Watch out for the upcoming "Notes Import Export Library"
Tags: Import Export Library IEL Excel
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.
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.
By using IEL you
will hopefully get more time to do other things, such as focusing on other
coding challenges!
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!
Add new fields.
Add your own fields too, which can be mapped just like any other field.
Add and edit
formulas on any target field. Don't want a straight data map? Why not
use ordinary @-formulas to create your own computed fields. Even some extra
@VC-functions are upcoming, so you for example in an exported Excel spreadsheet,
can create links back to the Notes documents.
Save and reload
settings. You map fields, rename them, add new ones and perhaps even
use formulas. What a shame if you couldn't save your settings, and reloading
them whenever needed.
Full unicode
support. IEL can treat your unicode content with grace!
Preview.
Sometimes it can be hard to know exactly what data gets imported- or exported.
By using the powerful preview dialog box, you can quickly see the what
the data will look like. Even formulas are executed
"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!
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!
| Permalink | 
Comments
Posted by Petter At 14:50:41 On 27.09.2011 | - Website - |
Posted by Ravi At 18:57:50 On 28.09.2011 | - Website - |
Or both (selected or all) categories and documents?
Posted by JF At 22:29:22 On 24.10.2011 | - Website - |