RE: pgAdmin Download as CSV

Lists: pgadmin-support
From: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
To: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: pgAdmin Download as CSV
Date: 2019-03-01 15:18:44
Message-ID: AM0PR10MB26255CB05015DAC61201160899760@AM0PR10MB2625.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Hi,
It seems the Download as CSV button doesn't work anymore for the last few versions. I upgraded from version 3.3 (didn't work here) to version 4.2 and it still doesn't work. It used to work before version 3.3 and downloaded the current query results to the c:\Downloads folder which was very handy. Just to clarify it works for the table list but not for a query results. Not sure if I am doing something wrong?
Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

Woodgate and Clark Limited, Registered Office, The Red House, King Street, West Malling, Kent, ME19 6QT No. 02090698 England.
This message is sent in confidence for the addressee only. It may contain confidential or sensitive information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you.

Our privacy policy is available at www.woodgate-clark.co.uk<https://www.woodgate-clark.co.uk/privacy-policy/>


From: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
To: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin Download as CSV
Date: 2019-03-02 10:07:08
Message-ID: CANxoLDeRg8W6=fsuqGDu+TFzuqyUVv4Jb5iZJAu6cy9TD7vcvg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Hi Elizabeth

I have tried with pgAdmin4 v4.2 and able to download the query result.
Please refer the attached screenshots. Can you please provide following
information:

- Browser and their version
- Any error in browser when click on download button? Please attached
the screenshot.

On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
wrote:

> Hi,
>
> It seems the Download as CSV button doesn’t work anymore for the last few
> versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and
> it still doesn’t work. It used to work before version 3.3 and downloaded
> the current query results to the c:\Downloads folder which was very handy.
> Just to clarify it works for the table list but not for a query results.
> Not sure if I am doing something wrong?
>
> Regards
>
> Ela Mytko
>
> *Woodgate and Clark Limited*
>
>
>
> Tel: 01732 520281
>
> Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk
>
> Web: www.woodgate-clark.co.uk
>
>
> Woodgate and Clark Limited, Registered Office, The Red House, King Street,
> West Malling, Kent, ME19 6QT No. 02090698 England.
> This message is sent in confidence for the addressee only. It may contain
> confidential or sensitive information. The contents are not to be disclosed
> to anyone other than the addressee. Unauthorised recipients are requested
> to preserve this confidentiality and to advise us of any errors in
> transmission. Thank you.
>
> Our privacy policy is available at www.woodgate-clark.co.uk
> <https://www.woodgate-clark.co.uk/privacy-policy/>
>

--
*Akshay Joshi*

*Sr. Software Architect *

*Phone: +91 20-3058-9517Mobile: +91 976-788-8246*

Attachment Content-Type Size
Download_Folder.png image/png 142.8 KB
pgAdmin4.2.png image/png 97.4 KB

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
Cc: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin Download as CSV
Date: 2019-03-02 13:03:23
Message-ID: CAPB4dViDQjRsFkNsa-1QiEQ62=L-6cDqYCKxZ3Ajfucydoeshw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Elizabeth,

You must be doing something wrong, or else your computer has an incorrect
configuration of some sort.

I'm importing and exporting from/to CSV several times a day, and it has
generally always worked (exceptions are cases where the CSV file to be
imported contains e.g. non-UTF8 characters).

I run any select query and then press the download icon - and the query
result downloads with a file name like "data_xxxxxxxx.csv" where xxxxx is
some random number. Using windows 10-64, latest Chrome

Regards
Calle

On Sat, 2 Mar 2019 at 11:07, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
wrote:

