1. GoHost4U
  2. RO CSVI
  3. Friday, 03 July 2015
  4.  Subscribe via email
Hi Roland...hope you are well!

I have not had an opportunity or reason to do this before so I have not come across this.

When I import properties I dont normally reimport images to save on server access etc but I have a need to redownload images on an import as some of the properties have new images taken and thus the old images are no longer required.

I note from the log that the import when set to overwrite existing data and re-download images that the system does overwrite the property details correctly and it downloads the new images and adds the new image details to the database but it does not delete the old database entries in #_ezrealty_images.

So I get 2 sets of database entries for the same property id as you can see from the spreadsheet attached.

If the settings are to overwrite and redownload images then the old database entries need to be deleted?

Is this possible?

Thanks in advance...Mark
Accepted Answer Pending Moderation
Hello Mark,

All is well, hope all is well with you too.

As for your question, you can create an import override of the file administrator/components/com_csvi/models/com_ezrealty/import/propertyimport.php file and add this code after line 528:
$db = JFactory::getDbo();
$query = $db->getQuery(true)
->delete($db->qn('#__ezrealty_images'))
->where($db->qn('propid').'='.$this->id);
$db->setQuery($query);
$db->query();


A somewhat related question, have you thought about a future with EZ Realty with it's development come pretty much to a standstill?
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
Accepted Answer Pending Moderation
Hi Roland...yes we are good thank you. Business is good so I cannot complain.

As for EZRealty, I understand Kathy is taking some time away and restructuring how she works in terms of support etc but she hasnt answered my personal email about how she is or what might be happening to the project.

I know this pretty well so moving to another system isnt an easy step for me so I can develope it myself or just stick with it as is.

I have already made quite a lot of changes and additions. I have even had an add on designed so we can send regular newsletters congaing properties which match the clients criteria and recording the results on a small cms within Joomla. This is a pretty neat solution as it just sends out nice emails to anyone on the list and keeps doing so until there are no new properties which match. Moving to another solution might mean loosing this which has really been accepted well with my clients.

Unless you have any suggestions I think I will have to stick with it. As I say maybe if anything is needed I can contract the work out to a couple of coders I know and keep it developed that way.
  1. more than a month ago
  2. RO CSVI
  3. # 2
Accepted Answer Pending Moderation
Hey Mark,

The same story about unanswered emails I have heard from another user.

I am aware that EZ Realty works OK as it is now and just looking forward as we are getting close to a year since the last release. CSVI 6 is coming out with EZ Realty support and not sure how much further to take it. For now it is OK :)

I have no other suggestions just wanted to get your take on things.
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. # 3
Accepted Answer Pending Moderation
Just a quick question...does this override only work if the Re Download images is set to yes?

Thanks Roland!
  1. more than a month ago
  2. RO CSVI
  3. # 4
Accepted Answer Pending Moderation
This override is always in place, so always used. If you want it to only work when re-download images is set to yes you will have to wrap it in an if statement. However, you are always importing the images right?
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. # 5
Accepted Answer Pending Moderation
Hi Roland,

Not really...only if the images are set to re download. This is to save server access and copying etc.


By the way I played about with V6...Only thing I noticed is theres no fname on the property import...does that mean you cannot do the image import at the same time as the property import?


Mark
  1. more than a month ago
  2. RO CSVI
  3. # 6
Accepted Answer Pending Moderation
Hey Mark,

In that case you will need to wrap the delete option in the redownload check.

The fname field is present in the EZ Realty import on CSVI 6. Perhaps you need to update the available fields or if it isn't there after that. Go to Maintenance -> Tasks -> Reset. After that run the update available fields and you should have the field.
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
Accepted Answer Pending Moderation
Hi Roland

I tried the reset then maintenance/available fields and update button and i got:
An error occured processing the records. The error occured is shown below if available. Additionally check your server log for any errors or warnings.
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator at root@localhost to inform them of the time this error occurred, and the actions you performed just before this error.
More information about this error may be available in the server error log.

Server lg is:
bugge-eiendom.no [Sat Jul 04 11:16:02 2015] [error] [client 81.36.168.83:37039] AH01225: Error reading request entity data
bugge-eiendom.no [Sat Jul 04 11:17:24 2015] [error] [client 81.36.168.83:46576] AH01225: Error reading request entity data
bugge-eiendom.no [Tue Jul 07 13:41:43 2015] [error] [client 79.150.252.248:56310] End of script output before headers: index.php
bugge-eiendom.no [Tue Jul 07 13:42:02 2015] [error] [client 79.150.252.248:39018] End of script output before headers: index.php
bugge-eiendom.no [Tue Jul 07 13:42:34 2015] [error] [client 79.150.252.248:60765] End of script output before headers: index.php
bugge-eiendom.no [Tue Jul 07 14:15:05 2015] [error] [client 79.150.252.248:58099] End of script output before headers: index.php
bugge-eiendom.no [Tue Jul 07 14:17:05 2015] [error] [client 79.150.252.248:49631] End of script output before headers: index.php


Regards
Mark
  1. more than a month ago
  2. RO CSVI
  3. # 8
Accepted Answer Pending Moderation
Hello Mark,

tried the reset then maintenance/available fields and update button and i got:

It is unclear when you get this error, doing the reload or the update of the available fields.

This is an error I have never seen before but Googling around appears to indicate it has something to do with too big log files or incorrect permission on the files. You can check the Logs page in CSVI, and empty all the logs to make sure it is empty and not using too much.

If you have the Joomla debug turned on, see if it helps by turning it off before reloading the tasks and/or updating the available fields.
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. # 9
Accepted Answer Pending Moderation
Hi Roland

As soon as I press the Update button the screen changes and says "Update available fields" with an animated gif saying Processing...

and immediately comes up with that message. See image!

I tried to delete all the logs but the ok button didnt do anything!

No debug running.
Attachments (1)
  1. more than a month ago
  2. RO CSVI
  3. # 10
Accepted Answer Pending Moderation
Hello Mark,

I tried to delete all the logs but the ok button didnt do anything!
Reported and fixed bug.

No debug running.
There is indeed no debug log because you are doing an update on the available fields.

Looking further with the error log message, it may be a file it cannot read or something. If you send me some FTP and website login details, I can check to see if I can pinpoint the issue.
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. # 11
Accepted Answer Pending Moderation
Hi Roland

I am travelling at the mo so sorry i did not get back earlier!

ftp as follows:


joomla access:


Thats a zero!

Cheers
Mark
  1. more than a month ago
  2. RO CSVI
  3. # 12
Accepted Answer Pending Moderation
Hello Mark,

The FTP login doesn't work, can you check it please? Please private message the details.
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. # 13
Accepted Answer Pending Moderation
Hey Mark,

In that case you will need to wrap the delete option in the redownload check.



Hi Roland!
Can you tell me where the if statement is or can i create a new one based on that check and if so what is the if statement i will need to use...Thanks in advance
  1. more than a month ago
  2. RO CSVI
  3. # 14
Accepted Answer Pending Moderation
Hey Mark,

You need to create the if statement yourself. As mentioned in my previous post where you can add the delete code, around that code you put
if ($template->get('redownload_external_image', 'image')) { }
and withing the curly braces you place the delete statement.

Does that help?
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. # 15
  • Page :
  • 1


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