FOCUS SQL Import Tool - SETUP

1. Preparation
   1. Obtain an instance of Microsoft SQL Server. This can be hosted on your own computers, or on your preferred cloud-hosting service (i.e. AWS RDS or Azure SQL)
   2. Download and install Microsoft SQL Server Management Studio
      1. Microsoft SQL Server Management Studio
   3. Connect to your Database Instance and create a new Database called FOCUSPOS
2. Database Settings
   1. Server Name - ​This will be the server name of your SQL Server. You will need TCP Port 1433 open to this server as the Import Tool writes directly to SQL Tables.
1. Log on to the server
   1. Select User SQL Server Authentication and enter in your SQL Server Credentials
2. Press Connect to connect to your SQL Server Instance. If any errors are encountered, solve for the error before proceeding.
3. Import Settings
   1. Database Name
      1. Select the FOCUSPOS database that was created in Step 1.3
   2. Import Interval
      1. Set your import interval to 60. This will cause the import tool to look for a pending import every 60 minutes.
   3. Hardware Key
      1. This is your FOCUS License Key.
      2. Your License Key can be found by touching on the time at your main FOCUS Log In Screen. Then press "System". Look for the word "HW Key". That number is your FOCUS License Key.
      3. 
   4. Press Schedule
      1. This will schedule your import to begin.
4. Tools
   1. Focus Path
      1. Depending on your FOCUS configuration, your FOCUS path will either be c:\Focus or d:\Focus.
         1. If you're unsure of which path to use, please contact the Focus Helpdesk
      2. If you need to change the path from c:\Focus, press Update Focus Path after the change is made.
   2. Update Database
      1. After getting the above items taken care of, you're going to want to press Update Database which will setup the necessary database tables
   3. Add Store
      1. When you press Add Store you're going to need to fill in your store info, including address and Hardware Key (same number from Step 3.3 above)

After that, you're all set and ready to start polling to your own SQL Instance.