search

omnitekinc / AERA_MSS

Bug Tracking
0 stars 0 forks source link

Membership Data #19

Open omnitekinc opened 7 years ago

omnitekinc commented 7 years ago

  1. I noticed the Excel you export for me with no "Expiration Date", has 2917 records. Can you give me an estimate how many records are there total in the membership database?

  2. Can you export another Excel for me with all membership that expired BEFORE 12-31-2011, they are going to go over the database and remove old data. Can you keep the "Source" columns

sagarjagdish commented 7 years ago

I noticed the Excel you export for me with no "Expiration Date", has 2917 records. Can you give me an estimate how many records are there total in the membership database?

total 13379 Records in membership

Can you export another Excel for me with all membership that expired BEFORE 12-31-2011, they are going to go over the database and remove old data. Can you keep the "Source" columns

Please download that file from below URL. expired BEFORE 12-31-2011.xlsx

omnitekinc commented 7 years ago

Sagar, Can you reexport these Excels including the following fields. Mail Code field and Comment field and sort by ID#.

BEFORE 12-31-2011.xlsx Members with no expiration date Excel

sagarjagdish commented 7 years ago

Please find attached updated file.

expired BEFORE 12-31-2011 with mail code.xlsx