Could you please advise how to set the csv download path? Thanks.

classic Classic list List threaded Threaded
7 messages Options
Reply | Threaded
Open this post in threaded view
|

Could you please advise how to set the csv download path? Thanks.

vanbell
Hi Team,

Could you please advise how to set the csv download path on the web page pgAdmin4 tool?

Thanks so much.



 

Reply | Threaded
Open this post in threaded view
|

Re: Could you please advise how to set the csv download path? Thanks.

Dave Page-7
Hi

On Wed, Mar 13, 2019 at 9:05 AM vanbell <[hidden email]> wrote:
Hi Team,

Could you please advise how to set the csv download path on the web page pgAdmin4 tool?

When you click the button, it should prompt and default to the browser's download location.

Note that in 4.3, there's an issue with Firefox in which it fails to prompt. A workaround for that has been committed (you can find it in the nightly snapshot builds - but make sure your browser cache is fully cleared), or you can use Chrome in which it'll work as expected.
 

Thanks so much.



 



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company
Reply | Threaded
Open this post in threaded view
|

Re:Re: Could you please advise how to set the csv download path? Thanks.

vanbell
Hi Dave,

Thanks so much. Now it is clear.
Thanks again.
Have a nice day.






在 2019-03-13 17:12:33,"Dave Page" <[hidden email]> 写道:
Hi

On Wed, Mar 13, 2019 at 9:05 AM vanbell <[hidden email]> wrote:
Hi Team,

Could you please advise how to set the csv download path on the web page pgAdmin4 tool?

When you click the button, it should prompt and default to the browser's download location.

Note that in 4.3, there's an issue with Firefox in which it fails to prompt. A workaround for that has been committed (you can find it in the nightly snapshot builds - but make sure your browser cache is fully cleared), or you can use Chrome in which it'll work as expected.
 

Thanks so much.



 



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


 

Reply | Threaded
Open this post in threaded view
|

Re: Could you please advise how to set the csv download path? Thanks.

Isaías Sánchez

Hi,

I am getting error even in Chromium when exporting to CSV it says [Object Blob] and  in the log I can see this:

2019-03-14 12:16:27,375: ERROR  pgadmin:        object of type 'set_iterator' has no len()
Traceback (most recent call last):
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1612, in full_dispatch_request
    rv = self.dispatch_request()
  File "/usr/local/lib/python3.6/site-packages/flask/app.py", line 1598, in dispatch_request
    return self.view_functions[rule.endpoint](**req.view_args)
  File "/usr/local/lib/python3.6/site-packages/flask_login.py", line 792, in decorated_view
    return func(*args, **kwargs)
  File "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/tools/sqleditor/__init__.py", line 1350, in start_query_download_tool
    data = request.values if request.values else None
  File "/usr/local/lib/python3.6/site-packages/werkzeug/datastructures.py", line 1409, in __len__
    return len(self.keys())
TypeError: object of type 'set_iterator' has no len()

I have pgAdmin4 v4.3

Regards,

Isaias S.

On 13/3/19 9:27, vanbell wrote:
Hi Dave,

Thanks so much. Now it is clear.
Thanks again.
Have a nice day.






在 2019-03-13 17:12:33,"Dave Page" [hidden email] 写道:
Hi

On Wed, Mar 13, 2019 at 9:05 AM vanbell <[hidden email]> wrote:
Hi Team,

Could you please advise how to set the csv download path on the web page pgAdmin4 tool?

When you click the button, it should prompt and default to the browser's download location.

Note that in 4.3, there's an issue with Firefox in which it fails to prompt. A workaround for that has been committed (you can find it in the nightly snapshot builds - but make sure your browser cache is fully cleared), or you can use Chrome in which it'll work as expected.
 

Thanks so much.



 



--
Dave Page
Blog: http://pgsnake.blogspot.com
Twitter: @pgsnake

EnterpriseDB UK: http://www.enterprisedb.com
The Enterprise PostgreSQL Company


 

Reply | Threaded
Open this post in threaded view
|

Error Exporting to CSV

Isaías Sánchez
Hi,

Is this caused by any version of flask or so?

Regards,

Isaias S.

On 14/3/19 12:21, Isaias Sanchez wrote:

