Database selected users export

Huckly · **Database selected users export -** 17-04-2008, 02:29 PM

Hello All,

I wonder if somebody can help me. I need actually to export somehow users registered on our eSupport to a file and then import the into different eSupport.

Is there a way haw can I example select user from let say only from US, export then to external file and use it in another eSupport (so import them in other eSupport database).

I'm really just beginner in Kayako and MySQL, so I would really apreciate any help on this.

Our current version of eSupport is 3.10.00.

Many thanks for help.

Huckly · 18-04-2008, 02:25 PM

Any suggestions?

Huckly · 22-04-2008, 09:36 AM

Hello,

Does it mean this is not possible to do? I would really appreciate if somebody can help with this.

Please. Thx

craigbrass · 22-04-2008, 10:17 AM

You could go into the swusers table in phpMyAdmin and export as a CSV file.

Huckly · 22-04-2008, 10:24 AM

I have already tried something similar with the "MySQL Browser", however there is no an option to select only certain users (example from US) from the "swusers" table. Also this table doesn't include all information related to the registration. Example all email addresses are in "swuseremail" table.

Also I have checked with "Kayako Chat" just a few min ago and it's seems like its not possible to do such a task.

As I'm not MySQL expert I do not know.

jaigupta · 22-04-2008, 11:06 AM

Kayako does not store user's country in database (I was not able to find it). Do you remember kayako asking for country from your user. In case it does then it must be storing it somewhere but I feel this is not in case with default kayako, if you have enabled extra fields then I can't say.

Huckly · 22-04-2008, 11:51 AM

Sorry for misunderstanding.

What I meant, was to select/export only certain users. Example user which email address ending by example by ".co.uk". I would like to export those selected users which have registered on one eSupport site and import them to another one.

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Extra Users showing in Database Table	sdwhite	SupportSuite, eSupport and LiveResponse	5	04-02-2008 05:20 PM
Free Increasing available information on 'edit users' page	deeps	Modifications & Addon Releases	5	26-10-2007 01:59 PM
Validated Users are removed or unvalidated?	PeteV	SupportSuite, eSupport and LiveResponse	7	23-10-2007 08:51 PM
Users -> Bulk add users to group	no0ne2k	End-user related	0	18-09-2007 05:01 PM
Auto Group Users	no0ne2k	SupportSuite, eSupport and LiveResponse	1	09-09-2007 12:30 PM

Huckly Offline New Member Posts: 5 Join Date: Jan 2007	18-04-2008, 02:25 PM Any suggestions?

Huckly Offline New Member Posts: 5 Join Date: Jan 2007	22-04-2008, 09:36 AM Hello, Does it mean this is not possible to do? I would really appreciate if somebody can help with this. Please. Thx

craigbrass Offline Senior Member Posts: 6,753 Join Date: Jun 2005 Location: Cumbria, UK	22-04-2008, 10:17 AM You could go into the swusers table in phpMyAdmin and export as a CSV file. Craig Brass - Kayako Forum Squatter (Note: I am NOT a staff member) My Addons: BlackBerry Ticket Client for Kayako - Windows Mobile Live Support Client for Kayako

jaigupta Offline Member Posts: 83 Join Date: Apr 2008	22-04-2008, 11:06 AM Kayako does not store user's country in database (I was not able to find it). Do you remember kayako asking for country from your user. In case it does then it must be storing it somewhere but I feel this is not in case with default kayako, if you have enabled extra fields then I can't say.

Huckly Offline New Member Posts: 5 Join Date: Jan 2007	22-04-2008, 11:51 AM Sorry for misunderstanding. What I meant, was to select/export only certain users. Example user which email address ending by example by ".co.uk". I would like to export those selected users which have registered on one eSupport site and import them to another one.