> Hi Elizabeth
>
> I have tried with pgAdmin4 v4.2 and able to download the query result.
> Please refer the attached screenshots. Can you please provide following
> information:
>
> - Browser and their version
> - Any error in browser when click on download button? Please attached
> the screenshot.
>
>
> On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <
> E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk> wrote:
>
>> Hi,
>>
>> It seems the Download as CSV button doesn’t work anymore for the last few
>> versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and
>> it still doesn’t work. It used to work before version 3.3 and downloaded
>> the current query results to the c:\Downloads folder which was very handy.
>> Just to clarify it works for the table list but not for a query results.
>> Not sure if I am doing something wrong?
>>
>> Regards
>>
>> Ela Mytko
>>
>> *Woodgate and Clark Limited*
>>
>>
>>
>> Tel: 01732 520281
>>
>> Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk
>>
>> Web: www.woodgate-clark.co.uk
>>
>>
>> Woodgate and Clark Limited, Registered Office, The Red House, King
>> Street, West Malling, Kent, ME19 6QT No. 02090698 England.
>> This message is sent in confidence for the addressee only. It may contain
>> confidential or sensitive information. The contents are not to be disclosed
>> to anyone other than the addressee. Unauthorised recipients are requested
>> to preserve this confidentiality and to advise us of any errors in
>> transmission. Thank you.
>>
>> Our privacy policy is available at www.woodgate-clark.co.uk
>> <https://www.woodgate-clark.co.uk/privacy-policy/>
>>
>
>
> --
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *Phone: +91 20-3058-9517Mobile: +91 976-788-8246*
>

--

*Carl-Anders (Calle) Hedberg*

HISP

Researcher & Technical Specialist

Health Information Systems Programme – South Africa

Cell: +47 41461011 (Norway)

Iridium SatPhone: +8816-315-19119 (usually OFF)

E-mail1: calle(at)hisp(dot)org

E-mail2: calle(dot)hedberg(at)gmail(dot)com

Skype: calle_hedberg


From: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
To: "calle(dot)hedberg(at)gmail(dot)com" <calle(dot)hedberg(at)gmail(dot)com>, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>, Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>
Cc: "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: RE: pgAdmin Download as CSV
Date: 2019-03-04 14:40:52
Message-ID: AM0PR10MB2625D43407F7363ABB39F48599710@AM0PR10MB2625.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Hi,

Thank you all for your replies. I am using 64-bit Windows 10 and Microsoft Edge browser. I have done some more tests and came into conclusion the download button only works when I use less than 4 aliases in the query. If there are more then 4 aliases in the query the button won’t work. I enclose the example of a simple query, it doesn’t matter which aliases of the 5 below I use but it will only accept 3 aliases. Hope that makes sense.

SELECT ins.insurer,
ib.branch,
ib.ins_br_index,
fe.invoice_total,
fe.fee_date,
fe.unpaid_amount,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) <= '30 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c30,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '31 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '60 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c60,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '61 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '90 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c90,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '91 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) > '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120plus
FROM fee fe,
claim cl,
insurer ins,
insurerbranch ib
WHERE cl.claim_ref::text = fe.claim_ref::text AND ib.ins_br_index = cl.ins_br_index AND ins.ins_index = ib.ins_index AND fe.fee_type = 'I'::bpchar AND fe.fee_status = 1
And ins.ins_index=82
ORDER BY ib.ins_br_index;

Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
Sent: 02 March 2019 13:03
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
Cc: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>; pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: pgAdmin Download as CSV

Elizabeth,

You must be doing something wrong, or else your computer has an incorrect configuration of some sort.

I'm importing and exporting from/to CSV several times a day, and it has generally always worked (exceptions are cases where the CSV file to be imported contains e.g. non-UTF8 characters).

I run any select query and then press the download icon - and the query result downloads with a file name like "data_xxxxxxxx.csv" where xxxxx is some random number. Using windows 10-64, latest Chrome

Regards
Calle

On Sat, 2 Mar 2019 at 11:07, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>> wrote:
Hi Elizabeth

I have tried with pgAdmin4 v4.2 and able to download the query result. Please refer the attached screenshots. Can you please provide following information:

* Browser and their version
* Any error in browser when click on download button? Please attached the screenshot.

On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk<mailto:E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>> wrote:
Hi,
It seems the Download as CSV button doesn’t work anymore for the last few versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and it still doesn’t work. It used to work before version 3.3 and downloaded the current query results to the c:\Downloads folder which was very handy. Just to clarify it works for the table list but not for a query results. Not sure if I am doing something wrong?
Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

Woodgate and Clark Limited, Registered Office, The Red House, King Street, West Malling, Kent, ME19 6QT No. 02090698 England.
This message is sent in confidence for the addressee only. It may contain confidential or sensitive information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you.

Our privacy policy is available at www.woodgate-clark.co.uk<https://www.woodgate-clark.co.uk/privacy-policy/>

--
Akshay Joshi
Sr. Software Architect

[Image removed by sender.]

Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

