I'm currently developing an Umbraco website (7.4.2) containing a large product catalog where the customer has all the information readily available from an Excel Spreadsheet. To make it easier for him to work with products, I have planned to create a small desktop application that enables him to use this spreadsheet to add/modify products in the catalog (and update Umbraco accordingly).
It looks like I'm out of luck regarding the nuget packages available, so to me it seems like the Umbraco webservices is the way to go? I tried adding the
Would it be better to turn to the UmbracoApiController to create an endpoint allowing me to upload the spreadsheet for further processing?
If you know of any examples of doing so, then please let me know!
Otherwise you can do what I've done and that is to write your own custom API or SurfaceControllers to take data in some format (either HTTP post values or XML or JSON) and then programmatically generate pages in Umbraco using the Content API. See:
It might be easier, though, if the data is in a spreadsheet to get your customer to export it as CSV and then create an upload feature to let him upload all the data via that.
Modifying contents of Umbraco 7.0+ from external application
Hello.
I'm currently developing an Umbraco website (7.4.2) containing a large product catalog where the customer has all the information readily available from an Excel Spreadsheet. To make it easier for him to work with products, I have planned to create a small desktop application that enables him to use this spreadsheet to add/modify products in the catalog (and update Umbraco accordingly).
It looks like I'm out of luck regarding the nuget packages available, so to me it seems like the Umbraco webservices is the way to go? I tried adding the
Would it be better to turn to the UmbracoApiController to create an endpoint allowing me to upload the spreadsheet for further processing?
If you know of any examples of doing so, then please let me know!
Best regards Stefan
Have you had a look at https://our.umbraco.org/documentation/Implementation/Rest-Api/ ? Not tried this, but worth a look.
Otherwise you can do what I've done and that is to write your own custom API or SurfaceControllers to take data in some format (either HTTP post values or XML or JSON) and then programmatically generate pages in Umbraco using the Content API. See:
https://our.umbraco.org/documentation/Implementation/Controllers/
https://our.umbraco.org/documentation/Implementation/Data-Persistence/
It might be easier, though, if the data is in a spreadsheet to get your customer to export it as CSV and then create an upload feature to let him upload all the data via that.
is working on a reply...