Ben Langhinrichs

Photograph of Ben Langhinrichs
E-mail address - Ben Langhinrichs







Recent posts

Tue 7 Nov 2017

CoexLinks Migrate 4.10 released



Thu 2 Nov 2017

Time to Migrate



Thu 26 Oct 2017

Modernizing your Data


November, 2017
SMTWTFS
   01 02 03 04
05 06 07 08 09 10 11
12 13 14 15 16 17 18
19 20 21 22 23 24 25
26 27 28 29 30

Search the weblog





























Genii Weblog

Help needed in Lanes 1 and 2

Thu 20 Mar 2014, 10:01 AM



by Ben Langhinrichs
Yesterday, I laid out a roadmap for Genii Software, defining three lanes that we see companies fall into and how we aim to address the needs of those companies. Over the next few days, I will post a few examples to illustrate our goals.

Lanes 1 and Lane 2:Taking data from a Notes database to SQL server without Notes development

Problem: a company has a Notes database, and they need to take a number of fields of a specific form and put them into SQL Server tables. They may be migrating (Lane 1) or simply need it for a specific purpose (Lane 2), but have no Notes developers and don't want to hire consultants for a one-off need.

Solution: using the Midas LSX 5, a customer could download the Export to CSV sample database. All they would need to do is fill out an Export Directive form (see below) with the database and specify which forms and fields to export (or all of them, if they didn't know which are needed), then click the button. Importing the CSV into SQL server is easy, using a technique such as How to create and populate a table in a single step as part of a CSV import. There is no need for Notes developers, and the entire process can be done in an afternoon. This example includes a rich text field, which is rendered by default to high fidelity HTML.


Export directive form

Copyright © 2014 Genii Software Ltd.

What has been said:

No documents found