CSV Import Floors

Hi,
I have been testing the CSV import feature and it works really well.

However, the 'Floors' field doesn't import. I have tested by exporting the csv then re-importing the same with these results.

Floors on CSV export 3
Floors on CSV import 0

Is there a fix for this?

Also can other fields be added? (e.g. Parking?)

Thanks Jim

Hi Jim,
To fix the issue, please follow these steps
1. Open file
administrator > components > com_osproperty > classes > csvimport.php
2. find
$db->setQuery("Select column_number from #__osrs_form_fields where form_id = '$row->id' and `field` like 'rooms'");
$col_rooms = $db->loadResult();
$col_rooms--;
$rooms = $cell[$col_rooms];
and add this bellow
$db->setQuery("Select column_number from #__osrs_form_fields where form_id = '$row->id' and `field` like 'number_of_floors'");
$col_number_of_floors = $db->loadResult();
$col_number_of_floors--;
$col_number_of_floors = $cell[$col_number_of_floors];

---

find
$property->rooms = $rooms;
and add this bellow that line
$property->col_number_of_floors = $col_number_of_floors;

Good luck
Dam

Thanks Dam,

But i don't have a csvimport.php file, ? only a csvexport.php file !

Jim

Sorry Jim, it should be csvform.php
Thanks
Dam

Hi Dam,
No problem thanks.
I have added the lines but then receive the following error on import (see attached file)
Jim