Question

assystETM, Data Management Worksheet Duplicate Columns

  • 14 October 2022
  • 1 reply
  • 58 views
askey-s
Rank
Userlevel 1
Badge +4

When I extract Contact User data via the assystETM DMW generation process there are eight columns where the table data is duplicated under a difference column heading in the spreadsheet.  Why is this, please, and should they both be populated with the same value when wanting to import data?

The columns (Column Letter and Heading Value) are:

1st Column 2nd Column
L: Email M: Email Address
N: Home Tele O: Home Telephone
T: Office Extension V: Office Telephone Extension
X: Role Short Code AB: User Role Short Code
AF: Anet Licence AG: Anet License
AH: Assyst User Alias Short Code BZ: User Alias Short Code
BH: Middle Name BW: Surname
BT: Salutation BX: Title

 

This is in v1.5.1 of the assystETM, but it was also in v1.5.0.

1 reply

P
Rank
Userlevel 2
Badge +9

The columns in the DMW are derived from the assystREST schema. The REST properties & the derived DMW columns are both accessing the same underlying data.

The schema should annotate one of the properties as deprecated, and it does do this for Salutation (deprecated) & Title.

However, the DMW/ETM doesn’t honor this indicator. 

To import via a DM then either populate both columns with the same value, or remove one of the two columns. If different values are supplied then which value is saved is undefined & indeterminate.

In addition to the columns you have identified you will also find sla/default sla.

Reply


Terms & ConditionsCookie settings