DataBase-Structure and direct SQL Access
Hello,
could you help me to get information about the database structure related to the requests and replies. We want to import some data into the SC+ and want to import additional information.
At first, I want to know what I have to insert into which table to create a request for a supporter. Where are the relations between tables and how is the structure built up?
The next I would like to know, where I have to access (which db-table) to get the related talk (as replies) between customer and supporter for a request.
In additional to this, I want to import existing data (tickets;requests,etc) into the SC+, because we want to change to SC+. I mean, is there a possibility to insert 20500 tickets via import tool? If yes: how? If no: could you explain where we have to insert the data via mysql inserts (automaticly script we would develope).
thank you very much.
could you help me to get information about the database structure related to the requests and replies. We want to import some data into the SC+ and want to import additional information.
At first, I want to know what I have to insert into which table to create a request for a supporter. Where are the relations between tables and how is the structure built up?
The next I would like to know, where I have to access (which db-table) to get the related talk (as replies) between customer and supporter for a request.
In additional to this, I want to import existing data (tickets;requests,etc) into the SC+, because we want to change to SC+. I mean, is there a possibility to insert 20500 tickets via import tool? If yes: how? If no: could you explain where we have to insert the data via mysql inserts (automaticly script we would develope).
thank you very much.