Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Next revision
Previous revision
en:how_to_export_and_import_users [2017/07/04 16:25]
127.0.0.1 external edit
en:how_to_export_and_import_users [2022/04/14 18:19]
kate [How to export and import users]
Line 3: Line 3:
 ====== How to export and import users ====== ====== How to export and import users ======
 In BioStar 2 you can import users in bulk with their basic user information such as user name, user ID, card ID and etc.  \\ In BioStar 2 you can import users in bulk with their basic user information such as user name, user ID, card ID and etc.  \\
- You can export the users in BioStar 2 as a CSV file and you can import them with a CSV file as well.   \\+ You can export the user information ​in BioStar 2 in a CSV file and you can import them using CSV file as well.   \\
 <callout type="​primary"​ icon="​true"> ​ <callout type="​primary"​ icon="​true"> ​
 CSV import does not allow you to import user fingerprint template. ​ CSV import does not allow you to import user fingerprint template. ​
 </​callout>​ </​callout>​
 +<callout type="​primary"​ icon="​true"> ​
 +CSV Import supports Batch Registration of Visual Face. Check the article below:
 +[[en:​supports_batch_registration_of_visual_face_using_csv_import|[BioStar 2] Supports Batch Registration of Visual Face Using CSV Import]]
 +</​callout>​
 +<callout type="​primary"​ icon="​true"> ​
 +CSV Import supports Mobile Access Card Enrollment. Check the article below: ​
 +[[en:​Issuing Suprema Mobile Access Cards via BioStar 2 User CSV Import|[BioStar 2 Issuing Suprema Mobile Access Cards via BioStar 2 User CSV Import]]
 +</​callout>​
 +
  
 Starting in BioStar 2.3, the CSV import feature was improved to have the following features: ​ \\ \\ Starting in BioStar 2.3, the CSV import feature was improved to have the following features: ​ \\ \\
Line 29: Line 38:
 5. The csv file is stored in your Windows **Downloads** folder. ​ \\ 5. The csv file is stored in your Windows **Downloads** folder. ​ \\
 {{:​en:​2x_sc_csv_import_export_003.png?​150|}} ​  \\ {{:​en:​2x_sc_csv_import_export_003.png?​150|}} ​  \\
 +
 +
 +===== Sorting Before Exporting =====
 +{{:​en:​2x_sc_csv_import_export_009.png?​|}} ​
 +1. You can click on the column names to **sort** the values by them. When you export them after sorting, the excel data are sorted as it’s sorted on BioStar 2. \\
 + 
  
 ===== Importing Users ===== ===== Importing Users =====
Line 43: Line 58:
 4. Remember to save the file format as a .csv file (separated with commas) and not a .txt or excel file. \\  4. Remember to save the file format as a .csv file (separated with commas) and not a .txt or excel file. \\ 
 {{:​en:​2x_sc_csv_import_export_005.png?​500|}} ​    \\ {{:​en:​2x_sc_csv_import_export_005.png?​500|}} ​    \\
- +<callout type="​primary"​ icon="​true">​  
 + Note:  
 +\\  
 +1. If you enter the user information in a language other than English or Korean, save the CSV file in UTF-8 format. 
 +\\ 
 +2. Supports DD/MM/YYYY format, Date format does not support MM/DD/YYYY format 
 +\\ 
 +3. If there are additional columns in the CSV file other than the basic user columns, BioStar 2 will fail to import the CSV file. 
 +</​callout>​ 
 + 
 5. Go to the **USER** tab in BioStar 2.  \\ 5. Go to the **USER** tab in BioStar 2.  \\
 6. Click on … \\ 6. Click on … \\
Line 60: Line 85:
 Check the content to see if there are any issue in those rows. \\  Check the content to see if there are any issue in those rows. \\ 
  ​{{:​en:​2x_sc_csv_import_export_008.png?​300|}} ​   ​  ​{{:​en:​2x_sc_csv_import_export_008.png?​300|}} ​   ​
- 
 </​callout>​ </​callout>​
 +\\
 +==== Video Demo ====
 +{{:​en:​2x_sc_how_to_export_and_import_users.mp4?​ 800x540}}
 +\\
 +