Disable SSL mode for Cs-Cart 4.4.X #CS Cart Ecommerce

This is not about whether disabling is good or bad. This is about how to, when you need to

Executing these SQLs worked for me for my local dev env. My local CS-cart version was 4.4.1

UPDATE `cscart_settings_objects` SET `value` = ‘N’ WHERE `cscart_settings_objects`.`object_id` =55;
UPDATE `cscart_settings_objects` SET `value` = ‘N’ WHERE `cscart_settings_objects`.`object_id` =56;
UPDATE `cscart_settings_objects` SET `value` = ‘N’ WHERE `cscart_settings_objects`.`object_id` =97;

I might have seen another SQL to change values in cscart_settings tables to disable ssl. This approach might work for earlier versions. On 4.4.1 cscart_settings table is non-existent

if you want to enable SSL for your sites, cert-bot might be an option
https://certbot.eff.org/

yes, I tried this successfully on Ubuntu platform and with real domain names.

For local Vagrant env, experienced some issues, did not try to resolve – kept it for a later time – I really did not need it for local – though will try to fix at one point (related to DNS issue, a local DNS setup or using /etc/hosts might work )

from https://certbot.eff.org/, you can select your platform and get instructions on how to make cert-bot work on your platform.
From: http://sitestree.com/?p=6019
Categories:CS Cart Ecommerce
Tags:
Post Data:2016-12-21 20:36:44

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

3rd part write a c# tool to create HTML to PDF #CSS #Root #By Sayed Ahmed

3rd part write c sharp tool to create HTML/CSS to pdf
[youtube http://www.youtube.com/watch?v=LlYtJtiDu14?list=UUHrtq0pV8mEuTLGd2-Lp9ig&w=854&h=510] From: http://sitestree.com/?p=1684
Categories:CSS, Root, By Sayed Ahmed
Tags:
Post Data:2014-11-18 21:58:08

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Examples: BAD CSS #CSS #Root #By Sayed Ahmed

Case 1: Bad as depends on HTML Structure too much

#main-nav ul li ul li div { }
#content article h1:first-child { }
#sidebar > div > h3 + p { }

Case 2: 
.widget {
  background: yellow;
  border: 1px solid black;
  color: black;
  width: 50%;
}
#sidebar .widget {
  width: 200px;
}
body.homepage .widget {
  background: white;
}
Bad because the CSS classes are not reusable. Modifying Components Based On Who Their Parents Are is not great. 
Widget is being different based on location Software entities (classes, modules, functions, etc.) should be open for 
extension, but closed for modification.

Case 3:
Bad as Overly Generic
<div class="widget">
  <h3 class="title">...</h3>
  <div class="contents">
    Lorem ipsum dolor sit amet, consectetur adipiscing elit.
    In condimentum justo et est dapibus sit amet euismod ligula ornare.
    Vivamus elementum accumsan dignissim.
    <button class="action">Click Me!</button>
  </div>
</div>

.widget {}
.widget .title {}
.widget .contents {}
.widget .action {}

Case 4: Bad: Making a Rule Do Too Much
.widget {
  position: absolute;
  top: 20px;
  left: 20px;
  background-color: red;
  font-size: 1.5em;
  text-transform: uppercase;
}

From: http://sitestree.com/?p=1638
Categories:CSS, Root, By Sayed Ahmed
Tags:
Post Data:2014-11-09 00:53:45

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Tools to Make Your Web-sites and Web-Applications Look Alright in Different Browsers #CSS #Root #By Sayed Ahmed

You can use the following services to test your web-sites and web-applications in different browsers (also in Mobile Mood)

http://www.portableapps.com
http://www.spoon.net
http://www.browsersstack.com

https://www.modern.ie/en-us/virtualization-tools

 

A tool to check and improve CSS syntax :

http://csslint.net

 

 

 

 

  From: http://sitestree.com/?p=1588
Categories:CSS, Root, By Sayed Ahmed
Tags:
Post Data:2014-10-18 18:26:57

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Some WPF Stuff: Windows Presentation Foundation: WPF vs HTML #CSS #Root #By Sayed Ahmed

Overview of WPF

https://en.wikipedia.org/wiki/Windows_Presentation_Foundation

“According to Microsoft developers answering questions during Build 2014, WPF is still actively developed, but was not designed to be highly responsive, nor adapted to low-power consumer devices such as tablets or smartphones. Because of that, no further major changes are expected to be done on the framework[5]”

 

In defense of WPF (No comment from me)

http://rgramann.blogspot.ca/2013/06/in-defense-of-wpf.html

 

