There is one complaint, though, regarding a custom module. It is supposed to post back to itself but ends up posting to Home.aspx. Let's call the custom module editMessage.ascx. Let's call the page that uses that module editMessage.aspx. The module has a submit button that runs at the server. The OnClick in the ascx is set to btnSave_Click and that method exists in the code behind. Yet, when I navigate to that editMessage.aspx page, fill out the form, and click the button, the POST sends me to the /home.aspx page.

Please ask questions for more info.

You can add script to pages using the Script module and configure the script to be loaded in the head, at the bottom of the page, or in place.

You can also add script site-wide using the "Custom Content" feature in Site Settings. There is an area for regular pages and admin pages.

Thanks, 
Joe

I have been exploring ways to modernize some of my mojoPortal pages by integrating JavaScript libraries like Chart.js and ApexCharts to create dynamic dashboards.  The challenge I am facing is figuring out the cleanest way to inject these scripts into specific mojoPortal pages especially while keeping the solution upgrade-friendly and not interfering with the core code or layout system. Has anyone implemented something similar?

I’m currently using HTML content modules with script blocks;  but I’ve run into issues with script ordering, loading conflicts & scoped CSS getting overwritten. I’d like to know if there’s a standard or recommended approach within mojoPortal for handling client-side libraries whether via skin-level JS injection, custom modules, or using the script loader system. Bonus if anyone has insight into managing multiple charts or updating them with AJAX calls. Checked https://www.chartjs.org/docs/latest/getting-started/Salesforce Developer Training guide related to this and found it quite informative.

If there’s a guide, doc, or example project showing how to cleanly inject and manage third-party JS frameworks in mojoPortal without breaking maintainability, I’d appreciate the pointer.

Thank you !

We pull fresh from the repo and build successfully quite a bit without issue.

Be sure you have .net framework 4.8.1 installed and that you're able to connect to nuget.

If you can post your errors here, we can help further.

Thanks,
Joe

I'm facing an issue when trying to debug the mojoPortal source code in Visual Studio 2022. After downloading the source code from the repository & setting up the project; I am encountering errors related to missing references & assembly compatibility. I've already tried cleaning and rebuilding the solution; but the problem persists.

Has anyone else run into compatibility issues with Visual Studio 2022; and are there specific steps I need to follow to get the project running smoothly in this version of Visual Studio? I have checked https://www.mojoportal.com/Forums/Thread.aspx?pageid=5&t=9932~-1-splunk documentation guide but still need help. 

Any advice on resolving the missing references or dealing with assembly compatibility issues would be appreciated.

Thanks in advance for your help!

You need to secure your filesystem properly. The latest version of mojo does provide some relief from this issue but the problem really is with how your file system permissions are configured. See this documentation for more information: Securing the File System - mojoPortal

Thank you,
Joe

Second, there aren't any services in mojoPortal which write files or allow files to be written to the root directory. You should make sure that the files are actually malicious and that you don't have something or someone else writing those files to your file system.

Thank you,
Joe

How is your conversion working out?

It's great that this worked so well for you. I might give it a go on a few sites we manage that have long lost their requirement for using mysql.

Thanks,
Joe

<%@ Control Language="C#" AutoEventWireup="true" Inherits="SuperFlexiUI.FeaturedImageSetting" %>

<script type="text/c#" runat="server">
    protected void Page_Load(object sender, EventArgs e)
        {    
        browse.Text = "Browse";
        browse.TextBoxClientId = imageUrl.ClientID;     
       }  
</script>

<asp:TextBox ID="imageUrl" CssClass="forminput" runat="server" style="width:260px" />
<portal:FileBrowserTextBoxExtender ID="browse" BrowserType="file" runat="server" CssClass="btn btn-link"/>

Has anyone put something together that would easily work for this without a lot of messing around? I know I need to use the isettingcontrol type. I copied something from superflexi that sorta works, but it isn't putting the selected page into my field. Plus it's tapping into superflexi which isn't ideal, I'd rather this be more self-contained and not hacked together.

I've often thought about putting a checkbox on the page edit to allow the editor to disable the 301 redirect creation. I've also considered a toggle for an admin to temporarily disable 301 redirects. Both just haven't made it past thoughts. We'll add it to the to-do list though.

There are some things you can do while you're building sites to make this a bit easier.

