From fab9a6506cd04ec8f840c98772a80c44a79c74a7 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 10 Dec 2008 16:52:52 +0000 Subject: MERGED r262:266 from branches/stuart02 to trunk to include new project structure. --- English.lproj/english_help/topics/dump.html | 93 ----------------------------- 1 file changed, 93 deletions(-) delete mode 100755 English.lproj/english_help/topics/dump.html (limited to 'English.lproj/english_help/topics/dump.html') diff --git a/English.lproj/english_help/topics/dump.html b/English.lproj/english_help/topics/dump.html deleted file mode 100755 index 99123b69..00000000 --- a/English.lproj/english_help/topics/dump.html +++ /dev/null @@ -1,93 +0,0 @@ - - -Sequel Pro Help - Data Dumps - - - - - - - - -
- - - - - - - - - -
- -

Data Dumps

-
- -
- -
- - Back to the main menu -
-
- - In order to perform actions with data dumps, you must use the "File->Import; File->Export" menu options of Sequel Pro. A variety -of exports/dumps can be performed: Sequel Pro dump, Export of Table Content Results (csv or xml format), Export of Custom -Query Results (csv or xml format), or Export of Multiple Table data (csv or xml format). On the other hand, you can only import a -Sequel Pro dump or a CSV file. -
-
-CSV File Format Information - - - - -
- -
    -
  • You can choose the following characters: fields enclosed, fields terminated, escaped and line ends
    • -
  • The following characters are escaped: the escaped-character itself, the line ends character, the enclosed character (if given) and the fields terminated character if no enclosed character is given
    • -
  • NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.
    • -
  • When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)
    • -
  • The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer).
    • -
-
- -
-Importing Dumps - - - - -
- -
    -
  • Choose "File->Import" from the Sequel Pro Menu
    • -
  • You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)
    • -
-
- - -
-Excel CSV Formatting Options -
-If you wish to export data to a CSV file for use in Excel, use the following settings: - - - - -
- -
    -
  • Enclosed by: " (single quote)
    • -
  • Escaped by: " (single quote)
    • -
  • Line ends: \r (for Macs)
    • -
  • Delimiter: , (comma)
    • -
-
- - - - - \ No newline at end of file -- cgit v1.2.3