Filter Order Export Values on orderslist (and others)

We're shifting our Forum based support to a more dedicated support system!

We'll be closing our Forum support from 10th June, 2020 and move to Email Support assistance.

  • If you are a WCFM premium add-ons user, contact us- here
  • Want to know more before buying our add-ons? Send Pre sale queries- here
  • If you are a WCFM free user, please open a support ticket at WordPress.org
  • For WCFM App related queries, reach us- here
From now the forum will be read-only!

Multi Vendor Marketplace Plugin | WCFM Marketplace › Forums › WCFM – Marketplace (WooCommerce Multivendor Marketplace) › Filter Order Export Values on orderslist (and others)

Viewing 7 reply threads
  • Author
    Posts
    • March 20, 2020 at 11:45 pm #112453
      john.kaufmann
      Participant

      Hello there, on this page (and any other that has export functionality): https://my-wordpress-site.com/store-manager/orderslist/ , I would like to be able to disable special characters from being exported.

      Such as:
      Equals to (“=”)
      Plus (“+”)
      Minus (“-“)
      At (“@”)

      Right now they can be exported, which is messing up my excel sheet in certain circumstances.

      See attachment for an example. Any idea how to mitigate this?

      Attachments:
      You must be logged in to view attached files.
    • March 31, 2020 at 11:30 pm #114366
      john.kaufmann
      Participant

      Any update on this?

    • April 3, 2020 at 10:03 am #114993
      WCFM Forum
      Keymaster

      https://wclovers.com/wp-content/uploads/2020/03/Screen-Shot-2020-03-20-at-1.14.36-PM.png

      – Is this a valid address?

      Thank You

    • April 3, 2020 at 7:32 pm #115115
      john.kaufmann
      Participant

      Yes it is. This is possible in the current system

    • April 4, 2020 at 1:48 pm #115287
      WCFM Forum
      Keymaster

      OK, if this is valid address then why you want to remove characters from this? After that it will become invalid, right?

    • April 6, 2020 at 9:16 pm #115997
      john.kaufmann
      Participant

      Ah okay, I see what you’re saying. My apologies. The address that is listed is able to be submitted through the system making it valid. The problem is when exported to excel, it is interpreted as a command and will run on opening excel.

      If you could help me understand how to filter those values out, or not allow them as addresses in the first place. That would be very helpful. Thank you in advance!

    • April 12, 2020 at 12:24 pm #118320
      WCFM Forum
      Keymaster

      The problem is when exported to excel, it is interpreted as a command and will run on opening excel.

      – Well, this is only because of Excel setting. Disable command execute option, this will open properly.

      Thank You

    • April 13, 2020 at 7:53 pm #118782
      john.kaufmann
      Participant

      I know, but I am running a multi-vendor store. So am I expected to tell all of my vendors they have to disable an excel setting before exporting? That seems unreasonable and prone to error. What if that command is something malicious?

      Are there no quick fixes to this problem?

  • Author
    Posts
Viewing 7 reply threads
  • You must be logged in to reply to this topic.