Export Import CSV

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

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";

...

I also want to add my custom fields to this

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

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)

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

Thanks

What about price? How can I export price?

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.

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

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?

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