I have a requirement to create a console application that will read in data from a file. This data will be used to create new users in a database and assign them roles. The input file will specify usernames to be used and the roles to which these new users will be assigned (7 potential different roles where it is possible to have more than one role).
The users will need to drop a file with the required information into a specified folder and then run the console application.
My question is what would be the best input file type to avoid confusion? E.g. txt, xml, csv, JSON etc. Would it be best to have a single fixed file that the user can edit each time or instead get them to create new files each time? Would it be best to included a README document in the same folder to explain how they should delimit the data correctly?
The people supplying this information will not be developers.