topic NCS - add guest user (import from file) in Wireless

NCS - add guest user (import from file)

codflanglers — Sun, 04 Jul 2021 05:25:01 GMT

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?

NCS - add guest user (import from file)

Amjad Abdullah — Wed, 18 Jul 2012 09:53:09 GMT

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

Re: NCS - add guest user (import from file)

codflanglers — Wed, 18 Jul 2012 10:19:26 GMT

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

Re: NCS - add guest user (import from file)

Amjad Abdullah — Wed, 18 Jul 2012 10:33:28 GMT

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

NCS - add guest user (import from file)

codflanglers — Wed, 18 Jul 2012 11:42:23 GMT

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.

NCS - add guest user (import from file)

Amjad Abdullah — Wed, 18 Jul 2012 11:57:40 GMT

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

NCS - add guest user (import from file)

codflanglers — Wed, 18 Jul 2012 12:20:35 GMT

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

NCS - add guest user (import from file)

Amjad Abdullah — Wed, 18 Jul 2012 12:31:28 GMT

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?

NCS - add guest user (import from file)

codflanglers — Wed, 18 Jul 2012 14:00:08 GMT

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

NCS - add guest user (import from file)

codflanglers — Thu, 19 Jul 2012 08:46:21 GMT

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.