Contribute to our GoFundMe Campaign

https://www.gofundme.com/f/6ek65t-1000

This campaign is to raise money to provide education and training through free youtube videos and youtube courses. The training will focus on Web, Mobile Development to AI and Machine Learning. In future, we can extend into social science, science, and business. The majority (80 to 90%) of the collected money will be primarily used to pay the teachers other than myself where the rest can be used for operational expenses as I see fit.

I myself have provided efforts to create training videos in the past. I also have conducted free online training sessions on Facebook. This campaign is to raise money to hire qualified teachers from developing countries who might also have a financial need to create training videos and courses for a youtube channel.

Facebook pages and groups will be utilized for student teacher communications in addition to youtube channel comments.

Target audience/students will be anyone over the entire world who wants to learn the topics created.

Youtube Channel:
Youtube Channel for Learning and Training

—

*** . *** *** . *** . *** . ***

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada

Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261

"Cache CLI (Status, Enable, Disable, Clean, Flush)

php bin/magento cache:clean Cleans cache type(s) php bin/magento cache:disable Disables cache type(s) php bin/magento cache:enable Enables cache type(s) php bin/magento cache:flush Flushes cache storage used by cache type(s) php bin/magento cache:status" Checks cache status

"

Also Check:
http://bangla.salearningschool.com/recent-posts?s=bin%2Fmagento

Also Check:
http://bangla.salearningschool.com/recent-posts?s=magento

Also, Check:
Youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists

Check the details at:
Magento 2 Useful and Important CLI Commands List

Ref: https://hiteshvaghasiya.com/magento-2-daily-useful-cli-commands-list

*** . *** *** . *** . *** . ***

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada

Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261

What is Big Data? Is Big-data a platform or just huge volume of data? What are 3 V’s of Big Data? What are 5 V’s of Big Data? What are 6 V’s of Big Data?

https://www.youtube.com/embed/DhtkQgzEW5M?list=PLUA7SYgJYDFpIHm2vfzdH0slgkCfqgdds

*** . *** *** . *** . *** . ***

Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261

What is Big Data? Is Big-data a platform or just huge volume of data? What are 3 V’s of Big Data? What are 5 V’s of Big Data? What are 6 V’s of Big Data?

<iframe width="732" height="412" src="https://www.youtube.com/embed/DhtkQgzEW5M?list=PLUA7SYgJYDFpIHm2vfzdH0slgkCfqgdds" frameborder="0" allow="accelerometer; autoplay; encrypted-media; gyroscope; picture-in-picture" allowfullscreen></iframe>

*** . *** *** . *** . *** . ***

Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261

Calculate Your Categorized Expenses for Tax Purpose.

The purpose of this note (i.e. code) is to calculate expenses (revenues) by categories. For the context, read the notes from

Write Tax and Financial Software
Code examples in relation to writing Tax and Financial Softwaremedium.com

At this point, you have spreadsheets for all of your bank accounts and credit cards. You need to merge them into one master sheet. Make sure that you align/match the columns properly. Some cards will use two columns for debit and credit. Others will just use one with +ve and -ve signs. You will need to separate them into two fields. The master spreadsheet as this code will use used three columns such as ‘Expense Debit’, ‘Credit’, ‘All Money’.

First, you need to find the list of expenses and the associated categories and subcategories. You will also need to put thoughts and decide what goes on which expense categories. A simple way is keep this in your head or in paper/note, and use them in the code. The simple way.

Well if you are really making a software then it has to be way more structured. A better way to do can be: Put all categories and subcategories in a JSON file (can be enough), or in an xml file (considered worse than JSON), or in a database table such as MySQL/SQL server table (can be seen as overkill, however, depending — you might find it easier to update (based on size, your skills, tool availability, or writing an UI and DB update code) ). Sure, the last sentence got messy — you know what I mean. I am not trying to be perfectionist here.

The same way, you can keep what goes into what category in JSON/XML/Database. You might want to think based on expense description based on which words or cards or accounts — what will go where. Then write the code to assign categories and calculate sum by categories.

The code will simply look for words in the description and based on search result, the category column will be updated. Then the sum will be based on the categories. Yes, you can assign subcategory the same way. And then calculate sum of subcategories.

# some simple code are given below

import os;
import glob;
import pandas as pd;
import math;
data_folder = ‘./’;
os.chdir(data_folder);

# read data, verify data manually
df = pd.read_csv(‘to_process_all_combined_transactions_assign_category.csv’)
df.head(3)

#Save to a temp file, to be safe
df.to_csv(‘temp_to_process_all_combined_transactions_assign_category.csv’);

# read data, verify data manually
df = pd.read_csv(‘temp_to_process_all_combined_transactions_assign_category.csv’)
df.head(3);

# Find Donation amount : FB Fundraiser

#check

df[df[‘Description 1’].str.contains(‘FBFUNDRAISER’, na = False, case = False )][{‘Description 1’, ‘Card Owner’, ‘Card’, ‘Expense Debit’}]

# assign category
df.loc[df[‘Description 1’].str.contains(‘FBFUNDRAISER’, na = False, case = False ), ‘Category’] = ‘Donation’

# keep saving if you want
df.to_csv(‘temp_to_process_all_combined_transactions_assign_category.csv’);

# Donation Sum
donation = sum(df[df[‘Description 1’].str.contains(‘FBFUNDRAISER’, na = False, case = False )][‘Expense Debit’]);

print(‘Donation from Business Cards:’, donation);

# Domain and Hosting Expense
df[df[‘Description 1’].str.contains(‘AWS’, na = False, case = False )][{‘Description 1’, ‘Card Owner’, ‘Card’, ‘Expense Debit’}]

df.loc[df[‘Description 1’].str.contains(‘AWS’, na = False, case = False ), ‘Category’] = ‘Domain and Hosting’

