Hi,
Ive just updated Joomla 3.5.0 & CSVi 6.5.5 now I cannot see CSVi in my admin components menu, although its still showing as being installed in Extensions > Manage
Please help asap, thanks!
Hello,
Very strange, honestly we are not seeing this issue. Can you try installing CSVI6.5.5 package again and see if it solves the issue?
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Ive installed it again, i got these errors and its still not appearing as a Components menu item:
Warning
JFolder: :delete: Path is not a folder. Path: /components/com_csvi/models
JFolder: :delete: Path is not a folder. Path: /administrator/components/com_csvi/helpers
JFolder: :delete: Path is not a folder. Path: /administrator/components/com_csvi/install
Table '#__csvi_availablefields' already exists SQL=RENAME TABLE #__csvi_available_fields TO #__csvi_availablefields;
Error
Error installing component
Id very much appreciate your help.
Thanks again!
Hello Jimmy,
You seem to have come from an older CSVI version like CSVI 5 and not followed the Installation or updating of CSVI 6 document.
See if you can uninstall CSVI and then install it. If this fails, you will either need to remove all the tables in your database that start with csvi_ manually and then do a clean install. Or if you wish to keep your templates, remove the tables from the database that start with csvi_ and restore the tables from a backup and add them to your database and then install the new CSVI version.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Thanks for your reply, im very pleased to say its ok now, im upgraded :) although a little more testing still to do :)
Just one immediate concern, previously my client used the URL below (rather than accessing the admin panel) to run imports/exports, but now this url is giving me a 404 error?
Many thanks in advance!
Hello Jimmy,
There is another post with the same request. The cron file is a real cron file now and as such can only be run as a cron job.
That this worked in the past was a fluke nor intended as such :)
I am working on a way to trigger templates from the front-end again as it turns out people are using this link rather than using the administrator area. There is already such a system for the export by creating a menu item. Once I have something working I will let you know.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
Ok thanks, any ideas how long roughly I might be waiting?
Thanks again!
Hello,
I have posted a patch in the original thread. Please give it a try and let me know how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
I have uploaded your patch and have attempted to create a CSVi menu item.
I successfully select the 'Menu Item Type:' but the next step 'Select template: select option' when I click the dropdown, nothing is available to me (I already have 1 import and 2 exports setup).
So thats as far as I got, your help would be very much appreciated! Thanks again!
Hello,
You need to enable the front-end usage of the template by setting the option Enable front-end/cron to Yes in the template. Don't forget, the secret key is required as well.
All this to prevent abuse of the template by manipulating a URL.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Great thanks yep, the import seems to be working fine now.
Although the 2 exports aren't working, depending on the 'destination' setting is bringing up just a plain white screen
unless I use 'use template settings' then this is the error
Fatal error: Call to a member function get() on a non-object in /homepages/43/d445035053/htdocs/clickandbuilds/Joomla/Luxury_Flatshares/components/com_csvi/controllers/exports.php on line 140
Although for one export I seem to be getting this error:
'Unfortunately, there are no fields set for this template. Now I don't know what to export. Go to Templates -> Template fields and add the fields you would like to export.'
Your help would once again be much appreciated!
Hello,
Are you running the exports from the front-end as well?
bringing up just a plain white screen
Enable the error reporting in System -> Global Configuration -> Server -> Error reporting -> Developer. After that run it again to see the error message.
Which URL are you accessing?
The other error, indicates you have selected a template but there are no fields in this template. Is that the case?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Ye all the errors I reported are when trying to access to export from the url in the frontend.
Regarding fields in the template, everything appears to be setup as it was prior the upgrade, when I look in the template I see the relevant fields setup which all seem correct.
Once again your help is much appreciated, thanks!
Hello,
The export template works via the administrator part?
Do you know what the error is on the white page?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
Im not sure what is going on here, im thinking something must have been messed up during the upgrade but I dont know what (everything was perfect prior to the upgrade) firstly the import seems to be working fine.
I have 2 exports:
- User Export -
Running in the frontend or backend, gives me the following error, although fields appear to be setup.
Error
Unfortunately, there are no fields set for this template. Now I don't know what to export. Go to Templates -> Template fields and add the fields you would like to export.
- Mailing list export -
I get this error when running the URL on the frontend
Fatal error: Call to a member function get() on a non-object in /homepages/43/d445035053/htdocs/clickandbuilds/Joomla/Luxury_Flatshares/components/com_csvi/controllers/exports.php on line 140
And when i run within admin nothing is processed?
Processed
0
Your help would be very much appreciated, im really hoping I dont have to redo all this :(
Hello Jimmy,
Let's get this export working via the admin first before we try the front. Let's focus on the user export first. You say there are fields linked to this template. Do you see the fields when you edit the template and go to the Fields tab?
Do you have a backup of your old websites/CSVI installation?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi,
Yes I see the fields
Yes I have a backup
thanks again!
Hello,
Since you see the fields let's see what creating a backup of the templates does. Can you go to Maintenance and choose CSVI Pro -> Backup templates. Backup the templates and post the resulting XML file here. So I can check the templates to see if anything is odd.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Ok, XML is attached.
Many thanks!
Hello Jimmy,
I am able to reproduce the error you have during export saying there are no fields found because I don't have the table acymailing_action. There is something I want you to check. Go to Maintenance -> Available Fields and filter this list on Export / CSVI Pro / Custom tables. Check the box "Show ID fields" and click on Go.
Do you see your fields there? If not, go to Templates -> Templates and edit your template and make sure the correct table is selected on the Options tab and save the template. Go back to Maintenance -> Available fields and click the Update button and once it is done go back to the list of Available Fields and see if they are there. In case they are not there, go to Logs and click on the CSVI Maintenance Update available fields entry to see the details of the update. Check in the messages if you see a line like Available fields have been added for table acymailing_action.
The table should have been indexed now and once that is done, you should be able to export. You may also need to double check if the fields you have in your template actually exist in the acymailing_action table.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Thanks again for your help/reply.
Yes I could see the fields in Maintenance > Available fields without having to do anything, they show as being in 'acymailing_action' table. But when I export I see processed 0.
To be honest, when I intiially setup both import and the 2 exports they are fairly complication with replacement fields etc etc etc. Im concerned that during the joomla/csvi upgrade ive lost other elements vital for the import/export.
I have actually gone ahead and ive setup a backup of the site on a seperate domain (taken prior to the recent joomla/csvi upgrade).
So I now have access to the old site admin, isit easier/safer/better for me to export the import/export settings from the old installation and I can then use them on the new upgraded site and be 100% sure they are exactly correct. Would this be the best fail/safe way forward.
Hello Jimmy,
Ok, since you have access to the old site let's take the following procedure:[ol][li]Uninstall CSVI 5[/li][li]Install CSVI 6[/li][li]Go to Maintenance -> Maintenance[/li][li]Choose CSVI on the first dropdown[/li][li]Choose Backup templates on the second dropdown[/li][li]CSVI will report where it stored the XML file.[/li][li]On the new site, go to Maintenance -> Maintenance[/li][li]Choose CSVI on the first dropdown[/li][li]Choose Restore templates on the second dropdown[/li][li]Restore the XML file you have from the backup operation[/li][li]You should now have your templates again[/li][li]Run the export[/li][/ol]
You may end up with templates with the same name but the ones at the bottom of the list are the new ones. If the export doesn't run please send me a private message with login details for both Joomla and FTP and I will take a look what is going on.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Thanks for the reply and help!
I got the following error on step 6 when processing the backup of templates.
--
Error
Invalid Character Error
I actually made a backup of the templates before step 1 in CSVI 5, I cant possibly use this?
Or would you like me to prepare admin/ftp access for you to take a look if thats still ok? thanks again!
Hello Jimmy,
I have not seen that error before, it probably got a character it doesn't know how to handle.
The backup you made of the templates before step 1 is a dump of the csvi_templates table?
Please prepare the access to admin/ftp and I will take a look. This will be the fastest way now I think.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sent.. many thanks!
Hello Jimmy,
The mystery has been solved. Your templates had the wrong table selected. As selected table you had acymailing_action but this is not the correct table. So I selected the correct table, added the fields to the template and ran the export. All is working as far as I can tell. Please check and let me know.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Thanks for your reply and help!
Ive just run the import and it seems to have created blank items for every valid item imported, although everything else appears to be ok, (ive deleted them now as they are on the live site, but if you run the import you will see what i mean)!
The exports indeed seem to be working ok when run in the backend, although when run in the frontend via the menu item im getting a blank white screen after logging in ..when the 'destination' setting is anything other than 'Use template settings' and when it is set to 'Use template settings' i get the following error:
Fatal error: Call to a member function get() on a non-object in /components/com_csvi/controllers/exports.php on line 140
Once again thanks for your help ..looking forward to getting this fixed!
Hello,
As for the import, the import fields need to be updated to the new names. That is why the preview is more empty than filled. The preview should show all the data you want to import. The custom fields are now prefixed with their group name. This is to allow duplicate names in different groups.
As for the export, I am able to reproduce the "white screen". I tis not really a white screen, there is just no output. I am going to look further into this and get back to you.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Thanks for your help!
-
Import -
This import has 141 fields, some of which are combined fields.
Are you saying I need to go and edit these 141 fields and give the 'new names'? What are the new names, what do you mean by this, what setting must I add? This is a lot of additional work for me.
And why am I having to re enter all this information, can it really not be carried over with the upgrade from the CSVI 5???? As you know I have a backup setup of the CSVi site. -
Export -
Ok thanks can you please let me know.
A little disappointed to see after all this time it seems much still needs doing to get these working.
My client has been without the import/export for around 2 weeks now, id love to get this working asap, without having to redo much of what Ive already done.
To clarify, can everything from CSVI 5 not be carried over to the upgraded CSVI 6? As I previously spent many many many hours setting these import/exports up perfectly, it wasn't easy and Im very reluctant to have enter all these import fields again.
Thanks again Roland.
Hello,
- Import -
I have fixed the template for you. Have a look at the new LFS Import template. You can start the import and look at the preview how everything looks. You may notice I have removed a bunch of combine fields as they are no longer necessary.
And why am I having to re enter all this information, can it really not be carried over with the upgrade from the CSVI 5????
The reason is that the move from CSVI 5 to CSVI 6 is a migration and not an update. Major version changes are always more than just a click of a button, that is why it is a major version number change. This seems to have been missed.
- Export -
Ok thanks can you please let me know.
I am working on it and will let you know.
A little disappointed to see after all this time it seems much still needs doing to get these working.
As mentioned before, a major update involves more work.
My client has been without the import/export for around 2 weeks now
This thread is not 2 but 1 week old. So I guess you have been working on this before posting the issue.
id love to get this working asap, without having to redo much of what Ive already done.
As you have seen, I am working with you to get this resolved.
To clarify, can everything from CSVI 5 not be carried over to the upgraded CSVI 6?
No this cannot due to the major changes.
Edit: The front-end export is now fixed as well as far as I am concerned. Please check that as well.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, thanks again for the reply/help!
Ive just run the import and problems im afraid (ive just manually changed everything back via the k2 item).
So far ive spotted the 'room dates1-10' are not importing the date correctly, although its perfect for the combined room field.
Also room prices now have a currency sign, when this should only be added to the combined room field.
There are various issue caused on the k2 template because of the above, thats why all those replacement fields were previously in place because of the price and dates fields.
Any reason why I cant still have those running? I think you mentioned in your previous post they weren't necessary but they are!
Also when trying to run the import for the last approx 10-15 times im getting the following error, although I the server seems fast and Ive even changed back all the fields settings I changed to ensure this wasn't effecting it.
An error has occured during the import. Below the information received from the server.
Status error: 500
Status message: Internal Server Error
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Hello,
Of course I haven't made up the fields myself but modelled it after what is in your CSVI 5 installation. Since I am only human, mistakes are bound to happen.
Ive just run the import and problems im afraid (ive just manually changed everything back via the k2 item).
I think we should just be importing 1 item and leave it unpublished so it won't affect the live site and can easily be cleaned up. I did not run any import by the way, only looked at the preview.
Any reason why I cant still have those running?
I will take a look.
The 500 error is an error where the server simply says there is an error but I won't tell you what. The server error log should have the real error in it. You will need to check that or ask the hosting provider for what the error is, with that error we will know what the problem is and can deal with it.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hey JImmy,
I have taken another look, the PropertyDescription did not import because the field is not called PropertyDescription but ProperyDescription. That is fixed.
The room date shows as 21-MAR-2016. This is incorrect? If so, how should it look like?
Also room prices now have a currency sign, when this should only be added to the combined room field.
This has been fixed as well.
There are various issue caused on the k2 template because of the above, thats why all those replacement fields were previously in place because of the price and dates fields.
I have re-added the combine fields for the prices and dates.
Can you check if it is OK for you now?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Thanks again for your help, the import is now working ok :)
Regarding the exports, although these are working fine and exporting the files, im currently getting a blank white screen when running them on the frontend, there are no errors in the log or with joomla error reporting on full nothing is displayed.
Once again many thanks!
Hello Jimmy,
im currently getting a blank white screen when running them on the frontend
That is to be expected because you are exportingthe file to the server so there is nothing to show on the site.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Thanks again for the great support!
I think everything is ok now, im just doing some final testing.
Thanks again!
Glad to hear all is working out :)
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
I have an issue with the import which exists still since the recent upgrade.
Basically k2 items which already exist seem not to be updating correctly, for example on the link [removed] the property 1RL only has one room available on the imported CSV file but on the k2 item/site there is data for 2 rooms still, its not clearing the data for these fields.
Also my client is complaining of a similar issue with the k2item not updating correctly when it is unpublished.
If you have any idea what could be causing this issue I would be much appreciated I have been looking for hours, many thanks!
Hello Jimmy,
If you can post me the debug log there is something for me to look at, now there is nothing to see. Please give me a clear example what I am looking for.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
HI Roland,
Many thanks debug log attached:)
Hello Jimmy,
Your debug log is missing in the post. If the file is too big, try to compress and post it.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Sorry about that ..trying again now.
Could you please delete it once you have downloaded it, thanks!
Hello Jimmy,
You gave no indication at all what I should be looking for as I requested. So here is a random check, I found it does do an update
UPDATE `__jos_k2_items` SET `title`='Greenwich North SE10 0NZ 1RL
. So why do you think it is not doing an update?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
I did explain in a earlier post but yes perhaps not properly/with enough detail, sorry about that and thanks again for your help!
This property/k2 item fields haven't been updated correctly (item 177):
....co.uk/flatshare/177-greenwich-north-se10-0nz-1rl
This item was first added using the CSVi import and CSV import file, with data for the following fields:
- Room1ID
- Room1No
- Room1Description
- Room1DateAvailable
- Room1Price
- Room1Occupants
The room was then updated and all data for the fields above removed (you can still see that the /import/lfs-import.csv file now has no data for these fields for PropertyID:1RL) the import has been run but the data in these k2 fields still remains (hasn't been updated).
My client has complained of this issue several times now, and is also saying there is a similar issue with fields not updating when a k2 item is set to unpublished and then published.
I hope that explains everything properly, many thanks again for your help!
Hi, Just a little reminder about this, many thanks!,
This import has been giving my client problems for months now, I really keen to get everything working perfectly again, many thanks!
Hello Jimmy,
Thanks for the reminder, I will get back to you later today.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hello Jimmy,
My client has complained of this issue several times now
Let's get it fixed once and for all.
So the property ....co.uk/flatshare/177-greenwich-north-se10-0nz-1rl is an existing property as I can see an update is being run.
The room was then updated and all data for the fields above removed (you can still see that the /import/lfs-import.csv file now has no data for these fields for PropertyID:1RL)
Unfortunately I can't see that because the query only contains IDs and not the field names associated to which ID. However I will take your word for it that they are not updated.
The room was then updated and all data for the fields above removed (you can still see that the /import/lfs-import.csv file now has no data for these fields for PropertyID:1RL) the import has been run but the data in these k2 fields still remains (hasn't been updated).
This sentence is confusing but after reading it 5 times I think you are saying the data is removed in the CSV file and as such would expect it to be removed on import, correct?
From what I see this field is not processed because it is empty in the file. I would say instead of leaving the field empty and put in a space so your CSV file has " " as field, it should empty the fields.
Let me know how it goes.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, Thanks for your help, I tried to add the " " in fields that are empty. It doesn't work im afraid.
This is a live site and a popular one, this property has been showing incorrect rooms for over a week now, my client isn't happy about this, but im trying to work out the issue. So your help asap would be much appreciated.
The room was then updated and all data for the fields above removed (you can still see that the /import/lfs-import.csv file now has no data for these fields for PropertyID:1RL) the import has been run but the data in these k2 fields still remains (hasn't been updated).
This sentence is confusing but after reading it 5 times I think you are saying the data is removed in the CSV file and as such would expect it to be removed on import, correct?
About my confusing sentence and the issue here, to clarify, yes the data for some extra fields isn't being updated correctly from the CSV, the property 1RL on a previous import had data for certain fields which updated fine, but on the most recent import the data for these certain fields has been removed on the CSV (or after your last post I also tried " ") but the within k2 item the data from the first import still exists (the fields are not blank or " ")
Your help would be very much appreciated asap, as I say this issue has been ongoing for quite some time now, I want to be able to tell my client is definetly finally fixed. Many thanks!
Hello Jimmy,
as I say this issue has been ongoing for quite some time now
Well yes, as I stated in my previous comment, empty fields are not being processed because they are empty.
I am going to work out a patch and post that here once it is ready.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Many thanks Roland!
Hello Jimmy,
Attached is a patch file you can load and this adds a new feature to the K2 Item import template.
After loading the patch file you have to take the following steps[ol][li]Go to Components -> CSVI Pro[/li][li]In the menu choose Maintenance -> Tasks[/li][li]Click Reset Tasks and confirm[/li][/ol] Now you can edit your import template and you should see an Options tab with 1 option. Set this option to process empty fields to Yes and after running the import, your fields that are empty in the CSV file will be emptied in the database as well.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
HI, My client is still saying this isn't working im afraid, im just trying to find out exact details and will be in touch asap
Can you please be ready many thanks
Hello,
Just saying "it doesn't work" is not giving me anything to work with. Post the debug log of your import and I can check. Make sure you have set and saved the new template setting.
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi Roland,
Ye sorry was trying to give you a heads up as such, just desperate to get this working finally, thanks for your help again!
The import is actually failing:
COM_CSVI_PROCESS_TEMPLATE_NAME
COM_CSVI_RECORDS_PROCESSED
COM_CSVI_LAST_SERVER_RESPONSE
COM_CSVI_MAX_IMPORT_TIME_PASSED
COM_CSVI_ERROR_DURING_PROCESS
Status error: 500
Status message: Internal Server Error
Internal Server Error
The server encountered an internal error or misconfiguration and was unable to complete your request.
Please contact the server administrator, and inform them of the time the error occurred, and anything you might have done that may have caused the error.
More information about this error may be available in the server error log.
Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.
Also my client has said many times that unpublished items are not being published when updated in the CSV.
Log is attached, thanks again!
Hello Jimmy,
Let's deal with one problem at a time. First the 500 error, I need you to check with your hosting provider what the real error is in the server log, without the real error we have no clue why the server is throwing a fit.
As for the items not being unpublished, which item am I looking for?
Kind regards,
RolandD
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Hi, My client has infact requested some quite major modifications to the site, therefore Im currently changing the import and other elements on the site.
I have hit a problem straight away, in that I seem unable to save rules that I am editing (also I tried creating a new rule and saving but this also didn't work), all 3 save buttons are not clickable (save, save and new, save and close).
Thanks in advance, im very keen to continue work on this!
Hello,
You can load the patch posted on this thread to solve this issue.
Kind regards,
Tharuna
=========================
If you use our extensions, please post a rating and a review at the Joomla! Extension Directory
Many thanks!
Log in to reply to this topic.