MJFreeway Pennsylvania
A) Prepare your data.
Note: The file should be in Comma Separated Values (CSV) format.
There should be a header row with column names. The following column names are supported (unknown columns will be ignored):
Field | Notes |
|---|---|
TransactionID | required Unique transaction ID |
Patient Number | required Unique patient ID |
LocationID | Unique location ID |
Item ID | |
Product Name | |
Product Category Name | |
VendorName | |
InventoryQuantity | |
Agg - Product Sales (subtotal) | |
AllocatedTax | |
Product Discount | |
TransactionDate | 2006-01-02 15:04:05 |
Completed Time | |
Patient Postal Code | |
Patient Address | |
Patient Name | |
Patient email | |
Patient Phone Default | |
Patient Gender | |
Patient Age | 2006-01-02 |
Facility Name | Store name |
B) Place the data in a folder in OneDrive. This folder should be at the top level; it should not be inside any other folders.
C) Enable AIQ to see your data.
- In AIQ, go to "Connect data" on the left hand navigation, and then select the "Data Sources" tab on this page.
- Click "Connect" on MJFreeway - Pennsylvania.
- Check the box indicating "All users from this source have passed an age gate compliant with my industry."
- At the bottom of the modal, enter the OneDrive folder name in the box labeld "Folder".
- Click "Update Connection".
- Reopen the modal by clicking "Connect" again.
- Click "Connect Account via OAuth2".
- Follow the prompts to authorize AIQ to import your data.
