You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@netbeans.apache.org by Periklis Ntanasis <pn...@gmail.com> on 2019/05/12 15:12:40 UTC
[db] Export of database results in CSV or other format
Hi all,
I was wondering if there is a way in Netbeans or a module to export the
database results to CSV or other formats.
I have looked around and posted a question on users mailing list (
http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser)
about that and so far I don't see something relevant. There was an old
issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which seems
unresolved.
I would be interested in creating a module or contributing a patch that
provides this functionality. Do you know if there is already this
implemented somewhere or if someone is working on it?
Thank you,
Periklis.
AW: [db] Export of database results in CSV or other format
Posted by Christian Lenz <ch...@gmx.net>.
Hey Periklis,
in general, rendundant functionality can be useful too. For me, in Person it to late the result, but for you or someone else can be the right direction. This is why I sent you the link where I also expected it. But sure, on the result page it is also fine 😊 and Maybe a bit simpler.
Cheers
Chris
Von: Periklis Ntanasis
Gesendet: Montag, 13. Mai 2019 23:33
An: dev@netbeans.apache.org
Betreff: Re: [db] Export of database results in CSV or other format
Hi all and thank you for your emails and suggestions.
I'll start looking into it. Any suggestions are more than welcome so please
feel free to share your thoughts.
Christian, I was actually thinking not to export all the contents of a
table but to export the results displayed in the grid/table after executing
a query. That way one can export a subset of a table or joins etc. I find
that more flexible. However, exporting many rows that way could be
problematic.
What do you think would be more useful?
Cheers,
Periklis
On Mon, May 13, 2019 at 12:58 AM David Soles <ds...@gmail.com> wrote:
> Hi everyone,
> First time participating in this mailing list.
> Just want to say that this feature would be awesome and very useful.
>
> Regards,
>
> - David
>
> On Sun, May 12, 2019 at 5:24 PM Christian Lenz <ch...@gmx.net>
> wrote:
>
> > Great, this is a really Handy feature as DataGrip has it and more Export
> > possibilites as you can see it here:
> >
> https://d3nmt5vlzunoa1.cloudfront.net/datagrip/files/2016/07/DumpSchemas.png
> >
> > I think, if you would like to add one Provider (CSV in this example)
> > others (like me) can jump in and add more like HTML and JSON. So it must
> be
> > easy as it is there. Right click any table(s) or database and export it.
> >
> >
> > Cheers
> >
> > Chris
> >
> >
> >
> > Von: Geertjan Wielenga
> > Gesendet: Sonntag, 12. Mai 2019 17:17
> > An: dev
> > Betreff: Re: [db] Export of database results in CSV or other format
> >
> > I don't believe anyone is working on this and it would be a cool
> feature, a
> > bit like this, except that a CSV file would be generated instead of a
> > visual diagram:
> >
> > http://wiki.netbeans.org/VisualDatabaseExplorer
> >
> > Gj
> >
> > On Sun, May 12, 2019 at 5:13 PM Periklis Ntanasis <pn...@gmail.com>
> > wrote:
> >
> > > Hi all,
> > >
> > > I was wondering if there is a way in Netbeans or a module to export the
> > > database results to CSV or other formats.
> > >
> > > I have looked around and posted a question on users mailing list (
> > >
> >
> http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser
> > > )
> > > about that and so far I don't see something relevant. There was an old
> > > issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which
> seems
> > > unresolved.
> > >
> > > I would be interested in creating a module or contributing a patch that
> > > provides this functionality. Do you know if there is already this
> > > implemented somewhere or if someone is working on it?
> > >
> > > Thank you,
> > > Periklis.
> > >
> >
> > --
> David Soles
> Software Engineer
>
Re: [db] Export of database results in CSV or other format
Posted by Periklis Ntanasis <pn...@gmail.com>.
Hi all and thank you for your emails and suggestions.
I'll start looking into it. Any suggestions are more than welcome so please
feel free to share your thoughts.
Christian, I was actually thinking not to export all the contents of a
table but to export the results displayed in the grid/table after executing
a query. That way one can export a subset of a table or joins etc. I find
that more flexible. However, exporting many rows that way could be
problematic.
What do you think would be more useful?
Cheers,
Periklis
On Mon, May 13, 2019 at 12:58 AM David Soles <ds...@gmail.com> wrote:
> Hi everyone,
> First time participating in this mailing list.
> Just want to say that this feature would be awesome and very useful.
>
> Regards,
>
> - David
>
> On Sun, May 12, 2019 at 5:24 PM Christian Lenz <ch...@gmx.net>
> wrote:
>
> > Great, this is a really Handy feature as DataGrip has it and more Export
> > possibilites as you can see it here:
> >
> https://d3nmt5vlzunoa1.cloudfront.net/datagrip/files/2016/07/DumpSchemas.png
> >
> > I think, if you would like to add one Provider (CSV in this example)
> > others (like me) can jump in and add more like HTML and JSON. So it must
> be
> > easy as it is there. Right click any table(s) or database and export it.
> >
> >
> > Cheers
> >
> > Chris
> >
> >
> >
> > Von: Geertjan Wielenga
> > Gesendet: Sonntag, 12. Mai 2019 17:17
> > An: dev
> > Betreff: Re: [db] Export of database results in CSV or other format
> >
> > I don't believe anyone is working on this and it would be a cool
> feature, a
> > bit like this, except that a CSV file would be generated instead of a
> > visual diagram:
> >
> > http://wiki.netbeans.org/VisualDatabaseExplorer
> >
> > Gj
> >
> > On Sun, May 12, 2019 at 5:13 PM Periklis Ntanasis <pn...@gmail.com>
> > wrote:
> >
> > > Hi all,
> > >
> > > I was wondering if there is a way in Netbeans or a module to export the
> > > database results to CSV or other formats.
> > >
> > > I have looked around and posted a question on users mailing list (
> > >
> >
> http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser
> > > )
> > > about that and so far I don't see something relevant. There was an old
> > > issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which
> seems
> > > unresolved.
> > >
> > > I would be interested in creating a module or contributing a patch that
> > > provides this functionality. Do you know if there is already this
> > > implemented somewhere or if someone is working on it?
> > >
> > > Thank you,
> > > Periklis.
> > >
> >
> > --
> David Soles
> Software Engineer
>
Re: [db] Export of database results in CSV or other format
Posted by David Soles <ds...@gmail.com>.
Hi everyone,
First time participating in this mailing list.
Just want to say that this feature would be awesome and very useful.
Regards,
- David
On Sun, May 12, 2019 at 5:24 PM Christian Lenz <ch...@gmx.net>
wrote:
> Great, this is a really Handy feature as DataGrip has it and more Export
> possibilites as you can see it here:
> https://d3nmt5vlzunoa1.cloudfront.net/datagrip/files/2016/07/DumpSchemas.png
>
> I think, if you would like to add one Provider (CSV in this example)
> others (like me) can jump in and add more like HTML and JSON. So it must be
> easy as it is there. Right click any table(s) or database and export it.
>
>
> Cheers
>
> Chris
>
>
>
> Von: Geertjan Wielenga
> Gesendet: Sonntag, 12. Mai 2019 17:17
> An: dev
> Betreff: Re: [db] Export of database results in CSV or other format
>
> I don't believe anyone is working on this and it would be a cool feature, a
> bit like this, except that a CSV file would be generated instead of a
> visual diagram:
>
> http://wiki.netbeans.org/VisualDatabaseExplorer
>
> Gj
>
> On Sun, May 12, 2019 at 5:13 PM Periklis Ntanasis <pn...@gmail.com>
> wrote:
>
> > Hi all,
> >
> > I was wondering if there is a way in Netbeans or a module to export the
> > database results to CSV or other formats.
> >
> > I have looked around and posted a question on users mailing list (
> >
> http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser
> > )
> > about that and so far I don't see something relevant. There was an old
> > issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which seems
> > unresolved.
> >
> > I would be interested in creating a module or contributing a patch that
> > provides this functionality. Do you know if there is already this
> > implemented somewhere or if someone is working on it?
> >
> > Thank you,
> > Periklis.
> >
>
> --
David Soles
Software Engineer
AW: [db] Export of database results in CSV or other format
Posted by Christian Lenz <ch...@gmx.net>.
Great, this is a really Handy feature as DataGrip has it and more Export possibilites as you can see it here: https://d3nmt5vlzunoa1.cloudfront.net/datagrip/files/2016/07/DumpSchemas.png
I think, if you would like to add one Provider (CSV in this example) others (like me) can jump in and add more like HTML and JSON. So it must be easy as it is there. Right click any table(s) or database and export it.
Cheers
Chris
Von: Geertjan Wielenga
Gesendet: Sonntag, 12. Mai 2019 17:17
An: dev
Betreff: Re: [db] Export of database results in CSV or other format
I don't believe anyone is working on this and it would be a cool feature, a
bit like this, except that a CSV file would be generated instead of a
visual diagram:
http://wiki.netbeans.org/VisualDatabaseExplorer
Gj
On Sun, May 12, 2019 at 5:13 PM Periklis Ntanasis <pn...@gmail.com>
wrote:
> Hi all,
>
> I was wondering if there is a way in Netbeans or a module to export the
> database results to CSV or other formats.
>
> I have looked around and posted a question on users mailing list (
> http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser
> )
> about that and so far I don't see something relevant. There was an old
> issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which seems
> unresolved.
>
> I would be interested in creating a module or contributing a patch that
> provides this functionality. Do you know if there is already this
> implemented somewhere or if someone is working on it?
>
> Thank you,
> Periklis.
>
Re: [db] Export of database results in CSV or other format
Posted by Geertjan Wielenga <ge...@apache.org>.
I don't believe anyone is working on this and it would be a cool feature, a
bit like this, except that a CSV file would be generated instead of a
visual diagram:
http://wiki.netbeans.org/VisualDatabaseExplorer
Gj
On Sun, May 12, 2019 at 5:13 PM Periklis Ntanasis <pn...@gmail.com>
wrote:
> Hi all,
>
> I was wondering if there is a way in Netbeans or a module to export the
> database results to CSV or other formats.
>
> I have looked around and posted a question on users mailing list (
> http://mail-archives.apache.org/mod_mbox/netbeans-users/201905.mbox/browser
> )
> about that and so far I don't see something relevant. There was an old
> issue (https://netbeans.org/bugzilla/show_bug.cgi?id=154740) which seems
> unresolved.
>
> I would be interested in creating a module or contributing a patch that
> provides this functionality. Do you know if there is already this
> implemented somewhere or if someone is working on it?
>
> Thank you,
> Periklis.
>