Load file users into the AspNetUsers table

Question

I have an Ms Excel file listing the users of my application. This file contains a set of informations of them(firstname, lastname, email...) but it does not contain the password and of course the Id fields. I want to load this file into the AspNetUsers table defined by the Ms Identity framework. How could i do this task?

thanks for your help

what i can suggest to you is to creat a task (maybe a test) wich ge items from excel and isert them in sql by EF — federico scamuzzi, Feb 14 '17 at 11:34
Good idea, thanks. But why should i use a task ? Is it for multi-threading purpose ? — Zakaria.d, Feb 14 '17 at 14:01
Create a [seeding method](http://stackoverflow.com/questions/19280527/mvc-5-seed-users-and-roles) in migration (or elsewhere). Read the file in, loop through it and add users as shown in link. — Steve Greene, Feb 14 '17 at 14:43
If it help you i ll post it ad an answer and you can rate it if you want... thnx — federico scamuzzi, Feb 14 '17 at 17:08

score 0 · Accepted Answer · answered Feb 14 '17 at 17:10

0

what i can suggest to you is to creat a consolen application or maybe a test Which can get the items from excel and isert them in sql by EF

answered Feb 14 '17 at 17:10

federico scamuzzi

3,708
1
17
24

Load file users into the AspNetUsers table

1 Answers1