/build/static/layout/Breadcrumb_cap_w.png

Kace asset import by CSV issue

Hello,


I'm having trouble importing assets on Kace using csv file.

When i need to do the asset import mapping, Kace detect all my columns as one column (see below screenshot)


Dye+WC+eZ4FoAAAAAElFTkSuQmCC


Is there something i'm missing here or is it a bug ?


Thanks by advance.


0 Comments   [ + ] Show comments

Answers (3)

Answer Summary:
Posted by: KevinG 3 weeks ago
Red Belt
0

What version of the SMA?

What were the options selected in the first steps of the import?

What did you use to create the CSV file?


I suspect an issue with the CSV file.

Posted by: MarlotM 3 weeks ago
White Belt
0

Hello,


Version of the SMA isĀ 13.2.182

The option selected is "Upload an Asset import CSV file"


Regarding the CSV file, i have created using Excel.

Posted by: MarlotM 3 weeks ago
White Belt
0

Top Answer

Found my solution :


Kace do not recognise semicolon as separator in excel files, only comma.

Everything is working fin now, thank you for your help.


Comments:
  • Yeah, it requires a CSV file. (Comma-separated values) - KevinG 3 weeks ago
    • And just as an extra nugget, if you are planning to import loads of records in one import, say 50 or above, you will need to save that CSV file in a UTF8 format, otherwise KACE will not be able to process it ;o) - Hobbsy 2 weeks ago

Don't be a Stranger!

Sign up today to participate, stay informed, earn points and establish a reputation for yourself!

Sign up! or login

Share

 
This website uses cookies. By continuing to use this site and/or clicking the "Accept" button you are providing consent Quest Software and its affiliates do NOT sell the Personal Data you provide to us either when you register on our websites or when you do business with us. For more information about our Privacy Policy and our data protection efforts, please visit GDPR-HQ