Importing Remote Office csv failing
Using the information from desktop central, the csv file is formatted as such. However, when i get to import the csv file it errors out with this:
- REMOTE_OFFICE_NAME,HAS_DS,DS_DOMAIN_NAME,DS_NAME,DS_IP,DS_DNS_NAME,DS_PORT,DS_HTTPS_PORT,REPLICATION_POLICY_NAME,PROTOCOL,HAS_PROXY,PROXY_SERVER,PROXY_PORT,PROXY_USER,PROXY_PASSWORD,COMPRESSION_TYPE,COLORQUALITY_TYPE,COMPUTERS
- ,,,,,,,,,,,,,,,,,
- - Header name(s) " REMOTE_OFFICE_NAME " are not allowed
- Instructions to be noted to prevent errors while importing
- 1. The following characters are not allowed for csv input data : quotes ( " and ' ), back slash (\)
- 2. If no data is required for a column, simply add a comma.
The instructions from DC are:
Column Names and their Description
|
- REMOTE_OFFICE_NAME - The Remote Office name
- HAS_DS - The values can be Yes or No. Yes means that
the communication Type is through the Distribution Server. The default
value is 'No' if newly added or the previous value in case of
modification. If the value is yes, the following columns are
mandatory:
- DS_DOMAIN_NAME - Domain Netbios Name of the Distribution Server
- DS_NAME - Computer Name where Distribution Server will be installed
- DS_IP - IP Address of the computer where Distribution Server will be installed
- DS_DNS_NAME - DNS Name where Distribution Server will be installed
- DS_PORT - HTTP Port through with the Distribution Server and WAN Agents communicate
- DS_HTTPS_PORT - HTTPS Port through with the Distribution Server and WAN Agents communicate
- REPLICATION_POLICY_NAME - Name of the Replication Policy created.
- PROTOCOL - The mode of communication between Distribution Server, WAN Computers and Desktop Central Server. The default is HTTP
- HAS_PROXY - The values can be Yes or No. 'Yes' means
the communication between the Distribution Server/WAN Computers to the
Desktop Central Server happens throuh the Proxy Server. The default is
'No' if newly added or the previous value in case of modification. If
the value is 'yes', the following columns are mandatory:
- PROXY_SERVER - The name / IP Address of the Proxy Server
- PROXY_PORT - The Proxy Port
- PROXY_USER - The user name for accessing the Proxy Server
- PROXY_PASSWORD - The password of the proxy user account.
- COMPRESSION_TYPE - The level of compression that
Remote Control feature should use for this Remote Office. The values can
be 0 or 1. 'Zero' denotes Fast Compression and 'One' denotes Best
Compression.
- COLORQUALITY_TYPE - Denotes the color quality of the
remote connections established using Remote Control feature. This can be
'4' for 4-bit, '8' for 8-bit, '16' for 16-bit and '24' for True Color.
- COMPUTERS - The computer names in that remote office.
If more than one computer is being specified, it should be within
double-quotes. Example: "john,jerry". Ensure that you add these
computers under Scope Of Management to install agent(s)
There are no (") or (') or (\) anywhere in the csv file. From what I can tell, the import doesn't like the fact that the first header column is named REMOTE_OFFICE_NAME, despite the instructions stating that should be the column name.
How do I go about importing a csv of my remote offices, i have 52? I will also need to do all of our computers. But want to make sure that the remote offices are done first.
New to ADSelfService Plus?