CMSImport PRO User manual
Contents
1. coocccocncccnncccnnnnas 49 12 3 get weird column names when importing from a CSV file o ccccconccncoconnnnononnnnnnnos 49 12 4 I get an error not supported error when using access or excel files ooooonccccinnnnn 49 12 5 Email is not send when importing a Member occccccoccncccnncnnccnncnncnnoncnnnnnncnnnnnnnnnconancnnonancnnnnneos 49 12 6 I get an Invalid License exception ccccccceescceceeeeeeeeeeeeeeceeseeeeaeeeeeeseaeeeeseaeeeesseeeeesaageeeenaegs 49 2013 Soeteman Software page 3 49 CMSImport PRO User manual Version 2 5 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 import a complete product catalog Categories and Products blogposts comments or any structure you want to import CMSImport PRO is optimized for uBlogsy Blog4Umbraco TeaCo2. 2013 Soeteman Software page 41 49 CMSImport PRO User manual CMSImport PRO 1 1 Select Datasource Enter the connection string Previous Next Version 2 5 We can provide a Connection string and click next to continue the import process the normal way 10 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 al di Products de Accessories de Bike Racks 34 Bike Stands Je Bottles and Cages s 3 al de Cleaners al de Fenders 3A at de Helmets 4 3 4 gt de Hydration Packs gt di Lights gt de Locks gt de Panniers gt de Pumps gt di Tires and Tubes gt di Bikes 2013 Soeteman Software page 42 49 CMSImport PRO User manual Version 2 5 10 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 i
3. retsll 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 2013 Soeteman Software page 5 49 CMSImport PRO User manual Version 2 5 3 Import Content You can go to the developer section open CMSImport and select Start Import The following wizard will open 3 1 Introduction When the wizard starts it will start with an introduction CMSimport PRO 2 0 4 Intro This wizard will help you to import your existing data into Umbraco Previous Next 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 y gt Select Datasource Type Datasource type Access database y 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
4. 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 iad int IDENTITY 1 1 NOT NULL UmbracoMediald 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 CMSImportScheduledIitems ScheduledItemId int IDENTITY 1 1 NOT NULL ScheduleldTaskId int NOT NULL ScheduledOn smalldatetime NOT NULL ExecutedOn smalldatetime NULL CONSTRAINT PK CMSImportScheduledItems PRIMARY KEY CLUSTERED ScheduledItemId 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 CMSImportCustomRelation CustomRelationld int IDENTITY 1 1 NOT NULL Umbracold int NOT NULL Alias nvarchar 250 NOT NULL DataSourceKey nvarchar 250 NOT NULL Relatedld nvarchar 250 NOT NULL CONSTRAINT PK CMSImpor
5. Previous Next 2013 Soeteman Software page 7 49 CMSImport PRO User manual Version 2 5 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 CMSImport PRO 1 1 a il Select Datasource Select XMI File 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 Selected datasource import dbACM35 mdb Specify a url Specify your Query Previous Next 3 3 5 Excel In case of an Excel sheet you can upload a xIs x file or point to a location When you click next you can select the worksheet from the pull down menu 2013 Soeteman Software page 8 49 CMSImport PRO User manual Version 2 5 Select Datasource Select file Bladeren 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
6. lira Mb R le bin 12 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 12 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 2013 Soeteman Software page 49 49
7. 2013 Soeteman Software page 12 49 CMSImport PRO User manual Create Date Document property ol a Tab Fro Color ail A abs ListPrice ll la ProductHumber OCIO O ir miuno BO Pro acu re o a Fi 3 6 Confirm Product Image Alias prod Due Dia re LE lerore 7 g Database column productCode a a prare a ListPrice a Ignore 0 imagefile Name a Media location Import Delete Choose Default value Choose Version 2 5 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 Next to import the data DataSource Type Excel file Datasource Provider Microsoft ACE OLEDB 12 0 Data Source F AsiteslUmbracoV45PROdatalimporti56953205 1edc 4121 9960 ec5B105de06b Products xlsx Extended Properties Excel 12 0 Xmli HDR YES Data command Data Options ProductCategories5 Document location Product Catalog Document Type Autopublish Content update options Action when the item already exists Primary key Enable recursive imports Enrainn Lean En p 3 7 Import ProductCategory True Update record ProductCategorylD True Dram t Drea ah atanma 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 2013 Soeteman Softwa
8. Enable recursive F imports Previous Next 3 10 End result Version 2 5 When importing these two definitions the content tree is filled with categories and products Content di Content gt di Runway Homepage Product Catalog Bikes a de Mountain Bikes Mountain 100 Mountain 200 Mountain 300 Mountain 400 W Mountain 500 gt J Road Bikes gt di Touring Bikes gt JU Components gt di Clothing gt di Accessories E Recycle Bin The import definition tree contains two items ProductCategory and Products as the child import definition 2013 Soeteman Software page 16 49 CMSImport PRO User manual CMSImport ES Import data di Import definitions Ji Content a 2 ProductCategory Products gt di Members gt de Scheduled imports gt db Settings 2013 Soeteman Software Version 2 5 page 17 49 CMSImport PRO User manual Version 2 5 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 you 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 E Select Datasource Type Datasource type Sql Server Import Data as Previous Next The following datasource types are s
9. CMSImport PRO User manual Version 2 5 CMSImport PRO 1 1 ld gt Select Datasource lect XMI Fil 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 gt Select Member type and roles Member type Company Automatic assign role y s a Customer Y Company When member exists Update record l Automatic generate 7 password i Send credentials via mail Import content related media stored i Previous Next 2013 Soeteman Software page 20 49 CMSImport PRO User manual 4 5 Create Mapping In this step you can specify the mapping betwe
10. Here you can modify the following settings 9 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 9 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 HDuration The duration of the import process HRecordCount The amount of records in the datasource HRecordsAdded The amount of records added during the import process HRecordsUpdated The amount of records updated during the import process HRecorsdSkippedCount The amount of records skipped during the import process HErrorCount The amount of errors during the import process HErrors The error descriptions
11. Le Productimport Site Name Productimport Recycle Bin Site Description Just a placeholder 10 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 10 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 10 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 2013 Soeteman Software page 39 49 CMSImport PRO User manual Version 2 5 public override string Alias get return AdventureWorks ProductCategories 10 4 3 Add UIl 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 OnInit e _contentPa
12. Open de folder in the zip file Copy all Except for CMSImport Events CMSImport LegacyEvents and HtmlAgilityPack dll files to the bin folder of your Umbraco installation Copy HtmlAgilityPack dll to the bin legacy folder of your Umbraco installation In case of Umbraco V7 and Higher o Copy CMSImport Events dll to the bin folder In case of Umbraco v6 and lower o Copy CMSImport LegacyEvents dll to the bin folder 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 from 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 SelectD
13. file you can point to a location or upload an rss file Select Datasource Select a rss file TS Select a local file Bladeren 9 Specify a url www richardsoeteman net SyndicationService asmx GetRss Previous Next RSS feed requires install of the CMSImport DataAdapters RSS package file 3 3 7 BlogML In case of BlogML you can upload a BlogML file or point to a location The BlogML Data adapters allow you to import authors categories tags posts and comments 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 create the correct mapping also BlogML requires install of the CMSImport DataAdapters BlogML package file 2013 Soeteman Software page 9 49 CMSImport PRO User manual Version 2 5 Select Datasource Select BlogML export file PUERTA is ES Select a local file Bladeren Specify a url http v Optimize for Blog4Umbraco CMSImport determined that you have installed Blog4Umbraco When you check the Optimize for Blog4Umbraco option CMSImport will automatically import the comments and CMSImport 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 The Wordpress data adapters allow you to import authors categories tag
14. what to do when an item is already 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 ParentProductcategorylD Select Destination and DocumentType Location Product Catalog Delete Choose DocumentType ProductCategory Auto publish Y Enable content Y update Only uncheck this option when you don t e panama ey in your datasource When the record Update record w already exists Select primary key ProductCategoryiD Y in datasource Enable recursive J imports Select foreign key ParentProductCategorylD vw for recursive import Next Previous Some of the options might be disable
15. Bladwijzer niet gedefinieerd 2013 Soeteman Software page 2 49 CMSImport PRO User manual Version 2 5 9 5 Configure Import D shb rd aukande 35 10 EXTEND CMSIMPOR La 36 IOE Seting Up VETA SO ia eaten 36 10 2 What s in CMSImport extensions ccooccccoccoconccocnconcnccnnnononnononconnnconnnononnonannonnnnonnnnnannnnanennons 36 10 33 Samples dl iia 38 10 4 Create a DataAdapter for Product Categories occccccoccnnccconnncoconcnnnconcnnnnonnnnnonannnnonanenononens 39 10 5 Create a DataAdapter for Products oooonccnccccconconcccnonnconcnononncnnonononnnnnnnnnnnnnnnnnonanennnonnnanennnns 42 10 6 Using a FieldAdapter to map text values against a Dropdownlist Data Type 43 11 MANUAL INSTALLATION CONFIGURATION scccsssccssscccsseccsseccsscccssecceseccsecensececsseceess 45 Tied Mantallastalation OT NES NSA 45 11 2 Manual configuration of Database ooonccnncccccnncnnnccnnonconnnononnnnnnnononnnnnononnnnnnnnnonanrnnnnnnnanennnoss 45 11 3 Manual configuration of the language files oooococcccnnnnccconnncoconnnnonnanoncnnanonconancnnnnnos 47 11 4 Manual configuration of the scheduled task handler cccccseeeeeceseeeeeeeeeeeeeaeeeeeeeeeeeeeeaees 47 12 TROUBLESHOOTING sosa 49 12 1 dont see the CMSImport package in my developer Section ooccccocnccccnccccncccnccncnccncnnnnos 49 12 2 dont see my column names when importing from a CSV file
16. CMSImport PRO User manual Version 2 5 CMSImport PRO User manual Version 2 5 1 WNDRODUCTION RS 4 Z INSTALLATION liliana roscado ios 5 3 IMPORT CONTENT Le 6 3 1 gl dele e ELO oO 6 32 Select Dalasounce Deia O ae Saeed 6 33 Bl BUEN 7 3 4 Select destination and document type ccooonccncccccnccnnncccnoncnnnonnnancnnnnonnnncnnnnnnnnnnnnnnonanrnnnnnnnnnnos 10 30 CESR mappi excenaeineccenavaarsosavegecsua laa 11 3 6 A A en 13 3 7 NOM EE a a 13 3 8 Save DO 14 39 Oreate a Child EMO 15 ETE SU macaco adios 16 4 IMPORT MEMBERS sara tii 18 4 1 MOON 18 42 Select DataSource Ty Oe HA 18 43 SEA DATSUN turcos iaa 18 44 Select member type and role oocccccccconncnncccconncnncnononcnnncnnnnncnnnononancnnnnnnnnnrnnnnnnnnncnnenonanennnos 20 AS Greate MappINdurasia nc 21 4 6 SN 21 4 7 IND OM g REE a ados 22 4 8 Save IMPON SEP seede 23 5 RELATED MEDIA IMPORT Lusis ere een 24 5 1 FRIGHT LOX CG i Ol i ces sey tacit os rv 25 52 MEA PE eee 26 So MulttNode Tree Picker MNT PY usanne 26 5 4 Digibiz Advanced Media PICKET sccccccssssececcceessececcceeeececseeeseeeecseuaueeeeesseseeeesssaseees 27 5 5 Upload ENN 27 6 TORPS aS 29 6 1 ETON 29 6 2 MAP ee eee 29 7 SCHEDULE IIVIPORTS sr 30 7 1 Scheduled ESN aS 31 S IMPORT DASHBOARD ve 32 9 SETTINGS sansen d eres deearenr 33 9 1 Roo eo a a a E a 33 92 SCheduler result Setas a A NE 33 93 Media SEN S esser O EO 33 94 Data adaplers ee ee ee Fout
17. DefinitionID foreach var prevalue in preValues Cast lt DictionaryEntry gt Select entry entry V alue as PreValue Where prevalue prevalue Value value return prevalue Id Nothing found create new prevalue and return the new database id return PreValue MakeNew dataTypeDefinitionID value Id Once the import has finished using this FieldProvider you ll see that all options are added to the ProductColor datatype Edit datatype ProductColor 4 a Name ProductColor Render control Dropdown list Data Type GUID aldeadc9 Be18 4d2a 8cf6 3c6206c5dab Lg LAA o JETLNES la a Database datatype nteger e Text Value Multi 286 Delete Silver 287 Delete Blue 288 Delete Black 289 Delete Silver Black 290 Delete Red 291 Delete Yellow 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 H A ProductName Road 150 Red 52 Product Number pk po3p 57 ProductPrice 3578 2700 Product color 2013 Soeteman Software page 44 49 CMSImport PRO User manual Version 2 5 11 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 11 1 Manual installation of files
18. RSS Feed e SQL Server e WordPress e XML BlogML WordPress and RSS feed require that you install additional packages containing the Data adapters Access file requires you to install an extra driver from Microsoft 2013 Soeteman Software page 6 49 CMSImport PRO User manual Version 2 5 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 CMSImport PRO 1 1 ll Select Datasource Enter a Connection String XPRESS database TestData user 1d Pe MF password E E Select from TestData Enter your Query Previous Next 3 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 CMSImport PRO 1 1 a Select Datasource The csv file must contain unique headers S V Fil Pena IER Select a local file 9 Specify a url http umbracov4 local data testdata csv Field Seperator syl Text Indicator No seperator vi No seperator
19. Source sqlConnection Open SqlCommand sqlCommand new SqlCommand 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 ex Message return result 10 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 SqlConnection DataSource sqlConnection Open SglCommand sqlCommand new SqlCommand 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 XmIToDataReader which takes an xml file url and xpath Expression Currently this only works on elements attributes will be ignored 10 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 and when we select the AdventureWorks ProductCategory DataAdapter we will see the following screen
20. a relative url will be imported automatically into Umbraco and the reference 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 Use a comma seperated string of images if you want to assien more than 1 image example ime imaget ime imaze 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 Media O Fkxsitrebel a b i n T N gt dy Attachments di 10Q05 productimages VG g i U gt 5 mw p TIP Using the MNTP datatype you can specify a comma separated list of images you want to import 2013 Soeteman Software page 26 49 CMSImport PRO User manual Version 2 5 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 Al as dampClassic Tab Photos Media stored with a relative url will be imported automatically into Umbraco and the reference will be updated Make sure all folders containing the
21. ail EmailAddress telephone Phone Version 2 5 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 i Import Finished Import is finished Import duration 00 01 29 h m s Records retrieved 440 Records imported 440 Errors 0 Previous 2013 Soeteman Software page 22 49 CMSImport PRO User manual Version 2 5 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 CMSimport PRO 1 1 H A gt Save the import steps for later reference Save import steps as Customers 2013 Soeteman Software page 23 49 CMSImport PRO User manual Version 2 5 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 required thing is that the original media folder is copied to the root of your Umbraco folder When the relative path in the datasource is a folder CMSImport will import the complete folder and assign the folder id to the mediapicker when assigning a folder is possible with the datatype In the exampl
22. ataSourceType 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 11 2 Manual configuration of Database Run the following script to install the database tables 2013 Soeteman Software page 45 49 CMSImport PRO User manual Version 2 5 ON ALLOW PAGE LOCKS ON ON PRIMARY WITH PAD INDEX OFF STATISTICS NORECOMPUTE OFF IGNORE DUP KEY OFF ALLOW ROW LOCKS ON PRIMARY CREATE TABLE CMSImportScheduledTask Scheduleld 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 ExecuteDays nvarchar 50 NOT NULL ExecuteHour int NOT NULL ExecuteMinute int NOT NULL CONSTRAINT PK CMSImportseheduledTask PRIMARY KEY CLUSTERED ScheduleId 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
23. bels 2 The MNTP Datatype For this record the datasource value contains Azure Umbraco 4 5 Labels optional 1 Post Date open Clear Date lt gt Azure lt gt Everything else Tags PE lt gt Gadgets meer to click save or FET lt gt Google API x sql azure lt gt Sitecore x Umbraco lt gt Umbraco lt gt Uncategorized TEN ae Select Items 2 2008 S F 2 Labels optional A lt gt Azure x gt lt gt Azure lt gt Umbraco a lt gt Everything else lt gt Gadgets v CMSImport will try to map the values based on Id or NodeName In case the value cannot be found the value will be ignored 2013 Soeteman Software page 29 49 CMSImport PRO User manual Version 2 5 7 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 ai Saved import name CMS import manual scheduled task name Daily import records for CM amp lmport manual Notify emailadress manual cmsimport com Run task as Administrator Execute every Week Day 2 Hour Monday Tuesday Wednesday Thursday El Friday E Saturday Sunday Time m 5 P 5 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 receive a notification when the import is finished and yo
24. d 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 2013 Soeteman Software page 11 49 CMSImport PRO User manual Version 2 5 Quick tip When your fieldnames from the datasource are the same as the alias of the document property CMSImport will automatically map this field 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 v Y Publish at es 9 Unpublish at Ap 9 Create Date lgnore Y Date format ti dd MM yyyy HH mm Preview 10 06 2011 13 30 Default value 2011 06 10 00 00 j Clear Date Document Database column property Previous Next 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
25. d domain url http elpadrinodkfileswordpre http warsoetemanotiwaren 2013 Soeteman Software page 34 49 CMSImport PRO User manual Version 2 5 9 4 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 MD Ce Arou lt b Hep GP Logout Admunstrator Developer MSimport PRO 2 1 Developer 1 Cache Browser d Data Types d Macros di Packages Below you can enable import definitions for certain user types This functionality is different from the normal import wizard de Scripting Files The end user can only pick a configured import definition and can 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 Configure import dashboard XSLT Files gt ar dashboard Executelmport ascx c
26. e below the img folder of the original site containing two images is stored in the Umbraco root de manual local de App Browsers Hi App Code di App Data di bin de config i css di data dig d install de masterpages de media d python de scripts di umbraco de umbraco_clent de usercontrols di nt ttrebel pog 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 2013 Soeteman Software page 24 49 CMSImport PRO User manual Version 2 5 Create Mapping Generic Properties Name tgnore Q Publish at gnore s Unpublish at Hgnore Create Date Ignore vw Document property Database column Body Text ignore v Y fab Conners Hide in navigation Jgnore Y Alias STOR Nav Tan Propert er rine q Upload P ignore 7 3 ne 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 Alias bodyText Ignore x Tab Content Import Images By enabling Image import images stored with a relative url will be imported automatically into Umbraco and the reference vill be updated Make sure all fo
27. en the fields from the data source and the properties of the Umbraco member type Version 2 5 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 Abas department ab Properties Country Alas country ab Properties Quick tip name x email ES email v Database column Afdeling v 2 Country wv y 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 2013 Soeteman Software page 21 49 CMSImport PRO User manual CM amp Import PRO 1 1 H Confirm Please validate your input and press Next to import the data DataSource Type Sql Server Datasource server SQLEXPRESS database AdventureWorksLT user id UmbracoCM5S password UmbracoCM5S Data command SELECT FROM SalesLT 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 em
28. ent Properties di Content ag AQ o X Us EL Styles MF id di Runway Homepage Lorem ipsum dolor sit amet consectetuer adipiscing elit Aeneaan commodo ligula a de Import y a Fete 1 A Foto 2 F Reevele Bin eget dolor Aenean massa Cum seclis matogue ha ESN penatibus et magnis dis parturient montes nascetur ridiculus mus Doner quam felis ult Image Upload Sections Remove file Comer Veda Leg Sel Lines M Media xsltrebel Delete Choose Developer F lger rar 1 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 2013 Soeteman Software bb Stam page 28 49 CMSImport PRO User manual Version 2 5 6 Lookups CMSImport support content lookups for Multi Node Tree picker values 6 1 Configuration CMSImport uses the datatype configuration to determine where to look for the nodes hi uiogsy MNTP Label Pi Property editor Multi Node Tree Picker 7 Property editor GUID 7e062 13 7 41 4ad9 b389 41dBBacefB7c Select tree type ontent v Node selection type Node Picker XPath Expression Path type Global From Current Path expression niaimer Label h filt y yu titer wpe Disable Enable Path filter 6 2 Mapping Based on the configuration it will look for nodes that it can map against the assigned value In the image below we import categories 1 The available La
29. 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 10 2 3 1 Recordimporting The recordimporting event gets hit before a record got imported the sender object contains the document or member being imported RecordimportingEventArgs contains the following information e DataAdapter e DataKeyName Primary key column e DataKeyValue Primary key value e Items collection of items that contains the original data You can cancel the import for this record by setting the cancel property to true 10 2 3 2 Recordimported The Recordimported event gets hit after a record got imported the sender object contains the imported document or member RecordimportedEventArgs contains the following information 2013 Soeteman Software page 37 49 CMSImport PRO User manual Version 2 5 e DataAdapter e DataKeyName Primary key column e DataKeyValue Primary key value e ImportAction ImportAsNew update or skip record e Items collection of items that contains the original data 10 2 3 3 Importing The Importing event gets hit before the import starts ImportE
30. g or member information The user can t modify the import definition using this Dashboard only upload data 2 Create About a Hep GI Logout adme Import Data Content 4 de Sime e we site d Blog import content or members into Umbraco using this simple tool Recyde 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 CMSImport What do you want to Product at og v 1 import Upload data file Bladeren 2 Upload media file Bladeren 2 ud Uria n e bets grep 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 2013 Soeteman Software page 32 49 CMSImport PRO User manual Version 2 5 9 Settings
31. gory and select Create child definition fi GMSImport i Import data a di Import definitions Content 2 ProductCategory d z Create child definition de Set ES Schedule gt Execute Jk 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 Select Datasource Select file Bladeren Select a local file Selected datasource Products xlsx Specify a url nttp Select a worksheet Products Previous Next 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 2013 Soeteman Software page 15 49 CMSImport PRO User manual Select Destination and DocumentType DocumentType Product Auto publish a Enable content 7 updates Only uncheck this option when you dont have a primary key in your datasource When the record Update record w already exists Select primary key productiD X in datasource Select parent ProductCategorylD w relation key Select the column which is related to the primary key of the parent Import
32. 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 assien more than 1 image example ime imagel ime 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 assiened value 15 null Choose When the import process is finished you ll see that the media items are imported DAMP Classic Choose Create xsitrebel 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 2013 Soeteman Software page 27 49 CMSImport PRO User manual Version 2 5 PEA COREA Media Contents Properties de Media 4 7 a d import a dk img Contents logos i ikrebel 5 RecycleBin Sections al 2 O I Conant Mera Luren S t Li nag 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 imported media items Conbent Conb
33. lders 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 relative url will be imported automatically into Umbraco and the reference will be updated The following extensions are supported doc docx pdf ppt ppix rar xls xalsx zip You can add remove extensions in the settings folder of CMSImport 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 2013 Soeteman Software page 25 49 CMSImport PRO User manual Version 2 5 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 mediaFicker Tab Content Image bl x 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 E Afias mediaMntp Tab Content Media stored with
34. lers 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 11 5 Manual configuration of the node actions Open the umbraco config create ui config file And add the following snippet to that file 2013 Soeteman Software page 48 49 CMSImport PRO User manual Version 2 5 12 Troubleshooting 12 1 I 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 12 2 I don t see my column names when importing from a CSV file Make sure that your csv file contains column names 12 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 12 4 get an error not supported error when using access 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 displayLang en 22 Make sure to enable 32 bits applications on the application pool running the website advanced Settings 7 x El General ae Mame ASP HET v4 0 Queue Length 1000 Start Automatically True El CPU Limit 1
35. low you find the FieldProvider We tell the import module to use our FieldProvider by setting the PropertyEditorAlias to the DataTypeld Guid or alias in Umbraco V7 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 And we set the priority to high so we know our FieldProvider will be hit before any other Field providers for this Data type lt summary gt Converts the text value of the datasource to the prevalue Id of the ProductColor datat ype Ei lt sunmary gt FieldProvider PropertyEditorAlias a74ea9c9 8el8 4d2a 8cf6 13c620605da6 Priority Field Prio High public class AutoAddProductColorToList gt public object Parse object value Property property FieldProviderOptions fieldProvide rOptions if property PropertyType DataTypeDefinition Text Produecttolar ver dt property PropertyType DataTypeDefinition value GetOrCreatePrevalue dt Id value ToString return value lt summary gt 2013 Soeteman Software page 43 49 CMSImport PRO User manual Version 2 5 Search in the prevalues list for the database Value if nothing found lt summary gt lt returns gt return true when found lt returns gt private int GetOrCreatePrevalue int dataTypeDefinitionID string value var preValues PreValues GetPreValues dataType
36. mmerce and Uwebshop This document describes PRO features only The free edition is limited in functionality Access Datasource requires you to install an extra driver from Microsoft 2013 Soeteman Software page 4 49 CMSImport PRO User manual Version 2 5 2 Installation Install the CMSImport PRO package using the Umbraco package installer s regn Absui o bisig PR Logset mimin heat loge metal bing the package C memga de Developer de Cache Browser Please note Installing 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 di lacras sl de Packages fe Limbraco package Reposilory Hame Cmsimport Version 2 0 di Created packages Author Soeteman Software l lrstabed packages dk Installed packages More info hitpe barns coimpart com de Install skin License Umbrsco Deli Package License Agreement Standard GF install local package di Seripling Files DE Accept license Accept license SLT Fies Read me TMSImport helps you import content or members from any dakasource into Umbraco by simply defining a mapping bebasan the Datasource and Umbraco properties The folleretng datasources are supported by detaull GOL Server CON file XML file if you have a bl ense you can use the following datasources also Excel Ar Mir Binary files in the package Esad more metho
37. nel 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 10 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 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 10 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 2013 Soeteman Software page 40 49 CMSImport PRO User manual Version 2 5 using SqlConnection sqlConnection new SqlConnection Data
38. nteger values 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 ramuarrinn failad whan enmuartina tha raarrhar walia Plark ta data hina int This can be solved using a FieldProvider 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 it doesn t exists so we don t need to create the prevalues first Be
39. ontrol to the dashboard config file also Example configuration C CMSimport t Import data lt section gt de import definitions Brenn area gt cont ent lt area gt scheduled imports lt aresas gt 4 Settings lt tab caption Import Data gt lt acceaa gt Login credentials email settin lt grant gt writer lt grant gt st Scheduler result email setting CUGLCIDS nee i on lt control gt umbraco plugins cmsimport dashboardcontrols cmsimportdashboardcontrol ascx lt contrel gt Media Settings lt tab gt aie amp Data adapters JG amp importDashboard settings Import definitions ars to impor csvMember import ProductCategory Member Testdata Mmeber Hen yie Lee blogs Fergus2011 4 m Fergus2008 Datels we SimpleMemberData el octi mE Z O tert Vota Users et td uml a re so 2013 Soeteman Software page 35 49 CMSImport PRO User manual Version 2 5 10 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 soetemansoftware nl downloads CMSImportVs2012Samples 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 10 1 Setting up Visual S
40. re page 13 49 CMSImport PRO User manual a Import Finished Import is finished import duration him s 00 00 00 Records retrieved Records imported a w PS Errors Previous Quick tip Version 2 5 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 a CMSImport 4 Import data a di Import definitions Content 2 ProductCategory gt di Members gt di Scheduled imports i di Settings Possible icons for saved content items 2013 Soeteman Software page 14 49 CMSImport PRO User manual Version 2 5 Standard import definition 3 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 ProductCate
41. s lt summary gt Field provider to make sure the boolean values gets imported correctly lt summary gt FieldProvider PropertyEditorAlias aL 06d9 Priority Medium FieldProvider PropertyEditorAlias Umbraco TrueFalse ium public class BooleanFieldProvider iarveanvuoay ya Sa DU oa aA y Priority Med fit FL ees lt summary gt Parse the data to the correct format lt summary gt tid 22 E HV lt param name lt param name lt param name lt returne gt lt returns gt gt The value to parse lt param gt gt The property lt param gt gt The options lt param gt FieldAdapters are replaced with FieldProviders since cmsimport 2 5 2013 Soeteman Software page 36 49 CMSImport PRO User manual Version 2 5 public object Parse object value Property property FieldProviderOptions fieldProvide rOptions if value Equals 0 value Equals 1 bool boolValue false if bool TryParse value ToString out boolValue return boolValue D return value This Parse method accepts the following parameters Value The original value which we can manipulate Property Gives us information about the document type FieldProviderOptions Options you can use for importing data Currently only userld 10 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
42. s posts pages and comments 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 create the correct mapping also Don t select this option when you just want to import the blogposts and blogcomments based on an Umbraco documenttype Select Datasource N ed EE Select a local file F umbraco Products Specify a url http Y Optimize for Blog4Umbraco CMSImport determined that you have installed Blog4Umbraco When you check the Optimize for Blog4Umbraco option CMSImport will automatically import the comments and CMSImport will automatically map the document properties for you Previous Next Wordpress requires install of the CMSImport DataAdapters Wordpress package file 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 if you started the import from the context menu in content You can also specify the 2013 Soeteman Software page 10 49 CMSImport PRO User manual Version 2 5 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
43. tCustomRelation PRIMARY KEY CLUSTERED CustomRelationId 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 2013 Soeteman Software page 46 49 CMSImport PRO User manual Version 2 5 11 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 xmli if you use the Dutch language in Umbraco open nl xml etc Replace With 11 4 Manual configuration of the scheduled task handler Open the config umbracoSettings config file Replace With 2013 Soeteman Software page 47 49 CMSImport PRO User manual Version 2 5 And replace url to mysite umbraco with the url of your site including the umbraco path For example http cmsimport com umbraco plugins CMSImport Hand
44. that occurred during the import process 9 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 You can also specify some domains url s that needs to be picked up Url s starting with that domain will also be picked up You still need to make sure files are located in the root of your Umbraco install 2013 Soeteman Software page 33 49 CMSImport PRO User manual Version 2 5 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 Richtext property other file extensions will be ignored When mapped against normal media picker all file extensions will be picked up Parse media for the following domain urls CMS import can only import files that ares stored in the rootfolder of Umbraco by default Sometimes a full url is specified in a field that is mapped against a Richtext property This setting allows you to specify domain urls so url s containing these domain urls will be converted to relative paths example http Sara orreimport com images foreenshot png will be converted to fimazes fsoreenshot png when you specify the domain url http arar Omsimport com Add extension a http Ad
45. tudio 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 10 2 What s in CMSImport extensions 10 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 10 2 2 FieldProvider A FieldProvider 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 FieldProviders to import media A FieldProvider is basically an implementation of the IFieldProvider interface that contains a parse method decorated with a FieldProvider attribute which contains the DataAdapterld property and the Parse method The DataAdapterID must match with the DataAdapterControl This will ensure that the parse method gets called when data is imported for the property using CMSImport Extensions FieldProvider using umbraco cms businesslogic property namespace CMSImportLibrary Providers FieldProviders DefaultFieldAdapter
46. u 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 2013 Soeteman Software page 30 49 CMSImport PRO User manual Version 2 5 a Ji CMSImport si Import data gt de Import definitions a Scheduled imports gt di Weekly a bi Daily i Products gt di Hourly gt di Settings When the import is finished you will receive a notification email on the specified email address 7 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 Scheduled Product task Schedule Every day at 14 28 Next run time 11 June 2011 16 28 Last run time 10 June 2011 16 29 scheduled Executed 10 Jure 2011 16 28 10 June 2011 16 24 Clear history 2013 Soeteman Software page 31 49 CMSImport PRO User manual Version 2 5 8 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 you want your users to upload a new product catalo
47. upported 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 2013 Soeteman Software page 18 49 CMSImport PRO User manual Version 2 5 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 LuASImport PRO 1 1 id Select Datasource Enter a Connection String XPRESS database AdventureWorksL mm m SELECT FROM SalesLT Customer gt 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 Datasource The csv file must contain unique headers ARAS Select a local file CWsersiichardDes O Specify a url Field Seperator Text Indicator No seperator Previous Next 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 2013 Soeteman Software page 19 49
48. ventArgs contains the alias of the DataAdapter 10 2 3 4 Imported The Imported event gets hit after the import has finished ImportEventArgs contains the alias of the DataAdapter 10 2 3 5 Bulkimporting The Bulklmporting event gets hit when a bulk content import is started ImportEventArgs contains the following info Importid The unique id GUID of the import definition ImportName The name of the saved import definition 10 2 3 6 Bulkimported The Bulkimported event gets hit when a bulk content import has ended ImportEventArgs contains the following info Importid The unique id GUID of the import definition ImportName The name of the saved import definition 10 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 2013 Soeteman Software page 38 49 CMSImport PRO User manual Version 2 5 Edit datatype ProductColor lal Loe ProductColor Render control Dropdown list Data Type GUID ald4ea9c9 feld 4d2a bcf6 73cb6206ch5dab 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 Os Dr Content Site Content Properties pr Content Y Q A gt de Runway Homepage
Download Pdf Manuals
Related Search