Jun 19

android_product_name_mismatch

USE [AmazonInventory-2018-06-14]
GO
/****** Object: StoredProcedure [dbo].[android_product_name_mismatch] Script Date: 2020-06-19 10:18:12 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
remove-this-phrase– =============================================
remove-this-phrase– Author: <Author,,Name>
remove-this-phrase– Create date: <Create Date,,>
remove-this-phrase– Description: <Description,,>
remove-this-phrase– =============================================

CREATE PROCEDURE [dbo].[android_product_name_mismatch]
AS
BEGIN
remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
remove-this-phrase– interfering with SELECT statements.
SET NOCOUNT ON;

SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name and ( (ama.[item-name] like ‘%android%’) or (supplier.name like ‘%android%’) )
order by ama.[item-name]

END
GO
*** . *** *** . *** . *** . ***

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

Jun 19

adjust_stock_status_data_for_canada

/****** Object: StoredProcedure [dbo].[adjust_stock_status_data_for_canada] Script Date: 2020-06-19 10:15:42 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

remove-this-phrase– =============================================
remove-this-phrase– Author: <Author,,Name>
remove-this-phrase– Create date: <Create Date,,>
remove-this-phrase– Description: <Description,,>
remove-this-phrase– =============================================
CREATE PROCEDURE [dbo].[adjust_stock_status_data_for_canada]
AS
BEGIN
remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
remove-this-phrase– interfering with SELECT statements.
SET NOCOUNT ON;

update price_calculations_dec_23_2018
set sku=concat(‘shopforsoul-‘, sku)
where sku not like ‘%shopfor%’;

remove-this-phrase–select * from CanadaAllListingsReport12252018;

remove-this-phrase–minimum price update
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 1 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel]
from [price_calculations_dec_23_2018] p
inner join CanadaAllListingsReport12282018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status=1)

remove-this-phrase–deactivate on amazon as they are disabled on ShopForSoul.com
select p.sku, round(amazon_special_price,2) as price, round(amazon_ca_minimum_price,2) as [minimum-seller-allowed-price]
, round(amazon_list_price,2) as [maximum-seller-allowed-price], 0 as quantity, 4 as [handling-time]
, ‘default’ as [fulfillment-channel], canada.asin1 as asinremove-this-phrase–, ‘Inactive’ as status
from [price_calculations_dec_23_2018] p
inner join CanadaAllListingsReport12282018 canada on trim(canada.[seller_sku])=trim(p.sku)
where (canada.status=’Active’) and (p.status <> 1)

END
GO
*** . *** *** . *** . *** . ***

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

Jun 19

remove this word product_name_mismatch

USE ProductAndPriceManagement
GO
/****** Object: StoredProcedure [dbo].[product_name_mismatch] Script Date: 2020-06-19 9:56:07 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

remove-this-phrase– =============================================
remove-this-phrase– Author: <Author,,Name>
remove-this-phrase– Create date: <Create Date,,>
remove-this-phrase– Description: <Description,,>
remove-this-phrase– =============================================
CREATE PROCEDURE [dbo].[product_name_mismatch]
AS
BEGIN
remove-this-phrase– SET NOCOUNT ON added to prevent extra result sets from
remove-this-phrase– interfering with SELECT statements.
SET NOCOUNT ON;

/****** Script for SelectTopNRows command from SSMS ******/
SELECT ama.asin1, ama.[seller-sku], supplier.sku, ama.[item-name] as name_on_amazon, supplier.name as name_at_supplier_side
FROM [ActiveListingsReport-06-19-2018] ama
inner join [all-to-upload-without-description] supplier on trim(ama.[seller-sku])=concat(‘shopforsoul-‘,supplier.sku)
where ama.[item-name] <> supplier.name
order by ama.[item-name]

END
GO

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

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

Jun 19

update_inactive_listings_uk

USE [AdjustInActiveInventory]
GO

