Extract csv with wrong rows

  • Resolved bobrock4

    (@bobrock4)


    1 year, 1 month ago

    Hi,

    we created forms with an optional text message.

    When we extract records with csv file, many of these messages leaved are going on more than one cell or row and we need to manually normalize the file.

    With many records it could be a bad work.

    Any advice to avoid it?

    Here you have a screenshot from the csv raw file

    Thanks

    • This topic was modified 1 year, 1 month ago by bobrock4.
Viewing 6 replies - 1 through 6 (of 6 total)
  • Plugin Author Arshid

    (@arshidkv12)

    Fill all data from frontend then export CSV and check it.

    Thread Starter bobrock4

    (@bobrock4)

    Hi, what you mean with “fill all data”? Users fill them from the frontend

    Plugin Author Arshid

    (@arshidkv12)

    Fill optional fields also.

    Thread Starter bobrock4

    (@bobrock4)

    Thanks

    I try to fill data and:

    a) I enter in a record (from here)

    b) I find not editable records (see here)

    Plugin Author Arshid

    (@arshidkv12)

    Upload csv to Google sheets and check it (It is comma separated). Or Change delimeter setting from Excel.

    Submit new data from frontend with filling optional field also. Then export CSV from dashboard.

    No editable option in cfdb7. It needs “Edit cfdb7 plugin”

    Thread Starter bobrock4

    (@bobrock4)

    Uploaded on google sheets was the solution

    Many thanks!

Viewing 6 replies - 1 through 6 (of 6 total)
  • The topic ‘Extract csv with wrong rows’ is closed to new replies.