teleren/devto huggingface dataset:
Handcrafted: a beautiful dark theme for Nova and VS Code
Tags: theme, vscode, showdev
Published: 2020-09-23 14:13:06

Link: https://hand.engineering/handcrafted/

I am proud to announce the release of Handcrafted! A theme for Panic's new code editor Nova and Microsoft's VS Code.

I developed this theme using the CIELAB colour space, which means as colours shift in hue they maintain a relative brightness. The relationship between colours creates a sense of contrast and balance that is ideal for long stretches of programming.

**Download Handcrafted for Nova**: `nova://extension/?id=handengineering.Handcrafted&name=Handcrafted` (paste into your omnibar of choice)
**Download Handcrafted for VS Code**: [Download](https://marketplace.visualstudio.com/items?itemName=HandEngineering.handcrafted-theme&ssr=false#overview)

![VS Code Screenshot](https://dev-to-uploads.s3.amazonaws.com/i/13h1gibz16v0uniunw1j.png)

![Nova Screenshot](https://dev-to-uploads.s3.amazonaws.com/i/yuh74skjzw934763x5lu.png)
📣 Released v0.6 of GraphQL API for WordPress
Tags: graphql, api, wordpress, news
Published: 2020-09-23 14:06:40

This post was originally published [on my blog leoloso.com](https://leoloso.com/posts/released-version-06-graphql-api-for-wp-plugin/)

---

I have just released version 0.6 of the [GraphQL API for WordPress](https://github.com/GraphQLAPI/graphql-api-for-wp) 🎉. 

This is a mighty new version, with [several new features and improvements](https://github.com/GraphQLAPI/graphql-api-for-wp/blob/master/docs/en/release-notes/0.6.md):

✅ The **GraphiQL Explorer** has been **added to all the GraphiQL clients**, including the public ones</br>
✅ Added support for **GitHub Updater**, to enable self-updating when there's a new version</br>
✅ The plugin is **coded with PHP 7.4**, and can **run with PHP 7.1**</br>
✅ Introduced "**embeddable fields**", a custom GraphQL query syntax construct to enable templating and improve performance</br>
✅ **PHPStan** has been upgraded to **level 8** (the strictest level), reducing the change of bugs happening</br>
✅ Release notes are displayed within the plugin, after being updated</br>

👉🏽 Read the descriptions in detail [in the release notes](https://github.com/GraphQLAPI/graphql-api-for-wp/blob/master/docs/en/release-notes/0.6.md).

---

👉🏽 Install the plugin in your site: download [graphql-api.zip](https://github.com/GraphQLAPI/graphql-api-for-wp/releases/latest/download/graphql-api.zip), and in the wp-admin go to `Plugins` => `Add New` => `Upload Plugin` [to install it](https://github.com/GraphQLAPI/graphql-api-for-wp#upload).
A New Way to Collect, Organize, and Search Design Assets to Make More Productive with Eagle App
Tags: eagle, productivity, designer, developer
Published: 2020-09-23 13:53:57


Hello world, how are you today? I hope we're always fine.
Let me introduce my self, I am [Abdul Aziz Ahwan](https://youtube.com/AbdulAzizAhwanID), and I usually made tutorials video and share about productivity tools on my YouTube channel. And now I also want to share the productivity tool that I used.

As a designer, almost all of our time spent in collecting, organizing, and searching for our design assets. So, if we need our design assets, we need extra time to find them, because we are bad at organizing our design assets.

But as technology advances, now there's a desktop-based application called Eagle. Eagle is a powerful tool to collect, organize, and search our design assets efficiently. And the good news is, we can use it on Windows and macOS. Not only that, but we can also use it in almost all available browsers such as Chrome, Firefox, Opera, and Edge.

**Wow, that's amazing.** 👏

Then how great is Eagle in collecting, organizing, and searching for our design assets? From the website, Eagle's main features are:
* Collect our favorite images and inspirations
* Manage, organize, classify our images
* Find any images that meet our needs

First thing first we have to download Eagle, we can download it from the website [here](https://en.eagle.cool)

After you have installed, you can continue to watch this video to see how powerful the Eagle app is collecting organizing, and searching design assets.

_If you want to see How Eagle App works, you can watch the following video_

{% youtube coEFBOs2KGA %}
erpnext software
Published: 2020-09-23 14:03:59

erp software is one where every business affiliation currently familiar with, it is the most normally used business the board programming. erpnext is an open source and [best erp software in dubai](http://craftinteractive.ae/)  used by various associations in dubai and middle east. As erpnext is open source it can alter according to clients necessities . each business affiliation has its own rules and rules, so every office should run by the plan, in such conditions, adjusting erpnext is noteworthy , another piece of room of erpnext has various modules like HR and fund, arrangements and purchase, accounting, creating, CRM, etc the data development is similarly huge in business, erpnext can encouraged on fogs along these lines it is definitely not hard to get to data from wherever. erpnext assistant associations give utilization and planning on erpnext, ace says that you can diminish cost by executing erpnext, and now it is possible to move to erpnext from your present programming.
iTerm2 + Oh My Zsh + Dracula theme + Plugins
Tags: tutorial
Published: 2020-09-23 13:47:56

#**iTerm2 and Oh-my-zsh**

**Download iTerm2**
1.  Download iTerm2 for MacOs from [here ](https://iterm2.com/downloads.html)
2.  After downloading, drag and drop iTerm2 file to your Application folder.

**Install oh-my-zsh**
Open iTerm2 and run the following curl command which will install oh-my-zsh and replace default terminal with zsh.

    sh -c "$(curl -fsSL https://raw.githubusercontent.com/robbyrussell/oh-my-zsh/master/tools/install.sh)"

**Dracula Theme**
You can install using git:

    git clone https://github.com/dracula/iterm.git

**Activating theme**

1.  _iTerm2 > Preferences > Profiles > Colors Tab_
2.  Open the  _Color Presets..._  drop-down in the bottom right corner
3.  Select  _Import..._  from the list
4.  Select the  `Dracula.itermcolors`  file
5.  Select the  _Dracula_  from  _Color Presets..._

<img width="682" alt="Screenshot 2020-09-14 at 7 21 48 PM" src="https://user-images.githubusercontent.com/29995603/93095031-3ca7b900-f6c0-11ea-9216-ce10e7f73f14.png">


**Enabling Plugins (zsh-autosuggestions & zsh-syntax-highlighting)**

**Download zsh-autosuggestions using**

    git clone https://github.com/zsh-users/zsh-autosuggestions.git $ZSH_CUSTOM/plugins/zsh-autosuggestions

**Download zsh-syntax-highlighting using**

    git clone https://github.com/zsh-users/zsh-syntax-highlighting.git $ZSH_CUSTOM/plugins/zsh-syntax-highlighting

**To enable plugin, edit the ~/.zshrc file**

    vi ~/.zshrc
**Find plugin using `/plugin`  then press " i "  to enter INSERT mode and 
append zsh-autosuggestions & zsh-syntax-highlighting to plugins() like this**

```
.  
.  
.  
# Which plugins would you like to load? (plugins can be found in ~/.oh-my-zsh/plugins/*)  
# Custom plugins may be added to ~/.oh-my-zsh/custom/plugins/  
# Example format: plugins=(rails git textmate ruby lighthouse)  
# Add wisely, as too many plugins slow down shell startup.  
plugins=(  
  git  
  docker  
  zsh-autosuggestions 
  zsh-syntax-highlighting
)
```
**Run the following command to apply the changes**
```
source ~/.zshrc
```
<img width="682" alt="Screenshot 2020-09-14 at 7 22 06 PM" src="https://user-images.githubusercontent.com/29995603/93095188-6f51b180-f6c0-11ea-9ce1-ca8627cf084c.png">
Failed migration to ASP.NET Core
Tags: migration, aspnetcore, net, experience
Published: 2020-09-23 13:47:16

For a long time, our team was trying to migrate an ASP.NET Full Framework project to ASP.NET Core. But, the process failed because a dependency on SOAP web services. As a result, I decided to stop the process and wait for .NET 5, hoping it will help the situation.

The migration process started with a branch of latest version of the code. I changed the project file structure, enabled and configured the DI in whole project. Moved static files to the www directory. Changed the startup and made the EF to code first as the base project was using EF database first. Then changed signature of all API methods in controllers. Everything was working good till now. 

However, the project was heavily dependent on old school SOAP web services. This part created a long pause in the progress. .Net Core, in contrast with .Net full framework, does not work with configuration based WCF communication. As a result, I used code base configuration. In spite of the fact that I tested many use cases, I did not find a way to call the web services correctly. .Net core 3.x does not have support for WsHttp2007. Extensions does not have a good support too. I encountered many errors, so I asked a question on the [StackOverflow](https://stackoverflow.com/questions/63753342/wshttpbinding-on-net-core) to find a solution. Unfortunately, I did not received a correct answer after 18 days. Finally, I gave up, and decided to find another solution.

The new solution happened to be ASP.NET Core based on .Net Full framework instead of .Net Core. This way, I could move the web part to ASP.NET Core despite its root in Full Framework. Then I can be hopeful that I will change the framework from Full Framework to .Net Core in a later time. But, soon, I realized that ASP.NET Core 3.x can not be used based on Full Framework. On the other hand, using Full Framework, you are restricted to ASP.NET Core 2.x. This is not what we mean as being up-to-date.

So far, so good. As [.Net 5](https://github.com/dotnet/core/blob/master/roadmap.md) release is scheduled for just next 2 months, I decided to abandon the migration process till its release. Hoping that .Net 5 has a better support of legacy SOAP web services. As a plan B, I consider creating a proxy application behind IIS. I mean creating a regular .Net Full Framework application which can work with legacy SOAP web service, expose this functionality with something more modern, like web API. Then put it behind IIS and force the migrated ASP.NET Core (on .Net Core) to communicate with this proxy application instead of SOAP web services.
Let's build a complex product with no-code
Tags: nocode, startup, product
Published: 2020-09-23 13:38:48

---
title: Let's build a complex product with no-code
published: true
description: No-code tools like Webflow, Bubble, Adalo combined with automation tools such as Zapier or Integromat can create super-powerful products.
tags: nocode, startups, product
cover_image: https://dev-to-uploads.s3.amazonaws.com/i/musb8bno2b08b9sjg0k7.png
canonical_url: https://2.flexiple.com/no-vc-reports/i-want-to-build-a-product-but-have-no-coding-skills
---

Just a few years back, aspiring entrepreneurs would reach out to software agencies to build a product. Not anymore.

Today, I want to talk about building a complex product using no-code! The way to do it is to use the most popular "no-code stack". 

## What is it and what do they do?
a. Webflow: Build a beautiful website interface
b. Memberstack: Restrict access to certain pages to paid users
c. Airtable: Implement complex logic on top of data
d. Zapier Connect all the above tools

Don't worry, I go into quite some detail of each tool in the report (end of post). It also includes pro-tips to make the most of each of them draw from my experience of building tons of no-code products!

## Additional context
If you don't have a background in software development, that's not an issue at all. I have also recorded a short video to give you quick context on how it works :)

Also, I share my reports regularly on twitter - you can follow me there :)

{% twitter 1308751453322752000 %}

There is a lot more in here: https://2.flexiple.com/no-vc-reports/i-want-to-build-a-product-but-have-no-coding-skills. Do give it a read - it is just 5 mins long!
What is the purpose of Dockerfile and Docker-compose in development mode?
Tags: javascript, node, devops, docker
Published: 2020-09-23 13:34:22

---
title: What is the purpose of Dockerfile and Docker-compose in development mode?
published: true



tags: #javascript #node #devops #docker
//cover_image: https://direct_url_to_image.jpg
---
I am building a MERN stack app. but I am not sure about the benefit of dockerize it on development mode.
I saw many examples on github where there are separate Dockerfile on client and server folder and there is a docker-compose file where they import client and server services. but do I really need them? 

If I need then, how can I run command parallelly? suppose I need to build the backend in watch mode in one terminal and in another terminal I need to execute the yarn start command. How can I achieve that?
digital marketing and web designing
Tags: webdesign
Published: 2020-09-23 12:42:00

in this 21st century buying and selling through online is so common, especially now we can see an incredible impact on web shopping, it's unfeasible for anyone to head outside and purchase as they wish so more people favor electronic shopping and relationship, for all business offer online affiliations , by then a webpage page is major and it is in like manner key that your website page should recorded in first pages where people search something related to your business , we can sure one thing from our experience that website page shows in first pages will get more access and snap. Progressed publicizing is the technique used to make your page top in google posting,  and [digital marketing company in dallas](https://www.kotlerdigital.com/) will do it. for best result in computerized conveying you up moreover need to make a heavenly webpage page, that is web making sense of everything is the spot you need to give more thought, a website must contain enough information about your business information, contact nuances, you can likewise give a demo of your service using photos, stories, etc, while designing web pages it is always better to provide inner pages if you offer many services, that is including many details in one page will make website more complicated and inner pages avoid such situations.
How to clone a GitLab repository after enabling 2FA
Tags: git, gitlab, 2fa
Published: 2020-09-23 12:25:55

I've recently started to enable **2FA** (Two Factor Authentication) on most of my online accounts, including [**GitLab**](https://www.gitlab.com). But what happen when you try to *clone* a repository against https after that?

When I tried the first time I run the usual git clone:
```
 git clone https://gitlab.com/username/project.git
```
but it didn't work, giving me this output:
```
Cloning into 'mypersonalbalance'...
remote: HTTP Basic: Access denied
remote: You must use a personal access token with 'read_repository' or 'write_repository' scope for Git over HTTP.
remote: You can generate one at https://gitlab.com/profile/personal_access_tokens
fatal: Authentication failed for 'https://gitlab.com/f.peluso/mypersonalbalance.git/'
```

I googled a little bit, finding that the problems was the 2 factor authentication, and then I found the following solution:
1. Log in into the GitLab account;
2. Go to the Settings section (at the moment, top right, hover the profile image and wait for the menu);
3. Go to `Access Tokens`;
4. Now here you can create a temporary token; if you need to pull/push you must enable *read_repository* and *write_repository* flags.
5. A token is shown in the page. Don't close or refresh the page, or you won't be able to retrieve the same token again!!!
6. Save the token somewhere safe if you need to use it more than once (I needed only once, so I just copypasted it, and then deleted it).

After these steps you can clone the repository using
```
git clone https://oauth2:PERSONAL_ACCESS_TOKEN@gitlab.com/username/project.git
```
where `PERSONAL_ACCESS_TOKEN` is the token you retrieved before.

GitLab explains that the tokens act like passwords after one enables the 2FA, so, in order to improve your security, you can manage one of more tokens to work with different repositories, devices and applications.
Delete All Sheets Except Current/Active One from Workbook in Excel!!
Tags: deleteallsheetsexcep, kutoolsexceltutorial, kutools
Published: 2020-09-24 03:39:09

---
title: Delete All Sheets Except Current/Active One from Workbook in Excel!!
published: true
date: 2020-09-23 12:24:23 UTC
tags: DeleteAllSheetsExcep,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/delete-all-sheets-except-current-active-one-from-workbook-in-excel/
---

## Delete All Sheets Except Current/Active One from Workbook in Excel:

In this article, you will learn the steps to **Delete All Sheets Except Current / Active One from the Workbook** in **Excel Office 365** using **Kutools**. 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)

**Note:** [kutools for Excel](https://geekexcel.com/get-kutools-for-ms-excel-2019-2016-2013-2010-2007-office-365/) has more than 180 features which are used to complete the difficult task with several clicks. If you want to use Kutools, you need to install it from Excel’s official website.

## **Steps to Delete All Sheets Except Current/Active One from the Workbook:**

To delete all sheets except the current or active sheet from the workbook in Excel, do as follows.

- You need to activate the sheet that you want to keep in the workbook.
- Then, go to the **Kutools Plus Tab,**  **select** the **Worksheet** option, **choose**  **Delete**  **All Inactive Sheets** from the menu.

![Choose Delete All Inactive Sheets option](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/2-84.png)<figcaption id="caption-attachment-14545">Choose Delete All Inactive Sheets option</figcaption>

- Now, **Kutools for Excel dialog box** will be popped out to tell you whether you want to delete all sheets except the active sheet, you need to **click** the **OK** button.

![Kutools for Excel Dialog Box](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/3-44.png)<figcaption id="caption-attachment-14546">Kutools for Excel Dialog Box</figcaption>

- After clicking the Ok button, it will delete all the sheets in the workbook except the active sheet.

### Added Information:

- You cannot use **undo** to recover the deleted sheets from the workbook.
- So, you need to back up the current workbook or click track a snap option for the current workbook before applying this feature in Kutools.

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

## **Conclusion:**

In the above article, you can clearly understand the steps to **Delete All Sheets Except Current / Active One from the Workbook** in **Excel Office 365** using **Kutools**. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!
Help figuring out the architecture of the application 
Tags: help, beginners, graphql, architecture
Published: 2020-09-23 12:20:29

I posted a while ago a short article expressing my desire to do some open-source projects.
While I've been using the time to publish some stuff on my GH page, now I believe I'm finally ready to start working on my idea. 

If only I knew where to start... 

I want to create an application where the user uploads a code bar from a soft-drink bottle, the code is translated to a string, the image discarded and based on the string some queries on the DB.

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

This is the short version of it. The front-end can be anything, but I will probably go for Gatsby or Gridsome.

For the back-end, I just need some easy API where I can create some CRUD entities, do some queries (POST / GET) and throw a json back.

Here are my questions:

1. What would be the easiest way to create such an API, host and deploy it? I was thinking of a Graphql API on NodeJs. (mostly because it looks like something fun to learn). But I have no experience creating a full API back-end.

2. How can I upload an image "somewhere", fetch the barcode string from it and then discard it? (I have no use to save it)

Any advice on how to plan all these and get started would be greatly appreciated.
Count the Number of Bold Cells in a Range in Excel Office 365!!
Tags: countthenumberofbold, kutoolsexceltutorial, kutools
Published: 2020-09-24 03:38:29

---
title: Count the Number of Bold Cells in a Range in Excel Office 365!!
published: true
date: 2020-09-23 12:17:24 UTC
tags: CounttheNumberofBold,KutoolsExcelTutorial,Kutools
canonical_url: https://geekexcel.com/count-the-number-of-bold-cells-in-a-range-in-excel-office-365/
---

## Count the Number of Bold Cells in a Range in Excel:

In this tutorial, we will guide you to learn the steps to **Count the Number of Bold Cells in a Range in Excel Office 365** using **Kutools**. 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 Count the Number of Bold Cells in a Range:**

To count only the number of bold cells in a range, do as below instructions.

- If you have a data range like the below example image and you need to find the total count of the number of bold cells from the range, do as follows.

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

- You need to **select a blank cell** to display the result.
- On the **Kutools**  **Tab** , **select** the **Kutools**  **Functions** option, **choose** the  **Statistical &**  **Math** option, and **choose the COUNTBYFONTBOLD** option from the menu.

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

- It will open the **Function**  **Arguments**  **dialog box.**
- You need to **click the button** given in the **Reference**  **box** and **select** the **input range**.

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

- Then, hit the **OK**  **button** to get the result as shown in the below screenshot.

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

## **Summary:**

In this article, you can clearly understand the steps to **Count the Number of Bold Cells in a Range in Office 365** using **Kutools ** with an example. Leave your **feedback** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!