• Replies 10 replies
  • Subscribers 338 subscribers
  • Views 92 views
  • Users 0 members are here
Related

Automatically generate a CSI with imported data

Martin Keen (Past Member)
$organization

Folks,

I have a set of data to import.  That's the easy part. What I'd like to do is add a closed/resolved CSI to these records.  It'd be easy enough to compile these records into a list.

Is there a report or procedure about that will allow me to add such a CSI to members of a list in List Manager?

Any advise would be very gratefully received.

Martin



[edited by: Martin Keen at 10:42 PM (GMT -6) on 22 Nov 2009]
Parents
  • $organization

    Hi Martin,

    Good day.

    I think this topic should be separated into a few parts.

    1, create a CSI type for these records or use a current CSI type.

    2, insert the records into t_cust_activity table.

    normally you need to create a LT_cust_activity table to prepare these data before you insert them into t_cust_activity.

    there is a t_next_id item for t_cust_activity.

    SELECT     type, description, next_id, parent_table, parent_col, module
    FROM         T_NEXT_ID
    WHERE     (type = 'AC')

    3, create values in t_keyword, then it can be accessed by list manager.

    you may need to create views before insert values into t_keyword.

     

    I don't believe there is a report or a stored procedure can do all of these.

    So you have to do these one by one. These steps are customized areas, you have to do them by yourself.

     

    have fun.

    Ben

Reply
  • $organization

    Hi Martin,

    Good day.

    I think this topic should be separated into a few parts.

    1, create a CSI type for these records or use a current CSI type.

    2, insert the records into t_cust_activity table.

    normally you need to create a LT_cust_activity table to prepare these data before you insert them into t_cust_activity.

    there is a t_next_id item for t_cust_activity.

    SELECT     type, description, next_id, parent_table, parent_col, module
    FROM         T_NEXT_ID
    WHERE     (type = 'AC')

    3, create values in t_keyword, then it can be accessed by list manager.

    you may need to create views before insert values into t_keyword.

     

    I don't believe there is a report or a stored procedure can do all of these.

    So you have to do these one by one. These steps are customized areas, you have to do them by yourself.

     

    have fun.

    Ben

Children
No Data