teleren/devto huggingface dataset:
Use Salesforce CRM and Streamline Business Processes
Tags: salesforce, crm, business
Published: 2020-09-28 07:27:36

It is important that companies have the privilege of operating from anywhere. They don't have to worry about investing in hardware or software to run or manage their operations. In a sense, they need to take advantage of the cloud and learn from the best of the cloud, mobile devices, and social media. Hence, CRM helps as it streamlines processes and automates operations while closing any gaps on the distance and geography front. It also helps to store all the information related to customers, associates and partners in one place so that the task of making decisions is as easy as necessary.

A high-quality [CRM system saves businesses](https://www.cloudanalogy.com/) the hassle and sadness of data security. This type of system will be feature-rich and cloud-based, providing granular control over all aspects of data and its security. In addition, it allows companies and all their parts to have a 360-degree view of their customers. Furthermore, its implementation in the company has an impact on practically all processes and operations. So while it helps the sales team close deals faster, it also enables marketing teams to keep track of campaigns. Also, the time required to resolve customer complaints is drastically reduced.

Additionally, a powerful [CRM system](https://www.cloudanalogy.com/) will give businesses the freedom to run on any device. It will be built to fit your business and support your future growth and expansion effortlessly. Furthermore, companies will have the facility to manage contacts, as well as to map, track and analyze sales opportunities. It is easy to control each potential customer and each customer, what companies really want. With all the information on hand and ready to be retrieved at any time, it is extremely easy for companies to reach only the right people and sell their products.

Furthermore, leveraging the cloud means that companies will always have up-to-date and social information on all aspects of their operations and customers. Likewise, it will be possible to hire experts and manage everything that is not part of the basic activities or operations. This will free up resources and help companies focus on the most vital aspect - operations. The best thing about a cloud-based CRM is that it connects everything to an organization. So it's easy to manage operations and track performance, even on the go or on the go.

In a sense, your business will benefit greatly if you decide to use a proven, feature-rich CRM system. It does not matter if you are a small entity or a large company, you will need operations and systems to be organized and optimized. You will need your business to benefit from Salesforce consulting services and grow by developing your capabilities and skills. Therefore, you should only rely on an expert or a certified partner so that the [company](https://www.cloudanalogy.com/) can benefit from the chosen CRM in the best possible way.
New Week StartUp
Tags: 100daysofcode, codenewbie, codequality
Published: 2020-09-28 07:23:47

Hi Everyone,
I am Syed Toqeer Abbas Desktop App Developer. Last week I am very tired due to some problems, on Sunday I set my workspace.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/rtjkg3iy8c671r4q136y.jpeg)

Today I start Work. hope you all are doing your best.
Best wishes to all of you.
What Are The Pros And Cons Of Digital Marketing Training
Tags: digitalmarketing, seo, socialmedia, sem
Published: 2020-09-28 07:18:54

Digital marketing is a relatively new field that focuses on enhancing the digital presence of a business and promoting the brand through different digital channels. With the launch, on-site engagement in events (such as sponsors, speakers, volunteers), PRs, and other outbound programmes, big corporations are excellent in creating excellent marketing campaigns that integrate inbound marketing. By providing cheap access to the mass market, digital marketing benefits enterprises of all sizes. Unlike TV or print advertising, it generates much-targeted advertisements. In digital marketing, there are also a number of concerns you should be aware of.https://ubldigital.in/Digitalmarketing
Autofit Rows using Macros (VBA) in Excel Office 365!!
Tags: autofitrowsusingmacr, vbamacros
Published: 2020-09-28 07:59:33

---
title: Autofit Rows using Macros (VBA) in Excel Office 365!!
published: true
date: 2020-09-28 07:07:56 UTC
tags: AutofitRowsusingMacr,VBAMacros
canonical_url: https://geekexcel.com/autofit-rows-using-macros-vba-in-excel-office-365/
---

## Autofit Rows using Macros (VBA) in Excel:

In this article, we are going to see the steps to **Autofit Rows using Macros in Excel Office 365** with an example. Let’s get into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)
## **Steps to Autofit Rows using Macros:**

To autofit rows in an Excel spreadsheet using Macros, follow the below steps.

- In the below example, you can see the rows that are not in the proper order. So we are going to autofit rows using the VBA & Macros.

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Example-8.png)<figcaption id="caption-attachment-14671">Example</figcaption>

