CMSImport PRO User manual
Contents
1. Select BlogML export file PUERTA m Select a local file Bladeren J Specify a url http iv Optimize for BlogdUmbraco CMSIimport determined that you have installed Blog4Umbraco When you check the Optimize for Blog4Umbraco option CMSlmport will automatically import the comments and CMSlmport will automatically map the document properties for you Previous Next 3 3 8 WordPress In case of Wordpress you can upload a Wordpress file or point to a location When you have uBlogsy Blog4Umbraco or the Blog starterkit installed you can specify that you want to optimize for either uBlogsy Blog4Umbraco Blog starter kit When you enable that option CMSImport will automatically import comments and store it in the correct comments table also Don t select this option when you just want to import the blogposts and blogcomments based on an Umbraco documenttype Select Datasource Y Muret Wordpress export select a local file F umbracolProductst J Specify a url http Y Optimize for Blog4Umbraco CMSimport determined that you have installed BlogdUmbraco When you check the Optimize for Blog4Umbraco option CMSlmport will automatically import the comments and CMSlmport will automatically map the document properties for you Previous Next 3 4 Select destination and document type In this step you need to specify the location where you want to store the imported documents This is prefilled if2. 2012 Soeteman Software page 42 49 CMSImport PRO User manual Version 2 3 Import Finished import is finished Import duration h m s 00 00 39 Records retrieved 295 Records imported 50 Errors 245 The following errors occured Conversion failed when converting the nvarchar value Multi to data type int Conversion failed when converting the nvarchar value Silver to data type int Conversion failed when converting the nvarchar value Blue to data type int Conversion failed when converting the nvarchar value Blue to data type int Conversion failed when converting the nvarchar value Blue to data type int Conversion failed when converting the nvarchar value Silver to data type int Conversion failed when converting the nvarchar value Silver to data type int Conversion failed when converting the nvarchar value Black to data type int Conversion failed when converting the nvarchar value Black to data type int Conversion failed when converting the nvarchar value Black to data type int Conversion failed when converting the nvarchar value Black to data type int Conversion failed when converting the nvarchar value Black to data type int nnesoarrinn failad whan enmartiina tha rarzhar walia Rlack ta data hina int This can be solved using a FieldAdapter For our implementation we want to retrieve the Id of the prevalue and return that id instead of the text value Additional it would also be nice if we can create the prevalue when i
3. de Runway Homepage de Productimport Site Name Productimport Recycle Bin Site Description Just a placeholder 9 4 Create a DataAdapter for Product Categories A DataAdapter could be used to communicate with a DataSource Basically it lets you set some properties and returns data to CMSImport which can then be imported In the Sample project we are using two DataAdapters 1 ProductCategoryAdapter responsible for importing all product category data 2 ProductDataAdapter responsible for importing all product data 2012 Soeteman Software page 38 49 CMSImport PRO User manual Version 2 3 9 4 1 Create the class To create a custom DataAdapter you need to create a class that derives from CMSImport Extensions DataAdapter ImportDataAdapter public class AdventureWorksLTProductCategeoriesDataAdapter ImportDataAdapter 9 4 2 Specify an alias The alias you specify by overriding the Alias property will be shown in the pulldownlist where the user can pick a DataAdapter This alias must be unique public override string Alias get return AdventureWorks ProductCategories 9 4 3 Add UI The ImportAdapter class itself derives from the Webcontrol Class so we can directly add UI Controls to this class private Panel _contentPanel new Panel private TextBox _datasourceTextBox new TextBox private Literal _selectDataSourceLiteral new Literal protected override void OnInit EventArgs e base OnI
4. 292 Delete White 293 Delete Grey 294 Delete Add prevalue And you ll see that these Prevalues are mapped correctly against the document Product Properties HQ A ProductName Road 150 Red 52 Product Number py posp 52 ProductPrice 3578 2700 Product color 2012 Soeteman Software page 44 49 CMSImport PRO User manual Version 2 3 10 Manual Installation Configuration If you renamed the Umbraco folder or for some reason can t give the installer sufficient rights to create tables in the database or the sufficient rights to modify the following folders bin config umbraco you need to install CMSImport PRO Manually 10 1 Manual installation of files Open de folder in the zip file Copy all Except for HtmlAgilityPack dll dll files to the bin folder of your Umbraco installation Copy HtmlAgilityPack dll to the bin legacy folder of your Umbraco installation Copy your license file to the bin folder of your Umbraco installation Open the umbraco plugins folder Create the folder CMSImport Create the following folders in the umbraco plugins CMSImport folder o Config o Handlers o Pages o Usercontrols In the umbraco plugins CMSImport Usercontrols folder create the folder ImportSteps In the umbraco plugins CMSImport Usercontrols ImportSteps folder create the folder Contentimport In the umbraco plugins CMSImport Usercontrols ImportSteps folder create the folder Memberlmport Copy all config files f
5. You can also specify some domains url s that needs to be picked up Url s starting with that 2012 Soeteman Software page 33 49 CMSImport PRO User manual Version 2 3 domain will also be picked up You still need to make sure files are located in the root of your Umbraco install Additional media settings for fields mapped against a Richtext property Allowed extensions for file import Specify file extensions for files that must be imported when mapped against a Richbext property other file extensions will be ignored mp Add extension When mapped against a normal media picker all file extensions will be picked up m K Parse media for the following domain http Miess urls OU QUEEN NN CMS import can only import files that ares stored Mesa P aei in the rootfolder of Umbraco by default a IDEO MONT RS WEINE Sometimes a full url is specified in a field that is http wwwsoetemanoftwaren mapped against a Richtext property This setting allows you to specify domain urls so url s containing these domain urls will be cormerted to relative paths example http e c RN T fscreenshat png will be converted to images fscreenshat png when you specify the domain url http wuw cmsimpart com ei 8 4 Data adapters CMSImport comes with a lot of DataAdapters you might not want to use In this section you can disable the items you don t want to use CMGimport PRO 2 0 ded Below you can enable or disable
6. displayLang en 22 Make sure to enable 32 bits applications on the application pool running the website advanced Settings EI E4 El General ae Mame ASP MET v4 0 Queue Length 1000 Stark Automatically True El CPU Limit T lira Abr R l Aer 11 5 Email is not send when importing a member Make sure you have configured your smtp server in your web config file Also check the UmbracoLog table for SMTP errors 11 6 I get an Invalid License exception Make sure your license file exists in the bin folder and you ve bought the correct license Contact support soetemansoftware nl for help 2012 Soeteman Software page 49 49
7. 0 2 Manttal Configuration or DataD ascii E E E 45 10 3 Manual configuration of the language les 47 10 4 Manual configuration of the scheduled task handler cccccseecceesseeeeeceeeeeesaeeeeeeseeeeeesaees 47 11 TROUBLESHOOTING ee E 49 11 1 don t see the CMSImport package in my developer sechon 49 11 2 don t see my column names when importing from a CSV file sseessssuss 49 11 3 get weird column names when importing from a CSV ie 49 11 4 lgetan error not supported error when using access or excel files 49 11 5 Email is not send when importing a member 49 1136 Igetaninvalla License except dea 49 2012 Soeteman Software page 3 49 CMSImport PRO User manual Version 2 3 1 Introduction CMSImport PRO helps you import content or members from any datasource into Umbraco The following datasources are supported by default e Access Database e BlogML e CSV e Excel File e RSS Feed e SQL Server e WordPress e XML CMSImport PRO allows you to save wizard steps so you can run the import later or even schedule it for a certain date and time When you re run an import already existing records will be updated and only new records will be added When media is imported references in content or member data will be updated automatically And best of all with CMSImport Pro it s possible to import complete content structures also This allows you to
8. CMSImport PRO User manual Version 2 3 CMSImport PRO User manual Version 2 3 E INTRODUCTION ou illa nicas 4 Z INSTALLATION EE 5 3 IMPORTCONTEN pee et 6 3 1 Je geet e PA sous E saaeden vest onaeteesenonee 6 32 Select DataSource Tl VOC EE 7 3939 SA e e e dd e 7 3 3 1 AE A PFP Ee 7 3 3 2 AP e Ae 8 3 3 3 X ME E 8 3 3 4 eis le 9 3 3 5 o M HEAD cro E PECTORE E 9 3 3 6 ASS POCO e T Xx MM n 10 3 9 7 BIOOM E traicion 10 3 3 8 e ie EE 11 3 4 Select destination and document type coooonccncccccnccnnncccnoncnnnononancnnnnonnnncnnnnnnnnncnnnnonannnnnnnnnannos 11 3 5 Create MAPPING sitas T 12 3 6 Seem O Vee ea oS as ae cus a eoetaesust castes edee 14 3 7 A a a 15 3 9 Save IMPON sleps EE 15 9 9 Greate er He COMMON ER 16 3 9 1 121 21 0 data IC is 16 3 9 2 SPECIFY CONTENT port ee le scada aa diras 17 3 10 o PP a a a i a 17 A IMPORT MEMBERS coil is 19 4 1 Ali CTO EE 19 AZ OEEC DAI OUr Ty OC EEN 19 A 19 4 3 1 SI M MTM 20 4 3 2 Gol Er M C 20 4 3 3 UM Ir 20 Aa Select member type dnd Re EE 21 4 5 Create Mapping occccccocnnnccconnncoconcnnononcnnnnnnnnnnn nennen nennen nnn nn nn nnns nu nnns suis n risas sanas sa anra sa nnns nans 22 4 6 Sr nnnc O A A 22 4 7 Ines GE 23 40 E EE Ee 24 5 RELATED MEDIA IMPORT e ees 25 5 1 o A A 26 52 A A ener eee 27 5 3 UComponents Multi Node Tree Picker MNTP oooocccnnccccncccncccccocconnccnnonccnnonnnnncnnnconnanenn
9. LT Customer Data Options Member type Company Selected Roles Customer Company Action when Update record member exists Automatic generate True password Send member False credentials via mail Mapping Document property Database column name CompanyHame login EmailAddress email Email amp ddress telephone Phone Version 2 3 Previous Next 4 7 Import When you click next in this step the import starts When the import is finished it will report what it did If there were any errors it will also report the errors CMSImport PRO 1 1 4 1 Import Finished Import is finished Import duration 00 01 29 h m s Records retrieved 440 Records imported 440 Errors 0 Previous O 2012 Soeteman Software page 23 49 CMSImport PRO User manual Version 2 3 4 8 Save Import steps When you click save you can specify a name and when hitting the save button again the import steps are saved for later use CHMSImport PRO 1 1 wi y Save the import steps for later reference Save import steps as Customers 2012 Soeteman Software page 24 49 CMSImport PRO User manual Version 2 3 5 Related media import CMSImport can import media also This isn t a separate import process but integrated in content or media import When CMSImport finds a reference to a relative path it will try to get the item and convert it to a media item or store it in the media folder in case of an upload field The only req
10. NULL CONSTRAINT PK_CMSImportScheduledTask PRIMARY KEY CLUSTERED teDays Scheduleld ASC WITH PAD_INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW ROW LOCKS ON ALLOW PAGE LOCKS ON ON PRIMARY ON PRIMARY CREATE TABLE CMSImportRelation Id int IDENTITY 1 1 NOT NULL UmbracoID int NOT NULL UmbracoParentId int NOT NULL DataSourceKey nvarchar 250 NOT NULL CONSTRAINT PK CMSImportRelation PRIMARY KEY CLUSTERED Id ASC WITH PAD INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW ROW LOCKS ON ALLOW PAGE LOCKS ON ON PRIMARY ON PRIMARY CREATE TABLE CMSImportMediaRelation Id int IDENTITY l1 1 NOT NULL UmbracoMediaId int NOT NULL SourceUrl nvarchar 500 NOT NULL CONSTRAINT PK CMSImportMediaRelation PRIMARY KEY CLUSTERED Id ASC WITH PAD INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW ROW LOCKS ON ALLOW PAGE LOCKS ON ON PRIMARY ON PRIMARY CREATE TABLE dbo CMSImportScheduledItems SchedulediIitemId int IDENTITY 1 1 NOT NULL ScheduleldTaskId int NOT NULL ScheduledOn smalldatetime NOT NULL ExecutedOn smalldatetime NULL CONSTRAINT PK CMSImportScheduledItems PRIMARY KEY CLUSTERED ScheduledlItemId ASC WITH PAD INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW
11. Possible icons for saved content items Standard import definition Recursive import definition 3 9 Create a child definition When you want to use structured imports its possible to create a child definition In the previous example we were importing Product categories Now we can import products for those categories Right click on the parent definition in this case ProductCategory and select Create child definition 4 CMSImport t4 Import data d Je Import definitions a A Content E ProductCategory gt a Create child definition gt Ji Sch gt Ji Set E Schedule p Execute X Delete This will start the import wizard again with a few small changes 3 9 1 Select datasource When selecting the same datasource type as the parent it will automatically select the same datasource as its parent 2012 Soeteman Software page 16 49 CMSImport PRO User manual Version 2 3 Select Datasource Select file Bladeren 9 Select a local file Selected datasource Products xlsx J Specify a url http Select a worksheet Products v eem enm 3 9 2 Specify content import options When you set the content import options you don t need to specify the location since that will be determined based on the parent record Instead you specify the parent relation key In this case we want to add a relation based on category id so we specify ProductCategoryld as the relation All other steps are the same Select Destinatio
12. ROW LOCKS ON ALLOW PAGE LOCKS ON ON PRIMARY ON PRIMARY CREATE TABLE CMSImportCustomRelation CustomRelationld int IDENTITY 1 1 NOT NULL Umbracotda int NOT NULL Alias nvarchar 250 NOT NULL DataSourceKey nvarchar 250 NOT NULL Relatedld nvarchar 250 NOT NULL CONSTRAINT PK CMSImportCustomRelation PRIMARY KEY CLUSTERED CustomRelationld ASC WITH PAD_INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW ROW LOCKS ON ALLOW PAGE LOCKS ON ON PRIMARY ON PRIMARY ALTER TABLE dbo CMSImportState ADD Recursive bit NULL Parent uniqueidentifier NULL ALTER TABLE dbo CMSImportScheduledItems ADD InProgress bit NULL ALTER TABLE dbo CMSImportScheduledTask ADD ImportAsUser int NULL 2012 Soeteman Software page 46 49 CMSImport PRO User manual Version 2 3 10 3 Manual configuration of the language files When the install failed due insufficient rights of the installer It s better to assign sufficient rights to the umbraco config lang folder and all the xml files in that folder Then start CMSImport PRO again CMSImport Pro will determine that the language file is not updated and will automatically update the language files again If for some reason this isn t the case you can modify the files manually To do this open the necessary language files For example if you use the English language in Umbraco open en xml if you use the Dutch language in Umbraco open nl xml etc Re
13. Soeteman Software page 32 49 CMSImport PRO User manual Version 2 3 8 Settings Here you can modify the following settings 8 1 Login credential settings These settings will be used when an email with login credentials is send to an imported member You can specify The from email address The email subject The email body In the email body you can use the following placeholders that will be replaced with real values when sending the email Snippet Description Hloginname The loginname of the imported member Hpassword The password NOT ENCRYPTED of the imported member Hemail The Email address of the imported member property alias This will replace the property alias with the imported value 8 2 Scheduler result settings These settings will be used when an email is send to inform a user that a scheduled task is finished You can specify The from email address The email subject The email body In the email body you can use the following placeholders that will be replaced with real values when sending the email Snippet Description HTaskname The name of the scheduled task amp Duration The duration of the import process HRecordCount The amount of records in the datasource 8 3 Media settings In this section you can specify which file extensions CMSImport needs to parse in case of media import mapped against a Rich Text editor Only the selected file extensions will be picked up to import
14. ake sure all folders containing the images are stored in the root of this umbraco environment Read the manual for a detailed description Use a comma seperated string of images if you want to assign more than 1 image example img image1 img image Media location Specify a location where to store the imported media items Public Delete Choose Default value Pick a default media item that will be used in case the assigned value is null Choose When the import process is finished you ll see that the media items are imported DAMP Classic Choose Create xsltrebel Edit Open Pixlr Remove logos Edit Open Pixlr Remove TIP Using the DAMP V2 datatype you can specify a comma separated list of images you want to import 5 5 Upload field When an image could also be a file reference is mapped against an upload field CMSImport will store the image in the Umbraco Media folder and update the reference in the Upload field When the import process is finished you ll see that the media items are imported Damp version 2 x only 2012 Soeteman Software page 28 49 CMSImport PRO User manual Version 2 3 PEA COREA Media Contents Properties A Media 4 id a Ak import 4 kb img Contents za logos Za altrebel 5 RecycleBin Sections al EK O Conant Mera Linen ert res A Developer dae And when you open an imported item in the content section you ll see that all the references are updated to the import
15. d when we select the AdventureWorks ProductCategory DataAdapter we will see the following screen CMSImport PRO 1 1 4 l Select Datasource Enter the connection string Previous Next We can provide a Connection string and click next to continue the import process the normal way 9 5 Create a DataAdapter for Products Since we will be importing both Categories and Products we want to have a Custom DataAdapter for products also Do this by copying the ProductCategories DataAdapter and name it AdventureWorksProducts rename the alias to AdventureWorks Products and replace the query in the UpdateAdapter method to SELECT FROM SalesLT Product order by Name 2012 Soeteman Software page 41 49 CMSImport PRO User manual Version 2 3 a Products d de Accessories 4 Bike Racks Kal 4 Bike Stands Kal 4 A Bottles and Cages Ka E a A Cleaners Kal d A Fenders 3 2 A Helmets 4 3 3 4 n Hydration Packs gt Ly Lights gt de Locks gt A Panniers gt de Pumps gt A Tires and Tubes gt A Bikes 9 6 Using a FieldAdapter to map text values against a Dropdownlist DataType As you might have seen our Product DocumentType contains a property ProductColor which is based on the ProductColor Dropdownlist When we map the color column form the AdventureWorks Products table directly against the ProductColor document property the import will fail because it can t convert text to integer values
16. ed media items Conbent Conbent Properties de Content ag wn X Ua A Styles B EISE CS A Runway Homepage Lorem ipsum dolor sit amet consectetuer adipiscing elit amp naan commodo ligula H A Import y A Foto 1 A Foto 2 7 Reevele Bin eget dolor Aenean massa Cum sociis nateque ug TE penatibus et magnis dis parturient montes nascatur ridiculus mus Doner quam felis ult ImageUpload Sections 2 Remove file Comer Meda T bei reg A Media xsltrebel Delete Choose Developer Meerterz Currently this import process will work for the following datatypes Upload field Media Picker TinyMCE Multi Node Tree Picker Media only DAMP Version 2 0 2012 Soeteman Software dh Stam page 29 49 CMSImport PRO User manual Version 2 3 6 Schedule Imports With CMSImport it s possible to run imports for on a certain day time When you right click on a saved import item content member and click schedule the following screen will show up CMSImport PRO 1 1 H Saved import name CMSlmport manual scheduled task name Daily import records for CMSImport manual Notify emailadress manual cmsimport com Run task as Administrator a Execute every Week Day Hour Monday Tuesday Wednesday Thursday Friday Saturday El Sun day Time o v 0 You can schedule imports to run every week on certain days time every day on a certain time or every hour You can specify an email address to rec
17. eive a notification when the import is finished and you can specify a user that will be assigned as creator for imported documents members When you click save the item will run on the selected day time 2012 Soeteman Software page 30 49 CMSImport PRO User manual Version 2 3 a jj CMSImport Sa Import data gt de Import definitions a A Scheduled imports gt A Weekly a KR Daily is Products gt A Hourly gt Settings When the import is finished you will receive a notification email on the specified email address 6 1 Scheduled task log When you right click on a scheduled task you can view when the task did execute As you already can see in the image below the scheduled time can be a little different from the real executed time This can be caused by the website not being up at the given time The scheduler will always execute the task when the site is back up and did not run the task This dialog gives some insight when that happened Scheduled task log x Scheduled Products task Schedule Every day at 16 28 Next run time 11 June 2011 16 28 Last run time 10 June 2011 16 29 Scheduled Executed 10 June 2011 15 28 IO June 2011 16 24 Clear history 2012 Soeteman Software page 31 49 CMSImport PRO User manual Version 2 3 7 Import Dashboard Using the Import Dashboard you can allow content editors to upload data and media items optional without giving the user access to the Developer section This is ideal when y
18. ence will be updated Make sure all folders containing the images are stored in the root of this umbraco environment Read the manual for a detailed description Enable Image import Select image location Import Delete Choose Import files By enabling Image import images stored with a relative url will be imported automatically into Umbraco and the reference will be updated The following extensions are supported doc dacx pt ppt pptx rar xls xalsx zip You can add remove extensions in the settings folder of CMSIlmport Make sure all folders containing the files are stored in the root of this umbraco environment Read the manual for a detailed description Enable file import Select file location Import Delete Choose 2012 Soeteman Software page 26 49 CMSImport PRO User manual Version 2 3 5 2 Media picker When you map against a mediapicker datatype you can specify the import options as shown below and CMSImport will create a media item and store the Id of the media item Download Alias mmediaPicker Tab Content Image T e Media location Import Delete Choose Default value Public file Delete Choose 5 3 Multi Node Tree Picker MNTP When you map against the Multi Node Tree Picker you can specify the import options as shown below and CMSImport will create a media item and store the Id of the media item Only datatypes configured for Media can be used MediaMntp Image Q Alias mediaMnt
19. import a complete product catalog Categories and Products blogposts comments or any structure you want to import CMSImport PRO is optimized for uBlogsy Blog4Umbraco TeaCommerce and Uwebshop This document describes PRO features only The free edition is limited in functionality Access and Excel file requires you to install an extra driver from Microsoft 2012 Soeteman Software page 4 49 CMSImport PRO User manual Version 2 3 2 Installation Install the CMSImport PRO package using the Umbraco package installer SF DEEN a Absui o bisig ud Logout mimin Developer metal bing the package C memga de Developer de Cache Browser Please note Installing a package containing several items and files can take some time Do not refresh the page or navigate di Data Types away before the installer motifies you the install is completed A Marco a de Packages ES Limbraco package Repoaillpny Rame Cmsimport Version 2 0 di Created packages Author Soeteman Software b Imstaled packages A Installed packages More info hktp faran cmsimpart com de Install skin License Umbrsco Deli Package License Agreement Standard Y install local package A Scripting Files E Accept license Y Accept license SLT Fies Read me CMS5Impeort helos you import content or members from any datasource into Umbraco by simply defining a mapping bebasan the Datasource amd Umbraco properties The folleretng datasources ane supported by defaulk SOL Se
20. is record by setting the cancel property to true 9 2 3 2 Recordlmported The Recordlmported event gets hit after a record got imported the sender object contains the imported document or member RecordimportedEventArgs contains the following information e DataAdapter e DataKeyName Primary key column e DataKeyValue Primary key value e ImportAction ImportAsNew update or skip record e tems collection of items that contains the original data 9 2 3 3 Importing The Importing event gets hit before the import starts ImportEventArgs contains the alias of the DataAdapter 2012 Soeteman Software page 37 49 CMSImport PRO User manual Version 2 3 9 2 3 4 Imported The Imported event gets hit after the import has finished ImportEventArgs contains the alias of the DataAdapter 9 3 Samples When you ve downloaded and installed the samples you can use two extra document types in your Umbraco installation ProductCategory and Product Before you start make sure the ProductColor datatype uses the integer Database datatype Edit datatype ProductColor H Name ProductColor Render control Dropdown list E Data Type GUID a 4ea9c9 Be 18 4d2a Bcf6 73c6206c5da6 Add prevalue All samples will use the above mentioned document types Only thing you need to do is to create a root folder and use that folder as import location for all the samples Wal esas Content Site Content Properties de Content ld KH A
21. le Version 2 3 EP Dassword d Be wm E In case of a CSV file you need to select a CSV File You also need to provide the field separator and text indicator A field separator is the character that is used to separate the columns The text indicator is a character that indicates a text string The default settings are based on an export from Microsoft Excel CMSImport PRO 1 1 4 il Select Datasource The csv file must contain unique headers VR Select CSV File Select a local file Specify a url http umbracov4 local data testdata csv Field Seperator Le Text Indicator No seperator D No seperator Previous Next 3 3 3 XML File In case of an XML file you need to select the xml file Optional you can specify an xpath expression 2012 Soeteman Software page 8 49 CMSImport PRO User manual Version 2 3 CMSImport PRO 1 1 a il Select Datasource Select XMI File m 9 Select a local file C Users richard Des Bladeren Specify a url Xpath Expression importData contentType news Previous Next When using xml you can only use elements attributes are not supported at the moment All elements that you want to map later must be under the first child node of the xml document 3 3 4 Access database In case of an access database you can upload a mdb file or point to a location and you can specify the query to execute Select Datasource Select file Select a local file Se
22. lected datasource import dbACM35 mdb J Specify a url Select from menu LIL LS Specify your Query Previous Next 3 3 5 Excel In case of an Excel sheet you can upload a xls x file or point to a location When you click next you can select the worksheet from the pull down menu 2012 Soeteman Software page 9 49 CMSImport PRO User manual Version 2 3 Select Datasource Select file i Bladeren 9 Select a local file Selected datasource Products xlsx Specify a url Select a worksheet ProductCategories ProductCategories Products ProductVariant Previous Next 3 3 6 RSS Feed In case of an rss file you can point to a location or upload an rss file Select Datasource Select a rss file Select a local file Bladeren 9 Specify a url www richardsoeteman net SyndicationService asmx GetRss Previous Next 3 3 7 BlogML In case of BlogML you can upload a BlogML file or point to a location When you have uBlogsy Blog4Umbraco or the Blog starterkit installed you can specify that you want to optimize for either uBlogsy Blog4Umbraco Blog starter kit When you enable that option CMSImport will automatically import comments and store it in the correct comments table also Don t select this option when you just want to import the blogposts and blogcomments based on an Umbraco documenttype 2012 Soeteman Software page 10 49 CMSImport PRO User manual Version 2 3 Select Datasource
23. n and DocumentType DocumentType Product v Auto publish F Enable content F updates Only uncheck this option when you don t have a primary key in your datasource When the record Update record e already exists Select primary key productiD Y in datasource Select parent ProductCategorylD e relation key Select the column which Is related to the primary key of the parent Import Enable recursive imports Previous Next 3 10 End result When importing these two definitions the content tree is filled with categories and products 2012 Soeteman Software page 17 49 CMSImport PRO User manual Version 2 3 Content A Content D A Runway Homepage 4 Product Catalog a Bikes a A Mountain Bikes Mountain 100 Mountain 200 Mountain 300 Mountain 400 W Mountain 500 gt Jj Road Bikes gt Jj Touring Bikes gt KR Components gt Jd Clothing gt Ji Accessories E Recycle Bin The import definition tree contains two items ProductCategory and Products as the child import definition 4 CMSImport D s Import data a jj Import definitions 4 Content a L ProductCategory Products j Members jj Scheduled imports b di Settings 2012 Soeteman Software page 18 49 CMSImport PRO User manual Version 2 3 4 Import members 4 1 Introduction When the wizard starts it will start with an introduction CMSImport PRO 1 1 4 al Intro This wizard will help y
24. nit e contentPanel ID CategorycontentPanel contentPanel CssClass propertypane Labels _selectDataSourceLiteral ID SelectDataSourceLiteral _selectDataSourceLiteral Text Enter the connection string TextBox datasourceTextBox ID datasource datasourceTextBox CssClass umbEditorTextField datasourceTextBox Text DataSource Create Layout _contentPanel Controls Add _selectDataSourceLiteral _contentPanel Controls Add new LiteralControl amp nbsp amp nbsp contentPanel Controls Add datasourceTextBox Controls Add contentPanel 9 4 4 Update DataAdapter values When the user clicks next you need to update the DataAdapter properties in this case DataSource and DataCommand public override void UpdateAdapter Uses the SqlConnection from the TextBox as the Datasource DataSource _datasourceTextBox Text 2012 Soeteman Software page 39 49 CMSImport PRO User manual Version 2 3 We are creating a custom DataAdapter for a productCategories don t bother the user with sql DataCommand Select from SalesLT ProductCategory order by ParentProductCategoryID Name 9 4 5 Validate When the user clicks next the validate method is called after the DataAdapter values are updated Return true in this method when the DataSource is valid false when not valid public override bool Validate bool result true try using SqlConnection sqlConnection new SglC
25. nnos 27 54 Bidibiz Advanced Media Picker Ca utu c deae i tese vete dese ois 28 So Solo ere PRESENT TERN 28 56 SCHED LEIMPORTS suis 30 6 1 Scheduled task log cccccocconcconccoconncnncnononncnnonononnnnnnnononnnnnnnnnnnnnnnnnonnnnnnnnnnnnnnrnnnnnnannrnnnnnnnns 31 O 2012 Soeteman Software page 2 49 CMSImport PRO User manual Version 2 3 7 IMPORT ERSTEN 32 E gg cott 33 8 1 ogincredential Sci EE 33 9 2 Scheduler H Sino ri 33 8 3 Media Std eege 33 8 4 RER E e 34 8 5 Configure Import Dashboard eene nenne nnn nennen nnns nnn nnns 35 9 EXTEND CMSIMPOR Totti Eege 36 9 1 Seine UD VISUAU VE 36 9 2 AT RE Tan lee ne ascii 36 9 2 1 Biz e Eet EE 36 9 2 2 Se Igel edem m c eae cree eee ee 36 9 2 3 mici EE 37 9 2 3 1 Record IM POINT mt AA A A A da 37 J232 ee eeleren e NERONE TU UTE 37 IS MONIN DEE 37 eet IMPOR luna a EE 38 A E UU mt 38 9 4 Create a DataAdapter for Product Categories ccoconcncccccncncoconcnnnconnnncnnnnnonononennnnonnnnnonaneness 38 9 4 1 Greate the Ee Ee 39 9 4 2 EE Fe Co o 39 9 4 3 Add loli EMT 39 9 4 4 Update DataAdapter values nnne nens 39 9 4 5 VE We 40 9 4 6 E RE 40 9 4 7 End es a A M 41 9 5 Create a DataAdapter for Products e leed ee 41 9 6 Using a FieldAdapter to map text values against a Dropdownlist DataType 42 10 MANUAL INSTALLATION CONFIGURATION scccsssccssscccsseccsseccsscccsseccssecceseccussceceseeeess 45 10 1 Manual installation of UE 45 1
26. only upload a datasource only when a file datasource was used during creation of the import definition Admin users are always enabled Make sure you add the plugins cmsimport SLT Files i i A LT Files dashboard Executelmport ascx control to the dashboard config file also Example configuration 4 C CMSImport vg Import data lt section gt de import definitions arcana Carea conc ent lt area A scheduled imports areas gt 4 A Settings cab caption Import Deta lt access gt Login credentials email se amp int grant gt writer lt grant gt DA Scheduler result email setting LKE m TEM V xa control umbraco plugins cmaimport dashboardcontrola cmsimportdashboardcontrol ascxc control Y Media Settings lt tab gt Data adapters E ImportDashboard settings i import definitions bet users to impor csvMWember import ProductCategory Mmeber Leen yie Lee t ogmi Fergus2011 4 m Fergus2008 Datelssues SimpieMemberData Sections P Zz Oo tert Medo Lus wet A ml we e 2012 Soeteman Software page 35 49 CMSImport PRO User manual Version 2 3 9 Extend CMSImport Although you don t need to there are several ways to extend CMSImport This chapter describes how you can make use of these extension points in your code All samples can be downloaded from http www cmsimport com download cmsimportsamplepackage zip and a sample VS2010 solution can be downloaded from http www cmsimport com do
27. onnection DataSource sqlConnection Open SqlCommand sqlCommand new SglCommand DataCommand sqlConnection sqlCommand ExecuteReader catch Exception ex Cannot validate against the Datasource result false Set the ValidationErrorMessage with the correct error ValidationErrorMessage string Format Error validating the Data source 0 ex Message return result 9 4 6 GetData The GetData method gets called by CMSImport during the import process and it will return the data from DataSource as an IDataReader In the example below you ll see the GetData Method that we are using in the AdventureWorks ProductCategory DataAdapter public override IDataReader GetData SqlConnection sqlConnection new SglConnection DataSource sqlConnection Open SglCommand sqlCommand new SglCommand DataCommand sqlConnection return sqlCommand ExecuteReader CMSImport will dispose the Reader once it s finished with the import If you need to convert XML to IDataReader you can use the helper method XmlToDataReader which takes an xml file url and xpath Expression Currently this only works on elements attributes will be ignored 2012 Soeteman Software page 40 49 CMSImport PRO User manual Version 2 3 9 4 7 End result When we will build the dll and drop it into the bin folder of the Umbraco install we will see the AdventureWorks ProductCategory in the pulldown list of possible datasources an
28. ou to import your existing data into Umbraco Next 4 2 Select Datasource Type In this step you are asked to specify a datasource type and how the data should be imported content members CMSImport PRO 1 1 4 i k Select Datasource Type Datasource type Sql Server e Import Data as Previous Next The following datasource types are supported by default e Access database e CSV e Excel File e SQL Server e XML It is possible to create extra Datasource Types See chapter extend CMSImport for more information 4 3 Select Datasource In the select Datasource step you need to provide the information for the selected datasource type 2012 Soeteman Software page 19 49 CMSImport PRO User manual Version 2 3 4 3 1 SQL Server In case of SQL server you need to provide the Connection string and the query that you want to use to retrieve the data CMSlmport PRO 1 1 id Select Datasource Enter a Connection String XPRESS databasezAdventureWorksLT en um SELECT FROM SalesLT Customer Enter your Query Previous Next 4 3 2 CSV File In case of a CSV file you need to select a CSV file You also need to provide the field separator and Text Indicator A field separator is the character that is used to separate the columns The text indicator is a character that indicates a text string The default settings are based on an export from Microsoft Excel CM5Import PRO 1 1 i Select Datas
29. ou want your users to upload a new product catalog or member information The user can t modify the import definition using this Dashboard only upload data gt Create B abut a Hep Y Logout admis Import Data A Content 4 d Simple website Blog Import content or members into Umbraco using this simple tooL Recycle Bir e Select what you want to import e Upload the file you want to import e Optional upload a zipfile with the media you want to import e Select Import and wait until the import is finished CM5SImport What do you want to Product atmog v 1 import Upload data file Se 2 Upload media file aioe 2 e Me rb fe exctiof 4 A t 7 C Medo seis estira Domum ia m 1 The user can select an import definition saved in the CMSImport tree to import Only Import definitions that are enabled to import from the Dashboard can be selected If there is only one import definition that can be selected this option will not be shown on the form Using this upload field Users can upload their data file 3 When the import definition allows the import of media a separate upload field for a media file will be shown The user can zip their folder with media that needs to be imported and use this upload field to import their media When the datasource is uploaded CMSImport will first inspect if the datasource is still correct Then it will import data See settings chapter how to configure the Import dashboard 2012
30. ource The csv file must contain unique headers 9 Select a local file Cz UserswichardiDesl O Specify a url Field Seperator 3 D Text Indicator No seperator Le Previous Hext 4 3 3 XML File In case of an XML file you need to select the xml File Optional you can specify an xpath expression 2012 Soeteman Software page 20 49 CMSImport PRO User manual Version 2 3 CMSImport PRO 1 1 lH gt Select Datasource lect XMI Fi select XMI File Select a local file Specify a url http www cmsimport com userdata xmi Xpath Expression fi user Previous Next When using xml you can only use elements attributes are not supported at the moment All elements that you want to map later must be under the first child node of the xml document 4 4 Select member type and role In this step you can select the member type and assign one or more roles With the When the item already exists option you specify what to do when an item is already imported Possible options are skip and update record When the Automatic generate password option is checked a password is automatically generated for the imported member When the Send credentials via mail is checked an email with login credentials is send to the imported member You can edit the email template check chapter settings on how to do this CMSimport PRO 1 1 4 d gt Select Member type and roles Member type Company EN Automatic assign
31. p Tab Content Media stored with a relative url will be imported automatically into Umbraco and the reference will be updated Make sure all folders containimg the images are stored in the root of this umbraco environment Read the manual for a detailed description Use a comma seperated string of images if you want to assign more than 1 image example img imagel img image Media location Specify a location where to store the imported media items img Delete Choose Default value Pick a default media item that will be used in case the assigned value is null no image available small Delete Choose When the import process is finished you ll see that the media items are imported Select Items Ji Media Q X xsitrebel 5 D img T r gt dy Attachments am logos cs Au productimages AY 9 9 is y d m p TIP Using the MNTP datatype you can specify a comma separated list of images you want to import 2012 Soeteman Software page 27 49 CMSImport PRO User manual Version 2 3 5 4 Digibiz Advanced Media Picker When you map against the Digibiz Advanced Media Picker DAMP you can specify the import options as shown below and CMSImport will create a media item and store the Id of the media item Only the default Image and File media types are supported DAMP Classic Image Q Al as dampClassic Tab Photos Media stored with a relative url will be imported automatically into Umbraco and the reference will be updated M
32. parse method gets called when data is imported for the Color property Render control 4 Data Type GUID Database datatype integer e Add prevalue This Parse method accepts the following parameters 2012 Soeteman Software page 36 49 CMSImport PRO User manual Version 2 3 Value The original value which we can manipulate Document property Gives us information about the document type FieldAdapterOptions Bunch of general setting mostly related to Media Import 9 2 3 Events There are several events that you can use for both content and member import You can hook up events in the same way you hook up events for other Umbraco functionality by deriving from ApplicationBase and hook up the event in the constructor public class Sample umbraco BusinessLogic ApplicationBase public Sample Hook up event MemberImport RecordImporting new MemberImport RecordImportingEventHandler MemberImport RecordImporting void MemberImport_RecordImporting object sender RecordImportingEventArgs e Logic here 9 2 3 1 Recordimporting The recordimporting event gets hit before a record got imported the sender object contains the document or member being imported RecordlmportingEventArgs contains the following information e DataAdapter e DataKeyName Primary key column e DataKeyValue Primary key value e tems collection of items that contains the original data You can cancel the import for th
33. place With 10 4 Manual configuration of the scheduled task handler Open the config umbracoSettings config file Replace With 2012 Soeteman Software page 47 49 CMSImport PRO User manual Version 2 3 And replace url to mysite umbraco with the url of your site including the umbraco path For example http cmsimport com umbraco plugins CMSImport Handlers ScheduleTaskHandler ashx When the scheduled task handler is configured correctly and you browse to that url using your favorite browser it should report CMSImport scheduler 2012 Soeteman Software page 48 49 CMSImport PRO User manual Version 2 3 11 Troubleshooting 11 1 don t see the CMSImport package in my developer section Make sure you have sufficient rights to install the package See chapter 2 otherwise perform a manual installation see chapter9 11 2 don t see my column names when importing from a CSV file Make sure that your csv file contains column names 11 3 get weird column names when importing from a CSV file Make sure that you set the correct csv options to display the CSV file For example choose as the delimiter and as a string indicator 11 4 I get an error not supported error when using access or excel files Make sure you ve installed the Microsoft Data Connectivity Components installed You can download them via http www microsoft com downloads en confirmation aspx familyld 7554f536 8c28 4598 9b72 ef94e038c891 amp
34. role Y s Customer Y Company When member exists Update record EN Automatic generate 7 password Send credentials via mail Import content elated media axe sure Previous Next 2012 Soeteman Software page 21 49 Version 2 3 CMSImport PRO User manual 4 5 Create Mapping In this step you can specify the mapping between the fields from the data source and the properties of the Umbraco member type When you click on the green plus sign you can set advanced settings for that particular datatype It should be at least possible to specify a default value for each datatype Create Mapping Generic Properties Member name Member login Member email Document property Department Alise TE mum Abas department Quick tip name Y email Q email DN YD Database column Afdeling e d Country e Q When your fieldnames from the datasource are the same as the alias of the document property CMSImport will automatically map this field 4 6 Confirm In this step you can validate the selected options one more time When you click next the import will start O 2012 Soeteman Software page 22 49 CMSImport PRO User manual Ch lmport PRO 1 1 H Confirm Please validate your input and press Next to import the data DataSource Type Sql Server Datasource server AS QOLEXPRESS databasezAdventureWorksL T user idzUmbracoCMS password llmbracaoCMS Data command SELECT FROM Sales
35. rom the zip file to the folder umbraco plugins CMSImport Config Copy all ashx files from the zip file to the folder umbraco plugins CMSImport Handlers Copy all aspx files from the zip file to the folder umbraco plugins CMSImport Pages Copy the files CMSImport ascx and CMSImportinstaller ascx from the zip file to the folder umbraco plugins CMSImport Usercontrols Copy the files ConfirmSelectedOptions ascx Importing ascx Intro ascx MapProperties ascx SelectDataSource ascx SelectDataSourceType ascx from the zip file to the folder umbraco plugins CMSImport Usercontrols ImportSteps Copy SelectUmbracoTypeAndLocation ascx from the zip file to the folder umbraco plugins CMSImport Usercontrols ImportSteps Contentimport Copy SelectMembertype ascx from the zip file to the folder umbraco plugins CMSImport Usercontrols ImportSteps Memberlmport Copy all the png files from the zip file to the folder umbraco Images 10 2 Manual configuration of Database Run the following script to install the database tables 2012 Soeteman Software page 45 49 CMSImport PRO User manual Version 2 3 ScheduleId int IDENTITY 1 1 NOT NULL ScheduleGUID uniqueidentifier NOT NULL ImportStateGUID uniqueidentifier NOT NULL ScheduledTaskName nvarchar 50 NOT NULL NotifyEmailAddress nvarchar 250 NOT NULL ExecuteEvery nvarchar 50 NOT NULL Execu nvarchar 50 NOT NULL ExecuteHour int NOT NULL ExecuteMinute int NOT
36. rver CSN file XML file If you have a License you can use the following datasources also Excel Ar Mir Binary files in the package Esad more metho raisal Package Make sure that the installer has modify rights on the following folders e bin e config e umbraco The installer also needs rights to create tables in the database If for some reason you can t give the installer these rights you can install the package manually Read the chapter manual configuration how to do this Once the package is installed you have an extra folder in your developer section called CMSImport You might need a page refresh or even logout and in again to see this folder When you want to use the PRO functionality add the license file to the bin folder of your Umbraco install 2012 Soeteman Software page 5 49 CMSImport PRO User manual 3 Import Content Version 2 3 You can start CMSImport by right clicking on the content node and select the import data option only visible for administrators Content Di Content Bech w E Pi E A Rurmway Homepage A import Create Edt in Canvas Delete prg Copy Sort Rollback Publeh Manage hostnames Permissions Public accasa At Trai Notifications send To Translation Reload nodes import Data Welcomes Administrator Or you can go to the developer section open CMSImport and select Start Import The following wi
37. sh Content update options Action when the item already exists Primary key Enable recursive imports ProductCategory True Update record ProductCategorylD True Dram t Drea arh atanma 2012 Soeteman Software page 14 49 CMSImport PRO User manual Version 2 3 3 7 Import When you click next in this step the import starts When the import is finished it will report what it did If there were any errors it will also report the errors id Import Finished import is finished import duration him s 00 00 00 Records retrieved d Records imported 2 Errors Previous Quick tip In case of test imports it might be useful to install the Content Maintenance Dashboard package also to bulk publish unpublish and delete content nodes You can download the package via http our umbraco org projects developer tools content maintenance dashboard package 3 8 Save Import steps When you click save you can specify a name and when hitting the save button again the import steps are saved for later use TE Save the import steps for later reference Save import steps as ProductCategory Saved imports are stored as Import definitions and can be found in the Import definitions tree 2012 Soeteman Software page 15 49 CMSImport PRO User manual Version 2 3 a CMSImport Sg Import data 4 Au Import definitions a Content ProductCategory gt Members gt Au Scheduled imports gt Settings
38. t Every datatype has its own options Using CMSImport PRO it s also possible to import media related to content the only requirement is that media is stored in the root of the website Whenever you map against a media picker or rich text editor screen it s possible for you to specify a media location and it s even possible to specify a default value See chapter Related media import for more information 2012 Soeteman Software page 13 49 CMSImport PRO Create Date Document property ProductHumber io Za Frois r n Color Ca ceo ab Productir n ListPrice D Pr oductir u Tags Alias tags ei a a md ra Si Product Product Image Mia producimaqo ch 3 6 Confirm User manual grana e 2 Database column productCode S a lgnare 9g ListPrice Q gnone a a magehlehame e Media location import Delete Choose Default value Choose Version 2 3 In this step you can validate the selected options one more time When you click next the import will start Confirm Please validate your input and press Mext to import the data DataSource Type Excel file Datasource Provider Microsoft ACE OLEDB 17 0 Data Source F siteslUmbracoV45PRO datalimporti56953205 1edc 4121 9960 ec5B105de06b Products xlsx Extended Properties Excel 12 0 XAml HDR YES Data command Data Options ProductCategories5 Document location Product Catalog Document Type Autopubli
39. t doesn t exists so we don t need to create the prevalues first Below you find the FieldAdapter The DataTypeld returns the Guid of the Dropdown Datatype The parse method first checks if the datatype is the ProductColor datatype and when it is the ProductColor datatype it will get or create the integer id of the prevalue summary public class AutoAddProductColorToList IFieldAdapter d lt summary gt Gets the data type id lt summary gt value The data type id lt value gt public Guid DataTypeld get return new Guid a74ea9c9 8e18 4d2a 8cf6 73c6206c5da6 public object Parse object value umbraco cms businesslogic property Property property FieldAdapterOptions fieldAdapterOptions if property PropertyType DataTypeDefinition Text ProductColor DataTypeDefinition dt property PropertyType DataTypeDefinition value GetOrCreatePrevalue dt Id value ToString return value 2012 Soeteman Software page 43 49 CMSImport PRO User manual Version 2 3 Once the import has finished using this FieldAdapter you ll see that all options are added to the ProductColor datatype Edit datatype ProductColor dd Hame ProductColor Render control Dropdown list El Data Type GUID a 4ea9c9 Be18 4d2a Bcf6 73c6206c5da6 oe hoi mm mmm k SP Line Text Value Multi 286 Delete Silver 287 Delete Blue 288 Delete Black 289 Delete Silver Black 290 Delete Red 291 Delete Yellow
40. tType ProductCategory Auto publish E Enable content y updates Only uncheck this optron when you cont ve a primary key in ur datasource When the record Update record e already exists Select primary key ProductCategorylD in datasource Enable recursive J imports ge Select foreign key ParentProductCategorylD v for recursive import Previous Next Some of the options might be disabled or you might have a few extra options when run this step as a child import See section structured import for more information 3 5 Create mapping In this step you can specify the mapping between the fields from the data source and the properties of the Umbraco document type Quick tip When your fieldnames from the datasource are the same as the alias of the document property CMSImport will automatically map this field 2012 Soeteman Software page 12 49 CMSImport PRO User manual Version 2 3 When you click on the green plus sign you can set advanced settings for that particular datatype It should be at least possible to specify a default value for each datatype Below you see the advanced settings for a datetime datatype Create Mapping Generic Properties Name Name Y Publish at dum Y Unpublish at lgnore e Y Lreate Date lgnore Y Date format dd MM yyyy HH mm Preview 10 06 2011 13 30 Default value 2011 06 10 00 00 Clear Date Document Database column property Previous Nex
41. the different Data Adapters If you enable the Office data adapters make sure you have the Microsoft Data Connectivity Components installed renera Yi Csv d Rss Feed Sal Server V Xmi TCO d Access database V Excel file ive El BlogML Comments J Wordpress blogposts V Wordpress Comments El BlogML blogposts 2012 Soeteman Software page 34 49 CMSImport PRO User manual Version 2 3 8 5 Configure Import Dashboard In this section you can configure the Import Dashboard You can specify which import definitions you want to allow to be used on the Dashboard Only datasource that supports uploading a datasource file such as Excel Xml Csv etc are supported Since it s a dashboard and you can put this dashboard anywhere you like only a sample xml snippet will be shown that you can copy and paste into the Dashboard config file To only allow selected usergroups access to the Dashboard use the Access element More information how to use the Dashboard config file can be found at http our umbraco org wiki reference files and folders dashboardconfi we O aru gi ren S Logost Adminstrator Developer LMSimport PRO 2 1 Developer id 4 Cache Browser Data Types ROS Configure import dashboard 4 Packages Below you can enable import definitions for certain user types This functionality is different from the normal import wizard Ak Scripting Files The end user can only pick a configured Import definition and can
42. uired thing is that the original media folder is copied to the root of your Umbraco folder In the example below the img folder of the original site containing two images is stored in the Umbraco root de manual local A App_Browsers A App Code de App Data de bin de config de css A data xsitrebel ppc A install A masterpages A media A python de scripts A umbraco de umbraco client A usercontrols d weit In the Import wizard you can specify that you want to import media items also Check the option Import content related media on the advanced setting of the property 2012 Soeteman Software page 25 49 CMSImport PRO User manual Version 2 3 Create Mapping Generic Properties Name gnore e 9 Publish at ignore 9 Unpublish at Iegnore D GC Lreate Date ignore 9 Document property Database column Body Text Hgnore o 1 Alum bodyText Gees woe 0 Alias e is v gt 22 Upload A Ignore E y 3 a Previous Next 5 1 Rich text editor When you map against a Richtext datatype you can specify the import options as shown below When a reference to an image is found in the content CMSImport will create a media Item and update the image source to the new Media item Document property Database column Body Text e seg Alias bodyText Ignore NI Tab Content Import Images By enabling Image import images stored with a relative url will be imported automatically into Umbraco and the refer
43. wnload CMSImportVs2010Samples zip To use the samples you need to install the AdventureWorks Lite database which can be downloaded from the CodePlex site http msftdbprodsamples codeplex com and use CMSImport PRO although some samples might work in the free version 9 1 Setting up Visual Studio When you want to create an extension for CMSImport you can create a new Class Library and add a reference to the Assembly CMSImport Extensions When you need to use Umbraco functionality or want to use CMSImport events also you can create references to the assemblies Umbraco interfaces cms and businesslogic 9 2 What s in CMSImport extensions 9 2 1 DataAdapter A DataAdapter is used as a generic interface to talk to datasources You can use a DataAdapter by using ImportDataAdapter as a base class Checkout the samples for a full implementation of a DataAdapter 9 2 2 FieldAdapter A FieldAdapter could be used to convert original data in a datasource to a datatype specific format during import CMSImport uses this already to make sure values like true false will be converted to a Boolean value which could be mapped against a true false datatype without causing an error and it uses FieldAdapters to import media A FieldAdapter is basically an implementation of the IFieldAdapter interface which contains the DataAdapterld property and the Parse method The DataAdapterlD must match with the DataAdapterControl This will ensure that the
44. you started the import from the context menu in content You can also specify the document type and you select the auto publish checkbox when checked items are published automatically The When the item already exists and the primary key option are needed for content updates With the When the item already exists option you specify what to do when an item is already O 2012 Soeteman Software page 11 49 CMSImport PRO User manual Version 2 3 imported Possible options are skip and update record With the primary key you specify the key in the datasource This field will be used to determine if an item is already imported To disable content updates uncheck the Enable content updates option Only do this when you don t have a primary key in your datasource No relation between imported data and Umbraco document is stored so even when you run the import for the second time data will be imported as new records CMSImport can maintain the structure for you when you import content This is normally be done using parent child import definitions but sometimes you import content with a recursive foreign key to itself for example when you import Product categories as in the example below Some categories have a relation to a parent category By selecting the recursive import option you can specify the key to its parent in this case ParentProductcategoryID Select Destination and DocumentType Location Product Catalog Delete Choose Documen
45. zard will open 3 1 Introduction When the wizard starts it will start with an introduction CMSimport PRO 2 0 id Intro This wizard will help you to import your existing data into Umbraco Previous Cat O 2012 Soeteman Software page 6 49 CMSImport PRO User manual Version 2 3 3 2 Select Datasource Type In this step you are asked to specify a datasource type and how the data should be imported content members CMSimport PRO 2 0 A gt Select Datasource Type Datasource type Access database Import Data as Content w Previous Next The following datasource types are supported by default e Access database e BlogML e CSV e Excel File e RSS Feed e SQL Server e WordPress e XML It is possible to create extra datasource types See chapter extend CMSImport for more information 3 3 Select datasource In the select datasource step you need to provide the information for the selected datasource Type 3 3 1 SQL Server In case of SQL server you need to provide the Connection string and the query that you want to use to retrieve the data Access and Excel file requires you to install an extra driver from Microsoft 2012 Soeteman Software page 7 49 CMSImport PRO User manual CMSImport PRO 1 1 al Select Datasource Enter a Connection Strine XPRESS database TestData user id Select from TestData Enter your Query Previous Next 3 3 2 CSV Fi
Download Pdf Manuals
Related Search