By Guest on Thursday, 08 March 2018
Replies 17
Likes 0
Views 1.3K
Votes 0
Using Import Ical event from front page (as admin) imports a csv file as expected.
However, the imported events show up as Unpublished in the administrator panel and therefore do not show in front-end.

Expected behavior:
Like in older version of JEvents, the imported events should be immediataly be Published.
vdneut anyreason you can't add the column "PUBLISHED" and set the value of 1 for the CSV Import?
·
Wednesday, 04 April 2018 10:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Can you provide your JEvents support info? They should import as published by default.

Many thanks
Tony
·
Thursday, 08 March 2018 22:20
·
0 Likes
·
0 Votes
·
0 Comments
·
Please find the requested information and the imported file in attachement.


PHP Version : 7.0.22-0ubuntu0.16.04.1
MySQL Version : 5.5.5-10.0.31-MariaDB-0ubuntu0.16.04.2
Server Information : Linux gondor 4.4.0-93-generic #116-Ubuntu SMP Fri Aug 11 21:17:51 UTC 2017 x86_64
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Max Input Vars ? : 1000
Club code set? : No
User Agent : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36
Joomla : 3.8.5
component_com_jevents : 3.4.46
component_com_jce : 2.6.15
component_plg_kunena_comprofiler : 5.0.13
component_com_acymailing : 5.9.1
module_mod_acymailing : 3.7.0
module_mod_jevents_cal : 3.4.46
module_mod_jevents_custom : 3.4.46
module_mod_jevents_filter : 3.4.46
module_mod_jevents_latest : 3.4.46
module_mod_jevents_legend : 3.4.46
module_mod_jevents_switchview : 3.4.46
plugin_acymailing_contentplugin : 3.7.0 (not enabled)
plugin_acymailing_managetext : 1.0.0
plugin_acymailing_online : 3.7.0
plugin_acymailing_share : 1.0.0
plugin_acymailing_stats : 3.7.0
plugin_acymailing_tablecontents : 1.0.0
plugin_acymailing_tagcontent : 3.7.0
plugin_acymailing_tagjevents_j30 : 2.6.0 (not enabled)
plugin_acymailing_tagsubscriber : 5.9.1
plugin_acymailing_tagsubscription : 5.9.1
plugin_acymailing_tagtime : 5.9.1
plugin_acymailing_taguser : 5.9.1
plugin_acymailing_template : 5.9.1
plugin_content_jevents : 3.4.46
plugin_editors_acyeditor : 5.9.1
plugin_finder_jevents : 3.4.46 (not enabled)
plugin_installer_jeventsinstaller : 3.4.46 (not enabled)
plugin_kunena_comprofiler : 5.0.13 (not enabled)
plugin_search_eventsearch : 3.4.46 (not enabled)
plugin_system_gwejson : 3.4.46
·
Tuesday, 13 March 2018 20:07
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,

I'm having the same problem with one of my sites as well. It was working fine but I'm not sure when the problem started (if has been a recent upgrade or not).

Joomla! 3.8.6
JEvents 3.4.46

Thanks,
NOEL
·
Wednesday, 14 March 2018 05:43
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Noel,

I've replicated the issue. It looks like some of my code for the new selector to allow unpublished/published on import has somehow made it's way in. I'm running tests now.

Many thanks
Tony
·
Wednesday, 14 March 2018 10:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Can you both open:

/component/com_jevents/libraries/iCalICSFile.php

look for:


if ($matchingEvent = $vevent->matchingEventDetails()){
$vevent->ev_id = $matchingEvent->ev_id;
$vevent->_detail->evdet_id = $matchingEvent->evdet_id;

unset($existingevents[$vevent->ev_id]);
}


around line 303 and replace } with:


} else {
$vevent->state = $this->state;
}


and try again. Basically it publishes them if they are new events only. so the existing state should stay the same if the event already exists.

Many thanks
Tony
·
Wednesday, 14 March 2018 10:53
·
0 Likes
·
1 Votes
·
0 Comments
·
Tried it, but it did not do the job.
I also tried

