Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Notifications
Login / Register
Community
Community
Notifications
close
  • Forums
  • Knowledge Center
  • Events & Webinars
  • Ideas
  • Blogs
Help
Help
  • Explore Community
  • Get Started
  • Ask the Community
  • How-To & Best Practices
  • Contact Support
Login / Register
Sustainability
Sustainability

We Value Your Feedback!
Could you please spare a few minutes to share your thoughts on Cloud Connected vs On-Premise Services. Your feedback can help us shape the future of services.
Learn more about the survey or Click here to Launch the survey
Schneider Electric Services Innovation Team!

Mass importing User Photos into Security Expert using Data Sync Service

Building Automation Knowledge Base

Schneider Electric Building Automation Knowledge Base is a self-service resource to answer all your questions about EcoStruxure Building suite, Andover Continuum, Satchwell, TAC…

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
  • Home
  • Schneider Electric Community
  • Knowledge Center
  • Building Automation Knowledge Base
  • Mass importing User Photos into Security Expert using Data Sync Service
Options
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
Invite a Co-worker
Send a co-worker an invite to the portal.Just enter their email address and we'll connect them to register. After joining, they will belong to the same company.
You have entered an invalid email address. Please re-enter the email address.
This co-worker has already been invited to the Exchange portal. Please invite another co-worker.
Please enter email address
Send Invite Cancel
Invitation Sent
Your invitation was sent.Thanks for sharing Exchange with your co-worker.
Send New Invite Close

Related Forums

  • Intelligent Devices Forum

Previous Next
Contributors
  • RobertAndriolo
    RobertAndriolo
  • AdamSteele
    AdamSteele

Invite a Colleague

Found this content useful? Share it with a Colleague!

Invite a Colleague Invite
Back to Building Automation Knowledge Base
Options
  • Bookmark
  • Subscribe
  • Email to a Friend
  • Printer Friendly Page
  • Report Inappropriate Content
1 Like
3071 Views

Link copied. Please paste this link to share this article on your social media post.

Trying to translate this page to your language?
Select your language from the translate dropdown in the upper right. arrow
Translate to: English
  • (Français) French
  • (Deutsche) German
  • (Italiano) Italian
  • (Português) Portuguese
  • (Русский) Russian
  • (Español) Spanish

Mass importing User Photos into Security Expert using Data Sync Service

Kirk AdamSteele Kirk
‎2018-11-15 10:30 PM

Warning

Potential for Data Loss: The steps detailed in the resolution of this article may result in a loss of critical data if not performed properly. Before beginning these steps, make sure all important data is backed up in the event of data loss. If you are unsure or unfamiliar with any complex steps detailed in this article, please contact Product Support for assistance.

Issue

Need a method for mass importing User photos for creating / updating the Users for a Security Expert site.

Product Line

Security Expert

Environment

  • Security Expert
  • Security Expert Data Sync Service (SX-DB-SYNC)

Cause

Data Sync Service is typically used to import data from the third party system.  In this instance, a CSV file containing the data to be imported into the Security Expert database is used. The Data Sync Service is configured to monitor the folder where this CSV file is located and automatically (if configured) import the relevant data into Security Expert, creating records (including users, access levels, areas, doors, schedules, and so on) for each matched entity.

Resolution

The Data Sync Service can be used to map specific fields from a CSV file to fields within Security Expert. One of those fields can be the User photos. Below is a guide on how to implement this.

 

1. Directory Setup

Before opening the Security Expert Data Sync Service, it is necessary to setup a CSV file and directory for the Data Sync Service to work with. The only requirement for now is that each image must have a unique name and that the folder housing the images must be called "Photos". Figure 1 shows an example folder structure:


SX_DataSyncService_ImportFolderStructure.png

Note: The names of the folder, CSV file and image names are not critical. As long as the image names match what is in the CSV file.

 

2. CSV File

A CSV file is a comma separated file with each row being a separate record and columns (fields) separated by comma's. An example CSV is shown below:

 

UniqueID,FirstName,LastName,AccessLevel,PIN
101,First,User,Visitor,1284
102,Second,User,Visitor,5618

Note: The UniqueID field will need to be the file name of the Users image. For the below example CSV, two images must be present in /Photos/ with the names 101.jpg and 102.jpg.

 

3. Security Expert Operator

