Razzmataz73
asked on
Get values from csv file using php
Hello,
I have a csv file located at:
http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV
I want to use PHP to search it and return the row results.
How would I do that?
Thank you.
-Heather
I have a csv file located at:
http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV
I want to use PHP to search it and return the row results.
How would I do that?
Thank you.
-Heather
Member_2_732957
Look at Example #1 there http://php.net/manual/en/function.fgetcsv.php
1. You want to searchit for what?
2. What results do you want returned and how (i.e table, list, CSV)?
2. What results do you want returned and how (i.e table, list, CSV)?
ASKER
I want to search for the value in the K column (if you view it in excel) for example Moorings 372 - Club and then have it bring back that rows results.
But I only want it to display some of that rows data (not just a flat print of the entire thing).
But I only want it to display some of that rows data (not just a flat print of the entire thing).
OK, so what of that row's data do you want displayedi.e in excel, what are the columns? (I am assuming here that you want the data for those rows returned in html)
ASKER
I want it to say (in html) something like this for displaying these columns:
Trip Start Date: Column E
Trip End Date: Column F
Booking Start Date: Column G
Booking End Date: Column H
Trip Duruation: Column I
Yacht Name: Column K
People: Column L
Cost: Column N
Trip Start Date: Column E
Trip End Date: Column F
Booking Start Date: Column G
Booking End Date: Column H
Trip Duruation: Column I
Yacht Name: Column K
People: Column L
Cost: Column N
heres is some code (un-tested)
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
while (($row = fgetcsv($file)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<td>".$line[5]."</td>" ."<td>".$line[6]."</td>" ."<td>".$line[7]."</td>" ."<td>".$line[8]."</td>"
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td>";
}
}
Actually, I think this is better
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
while (($row = fgetcsv($file)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>" ."<td>".$line[6]."</td>" ."<td>".$line[7]."</td>" ."<td>".$line[8]."</td>"
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></tr>";
}
}ASKER
I put the sample code into the page:
http://www.visailing.com/_testing/data-feed/feed.php
But it just times out.
Here is the code on that page (am I missing something?)
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "Results <table>";
while (($row = fgetcsv($file)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
}
}
echo "</table>";
?>
http://www.visailing.com/_testing/data-feed/feed.php
But it just times out.
Here is the code on that page (am I missing something?)
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "Results <table>";
while (($row = fgetcsv($file)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
}
}
echo "</table>";
?>
the file is probably too big. Fortesting, first try
<?
$file = "../tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "Results <table>";
while (($row = fgetcsv($file, 1000)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>" ."<td>".$line[6]."</td>" ."<td>".$line[7]."</td>" ."<td>".$line[8]."</td>"
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></tr>";
}
}
echo "</table>";
?>
I did not look at the code properly, if you want to echo the resuts as you iterate through them then rather than put themin the $Result array, then echo them there and then, i.e
echo "<tr><td>".$line[5]."</td>" ."<td>".$line[6]."</td>" ."<td>".$line[7]."</td>" ."<td>".$line[8]."</td>"
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></tr>";
Actually, fgetcsv splits the lines as it reads them, thus you will not need to explode as in the code example given above. Modify it to remove the "explosion" to:
<?
$file = "../tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "<table>";
while (($row = fgetcsv($file, 1000)) !== FALSE)
{
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>" ."<td>".$row[6]."</td>" ."<td>".$row[7]."</td>" ."<td>".$row[8]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></tr>";
}
}
echo "</table>";
?>ASKER
Now it just shows the word Results but with no value
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "Results <table>";
while (($row = fgetcsv($file, 1000)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
echo "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
}
}
echo "</table>";
?>
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "Results <table>";
while (($row = fgetcsv($file, 1000)) !== FALSE)
{
$line = explode(',', $row);
if( FALSE !== array_search($xCode, $line) ){
$Result[] = "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
echo "<tr><td>".$line[5]."</td>
."<td>".$line[9]."</td>" ."<td>".$line[11]."</td>" ."<td>".$line[12]."</td>" ."<td>".$line[14]."</td></
}
}
echo "</table>";
?>
Check the last code I gave you, i.e
<?
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
$Result = array();
echo "<table>";
while (($row = fgetcsv($file, 1000)) !== FALSE)
{
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>" ."<td>".$row[6]."</td>" ."<td>".$row[7]."</td>" ."<td>".$row[8]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></tr>";
}
}
echo "</table>";
?>ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Hi, Heather. We usually do not need over 10,000 lines of test data. A few dozen carefully chosen lines with mainstream examples and edge cases will almost always suffice. I notice that there are a few blank lines in the file, too.
Where did this enormous CSV file come from? It looks like something that should be in a data base, so you can run queries against it. If the column names are applied as the first row of the CSV it is very easy to load the CSV file into a table.
Where did this enormous CSV file come from? It looks like something that should be in a data base, so you can run queries against it. If the column names are applied as the first row of the CSV it is very easy to load the CSV file into a table.
ASKER
This is from a company that said they where going to give us a "feed" for us to get charter rates from.
I thought it was strange too.
The feeds with I have worked with in the past where already formatted and you just had to run it through a reader and you were done.
nepaluz I am working on your fix now to see if it works.
I thought it was strange too.
The feeds with I have worked with in the past where already formatted and you just had to run it through a reader and you were done.
nepaluz I am working on your fix now to see if it works.
ASKER
nepaluz is there something I need to ensure I have running on my server to get this to work?
I have created a new blank php page and called it nepaluz.
I then copied and pasted your code from above and posted it to my server:
http://www.visailing.com/_testing/data-feed/nepaluz.php
And it just displays a blank page.
I have created a new blank php page and called it nepaluz.
I then copied and pasted your code from above and posted it to my server:
http://www.visailing.com/_testing/data-feed/nepaluz.php
And it just displays a blank page.
ASKER
Here is the code I have running on
http://www.visailing.com/_testing/data-feed/nepaluz.php
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
echo "</table>";
?>
http://www.visailing.com/_testing/data-feed/nepaluz.php
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
echo "</table>";
?>
In PHP, the if() construct is easily paired with the else. You can use the else clause to print something in case the if() was not evaluated TRUE. In the case of the script above, the PHP generated HTML containing only <table></table>. To me this suggests that fopen() or while() found nothing or returned FALSE.
Example:
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE)
{
/* DO SOMETHING */
}
else
{
echo "fopen BROKERUR pooped out";
}
Example:
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE)
{
/* DO SOMETHING */
}
else
{
echo "fopen BROKERUR pooped out";
}
Yes you are missing something. Because your test data was rather HUGE (67 MB),i changed the code a bit and forgot to re-instate the changes after testing.
Change this line
Change this line
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {if (($handle = fopen($file, "r")) !== FALSE) {
I should add, because of my bandwidth restrictions, I have not been able to test that out, but should work (as it did for me with a portion of your test data saved locally).
ASKER
I did a mix of your 2 answers with the code:
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
//if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {
if (($handle = fopen($file, "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
else
{
echo "fopen BROKERUR pooped out";
}
echo "</table>";
?>
And I am getting the message
fopen BROKERUR pooped out
Do you think it is because the file is to big and they are telling us to do this the wrong way?
And it should be a smaller file for a feed or they should be putting it into a database?
If so can you give me something to tell them?
Then I will copy paste that into an email for them and close this thread (because the issue is on their end).
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
//if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {
if (($handle = fopen($file, "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
else
{
echo "fopen BROKERUR pooped out";
}
echo "</table>";
?>
And I am getting the message
fopen BROKERUR pooped out
Do you think it is because the file is to big and they are telling us to do this the wrong way?
And it should be a smaller file for a feed or they should be putting it into a database?
If so can you give me something to tell them?
Then I will copy paste that into an email for them and close this thread (because the issue is on their end).
ASKER
The new code is on http://www.visailing.com/_testing/data-feed/nepaluz.php
checkmy last posting. It is pooping out because of the path tothe file is wrong in the code suggestion. Change your code as I corrected in ID:37233886 and you should be upand running (of course that isif you do not time out due to the size of the file, but that is a question for another thread).
ASKER
I did (I commented it out) I completely deleted it now and this is what I have running.
Is it still wrong?
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
if (($handle = fopen($file, "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
else
{
echo "fopen BROKERUR pooped out";
}
echo "</table>";
?>
Is it still wrong?
<?
$file = "http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV";
$xCode = "Moorings 372 - Club";
echo "<table>";
if (($handle = fopen($file, "r")) !== FALSE) {
while (($row = fgetcsv($handle)) !== FALSE) {
if( FALSE !== array_search($xCode, $row) ){
echo "<tr><td>".$row[5]."</td>"
."<td>".$row[9]."</td>" ."<td>".$row[11]."</td>" ."<td>".$row[12]."</td>" ."<td>".$row[14]."</td></t
}
}
fclose($handle);
}
else
{
echo "fopen BROKERUR pooped out";
}
echo "</table>";
?>
Here is an abbreviated set of the test data. Note that I added column name headers as the first line. I will show you the general design patter that you can use to load a data base table from this data feed. Once you have the data out of the CSV and into the data base, it will be MUCH easier to search!
"A", "B", "C","D", "E", "F", "G", "H", "I", "J", "K", "L","M","N","O","P","Q","R","S","T","U","V","W","X","Y","Z"
"BABA","BABA7742260","B","ABA",20111118,20111125,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742261","B","ABA",20111118,20111125,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833761","C","ABA",20111118,20111125,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833762","C","ABA",20111118,20111125,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864263","P","ABA",20111118,20111125,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864264","P","ABA",20111118,20111125,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742245","B","ABA",20111118,20111125,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742246","B","ABA",20111118,20111125,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742247","B","ABA",20111118,20111125,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833746","C","ABA",20111118,20111125,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833747","C","ABA",20111118,20111125,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833748","C","ABA",20111118,20111125,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864248","P","ABA",20111118,20111125,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864249","P","ABA",20111118,20111125,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864250","P","ABA",20111118,20111125,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742242","B","ABA",20111118,20111125,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742243","B","ABA",20111118,20111125,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742256","B","ABA",20111118,20111125,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833743","C","ABA",20111118,20111125,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833744","C","ABA",20111118,20111125,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833757","C","ABA",20111118,20111125,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864245","P","ABA",20111118,20111125,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864246","P","ABA",20111118,20111125,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864259","P","ABA",20111118,20111125,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742248","B","ABA",20111118,20111125,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742249","B","ABA",20111118,20111125,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742251","B","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742252","B","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833749","C","ABA",20111118,20111125,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833750","C","ABA",20111118,20111125,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833752","C","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833753","C","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864251","P","ABA",20111118,20111125,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864252","P","ABA",20111118,20111125,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864254","P","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864255","P","ABA",20111118,20111125,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742258","B","ABA",20111118,20111125,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742262","B","ABA",20111118,20111125,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833759","C","ABA",20111118,20111125,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833763","C","ABA",20111118,20111125,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864261","P","ABA",20111118,20111125,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864265","P","ABA",20111118,20111125,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742244","B","ABA",20111118,20111125,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"CABA","CABA7833745","C","ABA",20111118,20111125,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"PABA","PABA7864247","P","ABA",20111118,20111125,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"BABA","BABA7742255","B","ABA",20111118,20111125,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"CABA","CABA7833756","C","ABA",20111118,20111125,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"PABA","PABA7864258","P","ABA",20111118,20111125,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"BABA","BABA8406393","B","ABA",20111118,20111202,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406394","B","ABA",20111118,20111202,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494934","C","ABA",20111118,20111202,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494935","C","ABA",20111118,20111202,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524742","P","ABA",20111118,20111202,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524743","P","ABA",20111118,20111202,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406378","B","ABA",20111118,20111202,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406379","B","ABA",20111118,20111202,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406380","B","ABA",20111118,20111202,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494919","C","ABA",20111118,20111202,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494920","C","ABA",20111118,20111202,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494921","C","ABA",20111118,20111202,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524727","P","ABA",20111118,20111202,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524728","P","ABA",20111118,20111202,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524729","P","ABA",20111118,20111202,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406375","B","ABA",20111118,20111202,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406376","B","ABA",20111118,20111202,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406389","B","ABA",20111118,20111202,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494916","C","ABA",20111118,20111202,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494917","C","ABA",20111118,20111202,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494930","C","ABA",20111118,20111202,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524724","P","ABA",20111118,20111202,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524725","P","ABA",20111118,20111202,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524738","P","ABA",20111118,20111202,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406381","B","ABA",20111118,20111202,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406382","B","ABA",20111118,20111202,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406384","B","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406385","B","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494922","C","ABA",20111118,20111202,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494923","C","ABA",20111118,20111202,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494925","C","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494926","C","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524730","P","ABA",20111118,20111202,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524731","P","ABA",20111118,20111202,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524733","P","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524734","P","ABA",20111118,20111202,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742253","B","ABA",20111118,20111125,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742254","B","ABA",20111118,20111125,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742259","B","ABA",20111118,20111125,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833754","C","ABA",20111118,20111125,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833755","C","ABA",20111118,20111125,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833760","C","ABA",20111118,20111125,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864256","P","ABA",20111118,20111125,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864257","P","ABA",20111118,20111125,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864262","P","ABA",20111118,20111125,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6340.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406391","B","ABA",20111118,20111202,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406395","B","ABA",20111118,20111202,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494932","C","ABA",20111118,20111202,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494936","C","ABA",20111118,20111202,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524740","P","ABA",20111118,20111202,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524744","P","ABA",20111118,20111202,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742257","B","ABA",20111118,20111125,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6725.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833758","C","ABA",20111118,20111125,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6725.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864260","P","ABA",20111118,20111125,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6725.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742250","B","ABA",20111118,20111125,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6940.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833751","C","ABA",20111118,20111125,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6940.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864253","P","ABA",20111118,20111125,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6940.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406377","B","ABA",20111118,20111202,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"CABA","CABA8494918","C","ABA",20111118,20111202,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"PABA","PABA8524726","P","ABA",20111118,20111202,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"BABA","BABA8406388","B","ABA",20111118,20111202,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"CABA","CABA8494929","C","ABA",20111118,20111202,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"PABA","PABA8524737","P","ABA",20111118,20111202,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"BABA","BABA8406386","B","ABA",20111118,20111202,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406387","B","ABA",20111118,20111202,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406392","B","ABA",20111118,20111202,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494927","C","ABA",20111118,20111202,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494928","C","ABA",20111118,20111202,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494933","C","ABA",20111118,20111202,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524735","P","ABA",20111118,20111202,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524736","P","ABA",20111118,20111202,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524741","P","ABA",20111118,20111202,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406390","B","ABA",20111118,20111202,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494931","C","ABA",20111118,20111202,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524739","P","ABA",20111118,20111202,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406383","B","ABA",20111118,20111202,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494924","C","ABA",20111118,20111202,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524732","P","ABA",20111118,20111202,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742281","B","ABA",20111119,20111126,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742282","B","ABA",20111119,20111126,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833782","C","ABA",20111119,20111126,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833783","C","ABA",20111119,20111126,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864284","P","ABA",20111119,20111126,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864285","P","ABA",20111119,20111126,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742266","B","ABA",20111119,20111126,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742267","B","ABA",20111119,20111126,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742268","B","ABA",20111119,20111126,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833767","C","ABA",20111119,20111126,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833768","C","ABA",20111119,20111126,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833769","C","ABA",20111119,20111126,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864269","P","ABA",20111119,20111126,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864270","P","ABA",20111119,20111126,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864271","P","ABA",20111119,20111126,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742263","B","ABA",20111119,20111126,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742264","B","ABA",20111119,20111126,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742277","B","ABA",20111119,20111126,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833764","C","ABA",20111119,20111126,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833765","C","ABA",20111119,20111126,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833778","C","ABA",20111119,20111126,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864266","P","ABA",20111119,20111126,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864267","P","ABA",20111119,20111126,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864280","P","ABA",20111119,20111126,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742269","B","ABA",20111119,20111126,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742270","B","ABA",20111119,20111126,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742272","B","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742273","B","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833770","C","ABA",20111119,20111126,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833771","C","ABA",20111119,20111126,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833773","C","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833774","C","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864272","P","ABA",20111119,20111126,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864273","P","ABA",20111119,20111126,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864275","P","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864276","P","ABA",20111119,20111126,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742279","B","ABA",20111119,20111126,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742283","B","ABA",20111119,20111126,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833780","C","ABA",20111119,20111126,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833784","C","ABA",20111119,20111126,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864282","P","ABA",20111119,20111126,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864286","P","ABA",20111119,20111126,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3255.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742265","B","ABA",20111119,20111126,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3885.00,"","",.00,"","",.00,"","",.00,"N",10,2
"CABA","CABA7833766","C","ABA",20111119,20111126,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3885.00,"","",.00,"","",.00,"","",.00,"N",10,2
"PABA","PABA7864268","P","ABA",20111119,20111126,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3885.00,"","",.00,"","",.00,"","",.00,"N",10,2
"BABA","BABA7742276","B","ABA",20111119,20111126,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3955.00,"","",.00,"","",.00,"","",.00,"N",7,2
"CABA","CABA7833777","C","ABA",20111119,20111126,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3955.00,"","",.00,"","",.00,"","",.00,"N",7,2
"PABA","PABA7864279","P","ABA",20111119,20111126,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3955.00,"","",.00,"","",.00,"","",.00,"N",7,2
"BABA","BABA8406414","B","ABA",20111119,20111203,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406415","B","ABA",20111119,20111203,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494955","C","ABA",20111119,20111203,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494956","C","ABA",20111119,20111203,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524763","P","ABA",20111119,20111203,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524764","P","ABA",20111119,20111203,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4690.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406399","B","ABA",20111119,20111203,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406400","B","ABA",20111119,20111203,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406401","B","ABA",20111119,20111203,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494940","C","ABA",20111119,20111203,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494941","C","ABA",20111119,20111203,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494942","C","ABA",20111119,20111203,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524748","P","ABA",20111119,20111203,20101115,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524749","P","ABA",20111119,20111203,20110523,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524750","P","ABA",20111119,20111203,20110531,20121130,"014","3722E","Moorings 37.2 - Exclusive",2,"EUR",4970.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406396","B","ABA",20111119,20111203,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406397","B","ABA",20111119,20111203,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406410","B","ABA",20111119,20111203,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494937","C","ABA",20111119,20111203,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494938","C","ABA",20111119,20111203,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494951","C","ABA",20111119,20111203,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524745","P","ABA",20111119,20111203,20100107,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524746","P","ABA",20111119,20111203,20100112,20120630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524759","P","ABA",20111119,20111203,20110106,20130630,"014","4103K","Moorings 41.3 - Club",2,"EUR",5390.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406402","B","ABA",20111119,20111203,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406403","B","ABA",20111119,20111203,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406405","B","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA8406406","B","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494943","C","ABA",20111119,20111203,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494944","C","ABA",20111119,20111203,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494946","C","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA8494947","C","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524751","P","ABA",20111119,20111203,20110115,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524752","P","ABA",20111119,20111203,20110503,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524754","P","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA8524755","P","ABA",20111119,20111203,20110729,20130131,"014","4103E","Moorings 41.3 - Exclusive",2,"EUR",6020.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742274","B","ABA",20111119,20111126,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742275","B","ABA",20111119,20111126,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742280","B","ABA",20111119,20111126,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833775","C","ABA",20111119,20111126,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833776","C","ABA",20111119,20111126,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833781","C","ABA",20111119,20111126,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864277","P","ABA",20111119,20111126,20100425,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864278","P","ABA",20111119,20111126,20100501,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864283","P","ABA",20111119,20111126,20110824,20130630,"007","47P4K","Moorings Power 474 - Club",2,"EUR",6335.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406412","B","ABA",20111119,20111203,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406416","B","ABA",20111119,20111203,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494953","C","ABA",20111119,20111203,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494957","C","ABA",20111119,20111203,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524761","P","ABA",20111119,20111203,20110708,20130630,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524765","P","ABA",20111119,20111203,20111001,20140430,"014","37X2K","Moorings 372PC - Club",2,"EUR",6545.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742278","B","ABA",20111119,20111126,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6720.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833779","C","ABA",20111119,20111126,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6720.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864281","P","ABA",20111119,20111126,20110613,20130630,"007","47P4E","Moorings 474PC - Excl",2,"EUR",6720.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742271","B","ABA",20111119,20111126,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA7833772","C","ABA",20111119,20111126,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA7864274","P","ABA",20111119,20111126,20110724,20130131,"007","46X4E","Moorings 4600 - Exclusive",2,"EUR",6930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406398","B","ABA",20111119,20111203,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"CABA","CABA8494939","C","ABA",20111119,20111203,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"PABA","PABA8524747","P","ABA",20111119,20111203,20100301,20120630,"014","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",7805.00,"","",.00,"","",.00,"","",.00,"N",10,2
"BABA","BABA8406409","B","ABA",20111119,20111203,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"CABA","CABA8494950","C","ABA",20111119,20111203,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"PABA","PABA8524758","P","ABA",20111119,20111203,20100801,20130630,"014","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",7945.00,"","",.00,"","",.00,"","",.00,"N",7,2
"BABA","BABA8406407","B","ABA",20111119,20111203,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406408","B","ABA",20111119,20111203,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406413","B","ABA",20111119,20111203,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494948","C","ABA",20111119,20111203,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494949","C","ABA",20111119,20111203,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494954","C","ABA",20111119,20111203,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524756","P","ABA",20111119,20111203,20100425,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524757","P","ABA",20111119,20111203,20100501,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524762","P","ABA",20111119,20111203,20110824,20130630,"014","47P4K","Moorings Power 474 - Club",2,"EUR",12705.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406411","B","ABA",20111119,20111203,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494952","C","ABA",20111119,20111203,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524760","P","ABA",20111119,20111203,20110613,20130630,"014","47P4E","Moorings 474PC - Excl",2,"EUR",13475.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA8406404","B","ABA",20111119,20111203,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"CABA","CABA8494945","C","ABA",20111119,20111203,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"PABA","PABA8524753","P","ABA",20111119,20111203,20110724,20130131,"014","46X4E","Moorings 4600 - Exclusive",2,"EUR",13930.00,"","",.00,"","",.00,"","",.00,"N",12,2
"BABA","BABA7742302","B","ABA",20111120,20111127,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742303","B","ABA",20111120,20111127,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833803","C","ABA",20111120,20111127,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833804","C","ABA",20111120,20111127,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864305","P","ABA",20111120,20111127,20110106,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864306","P","ABA",20111120,20111127,20110201,20140430,"007","3722K","Moorings 372 - Club",2,"EUR",2345.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742287","B","ABA",20111120,20111127,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742288","B","ABA",20111120,20111127,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742289","B","ABA",20111120,20111127,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833788","C","ABA",20111120,20111127,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833789","C","ABA",20111120,20111127,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833790","C","ABA",20111120,20111127,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864290","P","ABA",20111120,20111127,20101115,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864291","P","ABA",20111120,20111127,20110523,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864292","P","ABA",20111120,20111127,20110531,20121130,"007","3722E","Moorings 37.2 - Exclusive",2,"EUR",2485.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742284","B","ABA",20111120,20111127,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742285","B","ABA",20111120,20111127,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742298","B","ABA",20111120,20111127,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833785","C","ABA",20111120,20111127,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833786","C","ABA",20111120,20111127,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833799","C","ABA",20111120,20111127,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864287","P","ABA",20111120,20111127,20100107,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864288","P","ABA",20111120,20111127,20100112,20120630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864301","P","ABA",20111120,20111127,20110106,20130630,"007","4103K","Moorings 41.3 - Club",2,"EUR",2695.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742290","B","ABA",20111120,20111127,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742291","B","ABA",20111120,20111127,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742293","B","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742294","B","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833791","C","ABA",20111120,20111127,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833792","C","ABA",20111120,20111127,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833794","C","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"CABA","CABA7833795","C","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864293","P","ABA",20111120,20111127,20110115,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864294","P","ABA",20111120,20111127,20110503,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864296","P","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"PABA","PABA7864297","P","ABA",20111120,20111127,20110729,20130131,"007","4103E","Moorings 41.3 - Exclusive",2,"EUR",3010.00,"","",.00,"","",.00,"","",.00,"N",8,2
"BABA","BABA7742300","B","ABA",20111120,20111127,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742304","B","ABA",20111120,20111127,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833801","C","ABA",20111120,20111127,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA7833805","C","ABA",20111120,20111127,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864303","P","ABA",20111120,20111127,20110708,20130630,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA7864307","P","ABA",20111120,20111127,20111001,20140430,"007","37X2K","Moorings 372PC - Club",2,"EUR",3260.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA7742286","B","ABA",20111120,20111127,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"CABA","CABA7833787","C","ABA",20111120,20111127,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"PABA","PABA7864289","P","ABA",20111120,20111127,20100301,20120630,"007","40X4K","Moorings 4000-4 Cabin Clb",2,"EUR",3890.00,"","",.00,"","",.00,"","",.00,"N",10,2
"BABA","BABA7742297","B","ABA",20111120,20111127,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"CABA","CABA7833798","C","ABA",20111120,20111127,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"PABA","PABA7864300","P","ABA",20111120,20111127,20100801,20130630,"007","40X3K","Moorings 4000-3 Cabin Clb",2,"EUR",3960.00,"","",.00,"","",.00,"","",.00,"N",7,2
"BABA","BABA8406435","B","ABA",20111120,20111204,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
"BABA","BABA8406436","B","ABA",20111120,20111204,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494976","C","ABA",20111120,20111204,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
"CABA","CABA8494977","C","ABA",20111120,20111204,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524784","P","ABA",20111120,20111204,20110106,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
"PABA","PABA8524785","P","ABA",20111120,20111204,20110201,20140430,"014","3722K","Moorings 372 - Club",2,"EUR",4715.00,"","",.00,"","",.00,"","",.00,"N",6,2
Here is the script... The URLs for the script and test data are:
http://www.laprbass.com/RAY_temp_raz.php
http://www.laprbass.com/RAY_temp_raz.csv
http://www.laprbass.com/RAY_temp_raz.php
http://www.laprbass.com/RAY_temp_raz.csv
<?php // RAY_temp_raz.php
error_reporting(E_ALL);
echo "<pre>";
echo PHP_EOL;
// CONNECTION AND SELECTION VARIABLES FOR THE DATABASE
$db_host = "localhost"; // PROBABLY THIS IS OK
$db_name = "??"; // GET THESE FROM YOUR HOSTING COMPANY
$db_user = "??";
$db_word = "??";
// OPEN A CONNECTION TO THE DATA BASE SERVER
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-connect.php
if (!$db_connection = mysql_connect("$db_host", "$db_user", "$db_word"))
{
$errmsg = mysql_errno() . ' ' . mysql_error();
echo "<br/>NO DB CONNECTION: ";
echo "<br/> $errmsg <br/>";
}
// SELECT THE MYSQL DATA BASE
// MAN PAGE: http://us2.php.net/manual/en/function.mysql-select-db.php
if (!$db_sel = mysql_select_db($db_name, $db_connection))
{
$errmsg = mysql_errno() . ' ' . mysql_error();
echo "<br/>NO DB SELECTION: ";
echo "<br/> $errmsg <br/>";
die('NO DATA BASE');
}
// IF WE GOT THIS FAR WE CAN DO QUERIES
// TEST DATA, SAVED FROM THE POST AT EE
$csv = 'RAY_temp_raz.csv';
$fpo = fopen($csv, 'r');
if (!$fpo) die("FOPEN FAILED: $csv");
// GET THE FIELD NAMES FROM THE TOP OF THE CSV FILE
$top = fgetcsv($fpo);
$cnt = count($top);
// SET UP KEY NAMES FOR USE IN OUR QUERY
$query_cols = implode(',', $top);
// SET A ROW COUNTER
$counter = 0;
// KEEP TRACK OF ROWS THAT HAVE THE WRONG NUMBER OF FIELDS
$errors = array();
// LOOP THROUGH THE CSV RECORDS PERFORMING CERTAIN TESTS
while (!feof($fpo))
{
$counter++;
// GET A RECORD
$csvdata = fgetcsv($fpo);
// SKIP OVER EMPTY ROWS
if (empty($csvdata)) continue;
// CHECK THE NUMBER OF FIELDS
if ($cnt != count($csvdata))
{
$errors[] = $counter;
continue;
}
// MAYBE ASSIGN KEYS TO THE ROW OF FIELDS - ACTIVATE THIS TO SEE THE ASSOCIATIVE ARRAY
// $csvdata = array_combine($top, $csvdata);
// var_dump($csvdata);
// ESCAPE THE INFORMATION FOR USE IN THE QUERY
foreach ($csvdata as $ptr => $value)
{
$csvdata[$ptr] = mysql_real_escape_string($value);
}
// SET UP VALUE FIELDS
$query_data = "'" . implode("', '", $csvdata) . "'";
// SET UP A QUERY
$sql = "REPLACE INTO myTable ( $query_cols ) VALUES ( $query_data )";
// IN REAL LIFE YOU WOULD RUN THE QUERY HERE....
var_dump($sql);
}
// SHOW THE NUMBER OF ROWS PROCESSED
echo "<br/>RECORDS PROCESSED $counter \n";
// SHOW THE NUMBERS OF THE ROWS WITH THE WRONG NUMBER OF FIELDS
if (count($errors))
{
echo "<br/>ROWS WITH THE WRONG NUMBER OF FIELDS: \n";
var_dump($errors);
}
when you run that code in a browser, after around 5 seonds, right click on the (blank) browser that is now loading and select View Source.You will see the data being loaded, nothing actually appears at the end in the browser because the browser timed out. (data is too big!).
I think going foward the suggestion of placing your data in a datatable and querying it from there is the more practical one. (And I will keep my eye peeled for that too!)
I think going foward the suggestion of placing your data in a datatable and querying it from there is the more practical one. (And I will keep my eye peeled for that too!)
ASKER
I agree.
But they want us to query this csv file and they will be uploading a new csv file (replacing the current data) once a day.
From what you both are saying it looks like I should tell them that this is not a good approach and that they should just put it into a database (since they will be updating and maintaining the data).
Is that correct?
But they want us to query this csv file and they will be uploading a new csv file (replacing the current data) once a day.
From what you both are saying it looks like I should tell them that this is not a good approach and that they should just put it into a database (since they will be updating and maintaining the data).
Is that correct?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
They redid the data file and it is now 1/6 the original size, but the code still does not work.
http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV.
They want to use the csv and not the database option.
http://sailing-vacations.mobi/tuimarine/BROKEREUR.CSV.
They want to use the csv and not the database option.
ASKER
Got it working.
ASKER
I am trying to give you both equal credit in this thread.
Is there a way to do that?
Is there a way to do that?
Hi Razzmataz73,
As a Savant, I guess that Ray Paseur may probably have an answer :-)
As a Savant, I guess that Ray Paseur may probably have an answer :-)
You can ask a moderator to re-open the question (use the "Request Attention" button near the lower right side of the original post. Then you can close the question accepting more than one solution. See https://www.experts-exchange.com/help.jsp#hs=29&hi=404