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!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Mappings Question

Status
Not open for further replies.

Katy137

Programmer
Feb 25, 2010
1
0
0
GB
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
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top