aboutsummaryrefslogtreecommitdiffstats
path: root/Resources/Help/topics/dump.html
diff options
context:
space:
mode:
Diffstat (limited to 'Resources/Help/topics/dump.html')
-rwxr-xr-xResources/Help/topics/dump.html93
1 files changed, 0 insertions, 93 deletions
diff --git a/Resources/Help/topics/dump.html b/Resources/Help/topics/dump.html
deleted file mode 100755
index 99123b69..00000000
--- a/Resources/Help/topics/dump.html
+++ /dev/null
@@ -1,93 +0,0 @@
-<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