Help Desk Software & Beyond
September 24, 2017, 04:57:37 AM *
Welcome, Guest. Please login or register.
To post messages you need to register. We apologize for inconvenience, but this is to prevent spam.
Registration is instant (no email verification) and we do not ask for any personal information.

Login with username, password and session length
News: Welcome to Help Desk Software forum!
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: [MOD] Bulk re-writing & moving of ticket data  (Read 2182 times)
Sparky
Moderator
Hero Member
*****

Karma: 85
Posts: 2,275


stop pushing all those buttons


View Profile
« on: November 07, 2007, 11:41:39 AM »

I wrote a module last week that searches ticket messages for a particular line of data and moves it into new fields in the header database

1.  It takes a range of ticket numbers as input.
2.  Looks at messages inside each one.
3.  If it finds the particular line of data, splits it & copies a portion into the header DB.
4.  Deletes the old line of data from the ticket message.
5.  Removes dead space (if any) from the top of the ticket message.

I added some new fields into my header database and wanted to correct the existing tickets automatically.  This module did the trick although it's one of those things that probably gets used once.

If anyone has a need for something similar, this module could easily be edited to do almost anything in the way of moving data around inside all your tickets at once.  Let me know and I'll post a copy here and add plenty of comments when I get a chance.

It uses standard TTX methods of retrieving and saving data so it should be compatible with both SQL and non-SQL installations.
« Last Edit: January 16, 2008, 05:26:47 PM by sparky672 » Logged

Did you update the paths in ttxcfg.cgi after moving TTX to your new location?   Undecided
To those seeking help.... please report back when you figure it out.  Cheesy
Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1 RC3 | SMF © 2001-2006, Lewis Media Valid XHTML 1.0! Valid CSS!
Page created in 0.014 seconds with 20 queries.