Add <add key="DisableCacheFor301Redirects" value="true" /> to the user.config. This will prevent the 301s from being cached. Once you're ready to launch the site, you can disable this and clear the 301 redirects that have been created by running the following script against your DB (mssql, other versions would be similar). 

DELETE FROM mp_RedirectList WHERE SiteID = 1;

You could remove the WHERE SiteID = 1 if you don't have other sites on the same install.

You can also remove 301 redirects individually by going to Administration > Advanced Settings > 301 Redirect Manager. 

Thanks,
Joe

Currently, when you change a page name an automatic 301 redirect is created. I see how that could be useful in some cases but I wonder if it should be the default or if it should be an optional check when renaming? My opinion is that it should be optional for these reasons.

1) When building a site sometimes for SEO reasons page URLs are changed during the build process. This creates 301s that don't serve a purpose.

2) Typos happen. Again, creates 301s without benefit.

3) Sometimes I structure page URLs and then have to change them at some point to move a section and restructure URLs. Lots of 301s I don't need.

4) With search engines reindexing so often on many sites I wouldn't always want or need a 301.

I feel like all these 301s may not be needed. They also take up page URLs that you might want to use in the future and then can't use because there's a 301 out there which can cause issues and confusion for users.

I wonder if when renaming a page there's a little checkbox that asks if you'd like a redirect created? I'd default it to unchecked.

Or possibly even a user.config setting to turn off 301 auto-creation altogether. I'd probably choose this and just create 301s manually when I have that need.

Wordy post, worth a discussion I hope.

You're absolutely right. I've looked at that thing for like 10 years and thought it should go away but then I forget about it.

We'll get rid of it.

Thanks,
Joe

Here is the outline of the process as I did it:

1. Coded a new SQL Server data layer project for my custom features, including converting from MySQL inline SQL to stored procedures.
2. Built solution with SQL Server (e.g. "Release" configuration).
3. Created an empty SQL Server database, and updated user.config to point to it.
4. Ran setup to build out the empty database tables and stored procedures
5. Used Microsoft SQL Server Migration Assistant for MySQL to convert the production MySQL database into a separate schema in the empty database (e.g. mojoportal versus dbo)
   1. This step was needed because SSMA can't directly convert the GUIDs stored as strings in MySQL to the UNIQUEIDENTIFIER data type in SQL Server.
6. Built insert...select statements to convert every table from the mojoportal schema to the equivalent dbo schema, using CAST for UNIQUIDENTIFIER fields. e.g. CAST ([SiteGuid] AS UNIQUEIDENTIFIER)
7. Ran the conversion script to populate the dbo tables.
8. Lots of testing and fixing of my custom features, but mojoPortal itself worked flawlessly!

Currently it's running in our test environment and hopefully being pounded on by our web technician and content admins. Assuming testing is successful, I'm hoping to do the production conversion within the next two weeks.

Joe, for what it's worth, I think the only discrepancy I found between the two databases was there was a single field on one table that was named differently (single in MySQL, but an S on the end in SQL Server). I should have made a note for you, but it was such a small thing I just fixed it in my table copy script and moved on.

If anyone is interested in doing this, I'd be happy to answer questions or provide the more detailed steps I followed.

Thanks,

Mike

The best way to see how to setup an editor is to look at existing code.

Many features use ckeditor. The HTML module uses it and you can see the code here (line 14) and here (lines 86, 182, 279, 624).

Thanks,
Joe

However, I have been struggling with how to add an Html Editor to one on my controls.

Is there an existing example in this forum about implementing an editor in custom control?

Please point me to that example.

LJ

I made a few sites with MojoPortal a long time ago, I had to move all the sites now to a new server 2012 -> 2019.
Asp.net version is 4.8 - All of them has a machine key in the web.config but paswords are not encrypted in the database

Some of the sites are working completely but 3 of them are working but I have a issue when we try to logon, i get:

Validation of viewstate MAC failed. If this application is hosted by a Web Farm or cluster, ensure that configuration specifies the same validationKey and validation algorithm. AutoGenerate cannot be used in a cluster.
 

Did alot of searching but can't find why one site is working and the other not...

