Settings Batch Import?

[Chris Lee <ch...@centurycity.com.hk>]

Hi All,

Does User and Connections support batch import (e.g CSV file)?

[cid:image001.png@01D60387.CF685D80]

I want to create all the AD users and PC info on Excel, export to CVS file and import to MySQL database.

Regards,
Chris



This message and its attachment (if any) are strictly confidential and sent to the designated recipient(s) only. If you are not the intended recipient, please notify the sender by e-mail and delete this message and its attachment (if any) from your computer system immediately . Century City International Holdings Limited, Paliburg Holdings Limited, Regal Hotels International Holdings Limited, its respective related subsidiaries, associated companies and affiliates do not guarantee this message and its attachment (if any) are free of computer virus and would not accept any liability whatsoever arising from Internet transmission.

Re: Settings Batch Import?

[ivanmarcus <iv...@yahoo.com.INVALID>]

Chris,

There isn't a batch import option in the GUI. You'd need to import 
direct to the MySQL database, which shouldn't be too hard.

Although you may be able to do it direct from MySQL I'd suggest a Python 
script might be a good option. Given time I may have a go at producing 
something, but can't right the moment (vy busy supporting lots of 
remotes). However it's possible someone has already done this.

You could do the same for the connections as well I expect, if that were 
useful.


On 26/03/2020 9:01 p.m., Chris Lee wrote:
>
> Hi All,
>
> Does User and Connections support batch import (e.g CSV file)?
>
> I want to create all the AD users and PC info on Excel, export to CVS 
> file and import to MySQL database.
>
> Regards,
>
> Chris
>
>
>
> This message and its attachment (if any) are strictly confidential and 
> sent to the designated recipient(s) only. If you are not the intended 
> recipient, please notify the sender by e-mail and delete this message 
> and its attachment (if any) from your computer system immediately . 
> Century City International Holdings Limited, Paliburg Holdings 
> Limited, Regal Hotels International Holdings Limited, its respective 
> related subsidiaries, associated companies and affiliates do not 
> guarantee this message and its attachment (if any) are free of 
> computer virus and would not accept any liability whatsoever arising 
> from Internet transmission.

Re: Settings Batch Import?

[Guilherme Carvalho <gc...@gmail.com>]

The users will be auto import when you configure the LDAP, the connections
is good question, i really need this script to import kkkkkk

Em qui., 26 de mar. de 2020 às 05:01, Chris Lee <ch...@centurycity.com.hk>
escreveu:

> Hi All,
>
>
>
> Does User and Connections support batch import (e.g CSV file)?
>
>
>
>
>
> I want to create all the AD users and PC info on Excel, export to CVS file
> and import to MySQL database.
>
>
>
> Regards,
>
> Chris
>
>
>
>
> This message and its attachment (if any) are strictly confidential and
> sent to the designated recipient(s) only. If you are not the intended
> recipient, please notify the sender by e-mail and delete this message and
> its attachment (if any) from your computer system immediately . Century
> City International Holdings Limited, Paliburg Holdings Limited, Regal
> Hotels International Holdings Limited, its respective related subsidiaries,
> associated companies and affiliates do not guarantee this message and its
> attachment (if any) are free of computer virus and would not accept any
> liability whatsoever arising from Internet transmission.
>