$vevent->state = 1;

Which did not work either.

I tried also

if (isset($vevent->state) && !isset($vevent->published)) {
$vevent->published = $vevent->state ;
}
$vevent->published = 1; // Allways set on Published

Which did not work either.

Then I compared that section of the source with an old one (from 2014) and it was exactly the same. So my conclusion is that's not the section where the solution should be found.

Hope this helps?
·
Wednesday, 14 March 2018 18:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony,

Thanks for your prompt response.

I made the change you recommended and on a preliminary test it seems to have done the trick. What I'm doing to test is:
1) Delete (and empty trash) on all events that pre-exist from the imported calendar
2) Manually run the following command to pull in the data from my CSV...
/usr/bin/curl -s "http://mywebsite/index.php?option=com_jevents&icsid=23&task=icals.reload" > /dev/null 2>&1
3) Check my events from .../administrator/
4) Hey presto; they exist and are published. Thanks heaps!!

Vdneut; I've attached a screen shot of the change I made in case it is a help.
·
Wednesday, 14 March 2018 23:15
·
0 Likes
·
1 Votes
·
0 Comments
·
That's great thank you.

vdneut did you apply it as per noxidsoft comments?

Many thanks
Tony
·
Wednesday, 14 March 2018 23:44
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, applied as instructed. Also checked with screenshot; thanks!
However, performed import on two installations, but still unpublished events. Also new events did not show published.
The difference is in step 2). I use the frontend import option when logged in on the frontend Callendar.
Please find screenshot. I'm not able to perform import from command line.
Tried this both with Chrome as FireFox.
·
Thursday, 15 March 2018 21:59
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Ok I haven't tried the frontend but it should work with icsfile. Can you provide super user logins and the CS and the file you uploading so I can try?

Many thanks
Tony
·
Saturday, 17 March 2018 10:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks!
Please find attached the file to import. It will create a new entry as this one is unique.
Hope you'le find what's wrong.
Regards, Nico
·
Saturday, 17 March 2018 12:15
·
0 Likes
·
0 Votes
·
0 Comments
·
So to confirm, I can upload this via the frontend of your website and delete the imported events / re-import where needed?
·
Tuesday, 20 March 2018 22:58
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,
I have had the same problem, now fixed.
I just have applied the fix and seems like it works: I mod the php file (for me was line 336), I delete the imported events and then i reupload them via Anonymous update url
I post my server info if it could help
Thanks for the fix and for your job.




PHP Version : 7.0.28
MySQL Version : 5.6.38
Server Information :
Fix jQuery? : Yes
Load JEvents Bootstrap CSS? : Yes
Max Input Vars ? : 1000
Club code set? : No
User Agent : Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/65.0.3325.181 Safari/537.36
Joomla : 3.8.6
component_com_jevents : 3.4.46
module_mod_jevents_cal : 3.4.46
module_mod_jevents_custom : 3.4.46
module_mod_jevents_filter : 3.4.46
module_mod_jevents_latest : 3.4.46
module_mod_jevents_legend : 3.4.46
module_mod_jevents_switchview : 3.4.46
plugin_content_jevents : 3.4.46
plugin_finder_jevents : 3.4.46 (not enabled)
plugin_installer_jeventsinstaller : 3.4.46 (not enabled)
plugin_search_eventsearch : 3.4.46
plugin_system_gwejson : 3.4.46
·
Friday, 23 March 2018 14:25
·
0 Likes
·
0 Votes
·
0 Comments
·
So to confirm, I can upload this via the frontend of your website and delete the imported events / re-import where needed?

Sorry, did not notice your post until now!
Yes, this is a test site and please try!
Thanks!
·
Monday, 02 April 2018 16:11
·
0 Likes
·
0 Votes
·
0 Comments
·
I have a solution incoming for CSV Importing frontend.
·
Wednesday, 04 April 2018 11:08
·
0 Likes
·
0 Votes
·
0 Comments
·
·
Wednesday, 04 April 2018 11:15
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post