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

Importing Data from Service Center to SQL using Connect-it

Importing Data from Service Center to SQL using Connect-it

Importing Data from Service Center to SQL using Connect-it

I am new to both Peregrine Service Center and Connect-it.  I am attempting to import data from Peregrine Service Center to qn SQL table using connect-it.  I have trouble with any data that has a field name the begins with a Dollar sign ($), i.e. $Description.  Does any one have any suggestions?

RE: Importing Data from Service Center to SQL using Connect-it

 Anything starting with a $ inside of ServiceCenter is a variable and is not a field.

 You'll find that a number of times when you're looking at data on screen inside of ServiceCenter, you're not looking at the raw data, but rather at a computed value based on that data. For example, when you look at the problem details form inside of ServiceCenter 3.0, you're really looking at a combination of the original problem description (saved in one field), and any past updates (saved in another).

  In order to display a computed value to you, the programmer will first compute the value, either in the RAD code, or in the Display format control, and then put the value in question on a form by setting a field's input name to the variable name.
  Computed values aren't stored into the ServiceCenter data store, so if you want to export them out by going after the ServiceCenter table structure, you're in a bit of a bind.

  Ultimately, of course, the computed value is based on other values which at some point have to be read out of the data store. If you know what the computed value is based upon, then you can just query out the raw data and then do the same computation yourself inside of your application.

  So, my question to you is this:

  What piece of information are you actually trying to export? I can probably point you at the right field name if you can tell me what you're exporting.

   Good Luck.

RE: Importing Data from Service Center to SQL using Connect-it

an example of one of the fields I would be trying to export is $pmc.details in the filename of problems.  Could you walk me through the steps in determining the actual field name.  I also tried to download the incidents.description field and received the follwoing error: "No target connector is able to process document based on document type 'incidents (incidentsSrc)'"  The peregrine definition is long text field.  I am attempting to put it into an SQL table with a text declaration.  

Thanks for your help.

RE: Importing Data from Service Center to SQL using Connect-it

$pmc.details is a temporary holding place for the update a person is making to a ticket.  The actual database fields are:

action - hold the original description put in the ticket on open.
update.action - holds the date/time/user stamped updates that have been made to a ticket by typing them into the field that has $pmc.details

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