Categories
View Replies (10)

Resolved EZ Realty Multi Category Import

  1. GoHost4U
    GoHost4U
  2. RO CSVI
  3. Tuesday, 02 December 2014
  4.  Subscribe via email
Hi Roland,
Ive put this here so you can answer when you can.

I have a query about multiple property categories in EZRealty. How do I set up the system to cope with multiple categories.

Specifically what would the xml file have to have for a CSVI import and what would I need to set the import to so it imports multiple categories please.

Thanks!
0
Responses (10)
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

Multiple categories are separated by a pipe-symbol, |. So a multiple category would look like this Houses/terraced|Cities/Suburbia.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 1
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

The import will update the incats table, it was the export that did not do the multiple categories yet.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 2
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hi Roland

OK I am now trying to get this all to work but the export doesnt have (or I cannot find) a way to export this data.

The export only seems to have "Category" as an exportable field and it only exports the 1?

The "incats" table has the references to the multi categories but I cannot see how I can export this?
  1. more than a month ago
  2. RO CSVI
  3. # 3
rolandd
rolandd
Accepted Answer Pending Moderation
Hello,

I may have confused myself. I had another check and while you can import multiple categories separated by | when importing a property, the exported property is not yet checked for multiple categories.

My answer above is not completely correct, EZ Realty doesn't have nested categories, so you would just have Terraced|Suburbia on import.

CSVI 5 doesn't have full support for EZ Realty 7 but attached is a patch file you can load from the maintenance page and you should be able to export the category field with multiple categories.
Attachments (1)
patch_ezcategory_20141208.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 4
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hi Roland.
Thank you for your answer I will give it a go but by reading what you have said am I right in saying the system will not update the incats table which has

property_id and category_id
  1. more than a month ago
  2. RO CSVI
  3. # 5
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hi Roland

I have 2 more queries, sorry!

When I try to export the following fields I get an error...

Declat, declong, Language, metadesc, metakey, owncoords, postcode

the xml gives me:

<?xml version="1.0" encoding="UTF-8"?>
<channel>

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en-gb" lang="en-gb" dir="ltr">
<head>
<meta http-equiv="content-type" content="text/html; charset=utf-8" />
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<meta http-equiv="X-UA-Compatible" content="IE=edge" />
<title>Error: 1052 Column 'postcode' in field list is ambiguous SQL=SELECT `AcresTotal`,.......

Obviously the first it get to is the first error listed.

Secondly, when I export the fname for the images I get...

<fname>
<![CDATA[
808_649_22_.jpg|808_649_7_.jpg|808_649_6_.jpg|808_649_8_.jpg|808_649_2_.jpg|808_649_20_.jpg|808_649_5_.jpg|808_649_15_.jpg|808_649_16_.jpg|808_elalamillo002__.jpg
]]>
</fname>

Normally when I import i combine each image line of the xml but this is already combined. However, the server url is not included?
  1. more than a month ago
  2. RO CSVI
  3. # 6
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Mark,

Can you post me the full SQL error? The error is that the same field exists in multiple tables so the database doesn't know what to do with it.

As for the fname, that is correct it has no server url, you should use the picture_url or picture_url_thumb to get the image with the server URL. This will also give you only the first image the database returns, rather than the full batch.
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 7
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hi Roland

I have made a test with just those fields

let me know if you need anything else
Attachments (1)
rolands-test.xml
  1. more than a month ago
  2. RO CSVI
  3. # 8
GoHost4U
GoHost4U
Accepted Answer Pending Moderation
Hello Mark,

Can you post me the full SQL error? The error is that the same field exists in multiple tables so the database doesn't know what to do with it.

As for the fname, that is correct it has no server url, you should use the picture_url or picture_url_thumb to get the image with the server URL. This will also give you only the first image the database returns, rather than the full batch.


The thing is I want all images for each property not just the one?
  1. more than a month ago
  2. RO CSVI
  3. # 9
rolandd
rolandd
Accepted Answer Pending Moderation
Hello Mark,

Witht the attached file you can export the fields, the error came because another table has the same fields.

The thing is I want all images for each property not just the one?
You will have to change the property export file then. Instead of exporting 1 picture_url to have it export multiple or change the file_url export by prefixing it with the URL of the site.
Attachments (1)
patch_ezfields_20141209.zip
Kind regards,

RolandD

=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
  1. more than a month ago
  2. RO CSVI
  3. # 10
  • Page :
  • 1


There are no replies made for this post yet.
Be one of the first to reply to this post!