Export Mappings Question
Export Mappings Question
(OP)
Hi,
I'm trying to export mappings under channel mapping in r3.1.
I see recieve the following error message.
'Export Mappings is complete, but not all mappings were exported. Press OK and verify the loggers that were not exported.'
When I close this error message I then see. 'Mappings from the following loggers were not exported because the recording type is not yet supported'.
Can anyone shed any light on this error message?
We use Static Mapping and I've been asked to export the data in the summary field.
Thanks in advance.
Katy
I'm trying to export mappings under channel mapping in r3.1.
I see recieve the following error message.
'Export Mappings is complete, but not all mappings were exported. Press OK and verify the loggers that were not exported.'
When I close this error message I then see. 'Mappings from the following loggers were not exported because the recording type is not yet supported'.
Can anyone shed any light on this error message?
We use Static Mapping and I've been asked to export the data in the summary field.
Thanks in advance.
Katy
Talk To Other Members
RE: Export Mappings Question
Try the following SQL Script:
use nice_Admin
SELECT DISTINCT tblSystemResource.vcResourceName[Logger Name],
tblSystemResource.nvcInternalId[LG Serial Num],
tblSystemResource.vcLocation[LG Machine Name],
tblCLSCMChannel.iChannelNumber[LG Channel],
tblCLSCMSource.nvcDeviceNumber[Extension]
--tblCLSCMStaticMapping.iChannelID,
--tblCLSCMStaticMapping.iSourceID,
--tblCLSCMSource.iSWitchID
FROM tblCLSCMStaticMapping,
tblCLSCMSource,
tblCLSCMChannel,
tblSystemResource
WHERE tblCLSCMStaticMapping.iDeletionVersionID is NULL
and tblCLSCMSource.iSourceID = tblCLSCMStaticMapping.iSourceID
and tblCLSCMChannel.iChannelID = tblCLSCMStaticMapping.iChannelID
and tblCLSCMChannel.nvcLoggerResourceID = tblSystemResource.iResourceID
ORDER BY tblCLSCMChannel.iChannelNumber