I add a note to an calendar entry e.g. in iCal which has a length of e.g. 800 chars. When I look into the database in oc_calendarobjects_props the field “value” is varchar(255) and just displays the 254 chars.
QUESTION:
• Where is the full text stored?
• Can I just change the field to e.g. “Longtext”?
• Is it possible to “create” a new calendar entry via creating all required records in the database? (I want to “inject” calendar entries from a tool which just has access to the database).
In the column calendardata of the database table oc_calendarobjects (your table prefix might be different from oc_).
I would not recommend to change the layout of the database.
I would also not recommend to writing calendar items directly into the database. Clients will become out of sync and also other tables related to the calendar functionality might get out of sync with oc_calendarobjects.
Can‘t you get the data from your tool and write it to the database with a caldav request? That would be a much better approach.
In the column calendardata of the database table oc_calendarobjects (your table prefix might be different from oc_ ).
Great I found it! Now I understand why you don’t recommend to writing directly.
I think I can perform a CURL with the app. But since I’m a complete newbie on that would it be too much asked to give me an example of a full CURL-request, e.g. to insert a new calendar entry? That would be very much appreciated!
Great! Thank you!
That pointed me in the right direction and I was able to upload the file. Now I have to figure out how to just upload the text w/o exporting and creating an .ics first.