×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Export Mappings Question

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

RE: Export Mappings Question

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close