cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Announcements

Welcome to the Smart Net Total Care Community!

Our community includes Cisco experts to answer your questions about the Smart Net Total Care (SNTC) portal and CSP-Collector.
Click the navigation links below to access materials for using our service and supported collectors.

385
Views
10
Helpful
8
Replies
Highlighted
Beginner

CSV file import issue

Hi there,

 

I'm trying to do a file import (CSV File) but I get the follow error message:

 

Import Errors: Operation could not be complete. [Unable to perform the operation = File Import failed. Error in CSV headers.]

 

 

I'm following exactly what the "sample CSV file" shows.

Can somebody help me, please?

 

Best Regards

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted

I received your private message, thank you.

I see that you have semi-colons(;) instead of commas(,) in the CSV, please remove these and replace them with commas then try your import again.

View solution in original post

8 REPLIES 8
Highlighted
Cisco Employee

When using the template have you removed row 2 and column I when submitting CSV file ?

Highlighted

Yes, I did.

 

 

Highlighted

can you open the CSV in notepad and send a screenshot of the header please?

Highlighted

I received your private message, thank you.

I see that you have semi-colons(;) instead of commas(,) in the CSV, please remove these and replace them with commas then try your import again.

View solution in original post

Highlighted

I did replace the semi-colons (;) to commas (,) in the notepad and it worked, CSV file has been imported successfully.

 

But the Excel itself did put the semi-colons automacally when I choose "save file as..."

 

Do you know how Excel can save the CSV file with commas (,) instead of semi-colons (;) or everytime I save a file as .CSV, I have to open it with notepad and replace the semi-colons to commas?

 

 

Highlighted

My suggestion would be to work off of the same CSV inventory file as new devices need to be added or old devices removed, this way you should avoid issues with the formatting in the future.

Highlighted

Now that it worked, I have a doubt...

 

Everytime I do the file import, it will count the "double" of devices? The uploads will not work like the CSPC, just updating the informations?

 

Best Regards

Highlighted

If you import to the same inventory every time the portal will expect to see the same devices and add or remove anything new or not in the CSV file. Keeping a running inventory on one CSV will not cause duplicates on the portal., it's necessary to have all the active devices remain in your reports.

CreatePlease to create content
Right-rail
Navigation
Be sure to bookmark these support pages and use them in the future to find all the self-help information.
Helpful Links