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

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.

Hi Dave,

Thanks so much. Now it is clear.

Thanks again.

Have a nice day.

在 2019-03-13 17:12:33，"Dave Page" <dpage@pgadmin.org> 写道：

Hi

On Wed, Mar 13, 2019 at 9:05 AM vanbell <vanbell@126.com> 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

 

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

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.

Hi,

Please log this issue @ https://redmine.postgresql.org/projects/pgadmin4

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 <isaias.sanchez.l@gmail.com> 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.
>