|
<html>
<head>
<title>Comma Separated Value file loader</title>
<meta http-equiv="pragma" content="no-cache">
<h3>Comma Separated Value File Loader</h3>
</head>
<body>
<p>
<h4>Instructions</h4>
Before using this page:
<ul><li>Create a comma separated values (.csv) file containing your data. You can create this type of file
using Excel (Save as .csv), a text editor, or other tools.</li>
<li>One line of the .csv file corresponds to a row in the database.</li>
<li>Data values are separated by commas. Values containing spaces or or commas should be enclosed
in <b>double quote</b> characters ("). This program will convert to SQL format by putting
single quotes around data values and substituting two single quotes for apostrophes within the data.</li>
<li>Data formats must be compatible between the .csv file and Oracle table. Number values must not contain
letters. For dates, change the Excel date format to the Oracle date format: yyyy-mm-dd.</li>
<li>The first line of the .csv file must contain the Oracle column names for each column in the .csv file.
There must be the same number of names and data columns. Column names must appear in the same order as the data
values in the .csv file; this sequence may be different from the column sequence in Oracle.</li>
<li>Use WS_FTP to load your comma separated value (.csv) file into your AOL
server directory:<br>
/home/web/usf-acs/www/student/your-account/</li>
<li>Create the Oracle table where you want to load the data.</li>
<li>Issue a Grant in SQL Plus to allow user AD to access your table.</li></ul>
To load your data:<p><ul>
<li>Enter your user account.</li>
<li>Enter the file name with the extension. File names are case sensitive. Do not specify the directory,
files will read from your account under:<br>
/home/web/usf-acs/www/student/your-account/</li>
<li>Enter the name of the Oracle table where you want to insert the data into. Be sure you have done
a Grant to AD.<br>
Do not prefix the table name with your account name, that will be added automatically.</li>
<li>Note that:<ul>
<li>The .csv file must not contain any newline characters
(also known as enter key, carriage return, paragraph marks, etc.) within data fields. Newline characters
may result if data was collected in multi-line forms. Newlines will garble the data from the rest
of the file.</li>
<li>Blank lines in the .csv file, or lines containing only commas and blanks, will not be inserted
into the database.</li>
<li>As the file is processed you will see the data displayed and a message describing any errors.</li></ul></ul>
<p>
<form method=get action="csv-2.adp">
Your Account: <input type=text name=account value="" size=30><br>
File Name: <input type=text name=file size=30><br>
Table Name: <input type=text name=table size=30><p>
<input type=submit value="Load File">
</form>
<p><hr>
</body>
</html>
|
