Showtime
My Blackberry Enterprise Server Push Utility for the Lotus Notes Client, allows you to create Jobs for individual Channel, Message, and Browser Content Pushes, as well as allows you to delete Pushed Channel Icons from defined recipient devices.
Contact Information
Blogger, podcaster, writer, and geek Chris Toohey covers topics from application development to the latest must-have-gadgets.
Latest Updates
More on Mailer...
More on Junction Lite...
More on Remote Console...
More on Controller API Utility...
Products & Applications
Time Tracker
The idea is simple. At the start of your day - upon completion of your first task - create an entry highlighting what you did and whether you feel it was an efficient or inefficient use of your time. Based on several requests, you can also select the priority, apply categories, or even align your time against a project.
For Lotus Notes Client v8.0 and above, you can use the Time Tracker Widget to make this process even easier!
Zephyr
My Configuration-based Rich Text Mail Merge and Emailing Utility, Zephyr allows you to create rich, data-driven emails to support automated workflow - all via Microsoft Word Mail Merge-like architecture. Dear <firstname> allows you to personalize each email message not only to the individual recipient, but also to the individual application workflow event!
xCopy
xCopy is a simple configurable xCopy client for the Lotus Notes client. By creating and defining xCopy Profiles, you can batch process your file backup or remote upload jobs. With the addition of the xCopy sidebar widget, you can easily kick-off these jobs, and modify both the xCopy Profiles and xCopy itself.
Community & Resources
Lotus Technical Information & Education Community
The Lotus Technical Information & Education community is comprised of IBM, business partner, and customer subject matter experts who use product wikis, published articles, white papers, community blogs and the latest in social media to build and share high quality technical content.
OpenNTF.org - Open Source Community for Lotus Notes Domino
OpenNTF is devoted to enabling groups of individuals all over the world to collaborate on IBM Lotus Notes/Domino applications and release them as open source.
developerWorks Lotus : Wikis
Share your deployment experiences and best practices in our wikis and help IBM to create scenarios for successful deployments. Contribute to the community by collaborating on shared content and leverage the shared knowledge from that community.
Junction Lite v1.0 - Microsoft Excel Import Utility App for the IBM Lotus Notes Client
07/27/2010 12:45:25 AM by Chris Toohey
New Demo Video Coming Shortly!
Junction Lite allows you to create NotesDocuments in a defined target NotesDatabase from data in a Microsoft Excel Spreadsheet.
Each Job Document allows you to define a source Spreadsheet, a target NotesDatabase, and additional @Formula-driven NotesItems that are evaluated at import Runtime.
The idea is simple: Each Row in your Spreadsheet == 1 new NotesDocument in the defined target NotesDatabase!
As of version 1.1, you can now choose a Job Document Type:
| Type | Function |
| Import | 1 Row == 1 NotesDocument, aka direct import of the Excel Spreadsheet into the NotesDatabase. |
| Merge-Only | Using the first column of your Excel Spreadsheet to match the first [sorted] Column of your Target Notes View, you can now merge/update existing NotesData from a spreadsheet. |
| Merge and Import | When a match is found [see above], the NotesDocument is merged/updated. When there is no match for the defined key, the Row will be imported as a new NotesDocument in the NotesDatabase. |
Junction Lite allows you to import data sourced from Microsoft Access, SQL, or any other spreadsheet-generated data source.
Sales people tracking their leads and customer contacts in Excel? Bring that business-sensitive information into a Lotus Notes application within minutes with Junction Lite!
Licensing
As with all of my other $5 apps, this application is licensed per Lotus Domino Domain.
This means you have unlimited usage of Junction Lite v1.1 within your single Lotus Domino Domain for the low purchase price of $5 USD.
Additionally, those of you with licensed copies of Junction Lite v1.0 can download the v1.1 at no additional charge!
Simply use the download URL supplied at the time of purchase (you should have a follow-up email from ctoohey@dominoguru.com with the link) or simply email me at the aforementioned address and I will get you the download URL.
Purchase Information
Or you can click (and share!) the following direct purchase link:
|
Unless otherwise stated, this work is licensed under a Creative Commons Attribution-Share Alike 3.0 Unported License. |
and vice versa?
Chris:
Is it creating those fields on the fly in the Notes application (based on the column headings in the Excel spreadsheet?
Is the view (in your demo) generated programatically too?
Dan
I am a bit curious what Junction "Full" is capable of?
The last few seconds from the video seem to be missing by the way.
@Patrick:
There's an app for that... coming next week. Spread will allow you to export -- via configured logic -- NotesDocuments into an Excel Spreadsheet.
@Dan:
The View in the demo app is a standard View Deisgn Element, but each field / NotesItem is created at runtime based on the Source Excel Spreadsheet's first row/header or the formula-driven NotesItems documents in Junction Lite.
You'll notice -- in the demo vid -- that the
isFooandisBlahNotesItem are not only driven from the NotesItem documents, but also evaluated against the imported NotesDocument.This really gives you complete control over what's imported into your target NotesDatabase application!
@Henning:
Junction (Full) allows for scheduled imports, as well as allowing you to define an external data source (like SQL, XML) directly.
Lite is limited to imports via Microsoft Excel Spreadsheet.
And thanks for the catch on the video, demo video updated!.
We've already got our own importer interfaces, built over many years, that go wayyyyy beyond this here. But still Chris, I gotta say: SHAKE AND BAKE!