We help IT Professionals succeed at work.

Get values from csv file using php

Razzmataz73
Razzmataz73 asked
on
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
Comment
Watch Question

Commented:
1. You want to searchit for what?
2. What results do you want returned and how (i.e table, list, CSV)?

Author

Commented:
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).

Commented:
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)

Author

Commented:
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

Commented:
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>";
  }
}

Open in new window

Commented:
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>";
  }
}

Open in new window

Then all you have to do is echo the contents of the array $Result into a table.

Author

Commented:
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[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>";

?>

Commented:
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>";

?>

Open in new window

Commented:
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>";

Open in new window

Commented:
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>";

?>

Open in new window

Author

Commented:
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[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 "<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>";

?>

Commented:
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>";

?>

Open in new window

Commented:
OK, hands up that was un-tested code. Here is code I have tested (and works)
<?
$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[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>";
    }
    }
    fclose($handle);
}
echo "</table>";

?>

Open in new window

And the results
 Results
Most Valuable Expert 2011
Top Expert 2016

Commented:
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.

Author

Commented:
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.

Author

Commented:
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.

Author

Commented:
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[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>";
    }
    }
    fclose($handle);
}
echo "</table>";

?>
Most Valuable Expert 2011
Top Expert 2016

Commented:
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";
}

Commented:
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
if (($handle = fopen("BROKERUR.txt", "r")) !== FALSE) {

Open in new window

to
if (($handle = fopen($file, "r")) !== FALSE) {

Open in new window

(Actually thought you'd spot that....!)

Commented:
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).

Author

Commented:
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[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>";
    }
    }
    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).

Commented:
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).

Author

Commented:
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[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>";
    }
    }
    fclose($handle);
}
else
{
    echo "fopen BROKERUR pooped out";
}
echo "</table>";

?>
Most Valuable Expert 2011
Top Expert 2016

Commented:
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

Open in new window

Most Valuable Expert 2011
Top Expert 2016

Commented:
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
<?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);
}

Open in new window

Commented:
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!)

Author

Commented:
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?
Most Valuable Expert 2011
Top Expert 2016
Commented:
I guess the answer would somewhat depend on who "they" are.  If it's a foreign web service, not under your control, it might be nice if they would expose an API and let you query it selectively.  The HTTP protocol is not really well-made for bulk data transfer (FTP makes more sense for that).

I've read the data from the URL a couple of times and it seems to be consistently giving me 10,351 rows.  That's big for HTTP but nothing for a data base.  So once you have it downloaded each day, you can just plop the data into a table on your own machine and do the work "in-house."

Author

Commented:
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.

Author

Commented:
Got it working.

Author

Commented:
I am trying to give you both equal credit in this thread.
Is there a way to do that?
Hi Razzmataz73,

As a Savant, I guess that Ray Paseur may probably have an answer :-)
Most Valuable Expert 2011
Top Expert 2016

Commented:
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 http://www.experts-exchange.com/help.jsp#hs=29&hi=404