>
> Hi,
>
> I am getting error even in Chromium when exporting to CSV it says
> [Object Blob] and  in the log I can see this:
>
> 2019-03-14 12:16:27,375: ERROR  pgadmin:        object of type
> 'set_iterator' has no len()
> Traceback (most recent call last):
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1612, in full_dispatch_request
>     rv = self.dispatch_request()
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1598, in dispatch_request
>     return self.view_functions[rule.endpoint](**req.view_args)
>   File "/usr/local/lib/python3.6/site-packages/flask_login.py", line
> 792, in decorated_view
>     return func(*args, **kwargs)
>   File
> "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/tools/sqleditor/__init__.py",
> line 1350, in start_query_download_tool
>     data = request.values if request.values else None
>   File
> "/usr/local/lib/python3.6/site-packages/werkzeug/datastructures.py",
> line 1409, in __len__
>     return len(self.keys())
> TypeError: object of type 'set_iterator' has no len()
>
> I have pgAdmin4 v4.3
>
> Regards,
>
> Isaias S.
>

Reply | Threaded
Open this post in threaded view
|

Re: Error Exporting to CSV

Khushboo Vashi
Hi,

Also, mention the OS details, Browser details, and the sample query to reproduce this issue.

Thanks,
Khushboo

On Mon, Mar 18, 2019 at 1:57 PM Isaias Sanchez <[hidden email]> wrote:
Hi,

Is this caused by any version of flask or so?

Regards,

Isaias S.

On 14/3/19 12:21, Isaias Sanchez wrote:
>
> Hi,
>
> I am getting error even in Chromium when exporting to CSV it says
> [Object Blob] and  in the log I can see this:
>
> 2019-03-14 12:16:27,375: ERROR  pgadmin:        object of type
> 'set_iterator' has no len()
> Traceback (most recent call last):
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1612, in full_dispatch_request
>     rv = self.dispatch_request()
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1598, in dispatch_request
>     return self.view_functions[rule.endpoint](**req.view_args)
>   File "/usr/local/lib/python3.6/site-packages/flask_login.py", line
> 792, in decorated_view
>     return func(*args, **kwargs)
>   File
> "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/tools/sqleditor/__init__.py",
> line 1350, in start_query_download_tool
>     data = request.values if request.values else None
>   File
> "/usr/local/lib/python3.6/site-packages/werkzeug/datastructures.py",
> line 1409, in __len__
>     return len(self.keys())
> TypeError: object of type 'set_iterator' has no len()
>
> I have pgAdmin4 v4.3
>
> Regards,
>
> Isaias S.
>

Reply | Threaded
Open this post in threaded view
|

Re: Error Exporting to CSV

Isaías Sánchez

Never mind, I reinstalled Flask and pgAdmin4 using pip wheel file and now it works. Probably upgrading pgadmin4 using the python wheel leaves something wrong behind.

The OS was Centos 6, browsers Chromium and Firefox, PgAdmin4 v4.3

Thanks,

Isaias S.

On 18/3/19 8:40, Khushboo Vashi wrote:
Hi,

Also, mention the OS details, Browser details, and the sample query to reproduce this issue.

Thanks,
Khushboo

On Mon, Mar 18, 2019 at 1:57 PM Isaias Sanchez <[hidden email]> wrote:
Hi,

Is this caused by any version of flask or so?

Regards,

Isaias S.

On 14/3/19 12:21, Isaias Sanchez wrote:
>
> Hi,
>
> I am getting error even in Chromium when exporting to CSV it says
> [Object Blob] and  in the log I can see this:
>
> 2019-03-14 12:16:27,375: ERROR  pgadmin:        object of type
> 'set_iterator' has no len()
> Traceback (most recent call last):
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1612, in full_dispatch_request
>     rv = self.dispatch_request()
>   File "/usr/local/lib/python3.6/site-packages/flask/app.py", line
> 1598, in dispatch_request
>     return self.view_functions[rule.endpoint](**req.view_args)
>   File "/usr/local/lib/python3.6/site-packages/flask_login.py", line
> 792, in decorated_view
>     return func(*args, **kwargs)
>   File
> "/usr/local/lib/python3.6/site-packages/pgadmin4/pgadmin/tools/sqleditor/__init__.py",
> line 1350, in start_query_download_tool
>     data = request.values if request.values else None
>   File
> "/usr/local/lib/python3.6/site-packages/werkzeug/datastructures.py",
> line 1409, in __len__
>     return len(self.keys())
> TypeError: object of type 'set_iterator' has no len()
>
> I have pgAdmin4 v4.3
>
> Regards,
>
> Isaias S.
>