07-17-2012 07:06 AM - edited 07-03-2021 10:25 PM
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?
07-18-2012 02:53 AM
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
07-18-2012 03:19 AM
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
07-18-2012 03:33 AM
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
07-18-2012 04:42 AM
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.
07-18-2012 04:57 AM
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
07-18-2012 05:20 AM
OK, so I moved all the data in to a single column. Four commas. Still the same error.
07-18-2012 05:31 AM
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?
07-18-2012 07:00 AM
I have 5 columns in my csv. I have tried using commas and not and both are the same.
07-19-2012 01:46 AM
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.
Discover and save your favorite ideas. Come back to expert answers, step-by-step guides, recent topics, and more.
New here? Get started with these tips. How to use Community New member guide