How to Import Customer Records Into OTRS from CSV

Thanks to Mike Dent’s efforts and OTRS, we now know how a CSV file can be imported into the MySQL database directly. Here is the sample code:

mysql> load data infile '/tmp/otrs_test.txt' into table customer_user
fields terminated by '\t' lines terminated by '\r' (first_name,
last_name, address, postcode, phone1, email, customer_id, valid_id,
create_time, create_by, change_time, change_by, login);

Make sure to import all the required fields (that is, the ones that the database requires, see the table schema for details, >show table x;)

Posted under Freeware, MySQL, WebDev

This post was written by Content Curator on November 16, 2009

Tags: , , , , , , , , , , , , , , , , , , ,

How to Show MySQL Warnings at CLI

When logged in to the MySQL server using the command line interface (CLI) theĀ  generated errors on the previously run command.

mysql> show warnings;

Thanks to Trevor Nichols and www.issociate.de

Posted under Freeware, MySQL

This post was written by Content Curator on November 16, 2009

Tags: , , , , , , , , , , , ,

Firefox tip: Moving tabs between Firefox windows

So, you have two or more Firefox main windows open, and you need to close Firefox, but you’ll lose Firefox’s memory of all tabs in windows that are not the last one closed. Bummer.

This process assumes that you have Firefox set to “show my tabs from last time”.
Well, there are two ways to fox this. One is easy and requires no plugins. Here is the process:

  1. Pick one firefox window to be the recipient of all tabs. Maximize that window, or at least make it so you can see the tab bar, and it is near the top of your screen.
  2. By clicking on its icon on the Windows taskbar, open the other window that has tabs you want to save.
  3. Make sure that this second Firefox window is not maximized, and is small enough so that you can see the original Firefox window’s tab bar.
  4. Now, drag tabs from the second, smaller Firefox window, and drop them above on the original, bigger Firefox’s tab bar. NOTE: Read the next step too.
  5. If the original Firefox’s tab bar is full, or if it fills up as you drop tabs on it, then you can continue dropping tabs on the right-arrow button at the extreme right of the Firefox tab bar.
  6. Repeat step 4 for all tabs that you want to keep.
  7. Close the second, smaller Firefox window.
  8. Repeat steps 2 through 7 for any other Firefox windows that you want to retrieve tabs from.
  9. Make sure that only your one main Firefox window is open. Now close it. It will remember all those tabs you put into it now.

The second way to make this happen in the future is to download the Session Manager plugin for Firefox.

Posted under Browsers, Freeware

This post was written by Content Curator on October 17, 2007

Tags: , , , , , , , , , , , , , , , , , ,