teleren/devto huggingface dataset:
Why I want to use JSON in LibreOffice Calc.
Tags: libreoffice, calc, extensions, json
Published: 2019-06-11 07:47:02

---
title: Why I want to use JSON in LibreOffice Calc.
published: true
description: LibreOffice Calc SpreadSheet extensions JSON
tags: LibreOffice,Calc,extensions,JSON
---


Recently, Web Service exports JSON.
It is not SOAP, not XML.
Web Data is JSON.

- Address search from PostalCode
- Weather

....etc

If Calc can use JSON and WebAPI,
Calc borrow Functions from Web.

Use Python, It is easy.
Is it need to use by calc?

No.
Office Worker don't use Python.
They said.
VLOOKUP is wonderful!
VBA is awesome!
Python?  what's?
I'm not a Programmer.

It is need to deal JSON and WebAPI in Calc for us.

Excel can use JSON.
[Connect to a json file](https://support.office.com/en-us/article/connect-to-a-json-file-f65207ab-d957-4bf0-bec3-a08bb53cd4c0?ui=en-US&rs=en-US&ad=US)
LibreOffice don't have this function.

You make this function.

So, I develop underline Calc extensions.

- [GetRest Function](https://github.com/arachan/getrest)
- [ParseJSON Function](https://github.com/arachan/parsejson)

It may be not enough.
ParseJSON don't work :-(

Finally, I want to make Calc Standerd Function them.
Explain Asynchronous task running Like I'm Five
Tags: explainlikeimfive
Published: 2019-06-11 07:28:30

---
title: Explain Asynchronous task running Like I'm Five
published: true
tags: explainlikeimfive
cover_image: https://thepracticaldev.s3.amazonaws.com/i/nfn9wubobllzxfr9xt9k.png
---

I am working on Django web app and felt need of asynchronous task running with Celery and RabbitMQ. Will you please explain me how that works?
Bento-starter v1.0.0 is out ✨ (#PWA, #boilerplate, #vue.js, #firebase)
Tags: javascript, webdev, vue, opensource
Published: 2019-06-11 07:03:34

---
title: Bento-starter v1.0.0 is out ✨ (#PWA, #boilerplate, #vue.js, #firebase)
published: true
description: Bento-starter new release
tags: #javascript #webdev #vue #opensource
cover_image: https://user-images.githubusercontent.com/9840435/59188068-17e89b80-8b77-11e9-9b06-7a5d791ce415.jpg
---
:bento: [**bento-starter**](https://github.com/kefranabg/bento-starter) is an Open-Source Full-Stack boilerplate solution that helps you to build fast and maintainable web applications using tools like Vue.js, Firebase, Progressive Web Apps support, dynamic offline support... The goal of this project is to provide a powerful and well configured stack (with CI/CD, hosting...) so you can focus on writing your web application very quickly. 

If you want more information about the bento-starter stack, please refer to this article : https://dev.to/kefranabg/a-productive-stack-for-pwa-development-27o

**Some news about the v1.0.0 : **

* ✨ Update service worker workflow has been improved  
* ✨ A setup command has been added to make install step easier
* ✨ A bento-starter slack has been created : [join here](https://join.slack.com/t/bento-starter/shared_invite/enQtNjE5OTI5MzQyMTE3LTVjYjM3YjMzMGQ4NjgzYzY5YWMwNDkyY2VmMzg4ODg0OTkwZDRhMzg3OWU0MGY1MGYwMmVjYThiMmU2YzBjODY
)
* 🐛 3 bug fixes
* Full changelog is available [here](https://github.com/kefranabg/bento-starter/blob/master/CHANGELOG.md)

## Links :
Github: https://github.com/kefranabg/bento-starter
Documentation: https://bento-starter.netlify.com/ 
Demo : https://bento-starter.firebaseapp.com
Logic & Problem Solving
Tags: codenewbie, discuss, javascript
Published: 2019-06-11 06:56:53

---
title: Logic & Problem Solving
published: true
description: 
tags: #codenewbie #devdiscuss #JavaScript #Reactjs
---

What are some of the tips and tricks you for logic and problem solving in programming as a beginner? How do you put pieces together to create one project without necessary going back to a YouTube or a udemy tutorials? What should you know?
What is your daily source of information?
Tags: discuss, programming, news
Published: 2019-06-11 06:54:14

---
title: What is your daily source of information?
published: true
description: Looking for feedback from the community
tags: discuss, programming, news
cover_image: https://wikieducator.org/images/3/38/ILWordCloud.PNG
---

So just a few days ago I deactivated most of my social media accounts and now only use Twitter (but trying to lower the usage of it as well). So one thing I noticed is that when ever I'm bored or have any free time I will take my phone and try to open either fb or twitter to scroll trough to just kill the time.

So as you can image that isn't very productive nor does it help me in any way. 

So I wanted to hear from you guys what are some of your favorite websites you like to visit to catch up on the latest news (preferably tech stuff), educational sites, podcasts and any other sites/apps you like to use to try and get the latest information and/or improve your knowledge and skills ?

If you are also signed up for some newsletter that you actually wanted to receive please do include them in your comments. Or any other link you think someone might find useful.

Since I was spending so much time on social media I thought I always knew what was happening but that was far from reality. So I decided to change some old (bad) habits and try and work on my self more.  

These are some of the sites I visit:
   - Twitter
   - Dev.to
   - Devrant
   - TheHackerNews.com
   - My local newspaper (which has low to almost no interesting content about IT)


Thank you all :)

___
<sub><sup><a href="https://wikieducator.org/INFOSEEK" target="_blank">Image source: wikieducator</a></sub></sup>
Popups in Drupal 8? No problem!
Tags: drupal, webdev, opensource, discuss
Published: 2019-06-11 06:37:55

---
title: Popups in Drupal 8? No problem!
published: true
description: Drupal 8 is here and everyone is excited about it. There are too many features and add-ons to explore. However, this one focusses only on overlay / popup i.e. provide a simple and easy implementation. With this blog, I aim to explain the basic implementation of how to create a popup of your own.
tags: drupal,webdev,opensource,discuss
---
Drupal 8 is here and everyone is excited about it. There are too many features and add-ons to explore. However, this one focusses only on overlay / popup i.e. provide a simple and easy implementation. With this blog, I aim to explain the basic implementation of how to create a popup of your own.

Before learning to implement popup, let us briefly go through the drupal 8 routing system.

If you already know about the routing system, you can skip this section and if you don't I assume you still know at least the basics of Drupal 8. I have a page which has a table display of some data. On top of this page, I'll provide a link which will open a form in popup.

Now, let's start with the steps.

At first, we create a routing link where we show a table with some content.

hollywood.view_movie:

 path: '/movies-list'

 defaults:

   _title: 'Movie List'

   _controller: '\Drupal\hollywood\Controller\MovieList::overview'

 requirements:

   _permission: 'movies list'

[Read more!](https://www.innoraft.com/blogs/popups-drupal-8-no-problem)
Django
Tags: django, webframe, pythondjango
Published: 2019-06-11 06:23:05



Django is a web framework which helps you build interactive websites using Python. With Django one can define the kind of data site needs to work with, and define the ways  users can work with that data.

It’s usualy best to install Django to a virtual environment, where project can be isolated from other Python projects. 

 Create a virtual environment 
$ python –m venv ll_env 
Activate the environment (Linux and OS X) 
$ source ll_env/bin/activate 
Activate the environment (Windows) 
> ll_env\Scripts\activate 
Install Django to the active environment 
(ll_env)$ pip install Django
Sign in with Apple – Node.js library
Tags: webdev, apple, javascript, node
Published: 2019-06-11 06:21:28

Created my first Node library today that allows you to implement "Sign in with Apple" in your Node.js apps!

I realized that no one made a working version till now, so I decided to spend an all nighter getting this out. Hope y'all like it! :)

https://github.com/ananay/apple-auth
https://www.npmjs.com/package/apple-auth
If your ISP blocked the VPN you used
Tags: vpn
Published: 2019-06-18 07:36:41

---
title: If your ISP blocked the VPN you used
published: true
tags: VPN
canonical_url: https://kevinhq.com/if-your-isp-blocked-the-vpn-you-used/
---

What to do when your Internet Service Provider (ISP) blocked the VPN you used? Just one thing, don’t ask them about this since you will

[Continue reading your ISP blocked the VPN you used](https://kevinhq.com/if-your-isp-blocked-the-vpn-you-used/)

The post [If your ISP blocked the VPN you used](https://kevinhq.com/if-your-isp-blocked-the-vpn-you-used/) appeared first on [kevin's tech blog](https://kevinhq.com).
5 SEO tips to improve  Google search results
Tags: webdev
Published: 2019-06-17 07:27:57

---
title: 5 SEO tips to improve  Google search results
published: true
tags: Web Development
canonical_url: https://theworldwidecode.com/blog/2019/5-seo-tips-to-improve-google-search-results/
---

5 SEO tips to improve  Google search results
The ultimate guide to set up your Angular library project
Tags: typescript, automation, javascript, angular
Published: 2019-06-17 19:26:14

---
title: The ultimate guide to set up your Angular library project
published: true
tags: typescript,automation,javascript,angular
canonical_url: https://medium.com/@kevinkreuzer/the-ultimate-guide-to-set-up-your-angular-library-project-399d95b63500
---

#### Automated code formatting with Prettier & Husky, test coverage reports, deployed showcase and fully automated releases with Travis CI for your Angular library

![](https://cdn-images-1.medium.com/max/1024/1*pIDAs7gTgnIE6fZ9_QT0gQ.png)

Angular is such an awesome framework, and we all love it 😍 It’s a complete tool kit that helps us build amazing stuff.

And it gets even better. Angular also contains a great community. A community which continually grows and pushes Angular forward.

Therefore, it is not surprising that the framework has a massive ecosystem around it. From useful services to fully featured component libraries, the Angular ecosystem provides it all.

So nothing is impossible. Do you have an idea for a cool angular library? Then go on, participate, implement your library, and share it with the world! 🌎

### What you will learn 👨‍🎓

The newest Angular versions already has excellent support for the creation of libraries. However, developing and testing is only one part when creating your Angular library. Another part is shipping the artifact. 🚢

Delivering software requires some steps; we need to run tests, build our artifact, publish it, update the project with the release assets, and document the release.

A software engineers we tent to automate recurring manual steps. So that’s what we are going to do here. Automating the release of an Angular library is not an easy task. Especially not, if you not only want to automate the release but also the handling of the release assets.

This blog post tents to give you an ultimate guide on a fully automated and complete setup for your Angular library. It covers many topics and may, therefore, be best read in multiple goes.

So, without further ado, let’s grep a ☕ and [jump right into it!](https://medium.com/@kevinkreuzer/the-ultimate-guide-to-set-up-your-angular-library-project-399d95b63500)
Building Dev.to native iOS application
Tags: ios, swift, challenge
Published: 2019-06-11 05:29:42

---
title: Building Dev.to native iOS application
published: true
tags: iOS, Swift, challenge
---

Hello Guys, I have started a project to build a native iOS application for this website (In progress), I know there is already an iOS version, but it's just a web view.

 I am very open for feedback and contribution.

🧐 Why am I building this?
- Having Fun
- Working with RxSwift.
- MVVM + Coordinator.
- Exploring Dev.to and its API
- Dependency injection (Swinject)
- Just Code - No Storyboards 🤓


![](https://thepracticaldev.s3.amazonaws.com/i/a3el9xgjlbqzhrshkhoh.png)

You can check the code here: https://github.com/hadiidbouk/DevTo.iOS
Criando Simples Server PHP
Tags: php, serverphp, server
Published: 2019-06-11 05:16:03

---
title: Criando Simples Server PHP
published: true
description: 
tags: php, serverphp, server
---

Para rodar o PHP precisamos colocar o arquivo .php em um server local, por exemplo, para que possamos visualizar o arquivo no browser. E quando iniciamos nossos estudos em PHP somos instruídos a usar ferramentas como Apache, XAMP, WAMP, LAMP etc. O momento de programar torna-se um pouco mais enfadonho pois sempre é preciso carregar uma destas ferramentas citadas apenas para de repente testar um arquivo…

O iniciante talvez não saiba que quando o PHP é instalado, uma ferramenta também nos é dada que é a possibilidade de poder criar um server usando o php (somente) em um prompt do Sistema Operacional.

Para fazer isso no Windows é preciso que o PHP esteja adicionado à variavel de ambiente path. No Linux é bom que o PHP seja instalado pelo terminal assim ficará acessível facilmente no shell.

Após as devidas configurações, poderemos criar um server em qualquer pasta/diretório do Sistema Operacional. Digamos que exista o diretório /Documentos/php e que dentro deste diretório criemos um arquivo chamado index.php. Para rodarmos esse arquivo precisaremos abrir o prompt, navegar por ele até a pasta que estamos tomando como exemplo e executar o comando:

php -S localhost:777

![](https://thepracticaldev.s3.amazonaws.com/i/nxknufe3su02fjd5h24p.png)

onde 777 é uma porta que eu escolhi mas que você poderá escolher livremente desde que esta porta não esteja sendo usada por outra ferramenta do Sistema. Após fazer isso é só ir no navegador e digitar localhost:777 que contém a mesma porta passada no comando do prompt. Assim automaticamente será carregado o arquivo index.php no diretório onde o server foi criado (o arquivo index.php sempre será o arquivo padrão de carregamento PHP).

![](https://thepracticaldev.s3.amazonaws.com/i/5ep7e569vlox0h4qvbvw.png)

Se um arquivo com outro nome que não seja index.php estive no diretório e você quiser carregá-lo no browser, você deverá passar a url localhost:777/nome_do_arquivo.php onde “nome_do_arquivo” é o nome do arquivo o qual você deseja carregar no browser.

Este server php pode ser criado em qualquer lugar que você queira e isso é muito bom, diferentemente das ferramentas como LAMP que criam um server em local específico.

No Linux você tem que levantar o server php como super usuário.

Espero que estas dicas ajudem você a ter uma maior praticidade na hora de testar seus scripts no browser!

Até a próxima!
Debugging PHP application in Vagrant by Xdebug & VSCode
Tags: xdebug, vscode, vagrant
Published: 2019-06-11 04:47:29

## Notes

* Follow all steps to set up for VSCode.
* Follow 1, 2, 5 to set up for a server (required for any debugger tool).

## Requisites

* PHP >=5.3 in CentOS 6.x
* Your PHP project is running in Vagrant
* The Vagrant instance in this tutorial running on CentOS 6
* Host machine in this tutorial is Windows 10
* VSCode, of course!

## Install & configuration Xdebug in Vagrant

* Access root permission by command

```bash
sudo -i
```

* Run below commands in Vagrant

```bash
rpm -Uvh http://rpms.famillecollet.com/enterprise/remi-release-6.rpm
yum install --enablerepo=remi --enablerepo=remi-php56 php-pear php-devel -y
pecl install xdebug
service httpd restart
```

* Add configurations for XDebug in the end of `/etc/php.ini` file

```ini
zend_extension=/usr/lib64/php/modules/xdebug.so
[XDebug]
xdebug.remote_enable=1
xdebug.remote_autostart=1
; Host machine of Vagrant instance
xdebug.remote_host=10.0.2.2
xdebug.remote_connect_back=1

; Another xdebug configuration (in php.ini) set to profiling source code (optional). [Read more](https://xdebug.org/docs/profiler).

; xdebug.profiler_enable_trigger=1
; xdebug.profiler_output_dir=/vagrant/profiler
```

* Open `.vscode/launch.json` or (button setting for debug mode in VSCode), configure it like this below:

```json
{
    "version": "0.2.0",
    "configurations": [
        {
            "name": "Listen for XDebug",
            "type": "php",
            "request": "launch",
            "serverSourceRoot": "/var/www/your_website",
            "localSourceRoot": "${workspaceRoot}",
            "port": 9000,
            "log": true
        }
    ]
}
```

## Install PHP Debug for Visual Studio Code

* Search the extension as name PHP Debug, install it

## Problem with Firewall

There may be a problem with the OS firewall.

Solve: In Windows, access `Control Panel\System and Security\Windows Firewall` >> Choose to `Allow an app or feature through Windows Firewall` > Check both options (Private/Public network) for VSCode (or PhpStorm).

## Relate topics

[Configuring Visual Studio Code for PHP Development](https://blogs.msdn.microsoft.com/nicktrog/2016/02/11/configuring-visual-studio-code-for-php-development/)
What do you do when you can't write something in a clean way?
Tags: discuss, stuck
Published: 2019-06-11 04:35:25

---
title: What do you do when you can't write something in a clean way?
published: true
description: 
tags: discuss, stuck
---

When you've been stuck trying to figure out how to write something in a clean and SOLID way, and it's been taking more time that you'd like, what do you do? Do you give up and allow yourself a bit of messiness, or do you do something else to figure it out?
It's OK to Change Your Mind
Tags: change, writing, planning
Published: 2019-06-11 03:33:22

---
title: It's OK to Change Your Mind
published: true
description: I change my mind so often. Maybe it's a curse, but it's usually a sign of something bigger.
tags: change, writing, planning
cover_image: https://thepracticaldev.s3.amazonaws.com/i/eeen3nsks27i0k9gkz5c.jpg
---

Last week, I was feeling [fired up and ready to go](https://youtu.be/5AhRqg0ADbk). I wrote a whole post about some exciting things and plans.

{% link ashleemboyer/good-news-textua11y-updates-and-my-plan-for-future-writings-4g6e %}

But here's the thing: I've thought some more about my plans for writing, and I'm changing my mind. Let me get into the "why". The plans I made were way too strict for me. This is probably because of the spontaneous nature of [my recent 30-day blogging challenge](https://dev.to/ashleemboyer/after-30-days-of-writing-on-dev-to-a08), but I think it also has to do with deadlines.

For more than 80% of my life, I've dealt with a whole lot of deadlines. That's two decades! Don't get me wrong, I don't think deadlines aren't something we can totally get away from. I do think we can dramatically reduce the number of deadlines we encounter, however.

So, that's what I'm doing. Here's my new plan:

> I'll be blogging 4 days a week: Monday through Thursday.

How's that different from what I originally planned? Well, I wanted to write a bit more about the things I'm learning in my Software Architecture course, but:

1. Making half of my posts about it is way too much
2. I would love to "teach" technical material, but Software Architecture isn't where my passion lies

Today's post was "supposed" to be about Software Architecture, as a matter of fact, but writing it to my standards was far more stressful than it needed to be. I'd rather save that energy for something I plan to immerse myself in by choice, not because I have to.

Here's the moral of the story: you can change your mind whenever you want to. I was a little nervous about changing my mind on this because I really was excited to write about Software Architecture. Some people showed interest in it, and I also don't want to appear like I'm not holding my word or something.

But then I remembered: I *started* blogging for *me*. People finding value in what I write is an added benefit! Of course, I still want people to enjoy reading what I write, but I also need to enjoy what I'm writing or I'll burn right out.

You are your primary stakeholder. Keep doing the things you enjoy, and if you're not enjoying what you're doing, give it your very best shot to turn that around.

---

Did you know I have a newsletter? 📬

If you want to get notified when I publish new blog posts or make major project announcements, head over to [https://ashleemboyer.com/newsletter](https://ashleemboyer.com/newsletter).

---

[Image](https://unsplash.com/photos/ixZqFkb-iPY) by [Beth Ireland](https://unsplash.com/@bethirelandphotography) on [Unsplash](https://unsplash.com)
Make a Dataflow Editor with Vue
Tags: vue, opensource, javascript, contributorswanted
Published: 2019-06-11 03:00:40

Hello, folks! I’ve published a dataflow graph editor made with Vue. It’s based on [ghostiam/Vue-blocks-Vue-blocks](ghostiam/Vue-blocks-Vue-blocks) project.

I receive opinions, questions and PR. ;)

github: https://github.com/krthr/vue-dataflow-editor
npm: https://npmjs.com/package/@krthr/vue-dataflow-editor
docs: https://krthr.github.io/vue-dataflow-editor/
What do you think of VS Code's new remote extensions?
Tags: discuss, vscode
Published: 2019-06-11 01:42:29

[Visual Studio Code Remote Development](https://code.visualstudio.com/docs/remote/remote-overview) allows you to use a container, remote machine, or the Windows Subsystem for Linux (WSL) as a full-featured development environment.

For those of you who have used this, what do you think?

If you haven't used it, does it interest you? Why or why not?
A Mind map on Spring Framework
Tags: spring, mindmap
Published: 2019-06-11 01:40:17

This is one of the experiment I started couple of years ago, and it's really helpful. When you take notes and read it again, it might be boring but if you put notes as a mind map, you will love to read it again again.

This piece is a trail in this platform, let me know your thoughts about this.

![](https://thepracticaldev.s3.amazonaws.com/i/iubimqtspks31xse35b8.png)
What type of monitor(s) and setup do you use for software development?
Tags: discuss
Published: 2019-06-11 00:42:02

---
title: What type of monitor(s) and setup do you use for software development?
published: true
description: A discussion on monitors for software development.
tags: discuss
---

I'm curious to see what everyone is using. Do you roll with one monitor to keep the extra noise down? Do you use two 23" monitors side-by-side? Do you have one of your monitors turned in portrait mode? Does your setup look like something out of Swordfish? Let's discuss!
How to negotiate sponsorship deals?
Tags: help
Published: 2019-06-11 00:09:09

---
title: How to negotiate sponsorship deals?
published: true
tags: help
---

Hey,

I have a problem; but a good one! I've been chatting with a bootcamp about becoming a community sponsor for http://CodeCareer.io  & #301DaysOfCode but I have no clue what to ask for in return. 

Any advice on how to structure a deal with a partner / sponsor? 

Best, 
Ben
[Video] Hitchhiker's Guide to Web Standards
Tags: cascadiajs2018, videos, javascript
Published: 2019-06-10 23:44:41

---
title: [Video] Hitchhiker's Guide to Web Standards
published: true
description: Web standards and their corresponding organizations can be your best friend, and extremely daunting at the same time. As a web developer, you are in the unique position of being able to influence the platform you develop on every day - so come and learn how the world of web standards works, how to contribute to the web standards community, and about some of the latest platform trends.
tags: cascadiajs2018, videos, javascript
cover_image: https://pbs.twimg.com/media/DtM87aIU0AMyD94.jpg:large
---
*As we lead up to [CascadiaJS 2019](https://2019.cascadiajs.com), I'm going to share the 24 amazing talks from 2018 here on dev.to. Sit back and enjoy the show!*

![Dominic Farolino](https://2018.cascadiajs.com/speakers/dominic.png)

Web standards and their corresponding organizations can be your best friend, and extremely daunting at the same time. As a web developer, you are in the unique position of being able to influence the platform you develop on every day - so come and learn how the world of web standards works, how to contribute to the web standards community, and about some of the latest platform trends.

https://www.youtube.com/watch?v=z2SbknMWtp0