Export Mappings Question

Katy137 · Feb 25, 2010

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

AlmostMe · Feb 25, 2010

Yes, NICE have only completed that functionality for specific recorder types.

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

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Export Mappings Question

Katy137

Programmer

AlmostMe

Technical User

Similar threads

Part and Inventory Search

Sponsor