Stoton

Thanks for your reply. Yes we have around 5K+ orders.

No worries, I’ll submit the ticket. Thanks again.

Thanks very much @algolplus

That filter did the trick, I have it working now.

Here’s an example in case it can help someone else.

add_action( 'woe_xls_print_footer', function ( $objXls, $formatter ) {

    $custom_format = array(
        'font' => array(
            'bold' => true,
        ),
        'alignment' => array(
            'horizontal' => PHPExcel_Style_Alignment::HORIZONTAL_LEFT,
        ),
        'borders' => array(
            'allborders' => array(
              'style' => PHPExcel_Style_Border::BORDER_THIN,
              'color' => array( 'rgb' => 'BBBBBB' ),
            )
        ),
        'fill' => array(
            'type' => PHPExcel_Style_Fill::FILL_SOLID,
            'color' => array('rgb' => 'F28A8C' ),
        ),
    );

    $formatter->objPHPExcel->getActiveSheet()->getStyle('B3:B7')->applyFromArray( $custom_format );

} ,10, 2); 

No worries, ticket has been opened.

Yes they do. How can I send it to you?

Hi Alex, I tried importing the plugin generated CSV with ‘Force enclosure for all values’ checked. Below is the response from AusPost. Just to clarify the settings I am using do not have any custom php added through ‘Misc settings’. When I open the CSV all headers are present.

Error message:

Error file log
Row 1
Oops! Looks like your CSV file is missing column names. Please include all column names and try again.

Hi Alex, yeah I forgot to mention. AusPost does not accept the CSV generated by the plugin. I’ve always had to resave it from excel. I’ll try your suggestion and get back to you. Thanks again.

I’ve had to download an XLS instead of CSV, so I’m now using this filter to change the headers.

‘woe_xls_header_filter’

Thanks @algolplus for the link. It can be hard to know if any given postcode is meant to start with a zero so I wanted to avoid editing individual postcodes in the CSV, as this would just require researching suburbs and postcodes.

Yes i did come to learn that this was an excel issue rather than the CSV itself.

In any case I have found a workaround. First I save the file as an XLS instead of CSV. Once downloaded I open the XLS and resave it as CSV, this way the zero seems to sort of carry over… sort of because when I open the CSV there is no leading zero, but when I upload the CSV to AusPost it imports correctly and displays the zero. Very strange but it works…thanks again.

Sorry please delete this, i accidentally posted it in the wrong place.

Thanks @algolplus

Its all good, this is working ok for my purposes.

Thanks very much @algol.plus

That did the trick, though i had to change all headers. Finally no more copy / pasting…:)

Thanks again.

Thanks @zorem,

I see it now, not sure how I missed it. Thanks again, all good.

@wp_media Thanks, look forward to the update.

@michaelbourne No worries. Its good advice you give regarding having a staging site, this is something we have been doing with WordPress for years. Its a big advantage.

@michaelbourne Thanks mate, I have added the CSS to my theme and the cover block is working now. I have noticed that the “object-position” property that is set in the block settings is not being reflected currently. Lets hope Imagify can release an update to fix all the issues.

Thanks again for your help.

Hi Support,

Do you have any update on this issue? The cover block is not working with the latest WordPress 5.7 version.

Thanks