--

Carl-Anders (Calle) Hedberg

HISP

Researcher & Technical Specialist

Health Information Systems Programme – South Africa

Cell: +47 41461011 (Norway)

Iridium SatPhone: +8816-315-19119 (usually OFF)

E-mail1: calle(at)hisp(dot)org<mailto:calle(at)hisp(dot)org>

E-mail2: calle(dot)hedberg(at)gmail(dot)com<mailto:calle(dot)hedberg(at)gmail(dot)com>

Skype: calle_hedberg


From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
To: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
Cc: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>, Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin Download as CSV
Date: 2019-03-04 15:03:24
Message-ID: CAPB4dViLt+zjn=DwwGTmdrRnNtcPRqXtyC8Vm4NX_txLfVU+AQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Elizabeth,

I just tested a query with six aliases (using win10-64 and latest Chrome) -
and it downloads without problems.

So the prime suspect would be your browser - why don't you try Chrome or
Firefox instead, to see if there's a difference?

Regards
Calle

On Mon, 4 Mar 2019 at 15:40, Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
wrote:

> Hi,
>
>
>
> Thank you all for your replies. I am using 64-bit Windows 10 and Microsoft
> Edge browser. I have done some more tests and came into conclusion the
> download button only works when I use less than 4 aliases in the query. If
> there are more then 4 aliases in the query the button won’t work. I enclose
> the example of a simple query, it doesn’t matter which aliases of the 5
> below I use but it will only accept 3 aliases. Hope that makes sense.
>
>
>
> SELECT ins.insurer,
>
> ib.branch,
>
> ib.ins_br_index,
>
> fe.invoice_total,
>
> fe.fee_date,
>
> fe.unpaid_amount,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) <= '30 days'::interval THEN fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c30,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '31 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '60 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c60,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '61 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '90 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c90,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) >= '91 days'::interval AND ('now'::text::date::timestamp
> without time zone - fe.fee_date) <= '120 days'::interval THEN
> fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c120,
>
> CASE
>
> WHEN ('now'::text::date::timestamp without time zone -
> fe.fee_date) > '120 days'::interval THEN fe.unpaid_amount
>
> ELSE 0::numeric
>
> END AS c120plus
>
> FROM fee fe,
>
> claim cl,
>
> insurer ins,
>
> insurerbranch ib
>
> WHERE cl.claim_ref::text = fe.claim_ref::text AND ib.ins_br_index =
> cl.ins_br_index AND ins.ins_index = ib.ins_index AND fe.fee_type =
> 'I'::bpchar AND fe.fee_status = 1
>
> And ins.ins_index=82
>
> ORDER BY ib.ins_br_index;
>
>
>
> Regards
>
> Ela Mytko
>
> *Woodgate and Clark Limited*
>
>
>
> Tel: 01732 520281
>
> Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk
>
> Web: www.woodgate-clark.co.uk
>
>
>
> *From:* Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
> *Sent:* 02 March 2019 13:03
> *To:* Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> *Cc:* Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>;
> pgadmin-support(at)lists(dot)postgresql(dot)org
> *Subject:* Re: pgAdmin Download as CSV
>
>
>
> Elizabeth,
>
>
>
> You must be doing something wrong, or else your computer has an incorrect
> configuration of some sort.
>
>
>
> I'm importing and exporting from/to CSV several times a day, and it has
> generally always worked (exceptions are cases where the CSV file to be
> imported contains e.g. non-UTF8 characters).
>
>
>
> I run any select query and then press the download icon - and the query
> result downloads with a file name like "data_xxxxxxxx.csv" where xxxxx is
> some random number. Using windows 10-64, latest Chrome
>
>
>
> Regards
>
> Calle
>
>
>
> On Sat, 2 Mar 2019 at 11:07, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>
> wrote:
>
> Hi Elizabeth
>
>
>
> I have tried with pgAdmin4 v4.2 and able to download the query result.
> Please refer the attached screenshots. Can you please provide following
> information:
>
> - Browser and their version
> - Any error in browser when click on download button? Please attached
> the screenshot.
>
>
>
> On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <
> E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk> wrote:
>
> Hi,
>
> It seems the Download as CSV button doesn’t work anymore for the last few
> versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and
> it still doesn’t work. It used to work before version 3.3 and downloaded
> the current query results to the c:\Downloads folder which was very handy.
> Just to clarify it works for the table list but not for a query results.
> Not sure if I am doing something wrong?
>
> Regards
>
> Ela Mytko
>
> *Woodgate and Clark Limited*
>
>
>
> Tel: 01732 520281
>
> Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk
>
> Web: www.woodgate-clark.co.uk
>
>
>
> Woodgate and Clark Limited, Registered Office, The Red House, King Street,
> West Malling, Kent, ME19 6QT No. 02090698 England.
> This message is sent in confidence for the addressee only. It may contain
> confidential or sensitive information. The contents are not to be disclosed
> to anyone other than the addressee. Unauthorised recipients are requested
> to preserve this confidentiality and to advise us of any errors in
> transmission. Thank you.
>
> Our privacy policy is available at www.woodgate-clark.co.uk
> <https://www.woodgate-clark.co.uk/privacy-policy/>
>
>
>
>
> --
>
> *Akshay Joshi*
>
> *Sr. Software Architect *
>
>
>
> *[image: Image removed by sender.]*
>
>
>
>
> *Phone: +91 20-3058-9517 Mobile: +91 976-788-8246*
>
>
>
>
> --
>
> *Carl-Anders (Calle) Hedberg*
>
> HISP
>
> Researcher & Technical Specialist
>
> Health Information Systems Programme – South Africa
>
> Cell: +47 41461011 (Norway)
>
> Iridium SatPhone: +8816-315-19119 (usually OFF)
>
> E-mail1: calle(at)hisp(dot)org
>
> E-mail2: calle(dot)hedberg(at)gmail(dot)com
>
> Skype: calle_hedberg
>

