How to import a sales transaction log

Setting an occupancy threshold for a location

Table of Contents

    Overview

    Transaction logs can be imported in T.M.A.S. in order to populate data on the Today's Dashboard as well as various reports which provide KPIs based on combining traffic with sales, transactions, items and staff data.

    The import can be configured in the event that T.M.A.S. does not currently support your P.O.S. for direct integration and your P.O.S. has the ability to export a transactional log report (delimited CSV file with 1 row per transaction).

    Once configured, T.M.A.S. will retrieve a file on a the set schedule to import from the supplied integrated FTP solution. Note: Custom FTP is available, please contact techsupport@storetraffic.com to provide the FTP information for whitelisting prior to proceeding with this configuration. 

    Example: T.M.A.S. - Manage locations Import - transactions log file

    Steps to setup the transaction log import






    1. Select a location
    2. Expand Administration
    3. Select Manage Locations
    4. Select Import / Export Data / P.O.S. Integration
    5. Click Add
    6. Complete General Information
      1. Label = name for import or POS name
      2. Import type = delimited
      3. File Mask = name of file and or type to look for on FTP
      4. Delimiter = Comma or Semi-colon
      5. Status = must be checked for job to work
      6. FTP - Use Default
        • Use create new Storetraffic FTP account if dropdown is blank
        • To use a custom FTP, contact techsupport@storetraffic.com as FTP will need to approved for whitelisting
      7. root - default /imports check box to change default path to another directory on the FTP (Folder must exist to be able to save job)
    7. Click Next
    8. Set Schedule type to match the frequency you will upload and Hour for a couple minutes after the expected file upload.
    9. Click Next
    10. Complete Columns Information
      1. Location Mask = Location ID
      2. Select date format matched date column in file
      3. Check off Transaction log file
      4. Set the following columns Location ID, Date, Hour, Minute, Trans Id, Amount, Items numbers matching which the import file 
    11. Click Preview file - example should match your import file
    12. Click Add - Job will now be saved and run on the set schedule
    13. Test File Upload and Click Run on Demand to import ; once completed, go to Analytics / Reports and run a Totaling or Data Export report to verify the imported data

    FAQ

    Q: Are headers required in the uploaded file for import?
    A: Yes, the import file will not be processed unless headers are included in the output.
    Q: Can the column values be within "Quotes"?
    A: Currently this format is NOT accepted.
    Q: Can the Date/Time format be in AM/PM?
    A: Currently this format is NOT accepted.
    Q: Can the location ID column include location labels as well as the ID #?
    A: No, this column must be a numerical match to the location ID in T.M.A.S.

    Additional aid for file importation verification and setup

    An appointment can be made with SMS Techsupport for a video conference call to determine what capabilities your POS has in order to perform this setup.  Contact techsupport@storetraffic.com to make an appointment.



    header-top-left-border Created with Sketch.
    header-top-right-border Created with Sketch.