MemberExport PRO User manual
Contents
1. Return the name of the provider this will be displayed in the selectbox summary value The selected name value public override string Name 1 get return CSV file 4 2 2 CsvProvider The second part we need implement is the provider itself which handles the actual export process Create a new class and derive from ExportProviderBase This will give you an Export method and Icon property The Icon property will be displayed when opening the saved exports tree In this implementation we ve added the StringIndicator and Delimiter options which gets set from the UI The export method will give a list of columns to export and all records using an IRecordReader The rest of the code is implementation specific Two important things to know when exporting records When assigning a value always use the ValueParser factory ValueParser Parse reader GetObject column Alias column To write the file to the browser either use the WriteResponseString for stringvalues or WriteResponseBytes for a byte array methods Both methods need the Contenttype Mimetype and fileExtension using System using System Collections Generic using MemberExport Library Csv using MemberExport Library Members using MemberExport Library Types namespace MemberExport Library ExportProviders CSV 1 summary CSV Default implementation of MemberExport summary Serializable public class CSVProvider Expor2. MemberExport PRO User manual EL MemberExport PRO User manual Version 2 0 0 MemberExport PRO User manual css sse tenen nennen nnne nennen 1 1 INTRODUCTION eS 3 2 INSTALLATION te sassccsassansuen saveescendanseun sa esSeseedansennedeccesdesacscewsassssasasaese 4 3 EXPORT 3 cet EIE 5 4 EXTEND MEMBEREXPORT ee eeeeee eene e nnn nennen nnns sanatus aE ni suas sanus sete Ei 6 4 1 valus Nerei DI EE 6 4 2 Export providet cei eterno ei era itt ipeo ieee eee ieee 7 4 2 1 CSVProviderUl 2 22 22 2 232 deb dad ER dela 7 4 2 2 CSV dioe E H 9 5 MANUAL INSTALLATION CONFIGURATION sccccssecsssssssessccecessssesssssesecesessesssscacseeeessess 11 5 1 Manual installation of files SA EEG ae ER DE een RES el en nennen 11 5 2 Manual configuration of Database sssssssssseeeeeenenn ener nnne 11 6 TROUBLESHOOTING 4 40 rss axe os Ve eo de Up aa kd oe EUS SENERE SERENE 12 6 1 don t see the MemberExport package in my members section eesseeesssss 12 6 2 My CSV file is messed up when opening in Excel sssseeeeee 12 6 3 get an Invalid License exception sssessseseeneenen mener nnne 12 6 4 I get an Invalid Membership provider message sssseee 12 2011 Soeteman Software page 2 12 MemberExport PRO User manual Version 2 0 0 1 Introduction MemberExport Pro helps you export members from y
3. an specify what to export specify the export format Excel or csv and you can specify the csv export options in case of csv export Member Export Pr ud Select member groups J Admin 7 Employee Select member type Employee Export properties Flid J Email Name V Created by 7 Login Created V Password Department Export as CSV fle Field Seperator Excel fie Text Indicator No Text Indicator v When you click the export button you can download or open the csv file You can save the export options for later use by hitting the save button The saved exports will be stored in the same Export Members folder The save option will only save the export definition The actual export file will be generated on the fly Members Members i Members J Member Groups Member Types 4 amp Export members 4 Saved exports Csv export fl Excel export 2011 Soeteman Software page 5 12 MemberExport PRO User manual Version 2 0 0 4 Extend MemberExport MemberExport is an out of the box product still in some cases you might want to modify the package to your needs MemberExport can be extended by writing your own value parsers and export providers 4 1 Value parsers By default MemberExport exports the stored value from the database When this value is an Id value you might want to export the text value instead This can be achieved using a value parser By default MemberExport comes with val
4. itialize the Ul options based on the stored export provider settings In this case exportProvider will hold the text delimiter and text indicator options GetOptions will return the export provider settings so we use those settings when exporting records 2011 Soeteman Software page 7 12 MemberExport PRO User manual Version 2 0 0 The name property will return the name of the provider stored in the Export as dropdownlist when selecting an export provider using System using System Web UI using System Web UI WebControls using MemberExport Resources Helpers using umbraco uicontrols namespace MemberExport Library ExportProviders CSV summary Renders the Layout for the CSV Provider lt summary gt public class CSVProviderUI ExportProviderUIBase INamingContainer protected DropDownList _csvTextIndicatorDropDownList new DropDownList protected DropDownList _csvSVSeperatorDropDownList new DropDownList protected override void OnInit EventArgs e base OnInit e _csvSVSeperatorDropDownList Items Add new ListItem _csvSVSeperatorDropDownList Items Add new ListItem _csvTextIndicatorDropDownList Items Add new ListItem ResourceHelper Current GetStringResour ce CSVNoTextIndicator _csvTextIndicatorDropDownList Items Add new ListItem D _csvTextIndicatorDropDownList Items Add new ListItem 3 PropertyPanel delimiterPropery new Proper
5. nds of members in second IMPORTANT This installer will need modify rights to folders bin and umbraco folder and aso needs to be allowed to create tables in the database For a manual installation read the documentation Binary files in the package This package contains NET code This is not unusual as NET code is used for amy advanced functionality on an Umbrace powered wedwite However you don t know the author of the package or are unsure why this package contains these files it is adviced not to continue the installation The Files in question Memberfxport Core dil Mamharf snart NA dii e Internet Bevesligde modus uttgeschekeld Make sure that the installer has modify rights on the following folders e bin 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 member section called MemberExport You might need a page refresh to see this folder O 2011 Soeteman Software page 4 12 MemberExport PRO User manual Version 2 0 0 3 Export Members To export members you browse to the Member section of your Umbraco site Open the Export members folder and click on the Export members menu option The export member screen will appear Here you c
6. our Umbraco installation to an Excel or Csv file It s also possible to save the export options steps for later use MemberExport PRO can export thousands of members in a few seconds MemberExport uses the database directly and will only work with the default Umbraco Membership provider 2011 Soeteman Software page 3 12 MemberExport PRO User manual Version 2 0 0 2 Installation Install the MemberExport PRO package using the Umbraco package installer ir Favorieten 3 Developer Umbreco CM E sboutblank iP Content Umbraco CMS 9 Ambe umbrecovitest Iocal umbraco umbreco aspetdevelopes len websites q Web Si FOE 0c o5 Pee Bewgeg Brae Gr ogee 8 Developer Umbraco CMS umbracowltest local Cevelover dl Developer nstalling the p Cache Browser Name J Data Types A De om D ooe rareo Imatalling the package MemberExport PRO ge Membertxport P Menbertxport PRO Version 1 0 Soeteman Software t Macros 4 d Packages Umbraco package Repository http memberexport soetemansoftwere ni Menbertxport Liceme Created packages V Accept license MemberExport helps you exporting Umbraco members to a csr file One installed it adds a new folder to the Members section Installed packages Install Rurmay Instat local package d Priton Files d XSLT Fies 3 CMSimport With this pro version you can seve your export options for later use MemberExport PRO can export thousa
7. rform a manual installation see chapter 4 6 2 My CSV file is messed up when opening in Excel Make sure that you set the correct options to display the CSV file For Excel choose as the delimiter and as a string indicator 6 3 I get an Invalid License exception Make sure you ve bought the correct license for the sub domain or an enterprise license and added the license file to the bin folder Contact support soetemansoftware nl for help 6 4 I get an Invalid Membership provider message MemberExport uses the Database directly and will therefore only work with the default Membership provider Contact support soetemansoftware nl for help 2011 Soeteman Software page 12 12
8. tProviderBase lt summary gt Exports the data to a csv file lt summary gt param name columns gt Collection of column info lt param gt lt param name reader gt The actual data to export lt param gt public override void Export List lt Types MemberField gt columns umbraco DataLayer IRecordsReader r eader Use a csv writer object CsvWriter writer new CsvWriter Delimiter StringIndicator Add columns to export foreach MemberField field in columns Add data to export while reader Read writer Columns Add field Text Get values for the current row List lt object gt values new List lt object gt foreach MemberField column in columns values Add ValueParser Parse reader GetObject column Alias column 2011 Soeteman Software page 9 12 MemberExport PRO User manual Version 2 0 0 write values to csvwriter writer Add values ToArray Write response to the browser WriteResponseString writer Parse application excel csv lt summary gt Gets or sets the string indicator lt summary gt value The string indicator lt value gt public string StringIndicator get set lt summary gt Gets or sets the delimiter lt summary gt value The delimiter lt value gt public string Delimiter get set lt summary gt Returns the icon that will be displa
9. tyPanel delimiterPropery Text ResourceHelper Current GetStringResource CSVSeperatorProperty delimiterPropery Controls Add csvSVSeperatorDropDownList PropertyPanel stringIndicatorPropery new PropertyPanel stringIndicatorPropery Text ResourceHelper Current GetStringResource CSVTextIndicatorPro perty stringIndicatorPropery Controls Add _csvTextIndicatorDropDownList Controls Add delimiterPropery Controls Add stringIndicatorPropery summary Sets the export options delimiter and string indicator lt summary gt param name exportProvider gt The export provider lt param gt public override void Initialize ExportProviderBase exportProvider 1 CSVProvider csvProvider exportProvider as CSVProvider if csvProvider null _csvSVSeperatorDropDownList SelectedValue csvProvider Delimiter _csvTextIndicatorDropDownList SelectedValue csvProvider StringIndicator j summary Returns the selected export options delimiter and string indicator summary returns returns public override ExportProviderBase GetOptions 1 CSVProvider csvProvider new CSVProvider csvProvider Delimiter _csvSVSeperatorDropDownList SelectedValue csvProvider StringIndicator _csvTextIndicatorDropDownList SelectedValue return csvProvider j summary 2011 Soeteman Software page 8 12 MemberExport PRO User manual Version 2 0 0
10. ue parsers for the following datatypes e Checkbox e Dropdownlist e MNTP e MuiltipleDropdownlist e Radiobox e Ultimatepicker In the example below we will write a value parser for the True false datatype By default values will be exported as 1 0 We want the values to be exported as yes no for this example First we need to add a reference to the MemberExport Library dll Then we can create a class that implements the IValueParser interface public class TrueFalseParser IValueParser lt summary gt Returns the Datatype GUID of the true false Render Control lt summary gt public Guid DataTypeld get return new Guid 38b352c1 e9f8 4fd8 9324 9a2eab86d97a lt summary gt Converts the 8 1 to a normal yes no string lt summary gt lt param name memberfieldInfo gt The memberfield info lt param gt lt param name value gt The value lt param gt returns The yes no string lt returns gt public object Parse Library Types MemberField memberfieldInfo object value return string Format 0 value 1 yes no The DataTypeld property needs to return the GUID which is displayed on the datatype edit screen 2011 Soeteman Software page 6 12 MemberExport PRO User manual Version 2 0 0 Edit datatype True false a Name True false Render control True False Ja Nej v Data Editor GUID 38b352c1 e9f8 4fd8 9324 9a2eab06d97a Database datat
11. yed in the saved tree lt summary gt lt value gt The icon lt value gt public override string Icon get return csvexport gif j 2011 Soeteman Software page 10 12 MemberExport PRO User manual Version 2 0 0 5 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 umbraco you need to install MemberExport PRO Manually 5 1 Manual installation of files Open de folder in the zip file Copy all dll files to the umbraco bin folder Copy csvexport gif to the umbraco images Umbraco folder Create the following folders o umbraco plugins MemberExport o umbraco plugins MemberExport Config o umbraco plugins MemberExport UserControls Copy all aspx files to the umbraco plugins MemberExport folder Copy MemberExport ascx to the umbraco plugins MemberExport Usercontrols folder If you purchases a license Lic file Put that in the Bin folder of your Umbraco install 5 2 Manual configuration of Database Run the following script to install the database tables O 2011 Soeteman Software page 11 12 MemberExport PRO User manual Version 2 0 0 6 Troubleshooting 6 1 I don t see the MemberExport package in my members section Make sure you have sufficient rights to install the package See chapter 2 otherwise pe
12. ype Integer w The Parse method will be called when a true false property value is exported In the above example we transform the value to yes no The following information about the exported field is available in the memberFieldInfo variable DataTypeld The GUID which is displayed on the datatype edit screen DatatypeNodeld The node id of the Datatype Alias The Property alias Text The Property text To use the Value Parser all we need to compile the project and add the dll to the bin folder of the Umbraco install Then it will be picked up automatically and values will be exported as yes no In the example below the Active column is exported as true false value using the Value Parser A B c M Id Name Login Email Active 1057 Richard Scrsoeteman richard soetemansoftware nl Yes 4 2 Export provider MemberExport comes with two Export providers Csv and Excel If you want to create a provider yourself you can do this by implementing two classes and store the dll that contains the provider into the bin folder of your Umbraco install Below the implementation of the CSV Provider This is only possible with the PRO edition of MemberExport 4 2 1 CSVProviderUl The CSVProviderUI class is the class which is responsible for the UI part of the provider Add a reference to the MemberExport Library dll and derive from ExportProviderUlBase class Implement to following methods Onlnit create the UI controls Initialize in
Download Pdf Manuals
Related Search