.NET/WPF to HTML/CSS/Javscript

https://bling.github.io/blog/2013/04/13/dot-net-slash-wpf-to-html-slash-css-slash-javscript/

 

Can HTML5 Replace WPF?

http://www.kevinboyle.ie/blog/2013/05/08/can-html5-replace-wpf/

 

Creating hybrid HTML5 and WPF applications with self-hosted OWIN Web API SignalR and Awesomium

http://galratner.com/blogs/net/archive/2014/01/31/creating-hybrid-html5-and-wpf-applications-with-self-hosted-owin-web-api-signalr-and-awesomium.aspx

 

WPF Code Example: XAML

<Grid.ColumnDefinitions>
  <ColumnDefinition x:Uid="ColumnDefinition_1" />
  <ColumnDefinition x:Uid="ColumnDefinition_2" />
  <ColumnDefinition x:Uid="ColumnDefinition_3" SharedSizeGroup="Buttons" />
  <ColumnDefinition x:Uid="ColumnDefinition_4" SharedSizeGroup="Buttons" />
  <ColumnDefinition x:Uid="ColumnDefinition_5" SharedSizeGroup="Buttons" />
</Grid.ColumnDefinitions>

<Page x:Uid="Page_1" x:Class="MicrosoftSaudiArabiaHomepage.Homepage"
    xmlns="http://schemas.microsoft.com/winfx/2006/xaml/presentation"
    xmlns:x="http://schemas.microsoft.com/winfx/2006/xaml"   
    FlowDirection="LeftToRight" 
    Localization.Comments="FlowDirection(This FlowDirection controls the actual content of the homepage)"
    xml:lang="en-US">

Reference:
http://msdn.microsoft.com/en-us/library/ms788718%28v=vs.110%29.aspx

 

  From: http://sitestree.com/?p=1313
Categories:CSS, Root, By Sayed Ahmed
Tags:
Post Data:2014-08-06 22:04:53

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

CSS what to Learn? Mostly links to resources. If you can master the topics in all of these resources, you will be a great one.. #CSS #Root #By Sayed Ahmed #Misc. Reading

CSS what to Learn? Mostly links to resources. If you can master the topics in all of these resources, you will be a great one..

http://salearningschool.com/training_slides/CSS/css_what_to_learn.pdf From: http://sitestree.com/?p=1632
Categories:CSS, Root, By Sayed Ahmed, Misc. Reading
Tags:
Post Data:2014-11-02 14:07:16

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Using Rich Text Box Control from Kendo UI #CSS #Root #JQuery #By Sayed Ahmed

Kendo UI Rich Textbox Control:

http://docs.telerik.com/kendo-ui/api/javascript/ui/editor

Yes, I used this in real projects.

The following code will create a Rich Textbox Control (http://docs.telerik.com/kendo-ui/api/javascript/ui/editor). To customize the control, what buttons should appear on the toolbar, you can use the following instead of

 

//with all buttons

$(“#editor”).kendoEditor();
});

 

//with selected buttons

$("#topEditor").kendoEditor({
                        tools: [
                            "bold",
                            "italic",
                            "underline",
                            "strikethrough",
                            "justifyLeft",
                            "justifyCenter",
                            "justifyRight",
                            "justifyFull",
                            "createLink",
                            "unlink",
                            "insertImage",
                            "createTable",
                            "addColumnLeft",
                            "addColumnRight",
                            "addRowAbove",
                            "addRowBelow",
                            "deleteRow",
                            "deleteColumn",
                            "foreColor",
                            "backColor"
                        ]
                    });

 

 

Using CSS, you will be able to change the position of the toolbar as well as height of the toolbar. Yes, for sure, you can always customize the look and feel using CSS

 

<!DOCTYPE html>
<html>
<head>
<base href=”http://demos.telerik.com/kendo-ui/editor/index”>
<style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
<title></title>
<link rel=”stylesheet” href=”http://cdn.kendostatic.com/2014.3.1119/styles/kendo.common.min.css” />
<link rel=”stylesheet” href=”http://cdn.kendostatic.com/2014.3.1119/styles/kendo.default.min.css” />
<link rel=”stylesheet” href=”http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.min.css” />
<link rel=”stylesheet” href=”http://cdn.kendostatic.com/2014.3.1119/styles/kendo.dataviz.default.min.css” />
<link rel=”stylesheet” href=”http://cdn.kendostatic.com/2014.3.1119/styles/kendo.default.mobile.min.css” />

