FAQ - Importing users from CSV file to WebEdition

FAQ - Importing users from CSV file to WebEdition

Question
How to import user data from a CSV file to WebEdition?


Answer
It is possible to import user data from a CSV file to WebEdition using DataMigrationTool (DMT). The tool is available  here for download, its compatible with R10.x version.

The tool has been pre-configured to accept CSV input file located at “C:\TBS\migration.csv” and import the users to TBS database (default .\SQLEXPRESS instance). If different settings are required, then the file ‘DataMigrationTool.exe.config’ has to be edited accordingly.

The migration tool accepts the CSV input file in following format - 'migration.csv' (attached) , 'migration-with-avatars.csv'(attached). 


The UserID field is mandatory and has to be unique.
IMPORTANT: If there are clients already connected to server during migration, then they have to be manually synchronized by performing Reload DB from BioManager. Its required because DMT is adding the users directly to TBS database without creating any transactions to clients. The DMT is intended to be used only at project start to migrate existing users. If continuous user migration is desired, then it has to be programmatically performed using server web services which will automatically synchronize new users to client. Please contact TBS support for further information regarding web services if required. 


    • Related Articles

    • HowTo - Prevent WebEdition database log file from expanding continuosly

      Question How can I reduce the file size of TBS WebEdition database log, default name 'TBS_BAWSE.ldf'? NOTE: This logging is an inbuilt feature of MS SQL server itself and not created by TBS software. Its the responsibility of local DB server ...

    • FAQ - System requirements for TBS WebEdition

      Question What are the system requirements for TBS WebEdition? Answer The answer cannot be given easily, because it strongly depends on many parameters: number of users number of devices transactions per timeframe user data mutation frequency etc. ...

    • FAQ - Ways to access SQL Server in WebEdition

      Question By default WebEdition accesses SQL server database using 'SQL Server authentication'. How can I change that to 'Windows authentication'? Answer TBS server software is preconfigured to use 'SQL Server authentication' method when connecting to ...

    • FAQ - WebEdition server installation troubleshooting

      Question What are the most frequent problems when installing WebEdition server, and how can I solve them? Answer Installing all WebEdition server components is not a click-and-go experience. It requires several installation steps and skipping or ...

    • FAQ - Basic backup/restore of WE database in the same MS SQL Server

      Question How can I simply backup and restore TBS WebEdition server database (in the same SQL Server installation)? Answer In order to prevent data loss, it is a good practice to regularly backup content of TBS WebEdition server database. This article ...