...
Data Uploader is a CAM windows utility that read reads workspaces, users, and groups-related data from your on-premises billing or NBI system and upload the information to the CAM cloud for processing.
...
What Limits do I have with Data Uploader?
| Note |
|---|
|
CSV files have a maximum of 100 rows. Having more than 100 rows may result in issues like imports resulting in days to process.
How do I download Data Uploader?
The Data Uploader can be downloaded from theĀ AdministrationĀ tab >Data Uploader. Download and run the installer. Read here forĀ ConfigurationĀ details. The user must have system permission to download, install, and run the Data Uploader on the Desktop or server.
Is Windows 2012 supported for DU?
There can be issues running Windows Server 2012. Please read: https://pdocs.atlassian.net/wiki/spaces/CCAM/pages/33325689/Data+Uploader+Configuration#Important-Note-for-Windows-Server-2012 . We recommend Windows 2016+.
SQL Server can be SQL 2012+.
...
Are any changes made to the on-premises source database?
No changes are made to the on-premises database. The Data Uploader needs Read-only access to the source database on the SQL server to query the database and upload the information to CAM.
...
Are high availability servers supported for Data Uploader?
Currently, DU does not support an active-active or an active-passive High Availability configuration. This means that DU is not designed to be run concurrently on two servers for high availability purposes, and there is no built-in functionality for automatic failover or files synchronization (generated JSON / CSV) between servers. In the event that the primary server running DU fails, the service will not automatically resume on a secondary server. Furthermore, because there is no automatic synchronization of files or processing states, if you were to start DU on a secondary server after a failure, it would not continue from where the primary server left off uploading generated files. If the client chooses to use high availability on the database level from SQL, they can use that option.
...
Can multiple users log into the DataUploader server to view jobs?
Yes, multiple users can login to the server as whomever you want. However, data uploader must be run as the account you setup it with (no exceptions) otherwise jobs and connections may not display.
...
Connection Strings
What is a Connection String?
...
In order for Data Uploader to be able to create a Provisioning job, a properly configured script to update the matters must exist in the default SQL folderĀ C:\Program Files(x86)\Prosperoware\DataUploader\SQLĀ or in the folder path displayed in theĀ SQL FilesĀ tab.
The Jobs completed and show the workspaces in CAM, but the Job Center shows In Progress. What do I ned to do?
Most likely the API got overwhelmed and they ended up showing twice in the UI. It happens from time to time. If any concern is that the data is not there and completed, the jobs can be bulk re-run.
...
Can I change the default SQL folder location?
...
What needs to be set on the task scheduler?
Check On the Run only when General tab, ensure Run whether user is logged on . The task will not run in the other option.Check the Run with highest privileges boxor not, Do not store password, and Run with highest privileges are checked.
On the Settings tab, ensure Do not start a new instance is selected under If the task is already running, then the following rule applies list.
Use the service account user for the user account.
...
Check if the user running Data Uploader has access to execute scripts. Take one of the SQL scripts and run it as-is on the database.
...