Portal Engine Questions on portal engine and web parts.
Version 4.x > Portal Engine > Import of press releases from Excel? View modes: 
User avatar
Member
Member
Bryan White - 9/9/2010 2:18:53 PM
   
Import of press releases from Excel?
Let me know if I'm way off base here. I'm in the middle of developing a site for a client. This site is a clone of an existing Kentico CMS site and I've been updating the CSS and content accordingly. For their Press Releases, though, they have provided me with an Excel file containing all the press releases from the previous site and left me with the impression that I can just import these into the CMS with the click of a button.

This doesn't sound likely but before I go back to them I just want to be sure that I understand this completely and that this spreadsheet isn't what I need. It seems unlikely to me that I can import them this way but it also seems unwieldy to have to manually enter them one by one. Is there an easy way to take these press releases and get them into the CMS? The repeater for the press releases is already in place.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 9/10/2010 2:28:54 AM
   
RE:Import of press releases from Excel?
Hi,

I am afraid but this functionality is not present in current version. However, improvements similar to this one are planned for future versions.

Right now, you will need to build a custom utility - in which code you will read the data from excel sheet and assign appropriate excel columns to the document columns and save the values. You can find API examples on how to mange documents here.

Best regards,
Juraj Ondrus