254 shaares
Q: How can I import data from Excel into an existing Task List (or other list) for the various column types using the Datasheet View?
A: The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. Let me break it down for you. :)
**** Good example
A: The key points are recognizing the column types and formatting the data appropriately in Excel before the attempting the import. Certain column types are not able to be imported in this way, such as the Multi-line Enhanced Text. Let me break it down for you. :)
**** Good example
Raspberry Pi sprinkler system
I am totally new to DNN development, I made a module using Christoc Modules, and all my logic is in the view.ascx page, I want to add a new view that basically, would be a button that when the user clicks on it the user would be redirected to the view.ascx page, I have looked everywhere to find tutorial or example that is well explained to do this step by step but I didn't find
I want to set up a simple listing of cards (with a heading, a picture, some text, and a link) and when the user clicks on the link of a card, it brings them to a full "details" view that has a friendly URL. Very similar to a news module but considerably simpler.
So I would have https://mywebsite.com/careers and then a listing. When a user clicks on a career, they would be taken to https://mywebsite.com/careers/dairy-farmer
The URL would be the title of the career. On the details page, there would be a lot more content as well, that the content editor could manage.
Is this video still relevant? https://youtu.be/RtmOYvaeJpo
Or is there a newer, simpler way of doing things? Also, is this something I can set up in the Content module as opposed to the App module?
So I would have https://mywebsite.com/careers and then a listing. When a user clicks on a career, they would be taken to https://mywebsite.com/careers/dairy-farmer
The URL would be the title of the career. On the details page, there would be a lot more content as well, that the content editor could manage.
Is this video still relevant? https://youtu.be/RtmOYvaeJpo
Or is there a newer, simpler way of doing things? Also, is this something I can set up in the Content module as opposed to the App module?
As a side note, the file size for the PNG is 62.4KB, while the WebP is 29.8KB (52% smaller) with lossless compression using cwebp with the following command line.
C:\> cwebp -lossless -exact caniuse-WebP-Test.png -o caniuse-WebP-Test.webp
C:\> cwebp -lossless -exact caniuse-WebP-Test.png -o caniuse-WebP-Test.webp
OData (Open Data Protocol) is an ISO/IEC approved, OASIS standard that defines a set of best practices for building and consuming RESTful APIs. OData helps you focus on your business logic while building RESTful APIs without having to worry about the various approaches to define request and response headers, status codes, HTTP methods, URL conventions, media types, payload formats, query options, etc. OData also provides guidance for tracking changes, defining functions/actions for reusable procedures, and sending asynchronous/batch requests.
Extension for Visual Studio Code - OData query language support.
Notes:
Check the DNN Scheduler to see if there are any active jobs that are taking longer than they should. For example, if the Site Crawler scheduler is constantly running then you should check the files in the Portals folders to make sure all of the files located in the Portals folder should actually be there. The crawler is rebuilding the index and if you have a lot of files it could take hours to complete. If the files should be there, disable the crawler scheduler and then run during your slowest time of the day (1:00 AM?). I ran into this problem on a server that had hundreds of thousands of documents in the portals folder. Ended up solving it by running the crawler between 1:00 AM and 5:00 AM for a few days until it indexed all of the files. Once the files are indexed it will only have to index changed and new files; so it should just be a burden the first time it runs.
Another possible cause are exceptions. If your site is throwing a large amount of exceptions it will slow down your site. The handling of the exceptions and then the logging of them (to the DNN EventLog table in the database and the Log4Net files) can be brutal if your site is constantly throwing exceptions. If your site is also running in DEBUG mode the performance hit is multiplied by at least 30 times due to .Net collection all of the additional information about the exception while running in debug mode. That will be brutal to your sites performance.
Check the server logs to see how often IIS is recycling the application pool for your DNN site. If it's occurring often then that is also a sign of a large amount of exceptions being thrown if you are using the default IIS application pool settings. By default, IIS will recycle your application pool if too many exceptions are thrown within a short period of time. If you also have the option set to bring up a new instance of your site and run it side by side before IIS terminates the existing instance while your site is throwing exceptions that can cause a bottleneck and will cripple performance. For this situation, I usually disable IIS from recycling the application pool if too many exceptions are thrown within a short period of time. That may not be the best option for you but if you are on top of the exceptions being thrown on the site then you can disable that and let IIS run instances side by side after an app recycle (this is nice to have when you recycle during active periods so that all existing traffic completes with the old instance and all new traffic is sent to the new instance. Once all traffic is hitting the new instance of your site IIS will terminate the older instance.)
If none of the above help, run SQL Profiler on your database to see if there is any extreme database activities going on. Also check for any db locks.
There are a lot of possible causes that can slow down DNN. The best way to find out what is going on is to run a profiler on the server (RedGate Ants profiler or Telerik (Progress) Just Trace).
Check the DNN Scheduler to see if there are any active jobs that are taking longer than they should. For example, if the Site Crawler scheduler is constantly running then you should check the files in the Portals folders to make sure all of the files located in the Portals folder should actually be there. The crawler is rebuilding the index and if you have a lot of files it could take hours to complete. If the files should be there, disable the crawler scheduler and then run during your slowest time of the day (1:00 AM?). I ran into this problem on a server that had hundreds of thousands of documents in the portals folder. Ended up solving it by running the crawler between 1:00 AM and 5:00 AM for a few days until it indexed all of the files. Once the files are indexed it will only have to index changed and new files; so it should just be a burden the first time it runs.
Another possible cause are exceptions. If your site is throwing a large amount of exceptions it will slow down your site. The handling of the exceptions and then the logging of them (to the DNN EventLog table in the database and the Log4Net files) can be brutal if your site is constantly throwing exceptions. If your site is also running in DEBUG mode the performance hit is multiplied by at least 30 times due to .Net collection all of the additional information about the exception while running in debug mode. That will be brutal to your sites performance.
Check the server logs to see how often IIS is recycling the application pool for your DNN site. If it's occurring often then that is also a sign of a large amount of exceptions being thrown if you are using the default IIS application pool settings. By default, IIS will recycle your application pool if too many exceptions are thrown within a short period of time. If you also have the option set to bring up a new instance of your site and run it side by side before IIS terminates the existing instance while your site is throwing exceptions that can cause a bottleneck and will cripple performance. For this situation, I usually disable IIS from recycling the application pool if too many exceptions are thrown within a short period of time. That may not be the best option for you but if you are on top of the exceptions being thrown on the site then you can disable that and let IIS run instances side by side after an app recycle (this is nice to have when you recycle during active periods so that all existing traffic completes with the old instance and all new traffic is sent to the new instance. Once all traffic is hitting the new instance of your site IIS will terminate the older instance.)
If none of the above help, run SQL Profiler on your database to see if there is any extreme database activities going on. Also check for any db locks.
There are a lot of possible causes that can slow down DNN. The best way to find out what is going on is to run a profiler on the server (RedGate Ants profiler or Telerik (Progress) Just Trace).
When yo get the green squiggly line on unknown elements in Visual Studio, this is the fix.
Notes:
Delete the files from “C:\Documents and Settings[Username]\Application Data\Microsoft\VisualStudio\9.0\ReflectedSchemas” folder (or “…\VisualStudio\8.0\…” if running Visual Studio 2005) in Windows XP. In Windows 7 it is under "C:\Users{User Profile}\AppData\Roaming\Microsoft...etc". Remember also the "VisualStudio" part of the path will be different depending on the version installed.
I closed Visual Studio (always a good idea for changes that will affect the IDE), deleted the files then re-opened the project. The warnings were gone.
I found references to this solution at: http://forums.asp.net/t/1205528.aspx http://blogs.msdn.com/mikhailarkhipov/archive/2005/04/21/410557.aspx
A quick Google search found the solution. FYI, the search term I used in Google was “element is not supported”.
I don't know why this happens but I do know there are some flaky domain profile things happening in the network environment.
Notes:
Delete the files from “C:\Documents and Settings[Username]\Application Data\Microsoft\VisualStudio\9.0\ReflectedSchemas” folder (or “…\VisualStudio\8.0\…” if running Visual Studio 2005) in Windows XP. In Windows 7 it is under "C:\Users{User Profile}\AppData\Roaming\Microsoft...etc". Remember also the "VisualStudio" part of the path will be different depending on the version installed.
I closed Visual Studio (always a good idea for changes that will affect the IDE), deleted the files then re-opened the project. The warnings were gone.
I found references to this solution at: http://forums.asp.net/t/1205528.aspx http://blogs.msdn.com/mikhailarkhipov/archive/2005/04/21/410557.aspx
A quick Google search found the solution. FYI, the search term I used in Google was “element is not supported”.
I don't know why this happens but I do know there are some flaky domain profile things happening in the network environment.
A little while ago I received an email from Deborah asking what formula she can use to list missing numbers from a range.
I’ve seen loads of different approaches to this over the years but today I’m going to share with you the formula I think is the most elegant.
I’ve seen loads of different approaches to this over the years but today I’m going to share with you the formula I think is the most elegant.
If you have the need to highlight cells with duplicate or unique values in Microsoft Excel 2016 or 2013, here’s an easy way to do it.
Creating masks for form fields
jQuery-Mask-Plugin - A jQuery plugin to make field masks
I'm trying to write a regular expression to validate US phone number of format (123)123-1234 or 123-123-1234 as true.
The easiest way to match both this (000)000-0000 is this
^\([0-9]{3}\)[0-9]{3}-[0-9]{4}$
and this 000-000-0000 is this
^[0-9]{3}-[0-9]{3}-[0-9]{4}$
and to use alternation ((...|...)): specify them as two mostly-separate options:
^(\([0-9]{3}\)|[0-9]{3}-)[0-9]{3}-[0-9]{4}$
By the way, when Americans put the area code in parentheses, we actually put a space after that; for example, I'd write (123) 123-1234, not (123)123-1234. So you might want to write:
^(\([0-9]{3}\) |[0-9]{3}-)[0-9]{3}-[0-9]{4}$
(Though it's probably best to explicitly demonstrate the format that you expect phone numbers to be in.)
The easiest way to match both this (000)000-0000 is this
^\([0-9]{3}\)[0-9]{3}-[0-9]{4}$
and this 000-000-0000 is this
^[0-9]{3}-[0-9]{3}-[0-9]{4}$
and to use alternation ((...|...)): specify them as two mostly-separate options:
^(\([0-9]{3}\)|[0-9]{3}-)[0-9]{3}-[0-9]{4}$
By the way, when Americans put the area code in parentheses, we actually put a space after that; for example, I'd write (123) 123-1234, not (123)123-1234. So you might want to write:
^(\([0-9]{3}\) |[0-9]{3}-)[0-9]{3}-[0-9]{4}$
(Though it's probably best to explicitly demonstrate the format that you expect phone numbers to be in.)
How to put a hyperlink in a bootstrap button.
This page is specifically written for users who want to find the iPhone (iTunes) backup location on Windows and Mac. Additionally, we also offer the steps to change the iTunes backup location on Windows. For more details, you can read this post.
5 WAYS to Make TEXTURES on Your Art Canvas | Painted Wall Art DIY: I always like to learn new ways to add texture to my arts 'n' crafts, because that's where you can add dimension and therefore make something much more interesting. This tutorial goes through 5 ways of adding texture with easy-to-find items, from eg…
Any public property can be set in the markup as indicated above. You can get more advanced than this and support child elements, etc. too. See more information: http://asp.net-tutorials.com/user-controls/using/
Creating and using a UserControl in ASP.NET and C#. Also see https://asp.net-tutorials.com/user-controls/using/
Creating and using a UserControl in ASP.NET and C#. Also see https://asp.net-tutorials.com/user-controls/creating/
The skills required to advance your career and earn your spot at the top do not come easily. Now there’s a more rewarding approach to hands-on learning that helps you achieve your goals faster. Earn points, levels, and achieve more!
While Crystal reports can handle this, we are transitioning to SSRS and we need to display it on our work travelers to comply with our suppliers. Are there alternatives to display a black star on SSRS, that can still be …
What is the difference between DNN module control types Edit and View
Web Service API Demo by farhan1386
Let’s start at the very beginning. We’ll discover what Docker is and why containers are so popular. Then you’ll learn how to pull images from the Docker Hub, and what happens when you run a container.
To dynamically change the color of a text box or font properties
In this tip we cover how you can add conditional formatting for different objects in your SSRS reports.
Turn-key white papers are how we share some of our best advice to the public. We take pride in ensuring that best practices are followed by all, even those that are not our current customers.
After upgrading DNN it is possible that your prior performance configurations are lost. It is important to regularly verify your configuration.
ASP.NET Ajax allows developers to add Ajax functionality to quickly introduce Ajax features without extra development, however, usage of this within DNN is met with some challenges.
Many extension developers rely on the internal DotNetNuke Text Editor to provide rich-text editing experiences to users, however, Visual Studio may not always make this process straightforward.
Often times you might need to confirm actions with users, by creating a re-usable confirmation in the skin of your site, you can control this look and feel easily.
DotNetNuke provides its own internal data access strategy for accessing SQL Server, this process works well for most standard situations. However, complex items such as the ability to call using Table-Valued Parameters can be less straightforward to implement.
Working with custom solutions it is commonplace to need multiple extensions, it is possible with small modifications to package those extensions all at once.
Over the past 6 months, I have been pushing to establish a set of NuGet packages for DotNetNuke extension development, these have finally been released!
Developers will often need to add custom functionality that ties into, or consumes data from, existing DNN tables. There are many ways that one can do this, and this post explores one of the best ways to do this without impacting DNN.
DNN provides methods for encrypting and decrypting parameter information, however, there are a few gotchas that can impact the usability of this feature.
I love sharing stories of great experiences with third-party vendors, as it doesn't happen as often as I would like. When a recent performance issue was identified in DNN using 51 Degrees software, they jumped in and helped greatly.
Module developers have many choices as they create their extensions. One of which is around the level of emphasis placed on performance, a few simple things can set your module apart from others with these performance tweaks.
Installing multiple DotNetNuke extensions at the same time can be tedious and result in unexpected downtime. Thankfully there is an easy way to install multiple extensions at once.
Boosting chicken pot pie with spring veggies puts a healthy twist on a comfort food classic.
Learn what trusted documents are and how to change the options.
Link for all dot net and sql server video tutorial playlistshttp:
Using the AJAX UpdatePanel Control in ASP.Net
Free keyboard macro program. Supports hotkeys for keyboard, mouse, and joystick. Can expand abbreviations as you type them (AutoText).
Whether you obtain data from an external source or have someone performing data entry, mistakes can happen. If you’re concerned that you may have duplicate data in Microsoft Excel, you can find out quickly with conditional formatting.
Blender recipes. Smoothies, soups, and the like.
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
Now that we have a good structure in place, how do we deploy to different environments and test our DotNetNuke solutions?
In the final installation of my Enterprise Extension Development blog series we look at the actual project file structure and focus on reusability.
Enterprise extension development is a mindset and a technology set. The prior blog post looked at the mindset, now we look at the technology.
There is a difference when developing enterprise-grade solutions vs those quick-hit type items that are more bespoke. This post explores some of the differences in structure and process for the enterprise developer.
Chris Hammond's GitHub
Free Code 39 Barcode Font - TrueType
Before you spend money on special fonts or software, you should take a look at one of the best hidden native features of Microsoft Office—creating and printing barcodes. You can print several different kinds of codes from within Word. 1D codes like CODE128, CODE39, UPC A and UPC E, and EAN are available, and the big daddy of 2D barcodes, the QR code, is also included. This guide will show you exactly how to take advantage of these features.
This article describes how to quickly migrate data from SQLite to SQL Server by ESF Database Migration Toolkit! Help you complete complex database migration tasks and save a lot of time!
ESF Database Migration Toolkit is a powerful and high performance toolkit that can migrate data across various database formats, such as SQLite, SQL Server and so.
ESF Database Migration Toolkit is a powerful and high performance toolkit that can migrate data across various database formats, such as SQLite, SQL Server and so.
SQLAlchemy is the Python SQL toolkit and Object Relational Mapper that gives application developers the full power and flexibility of SQL.
It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
It provides a full suite of well known enterprise-level persistence patterns, designed for efficient and high-performing database access, adapted into a simple and Pythonic domain language.
Storm is an object-relational mapper (ORM) for Python developed at Canonical.
Save tens of thousands of dollars* worth of development time by boosting your productivity with the most powerful, zero config object relational mapper (ORM) the industry has ever known.
How to create a file from the command line.
I used this as a batch file to create text files for the letters a-z
echo test>A.txt
echo test>B.txt
echo test>C.txt
echo test>D.txt
echo test>E.txt
echo test>F.txt
echo test>G.txt
echo test>H.txt
echo test>I.txt
echo test>J.txt
echo test>K.txt
echo test>L.txt
echo test>M.txt
echo test>N.txt
echo test>O.txt
echo test>P.txt
echo test>Q.txt
echo test>R.txt
echo test>S.txt
echo test>T.txt
echo test>U.txt
echo test>V.txt
echo test>W.txt
echo test>X.txt
echo test>Y.txt
echo test>Z.txt
I used this as a batch file to create text files for the letters a-z
echo test>A.txt
echo test>B.txt
echo test>C.txt
echo test>D.txt
echo test>E.txt
echo test>F.txt
echo test>G.txt
echo test>H.txt
echo test>I.txt
echo test>J.txt
echo test>K.txt
echo test>L.txt
echo test>M.txt
echo test>N.txt
echo test>O.txt
echo test>P.txt
echo test>Q.txt
echo test>R.txt
echo test>S.txt
echo test>T.txt
echo test>U.txt
echo test>V.txt
echo test>W.txt
echo test>X.txt
echo test>Y.txt
echo test>Z.txt
Create a shortcut key for a Windows app
Samples for the SharePoint Column Formatting feature to demonstrate different capabilities and possibilities.
Each sample has its own dedicated readme file with a screenshot to show the result of the sample applied to a SharePoint column.
Note: Excel-style expressions are not supported on SP 2019. You need to use the AST(Abstract Syntax Tree) version of the JSON from the sample repository on SP 2019.
Each sample has its own dedicated readme file with a screenshot to show the result of the sample applied to a SharePoint column.
Note: Excel-style expressions are not supported on SP 2019. You need to use the AST(Abstract Syntax Tree) version of the JSON from the sample repository on SP 2019.
Making vmware work on windows 10
The Situation Report (SITREP) is a form of status reporting that provides decision-makers and readers a quick understanding of the current situation. It provides a clear, concise understanding of the situation—focusing on meaning or context, in addition to the facts. It does not assume the reader can infer what is important or not, and what actions or decisions are needed. It calls out what is needed. Below are descriptions and guidance to complete the form. It can also be provided verbally in a 30 second to 5-minute duration.
If you decide to download PHP and install it manually, the procedures in this section guide you.
Also, see Installing WinCache PHP extension at https://docs.microsoft.com/en-us/iis/application-frameworks/scenario-build-a-php-website-on-iis/configuring-step-2-configure-php-settings
Also, see Installing WinCache PHP extension at https://docs.microsoft.com/en-us/iis/application-frameworks/scenario-build-a-php-website-on-iis/configuring-step-2-configure-php-settings
Microsoft Visual C++ Redistributable for Visual Studio 2019 required for PHP 7.4
In views, you’ll need to set filters using [Today]
You could also create more complicated filters such as:
* Incomplete projects: DueDate <= [Today] AND Completed=No
* Projects beginning in a week or more: StartDate >= ([Today]+7)
* Last year on this day: Created = [Today]-365
In calculated columns, you’ll need to use Today() or Now() as the value for today’s date or today’s date and time.
The difference is Now() uses date and time, so you’ll get down-to-the-minute values (i.e. hours since reported). Today is just date best used for data with no times involved (i.e. days since hire date).
You could also create more complicated filters such as:
* Incomplete projects: DueDate <= [Today] AND Completed=No
* Projects beginning in a week or more: StartDate >= ([Today]+7)
* Last year on this day: Created = [Today]-365
In calculated columns, you’ll need to use Today() or Now() as the value for today’s date or today’s date and time.
The difference is Now() uses date and time, so you’ll get down-to-the-minute values (i.e. hours since reported). Today is just date best used for data with no times involved (i.e. days since hire date).
REST API for a list in SharePoint Online using POSTMAN
The support site for the Unique DNN skins
This step by step guide details how to configure a Microsoft Flow to extract data from a document and add to the document as metadata.
For the purposes of this guide we'll use this simple scenario;
The finance department generates invoices using a third party application which uploads the documents to a SharePoint library for storage. To enable invoice reporting, tracking and related activities we have a requirement to extract data from each invoice and add as metadata to the document.
For the purposes of this guide we'll use this simple scenario;
The finance department generates invoices using a third party application which uploads the documents to a SharePoint library for storage. To enable invoice reporting, tracking and related activities we have a requirement to extract data from each invoice and add as metadata to the document.
Chalkboards have been used in schools for more than 400 years. White boards entered classrooms in the 1990’s, and schools are now installing Interactive White Boards. Meanwhile, many teachers have experienced the benefits of using Microsoft OneNote as a digital whiteboard in the classroom, without the costs.
To simplify things for this article, I’m going to start by showing you how to use OneNote as a real-time virtual whiteboard to share ideas among a virtual team, regardless of where they are or what kind of computers they have. All you (and your collaborators) need is an internet connection and, at a minimum, a web browser.
How to stamp a concrete overlay wall inside and outside corner shows you step by step how to stamp inside and outside corners when applying concrete overlays to walls, fireplaces, barbecues, outdoor kitchens and more.
Vertical Artisans just wanted to share some tips and tricks in staining the Hardscape System with Tru-Tint stains from Walttools. Nathan Giffin breaks down the staining process by the numbers that are really easy to complete.
The Stone Matrix was used to create the stone pattern on the Vertical Decorative Concrete project. Watch how subtle the color transition is while providing a very engaging color contrast with the very nice color flow.
The Stone Matrix was used to create the stone pattern on the Vertical Decorative Concrete project. Watch how subtle the color transition is while providing a very engaging color contrast with the very nice color flow.
This "How To" video with Stone Edge Surfaces famous Liquid Colors and our vertical Pro Wall Mix (which can go up to 6" thick)...shows you a step by step coloring process on how to get realistic and authentic looks from Stamped Concrete (Concrete Overlays, Decorative Concrete).
Used five colors (black diluted 6:1), amber (2:1) nutmeg (1:1) fawn (2:1)
Good for horizontal, but not vertical application. Used Chestnut first and then fawn, cream, redwood, golden wheat. For color blending, used black walnut on top side, then antique teal on bottom of a "stone". Also used redwood and golden wheat. Creme & dark walnut splosh, Chestnut with olive.
This was a class where we produced a water wall feature in 3 days. The area is still being developed. To see this feature in person visit The Stamp Store in Oklahoma or go to their web site www.TheStampStore.com for more data.
This VDO gives you an overview of the five days that it took to build the entire booth at the World of Concrete Expo 2017.