--

*Carl-Anders (Calle) Hedberg*

HISP

Researcher & Technical Specialist

Health Information Systems Programme – South Africa

Cell: +47 41461011 (Norway)

Iridium SatPhone: +8816-315-19119 (usually OFF)

E-mail1: calle(at)hisp(dot)org

E-mail2: calle(dot)hedberg(at)gmail(dot)com

Skype: calle_hedberg


From: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
To: "calle(dot)hedberg(at)gmail(dot)com" <calle(dot)hedberg(at)gmail(dot)com>
Cc: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>, Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>, "pgadmin-support(at)lists(dot)postgresql(dot)org" <pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: RE: pgAdmin Download as CSV
Date: 2019-03-05 12:14:49
Message-ID: AM0PR10MB26254202B9DDBFBD2FD73B4699720@AM0PR10MB2625.EURPRD10.PROD.OUTLOOK.COM
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgadmin-support

Hi Calle,

I tried Chrome and it works fine so it must be a browser to blame.
Thank you for your help.

Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com>
Sent: 04 March 2019 15:03
To: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>
Cc: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com>; Guy Rouillier <guy(dot)rouillier(at)gmail(dot)com>; pgadmin-support(at)lists(dot)postgresql(dot)org
Subject: Re: pgAdmin Download as CSV

Elizabeth,

I just tested a query with six aliases (using win10-64 and latest Chrome) - and it downloads without problems.

So the prime suspect would be your browser - why don't you try Chrome or Firefox instead, to see if there's a difference?

Regards
Calle

On Mon, 4 Mar 2019 at 15:40, Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk<mailto:E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>> wrote:
Hi,

Thank you all for your replies. I am using 64-bit Windows 10 and Microsoft Edge browser. I have done some more tests and came into conclusion the download button only works when I use less than 4 aliases in the query. If there are more then 4 aliases in the query the button won’t work. I enclose the example of a simple query, it doesn’t matter which aliases of the 5 below I use but it will only accept 3 aliases. Hope that makes sense.

SELECT ins.insurer,
ib.branch,
ib.ins_br_index,
fe.invoice_total,
fe.fee_date,
fe.unpaid_amount,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) <= '30 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c30,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '31 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '60 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c60,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '61 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '90 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c90,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) >= '91 days'::interval AND ('now'::text::date::timestamp without time zone - fe.fee_date) <= '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120,
CASE
WHEN ('now'::text::date::timestamp without time zone - fe.fee_date) > '120 days'::interval THEN fe.unpaid_amount
ELSE 0::numeric
END AS c120plus
FROM fee fe,
claim cl,
insurer ins,
insurerbranch ib
WHERE cl.claim_ref::text = fe.claim_ref::text AND ib.ins_br_index = cl.ins_br_index AND ins.ins_index = ib.ins_index AND fe.fee_type = 'I'::bpchar AND fe.fee_status = 1
And ins.ins_index=82
ORDER BY ib.ins_br_index;

Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

