Set First 2 Lines with Fixed Data

  • Resolved Simone

    (@seo-freelance)


    7 years, 8 months ago

    Dear AlgolPlus,

    wonderful plugin! I’m using it from long time and I love it!
    I’d like to ask you if it’s possible to set the first 2 lines of the CSV file with Fixed data.

    To be more specific:
    On the 1st line: Columns A,B,G,H,K must have always the same data
    On the 2ns line: all the cells must be blank

    Then On the 3rd line the Column set in the plugin, and starting from the 4th all the export data.

    I do understand it’s a crazy request, but it’s even crazier to see that this courier company has chosen this standart to import data (mad!).

    Thanks a lot for the help
    Bye
    Simone

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author algol.plus

    (@algolplus)

    7 years, 8 months ago

    hi Simone,

    please, put following code to section “Misc Settings”.
    but it won’t modify “Preview”!
    thanks, Alex

    add_action( "woe_before_csv_print_header", function( $file_handle, $headers, $formatter){
 fputcsv($file_handle, array("SAME","SAME","","","","SAME","SAME"));//adjust values
 fputcsv($file_handle, array()); // just empty line 
},10,3);
    Thread Starter Simone

    (@seo-freelance)

    7 years, 8 months ago

    Hi Alex,

    thanks for the quick response!
    I’ve updated the plugin and added the code you gave me (https://i.imgur.com/8OLuxVU.png) but unfortunatelly the output totally ignore these lines.

    What do I wrong?

    Thanks again
    Have a nice day
    Simone

    Plugin Author algol.plus

    (@algolplus)

    7 years, 8 months ago

    hi Simone

    Is format CSV ? The plugin uses XLS by default.

    Do you use button “Export” ( or Export w/o progress) ?

    thanks, Alex

    Thread Starter Simone

    (@seo-freelance)

    7 years, 8 months ago

    Hi Alex,

    it was my fault, I kept selected XLS while this customization was for the CSV one. So everything is working fine! Thanks 🙂

    Plugin Author algol.plus

    (@algolplus)

    7 years, 8 months ago

    you’re welcome.

Viewing 5 replies - 1 through 5 (of 5 total)

The topic ‘Set First 2 Lines with Fixed Data’ is closed to new replies.