By metabern on Thursday, 19 April 2018
Replies 11
Likes 0
Views 1.9K
Votes 0
I am in the process of configuring my events with all of the parameters showing and filled. I want to export a full event as a csv and then using it's format, add more events to my csv and import them into Jevents.

I see there is a way to export events as CSV
https://www.jevents.net/docs/item/using-range-list-for-print-layout-of-events

Can I det this file and then reimport it back into Jevents? Will this work?
Hello,

Now you will be better using the JEvents List of Events Menu item and setting as a CSV Export Menu Item.

You should be able to import this, but you may need to change the column headings to match as per:
https://www.jevents.net/frequently-asked-questions/importing-events-in-csv-format

Many thanks
Tony
·
Thursday, 19 April 2018 08:43
·
0 Likes
·
0 Votes
·
0 Comments
·
I was able to create an export csv file that works, I added as many parameters as I could using the references on the documentation pages and so far successful. I want to add even more parameters to my event export, is this possible?

Below you can see the fields I added.

I would like to add all RSVP Pro parameters including payment type, price, reg opening, reg closing etc. How can I do that and where can I reference the list of RSVP Pro options?

Also my export csv has all of the html code in it. Is there a way for me to strip that out? Either in csv export or import? (See Attached)

Currently my csv export has start date and time the same. Not sure why that is(See attached)

changed portion of my csvprintevents.php file

...

global $fields;
$fields = array();
$fields["Title"] = "title";
$fields["Category"] = "catname";
$fields["Description"] = "content";
$fields["Location"] = "location";
$fields["StartDate"] = "startDate";
$fields["StartTime"] = "startTimeConstrained";
$fields["EndDate"] = "endDate";
$fields["EndTime"] = "endTimeConstrained";
//$fields["All Day Event"] = "alldayevent";
//$fields["No End Time"] = "noendtime";
$fields["Creator"] = "creatorName";
$fields["Contact"] = "contact_info";
$fields["Tags"] = "getTags";
$fields["Keywords"] = "getKeywords";
// Other fields that may be available
$fields["Location"] = "location";
// Custom fields
$fields["Field2"] = 'customfields["field2"]["value"]';
// Standard Images/Files
$fields["Image1"] = '_imageurl1';
$fields["Image1Title"] = '_imagetitle1';


// THE FIELDS I ADDED
$fields["Category description"] = "getCategoryDescription";
$fields["Published?"] = "published";
$fields["All Day Event?"] = "alldayevent";
$fields["End time?"] = "noendtime";
$fields["Multiday?"] = "multiday";
$fields["Contact Info"] = "contact_info";
$fields["Contact Link"] = "contactLink";
$fields["Extra Info"] = "extra_info";
$fields["Published"] = "published";
$fields["Year Start"] = "yup";
$fields["Month Start"] = "mup";
$fields["Day Start"] = "dup";
$fields["Hour Start"] = "hup";
$fields["Minute Start"] = "minup";
$fields["Year End"] = "ydn";
$fields["Month End"] = "mdn";
$fields["Day End"] = "ddn";
$fields["Minute End"] = "mindn";
$fields["Is Repeat?"] = "isrepeat";
$fields["Repeat Summary"] = "repeatSummary";

...
·
Monday, 23 April 2018 21:29
·
0 Likes
·
0 Votes
·
0 Comments
·
I also want to add my custom fields to this
·
Monday, 23 April 2018 21:36
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

Please see:
https://www.jevents.net/frequently-asked-questions/importing-events-in-csv-format

Scroll down and you will see the information about RSVP Pro settings/custom fields and so on.

Many thanks
Tony
·
Tuesday, 24 April 2018 13:57
·
0 Likes
·
0 Votes
·
0 Comments
·
Hi Tony, I have looked at this page and have already added all of the RSVP pro fields listed

According to this page, my custom fields would look like this if I am correct

$fields["Course Code"] = "Course_Code";
$fields["Age"] = "Age";
$fields["Course Type"] = "Course_Type";


THe page you referred to doesn't answer these questions:
I would like to add all RSVP Pro parameters including
-payment type,
-price,
-registration opening,
-registration closing,
- etc.

How can I do that and where can I reference the list of RSVP Pro options?

Also my export csv has all of the html code in it. Is there a way for me to strip that out? Either in csv export or import? (See Attached)
·
Tuesday, 24 April 2018 14:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

So:

rsvp_regopen
When will your registrations for the event start.
Use format: "YYYY-MM-DD hh:mm:ss"
rsvp_regclose
When will your registrations for the event finish.
Use format: "YYYY-MM-DD hh:mm:ss"

are your registration open/close.

You can't set the template fields you would have to have a single default RSVP Pro template which is auto-assigned as default.

Re the custom fields, it depends on the name which can be different to the name, it is shown on the attached.

Many thanks
Tony
·
Tuesday, 24 April 2018 18:05
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks

What about price? How can I export price?
·
Tuesday, 24 April 2018 18:16
·
0 Likes
·
0 Votes
·
0 Comments
·
I've managed to add custom fields to my export in my csvprintevents.php file they work properly. I added this to my prientevents file:

$fields["Course Code"] = 'customfields["Course_Code"]["value"]';
$fields["Child's age"] = 'customfields["Childs_age"]["value"]';
$fields["Course Type"] = 'customfields["Course_Type"]["value"]';


I cannot get rsvp elements to work

I have added them to my print events file like this:

$fields["Registration Open"] = "rsvp_regopen";
$fields["Registration Closed"] = "rsvp_regclose";
$fields["Price"] = "rsvp_flatfee";

This doesn't seem to work as my csv output shows the 3 columns but has "n/a" in each cell, even though there is data that has been added to events

I have attached my updated csvprintevents.php file. My goal is to be able to export a csv that has ALL fields available from events and rsvp.
·
Tuesday, 24 April 2018 19:04
·
0 Likes
·
0 Votes
·
0 Comments
·
Sorry I've just clicked you are talking about exporting above and you have done a custom file?

Is there any reason you haven't used the List of Events menu item as originally suggested with just ticking the CSV option on the menu item? This displays all fields available in the menu item.

You may need to configure RSVP Pro to show counts and attendees in lists/calendars.

Many thanks
Tony
·
Tuesday, 24 April 2018 22:13
·
0 Likes
·
0 Votes
·
0 Comments
·
That was a great help, it appears that I can do a pretty comprehensive csv export. So far so good

now I want to import that csv back into Jevents using the calendar /scratch / ical method.

I get as far as creating a new calendar and selecting my csv for upload . There is a "Load iCal from File" button. Thats the only option and it fails and reverts to the calendar manager

Any thoughts?
·
Tuesday, 24 April 2018 23:13
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello,

I suspect the headers might not be matching. Can you provide a copy of the export and I'll take a quick look for you?

Many thnaks
Tony
·
Wednesday, 25 April 2018 08:37
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post