You are viewing a plain text version of this content. The canonical link for it is here.
Posted to user@couchdb.apache.org by "Ramanadham, Radhika" <ra...@emc.com> on 2014/04/01 21:37:03 UTC
import csv data into couchdb document using python-cloudant module
Does anyone have a code snippet to import csv data into couchdb document leveraging python-cloudant module?
I want to check out what's available before trying to figure it out myself.
Thanks for the help in advance!
-Radhika
Re: import csv data into couchdb document using python-cloudant module
Posted by Jason Winshell <ja...@bearriver.com>.
Transform a CSV file into a JSON file with Python
http://jaranto.blogspot.com/2012/12/transform-csv-file-to-json-file-with.html
On Apr 1, 2014, at 12:37 PM, Ramanadham, Radhika <ra...@emc.com> wrote:
> Does anyone have a code snippet to import csv data into couchdb document leveraging python-cloudant module?
> I want to check out what's available before trying to figure it out myself.
>
> Thanks for the help in advance!
> -Radhika
Re: import csv data into couchdb document using python-cloudant module
Posted by Benoit Chesneau <bc...@gmail.com>.
On Tue, Apr 1, 2014 at 11:11 PM, Dave Cottlehuber <dc...@jsonified.com> wrote:
> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > radhika.ramanadham@emc.com> wrote:
> >
> > > Does anyone have a code snippet to import csv data into couchdb
> document
> > > leveraging python-cloudant module?
> > > I want to check out what's available before trying to figure it out
> myself.
> > >
> > > Thanks for the help in advance!
> > > -Radhika
>
> Radhika,
>
> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be
> sufficient for your needs, although a bit dated. There's enough info in
> https://cloudant.com/blog/using-python-with-cloudant/ and the newer
> https://github.com/cloudant-labs/cloudant-python/ to get up to speed if
> not. BTW I'm not a pythoneer (pythonista? pythonian?) so that's as far as I
> can help you.
>
> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com)
> wrote:
> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>
> BTW Benoît, you might want to elaborate how this apparently unrelated code
> might help the OP; as far as I can tell it doesn't?
>
>
> As far as I can telll if you want to upload CSV on a couchdb node i
>
As far as I can telll if you want to upload CSV on a couchdb node without
using a script you can do it using this extension. That if you have the
control of your couchdb node.
- benoit
Re: import csv data into couchdb document using python-cloudant module
Posted by Will Holley <wi...@gmail.com>.
If you want a couchapp / gui solution,
https://github.com/Mango-information-systems/csv2couchdb is decent and
provides options around document per row / per file.
On 2 April 2014 15:11, Ramanadham, Radhika <ra...@emc.com> wrote:
> Have a single doc with list of rows.
>
> Also, if I may ask, what is the use of attaching the files in a doc? When do people want to attach a file to a document?
>
> -----Original Message-----
> From: Simon Metson [mailto:simon@cloudant.com]
> Sent: Wednesday, April 02, 2014 2:15 AM
> To: user@couchdb.apache.org
> Subject: Re: import csv data into couchdb document using python-cloudant module
>
> Do you just want to attach the csv to a single doc (as a file) or have a single doc with a list of rows?
>
>
> On Wednesday, 2 April 2014 at 02:21, Ramanadham, Radhika wrote:
>
>> I tried this before and it creates a unique document for each row in the csv file.
>>
>> -----Original Message-----
>> From: Dave Cottlehuber [mailto:dch@jsonified.com]
>> Sent: Tuesday, April 01, 2014 5:11 PM
>> To: user@couchdb.apache.org
>> Subject: Re: import csv data into couchdb document using
>> python-cloudant module
>>
>> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
>> > radhika.ramanadham@emc.com> wrote:
>> >
>> > > Does anyone have a code snippet to import csv data into couchdb
>> > > document leveraging python-cloudant module?
>> > > I want to check out what's available before trying to figure it out myself.
>> > >
>> > > Thanks for the help in advance!
>> > > -Radhika
>> > >
>> >
>> >
>>
>>
>> Radhika,
>>
>> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There's enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I'm not a pythoneer (pythonista? pythonian?) so that's as far as I can help you.
>>
>> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com) wrote:
>> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>>
>>
>> BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn't?
>>
>> --
>> Dave Cottlehuber
>> Sent from my PDP11
>>
>>
>
>
Re: import csv data into couchdb document using python-cloudant
module
Posted by Simon Metson <si...@cloudant.com>.
An example is a doc that contained metadata about an image and had the image itself as an attachment.
On Wednesday, 2 April 2014 at 15:11, Ramanadham, Radhika wrote:
> Have a single doc with list of rows.
>
> Also, if I may ask, what is the use of attaching the files in a doc? When do people want to attach a file to a document?
>
> -----Original Message-----
> From: Simon Metson [mailto:simon@cloudant.com]
> Sent: Wednesday, April 02, 2014 2:15 AM
> To: user@couchdb.apache.org (mailto:user@couchdb.apache.org)
> Subject: Re: import csv data into couchdb document using python-cloudant module
>
> Do you just want to attach the csv to a single doc (as a file) or have a single doc with a list of rows?
>
>
> On Wednesday, 2 April 2014 at 02:21, Ramanadham, Radhika wrote:
>
> > I tried this before and it creates a unique document for each row in the csv file.
> >
> > -----Original Message-----
> > From: Dave Cottlehuber [mailto:dch@jsonified.com]
> > Sent: Tuesday, April 01, 2014 5:11 PM
> > To: user@couchdb.apache.org (mailto:user@couchdb.apache.org)
> > Subject: Re: import csv data into couchdb document using
> > python-cloudant module
> >
> > > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > > radhika.ramanadham@emc.com (mailto:radhika.ramanadham@emc.com)> wrote:
> > >
> > > > Does anyone have a code snippet to import csv data into couchdb
> > > > document leveraging python-cloudant module?
> > > > I want to check out what's available before trying to figure it out myself.
> > > >
> > > > Thanks for the help in advance!
> > > > -Radhika
> > >
> >
> >
> >
> >
> > Radhika,
> >
> > https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There’s enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I’m not a pythoneer (pythonista? pythonian?) so that’s as far as I can help you.
> >
> > On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com (mailto:bchesneau@gmail.com)) wrote:
> > > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
> >
> >
> >
> >
> > BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn’t?
> >
> > --
> > Dave Cottlehuber
> > Sent from my PDP11
>
RE: import csv data into couchdb document using python-cloudant
module
Posted by "Ramanadham, Radhika" <ra...@emc.com>.
Have a single doc with list of rows.
Also, if I may ask, what is the use of attaching the files in a doc? When do people want to attach a file to a document?
-----Original Message-----
From: Simon Metson [mailto:simon@cloudant.com]
Sent: Wednesday, April 02, 2014 2:15 AM
To: user@couchdb.apache.org
Subject: Re: import csv data into couchdb document using python-cloudant module
Do you just want to attach the csv to a single doc (as a file) or have a single doc with a list of rows?
On Wednesday, 2 April 2014 at 02:21, Ramanadham, Radhika wrote:
> I tried this before and it creates a unique document for each row in the csv file.
>
> -----Original Message-----
> From: Dave Cottlehuber [mailto:dch@jsonified.com]
> Sent: Tuesday, April 01, 2014 5:11 PM
> To: user@couchdb.apache.org
> Subject: Re: import csv data into couchdb document using
> python-cloudant module
>
> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > radhika.ramanadham@emc.com> wrote:
> >
> > > Does anyone have a code snippet to import csv data into couchdb
> > > document leveraging python-cloudant module?
> > > I want to check out what's available before trying to figure it out myself.
> > >
> > > Thanks for the help in advance!
> > > -Radhika
> > >
> >
> >
>
>
> Radhika,
>
> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There’s enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I’m not a pythoneer (pythonista? pythonian?) so that’s as far as I can help you.
>
> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com) wrote:
> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>
>
> BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn’t?
>
> --
> Dave Cottlehuber
> Sent from my PDP11
>
>
Re: import csv data into couchdb document using python-cloudant
module
Posted by Simon Metson <si...@cloudant.com>.
Do you just want to attach the csv to a single doc (as a file) or have a single doc with a list of rows?
On Wednesday, 2 April 2014 at 02:21, Ramanadham, Radhika wrote:
> I tried this before and it creates a unique document for each row in the csv file.
>
> -----Original Message-----
> From: Dave Cottlehuber [mailto:dch@jsonified.com]
> Sent: Tuesday, April 01, 2014 5:11 PM
> To: user@couchdb.apache.org
> Subject: Re: import csv data into couchdb document using python-cloudant module
>
> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > radhika.ramanadham@emc.com> wrote:
> >
> > > Does anyone have a code snippet to import csv data into couchdb
> > > document leveraging python-cloudant module?
> > > I want to check out what's available before trying to figure it out myself.
> > >
> > > Thanks for the help in advance!
> > > -Radhika
> > >
> >
> >
>
>
> Radhika,
>
> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There’s enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I’m not a pythoneer (pythonista? pythonian?) so that’s as far as I can help you.
>
> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com) wrote:
> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>
>
> BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn’t?
>
> --
> Dave Cottlehuber
> Sent from my PDP11
>
>
RE: import csv data into couchdb document using python-cloudant
module
Posted by "Ramanadham, Radhika" <ra...@emc.com>.
Thanks Matt. Will look into the links you sent.
-----Original Message-----
From: matt j. sorenson [mailto:matt@sorensonbros.net]
Sent: Wednesday, April 02, 2014 12:03 AM
To: user@couchdb.apache.org
Subject: Re: import csv data into couchdb document using python-cloudant module
being the lazy hack I am, I have achieved this in the past (>1 yr ago) using google refine and max ogden's refine uploader...
https://github.com/maxogden/refine-uploader/
https://github.com/maxogden/refine-uploader/#visual-example
cheers
--
Matt
On Tue, Apr 1, 2014 at 8:21 PM, Ramanadham, Radhika < radhika.ramanadham@emc.com> wrote:
> I tried this before and it creates a unique document for each row in
> the csv file.
>
> -----Original Message-----
> From: Dave Cottlehuber [mailto:dch@jsonified.com]
> Sent: Tuesday, April 01, 2014 5:11 PM
> To: user@couchdb.apache.org
> Subject: Re: import csv data into couchdb document using
> python-cloudant module
>
> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > radhika.ramanadham@emc.com> wrote:
> >
> > > Does anyone have a code snippet to import csv data into couchdb
> > > document leveraging python-cloudant module?
> > > I want to check out what's available before trying to figure it
> > > out
> myself.
> > >
> > > Thanks for the help in advance!
> > > -Radhika
>
> Radhika,
>
> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might
> be sufficient for your needs, although a bit dated. There's enough
> info in https://cloudant.com/blog/using-python-with-cloudant/ and the
> newer https://github.com/cloudant-labs/cloudant-python/ to get up to
> speed if not. BTW I'm not a pythoneer (pythonista? pythonian?) so
> that's as far as I can help you.
>
> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com)
> wrote:
> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>
> BTW Benoît, you might want to elaborate how this apparently unrelated
> code might help the OP; as far as I can tell it doesn't?
>
> --
> Dave Cottlehuber
> Sent from my PDP11
>
>
>
>
>
Re: import csv data into couchdb document using python-cloudant module
Posted by "matt j. sorenson" <ma...@sorensonbros.net>.
being the lazy hack I am, I have achieved this in the past (>1 yr ago)
using google refine and max ogden's refine uploader...
https://github.com/maxogden/refine-uploader/
https://github.com/maxogden/refine-uploader/#visual-example
cheers
--
Matt
On Tue, Apr 1, 2014 at 8:21 PM, Ramanadham, Radhika <
radhika.ramanadham@emc.com> wrote:
> I tried this before and it creates a unique document for each row in the
> csv file.
>
> -----Original Message-----
> From: Dave Cottlehuber [mailto:dch@jsonified.com]
> Sent: Tuesday, April 01, 2014 5:11 PM
> To: user@couchdb.apache.org
> Subject: Re: import csv data into couchdb document using python-cloudant
> module
>
> > On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> > radhika.ramanadham@emc.com> wrote:
> >
> > > Does anyone have a code snippet to import csv data into couchdb
> > > document leveraging python-cloudant module?
> > > I want to check out what's available before trying to figure it out
> myself.
> > >
> > > Thanks for the help in advance!
> > > -Radhika
>
> Radhika,
>
> https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be
> sufficient for your needs, although a bit dated. There's enough info in
> https://cloudant.com/blog/using-python-with-cloudant/ and the newer
> https://github.com/cloudant-labs/cloudant-python/ to get up to speed if
> not. BTW I'm not a pythoneer (pythonista? pythonian?) so that's as far as I
> can help you.
>
> On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com)
> wrote:
> > https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
>
> BTW Benoît, you might want to elaborate how this apparently unrelated code
> might help the OP; as far as I can tell it doesn't?
>
> --
> Dave Cottlehuber
> Sent from my PDP11
>
>
>
>
>
RE: import csv data into couchdb document using python-cloudant
module
Posted by "Ramanadham, Radhika" <ra...@emc.com>.
I tried this before and it creates a unique document for each row in the csv file.
-----Original Message-----
From: Dave Cottlehuber [mailto:dch@jsonified.com]
Sent: Tuesday, April 01, 2014 5:11 PM
To: user@couchdb.apache.org
Subject: Re: import csv data into couchdb document using python-cloudant module
> On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> radhika.ramanadham@emc.com> wrote:
>
> > Does anyone have a code snippet to import csv data into couchdb
> > document leveraging python-cloudant module?
> > I want to check out what's available before trying to figure it out myself.
> >
> > Thanks for the help in advance!
> > -Radhika
Radhika,
https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There’s enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I’m not a pythoneer (pythonista? pythonian?) so that’s as far as I can help you.
On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com) wrote:
> https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn’t?
--
Dave Cottlehuber
Sent from my PDP11
Re: import csv data into couchdb document using python-cloudant
module
Posted by Dave Cottlehuber <dc...@jsonified.com>.
> On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
> radhika.ramanadham@emc.com> wrote:
>
> > Does anyone have a code snippet to import csv data into couchdb document
> > leveraging python-cloudant module?
> > I want to check out what's available before trying to figure it out myself.
> >
> > Thanks for the help in advance!
> > -Radhika
Radhika,
https://bitbucket.org/jagan/misc/src/84cefb61c86a/csv2couch.py might be sufficient for your needs, although a bit dated. There’s enough info in https://cloudant.com/blog/using-python-with-cloudant/ and the newer https://github.com/cloudant-labs/cloudant-python/ to get up to speed if not. BTW I’m not a pythoneer (pythonista? pythonian?) so that’s as far as I can help you.
On 01. April 2014 at 22:08:32, Benoit Chesneau (bchesneau@gmail.com) wrote:
> https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
BTW Benoît, you might want to elaborate how this apparently unrelated code might help the OP; as far as I can tell it doesn’t?
--
Dave Cottlehuber
Sent from my PDP11
Re: import csv data into couchdb document using python-cloudant module
Posted by Benoit Chesneau <bc...@gmail.com>.
https://github.com/refuge-incubator/rc_csv is a direct rcouch extension.
On Tue, Apr 1, 2014 at 9:37 PM, Ramanadham, Radhika <
radhika.ramanadham@emc.com> wrote:
> Does anyone have a code snippet to import csv data into couchdb document
> leveraging python-cloudant module?
> I want to check out what's available before trying to figure it out myself.
>
> Thanks for the help in advance!
> -Radhika
>