RE: pgAdmin Download as CSV

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