+ Reply to Thread
Results 1 to 9 of 9

Import / Export CSV files

  1. Import / Export CSV files

    Hello,
    In my application I need to import and export some CSV files.

    The imported datas are attached in a Notes document, but I need to read some
    of them.
    The export function takes datas within different kinds of Notes document and
    sometimes from attached CSV files.

    My question is : is there anything provided by Notes/Domino to access
    easyly datas that are located in a structured file ? Or must I do it myself,
    opening the text file, reading each lines etc ? I was thinking about
    something like an ODBC driver, to manipulate datas in a structured file as
    easyly as you can do with an array or a SQL table...


  2. Re: Import / Export CSV files

    On Wed, 8 Sep 2004 18:10:21 +0200, "Pierre Goiffon"
    wrote:

    >My question is : is there anything provided by Notes/Domino to access
    >easyly datas that are located in a structured file ?


    Pierre,

    no.

    >Or must I do it myself,
    >opening the text file, reading each lines etc ?


    Yes.

    Unless you find a third-party product.

    Hans-Georg

    --
    No mail, please.

  3. Re: Import / Export CSV files

    "Hans-Georg Michna" a écrit dans
    le message de news:f9qvj0pem9ahq9ou9if8btbkn6obqfqmep@4ax.com
    >> My question is : is there anything provided by Notes/Domino to
    >> access easyly datas that are located in a structured file ?
    >> Or must I do it myself,
    >> opening the text file, reading each lines etc ?

    >
    > Yes.
    >
    > Unless you find a third-party product.


    Damned.
    Anyway, thanks for the answer...


  4. Re: Re: Import / Export CSV files

    On Thu, 09 Sep 2004 07:25:40 +0200, Hans-Georg Michna
    wrote:

    >On Wed, 8 Sep 2004 18:10:21 +0200, "Pierre Goiffon"
    > wrote:
    >
    >>My question is : is there anything provided by Notes/Domino to access
    >>easyly datas that are located in a structured file ?

    >
    >Pierre,
    >
    >no.
    >
    >>Or must I do it myself,
    >>opening the text file, reading each lines etc ?

    >
    >Yes.
    >
    >Unless you find a third-party product.
    >
    >Hans-Georg


    See if you can find (download) a copy of NotesSQL, this will allow you
    to use ODBC to access the Notse server, then you may be able to do
    what you want using MS Access etc.

  5. Re: Import / Export CSV files

    Pierre,

    can you elaborate on what exactly you are trying to achieve?

    As far as I understand, you have DOMINO/Notes documents with attachments.
    These attachments contain comma seperated data items that you would like to
    read in your application. My first two questions would be:

    1. What technology is your application built on (programming language etc.)?
    This is quite important to know because DOMINO/Notes offers a lot of
    different interfaces and APIs that can be leveraged from different
    programming languages.

    2. Can you explain the next steps in the process in more detail? What
    happens once you get access to the data in the attachments? Do you want to
    modify them and save them back to the original DOMINO/Notes document? Do you
    need the data in your application and just export them to the filesystem?

    Maybe, I can help you. I have done a lot of work around exporting and
    importing documents from and to DOMINO/Notes. Any detail you can provide
    will make it much easier to guide you into the right direction. So, it's up
    to you.

    Looking forward to your response. If you are interested, you can contact me
    at jochen.tuemmers@gmx.de.


    Jochen


    "Pierre Goiffon" wrote in message
    news:413f2eee$0$32718$626a14ce@news.free.fr...
    > Hello,
    > In my application I need to import and export some CSV files.
    >
    > The imported datas are attached in a Notes document, but I need to read

    some
    > of them.
    > The export function takes datas within different kinds of Notes document

    and
    > sometimes from attached CSV files.
    >
    > My question is : is there anything provided by Notes/Domino to access
    > easyly datas that are located in a structured file ? Or must I do it

    myself,
    > opening the text file, reading each lines etc ? I was thinking about
    > something like an ODBC driver, to manipulate datas in a structured file as
    > easyly as you can do with an array or a SQL table...
    >




  6. Re: Import / Export CSV files

    There is code out there to do it. At least this will get you started.

    http://www.lotus.com/ldd/sandbox.nsf

    search for "csv"

  7. Re: Re: Import / Export CSV files

    a écrit dans le message de
    news:9s63k0pknuhnjkrpn9dc7sp0roeipgn7cm@4ax.com
    > See if you can find (download) a copy of NotesSQL, this will allow you
    > to use ODBC to access the Notse server, then you may be able to do
    > what you want using MS Access etc.


    Well my application is inside Domino, so this won't fit. But thanks for the
    idea !


  8. Re: Import / Export CSV files

    "Jochen Tuemmers" a écrit dans le message de
    news:cht2ba$1oon$1@ulysses.news.tiscali.de
    > can you elaborate on what exactly you are trying to achieve?


    Yes, sorry I didn't gave many details...
    Well, I used to relationnal databases, and they very often feat a
    import/export module, like DTS in SQL Server.

    Since a few months I work for a comapny that makes a Domino application -
    LotusScript mainly, for Notes and Web clients. Certain functionnalities are
    using CSV files, for import as for export purposes.

    I know a Notes database isn't a relationnal database... But I was searching
    for some way to simplify developper's tasks. Anything that can help to get
    each "cell" value of a CSV file, modify it, etc. A simple middleware - as
    when you want to read, write or delete some elements in a table ina
    relationnal database you don't have to write your own code but simply use
    SQL with a corresponding ODBC driver.


  9. Re: Import / Export CSV files

    a écrit dans le message de
    news:lMudnToRMI0nKt7cRVn-vg@adelphia.com
    > There is code out there to do it. At least this will get you started.
    >
    > http://www.lotus.com/ldd/sandbox.nsf
    >
    > search for "csv"


    Ooops, I didn't thought to go search therre. Thinks for the link !


+ Reply to Thread