- Go to the **Developer Tab,** choose the **Visual Basic** option in the **Code** section.

![Select Visual Basic option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Select-Visual-Basic-option.png)<figcaption id="caption-attachment-14664">Select Visual Basic option</figcaption>

- You need to activate the sheet where you want to autofit the rows.
- Now, enter the below code.

VBA code for autofit rows

Sub AutoFitAllRows()

Cells.Select

‘Now, you can see the result!!

Cells.EntireRow.AutoFit

End Sub

- You need to save the code by selecting it. Then close the window.

![Enter the Code](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Enter-the-Code.png)<figcaption id="caption-attachment-14666">Enter the Code</figcaption>

- Then, open the sheet that contains the data, and on the **Developer Tab, **** choose **the** Macros **option in the** Code** section.

![Choose Macros option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Choose-Macros-option.png)<figcaption id="caption-attachment-14667">Choose Macros option</figcaption>

- You have to make sure that your Macro is selected and **click** the **Run** button.

![Macro dialog box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Macro-dialog-box.png)<figcaption id="caption-attachment-14668">Macro dialog box</figcaption>

- Now, all the rows are automatically fitted in the Excel spreadsheet.

![Result](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/Result-7.png)<figcaption id="caption-attachment-14669">Result</figcaption>

## **Verdict:**

In this article, you can clearly understand the steps to **Autofit Rows using Macros in Excel Office 365** with an example. Leave your **suggestions** in the below comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Traefik 2.3 announced - New features Pilot, AWS ECS, and Kubernetes Ingress
Tags: devops, microservices, docker, kubernetes
Published: 2020-09-28 07:03:56

A few major events happened in the Traefik world last week. First, Traefik celebrated its 5th birthday. Incredible to see the Traefik journey. Considering the founder Emile created Traefik to solve a problem he was working on has now become one of the most popular Docker images on Docker Hub with over **2 Billion downloads**

