Differences
This shows you the differences between two versions of the page.
| 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] (current) 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}} | ||
| + | \\ | ||
| + | |||