Upload CSV to CRM Calendar

[former_member761768]

Good day,

I am new in SAP and do not have much hands on experience so I hope this is a valid question.

I am required to build an upload program that needs to populate specific dates/days on the CRM Web UI calendar.

Scenario: User has an MS Excel file containing dates and details of pre-planned meetings that need to take place throughout the year. User uploads the spreadsheet onto CRM Web UI using a button and the system creates appointments (transactions) in accordance with the dates. When user looks at month view for calendar, all dates are visible for the annual plan.

How can one achieve this ? Thanks in advance for all your help.

[Kwithaer]

One approach could be converting your spreadsheet data into an iCal format, which is compatible with most calendar applications. I stumbled upon a helpful tutorial on importing iCal into Google Calendar, which might offer some insights into the process you're trying to achieve. You can check it out here: https://calendargeek.com/step-by-step-tutorial-how-to-import-ical-into-google-calendar. As for your specific scenario, here's a general roadmap you could follow: Data Formatting: Ensure your Excel file is properly formatted with columns for dates and meeting details. Conversion to iCal: Use a script or tool to convert your Excel data into iCal format. This step might require some scripting or finding a suitable tool online. Upload Functionality: Implement a feature in your CRM Web UI to allow users to upload their iCal files.