SM Request Import Utility - setting visibility of Historic Updates

[Martyn Houghton]

@Steve G

Looking a the configuration file for the Service Manager Request Import, visibility does not appear to the be included in the configuration options. As it is now possible to display historic updates on the customer portal, we need to ensure we carry over the appropriate visibility of the update in the import. 

Am I missing something or is this not supported by the current version?

Cheers

Martyn

[Steve G]

Hi @Martyn Houghton,

This is set using the h_updatetype property of the HistoricUpdateMapping section within the import config. This is an integer column, and the code looks for particular bits being set against the integer using bitwise operators to work out the update type and visibility for each row.

Essentially, setting bit 1 marks the historic update type as User, and 512 marks a historic update as private, so setting the integer as 513 will be a private user update.

This old post comment from the Supportworks forum describes the values in more detail:

Kind regards,

Steve

[Martyn Houghton]

@Steve G

Thanks for the pointer. I trying to remember the Suportworks schema to translate what we need to submit to the generic importer.

Cheers

Martyn