Custom CSV

[ncadjan]

This is the information that Tricia needs.

[ncadjan]

Mockup.xlsx

[ncadjan]

This doesn't include how we want to do the M2M connections. I don't know if this can be in the same report or if it has to be a separate .CSV

[beck24]

Looking at this now - I may be mis-remembering but I thought the csv export was for event membership. The reason it couldn't work in MIRG was because they wanted the user to have a separate row for each event, but I don't see any event identifier or anything in this mockup. Am I remembering wrong or what?

[ncadjan]

Let me get home and I'll look. I added a xls to the ticket on member reporting.

Get Outlook for iOShttps://aka.ms/o0ukef

---

From: Matt Beckett notifications@github.com Sent: Monday, April 10, 2017 2:23:00 PM To: arckinteractive/en-issues Cc: Nancy Cadjan; Author Subject: Re: [arckinteractive/en-issues] Custom CSV (#35)

Looking at this now - I may be mis-remembering but I thought the csv export was for event membership. The reason it couldn't work in MIRG was because they wanted the user to have a separate row for each event, but I don't see any event identifier or anything in this mockup. Am I remembering wrong or what?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://github.com/arckinteractive/en-issues/issues/35#issuecomment-293067608, or mute the threadhttps://github.com/notifications/unsubscribe-auth/AYlRpd5HPegm9WUszgRm4A2wPtLan63wks5ruo-kgaJpZM4M2YC5.

[ncadjan]

Matt, we need the attached fields, some of them being the Member 2 Member connections. When I had originally worked on this with Tricia, we thought it could all go into the one CSV file. But, I think you are telling me that we need two. Yes? Can we talk for 5 mins?

[ncadjan]

OK. Let me clarify again in my head: 1> The attached is the information Tricia needs. 2> We originally thought M2M could be pulled into this report. Seems like we can't get it into this report. 3> Can we make make the report attached for everything except M2M and then make a separate CSV for that data with as close as possible same structure as this file (same Member Info columns such as First Name, Last Name, Network, End Date, etc)

[beck24]

I'm available for the next 4 hours if you want to chat. I've paused work pending Paul getting an hours update.

[ncadjan]

In the M2M CSV, is it possible to list First Name Last Name instead of "For"? This is how Tricia's reports are sorted.

[ncadjan]

Member 2 Member CSV is missing the Completed Dates.

[ncadjan]

BTW: The Event report takes 30 minutes to load. Lots of data. I sent it to Tricia to review.

[beck24]

Yeah that's why I put that note on there that it could take a while. It's essentially churning through a good chunk of the database to get all the information. It's a big one.