http://cdn.kendostatic.com/2014.3.1119/js/jquery.min.js
http://cdn.kendostatic.com/2014.3.1119/js/kendo.all.min.js
</head>
<body>

<div id=”example”>
<textarea id=”editor” rows=”10″ cols=”30″ style=”height:440px”>
<p><img src=”../content/web/editor/kendo-ui-web.png” alt=”Editor for ASP.NET MVC logo” style=”display:block;margin-left:auto;margin-right:auto;” /></p>
<p>
Kendo UI Editor allows your users to edit HTML in a familiar, user-friendly way.<br />
In this version, the Editor provides the core HTML editing engine, which includes basic text formatting, hyperlinks, lists,
and image handling. The widget <strong>outputs identical HTML</strong> across all major browsers, follows
accessibility standards and provides API for content manipulation.
</p>
<p>Features include:</p>
<ul>
<li>Text formatting & alignment</li>
<li>Bulleted and numbered lists</li>
<li>Hyperlink and image dialogs</li>
<li>Cross-browser support</li>
<li>Identical HTML output across browsers</li>
<li>Gracefully degrades to a <code>textarea</code> when JavaScript is turned off</li>
</ul>
<p>
Read <a href=”http://docs.telerik.com/kendo-ui”>more details</a> or send us your
<a href=”http://www.telerik.com/forums/”>feedback</a>!
</p>
</textarea>
<script>
$(document).ready(function() {
// create Editor from textarea HTML element with default set of tools
$(“#editor”).kendoEditor();
});
</script>
</div>
</body>
</html> From: http://sitestree.com/?p=1847
Categories:CSS, Root, JQuery, By Sayed Ahmed
Tags:
Post Data:2014-12-30 21:12:39

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

What is Data Warehousing? #Data Warehouse #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc

A Data Warehouse is a storage of an organization’s historical data. Usually, data warehouse is built to provide a decision support system to the management. Data warehouse can be mined (using data mining) and queried to collect overall and summarized business information that significantly helps in decision making. It can provide trends over many years.

Operational databases are optimized for day to day operation access. Here, the relationships are normalized and further divided into more relations/tables to make accessing faster that also reduces data traffic among the systems. But a data warehouse does the reverse, where relationships/tables are de-normalized as much as possible to provide the required information to the management.

As a data warehouse provides summarized information de-normalization helps, otherwise the data would be required to collect from many tables and the queries may be running over data for 10 years (millions/billions of records). Usually, data warehouse is created separately from the operational databases.

Microsoft SQL Server and Oracle both have supports and tools to create Data warehouse Systems. There are also free tools for the purpose even for My SQL. From: http://sitestree.com/?p=3569
Categories:Data Warehouse, Data Warehouse – 001, Data Warehouse, Data Warehouse Misc
Tags:
Post Data:2016-07-05 15:37:20

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Random Information on BI #Data Warehouse #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc

  • Real internet money/business lies in B2B not in B2C.
  • Decision Support System (DSS):
    • Full spectrum of systems that allow/help management to take decisions, such as, reporting, OLAP, data mining.
  • Java provides support for web enabled DSS
  • JDM is Java’s Data mining/BI API.
  • BI Applications: Balanced Score-card, Activity Based Costing.
  • Data warehouse elements
    • Operational Environment: Maintains day to day activities. Raw Data
    • Independent data mart: A small data warehouse specific to one topic/area/subject
    • Extraction: Extraction of data from operational systems
    • Extraction Store: Data storage after extraction
    • Transformation and cleansing: Before putting data into the central/main warehouse data needs to be cleaned up
    • Extraction log: Create a log in the transformation and cleansing process
    • External source: Data originated outside the organization is also incorporated into the data warehouse.
    • Data administrator: The person who ensures the quality of data
    • Central Repository: Stores all data and meta-data
    • Meta data: Data about data. Example: the extraction log.
    • Dependent Data Mart: Relies on the data warehouse for the sources of its data
  • Distributed Data Warehouse: Warehouse data is physically distributed across a company’s information infrastructure.
  • Data mining types: classification, and estimation.
    • Classification: categorize customers,
    • Estimation: predict or estimate some numerical value
  • Decision trees: modeling technique helps in deciding. Different alternatives are drawn as paths where nodes represent the selected alternative. edges/paths may carry some probability values as selection/influencing criteria.
  • Neural networks: Try to mimic the work nature of human brain to take a decision.
  • General modeling: Well-suited for categorizing.
  • Balanced Scorecard application: views the health and well-being of the organization by more than its financial data. We need to define: Vision, Strategy, Strategic themes, Strategic Objectives, Key performance indicators.
  • Activity based costing application:
  • Three types of organizations:
    • Engineer driven: They know how to make a product. Than sales it through sales force.
    • Sales Driven: They know how to sale a particular product, then make the product and sell it.
    • Customer driven: They Know what customers want, then make the products and sale them. Customer driven organizations are the most successful.

From: http://sitestree.com/?p=3567
Categories:Data Warehouse, Data Warehouse – 001, Data Warehouse, Data Warehouse Misc
Tags:
Post Data:2016-07-04 15:22:58

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada

Steps in Data Warehouse Design and Implementation #Data Warehouse #Data Warehouse – 001 #Data Warehouse #Data Warehouse Misc

 

  • Most BI projects usually fail. It is not due to the errors in the construction steps but due to the inappropriate design steps and methodologies.
  • Waterfall method is not appropriate for BI. A method like developmental spiral may be more appropriate. Ref: [W. A. Giovinazzo ]
  • Steps in developmental spiral: Definition, Analysis, Design, Development, Implementation/Deployment, Maintenance, Evaluation
  • Developmental spiral method is effective for BI only when Object Oriented approach is taken
  • In developmental spiral, object modeling is used to represent objects in the related business areas. In object modeling, objects are represented as rectangles, the rectangles can be treated as classes. Classes/objects can have sub-classes/sub-objects. Objects have attributes. Objects also have some special properties like: accelerators, stops.
  • Definition – first step of developmental spiral: Define a short description what you want to build – like the problem statement in a research proposal. Example: I want to build a data mart that will provide data to support the analysis of customer demographics such as age, gender, and income for all product lines
  • Analysis Phase: In this step, analyze the requirements of the BI system, the nature of the BI system, the expectations from the BI system. Interviewing different parties will help a lot:
  • Interview the sponsor to get a detail understanding of the mission. The questions will include: Data-related(which objects are related to the business needs?), user-related: who are the users, system evaluation: what parameters will make the project a success?
  • Interviewing management: To understand management’s expectation of the data warehouse. Questions may include: User profile related (what types of systems you use/will use to access BI?), System vision: what do you see as the objective of the data warehouse, System Evaluation: what parameters will make the project a success?
  • Interviewing Users : Interviewing users who will use the system
  • Interviewing information technology staffs: To know the current state of the organization’s information systems
  • Design phase: output – object model, implementation model
  • Start with the analysis phase information. The design phase is complete when all the objects related to the mission are well defined. An object diagram needs to be drawn showing all objects, relationships, attributes.
  • Another chart listing all the attributes and their data types will be useful. Objects will have relations like super classes or sub-classes.
  • Cardinality relationships: exactly one, one to many, zero or one, zero to many
  • aggregation may be required in some cases. Aggregation: an object is composed of other objects.
  • Implementation Model: Data warehouse databases are multi dimensional databases. Objects are represented in more than two dimensions. Common practice is: three dimensional databases. Such as an object/table represented with three dimensions (called cube) like: product, dealer, and time. RDBMS’s are two dimensional.
  • Data cubes: have six possible different views [permutation of three dimensions].
  • Why not always multidimensional databases: because of space requirements.
  • Star schema: Provides a multidimensional flavor in two dimensional relational databases.
  • Star schema uses a concept called fact tables to bind dimensions to create a multidimensional space.
  • Denormalization of the tables are utilized in star schema to create multi dimension.
  • Dimension table: Think about a three dimensional cube. Each wall represents a dimension table. Or think it as a mathematical combination of the dimensions.
  • All objects represented in the dimensions can slowly change over time – slowly changing dimensions. There are many approaches to address this issue.
  • Snowflakes: normalizing dimensions – not always a great thing
  • Implementation considerations: Parallel processing, Bitmapped Indexing, Star Query Optimization, Summation Tables

  From: http://sitestree.com/?p=3565
Categories:Data Warehouse, Data Warehouse – 001, Data Warehouse, Data Warehouse Misc
Tags:
Post Data:2016-07-06 15:54:10

Shop Online: https://www.ShopForSoul.com/
(Big Data, Cloud, Security, Machine Learning): Courses: http://Training.SitesTree.com
In Bengali: http://Bangla.SaLearningSchool.com
http://SitesTree.com
8112223 Canada Inc./JustEtc: http://JustEtc.net (Software/Web/Mobile/Big-Data/Machine Learning)
Shop Online: https://www.ShopForSoul.com/
Medium: https://medium.com/@SayedAhmedCanada