DOTNETNUKE SOLUTIONS
Contents
1. 12 _ 12 RECTBYAFFILIATEID 12 13 12 12 12 12 iaaa E R D 9 12 5 aes Ree A a ee ea eS 11 12 1 11 12 8 EEE 1 16 17 Connect 8 Connected Table lt dee oe te 8 neato 6 7 8 9 10 11 12 14 15 22 seven da Sadan 9 10 D Data GFO eRe re 9 13 14 Data EY Pe a 8 hee eee EEE 32. eae 16 5 16 NOTIFICATIONS 16 ITEM RELATIONSHIPS SUB PARENT AND RELATED 2220202 16 RELATED FILES EET SE 17 AUTOMATED DATA COLLECTION AND PROCESSING OF 9 17 EMAL TEMPLATES csesscsscsccdscsecscvsssusoesectasessovonevedostecoutsbonsunsevsevetvoveeoadentedees oeseri 17 SETTING UP YOUR OWN USER REGISTRATION MODULE 18 SETTING UP PAYPAL ENABLED 5 18 FILTERING AND SORTING THE RESULTS 19 ee 20 gt gt E E E A oe 21 Information in this document including URL and other Internet Web site references is subject to change without notice The entire risk of the use or the results of the use of this document remains with the user Copyright 2006 Chris Onyak OnyakTech com All Rights Reserved Updated on December 2 2006 OnyakTech eBusiness Solutions Liberty Commons Office Complex 1300 Weathervane Lane Suite 324 Akron OHIO 44313 USA WWW ONYAKTECH COM Sales OnyakTech com Support OnyakTech com Introduction As on ongoing commitment to quality and perfection all OnyakTech modules for DotNetNuke are constantly being revised to include additional minor changes as requested by our customers Therefore this document may be outdated by the time you read it Ple
3. RUN ics Sie ON GSE hats Soa 2 7 10 20 6 sends ae esa Wan ieee 9 13 14 F 10 ee E 1 16 18 ee 5 17 21 5 1 2 4 6 16 17 20 22 23 H gt 5 A 9 10 11 12 14 19 22 20 5 1 1 11 fates N 1 17 1 E 16 J 5 9 11 L secre dats ch dct 7 9 10 M ARR 3 22 N oes 1 17 ce 1 15 PayPal ne 2 20 22 23 E babe eee 10 8 Rada ae eee 4 5 6 8 16 19 21 22 A RET EEE CRT 15 16 19 20 21 22 AO 1 5 14 15 19 21
4. 2 4 SOLUTIONS Professional Modules and Skins 20421 00 0 40000 40 0040 0 0 4 1866 4 0 0 020 00000000 00 3 USER MANUAL 55 5 2222222222 2 2 2 2 2 4 3 3 ol MAN AED 3 3 MEMBERS AR EA ci aceon 3 INSTALLING HQ Ovi sicccccccscccsssciscscsssivssssesosssscsvessnascsecsneosecdasaoscooscdensosdsaondeessossbebavdoasosscoes 3 20 5 4 canoe 5 TEAMS 555 T 5 PROJECTS 5 MODULE 5 00 00 2 000 00000000000000000 5 GETTING STARTED 5 2 0000 0 002 00000000000000 EEE 6 ae A ee tbh A etd 6 ADDING CONTROLS YOUR 220 0202000 20 2000 6 SECURE FORM FIELDS BY A USERS 8 7 ENTER DATA VALI
5. Directly It is strongly recommended that you carefully plan Table Connected H20 forms Improper planning could damage referential integrity of your table To help aid this the Primary Key field in the 20 form is disabled so that it can t be changed With directly connect forms e You must specify the Primary Key of the Table it s connecting to Otherwise data synchronizations will not be performed e When an item task in a project is saved all fields in the Form that match the name of fields in the Table are updated 20 and in the connected Table e Your tables must not contain fields of data type char or nchar e When viewing results the data is synchronized between 20 and the connected table Any new records in the connected table will be created in H20 Control Type Specifics e Label Controls Use label controls to add additional functionality to your 2 forms For example if you want to simply redirect user to a specific page based on their user role create a form with just a Label control and enter your command into the 20 Script property of the control For example you might enter COM_REDIRECTBYROLE Administrators gt http www OnyakTech c om This will redirect all users in the Administrators role to OnyakTech com You could use any control to create this functionality the label control is just used as an example e Data Grid Enter your SQL Statement into the H2O Script field All fi
6. Question How do set the quantity of PayPal enabled 2 Forms Answer To have H20 automatically calculate the quantity just add a field named Quantity to your form When the form is saved and the user is sent to PayPal com for payment 2 will use the Quantity field to set the amount and send this to PayPal You should use the validation property to check for numeric input Question change the icon displayed for the 2 Project Answer Yes open the project details screen and enter the URL to the image in the Menu Image URL field Question Can 20 display different results in separate instances of H20 For example want one instance to display all entries while another instance of H2O filters the entered items based on a field value 20 Answer Yes H20 by default will display all items For second instance set the Default Filter property in the Project Details This setting is stored at the module level so that you can have different filters for each module instance This also applies to the Sort property of the project as well Question Can 2 send emails of new submitted forms to a custom list of email addresses Answer Yes enter the email addresses into the Additional Email Notification List of the project Question Can 2 render just the form and ignore processing involved with the H20 projects Answer Yes click on Edit 20 and then open User Interaction Then check Only
7. Display Form Remove All Else and click Update Question Does 20 provide a list of transactions processed with PayPal enabled forms Answer You must install the PayPal Log module from OnyakTech to view a complete list of PayPal transactions processed through H20 This is included with the purchase of 20 Question Is it possible to lock a form from being changed after it s created Answer Yes click Lock Forms After Submit in the User Interactions section of Edit H2O module menu item Question Can 2 prevent users from creating more then one form while still allowing the user to come back at a later time and modify the form Answer Yes check Allow Only 1 Form Entry Per User in the User Interactions section of Edit H2O module menu item Question What is Quick Entry Answer Quick Entry mode displays a specific form to the user and then redirects them to the URL of your choice after they have completed the form INDEX A at 11 11 Attribute Value 11 Autos Fill 1 14 aunts a ol 9 COLUMN 6 7 9 10 21 COM GRANTROLE
8. now want a separate page to display this data thru a data grid and this page should be accessible only to administrator How can create the page for displaying data Answer All you should need to do is simply add 20 to another page default H2O will show all projects within your portal you should be able to click on the project icon to view the entered data You don t need to create another form and another project to view information on an 20 project used another module instance H2O Projects are global to the entire portal unless you secure it to a specific module instance Question would like to be able to edit a table that have directly connected to in 2 is this possible Answer Yes When you connect 20 directly to an existing table you can change the values in the table by editing the table directly either through some SQL Server editing tool or a custom application or by editing existing records through 20 2 automatically synchronizes record changes between both 20 and your existing table If you change records in your table those changes will get replicated to 2 If you change records in 20 those changes will get replicated to your existing table Question want to use the radio button list SQL control have the SQL query to pull the list of buttons that want Answer The SQL for all SQL related controls should be entered into the 2 Script field for the control
9. 8 19 7 10 thea vous cha hos Ba eae 6 16 U User REGISEFALION a a E N T eS 1 14 15 19 20 V Vada O 1 7 8 11 ie Grae at Ga 11 23
10. DATION FOR A 7 2 FORM NAMES 2 7 DIRECT CONNECTIONS WITH TABLES 8 CONTROL TYPE SPECIFICS 2 02 00 0 000000 000000000000 0000 8 CONTROL 5 1 2 2 1 111 9 H20 SCRIPTING ciscccsieisccssccsscscscsossosvcusegusssscssesesessastensoevescossuvessebausesns cusesnsdensesnssstdessess 11 2 COMMANDS EER 11 AVAILABLE SOLTAGS a allo toes a 12 N B g D N ETES A A N S AE EA 13 CUSTOM 14 H20 MODULE 5 2 2 2 2 2 22 244 7 000 14 VISUALS ETTIINGS wash 14 USER INTERACTION SETTINGS 2 2 0 0 2 022 201 1 0 01 0000000000 15 15 SECURITY OPTIONS et ee ee 16 FORM ENTRY ITEM DETAI L 5 16 COMMENTS
11. PORTALALIAS Returns the portals Portal Alias 12 CPT PORTALID Returns the portals Portal Id CPT PORTALNAME Returns the portals Portal Name CPT REGROLEID Returns the portals Registered Role Id CPT USRTABID Returns the portals User Tab Id Auto Fill Tags To auto fill values into a control when the form is processed use the following 20 Script Tags These codes should be entered into the 2 Script field They are not case sensitive Note that these codes are not valid for the Data Grid External List Register Body Script and Register Body Startup Script tags UserID Fills the field value with the current users User ID LastName Fills the field value with the current users Last Name FirstName Fills the field value with the current users First Name FullName Fills the field value with the current users Full Name Affiliatel D Fills the field value with the current users Affiliate 10 Email Fills the field value with the current users email address Portall D Fills the filed value with the current Portal ID UserReg_FirstName Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_LastName Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Password Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_PasswordConfirm Used with User Registration option in Proj
12. Q Query SUING 15 kee ES 4 16 23 R neiuna n IENEN EE ONERE Sud adh 9 5 a 1 18 7 11 OS ttt 2 8 20 22 an beet ate ose 1 5 11 12 13 20 se a IS hc Se 6 7 10 5 1 7 baat 1 7 15 17 550 15 21 SOL tai ete 1 6 7 8 9 11 13 15 22 3 a ie 8 Synchronized sen e a a E E E E RRE aT 8 T IEE E EEE AE EEE EEE SR Pe SAAE AA 6 8 19 Rd ee 1 11 13 14 19 eta des Ach ae ee tee ola 16 1 5 lt 1 15 17 1
13. anges in that table will update your H2O project Any changes in your 2 project will update the existing table You can create H20 forms that are connected to an existing table and also have controls that pull data from other tables For example you may have a User Profile form that displays data on the current user and then also have a data grid that shows the user their recent purchases You can have H2O automatically create a form for you by specifying an existing table This form can then be left as is or connected to that table for automatic synchronization You can create an 2 form that contains only scripting Java or H20 Useful for redirecting users to a specific page based on the region specified their profile Or displaying a pop up advertisement with advanced graphics using Java are four areas to understand in 2 Forms Contain the visual appearance fields data synchronization configurations script and logic commands for 20 These can be downloaded for use on 2 installation assigned to H2O project as a sub form in H2O project Teams A collection of DNN Users that are assigned to one or more 20 Projects for the primary purpose of identifying security rights at a group level Teams can be quickly populated by specifying a Role to import users from Projects Projects are a container for your H2O forms that provide meta data and additional processing For example if you cre
14. ase make sure you check for new releases by logging into OnyakTech com and checking the My Downloads page in the Members tab In the Members area you will find information on every release as well as discussions on them in the Members Forums User Manual Assumptions This manual will guide you through the installation and administration of H2O It is assumed that the reader of this document is familiar with the use of DotNetNuke and further familiar with the terminology associated with DotNetNuke which includes Portals Private Assemblies Uploading files Roles Host Admin User etc URL s Domains Containers This manual also assumes that the reader has installed DotNetNuke either on his her local computer or on a server system Help Videos on using DNN are available for download in the Members Area on www OnyakTech com Support Web Based Go www OnyakTech com log in and click on the Support page to submit requests You can also submit support requests from the My OnyakTech page in the Members tab on OnyakTech com Live Chat Using Yahoo Instant Messenger contact OnyakTech support with user id ONYAKTECH Members Area Obtain updates Support and more If you have not done so already contact Support OnyakTech com to request Members Area access If you purchase from OnyakTech com directly then you are given access immediately after purchase The Members Area includes product downloads with email notificatio
15. at It gives you the ability to turn a form into much more then just a way to collect data Forms in 2 are like modules in DotNetNuke You must have DotNetNuke before you can have the module Forms in 2 define an interface however it s data unless connected to an external table is stored locally within a project Any changes to that data are also stored against the project All security teams sub forms etc all tied to the project This design allows you to quickly build applications within DNN and maintain the forms independence from the project so that you can re use the form in other projects or even as sub forms in a project By using Quick Entry and other related options in the configurations of 2 you can setup 2 to display a single form very easily and have it presented to the user as if it s not attached to any projects The primary original purpose of 20 was to provide a custom forms module that was not limited to XML which suffers from database searching and a performance loss We also didn t want to make it mandatory to know database programming This resulted in 20 storing it s data in its own tables while also giving you the option to automatically synchronize with tables in your database Simply put You can create 2 forms from scratch that have no connections to existing tables in your database You can create 20 forms that are connected to an existing table Any ch
16. ated an article form you would use the project to allow visitors to post comments create a custom view of your articles filter your articles assign security etc Your forms must be assigned to a project for them to function Module Configurations This is where you configure how H20 will be presented to the user and how the projects and forms will be used For example you could configure 20 to simply display just a single 20 form and nothing else or display a menu of all projects in your system with icons or display a list of posted forms in a project and allowing the user to drill down into the form details etc Getting Started Fast get started quickly log on to www OnyakTech com and download 20 Forms from the Repository These are simple forms but should get you going and give you an idea of can be done Another great way to get started especially if you need to build a form with a lot of fields is to first create a table in SQL Server that contains all the fields you will want your form to contain Then create a new form 20 by entering the name of the table you just created as the Form Name and click the Generate From Table link 2 will then create your form with all fields and labels as well as having it properly formatted Step By Step These Step By Step procedures assume you are using the default module configurations of 2 Creating 2 Form 1 Click Forms in the H20 Toolbar 2 Click
17. ects to connect this field to the DNN Registration fields UserReg_UserName Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_ Unit Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_ Street Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_City Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Region Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_ Postal Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Country Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Telephone Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Email Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Cell Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_Fax Used with User Registration option in Projects to connect this field to the DNN Registration fields UserReg_IM Used with User Registration option in Projects to connect this field to the DNN Registration fields UserR
18. eg_WebSite Used with User Registration option in Projects to connect this field to the DNN Registration fields NOW Inserts the current date and time 13 Custom Parameters Use Session and Query String Parameters to create dynamic form content You can run reports dynamically based on Session and or Query String Parameters The syntax is the same as the Parameter Keys You can define these parameters in any control that accepts SQL For Session values use the syntax SSN YOURSESSIONVARIABLEHERE For example if a module creates a session variable called UserlD then you can use the following SQL SELECT FROM dbo Users Where UserlD SSN UserID If it was a querystring parameter then you would use the following SELECT FROM dbo Users Where UserlD QRY UserlD 2 Module Settings H20 contains the following options in the Edit H2O module settings e Visual Settings Change the module logo Limit Items Displayed etc e Template Settings Change the way 20 generates Project Templates e User Interaction Change the way 2 interacts with the user e Security Settings Filter item list by creator Visual Settings This area of the Edit 2 screen allows you to change the images and toolbars that are displayed in the module e Toolbar Checking Display To All Users will display the 2 Toolbar displayed at the top of the module to everyone To hide this toolbar simply check the checkbo
19. elds returned will be displayed This control does not contain any formatting by default so you may also want to specify CSS in the CSS Class field to improve the visual appearance of your data grid e Radio Button List SQL Enter your SQL Statement into the H20 Script field If your SQL Statement only returns a single column that column will be used as the value and displayed text If your SQL Statement returns more then one column the first column is used as the value and the second column is used as the displayed text e External List Enter your SQL Statement into the 2 Script field If your SQL Statement only returns a single column that column will be used as the value and displayed text If your SQL Statement returns more then one column the first column is used as the value and the second column is used as the displayed text e Checkbox List and Radio Button List Type the items you want displayed in these lists into the Text field Each item needs to be separated by a semicolon e Register Body Startup Script This control is used to register Java VB Script on the page immediately after the Body tag Type your script into the 2 Script field e Register Body Script This control is used to register Java VB Script on the page near the end of the Body closing tag Type your script into the 20 Script field Note that DotNetNuke or other modules may be registering script on the page as well to prevent script errors fro
20. em to Ex COM_REDIRECTBYREGION Ohio gt http www OnyakTech com 11 The commands listed above are executed when the user clicks Save button on your form If you need to have the command executed as soon as the form is loaded you can use the commands below COM_ONINITSETNAME COM_ONINITGRANTROLE COM_ONINITREDIRECTBYROLE COM_ONINITREDIRECTBYAFFILIATEID COM_ONINITREDIRECTBYREGION The following tags are available for the External List and Data Grid controls for use in SQL Statements When the form is processed the tags are replaced with the corresponding value Available SQL Tags USR USERID Return the current users User 10 USR LASTNAME Returns the current users Last Name USR USERNAME Returns the current users User name USR FULLNAME Returns the current users Full Name USR FIRSTNAME Returns the current users First Name USR AFFILIATEID Returns the current users Affiliate 10 ATB ISDELETED Returns the Active Tabs Is Deleted value ATB URL Returns the Active Tabs Url ATB TITLE Returns the Active Tabs Title CPT EXPDATE Returns the portals Expiry Date CPT ADMID Returns the portals Administrator Id CPT ADMROLEID Returns the portals Administrator Role Id CPT ADMROLENAME Returns the portals Administrator Role Name CPT HOMEDIR Returns the portals Home Directory CPT HOMETABID Returns the portals Home Tab Id CPT HOSTSPACE Returns the portals Host Space CPT LOGTABID Returns the portals Login Tab Id CPT
21. field If the user should be required to enter a value into this control check the Required checkbox If you would like to give your user detailed information on this field enter your information into the Tool Tip field Enter values into any other fields you want to make use of and then click Update Control Info At this point you will see your new control listed in the controls data grid below the fields you where create edit your forms controls Secure Form Fields by a users DNN Role 1 Open the form you want to edit In the controls data grid click the Edit link to make that control active Under Control Security check the Roles you want to have the ability to edit this control Click Update Control Info Enter Data Validation for a Control 1 Open the form you want to edit In the controls data grid click the Edit link to make that control active In the Validation field enter a REGEX formula that 20 will use to validate data entry into this control A full list of REGEX formulas can be found at www RegExLib com Click Update Control Info 2 Form Names Each form in 2 must have a unique If you try to create a new form that has the same name as a form that already exists 2 will load in the form that already exist Direct Connections with Tables To directly associate an 2 form with an existing Table in SQL Server check the box directly under the Form Name field Check to Connect
22. fields for First Name Last Name User Name Password Password Confirm and Email Address Without these fields you may have problems creating the accounts in DotNetNuke e To connect a field in your 2 form to a field in the DotNetNuke Registration Profile use the 20 Script keywords that begin with UserReg_ e DO connect the form directly with a DNN Table This is unnecessary since 20 will automatically update and or create the profile after you check the Is DNN User Registration option in the Projects Detail screen If you need to start off with a current list of users use the Import Data function from the Project Details screen to import users from the DotNetNuke Users Table e You must check the option 15 DNN User Registration the 20 Project containing your registration form Setting Up PayPal Enabled Forms When setting up an instance of 20 to handle a form to process PayPal payments you must dedicate a single instance of the 20 to that form In other words you can t allow users to enter edit multiple forms projects in the 20 instance you want to enable with PayPal To setup PayPal with 20 click Edit 2 and then click on User Interactions At the bottom of the screen you will see the PayPal settings Complete the settings as described below 1 Check Enable PayPal Payments 2 The option to Allow Pending Transactions is used in conjunction with the Add User to Ro
23. ge if they are asked to log in Security Options At the writing of this document the security section allows one option To filter by Creator By checking this option the logged in user will only be able to see the items they created Form Entry Item Detail Tabs Comments You can add comments to an item by typing in the Comments text box at the bottom of the item and clicking Add Comment Note Comments can not be changed once they have been added to an item History Every time an item is saved the system automatically logs the user who saved it along with the date and time This information can be viewed from the History Item Details Tab Notifications The Notifications Tab contains a list of the users who will be notified via email when the item is updated By default the creator is automatically added to the notification list of the item To remove yourself from the notification list click the Remove Me button To add yourself to the notification list click the Add Me button The Notification tab also allows you to add additional users to the list by selecting them from a drop down list and clicking Add Notification Item Relationships Sub Parent and Related The Item Relationship tabs provide the ability to create relationships between items for future reference and easier navigation To relate the item your working on with another item type the item id of the sub item and click the appropr
24. he current users User ID and then executed Resulting in Select From Users Where UserlD 584 The following 2 Commands are not control specific They are used for additional form functionality You can use these commands on a control that is not using the 20 Script field or assign it to a hidden Label control 2 Commands e COM_SETNAME Changes the text displayed on the Save button in H20 Ex COM_SETNAME Register e COM_GRANTROLE Will assign the user completing the form to a specific DNN Role once they complete the form Ex COM_GRANTROLE SigmaPlusSource e COM_REDIRECTBYROLE Will redirect the user to a specified URL if they belong to a specific Role The first parameter after the command is the name of the role followed by a gt character and then the URL to redirect them to Ex COM_REDIRECTBYROLE Administrators gt http www OnyakTech c om e COM_REDIRECTBYAFFILIATEID Will redirect the user toa specified URL based on their affiliate id in their DNN User Profile The first parameter after the command 15 the affiliate 10 followed by a gt character and then the URL to redirect them to Ex COM_REDIRECTBYAFFILIATEI D 1525 gt http www OnyakTech co m COM_REDIRECTBYREGI ON Will redirect the user to a specified URL based on their region in their DNN User Profile The first parameter after the command is the region followed by a gt character and then the URL to redirect th
25. he control in the Row and Column location of the form The Position is used when you have more then one control in the same row and column of your form For example if you want a label control and a text box control to exist in the same row and column of your form you would set the label control position 1 and the text box control position to 2 This is just an example it s better to place your labels in the first column and your data input controls in the second column for better looking form Enabled This sets the visibility of the control on your form Its primary purpose is to be used with functional controls such as a label control you added to the form for the primary purpose of executing 2 Script Field Name When connecting to an existing table enter field name you want this control to be connected to in your table Control Color This sets the control color displayed on your form CSS Class This sets the CSS Class for your control Tool Tip Enter text here to display information about the field to your users 2 Script Enter 20 functions SQL statements in this property See the section on 20 Scripting for more details Validation Enter REGEX formulas in this property to validate user input for this control Required Checking this property will force the user to enter a value for this control DNN Role If you select DNN Role the control will only be editable by users that belong to the roles you
26. iate add item button button differs depending on the relation tab you are currently using When you add Sub Item to item the system will automatically display the correct relation when viewing the other item For example if you add item 44 to the Sub Item tab of Item 13 Item 44 will display Item 13 in the Parent Item tab Related Item display on the same tab Related Items for all items associated 16 Related Files Files uploaded to items are stored directly into the database You can upload as many files as you want but the size of the file may be restricted by your web server s configuration If you need to upload larger files add the following to your web config and increase the maxRequestLength as needed lt allow large file uploads gt lt httpRuntime useFullyQualifiedRedirectUrl true maxRequestLength 8192 gt The default value for maxRequestLength is 4096 This value is set low to prevent the Denial Of Service attack Automated Data Collection and Processing of Items Behind the scenes Items automatically collect specific information during processing Some of this information is displayed at the item header Date Created Displays the Day and Time originally created Attached Files The attached files indicator at the item header is provided to quickly let users know that the item has downloadable files attached to it This will prevent the mistake of assuming the item does not contain any fi
27. le After Payment settings If you check this option users will be added to the DNN Role you specify if the transaction is Pending or Completed Otherwise the user will only be added to the role if the payment is completed 3 Check the Sand Box Mode option to test your form using PayPal s SandBox testing server 18 4 Enter a name for the purchase in the Item Name field 5 Enter the amount of the purchase in the Amount field If you want to allow your users to purchase more then one of the item add a field to your form and name it Quantity 2 will automatically calculate the price based on the quantity entered by the user 6 Enter your PayPal email address in the PayPal 10 field 7 Leave the Portal ID field as is unless you want transactions to appear in a different DotNetNuke Portal 8 To add users to a DNN Role after payment is complete check the Enabled option for Add User To Role after Payment and then select a role from the list provided 9 Click Update Customize the Results View 20 contains a default results view that you can over ride for each project To change the result view open the project details for the project you want to change the displayed results for and type in your template into the field View HTML This field can contain any valid HTML To indicate where field values should go just type the name of the field into your template For a link to open the item use the text Pr
28. les or having to check the Related Files tab for each item Email Templates 2 contains three sets of Email Templates that are used when sending email notifications on new updated items and new comments 1 20 Default These are used when Email Templates have not bee configured 2 2 Module Default These are in the Templates section of the Edit 2 module menu option These override the 2 Default values and are used when templates for a project have not bee setup 3 20 Project These are visible 20 Project Details In the Email Templates you can specify field tags These tags are parsed when an email is sent out and allows you to insert dynamic content Tags are entered with brackets around the tag name For field values from an 2 Form use CST FIELDNAMEHERE For example if a field in your form is named Category then your tag should look like 5 Category H20 Email Tags 1 URL Inserts web address directly to the item on your site 2 PROJECTNAME Inserts the project name the form was created under 3 For form field values use CST FlELDNAMEHERE 17 Setting Up Your own User Registration Module When creating your own User Registration module it s highly recommended to create and test the 20 form on a development server Directly altering DotNetNuke tables may render your portal useless if not properly setup Some things to consider e At minimum you should create
29. m undefined objects you should register all objects and variables in a Startup Script Control Properties Name This is the name of your control If must be unique in your form and must not contain spaces If you have created the form from an existing table the value of this property will be the field name Type This is the control type Height This is the height of the control Width The width of the control Mode Mode is specific to select controls For this release it s only applied to the Text Box control and controls if the text box is single or multiline Row This is the row position of the control in your form to render where the control will be displayed to the user Column This is the column position of the control in your form to render where the control will be displayed to the user Default Value This sets the default value for the control Note that you can use the Auto Fill Tags to dynamically fill the value When using the Auto Fill tags for the Default Value do not include the UserReg text of the tag When setting the default value for the checkbox control use either true or false Text This property sets the text displayed to the user for the control For example when configuring a Label control the value you enter here is what the user will see on the screen The Name property may be IbIPhone and the Text property would be Phone Number Position This is the position of t
30. n on new minor releases Members Forum and an area to request new features Installing 2 Note that there are different file types with OnyakTech DNN products Private Assemblies are DNN Module Installation files that are packaged as zip files PA files are uploaded to DNN as a whole into the Module Definitions page under the Host menu These files contain the characters PA in the name Example H20 v1 1 7 PA zip e SOURCE Source Code files are packaged in zip files and contain all source code for the module named These files contain the characters SOURCE Example 20 v1 1 7 SOURCE zip e INSTALL OnyakTech produces several Windows applications that connect directly to your DNN portal to process data These files contains the characters INSTALL and should be extracted to your PC for installation into Windows Example SigmaEx v3 1 INSTALL zip To install 2 into your DNN Portal 1 Log in to your portal as Host 2 Select Module Definitions from the Host menu 3 At the top of the module under the text Module Definitions is a down arrow Click on the arrow to pull up the module menu and click on Upload New Module 4 Click Browse and find the PA you want to install After you have selected all of the modules you want to upload click on Upload New File 2 Basics Basically put 2 allows you to create custom forms in DotNetNuke But it does much more than th
31. ojectToolld Here is sample taken from the 2 Classifieds Projects available from OnyakTech com Field Names are Bold lt table border 0 width 100 cellspacing 1 cellpadding 0 id tablel gt lt tr gt lt td rowspan 2 width 73 valign top gt lt font S ZE 2 gt ProjectToolld lt font gt lt td gt rowspan 2 width 161 gt lt font face Verdana size 2 gt _ lt img border 0 src ImageURL width 161 height 125 gt lt font gt lt td gt lt td gt lt font face Verdana size 2 gt lt b gt Title lt b gt lt font gt lt td gt lt tr gt lt tr gt lt td height 91 valign top gt lt font face Verdana size 2 gt Description lt font gt lt td gt lt tr gt lt table gt Filtering and Sorting the Results View To set the filter and sort settings for a specific module open the Project Details in the module you want to apply the filter sort to and enter your setting into the text boxes provided Filter and Sort Rules are the same as the standard Net View object rules For example to filter by the 19 column UserlD you would Userld gt 1 Note that if you did not use standard naming conventions then you may need to include brackets for example poor field name 50 FAQ Question want to create a Form for a common user and a page with data grid for displaying that data have already created a form to catch data from users and it is working But
32. on is used with Quick Entry and prevents the user from creating more then one form entry If they return to 2 at a later date they will be displayed the original form the first completed Show Current Project Phase In the Project Details screen you can setup phases to display the status of form collections This is just informational to the end user to display specific stages Production Closed Online etc Show Project Forms you added forms to a project in the Project Details screen to the Project Level the user will see the completed forms and be able to create new forms which are displayed at the bottom of the projects entered items list Potential uses for this are Project Charters Data Collection Methods etc Lock Forms After Submit Prevents users from changing the information entered into a form after they have saved it Email Templates The Templates allow you to edit the display of emails sent when new forms are completed and updated as well as when a comment is added to an existing item The Navigation URL is used when using the URL tag This is added to the email to give your users a direct link to the item in the portal Note that they will need to be logged in If they are not logged in they will be 15 asked to log in to the site and then they will be taken to the item If you have specified a Home page in the Site Settings then DNN will override this action and they will be taken to the specified Home pa
33. select Access Key Attribute Key and Attribute Value fields The Access Key is a keyboard shortcut to the control For example if you enter the letter A you can navigate to the control by pressing AIt A on your keyboard The Attribute Key and Attribute Value are used together to add client side script to the form For example in the Form Delete button of 20 the following Attribute set is added to the Delete button on the server before it s sent to the client btnDelete Attributes Add onclick return confirm Are you sure you want to delete this The onclick is the attribute and return confirm Are you sure you want to delete this is the Attribute value 10 H20 Scripting The 20 Scripting field is used for several purposes In this field you will enter SQL Statements Java VB Script and H2O Commands Note that 20 Commands and H20 Tags are completely different H20 Command is used by itself with parameters following it For example if you entered the following into the 2 Script field for any control COM_SETNAME Register when your form is rendered the Save button will have its displayed text changed to Register H2O Tag is used SQL Statements and Java VB Scripts in the 20 Script field to inform 2 that it should replace that 2 Tag with a dynamic value For example the following SQL Statement Select From Users Where UserID USR_USERID will be changed to match t
34. the Create New Form link 3 Enter a Form Name 4 Enter your name into the Form Author field 5 Enter a description for your form 6 Specify the number of Rows and Columns your form will contain into the Rows and Columns fields When you start adding controls to your form you will need to specify the location of the control on your form 2 uses a grid for control placement If you are not sure the number of rows or columns you will need it is best to start off with 10 rows and 2 columns You can always update these fields later if you need more rows or columns 7 Click Update Form Info Adding Controls to your Form Current available control types for use in H2O Forms are Check Box Text Box Label HTML Password List DNN User List Calendar External List Data Grid File Upload Register Body Startup Script Register Body Script Radio Button List SQL and Radio Button List All 20 controls require name row and column Additional requirements and options appear when you select some control types Enter name for your control This name not contain spaces these will be removed if you use them Enter the row location into the Row field Enter the column location into the Column field If you want your control to be enabled make sure the Enabled checkbox is checked If you are using a label control or any other control that should contain displayed text enter the text to be displayed into the Text
35. x e Tabs Item Tabs are located at the bottom of form entries These can be used solely for administration purposes or by both administrators and end users for collaboration These tabs contain comments files related items etc o Display Comments and Files Only This displays just the comments and files to the end users If administration needs to view history and other tabs it s recommended to add 2 to another page secured to administrators only and leave the default out of the box configuration 14 Show Team Only Limits display of the form tabs to the Team only Images Hides all 2 logos Note that you can replace the 2 logos with your own logos by editing or replacing the images in the Desktop Modules folder of DNN Item Label This is the name of which you want your Forms to be referenced as The default is Form For example use this option allows you to setup one instance of 2 to display forms as Requests and another instance to show forms as Survey User Interaction Settings Project To Display Setting this option will restrict 20 to display a specific Project ONLY You must also check the option Limit Project List Enable Quick Entry This displays just the form of the selected project Redirect URL This URL is used when using Quick Entry After user completes a form they are redirected to this URL Allow Only 1 Form Per User This opti
Download Pdf Manuals
Related Search