df[df[‘Description 1’].str.contains(‘HOSTGATOR’, na = False, case = False )][{‘Description 1’, ‘Card Owner’, ‘Card’, ‘Expense Debit’}]

df.loc[df[‘Description 1’].str.contains(‘HOSTGATOR’, na = False, case = False ), ‘Category’] = ‘Domain and Hosting’

df[df[‘Description 1’].str.contains(‘godaddy’, na = False, case = False )][{‘Description 1’, ‘Card Owner’, ‘Card’, ‘Expense Debit’}]

df.loc[df[‘Description 1’].str.contains(‘godaddy’, na = False, case = False ), ‘Category’] = ‘Domain and Hosting’

df[df[‘Description 1’].str.contains(‘VULT’, na = False, case = False )][{‘Description 1’, ‘Card Owner’, ‘Card’, ‘Expense Debit’}]

df.loc[df[‘Description 1’].str.contains(‘VULT’, na = False, case = False ), ‘Category’] = ‘Domain and Hosting’

df[df[‘Category’].str.contains(‘Domain’, na = False, case = False )][{‘Description 1’, ‘Expense Debit’}]

domain_hosting = sum(df[df[‘Category’].str.contains(‘Domain’, na = False, case = False )][‘Expense Debit’])

print(‘Domain from Business Cards:’, domain_hosting);

df.to_csv(‘temp_to_process_all_combined_transactions_assign_category.csv’);

# Section Find all Car Gas Expenses

df.loc[ df[‘Description 1’].str.contains(‘ESSO’, na = False, case = False ), ‘Category’ ] = ‘Car Gas’;
df.loc[ df[‘Description 1’].str.contains(‘SHELL’, na = False, case = False ), ‘Category’ ] = ‘Car Gas’;
df.loc[ df[‘Description 1’].str.contains(‘MOBIL Toronto’, na = False, case = False ), ‘Category’ ] = ‘Car Gas’;
df.loc[ df[‘Description 1’].str.contains(‘Petro’, na = False, case = False ), ‘Category’ ] = ‘Car Gas’;

# Car Gas Sum
df[df[‘Category’].str.contains(‘Car Gas’, na=False, case=False)] 

sum(df[df[‘Category’].str.contains(‘Car Gas’, na=False, case=False)][‘Expense Debit’])

My goal was not to write great articles; however, share little bit of stuff that I have

*** . *** *** . *** . *** . ***

Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Training Courses: http://Training.SitesTree.com
Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net
Youtube: https://www.youtube.com/channel/UCHrtq0pV8mEuTLGd2-Lp9ig/playlists
Medium: https://medium.com/@SayedAhmedCanada

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/salearningschool

https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/

Join, Discuss, and Thrive:
Finance: https://www.facebook.com/groups/1792339521056034

Bangladesh and Canada: https://www.facebook.com/groups/398414183875009

Bangladesh: IT & Eng: Canada: https://www.facebook.com/groups/480297675634630

BUETians in Ontario: https://www.facebook.com/groups/371982239854027

Worldwide IT: https://www.facebook.com/groups/28362061867

JustEtc: https://www.facebook.com/JustETC-Technologies-Inc-289864738261

[Do not forget to search this site to learn/find related information]

# Use reset to reset current indexing status
# You may not need to use this all the time
# You will need to use this when you see invalid indexing status or you see index locked;
# When irrespective of that, you want to reindex, reset first

sudo php bin/magento indexer:reset

# want to see reset status of all indexes use the command below
sudo php bin/magento indexer:status [indexer]

# to see status of one index
sudo php bin/magento indexer:status [index name, one from the list given at the end]

# to check information and status on indexing/reindexing
sudo php bin/magento indexer:info

# execute the reindex: i.e. reindex
sudo php bin/magento indexer:reindex

# you might find these commands useful

# i.e. when to reindex such as real-time (update on save) or by “Schedule and cron”

sudo php bin/magento indexer:show-mode
sudo php bin/magento indexer:show-mode [indexer]
sudo php bin/magento indexer:set-mode {realtime|schedule} [indexer]

# the index types are provided below. If you just want to work with one of them, use the term from the below list
and put on the right side of each of the command above

# design_config_grid Design Config Grid
# customer_grid Customer Grid
# catalog_category_product Category Products
# catalog_product_category Product Categories
# catalogrule_rule Catalog Rule Product
# catalog_product_attribute Product EAV
# cataloginventory_stock Stock
# inventory Inventory
# catalogrule_product Catalog Product Rule
# catalog_product_price Product Price
# scconnector_google_remove Google Product Removal Feed
# scconnector_google_feed Google Product Feed
# catalogsearch_fulltext Catalog Search

###### If you want to configure from the admin menu, use: System -> index and then do as the image below shows:

***. ***. ***

Note: Older short-notes from this site are posted on Medium: https://medium.com/@SayedAhmedCanada

*** . *** *** . *** . *** . ***
Sayed Ahmed

BSc. Eng. in Comp. Sc. & Eng. (BUET)
MSc. in Comp. Sc. (U of Manitoba, Canada)
MSc. in Data Science and Analytics (Ryerson University, Canada)
Linkedin: https://ca.linkedin.com/in/sayedjustetc

Blog: http://Bangla.SaLearningSchool.com, http://SitesTree.com
Training Courses: http://Training.SitesTree.com
8112223 Canada Inc/Justetc: http://JustEtc.net

Facebook Groups/Forums to discuss (Q & A):
https://www.facebook.com/banglasalearningschool
https://www.facebook.com/justetcsocial

Get access to courses on Big Data, Data Science, AI, Cloud, Linux, System Admin, Web Development and Misc. related. Also, create your own course to sell to others. http://sitestree.com/training/