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.

"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...

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.

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...
>

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"

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 !

"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.

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 !