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
We have a report for adding CSIs that Matt Cooper at JCA built for us when they helped us install Tessitura.
Lucie Spieler
Florida Grand Opera
From: Tessitura Technical Forum [mailto:forums-technical@tessituranetwork.com] On Behalf Of Martin Keen Sent: Sunday, November 22, 2009 11:42 PM To: Lucie Spieler Subject: [Tessitura Technical Forum] Automatically generate a CSI with imported data
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.
This message was sent automatically to you by www.tessituranetwork.com because you subscribed to the Tessitura Technical Forum. You may reply to this message to post to the Technical forum or visit the site to search, read and post to the forums. In the interest of keeping the forum posts from becoming cluttered, we encourage you to delete previous message text from your reply before sending. Thank you!
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, moduleFROM T_NEXT_IDWHERE (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
Many thanks to you both for replying.
Lucy, is there a possibility you'd be prepared to share the report?
HI Martin,
did you still need a report like this? I just created something today because we needed a away to on mass assign the nscan csi. Let me knwo I would be happy to share.
Jon
Hi Jon,
Could you send me on your insert CSI report if you still have it.
I have a bulk insert of CSI's to do.
Email is: dara.hogan@abbeytheatre.ie
many thanks,
Dara
How did you set up this report? We are looking to mass assign an nscan csi message to all patrons that have a certain constituency on their account.
Does your bulk add utility allow for variations in things like performance code? Or is it limited to everyone on the list getting the exact same data? We are currently loading Nscan CSI's through the back end covering a run of 50 performances, but it would be great to be able to do this through the front end if we could be loading the performance code too.
Thanks for your help.
Dale
Is this still relevant? We want to assign an CSI on mass. I looked in shared reports but couldn't find anything.
Thanks,
Carol
We have something that you might be interested in seeing. Creates mass CSI's from a list. If you are interested email me.
Travis
Here... Test, test, test. The report parameters are drop downs. Notes you type directly into. This does not use imported data, but will create identical Csi's in mass.
http://www.tessituranetwork.com/Community/members/travisarmbuster9061/files/CSI-BULK-REPORT.zip.aspx