Thursday, 08 March 2018
  17 Replies
  1.1K Visits
0
Votes
Undo
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.
7 years ago
·
#199617
Accepted Answer
0
Votes
Undo
vdneut anyreason you can't add the column "PUBLISHED" and set the value of 1 for the CSV Import?

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#198657
0
Votes
Undo
Hello,

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

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#198882
0
Votes
Undo
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
7 years ago
·
#198897
0
Votes
Undo
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
7 years ago
·
#198908
0
Votes
Undo
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

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#198911
1
Votes
Undo
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

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#198934
0
Votes
Undo
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?
7 years ago
·
#198943
1
Votes
Undo
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.
7 years ago
·
#198944
0
Votes
Undo
That's great thank you.

vdneut did you apply it as per noxidsoft comments?

Many thanks
Tony

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#198966
0
Votes
Undo
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.
7 years ago
·
#199035
0
Votes
Undo
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

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#199039
0
Votes
Undo
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
7 years ago
·
#199133
0
Votes
Undo
So to confirm, I can upload this via the frontend of your website and delete the imported events / re-import where needed?

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#199281
0
Votes
Undo
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
7 years ago
·
#199525
0
Votes
Undo
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!
7 years ago
·
#199617
Accepted Answer
0
Votes
Undo
vdneut anyreason you can't add the column "PUBLISHED" and set the value of 1 for the CSV Import?

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#199622
0
Votes
Undo
I have a solution incoming for CSV Importing frontend.

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

7 years ago
·
#199624
0
Votes
Undo

JEvents Club members can get priority forum support at the Support Forum. As well as access to a variety of custom JEvents addons and benefits. Join the JEvents club today!Join the JEvents club today!

  • Page :
  • 1
There are no replies made for this post yet.