/****** Object: StoredProcedure [dbo].[update_inactive_listings_uk] Script Date: 2020-06-19 9:55:55 PM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Jun 13

OOP in Matlab

Introduction to Object-Oriented Programming in MATLABhttps://ww2.mathworks.cn/matlabcentral/fileexchange/18971-comparison-of-c-and-matlab-using-oop-example?s_tid=FX_rc1_behav

Matlab OOP
https://www.slideshare.net/HosseinMolhem/matlab-oop?qid=9408235e-e0c5-4b8c-8003-99d8eb096776&v=&b=&from_search=1

Book: OOP in Matlab
https://www.slideshare.net/AlbanLevy/object-oriented-programming-in-matlab?qid=9408235e-e0c5-4b8c-8003-99d8eb096776&v=&b=&from_search=2

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

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

Jun 13

OOP in Matlab

Examples and How To

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

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

Jun 06

“Private sector races to build virus apps to track employees”

Search Results

Web results

Stumbled upon while looking for something else. Links are taken from Google search.
I cannot guarantee that the URLs are safe to click (I opened them anyway)



"

Private sector races to build virus apps to track employees …

www.ft.com › content

26 Apr 2020 – Tools could track movement of office workers to within a few centimetres. … While governments and tech companies are working on voluntary …"

Top 10 Software To See If Remote Employees Are Working

https://biz30.timedoctor.com/remote-employee-software/

You can track employees working from home. But should you?

"The biggest thing we need to track right now is mental health, not if people are getting a 5% or 10% productivity boost."

https://www.protocol.com/remote-work-boss-tracking-tools

"Your Boss May Soon Track You At Work For Coronavirus Safety

"The last time you were in your office, who did you walk past in the lobby? Stand next to in the elevator? Chat with in the kitchen? You’re not alone if you can’t remember each of those encounters. But that is exactly the sort of information employers want to have on hand, in case an employee catches the coronavirus." https://www.npr.org/2020/05/08/852896051/your-boss-may-soon-track-you-at-work-for-coronavirus-safety?t=1591490073133

"How My Boss Monitors Me While I Work From Home

As we shelter in place in the pandemic, more employers are using software to track our work — and us."

https://www.nytimes.com/2020/05/06/technology/employee-monitoring-work-from-home-virus.html

"Just because you’re working from home doesn’t mean your boss isn’t watching you Software that monitors remote employees is seeing a sales boom."

https://www.vox.com/recode/2020/4/2/21195584/coronavirus-remote-work-from-home-employee-monitoring

What is Employee Monitoring?

"Get a crash course on the leading work tracking software for better productivity, performance, and time savings"

https://hubstaff.com/employee_monitoring

Companies are finding new ways to track workers at home, but are they going too far?https://www.ctvnews.ca/business/companies-are-finding-new-ways-to-track-workers-at-home-but-are-they-going-too-far-1.4944907"

Employers are monitoring computers, toilet breaks – even emotions. Is your boss watching you?

From microchip implants to wristband trackers and sensors that can detect fatigue and depression, new technology is enabling employers to watch staff in more and more intrusive ways. How worried should we be?"
https://www.theguardian.com/world/2018/may/14/is-your-boss-secretly-or-not-so-secretly-watching-you

"Is your company spying on you? Digital surveillance tools track your productivity when working from home

https://abc7news.com/work-from-home-working-jobs-coronavirus-tips/6158718/"

Employee monitoring: to track or not to track?

"it’s easy to clock up a 9-5 day and get absolutely nothing done. Before computers were the office norm, you could probably stare into cubicle abyss all day, pretending to read memos."
https://resources.workable.com/stories-and-insights/employee-monitoring

"

7 Ways Your Work Tech Is Betraying Your Privacy

By Joshua Stowers, StaffUpdated: May 1, 2020

  • MORE

image for ijeab / Getty Images
ijeab / Getty Images

  • Employers can remotely install or remove software and can even erase data on employee devices.
  • Employees should assume that everything they do on their work computer is being watched and tracked.
  • Many people access their nonwork accounts with their work computers, but it exposes their personal data to the IT team. " https://www.businessnewsdaily.com/7928-work-computer-employee-monitoring.html

"To make sure employees aren’t slacking off as Covid-19 has n ..

Read more at:

http://timesofindia.indiatimes.com/articleshow/74978786.cms?utm_source=contentofinterest&utm_medium=text&utm_campaign=cppst_prime"
https://timesofindia.indiatimes.com/india/how-employers-are-using-new-tech-to-track-those-working-from-home/articleshow/74978786.cms

"The Quantified Employee: How Companies Use Tech to Track Workers
BY CHANDRA STEELE 14 FEB 2020, 2 P.M.

Measuring employee performance with surveillance isn’t new, but emerging technologies are helping companies monitor workers in arguably invasive ways. Are you being watched?

Employee time tracking: the complete guide to monitoring employees in the workplace

"Monitoring employees’ computer use in the workplace may be controversial, but stats speak for themselves: companies that monitor employee internet usage report 30% productivity boost within the first month."

https://desktime.com/employee-time-tracking-guide

"The Best Employee Monitoring Software for 2020
"Employee monitoring software is an important tool for business owners who want to verify employees are using their time at work to accomplish the responsibilities and tasks assigned to them, not spending hours watching cat videos and trolling social media, or, worse, engaging in reckless or malicious behavior that jeopardizes the security of one’s business.
We considered 29 employee monitoring solutions, looking for affordable, easy-to-use software that comes with the features business owners need for productivity tracking and security, such as app and website tracking, content filtering and screen captures."
https://www.business.com/categories/employee-monitoring-software/

"What you should know about employee tracking laws

Nowadays more and more businesses are becoming mobile, with many businesses predicting growth. With high competition, it means that every business is attempting to find new methods of achieving greater productivity and efficiency."

https://www.opusenergy.com/brighter-business/what-you-should-know-about-employee-tracking-laws/

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

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

Jun 04

Contribute to our GoFundMe Campaign

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

May 24

Magento 2 Useful and Important CLI Commands List

"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

May 15

How to Upload Product Data to an Ecommerce Shop