From 1d0c281511ce7b35c7e06475d7e147db5a656575 Mon Sep 17 00:00:00 2001 From: stuconnolly Date: Wed, 23 Sep 2009 13:29:10 +0000 Subject: Rename (currently unused) help folder. --- Interfaces/English.lproj/Help/topics/dump.html | 93 ++++++++++++++++++++++++++ 1 file changed, 93 insertions(+) create mode 100755 Interfaces/English.lproj/Help/topics/dump.html (limited to 'Interfaces/English.lproj/Help/topics/dump.html') diff --git a/Interfaces/English.lproj/Help/topics/dump.html b/Interfaces/English.lproj/Help/topics/dump.html new file mode 100755 index 00000000..99123b69 --- /dev/null +++ b/Interfaces/English.lproj/Help/topics/dump.html @@ -0,0 +1,93 @@ + + +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