• State Not Answered
  • Locked Locked
  • Replies 4 replies
  • Subscribers 92 subscribers
  • Views 1993 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Employee - Person Table in MS SQL - UID_Person

jordanics ferenc
over 5 years ago

Hello

In the SQL db the Person table contain the all employees.

The UID_Person field - varchar(38), the value calculated over one procedure. This is the unique key field.  Someone knows which procedure generate this value????

This is the value: Person - UID_Person

1ed3b4bb-ad18-4c3e-bbba-069db8b326fb
339786e7-4c36-495f-9869-ce223b939aaf
394b2d97-6355-45f8-9817-9418101cc21d
47741097-bfbf-487e-89ad-37a2e4f37b87
4857e58f-9905-4a94-a890-4525e75c2421
53abba52-838e-4b99-80e6-c174ba91e3ae
9e68b4de-0940-4f01-b363-78c654714ca7
9f85ce19-13fd-4a18-9c58-b679d99b0cb4
af0198f0-53ba-4354-8560-b4e23eca812a
c655b270-e746-4080-9adc-f71d6014df75
e0d2bdf0-a397-49ad-a179-468c3e6d1a4e
ede0b719-3595-49bd-8b95-8a854bdf36f7
f56bf4b3-4144-4986-842b-16fa7eccfb84

I vould like to create the xml schema file to uplod employee into the Person table. But I have a problem the UID_Person field.

Could you help me how I configure the xml scheme to fill in the UID_Person field with the correct value.

Thank you and kind regards

Ferenc Jordanics

  • 0 over 5 years ago

    You shouldn't upload the data using pure SQL if that is what you are trying to achieve. In all other cases, the UID will be auto-generated by the object layer.

    Why are you trying to do that?

    Which version are you using?

  • 0 over 5 years ago

    Hello dear Markus,

    Thank you for replay.

    I'm using 8.0.2 version with MS SQl 2016 Server.

    First.        I would like to build up the test envirnment.  This is the reason why I would like to upload employee from a csv file.    I assume this is not a common procedure.

    Second.  I would like to better understand the procedure to fill it up the Person table.  The Parson table the main table about the whole employee

    I setup the AD synchronization, this uplod the AD user to the Person table.

    In the real environment the recomendation to synchronize the Person table - employee - with any kind of HR system.

    I would like to better understend who can I build a non standard interface if there are a special HR system.

    Thank you and kind regards

  • 0 over 5 years ago in reply to jordanics ferenc

    If you are using the Data Importer to import the data to the person table from the CSV you do not need to set the UID_Person as it will be auto-generated as GUID.

    Importing data from external sources (HR, ...) should use the object layer at all times (unless you know what you are doing) an not pure SQL.

  • 0 over 5 years ago

    Hello dear Markus

    Thank you for your replay.

    Kind regards

    Ferenc