:(

Thanks for any tips!

i think it MUST be an update. otherwise those who already have a site with a lot of material and content would be forced to lose years and years of content. that it is an update is required.

thanks Joe

We are still developing mojoPortal and are working on a release right now. We tend to go a while without releasing anything but we are always improving mojo in many different ways.

As for an MVC version, the original developer of mojoPortal did decide to start a new project and originally he was planning on making some kind of an upgrade path to it from mojoPortal. His new project was acquired a while back by another company and he never built any kind of migration path. The new project is less of a content management system and more of a collection of separate packages that do different things and one could build a CMS with them. It's good stuff for sure but it doesn't really replace mojoPortal in a lot of ways.

We are in the early stages of planning and have done some development on a new CMS based on MVC and .NET Core that will be an upgrade from mojoPortal. We don't have a lot of information that we're willing to share publicly on it yet though. It will definitely be Open Source.

Thanks,
Joe

I read on anther forum post about successor to mojoPortal based on .NET Core MVC, which are in your plan. I used mojoPortal for more than 10 years, and still I like it, but because there are many new frontend and backend changes on dotnet products, and while dotnet core is very attractive, I'm thinking about finding another CMS developed for dotnet Core, 

When I read that you have a plan to develop a new CMS similar to mojoPortal but with new technology, it very good news for me. but I want to know more about this plan and when you think a public update will be published? is that also be opensource ?

Is there any more details, you can share with us?

Thanks

Yes this is possible, you can even create dynamic categories using the DynamicCheckBoxList field type, so that as users create items they can add new categories which will automatically populate on the page. You can put data-category="$myCheckboxToken$" on each of your items so you can see which category they relate to. Then you want to tie in some JavaScript to watch for clicks on the tabs, show the related items, and hide the unrelated items.

Hope this helps.

We've never actually run into any problems with this. The role provider doesn't use sessions, just cookies. We'll take a look at it though and see if we can make some adjustments. Before we do that though, we'll do some use case testing to see how many roles we can add a user to before things go haywire. 

Thanks,
Joe

from here: https://www.mojoportal.com/docs/roles-permissions

"You can create as many roles as you'd like, but each user should be in no more than a handful of roles. A user's roles are stored in an encrypted browser cookie, and a cookie can only hold so much data. So if a user is a member of too many roles it can overflow the capacity of the cookie."

In my case, there will be many roles for every user.

Is there an easy way to change the storage from the browser to let say Session?

Thank you.

That appears to be a custom feature developed for mojoPortal. Usually, with mojoPortal, features are added to pages (virtual mojoPortal pages) and the feature handles all of it's own rendering. Try this to figure out what feature is rendering this form:

1. Login to the site
2. Go to the page with the form
3. You should see a "settings" link somewhere close to the top of this form
4. A settings page will open, with a tabbed view of settings. The first tab will be something like "Acme Form Settings", where "Acme Form" is the name of the feature. Take note of this.
5. Go to the administration menu, should an "Administration" link somewhere on the page.
6. From the Administration Menu, select Advanced Tools and then Feature Installation and Configuration
7. Scroll through the list of features until you find the feature name you noted in step 4 above. Click the gear icon to the left of feature's name.
8. The path and name of the file that controls the form in question will be in the "Control Source" field. Take note of this.
9. Use the path and file name from step 8 to locate the file on the server. 

These steps will get you to the entry point for the feature. If the code for the feature has been compiled, you will need to locate source code before you can make any substantial changes.

I hope this helps,
Joe

http://servicepallet.alligatortek.com/contact-us.aspx

Is it rendered from some tables in DB or a particular Page. I was not able to find the contact-us.aspx in the code as it uses URL rewriting. We need to implement Invisible Captcha for this page. Please guide us through the process.

For accordion Change to:
--------------------------------------------
<div class="collapsed-accordion">

Put below accordion code:
--------------------------------------------
<script type="text/javascript">// <![CDATA[
 $('div.collapsed-accordion').accordion({active:false, collapsible:true, autoHeight:false, fx:{opacity:'toggle',duration:'fast'}});
 // ]]></script>

For tabs
---------------------------------------------------------------------------
<script type="text/javascript">
// MAKES TABS COLLAPSE ON DEFAULT
// <![CDATA[
    $('.tabs').tabs({collapsible: true, active: false });
// ]]>
</script>

Beginning with mojoPortal 2.3.5.5, if you want to make the same sort of change skin-wide, you can do so by modifying ScriptLoader in the Layout.Master file for your skin, and adding JQueryAccordionConfig=[parameters]. To continue the example of a closed accordion widget, the final ScriptLoader line would look something like this:

<portal:ScriptLoader ID="ScriptLoader1" runat="server" IncludeSizzle="true" JQueryAccordionConfig="{active:false, collapsible:true, autoHeight:false, fx:{opacity:'toggle',duration:'fast'}}" />

It would be nice to prevent any reformatting of HTML.

Some of this can be done via CSS and giving the solution a custom class. It would be better to allow end users to make some of these choices or even on the developer end so custom classes are not necessary. It would save a lot of time and give tons more flexibility since not everything can be solved with CSS.

I didn't see any examples with these types of options or anything in the documentation but thought it was worth asking. Thanks!

I created a user control and added it to the feature installation & configurations section.  Adding the user control to a page works, and I can see asp controls like a button and text box.  When I add a Telerik control to the user control, I get this error:

2020-03-23 12:39:23,642 ERROR 127.0.0.1 - en-US - /telerik-test - mojoPortal.Web.UI.CmsPage - failed to load control controls/mycontrols/usercontroltest.ascx 
System.Web.HttpCompileException (0x80004005): C:\inetpub\mysite\controls\mycontrols\usercontroltest.ascx(35): error BC30002: Type 'Telerik.Web.UI.RadButton' is not defined.
   at System.Web.Compilation.BuildManager.CompileWebFile(VirtualPath virtualPath)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultInternal(VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.Compilation.BuildManager.GetVPathBuildResultWithNoAssert(HttpContext context, VirtualPath virtualPath, Boolean noBuild, Boolean allowCrossApp, Boolean allowBuildInPrecompile, Boolean throwIfNotFound, Boolean ensureIsUpToDate)
   at System.Web.UI.TemplateControl.LoadControl(VirtualPath virtualPath)
   at mojoPortal.Web.UI.CmsPage.LoadPage()

Why would a RadButton work in the layout.master but not a user control?

Also, I tried replacing asp:ScriptManager with telerik:RadScriptManager.  Everything seems to work except that the administration panel on the left side of the page won't open.  

I'm using the deployment files, not the source code.

Thanks for any help!!!

mojoPortal currently targets 4.6.2 but we've got it running on 4.7.2 hosting without any issues.

Thanks,
Joe

The best workaround in this situation is to add a comment to between the opening and closing spans:

<span class="glyphicon glyphicon-search"><!-- do not delete me --></span>

I hope this helps you,

Joe

<span class="glyphicon glyphicon-search"></span>

I'm using a custom ckeditor.js file that contains config.allowedContent = true; .  I believe this setting allows any content?

If I add text inside the span tag, it works:

<span class="glyphicon glyphicon-search">Search</span>

Any suggestions what could be causing this or how to work around it?

Thanks!

Thanks

Tim

I want to know is it possible to create a selective list like https://templatemo.com/live/templatemo_539_simple_house by superflexi feature?

I have installed a Webstore in a Mojoportal Site and integrated Paypal Express Checkout . I see the Paypal Button on the cart page. Om click I see that the call to PayPal site is launched, but I do not see the Paypal Checkout Form, and the focus does not move from the cart page. Do you have any suggestion on what I have to do to have it working?

I would also like to accept credit cards via Stripe. May be someone else is already working on that? If so we can work together.

Ciao

Mari

Has anyone integrated a SAML login for Mojoportal ?

The following Github consumer would be enough, its just the best way to integrate into Mojo ?

https://github.com/jitbit/AspNetSaml

How SAML works?

SAML workflow has 2 steps:

User is redirected to the SAML provider (where he authenticates)

User is redirected back to your app, where you validate the payload

Here's how you do it (this example is for ASP.NET MVC:

1. Redirecting the user to the saml provider:

//this example is an ASP.NET MVC action method

public ActionResult Login()
{
            //TODO: specify the SAML provider url here, aka "Endpoint"

            var samlEndpoint = "http://saml-provider-that-we-use.com/login/";

            var request = new AuthRequest(

                        "http://www.myapp.com", //TODO: put your app's "unique ID" here

                        "http://www.myapp.com/SamlConsume" //TODO: put Assertion Consumer URL (where the provider should redirect users after authenticating)

                        );

            //generate the provider URL

            string url = request.GetRedirectUrl(samlEndpoint);

            //then redirect your user to the above "url" var

            //for example, like this:

            Response.Redirect(url);

}

2. User has been redirected back

User is sent back to your app - you need to validate the SAML response ("assertion") that you recieved via POST.

Here's an example of how you do it in ASP.NET MVC

//ASP.NET MVC action method... But you can easily modify the code for Web-forms etc.

public ActionResult SamlConsume()

{

            // 1. TODO: specify the certificate that your SAML provider gave you

            string samlCertificate = @"-----BEGIN CERTIFICATE-----

BLAHBLAHBLAHBLAHBLAHBLAHBLAHBLAHBLAHBLAHBLAHBLAH123543==

-----END CERTIFICATE-----";

            // 2. Let's read the data - SAML providers usually POST it into the "SAMLResponse" var

            Saml.Response samlResponse = new Response(samlCertificate, Request.Form["SAMLResponse"]);

            // 3. We're done!

            if (samlResponse.IsValid())

            {

                        //WOOHOO!!! user is logged in

                        //Some more optional stuff for you

                        //let's extract username/firstname etc

                        string username, email, firstname, lastname;

                        try

                        {

                                    username = samlResponse.GetNameID();

                                    email = samlResponse.GetEmail();

                                    firstname = samlResponse.GetFirstName();

                                    lastname = samlResponse.GetLastName();

                        }

                        catch(Exception ex)

                        {

                                    //insert error handling code

                                    //no, really, please do

                                    return null;

                        }

                        //user has been authenticated, put your code here, like set a cookie or something...

                        //or call FormsAuthentication.SetAuthCookie() or something

            }

}

Dependencies

Project should reference System.Security

(NEW!) Nuget

I've published this to Nuget.

Install-Package AspNetSaml

Thanks,
Joe

I am currently trying to develop contact form on mojo portal and is facing issues with linking .PHP mailer file to the website.

I am having a problem receiving the submitted form.

When using Iframe with the exact code, I am able to recieve the submitted forms. So my feeling is I am not able to link to .PHP mailer file when i link it on the html coding.

Can you help me?

Below is the code I am using:

<center>Contact Us</center>

<p>&nbsp;</p>

<center>Please specify your preferred mode of contact and we will respond as quickly as possible!</center>
&nbsp;

<form action="/Data/Sites/1/media/formS2/contact-3.php" id="contactForm" method="post" role="form">
<div class="messages">&nbsp;</div>

<div class="controls">
<div class="row">
<div class="col-md-2">
<div class="form-group"><select aria-invalid="false" aria-required="true" id="form_titles" name="title" style="width:150px; border :0; outline:0; background: transparent; border-bottom: 0;"><option selected="selected" value="Mr">Mr</option><option selected="selected" value="Mrs">Mrs</option><option selected="selected" value="Ms">Ms</option><option selected="selected" value="Title">*Title</option> </select></div>
</div>

<div class="col-md-4">
<div class="form-group"><input data-error="Firstname is required." id="form_name" name="name" placeholder="Enter your firstname *" required="required" style="width:300px;" type="text" />
<div class="help-block with-errors">&nbsp;</div>
</div>
</div>

<div class="col-md-5">
<div class="form-group"><input data-error="Lastname is required." id="form_lastname" name="surname" placeholder="Enter your lastname *" required="required" style="width:300px;" type="text" />
<div class="help-block with-errors">&nbsp;</div>
</div>
</div>
</div>
&nbsp;

<div class="row">
<div class="col-md-6">
<div class="form-group"><input data-error="Valid email is required." id="form_email" name="email" placeholder="Please enter your email *" required="required" style="width:460px;" type="email" />
<div class="help-block with-errors">&nbsp;</div>
</div>
</div>

<div class="col-md-5">
<div class="form-group"><input id="form_phone" name="phone" placeholder="Please enter your phone" style="width:300px;" type="tel" />
<div class="help-block with-errors">&nbsp;</div>
</div>
</div>
</div>
&nbsp;

<div class="row">
<div class="col-md-12">
<div class="form-group"><textarea id="form_message" name="message" placeholder="Message for me *" style="width:85%; height:100px; border:1px solid #fff;"></textarea>

<div class="help-block with-errors">&nbsp;</div>
</div>
</div>

<div class="col-md-12"><input id="agree" name="Terms and Conditions" type="checkbox" value="terms" /> *I have read and accepted the <span><a href="https://www.sweecheong.com.my/terms-and-conditions">terms and conditions and privacy policy.</a></span><br />
<input name="Marketing Information" type="checkbox" value="marketing" /> I accept receiving marketing information about Rolex from Swee Cheong Watch Sdn Bhd.
<p class="text-muted"><strong>*</strong> These fields are required.</p>
</div>

<div class="col-md-12">
<center><input class="btn btn-success btn-send" onclick="if(document.getElementById('agree').checked) { return true; } else { alert('Please indicate that you have read and agree to the Terms and Conditions and Privacy Policy'); return false; }" type="submit" value="Send message" /></center>
</div>
</div>
</div>
</form>
</div>
<!-- /.8 --></div>
<!-- /.row--></div>
<!-- /.container--><script src="https://code.jquery.com/jquery-1.12.0.min.js"></script><script src="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/js/bootstrap.min.js"></script><script src="https://cdnjs.cloudflare.com/ajax/libs/1000hz-bootstrap-validator/0.11.9/validator.min.js" integrity="sha256-dHf/YjH1A4tewEsKUSmNnV05DDbfGN3g7NMq86xgGh8=" crossorigin="anonymous"></script><script src="https://www.mojoportal.com/Data/Sites/1/media/formS2/contact-3.js"></script>

So it was as simple as that, just fill up the fields in the mp_Users and mp_UserRoles tables. I was able to batch-insert 2693 user accounts in one click this way. I apologize for any confusion this may have caused.

Thanks for your note. SuperFlexi is definitely a huge help to us when developing sites.

All the best,
Joe

The easiest way to get started is to copy and existing solution and build off of the examples. You do NOT need to be a developer to build these solutions.Give it a try. MojoPortal doesn't have a ton of modules but with SuperFlexi you can build what you want.

I recently added an instance of the Better Image Gallery to a website page in order to try it out. Really liking it but ran into a problem and wondering if anyone knows the fix or things to look at, etc.

It works just fine while I'm logged into the website and all of the pictures show up as they should. If I'm logged out however, it shows this message:

Selected gallery folder was not found.

Just in case it had to do with the subfolder, I tried removing the special subfolder from the folder settings so it would use the main BetterImageGallery folder, then I put all of the pictures into that folder. The pictures then showed up fine if I was logged in but when I'm not logged in, no pictures.

Any ideas?

Thanks!

What version of mojoPortal are you running? The latest version of Form Wizard requires mojoPortal 2.7.

Thanks,
Joe

Is another option...?

Fire the command then have a "Consumer" to work with the reply from SAML/Azure.

What is the best place / method to add a new Custom Authenticator to Mojo ?

I'm looking at adding Office365 / Azure AD login support using the Open Source Saml 2.0 library:

https://github.com/Sustainsys/Saml2

Previously I wrote a custom IHttpModule to intercept the page traffic, I'm assuming there is a cleaner way to add custom

authentication ?

I hope to be able to add the ID's from Azure (EndPoints/Return URL) and let SAML 2.0 do the authentication.

Any feedback appreciated.

Regards

Andrew Tierney

Open eletter\Admin.aspx in Visual Studio and remove the portal:NewsletterDisplaySettings control. Should be on line 5.

I've made this change and pushed it to repository. Sorry for the trouble.

Thanks,
Joe

i download the latest source code from sourcetree and try to build on visual studio 2017 , i find this error after build : 

Severity    Code    Description    Project    File    Line    Suppression State
Error    CS0234    The type or namespace name 'NewsletterDisplaySettings' does not exist in the namespace 'mojoPortal.Web.UI' (are you missing an assembly reference?)    mojoPortal.Web    C:\Users\sengk\Downloads\mojoportal-master\mojoportal-master\Web\eletter\Admin.aspx.designer.cs    22    Active

How to i solve this issue, so that i can continue building my website using mojoportal ? 

thanks 
 

Does anyone know where all moduleids are defined? 

Thanks in advance

Micha

This is what happens when you get in a hurry.
 

The incoming tabular data stream (TDS) remote procedure call (RPC) protocol stream is incorrect. Table-valued parameter 2 ("@UploadTable"), row 0, column 0: Data type 0xF3 (user-defined table type) has a non-zero length database name specified.  Database name is not allowed with a table-valued parameter, only schema name and type name are valid.

HTML:

<asp:FileUpload runat="server" ID="TimesheetFile" AllowMultiple="false" />
<asp:Button Text="Upload" runat="server" ID="TimesheetFileUpload" OnClick="TimesheetFileUpload_Click" />

C# Code

    protected void TimesheetFileUpload_Click(object sender, EventArgs e)
    {
        if (TimesheetFile.PostedFile.ContentType == "text/plain")
        {
            FaceScanAudit faceScan = new FaceScanAudit();
            faceScan.LoadFile(DateTime.Parse(TimesheetDate.Text), TimesheetFile.PostedFile.InputStream);
            ReloadWithFilters();
        }
        else
        {
            TimesheetFileLabel.Text = "Please make sure you pick a text/plain file.";
        }

    }

Business C#

        public void LoadFile(DateTime date, Stream FileInputStream)
        {
            DataTable FaceScanExport = new DataTable();
            FaceScanExport.Columns.Add(new DataColumn("EmployeeNumber"));
            FaceScanExport.Columns.Add(new DataColumn("EmployeeFirstName"));
            FaceScanExport.Columns.Add(new DataColumn("EmployeeLastName"));
            FaceScanExport.Columns.Add(new DataColumn("DateMonth"));
            FaceScanExport.Columns.Add(new DataColumn("DateDay"));
            FaceScanExport.Columns.Add(new DataColumn("DateYear"));
            FaceScanExport.Columns.Add(new DataColumn("RegularHours"));
            FaceScanExport.Columns.Add(new DataColumn("Overtime1Hours"));
            FaceScanExport.Columns.Add(new DataColumn("VacationHours"));
            FaceScanExport.Columns.Add(new DataColumn("HolidayHours"));
            FaceScanExport.Columns.Add(new DataColumn("OtherHours"));

            StreamReader reader = new StreamReader(FileInputStream);
            List<string> list = new List<string>();

            while (!reader.EndOfStream)
            {
                list.Add(reader.ReadLine());
            }

            string[] lines = list.ToArray();
            string[][] cells = new string[lines.Length][];

            for (int i = 0; i < cells.Length; i++)
                cells[i] = lines[i].Split('\t');

            for (int i = 0; i < cells.Length; i++)
            {
                FaceScanExport.Rows.Add(cells[0], cells[1], cells[2], cells[3], cells[4], cells[5], cells[6], cells[7], cells[8], cells[9], cells[10]);
            }

            DBFaceScanAudit.UploadExport(date, FaceScanExport);

        }

Database C#

        public static void UploadExport(DateTime date, DataTable data)
        {
            SqlParameterHelper sph = new SqlParameterHelper(ConnectionString.GetReadConnectionString(false), "MANCON_SP_EXCEL_FaceScanAudit_TableImport", CommandType.StoredProcedure, 2);
            sph.DefineSqlParameter("@SelectedBatch", SqlDbType.Date, ParameterDirection.Input, date);
            sph.DefineSqlParameter("@UploadTable", SqlDbType.Structured, ParameterDirection.Input, data);
            sph.ExecuteNonQuery();
        }

Stored Procedure

ALTER PROCEDURE [dbo].[MANCON_SP_EXCEL_FaceScanAudit_TableImport]
    @SelectedBatch datetime = null
    ,@UploadTable PayClockTimeSheetTable READONLY
AS
BEGIN

-- - Insert From Table

    INSERT INTO MANCON_PayClockTime
    (EmployeeNumber, EmployeeFirstName, EmployeeLastName, Month, Day, Year, RegularHours, Overtime1Hours, VacationHours, HolidayHours, OtherHours)
    SELECT EmployeeNumber, EmployeeFirstName, EmployeeLastName, DateMonth, DateDay, DateYear, RegularHours, Overtime1Hours, VacationHours, HolidayHours, OtherHours
    FROM  @UploadTable

END

SQL User-Defined Table Type

/****** Object:  UserDefinedTableType [dbo].[PayClockTimeSheetTable]    Script Date: 7/3/2018 3:06:02 PM ******/
CREATE TYPE [dbo].[PayClockTimeSheetTable] AS TABLE(
    [EmployeeNumber] [nvarchar](20) NOT NULL,
    [EmployeeFirstName] [nvarchar](30) NOT NULL,
    [EmployeeLastName] [nvarchar](30) NOT NULL,
    [DateMonth] [int] NOT NULL,
    [DateDay] [int] NOT NULL,
    [DateYear] [int] NOT NULL,
    [RegularHours] [decimal](38, 20) NOT NULL,
    [Overtime1Hours] [decimal](38, 20) NOT NULL,
    [VacationHours] [decimal](38, 20) NOT NULL,
    [HolidayHours] [decimal](38, 20) NOT NULL,
    [OtherHours] [decimal](38, 20) NOT NULL,
    PRIMARY KEY CLUSTERED 
(
    [EmployeeNumber] ASC,
    [DateMonth] ASC,
    [DateDay] ASC,
    [DateYear] ASC
)WITH (IGNORE_DUP_KEY = OFF)
)
GO

I download source of mojoportal-2.4.1.0 and i install sql server express 2008

I config file user.config and web.config as bellow

<add key="MSSQLConnectionString" value="server=thanhnt26-PC\SQLExpress;UID=sa;PWD=123456abc@;database=mojoportal" />

When i build and run VS 2013 it is error at code SqlCommandBuilder.DeriveParameters(discoveryCommand);

and it message An exception of type 'System.InvalidOperationException' occurred in System.Data.dll but was not handled in user code

Additional information: The stored procedure 'mp_SiteHosts_SelectSiteIdByHost' doesn't exist.

I'm new commer use mojoportal. Can you help me

Thank you very much

Thanh

I am trying to import some products from another database into the mojoportal cms database. I managed to do this by putting the createUrl Methods from the save method in to seperate methods which are then called by the original save method. All goes well when doing this. When I try to load the page associated with the URL however I am directed to the following page: https://imgur.com/a/Vz4gJqz . Does anyone know why this is happening?

Regards

Micha

Regards

Micha

I am trying to generate proper URL's for my products. I am trying to do this by using methods found in the AdminProductEdit.cs file. However when calling methods from this file i constantly get the error that sitesettings are null. Does anyone know how to fix this?

Regards

Micha

I can see that the text of the buttons is also automatically generated in another file. But which tool generates this file? Since i don't really want to have a loose string with the text for the button. I want it to be done in the same way as all the other buttons.

Thanks for the help again

Micha

What CAPTCHA solution are you using? Please check in Administration > Site Settings > Security (tab) > Anti-SPAM(tab)

Looking at the comments, they are most assuredly spam. So I came here looking for something to block the spam, and saw there was a setting... I checked mine and it is most assuredly turned on.  Yet, I have 206 spam comments!

Am I missing something?

You would need to edit the WebStore/AdminDashboard.aspx and WebStore/AdminDashboard.aspx.cs code files. Add the button in the .aspx file and the code for what the button needs to do in the .aspx.cs file.

Hope this helps,
Elijah

This happens from time to time with Visual Studio. I suggest deleting the "C:\Users\andre\AppData\Local\Temp\Temporary ASP.NET Files" folder and the bin and obj folders from your project.

I hope this helps.

Thanks,
Elijah

You can see how to create the database scripts here.

Thanks,
Elijah

1. copy my *.dll files to the bin folder
2. copy my ascx files to the Modules folder
3. Create FeatureDefinitions config

But i also need to create some new tables in the database. Is it possible to run the  sql scripts when installing the module?
It seems like I saw such an opportunity but I can not remember where exactly...

PS: sorry for english from google translate
 

Regards
Alex

2018-04-08 12:20:26,669 ERROR 192.168.1.80 - en-GB - /Book-an-Event - mojoPortal.Web.UI.CmsPage - failed to load control bccmodules/BCCBookevent.ascx
System.Web.HttpCompileException (0x80004005): C:\Users\andre\Documents\My Web Sites\mojoPortal-Local 2-6\bccmodules\BCCBookEvent.ascx.vb(8): error BC30175: module 'Idents' and module 'Idents', declared in 'C:\Users\andre\AppData\Local\Temp\Temporary ASP.NET Files\vs\72452f1b\5c4aa6cf\App_Web_ij3xy11i.1.vb', conflict in namespace '<Default>'.

I understand that there is a conflict but unsure where it is and therefore can't correct it. 

Can you give me some pointers as to where to look.

Regards

Andy

mojoPortal does support content workflow for the HTML Content Module. See the Using the Content Workflow System document.

Thank you,
Joe

The only workaround that I see is to designate a non-visible (except to admins and content publishers/admin ) page to be a "preview" page and then using the content sharing capacity to publish content to other visible pages.