Importing Data From a CSV File

[Steve Anderson <s....@gmail.com>]

Hi there

I'm a CouchDB-newbie newbie (yes, that's two newbies).

How can I import data from a CSV file into a CouchDB database? I need to
create an automated way to do this.

The CSV file is produced from an MS Access database and each file will
contain all rows from the applicable MS Access table(s), rather than just
those that have changed. With that in mind, can one easily delete all
existing data from a CouchDB database prior to importing each CSV file? I'm
open to alternative approaches as I realise this approach may not be
efficient.

Finally, can anyone recommend companies offering CouchDB hosting services?

Thanks a lot.
*Steve*

-- 
Submission ...learn more at www.masjidtucson.org

Re: Importing Data From a CSV File

[Luis Carlos Junges <lu...@gmail.com>]

HI,

I have this problem also. I sent an email some time ago on this list and
they replied it with a python code to do that.

I particulary will upload on couchdb  just entries that have changed instead
of deleting everything


On Tue, Jan 11, 2011 at 12:43 PM, Amine BENHAMZA
<am...@gmail.com>wrote:

> Hi,
>
> I'm newbie too but still can give you some help : first of all, which
> language are you working with. You'll find here all the couchdb drivers  :
> http://www.couchone.com/page/dev/couchdb-drivers
>
> You'll be able then to parse your CSV file with your favourite language and
> feed your couchdb
>
> For hosting, take a look à at "couchone" & "cloudant".
>
> Good luck
>
> Amine.
>
> On 11 January 2011 14:28, Steve Anderson <s....@gmail.com> wrote:
>
> > Hi there
> >
> > I'm a CouchDB-newbie newbie (yes, that's two newbies).
> >
> > How can I import data from a CSV file into a CouchDB database? I need to
> > create an automated way to do this.
> >
> > The CSV file is produced from an MS Access database and each file will
> > contain all rows from the applicable MS Access table(s), rather than just
> > those that have changed. With that in mind, can one easily delete all
> > existing data from a CouchDB database prior to importing each CSV file?
> I'm
> > open to alternative approaches as I realise this approach may not be
> > efficient.
> >
> > Finally, can anyone recommend companies offering CouchDB hosting
> services?
> >
> > Thanks a lot.
> > *Steve*
> >
> > --
> > Submission ...learn more at www.masjidtucson.org
> >
>
>
>
> -
>



-- 
"A realidade de cada lugar e de cada época é uma alucinação coletiva."


Bloom, Howard

Re: Importing Data From a CSV File

[Amine BENHAMZA <am...@gmail.com>]

Hi,

I'm newbie too but still can give you some help : first of all, which
language are you working with. You'll find here all the couchdb drivers  :
http://www.couchone.com/page/dev/couchdb-drivers

You'll be able then to parse your CSV file with your favourite language and
feed your couchdb

For hosting, take a look à at "couchone" & "cloudant".

Good luck

Amine.

On 11 January 2011 14:28, Steve Anderson <s....@gmail.com> wrote:

> Hi there
>
> I'm a CouchDB-newbie newbie (yes, that's two newbies).
>
> How can I import data from a CSV file into a CouchDB database? I need to
> create an automated way to do this.
>
> The CSV file is produced from an MS Access database and each file will
> contain all rows from the applicable MS Access table(s), rather than just
> those that have changed. With that in mind, can one easily delete all
> existing data from a CouchDB database prior to importing each CSV file? I'm
> open to alternative approaches as I realise this approach may not be
> efficient.
>
> Finally, can anyone recommend companies offering CouchDB hosting services?
>
> Thanks a lot.
> *Steve*
>
> --
> Submission ...learn more at www.masjidtucson.org
>



-