/
Export to New Roads SQL Server

Export to New Roads SQL Server

Feb 11, 2022

Please notify support@rtvision.com to update the export settings for the Timecard exports for New Roads for SQL Server. Once you complete the tasks below, you will need to have an Administrator update the New Roads connection in Timecard and also OneOffice.

This Section only needs to be done once.  If you have already completed these directions for use in another RTVision application, you do not need to repeat.

The export to New Roads SQL Server will require a SQL login. The SQL Server will need "SQL Server and Windows Authentication mode" enabled. Your IT administrator can use the following SQL script to create a SQL user that only has access to the import table(s). The script will create a SQL user named RtVision with a password determined by your IT administrator, just replace "password-here" where the script sets the password (...PASSWORD=N'password-here'). To run the script below, open SQL Server Management Studio from the New Roads SQL Server, click the "Connect" button when prompted, select File => New => Query, and paste the script in the query window. Then run the script by clicking the "Execute" button or pressing the F5 key.

USE [NRSDTA]
GO
IF NOT EXISTS (SELECT * FROM master.dbo.syslogins WHERE name = N'RtVision')
BEGIN
CREATE LOGIN [RtVision] WITH PASSWORD=N'password-here', DEFAULT_DATABASE=[NRSDTA], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF
EXEC sp_grantdbaccess N'RtVision', N'RtVision'
END
GO


For Timecard:

Using SQL Server Management Studio, as described above, run the following script granting permission to the timecard import tables.

USE [NRSDTA]
GO
GRANT SELECT, INSERT, DELETE ON [IMPEMPTIME] TO [RtVision]
GO
GRANT SELECT, INSERT, DELETE ON [IMPEQPTIME] TO [RtVision]
GO
GRANT SELECT, INSERT, DELETE ON [IMPINVWITH] TO [RtVision]

Update the connection setting in Timecard:

  1. Go to Administration
  2. Click Admin. Util.> Connections
  3. Change the Type to Microsoft SQL Server
  4. Update the IP address
  5. Change the Username to RtVision
  6. Change the Password to match what was set up above
  7. Click Save changes to connections

You can test by exporting data to New Roads, and then deleting the batch.