Skip to main content

Clear all V-Customer data

Describes steps required to clear customer data. This is required when a customer want to test a functionality before going Live

Be very cautious whilst deleting data.  Measure twice and cut once ​

  1. Get the lease Company Id from DI Admin

  2. Login to Prod Algolia

  3. Go to enquirySearch Index and filter by leaseCompanyId facet

  4. You can now see the list of account Ids associated with this leaseCompanyId. In the facets you can see the enquiries that are sent to accountObjectID and serviceUnitObjectID (there also many other facets)

  5. Select the accountObjectID from the facet

  6. Select a serviceUnitObjectID from the facet

    Now we have a list of enquiries for deletion for a given account and service unit

  7. Login to Prod Firestore

Delete from V-Supplier​

  1. Go to the enquiries list for the given accountObjectId and serviceUnitID /accounts/<accountObjectID>/serviceUnits/<serviceUnitObjectID>/enquiries

  2. Delete the enquiries

Delete from Firestore > enquirySearchIndex​

  1. Go to /algolia/enquirySearchIndex/index

  2. Filter by the leaseCompanyId

  3. Delete unwanted documents

Delete from Firestore > enquiryStatus​

  1. Go to /algolia/enquiryStatus/index

  2. Filter by the leaseCompanyId

  3. Delete unwanted documents

Delete from Firestore > enquiryStatusIndexForVORCheckedInDesc​

  1. Go to /algolia/enquiryStatusIndexForVORCheckedInDesc/index

  2. Filter by the leaseCompanyId

  3. Delete unwanted documents

Delete from Firestore > billings​

  1. Go to /billing/<YYYY>/<month>/enquiries/accepted/

  2. Filter by the leaseId

  3. Delete unwanted documents

  4. Go to /billing/<YYYY>/<month>/enquiries/completed/

  5. Filter by the leaseId

  6. Delete unwanted documents

  7. Go to /billing/<YYYY>/<month>/enquiries/invoiced/

  8. Filter by the leaseId

  9. Delete unwanted documents

  10. Go to /billing/<YYYY>/<month>/enquiries/submitted/

  11. Filter by the leaseId

  12. Delete unwanted documents

  13. From Algolia (step 4), copy ObjectID

Example Yvpasdasal078H4rJ1RdU_f3Wasdad8oOsAr1IEsIrR_5j0bi0xrjpasdasdW9tU0B_J14ERasdasdP3nJ0Y2MYXl

Delete from Algolia > enquiryStatusIndex​

  1. Go to enquiryStatusIndex and search by the copied objectID

  2. Delete the document

Delete from Algolia enquiryStatusIndex_For_VOR_checked_in_desc

  1. Go to enquiryStatusIndex_For_VOR_checked_in_desc and search by the copied objectID

  2. Delete the document

Delete from Algolia > enquirySearch​

  1. Delete the document from enquirySearch index

  2. Repeat step from previous steps

Delete from Algolia > messageQueueIndex​

  1. Go to messageQueueIndex

  2. Apply facet filter for leaseCompanyId

  3. Delete unwanted documents

Delete from Firestore > V-Customer enquiries​

  1. Go to collection path /leasecompany/<leaseCompanyId>/enquiries

  2. Delete unwanted enquiries

Delete from Firestore > V-Customer exports​

  1. Go to collection path /leasecompany/<leaseCompanyId>/exports/yyyy

  2. Delete unwanted documents

        

Status: Accepted
Category: Protected
Authored By: Vishwa on Mar 22, 2023
Revisions
05 Jun, 2024 - Removed Delete from Algolia > userCounterIndex section, VN-11367