Forwarded to devs [Export lists to CSV extension] It's no longer possible to export the list of domains from the Domains page

[Maarten]

Username:

TITLE

[Export lists to CSV extension] It's no longer possible to export the list of domains from the Domains page

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE

AlmaLinux 8.7
Plesk Obsidian 18.0.50 Update #2
Export lists to CSV extension v1.1.1-6

PROBLEM DESCRIPTION

On the Domains page, it's no longer possible to export the list of domains using the "Export lists to CSV" extension.

STEPS TO REPRODUCE

1. Install the "Export lists to CSV" extension.
2. Go to the "Domains" page in Plesk.
3. There is no option to export the domains to a CSV file.

ACTUAL RESULT

There is no option to export the domains to a CSV file.

EXPECTED RESULT

Being able to export a list of all domains from the Domains page.

ANY ADDITIONAL INFORMATION

(DID NOT ANSWER QUESTION)

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM

Confirm bug

 

[Peter Debik]

Thank you for reporting. I could verify it on 18.0.51 and have forwarded it to developers as [PPS-14127].

 

[Strangelove]

Filed as a Plesk bug - EXTPLESK-4467

In the meanwhile you can use a script as a w/a for Linux:

#!/bin/bash

MYSQL_PASSWORD=`cat /etc/psa/.psa.shadow`
PATH=/sbin:/bin:/usr/sbin:/usr/bin

function mysqlExec(){
    MYSQL_PWD=$MYSQL_PASSWORD mysql -Ns -uadmin -D psa -e "$@"
}

domainList=$(mysqlExec "select name from domains")
echo "Domain;Subscriber;CreationDate;Expires;hostingType" > domains.csv

while read -r dom ; do
    subscriber=$(mysqlExec "select pname from clients cl join domains d where d.cl_id=cl.id and d.name='$dom'")
    hostingType=$(mysqlExec "select htype from domains where name='$dom'")
    if [ "$hostingType" == "vrt_hst" ] ; then
        hostingType="Website"
    else
        if [ "$hostingType" == "std_fwd" ] ; then
            hostingType="Forwarding"
        else
            if [ "$hostingType" == "none" ] ; then
                hostingType="None"
            fi
        fi
    fi
    expiration=$(mysqlExec "select value from Limits l join domains d where l.id=d.id and l.limit_name='expiration' and d.name='$dom'")
    if [ "$expiration" == "-1" ] ; then
        expiration="Never"
    else
        expiration=$(date -d @$expiration)
    fi
    crDate=$(mysqlExec "select cr_date from domains where name='$dom'")
    echo "$dom;$subscriber;$crDate;$expiration;$hostingType" >> domains.csv

done <<< "$domainList"

 

[Maarten]

This issue is fixed in the latest update of the extension:

1.2.0 (05 April 2023)​

• [-] The extension can now again be used with Plesk Obsidian 18.0.44 and later. (EXTPLESK-4467)

 

[Franky H]

Well, trying at this moment v 1.2.0-8 on Versie 18.0.64 on Ubuntu 20.04.6 LTS
and it is no longer working.
Can you please have a look @Maarten ?
Much appreciated.

 

[Maarten]

Well, trying at this moment v 1.2.0-8 on Versie 18.0.64 on Ubuntu 20.04.6 LTS
and it is no longer working.
Can you please have a look @Maarten ?
Much appreciated.

Sorry, I don't use Ubuntu. What exactly doesn't work?

 

[Franky H]

The Icon to activate the export does not show. It used to be next to the 'number of items per page:'

 

[Maarten]

Aha, I see the same on Almalinux.

@Sebahat.hadzhi Can you please reopen this report? The "Export lists to CSV" extension is broken again.

 

[Franky H]

Aha, I see the same on Almalinux.

@Sebahat.hadzhi Can you please reopen this report? The "Export lists to CSV" extension is broken again.

Maybe superfluous : I do not see the icon in any list... where it used to show.

 

[Sebahat.hadzhi]

Thank you for reporting the issue. We are reviewing it. I will update you with more details shortly.

 

[Sebahat.hadzhi]

Hey, everyone. Thank you for reposing the bug. Our team was able to confirm the same reappeared and was identified with ID EXTPLESK-5895. We will introduce a fix in one of the upcoming releases. In the meantime, please use the script originally suggested by Strangelove, we confirmed that the same still works:

Bash:

#!/bin/bash

MYSQL_PASSWORD=`cat /etc/psa/.psa.shadow`
PATH=/sbin:/bin:/usr/sbin:/usr/bin

function mysqlExec(){
    MYSQL_PWD=$MYSQL_PASSWORD mysql -Ns -uadmin -D psa -e "$@"
}

domainList=$(mysqlExec "select name from domains")
echo "Domain;Subscriber;CreationDate;Expires;hostingType" > domains.csv

while read -r dom ; do
    subscriber=$(mysqlExec "select pname from clients cl join domains d where d.cl_id=cl.id and d.name='$dom'")
    hostingType=$(mysqlExec "select htype from domains where name='$dom'")
    if [ "$hostingType" == "vrt_hst" ] ; then
        hostingType="Website"
    else
        if [ "$hostingType" == "std_fwd" ] ; then
            hostingType="Forwarding"
        else
            if [ "$hostingType" == "none" ] ; then
                hostingType="None"
            fi
        fi
    fi
    expiration=$(mysqlExec "select value from Limits l join domains d where l.id=d.id and l.limit_name='expiration' and d.name='$dom'")
    if [ "$expiration" == "-1" ] ; then
        expiration="Never"
    else
        expiration=$(date -d @$expiration)
    fi
    crDate=$(mysqlExec "select cr_date from domains where name='$dom'")
    echo "$dom;$subscriber;$crDate;$expiration;$hostingType" >> domains.csv

done <<< "$domainList"