Assistance with Views Data Export

Request Type:

Office Hours

Forums:

Author:

Erin Johnson

Issue/Request:

Hello,

I set up a Data Export view for my events calendar but for some reason the entries in my final excel file are duplicated. I’m not sure if this is an issue in how I have the filters set but I’ve tried a few options (on the Drupal side as well as the Excel side) and think I’ll need some help getting to the bottom of it.

My end goal is to export the calendar data in aggregate so that I can sort and analyze it. I’m happy to discuss in office hours if that is easier.

Thanks!

Alan Scrimenti on March 29, 2017:

Hi Erin,

My name is Alan and I will be helping you with this forum issue. I will contact you as soon as I have more information.

Best Regards,

Alan Scrimenti

Alan Scrimenti on March 31, 2017:

Hi Erin,

The Tag:delta value in the Field list is causing the duplicates. So there will be one record output for each Tag value you have checked. If you have 3 tags checked, it will be written out 3 times.

Content: Tags:delta (Tags (field_calendar_tags:delta))

Removing the Tags:delta field from your output should eliminate the duplicates.

Please let me know if this resolves the issue.

Thanks,

Alan