Resolved [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)