For an automated upload process, it is often convenient to use XML data formats instead of Excel worksheets. XML documents provide a flexible and easy way of interchanging data over the internet.

The upload format that is understood by Optimize My Day is very similar to the format defined in the sample Excel document. The XML example below shows a Plan XML containing two sample tasks.

Note that the attribute names of the XML Task elements correspond to the column names as defined in the Task tab of the sample Excel file.

Optimize My Day provides a REST-based API, i.e. you can upload XML documents automatically by using the HTTP POST method. Posting an XML document to Optimize My Day actually uses the same mechanisms as uploading it through the configuration's menu option Planning -> Data Up-/Download -> Upload of Data. However, for automated processes, you may want to use the BASIC authentication mechanism.

If you intend to post the XML programmatically, post the XML document to the URLhttps://www.optimizemyday.com/omdservices-basic/Configuration/<ConfigurationIdentifier>/Plan, where<ConfigurationIdentifier> is the number of your specific configuration.

To allow basic authentication, you will have to provide a Base64-encoded username/password header along with the HTTP request. If you intend to send a zipped XML document, add the zipped=true parameter to the URL.

Alternatively, you may use the Folder-based Gateway. This program scans a specified file system folder for XML documents. As soon as a new file is added to the folder, the content is uploaded to Optimize My Day and the file is moved to an archive folder. The result of the upload is stored in either a success or failure folder, depending on the result of the upload.

The folder-based gateway must be installed on a server in your IT environment. It must have access to the public internet. It is your responsibility to store the relevant plan data as XML documents in the inbound folder of the Folder-based Gateway.