From: Calle Hedberg <calle(dot)hedberg(at)gmail(dot)com<mailto:calle(dot)hedberg(at)gmail(dot)com>>
Sent: 02 March 2019 13:03
To: Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>>
Cc: Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk<mailto:E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>>; pgadmin-support(at)lists(dot)postgresql(dot)org<mailto:pgadmin-support(at)lists(dot)postgresql(dot)org>
Subject: Re: pgAdmin Download as CSV

Elizabeth,

You must be doing something wrong, or else your computer has an incorrect configuration of some sort.

I'm importing and exporting from/to CSV several times a day, and it has generally always worked (exceptions are cases where the CSV file to be imported contains e.g. non-UTF8 characters).

I run any select query and then press the download icon - and the query result downloads with a file name like "data_xxxxxxxx.csv" where xxxxx is some random number. Using windows 10-64, latest Chrome

Regards
Calle

On Sat, 2 Mar 2019 at 11:07, Akshay Joshi <akshay(dot)joshi(at)enterprisedb(dot)com<mailto:akshay(dot)joshi(at)enterprisedb(dot)com>> wrote:
Hi Elizabeth

I have tried with pgAdmin4 v4.2 and able to download the query result. Please refer the attached screenshots. Can you please provide following information:

* Browser and their version
* Any error in browser when click on download button? Please attached the screenshot.

On Sat, Mar 2, 2019 at 6:06 AM Elizabeth Mytko <E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk<mailto:E(dot)Mytko(at)woodgate-clark(dot)co(dot)uk>> wrote:
Hi,
It seems the Download as CSV button doesn’t work anymore for the last few versions. I upgraded from version 3.3 (didn’t work here) to version 4.2 and it still doesn’t work. It used to work before version 3.3 and downloaded the current query results to the c:\Downloads folder which was very handy. Just to clarify it works for the table list but not for a query results. Not sure if I am doing something wrong?
Regards
Ela Mytko
Woodgate and Clark Limited

Tel: 01732 520281
Email: e(dot)mytko(at)woodgate-clark(dot)co(dot)uk<mailto:e(dot)mytko(at)woodgate-clark(dot)co(dot)uk>
Web: www.woodgate-clark.co.uk<http://www.woodgate-clark.co.uk/>

Woodgate and Clark Limited, Registered Office, The Red House, King Street, West Malling, Kent, ME19 6QT No. 02090698 England.
This message is sent in confidence for the addressee only. It may contain confidential or sensitive information. The contents are not to be disclosed to anyone other than the addressee. Unauthorised recipients are requested to preserve this confidentiality and to advise us of any errors in transmission. Thank you.

Our privacy policy is available at www.woodgate-clark.co.uk<https://www.woodgate-clark.co.uk/privacy-policy/>

--
Akshay Joshi
Sr. Software Architect

[Image removed by sender.]

Phone: +91 20-3058-9517
Mobile: +91 976-788-8246

--

Carl-Anders (Calle) Hedberg

HISP

Researcher & Technical Specialist

Health Information Systems Programme – South Africa

Cell: +47 41461011 (Norway)

Iridium SatPhone: +8816-315-19119 (usually OFF)

E-mail1: calle(at)hisp(dot)org<mailto:calle(at)hisp(dot)org>

E-mail2: calle(dot)hedberg(at)gmail(dot)com<mailto:calle(dot)hedberg(at)gmail(dot)com>

Skype: calle_hedberg

--

Carl-Anders (Calle) Hedberg

HISP

Researcher & Technical Specialist

Health Information Systems Programme – South Africa

Cell: +47 41461011 (Norway)

Iridium SatPhone: +8816-315-19119 (usually OFF)

E-mail1: calle(at)hisp(dot)org<mailto:calle(at)hisp(dot)org>

E-mail2: calle(dot)hedberg(at)gmail(dot)com<mailto:calle(dot)hedberg(at)gmail(dot)com>

Skype: calle_hedberg