Problems with CSV Reports

  • Resolved bernard1946

    (@bernard1946)


    5 years, 11 months ago

    I have a number of issues with CSV Report of bookings received.

    1. Report contains a lot of columns that I don’t need to see eg the service is free so I don’t need anything to do with price. I am assuming the first line of the CSV report gives the field names. I have entered all the ones I want to omit from the Report, comma separated, but some of them still appear.
    2. One of the fields I have omitted is “email” and this does not appear except for the last booking made the email address appears under “app_service_1” and all other data is shifted across so that it is under the wrong heading
    3. Report contains 6 columns each containing the date of the appointment but there is no field name at the top so I can’t omit them

Viewing 5 replies - 1 through 5 (of 5 total)
  • Plugin Author codepeople

    (@codepeople)

    5 years, 11 months ago

    Hi,

    Please indicate the version number of the plugin you are using.

    Thank you!

    Thread Starter bernard1946

    (@bernard1946)

    5 years, 11 months ago

    Version 1.2.34

    Plugin Author codepeople

    (@codepeople)

    5 years, 11 months ago

    Hi,

    The form fields have to be excluded using its ID instead its name in the first line. See in the following image how to locate the field IDs:

    https://apphourbooking.dwbooster.com/customdownloads/field-ids-tags-form-builder.png

    Thank you for using the plugin!

    Thread Starter bernard1946

    (@bernard1946)

    5 years, 11 months ago

    If I use the full tag for email (in my case <%email%>) and enter this in the exclusion list, when I Update Changes then the <%email%> disappears from the exclusion list.

    Also I still have 6 columns in my report which show the date of the appointment but they have no header so I have no idea where they are coming from and so I can’t omit them

    I have now updated to v1.2.43

    Plugin Author codepeople

    (@codepeople)

    5 years, 11 months ago

    Hi,

    Don’t use the full tag, use only “email” without the > % < characters.

    Columns with missing header are usually due to fields without title or fields already deleted from the form.

    Thank you for using the plugin!

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

The topic ‘Problems with CSV Reports’ is closed to new replies.