Chapter 9: Data Manipulation

9.1 Data Manipulation

Data Manipulation Module serve to help users to manipulate on the data collected by FootfallCam People Counter which users think maybe inaccurate. The changes made to the data will be permanently overview in database and data displayed in related report will be affected. The data can be reverted back to the original data collected from the FootfallCam People Count if necessary.

 

9.1.1 Automate Data Manipulation

Note

Data for the chosen date(s) will be manipulated based on the data from last three weeks on the same day.

STEP 1 - Click on Maintenance > Data Manipulation to access Data Manipulation Page.

STEP 2 - Entering all the required fields and click on Preview button.

STEP 3 - Complete the process by click on Apply and agree with the T&C(s).

Item Description
1. Patch Selection Select the Auto as the patch selection type.
2. Patch Level Select the data patching level either at site or counter level.
3. Site / Counter Site: Select the site of which data to be manipulated.
  Counter: Select the counter of which data to be manipulated.
4. Date Range Select the date range of which data to be manipulated.
5. Metric Level Select the metric aggregated level.
8. Metric Select the metric data to be manipulated.

9.1.2 Manual Data Manipulation

Note

Data for the chosen date(s) will be manipulated based on numerical figures manually inputted by the user

Edited data will be appeared as RED colour.

STEP 1 - Entering all the required fields and click on Preview button.

STEP 2 - Complete the process by click on Apply and agree with the T&C(s).

Item Description
1. Patch Selection Select the Manual as the patch selection type.
2. Patch Level Select the data patching level either at site or counter level.
3. Site / Counter Site: Select the site of which data to be manipulated.
  Counter: Select the counter of which data to be manipulated.
4. Date Range Select the date range of which data to be manipulated.
5. Metric Level Select the metric aggregated level.
6. Metric Select the metric to be manipulated.

9.1.3 Manual Data Manipulation

Note

Data for the chosen date(s) will be reverted to the original data observed by FootfallCam Counter(s).

STEP 1 - Select either Patch Selection and fill in all the fields based on the data to be manipulated.

STEP 2 - Click Preview and data to be manipulated with site details will be displayed.

STEP 3 - Complete the process by click on Reset and agree with the T&C(s).

9.2 Manual Occupancy

Item Description
1. Branch List of branches which the user is allowed access to.
2. Area List of areas which belongs to the branch.
3. Occupancy Type Type of occupancy to adjust.
4. Value Value you want the occupancy to be adjusted to.
5. Set Occupancy Click on this button to adjust the occupancy.

9.2.1 Set Manual Occupancy

STEP 1 - Locate the branch/area that you want to adjust the occupancy.

STEP 2 - Choose correct Occupancy Type to adjust.

STEP 3 - Enter the Value you want to adjust to.

STEP 4 - Click on the "Set Occupancy" button. 

9.2.2 Manual Occupancy API Integration

Manual Occupancy API can be used to update areas' or branches' occupancy by only calling the api itself. 

Item Description
1. URL {AnalyticManagerURL}/Occupancy/AddGroundTruthManualOccupancy
2. Payload

{
       "DataLevel": If Branch then 2, if Area then 3,
       "DataID": If DataLevel is BranchId then pass BranchId, if DataLevel is Area then pass AreaId, (for BranchId can get from Site > Click the branch > get BranchId from the URL, while AreaId can get from Area> Click the area > get AreaId from the URL)
       "Value": Value that wanted to set,
       "peopleType": Customer = 1, Staff = 2, VisitorOnly = 3, Car = 100,
       "BranchItBelongsTo": BranchId
}

Sample :
{
       "DataLevel": 2,
       "DataID": 123,
       "Value": 12,
       "peopleType": 3,
       "BranchItBelongsTo": 123
}

3. Method POST
4. Header "AToken": Please right click any page in portal and Inspect > Application > under Local Storage, find AToken and paste into here

Updated on November 3, 2022