Well, this is a classic example of "...your mileage may vary..." I find it extraordinarily easy to use the built in reports with minimal data manipulation. Perhaps your trouble was caused by using the .csv format rather than the .xls. Of course, familiarity with the product probably makes it easier.
Five minutes of cleanup and then import the salient features directly into Remedy seems like a pretty good way to do this. Maybe had you taken the easy route, you would have had a better experience. Yours truly, Charles H. Roberts, 4th Riverside County Information Technology Office: 951-486-7780 Cell: 951-840-8699 eMail: crobe...@riversidecountyit.org<mailto:crobe...@riversidecountyit.org> From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of strauss Sent: Wednesday, September 29, 2010 8:32 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** Remember that Kinetic Survey and Kinetic Request are the same application with different license keys. When it comes to $$$, Kinetic Request is _significantly_ less expensive than SRM (and far easier to implement and maintain). We got our value from the Request side of the app, and only bought the Lite license for Survey - which may be all that you need to implement a follow-up survey process. The Kinetic apps ARE Remedy apps - everything they do is inside the ARSystem database, so direct integration to ITSM or a custom app is relatively easy. The web portal is NOT a mid-tier app, which allows it to work with a wider range of browsers, so it makes for a VERY effective customer portal and service catalog. Survey Monkey is a foreign app to Remedy, and I had to spend six months prying data out of it and forcing it into a usable form when I did my dissertation research, and I was NOT impressed. We license it in various departments at the university for quick and dirty surveys with an easy to use question development interface, but the data side of it is filthy. When you download data to .csv for import into a database like MS Access, ultimately for import into SPSS (the Excel spreadsheet formats are difficult to use for that), it re-defines the column IDs for the questions and responses in ways that add hours to process of combining data sets. If you don't mind a lot of manual hand-jamming of data into a usable format, it does provide excellent questionnaire development and user tracking - that's why we use it! On the other hand, it would be my _last_ choice for "integration" into a Remedy app, based on my experience with the data it produces. Christopher Strauss, Ph.D. Call Tracking Administration Manager University of North Texas Computing & IT Center http://itsm.unt.edu/ From: Action Request System discussion list(ARSList) [mailto:arsl...@arslist.org] On Behalf Of Roberts, Chas Sent: Wednesday, September 29, 2010 10:07 AM To: arslist@ARSLIST.ORG Subject: Re: Survey Monkey ** I took the time to call Kinetic Data and at a base price of $12,500.00 per Remedy server per year, it is easy to understand why Kinetic Data does not post the price on their website. It took five calls to even get someone on the phone. They are a voicemail organization. I cannot imagine paying 6,250% more for this solution, especially in this economy. What could possibly justify such an exorbitant expense, when the same functionality is available for $200 (not even tied to server count - flat $200 for any and all usage per year?) Sure it may integrate directly with Remedy, but Survey Monkey is at least as customizable and easy to implement and use. In fact from the look at Kinetic Data's website, Survey Monkey has them beat in all respects "look & feel" wise. Can it be worth $12,500.00 per server per year to avoid manually importing Excel data? ________________________________ This email is confidential and intended solely for the use of the individual(s) to whom it is addressed. The information contained in this message may be privileged and confidential and protected from disclosure. If you are not the author's intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please delete all copies, both electronic and printed, and contact the author immediately. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
