<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head>
<body>
<p dir="ltr">Thank you I think you have a great suggestion. </p>
<div class="gmail_extra"><br>
<div class="gmail_quote">On Sep 9, 2016 3:19 PM, Landon Stewart <lstewart@internap.com> wrote:<br type="attribution">
<blockquote class="quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<div style="word-wrap:break-word">If you formulate the email with the "From:" as the requestor it would set it accordingly in the ticket. If RT is set to produce auto-replies though they'd get that auto-reply.
<div><br>
</div>
<div>
<div>
<blockquote>
<div>On Sep 9, 2016, at 11:51 AM, Dunbar, Brian <<a href="mailto:Brian.Dunbar@von.ca">Brian.Dunbar@von.ca</a>> wrote:</div>
<br>
<div>
<div style="font-family:'helvetica';font-size:18px;font-style:normal;font-weight:normal;letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px">
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif;color:rgb( 31 , 73 , 125 )">I can format the csv anyway as desired but importing as email will make me the requester for every ticket?</span></div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif;color:rgb( 31 , 73 , 125 )"> </span></div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<a name="_MailEndCompose"><span style="font-size:11pt;font-family:'calibri' , sans-serif;color:rgb( 31 , 73 , 125 )"> </span></a></div>
<div>
<div style="border-style:solid none none;border-top-color:rgb( 181 , 196 , 223 );border-top-width:1pt;padding:3pt 0cm 0cm">
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<b><span style="font-size:10pt;font-family:'tahoma' , sans-serif">From:</span></b><span style="font-size:10pt;font-family:'tahoma' , sans-serif"> Landon Stewart [<a href="mailto:lstewart@internap.com">mailto:lstewart@internap.com</a>] <br>
<b>Sent:</b> Friday, September 9, 2016 2:38 PM<br>
<b>To:</b> Dunbar, Brian<br>
<b>Cc:</b> <a href="mailto:rt-users@lists.bestpractical.com">rt-users@lists.bestpractical.com</a><br>
<b>Subject:</b> Re: [rt-users] import tickets from csv file</span></div>
</div>
</div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
</div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
What kind of columns does the CSV have? May it's possible to simply convert each record in the CSV to an email and use rt-mailgate?</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
</div>
<div>
<blockquote style="margin-top:5pt;margin-bottom:5pt">
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
On Sep 9, 2016, at 10:28 AM, Dunbar, Brian <<a href="mailto:Brian.Dunbar@von.ca" style="color:purple;text-decoration:underline">Brian.Dunbar@von.ca</a>> wrote:</div>
</div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
</div>
<div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif">Hello All,</span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif"> </span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif">I have a new 4.4 install of RT and I would like to import tickets from another ticket system (Spiceworks). I can get the ticket info in a csv file to import but I have not found a script that works
to populate RT with the info. I found a script by Alister West (<a href="https://alisterwest.com/code/perl-rt-import-tickets" style="color:purple;text-decoration:underline"><span style="color:purple">https://alisterwest.com/code/perl-rt-import-tickets</span></a>)
but it did not work and it was made for RT4.0 I do not know perl enough to write my own script. So hopefully there is something out there that works and can be shared.</span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif"> </span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif">Regards<br>
Brian</span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'calibri' , sans-serif"> </span></div>
</div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-size:11pt;font-family:'helvetica' , sans-serif">---------<br>
RT 4.4 and RTIR training sessions, and a new workshop day! </span><a href="https://bestpractical.com/training" style="color:purple;text-decoration:underline"><span style="font-size:11pt;font-family:'helvetica' , sans-serif;color:purple">https://bestpractical.com/training</span></a><span style="font-size:11pt;font-family:'helvetica' , sans-serif"><br>
* Boston - October 24-26<br>
* Los Angeles - Q1 2017</span></div>
</div>
</blockquote>
</div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
</div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-family:'arial' , sans-serif">--</span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-family:'arial' , sans-serif">Landon Stewart</span></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
<span style="font-family:'arial' , sans-serif">Lead Analyst - Abuse and Security Management<br>
</span><b><i><span style="font-family:'arial black' , sans-serif">INTERNAP</span></i></b><span style="font-family:'arial' , sans-serif"> </span><sup><span style="font-family:'arial' , sans-serif">®</span></sup></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
📧 <a href="mailto:lstewart@internap.com" style="color:purple;text-decoration:underline">lstewart@internap.com</a></div>
</div>
<div>
<div style="margin:0cm 0cm 0.0001pt;font-size:12pt;font-family:'times new roman' , serif">
� <a href="http://www.internap.com/" style="color:purple;text-decoration:underline">www.internap.com</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</blockquote>
</div>
<br>
<div>
<div style="color:rgb( 0 , 0 , 0 );letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div style="color:rgb( 0 , 0 , 0 );letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div style="color:rgb( 0 , 0 , 0 );letter-spacing:normal;text-indent:0px;text-transform:none;white-space:normal;word-spacing:0px;word-wrap:break-word">
<div style="text-indent:0px;word-wrap:break-word">
<div style="text-indent:0px;word-wrap:break-word">
<div style="text-indent:0px;word-wrap:break-word">
<div style="margin-top:0px;margin-bottom:0px">
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:'arial'">--</span></div>
<div style="margin-top:0px;margin-bottom:0px"><span style="font-family:'arial'">Landon Stewart</span></div>
<div style="margin-top:0px;margin-bottom:0px"><font face="Arial">Lead Analyst - Abuse and Security Management<br>
</font><b><i><span style="font-family:'arial black'">INTERNAP</span></i></b><span style="font-family:'arial'"> <sup>®</sup></span></div>
<div style="margin-top:0px;margin-bottom:0px">📧 <a href="mailto:lstewart@internap.com">lstewart@internap.com</a></div>
<div style="margin-top:0px;margin-bottom:0px">� <a href="http://www.internap.com">www.internap.com</a></div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
</div>
<br>
</div>
</div>
</blockquote>
</div>
<br>
</div>
</body>
</html>