Importing Remote Office csv failing

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:

  1. 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
  2. ,,,,,,,,,,,,,,,,,
  3. - Header name(s) " REMOTE_OFFICE_NAME " are not allowed


  4. Instructions to be noted to prevent errors while importing
  5. 1. The following characters are not allowed for csv input data : quotes ( " and ' ), back slash (\)
  6. 2. If no data is required for a column, simply add a comma.



The instructions from DC are:
Column Names and their Description
  1. REMOTE_OFFICE_NAME - The Remote Office name
  2. 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:
    1. DS_DOMAIN_NAME - Domain Netbios Name of the Distribution Server
    2. DS_NAME - Computer Name where Distribution Server will be installed
    3. DS_IP - IP Address of the computer where Distribution Server will be installed
    4. DS_DNS_NAME - DNS Name where Distribution Server will be installed
    5. DS_PORT - HTTP Port through with the Distribution Server and WAN Agents communicate
    6. DS_HTTPS_PORT - HTTPS Port through with the Distribution Server and WAN Agents communicate
  3. REPLICATION_POLICY_NAME - Name of the Replication Policy created.
  4. PROTOCOL - The mode of communication between Distribution Server, WAN Computers and Desktop Central Server. The default is HTTP
  5. 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:
    1. PROXY_SERVER - The name / IP Address of the Proxy Server
    2. PROXY_PORT - The Proxy Port
    3. PROXY_USER - The user name for accessing the Proxy Server
    4. PROXY_PASSWORD - The password of the proxy user account.
  6. 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.
  7. 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.
  8. 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 ADManager Plus?

                  New to ADSelfService Plus?