Import CIs

 
Author
Message
SysAid Product Manager
309
 

Settings

CMDB

Import CIs from a Delimited File

 

This page allows you to easily import a list of CIs from a .csv file. You can also update existing CIs by reimporting them with updated information.

 

 

To import a list of CIs:

  1. Create a .csv file with the CIs you would like to import. You can easily create a .csv file using Microsoft Excel (save as CSV). Columns in the .csv are fields to import for each CI, and rows in the .csv are the individual CIs. See the image below for an example.

     A .csv file ready for import into SysAid


  2. Select the .csv you've created by clicking Choose File.
  3. If your .csv has column headers (like in the picture above) select the Do not import the head line check box.
  4. Select the field delimiter. If you create the .csv in Excel, this is a comma (,) by default.
  5. Select the number of fields to import. The number of fields is equal to the number of columns in your .csv file.
  6. Choose a column as the key field for the import. The importance of the key field is for checking to see if the CIs already exists in your system. If a CI already exists, SysAid updates it instead of creating a new CI. Please make sure to use a field with unique values as the key. If you use a field with values that frequently appear, you will simply overwrite one of your CIs multiple times.
  7. Choose the Default CI Type. Any new CI you import that doesn't have a specified type is created with the type you specify here.
  8. Select each field you are importing in the Field content column. Each field corresponds to one column in the .csv file. The Field content in Position 1 is the left-most column in your .csv.
  9. If you select any date fields, specify the date format in the Format column. You can use either European (dd/mm/yyyy) or US date formats (mm/dd/yyyy).
  10. Click Submit to import your CIs.

 

You can verify that your CIs were correctly imported and/or updated from Assets > CMDB > CI List.

 

Automatically sync SysAid with a .csv file

You can set SysAid to automatically sync its CI information with a .csv file. This means that at the intervals you define, SysAid checks the .csv file for changes. If any changes have been made, SysAid imports the file and overrides the existing CI information with the updated information in the .csv file.

 

On-Premise users can accomplish this by pointing to the file location of the .csv file or by connecting to the .csv file via the RDS. Cloud users can perform this sync only by connecting to the .csv file via the RDS. The RDS scans the folder and uploads the copy of the .csv file to the server every 10 minutes. The server processes the updated information based on the selected schedule time.

 

To automatically sync your CIs with a .csv file via the SysAid server

  1. Check the Schedule box.
  2. In the Start Time field, select a date and time to begin syncing with the file.
  3. From the Rerun Every drop-down list, select if the sync should occur every hour, day, or week.
  4. Select the File path option button.
  5. In the File Path field, enter the file path location of the .csv file.
  6. Click Set scheduled import.

 

To automatically sync your CIs with a .csv file via the RDS

  1. Check the Schedule box.
  2. In the Start Time field, select a date and time to begin syncing with the file.
  3. From the Rerun Every drop-down list, select if the sync should occur every hour, day, or week.
  4. Select the File path option button.
  5. Click Set scheduled import.
  6. On your system, add a copy of the .csv file to the RDS folder under WEB-INF/csvCiFiles.

    Important: Do not attempt to permanently store the original .csv file in this location as the RDS uploads it to the server and removes it from this location.

  7. Access the RDS and open the DiscoveryService.properties file.
  8. Find the "csv.ci.import" parameter and set its value to "true". If the parameter does not exist in the file, add it manually.
  9. Save the file.
  10. Restart the RDS service.

 

 

SysAider
5
 
if my service is cloud sho a error find the file, any idea?
SysAid Community Manager Product Team
4490
 
Joseph Pineda wrote:if my service is cloud sho a error find the file, any idea?

Hi Joseph,

Can you please clarify the issue? What is the content of the error you receive?

Cheers,
Danny
SysAider
5
 
when a try import file , show always a file not found, my service is cloud account, the file path is: http://www.site.com/sysaid/file.csv and not have option by hour, only day and other
SysAid Community Manager Product Team
4490
 
Hi Joseph,

I'm not sure I understand. Can you please take a screenshot of CI import screen after an error is received and post it here?

Additionally, what do you mean you don't have the option by hour? Are you referring to the schedule of CI imports? If so - you should be able to select the schedule time when selecting the date.

Cheers,
Danny
SysAider
5
 
I'm trying to import a basic CSV for CI's but whenever I choose the key field number, in this case phone number for cell phones, I keep getting the message:

Please choose one of the imported fields to be the key field.

What is the reason for this? The field does have unique values in it!
SysAid Community Manager Product Team
4490
 
Hi morpheusa5,

Can you please send me the CSV file over a private message (use Google Drive or similar), and a screenshot of the settings you chose for importing CIs? I'll try testing it here.

Cheers,
Danny
SysAider
8
 
Hi,
i have the problem as well!
What should i do ?
Thanks a lot.
Julien
SysAid Community Manager Product Team
4490
 
Hi Julien,

Please double-check that your import settings are configured correctly to receive the file in question. If that fails, please follow my previous advice in this thread and send the file over to me

Thanks,
Danny
SysAider
8
 
Hi Danny,
thanks for your answer
You've got in attachments 3 documents, Importation_CI_non_conformite_new_id.csv plus Import_CIs.png and CI_cust_fields.png. Import_CIs.png is a image of the configuration for the import. I would like to import the content of the csv file in the cust fields described in CI_cust_fields.png.
thanks a lot.
Regards.
Julien
Importation_CI_non_conformite_new_id.csv
SysAid Community Manager Product Team
4490
 
What is the exact error you receive when trying to import?
SysAider
8
 
The error message is : Please choose one of the imported fields to be the key field.
SysAid Community Manager Product Team
4490
 
Strange, it worked here without this error. I suggest contacting our customer support team for further investigation, and update here once a solution is found.

Thanks,
Danny
SysAider
8
 
Did you creat crustomized fields ?
Did you creat a CI type Non-conforme ?
I have a SysAid for test could it be the reason ?
Can you send me a printscreen of your parameters ?
Thanks.
Julien
SysAid Community Manager Product Team
4490
 
I've inserted most of the information into random custom text fields - however from my understanding the error usually pops up on the start of the file scan. What happens if you flip the "Key field number" to 0 or 2?