aboutsummaryrefslogtreecommitdiffstats
path: root/Interfaces/English.lproj/Help/topics/dump.html
diff options
context:
space:
mode:
Diffstat (limited to 'Interfaces/English.lproj/Help/topics/dump.html')
-rwxr-xr-xInterfaces/English.lproj/Help/topics/dump.html93
1 files changed, 93 insertions, 0 deletions
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 @@
+<html>
+<head>
+<title>Sequel Pro Help - Data Dumps</title>
+<meta name="AppleTitle" content="Data Dumps">
+<meta name="AppleFont" content="Lucida Grande">
+<meta ROBOTS="robots" CONTENT="anchors">
+</head>
+<body text="#000000" link="#0000FF" alink="#0000FF" vlink="#0000FF" topmargin="0" leftmargin="0" marginwidth="0" marginheight="0">
+
+<font face="Lucida Grande,Geneva,Arial">
+
+<br>
+
+<table border="0" cellpadding="0" cellspacing="0" width="100%" height="80">
+ <tr>
+ <td align="left" valign="top" width="70">
+ <img src="sequel-pro_logo.jpg" width="60" height="60" border="0">
+ </td>
+ <td align="left"><h1>Data Dumps</h1>
+ </td>
+ </tr>
+ <tr>
+ <td colspan="2">
+ <img src="bar.gif" width="100%" height="20">
+ </td>
+ </tr>
+</table>
+
+<br>
+<font size="-1">
+&nbsp;<a href="../index.html">Back to the main menu</a>
+<br>
+<br>
+
+&nbsp;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.
+<br>
+<br>
+<b>CSV File Format Information</b>
+<table border="0" cellpadding="5" cellspacing="0" width="100%">
+ <tr>
+ <td bgcolor="#fff8dc" valign="top">
+ <font size="-1" face="Lucida Grande,Geneva,Arial">
+ <ul>
+ <li>You can choose the following characters: fields enclosed, fields terminated, escaped and line ends</li>
+ <li>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</li>
+ <li>NULL values are written without enclosed character. If it is enclosed, it is interpreted as a string.</li>
+ <li>When importing a csv, unenclosed \N is also interpreted as NULL (this format is used by mysqldump)</li>
+ <li>The recommended formats should work best. When importing, enclosed/terminated/escaped characters should be all only one character long (line ends may be longer). </li>
+ </ul>
+ </td>
+ </tr>
+</table>
+
+<br>
+<b>Importing Dumps</b>
+<table border="0" cellpadding="5" cellspacing="0" width="100%">
+ <tr>
+ <td bgcolor="#fff8dc" valign="top">
+ <font size="-1" face="Lucida Grande,Geneva,Arial">
+ <ul>
+ <li>Choose "File->Import" from the Sequel Pro Menu</li>
+ <li>You must choose to import a CSV file (table data) or a Sequel Pro dump (varied information)</li>
+ </ul>
+ </td>
+ </tr>
+</table>
+
+
+<br>
+<b>Excel CSV Formatting Options</b>
+<br>
+If you wish to export data to a CSV file for use in Excel, use the following settings:
+<table border="0" cellpadding="5" cellspacing="0" width="100%">
+ <tr>
+ <td bgcolor="#fff8dc" valign="top">
+ <font size="-1" face="Lucida Grande,Geneva,Arial">
+ <ul>
+ <li>Enclosed by: " (single quote)</li>
+ <li>Escaped by: " (single quote)</li>
+ <li>Line ends: \r (for Macs)</li>
+ <li>Delimiter: , (comma)</li>
+ </ul>
+ </td>
+ </tr>
+</table>
+
+</font>
+
+</body>
+</html> \ No newline at end of file