cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
4613
Views
0
Helpful
9
Replies

NCS - add guest user (import from file)

codflanglers
Level 1
Level 1

Does anyone have the format of the csv? I'm using

user     password     duration      description     disclaimer

However, I get the error "Insufficient data at line 1. Missing required 2 field(s).".

Any ideas?

9 Replies 9

Amjad Abdullah
VIP Alumni
VIP Alumni

Don't you have a sample on the page that allows you to upload the file? There are usually sample what to configure and what parameters are mandatory and what are optional.

Can you please put a sample from your CSV file?

Thanks.

Amjad

Rating useful replies is more useful than saying "Thank you"

codflanglers
Level 1
Level 1

Username Password Lifetime Description Disclaimer
user1 ***** 3600 Example conference Disclaimer-1
user2 ***** 3600 Example conference Disclaimer-1
user3 ***** 3600 Example conference Disclaimer-1
user4 ***** 3600 Example conference Disclaimer-1


This is what I have in my csv

You should separate letters by commas (and hence the CSV name: Comma separated values).

you should write:

"Username","password", "lifetime", "Description", Disclaimer"

user1,*******,3600,Example conference disclaimer-1.

HTH

Amjad

Rating useful replies is more useful than saying "Thank you"

But the footnote on the NCS says "The first row of the sample CSV below is used to describe the columns. It is not required in the CSV file. The Description and Disclaimer are not mandatory." which would indicate that the data needs to be seperated out in to columns.

This is why I asked you about what the note says.

so, if it is the case, ignore the first row I put.

If you want not to insert optional fields you would write (for example, ignoring the disclaimer and the description):

user1,*****,3600,,,

(or if we want to ignore the disclaimer only);

user1,*****,3600,description,,

(or if we want to ignore the description only):

user1,******,3600,,disclaimer

.

You need to use 4 commans anyway for each row. if you want to leave something blanks you use whatever after the comma blank. but the comma should be there.

NCS uses the commas as separator to know what field to be filled. So no need to put them in regular column shape.

HTH

Amjad

Rating useful replies is more useful than saying "Thank you"

OK, so I moved all the data in to a single column. Four commas. Still the same error.

You need five columns. not four.

user1,******,3600,,disclaimer

username: user1

password: ******

lifetime: 3600

description is not provided.

Disclaimer: disclaimer

Do you have 5 columns in your CSV or 4? are you using commas?

Rating useful replies is more useful than saying "Thank you"

I have 5 columns in my csv. I have tried using commas and not and both are the same.

Sorted it. Turns out the file I was using was corrupt for some reason. I re-created the file in the original format and it worked fine.

Review Cisco Networking for a $25 gift card