Excel file from listings

[Ikky]

Well, as we all know, 68C has a function to make an excel file of all the users (members) with their information in the admin side. I wanted to know if there's a similar function for all listings or if someone is developing this.

[Eric Barnes]

Currently it does not have this as an option. However it should not be to hard to build. If you know a little php.

PHP Code:

<?php
require_once('includes/init.php');
require_once(FILESYSTEM_PATH .'includes/classes/kernel/Pagination.php');

    require_once('../includes/classes/kernel/Listings.php');
    $Listings= new Listings;
        
        $options = '';
        $list=$Listings->getAllListings($options, 1, '9999');
        $i=0;
        $headings='';
        foreach ($list['list'][0] as $key => $value) {
            $headings.= $key.",";
            $i++;
        }
        $csvoutput = rtrim($headings, ', ');
        $csvoutput .= "\n";
        //now the users
        $i=1;
        $next=0;
        $users='';
        foreach ($list['list'] as $v1) {
            foreach ($v1 as $key => $value) {
                $users .= $value.',';
                $next++;
            }
            $users = rtrim($users, ',');
            $users .= "\n";
            $next=0;
            $i++;
        }
        $csvoutput .= $users;
        
    header ( "Content-Type: application/force-download" );
    header ( "Content-Type: application/octet-stream" );
    header ( "Content-Type: application/download" );
    header ( "Content-Type: text/csv" );
    header ( "Content-Disposition: attachment; filename=listings.csv");
    header ( "Content-Transfer-Encoding: binary" );
    header ( "Accept-Ranges: bytes" );
    header ( "Content-Length: ".strlen ( $csvoutput ) );
    echo $csvoutput;

Save that as export_listings.php and upload to your administration directory.