#dominoforever | Product Ideas Portal

 

Welcome to the #dominoforever Product Ideas Forum! The place where you can submit product ideas and enhancement request. We encourage you to participate by voting on, commenting on, and creating new ideas. All new ideas will be evaluated by HCL Product Management & Engineering teams, and the next steps will be communicated. While not all submitted ideas will be executed upon, community feedback will play a key role in influencing which ideas are and when they will be implemented.

For more information and upcoming events around #dominoforever, please visit our Destination Domino Page

import data directly from XLS/ODS file (Lotus 123 is too old)

To import data into a notes client:

it is possible to import from Lotus 123, but not from Excel or OpenOffice

(my solution or workaround  is to use an old Excel 2003, which can save as WK4 (Lotus 123))

  • Guest
  • Jul 23 2018
  • Planning to implement
  • Attach files
  • Guest commented
    14 Sep 10:50am


    3 years ago I added this thread? Will there be a solution?

    Like Theo I used the 123-importer very often, and I think more than 115 votes show that a lot of people are missing this feature.

  • Guest commented
    12 Aug 02:27pm

    Agreed with Theo!

    Import/Export from/to Excel means ability to export a set of documents from a view to Excel speadsheet file of specified format. and then to import it into another DB with fields set as headers and each Excel row to convert into separate docs in goal DB

    Ivan Kuzmenkov, Ambassador 2021 class

  • Guest commented
    12 Aug 02:02pm

    This only imports Excel data into a Rich Text.

    It does not import from a view, where records from Excel are transformed into Notes documents. The ‘old’ 123 importer did this, and I used it a lot.


    Please add this capability too, as I’m sure this is what the requestor wanted.


    And change the status, if set to ‘implemented’


    Theo

  • Admin
    Thomas Hampel commented
    12 Aug 01:55pm

    Import from XLS is available in Notes 12.0

  • Guest commented
    27 Feb, 2020 10:03am

    If this is implemented then please consider this idea as wel https://domino-ideas.hcltechsw.com/ideas/NTS-I-209

  • Guest commented
    25 Oct, 2018 01:27pm

    I have installed Notes V10 Client, but the import / export options are the same as in 9, no xls files. Where is the option?

  • Guest commented
    2 Aug, 2018 06:56pm

    .xls support is available in V10 Beta

  • Guest commented
    24 Jul, 2018 03:12pm

    .xlsx and .odf should be considered as well.

  • Guest commented
    24 Jul, 2018 12:29pm

    Thanks for your proposal!

    I have a lot of import utilities, too.

    I have written them in JavaScript, and Java, and from command line via Ruby and OLE.

    All is working, but  nothing on earth could replace a fast and interactive import with the Notes Client.

  • Guest commented
    24 Jul, 2018 12:22pm

    It would be nice to have a configurable import-from-Excel function. In the meantime you can use this approach: http://www.botstation.com/code/excel_people_to_notes.php