Next, Containous the company behind Traefik rebranded itself to [Traefik Labs](https://traefik.io/blog/traefik-labs-incubating-the-future-of-cloud-native-networking ).
 . No more confusion and now all products in the Traefik Labs catalog align with easier branding.

Finally, [Traefik has released version 2.3]( https://traefik.io/blog/houston-we-have-plugins-traefik-2-3-announcement/). New in 2.3 is Traefik Pilot which is a SaaS solution connecting to your Traefik instance to monitor and alert on the health and security of your instance. Additionally, Pilot enables a new feature that allows for 3rd party plugins. Some other features that are now available in 2.3 include AWS ECS provider & Kubernetes IngressClass.

Have a look at the 2.3 Demo.

 

## Traefik 2.3 Demo
{% youtube LW5Z8Yaow-o %}


Interested in learning more about Traefik? I have a new [Traefik Training course available](https://www.thebyte.io/traefik-training).
GCP DevOps Certification - Pomodoro Three
Tags: devops, certification, sre, googlecloud
Published: 2020-09-28 06:57:49

# How Google see DevOps

Watching through the [video content](https://www.coursera.org/learn/site-reliability-engineering-slos/home/welcome) presented by [@lizthegrey](https://twitter.com/lizthegrey) and [@sethvargo](https://twitter.com/sethvargo) - they discuss the potential friction between developers and operations. Change vs Stability.

Thank god I haven't been explaining it wrong! 🤓 Well by this video at least.

Google outline DevOps as having 5 characteristics

* Reduce organisation silos

* Accept failure as normal 

* Implement gradual change

* Leverage tooling and automation

* Measure everything

# Moving on to SRE

Google think of Site Reliability Engineering in a similar manner to the way an object oriented class might implement an interface

```
class SRE implements DevOps
```

Specifically SRE's will 

* Share ownership of environments with developers (Reducing organisation silos)

* Service Level Objects and Blameless post-mortems (Accepting failure as normal)

* Reduce the cost of failure such as [Canary releases](https://blog.getambassador.io/cloud-native-patterns-canary-release-1cb8f82d371a) (Implementing gradual change)

* Eliminate as much manual work as possible (Tooling and automation)

* Measuring [TOIL](https://landing.google.com/sre/sre-book/chapters/eliminating-toil/) and system reliability (Measuring everything)

# Lets talk reliability

This part I love. Actually question how reliable your systems need to be and the inverse - what unreliability error budget is required.

#### 3 nines = 99.9% = 40mins over 28 day period

So thats just about enough for a monitoring system to spot an issue, alert someone and the human to take action. Depending on the root cause of course.

#### 4 nines = 99.99% = 4 mins over 28 day period

Now you're in to machine based detection and self healing world. Software updates and roll-outs probably need to be isolated to decoupled areas.

#### 5 nines = 99.999% = 28 secs over 28 day period

Good luck! There is even potential for your monitoring system to actually miss this amount of down time. Imagine if you're checking uptime every minute, you could have just missed your downtime issue and falsely reported that you are 'up'.

Now extend those thoughts to consuming public cloud services like Google Cloud. Introduce a support request round trip and you've likely consumed your reliability error budget. 

Super interesting thoughts on just how "available" does a system need to be and what implications does it have.

# The StayPuft Man

![Stay Puft Man](https://dev-to-uploads.s3.amazonaws.com/i/p81l6us4qnpevirscjai.jpg)

Ok I admit it - I couldn't help myself....today I ran one of the mock tests. You know just to understand my gaps.

I managed to get 7 out of 13 correct - about 53%. 

My gaps at this stage were around specific Google API's specifically within Stackdriver and recommended security practices. 

To anyone that has worked with me - that probably isn't new information #cowboy
How to query multiple indexes with elasticsearch in Spring boot(Java App)
Tags: java
Published: 2020-09-28 06:57:17

As we all know elasticsearch has indexes, that you can query to get data. That is simple with spring data configured or rest template. So, I came across a complex query I need to perform. So let see.
The Query I was to do on two user indexes on different types, having some similar data. So I did some r&d and got to know about multi-search queries.
Multi-search queries enable us to query two or more indexes, with queries for each index. Check out at the link below
[https://www.elastic.co/guide/en/elasticsearch/client/java-rest/master/java-rest-high-multi-search.html](https://www.elastic.co/guide/en/elasticsearch/client/java-rest/master/java-rest-high-multi-search.html)
<hr />

# My Solution
The solution multi-search API provided was good, but complex for my case, as I had different indexes but with the same fields in both like userId, id, name.
So I do use multi indexes but with a single search and single query. Let see.

# Steps

1.Create a method and initialize High-Level Rest Client(You can use directly in your main method too, I just prefer keeping separate code)
```java
 private RestHighLevelClient restHighLevelClient() {
        log.debug("RestHighLevelClient initialization");
        String esHost = // host of elasticsearch
        Integer esPort = // port of elasticsearch
        return new RestHighLevelClient(RestClient.builder(new HttpHost(esHost, esPort)));
    }
```
2.Search method with a query
```java
search(keyword: string) {
// Create a Bool query 
BoolQueryBuilder boolQuery = QueryBuilders.boolQuery();
boolQuery.must(query);
// Create a search request 
// pass your indexes in place of indexA, indexB
SearchRequest searchRequest = new SearchRequest("indexA", "indexB");
// CReate a search Source
SearchSourceBuilder searchSourceBuilder = new SearchSourceBuilder();
 searchSourceBuilder.query(boolQuery);
 searchRequest.source(searchSourceBuilder);
// Create object to get Response
SearchResponse searchResponse = restHighLevelClient().search(searchRequest, RequestOptions.DEFAULT);
// Parsing response 
SearchHit[] searchHits = searchResponse.getHits().getHits();
}
```
3.Parsing data from Search hit by looping
Just pass the fields and cast data type to get the expected response
```java
for(SearchHit hit: searchHits) {
   Map<String, Object> sourceAsMap = hit.getSourceAsMap();
   String field = (String) sourceAsMap.get("fieldName");
   Integer field2 = (Integer) sourceAsMap.get("fieldName");
}
```
4.This is how you can do the multi-search. Just replace your query, indexes as required, and parse data
> Note: You must be thinking about why we did not use any DTO instead. This is because, we require just 3 fields for now, which can be handled easily. We using JSONObject for this. You can create any class or DTO for parsing.

I hope it will help you, thanks for reading.

> Also, checkout [Tekraze.com](https://tekraze.com/2019/12/big-bi-trends-to-track-in-2020/) for more articles.
Sieve of Eratosthenes Algorithm to find Prime Number
Tags: algorithms, python
Published: 2020-09-28 04:16:34

**Sieve of Eratosthenes** is a simple and ancient algorithm used to find the prime numbers up to any given limit. It is one of the most efficient ways to find small prime numbers.

For a given upper limit **n** the algorithm works by iteratively marking the multiples of primes as composite, starting from **2**. Once all multiples of **2** have been marked composite, the multiples of next prime, **i.e. 3** are marked composite. This process continues until <b>p*p ≤ n</b> where **p** is the current prime number.

#####_Following is the algorithm of Sieve of Eratosthenes to find prime numbers._#####

**1.** To find out all primes under n, generate a list of all integers from 2 to n. 
######(Note: 1 is not a prime number)######
**2.** Start with a smallest prime number, **i.e. p = 2**
**3.** Mark all the multiples of p which are less than n as composite. To do this, we will mark the number as **0**.  *(Do not mark p itself as composite.)*
**4.** Assign the value of **p** to the next non-zero number in the list which is greater than **p**.
**5.** Repeat the process until **p*p ≤ n**

---------------------------------------------------------

**_Example: Generate all the primes up to 11_**

First thing to note is that do not mark prime themselves as composite.
**1.** Create a list of integers from 2 to 11. 

| 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11
|---|--|--|--|--|--|--|--|--|--|

**2.** Start with **p=2**
**3.** Since **2*2  ≤ 11**, continue.
**4.** Mark all **multiples of 2 as composite** by setting their value as **0** in the list.

| 2 | 3 | 0 | 5 | 0 | 7 | 0 | 9 | 0 | 11
|--|--|--|--|--|--|--|--|--|--|

**5.** Assign the value of **p**  to the next prime, **i.e. 3**
**6.** Since **3*3 ≤ 11** , continue.
**7.** Mark all **multiples of 3 as composite** by setting their value as **0** in the list.

| 2 | 3 | 0 | 5 | 0 | 7 | 0 | 0 | 0 | 11
|--|--|--|--|--|--|--|--|--|--|

**8.** Assign the value of **p to 5**
**9.** Since **5*5 ≰ 11** so we **stop** here.
_We are done! The list is:_

| 2 | 3 | 0 | 5 | 0 | 7 | 0 | 0 | 0 | 11
|--|--|--|--|--|--|--|--|--|--|

Since all the numbers which are 0 are composite, all the non-zero numbers are prime. 

Hence the prime numbers up to 11 are **2, 3, 5, 7, 11**
 

_Python program to print all primes smaller than or equal to a given limit using Sieve of Eratosthenes._

```python
n = int(input("Enter an integer number:"))
prime = [] # An empty list
for i in range(n+1):
    prime.append(i)
    
prime[0]=0
prime[1]=0   

p = 2
while (p * p <= n): 
    # If prime[p] is not changed, then it is a prime 
    if (p != 0): 
        # Update all multiples of p to zero
        for i in range(p*2, n+1, p): 
            prime[i] = 0
            
    p += 1

#print all element of list which are not zero
print("All the prime numbers up to", n, "are:")
for i in range(len(prime)):
    if (prime[i] != 0):
        print(prime[i], end=" ")
```

**OUTPUT:**
Enter an integer number:30
All the prime numbers up to 30 are:
2 3 5 7 11 13 17 19 23 29
Must-have Vim config
Tags: vim, linux
Published: 2020-09-28 06:44:50

![.vimrc](https://dev-to-uploads.s3.amazonaws.com/i/g7cnaqss3xufyeb8zx6t.png)
# Get the most out of Vim.
Vim is pretty great right out of the box but .vimrc settings are a simple way to elevate your enjoyment of vim and speed up your workflow.

```bash
:imap jj <Esc>
:imap kk <C-N>
  
:set tabstop=4
:set shiftwidth=4
:set expandtab
:set autoindent
:set number
:set term=screen-256color
:set pastetoggle=<f5>
 
:colorscheme 256_noir
```
Just drop these lines in a file called .vimrc file and save it to your home directory.

This config file includes the 256_noir Vim color scheme. You can download the scheme here:
https://github.com/andreasvc/vim-256noir

Drop this file here:
~/.vim/colors 

If this scheme doesn't work for you, you can omit the last line in the .vimrc file or download and use a different scheme.

As for mapping <Esc> to jj, I can't tell you how much this improves my workflow. Being able to quickly type jj instead of reaching for the esc every time I need to enter command mode is invaluable.

This is just the beginning. My .vimrc file is over 100 lines. Let me know if you want me to share it. I hope this helps get you started. Let me know what you think.
How to make your github profile more captivating
Tags: github, git, webdev
Published: 2020-09-28 06:36:07

Hey guys so inspired by this post i made this article do give it a read. 

{% link https://dev.to/madza/github-profile-as-a-portfolio-your-thoughts-3ci3 %}

so based on that i thought of making this little post about make your github page look smart. here is the screenshot of my page.

![](https://dev-to-uploads.s3.amazonaws.com/i/gr63ktiuckb6y80imnnp.jpg)

So yeah i am gonna tell you guys how i made that thing so lets start with basics make a repo and name it *exactly* as you github **username** now just add a README to it 

**NOTE: keep the repo public**

so when u will create it on the top right corner a option will appear 

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/3jflvwzc9i5qzwxgcr3n.jpg)

now press on share to profile and your readme will be available on ur profile Yay now lets edit it

*Here is a basic format you can try*

![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/mzzxdm66rxnkf4ay5xa0.png)

but if you want to make your profile like mine then u can see the source code of my read me on my github

Thanks for reading if you find this usefull drop a like ^-^
What is Database N0rmalizati0n???
Published: 2020-09-28 03:22:53

What's going on guys,
So for the past few weeks as you know I have been working with a Entity Relationship diagram mapping the risks of COVID-19. In my most recent video, I coded my tables using SQL and phpMyAdmin. This week I will be 'normalizing' my data.
Basically normalization is a technique for organizing your data in a database. This process is used to minimize redundancy in your data and ensure your data relates in a logical way. Technically, there are six stages to this process known as normal forms, but we'll only be focusing on the first three, as they are the most relevant. These forms continue to build off of each other.
### First Normal Form (1NF) ###
This step ensures that the data stored in the tables are identified with a primary key, there are no repeating groups, and data is stored in columns in its most reduced form.

### Second Normal Form (2NF) ###
The second step of the normalization process holds the same requirements as 1NF and adds that only data relating to a table's primary key is stored in each table.

### Third Normal Form (3NF) ###
The third and final step we'll discuss includes everything from 2NF and adds that there are no in-table dependencies between the columns in each table.

##### Applying Our Knowledge: #####
To start we'll be looking at the Location table. Off the bat, I can see that this is in violation of 1NF. As you can see, the table's primary key is associated with the zip code. Because the zip code is a unique identifier, it will always yield a country of origin, in this case, USA. This means the country column in this table is redundant and can therefore be removed. With this the removal of this column, our table now meets the 1NF requirements.
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/ebnwb5jm3884rrs9nqoa.png)

Next, we'll have a look at the Hospital table. This table meets the 1NF requirements, but when we get to the 2NF, it fails. We see there is a column whose data doesn't relate to the table's primary key. The primary key in this case is the HospitalID, a unique identifier for a particular hospital. The column in violation is 'Quantity'. Since the primary key is a unique identifier, asking how many hospitals in the area does not make sense. Instead, we can either remove the column completely or move it under the Location table. 
![Alt Text](https://dev-to-uploads.s3.amazonaws.com/i/0y8jmaoay77eyno34jfj.png)

That about sums up the work for this week. I posted the link to my video below where I quickly reviewed the three normalization steps and used the ALTER function in SQL to my the changes necessary to meet these requirements. Thank you and I'll see ya next week :)

https://www.youtube.com/watch?v=ngRU3mPXnG4
Stripe checkout setup and integration
Tags: stripe, livecoding, javascript, tutorial
Published: 2020-09-28 06:32:25

---
title: Stripe checkout setup and integration
published: true
description: Live coding of a Stripe checkout integration
tags: 
  - stripe
  - livecoding
  - javascript
  - tutorial
//cover_image: https://direct_url_to_image.jpg
---

Hello,

I just published a live coding session that I recorded to integrate Stripe into a website.

I'm focusing on a specific tool of Stripe called Checkout.

{% youtube rPdYt8CD2dA %}

I'm just starting with Live coding, so feel free to give me feedback on how to improve that :)