[rt-users] Urgent request for aid - Set created date on import?

[Kenneth Crocker]

Aaron,


	OPPS! Sorry, I didn't realize that created was off-limits in the bulk 
update. Bad assumption on my part. I go for SQL code. easier to do it in 
the DB and that way you don't have to wonder what RT is gonna do in 
other places or whatever.


Kenn
LBNL

On 4/9/2008 11:09 AM, Aaron Sallade wrote:
> Hi all,
> 
> We are down to the last little hurdle for an import of 20,000 tickets
> from a commercial system. I need to be able to set the Created date, as
> opposed to it showing as created Now(). I currently have the value in
> "Starts" so if it can be done from a scrip it may work, otherwise a
> direct db change may be the only way to go.
> 
> Ideas?
> 
> Aaron Sallade'
> Application Manager
> PTSO of Washington
> "Shared Technology for Community Health"
> (206) 613-8938 Desk
> (206) 521-8833 Main
> (206) 613-5078 Fax
> asallade at ptsowa.org
> 
> 
> _______________________________________________
> http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
> 
> Community help: http://wiki.bestpractical.com
> Commercial support: sales at bestpractical.com
> 
> 
> Discover RT's hidden secrets with RT Essentials from O'Reilly Media. 
> Buy a copy at http://rtbook.bestpractical.com
>