Differences

This shows you the differences between two versions of the page.

--- start [2024/01/11 08:30] – admin
+++ start [2024/01/20 18:38] (current) – admin
@@ Line 269: / Line 269: @@
 __Good afternoon Megan__,
-My name is __Nqophisa Mtshonisi__, an email data consultant from Gradesmatch. At Gradesmatch we produce educational technologies that assist students with career guidance and applying to higher learning institutions. As part of the process, we provide our users with a unique email address that they can access and we notify them via WhatsApp or SMS when a new email is received so they may read it and track it. The domain name we use is @gradesmatch.com, for example, __nqophisam@gradesmatch.com__ could be a version for myself if I were a student.
+My name is __Nqophisa Mtshonisi__, an email _data consultant_ from Gradesmatch. At Gradesmatch we produce educational technologies that assist students with career guidance and applying to higher learning institutions. As part of the process, we provide our users with a unique email address that they can access and we notify them via WhatsApp or SMS when a new email is received so they may read it and track it. The domain name we use is @gradesmatch.com, for example, __nqophisam@gradesmatch.com__ could be a version for myself if I were a student.
 We received an email with the subject "__Provisional Acceptance to study at Nelson Mandela University 2024 - Medical Evaluation and Acceptance of Offer Forms__" from you, however, our technology was unable to allocate the email to the correct learner and thus notify them as it did not have a clear "To" address. I would like to assist with helping you connect with the correct learners with this subject. As mentioned earlier, our email domain is @gradesmatch.com so if you send emails to those learners, you may share it so I may ensure they receive the correct emails and are able to adequately take note or respond to your email.
@@ Line 312: / Line 312: @@
 Search is an array, and you need to find the unique text within the email that differentiates the institution from other communications originating from the From address.
-**AWARD VALUE DOCUMENTATION**
+**MONGO QUERIES FOR FIRM OFFERS**
+Query to find the offers for: VUT, UNIZULU, SPU, SMU, CUT, UFH
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 37,$or: [{ Subject: 'Application Admitted'},{ Subject: 'Application Offered'}]}
+Query for Wits:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 30, Attachments:"UW_AD_UGF0_N.pdf"}
+Query for UP:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A41.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_AT4.PDF/}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 22, Attachments:/_A39.PDF/}
+Query for UWC:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 31, Subject:/Offer to study at UWCCK Ref:/}
+Query for UJ:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 28, $or: [{ Subject: 'Univ. of Johannesburg - Orange Carpet Admitted'},{ Subject: 'University of Johannesburg - Admittance Letter'}]}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Attachments:"PVA014.pdf"}
+Query for NWU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 14, Subject:/Final Acceptance/}
+Query for RU:
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:"Offer Confirmed"}
+  - {CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 17, Attachments:/O1/}
+Query for UFS:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 21, $or: [{ Attachments: 'UV_ADMIT_COV.pdf'},{ Attachments: 'NAS_FINAL.pdf'}]}
+Query for UCT:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 19, Html:/OFFER/}
+Query for SU:
+{CreatedTime: {$gt: ISODate('2024-01-19')},InstitutionId: 12, Subject:"ADMISSIONS COMMUNICATION FROM STELLENBOSCH UNIVERSITY", Attachments:/Offer_Letter_/}
+**In all the queries you'll need to amend the time and institutionId where applicable**