Ticket design export/import?

I see that nobody has answered this question - and it's been more than eight years since it was asked, so I'm assuming that very few, if any members are doing this. We are interested in doing the same, as we use variables in a lot of the ticket designs for perf and other data so that we can minimize the number of designs we need to create. They take way to long using a visual editor. If we were able to simply create the file using Boca Ghost language, this would be simple.

To export the ticket information, we need the ticket design number. The following SQL query will provide the results needed from the TX_DESIGN_ELEMENT table for the export:

DECLARE @DesignNo int

SET @DesignNo = ''  --Enter the ticket design number between the ''. This can be found in the Ticket Design List in Ticketing Setup

SELECT * FROM TX_DESIGN_ELEMENT

WHERE [DESIGN_NO] = @DesignNo

You can then save the results as a CSV file for use in importing the ticket details.

Where I'm running into issues is importing the results into the TX_DESIGN_ELEMENTS table in the target database (which is in a different server instance). I think, because the first two fields in the table are Primary Key (PK) fields and those fields are Clustered (index) fields, the Import Wizard runs into an issue. At this point I'm still researching how to get around the issue and get the data into the table without having to use a Values list (which does seem to work and is a very tedious process).

If anyone else has tried to do this and has had some success, please let me know how you did it. Until then, I'm going to do some more research into this and, quite possibly, build a utility to do this, so that we don't have to create all of our designs in LIVE.I should also mention that we are in the hosted (RAMP) environment, so I don't have complete Admin rights to the server, just on the database.

Maybe just this little piece will help someone else with a similar need.

Phil Parks