It is recommended that a new Security Expert Operator is added for importing from the Data Sync Service. This ensures that records that have been added / modified / deleted by the Data Sync Service can easily be identified. To proceed past the Data Target section the Show PIN numbers for Users option must be enabled in the Operator object.

 

4. Data Target

Now that an Operator, directory and CSV have been set up, open Security Expert Data Sync Service and follow these steps:

  1. Select Security Expert from the Target System dropdown.
  2. Confirm the SOAP Server Address. If the defaults were accepted during the installation of the SOAP Service, enter http://localhost:8030/SecurityExpertSOAPService/service.svc.
  3. Enter the Username of an Operator.
  4. Enter the Password for that Operator.
  5. From the Site dropdown, select the Site that the records are to be imported to. All Sites that have been added in Security Expert will be available in the dropdown.
  6. Overwrite the Site ID during the field mapping process if the records are imported to different Sites within a single import.

SX_DataSyncService_DataTarget_KBsteps.png

Note: The rest of the fields on the Configuration window are disabled until a valid Server Address, Username and Password have been entered.

 

5. Sync Options

  1. Set the Resynchronize Every time to a time interval over which the service should resync data.
  2. Tick the Enable Error Log checkbox to populate the Event Viewer with events that will make error solving simpler. 

SX_DataSyncService_SyncOptions.png

6. Data Mapping

 Configure the records and import file with the following steps.

  1. Select Users from the Record to Sync drop-down. 
  2. In the File Directory field, enter the created folder.
  3. If importing a single file, enter the name of the file in the Import File field. If the checkbox is left unticked, all files in the File Directory will be imported.
  4. From the File Format drop-down, select Delimited.
  5. If the import file is a CSV, select {CR}{LF} as the Row and {Comma} as Column delimiters.
  6. Enable the option to Start Import At Row 2 to skip the header. 

SX_DataSyncService_TargetFields_KBsteps.png

 

7. Field Mapping

The data mapping phase allows CSV columns (Source Column) to be mapped to a record type in the Security Expert Database (Target Field). To import the example CSV, the field mapping must be configured as below. Link a Target Field and Source Column, simply select both in the interface, complete the following:

  1. Link the following [Target Field : Source Column]:
    1. ImageID : 1,
    2. First Name : 2,
    3. Last Name : 3,
    4. UserAccessLevelGroupDataData > UserAccessLevel : 4
    5. PINNumber : 5,
  2. Select ImageID (Column 1) as the Unique Field.
  3. For UserAccesLevel, open the Advanced Data Configuration by clicking the [ … ] button.
    1. Ensure that Use This Field As The Group Data Identifier is set and Grouping Type is Singular Data.
    2. Ensure Target Field Record Type is ticked and set to Access Levels.
  4. Click Save and then Start to begin the syncing of Users.

SX_DataSyncService_DataMapping_KBsteps.png

8. Troubleshooting

If troubleshooting is required, examine the following logs:

  1. All Events - In Security Expert under Monitoring > Status Page View, open the All Events view to view Data Sync Service events.
  2. Event Viewer - Open the Windows Event Viewer and navigate to Event Viewer > Applications and Services Logs > Schneider Electric Security Expert event log.
Labels (1)
Labels:
  • EcoStruxure Security Expert
Tags (2)
  • Find more articles tagged with:
  • AdamSteele20
  • AdamSteele21
Was this article helpful? Yes No
100% helpful (1/1)

Link copied. Please paste this link to share this article on your social media post.

To The Top!

Forums

  • APC UPS Data Center Backup Solutions
  • EcoStruxure IT
  • EcoStruxure Geo SCADA Expert
  • Metering & Power Quality
  • Schneider Electric Wiser

Knowledge Center

Events & webinars

Ideas

Blogs

Get Started

  • Ask the Community
  • Community Guidelines
  • Community User Guide
  • How-To & Best Practice
  • Experts Leaderboard
  • Contact Support
Brand-Logo
Subscribing is a smart move!
You can subscribe to this board after you log in or create your free account.
Forum-Icon

Create your free account or log in to subscribe to the board - and gain access to more than 10,000+ support articles along with insights from experts and peers.

Register today for FREE

Register Now

Already have an account? Login

Terms & Conditions Privacy Notice Change your Cookie Settings © 2025 Schneider Electric

This is a heading

With achievable small steps, users progress and continually feel satisfaction in task accomplishment.

Usetiful Onboarding Checklist remembers the progress of every user, allowing them to take bite-sized journeys and continue where they left.

of