T.M.A.S. provides the ability to easily configure a flat file for traffic and schedule an export to an SMS supplied FTP site or your own custom FTP site. Thus enabling your to integrate traffic into other BI applications
Upload traffic data to another application, reporting system or data warehouse.
Automate and schedule uploads at regular intervals as new data is being collected.
Easily integrate traffic data with different systems.
Use SMS supplied FTP site or your very own for uploading.
Receive the export by e-mail.
Examples of applications that import traffic files from T.M.A.S.
Export sample files
*Custom exports available on demand and subject to additional fees which will be quoted.
Verify / Update - FTP address path points to the Import folder or root by default. (Optional) check off change default path and indicate a new path if other folders were created in the SMS FTP site. Note* This process will not create folders on the FTP, you would need to login separately to create these.
Contact SMS Techsupport
Customers which are looking to use their own custom FTP to upload and download traffic exports files must contact email@example.com to request whitelisting of the FTP URL for security purposes prior to proceeding with the following steps.
*If a custom port is also required as the standards are not in use or blocked, then additional fees may apply.
FTP CUSTOM - (USING YOUR OWN PRIVATE FTP)
Bullet Custom for FTP
Input the URL of the FTP address
Indicate a port (Common ports are FTP=21, FTP/SSL(aka FTPS)=21 or 990, SFTP=22)
Indicate file path
Indicate Columns Information
Traffic Interval to be displayed - determines traffic grouping for locations
15 Minutes (Note* - Requires counter interval to be 15min)
30 Minutes (Note* - Requires counter interval to be 30min or less)
Columns Layout(Selections vary depending on Traffic interval selected)
15min, 30min or 1 hour output selections are as follows
Daily output selections
Check business hours if you would like export to only contain business hours currently configured in T.M.A.S.
Test the export by clicking on the Run on demand icon, then login to the FTP and verify that the file has been received. (Note* could take a couple minutes for generation depending on the number of locations in the export)
If set to active prior to saving - A connection test will be performed at the end of the 'add export' setup wizard - if the connection test fails, an error message will be displayed, and the export job will NOT be saved. Set job as inactive to bypass the connection test and save settings.
How to Edit, Delete or Run an export on demand
Check off the export line - additional options will appear.
Click the button which responds to the what you would like to do
Edit will open the previously configured Export and allow changes to be made and saved such as change the scheduled timing
Delete will remove the export job after responding Yes to the confirmation window
Run Now - will launch the export job prior to the next scheduled run time. Once clicked, a confirmation message will be shown to indicate it has been run successfully. Allow a couple minutes after clicking the run now for the export to be generated and uploaded to the FTP site.
Other ways of exporting traffic data
SMS can customize exports which will only be configured upon request basis to Techsupport@storetraffic.com Additional fees may apply based on the complexity of the request charged at an hourly quoted rate.
Q: Can sales and transactions be exported too?
A: This export function is for traffic only, to generate a report in an Excel format for sales, transactions, staff,that and traffic data; use the data export report. Click here for more info.
Q: How can I export more than a day of data?
A: The default stock export returns yesterday’s data exclusively.