Quotes causing issues

  • Resolved rcantwell

    (@rcantwell)


    4 years, 7 months ago

    Hi,

    I have a scheduled task which runs each day at 2 and FTPs a .csv file to a destination. All works great!

    Only thing is that some quotes (both single and double) that appear in one of the fields (Postal address) causes issues in the CRM the .csv is uploaded to?

    I can’t seen anywhere in the settings where i can escape fields – can anyone help?

    Thanks

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

    (@algolplus)

    hi

    Do you want to remove all quotes from the export ?

    can you share sample file which breaks CRM ?
    via https://algolplus.freshdesk.com/

    thanks, Alex

    Thread Starter rcantwell

    (@rcantwell)

    Thanks Alex – i’ve just submitted that ticket there via https://algolplus.freshdesk.com/ – thanks for your help

    Plugin Author algol.plus

    (@algolplus)

    Actually, comma (even inside quotes) breaks import to CRM.

    it’s not the error, but I provided this code ( should be added to “Misc Settings”)

    add_filter("woe_fetch_order_data", function($rows) {
  foreach($rows as $i=>$row)
    foreach($row as $j=>$value)
      $rows[$i][$j] = preg_replace("/[^A-Za-z0-9?![:space:]]/","",$value);
  return $rows;
});
Viewing 3 replies - 1 through 3 (of 3 total)
  • The topic ‘Quotes causing issues’ is closed to new replies.