On March 26, 2019 we launched new MODX Forums. Please join us at the new MODX Community Forums.
MODX Forums
View Latest Posts

or Search:

Answered Formit Export: Convert JSON to Columns?

Subscribe: RSS
  • Ben M Reply #1, 10 months, 3 weeks ago
    I remember when I used FormSave and any exports placed each form field into it's own column in a CSV spreadsheet. Formit seems to just use JSON strings (I think), and it is REALLY annoying. Is there a way to fix this? Maybe a script or something in Excel/LibreOffice or a modification of the extra? It's really driving my client's marketer nuts, and FormSave is no longer stable.

    This question has been answered by lkfranklin. See the first response.

    • discuss.answer
      LK Reply #2, 10 months, 3 weeks ago
      Google docs or excel should let you open or import the csv and set the separator value to format it in a readable format. Google docs detects automatically I believe, not so sure about excel been a while since I used that.
        ■ email: lk@alienbuild.uk | ■ website: https://alienbuild.uk

        The greatest compliment you can give back to us, is to spend a few seconds leaving a rating at our trustpilot: https://uk.trustpilot.com/review/alienbuild.uk about the service we provided. We always drop mention of services offered by businesses we've worked with in the past to those of interest.
      • Ben M Reply #3, 10 months, 3 weeks ago
        Quote from: lkfranklin at Jan 16, 2019, 12:23 PM
        Google docs or excel should let you open or import the csv and set the separator value to format it in a readable format. Google docs detects automatically I believe, not so sure about excel been a while since I used that.

        Thank you! It was just some settings in LibreOffice. You rock!
        • jasper052 Reply #4, 10 months ago
          I am not sure this question is solved already or not, but let me paste what I have done for reference. First, your JSON has nested objects prepaidgiftbalance