Posted on

Google Drive and Debian integration on HyperV

I am helping one customer with their VPS and they use primarily Google Drive for data management. So the idea poped up in my head…

What if I could grab some files from the VPS server and push them straight into their G-Drive?

This could provide an opportunity for backing up required data from VPS but also push certain data back into VPS without a need for FTP. Hmm…

As an example: you could upload product images for the online shop, where user simply drops them into Google Drive and the rest of the work gets automated on the server with CRON and custom scripts. Same can be done for updating stock via XML files and more.

In this article, I will focus on getting the integration working and leave the rest for your imagination. However, if you would want to know more about the automation part on the server, have even better idea, just leave me a message on LinkedIn or e-mail me. Now let us dive into it.

Running Debian on HyperV 

Although my personal preference is Ubuntu, I decided to play with Debian on my local PC to test the Google Drive integration. I used Hyper-V and Debian-10.1.0-i386-netinst.ISO. My laptop specs: T440, 256GB SSD, 12GB RAM.

First problem, ISO is not booting – getting PXE Boot issue = I create new VM with GEN1 and we are ready to go. Here are more tips on how to run Linux on HyperV

Second problem, screen size/resolution of the VM. Hyper-V does not control this, instead the VM is in charge. Everyone probably knows how to change the resolution in Windows 10/7 using GUI, but since I have Debian with no GUI, CLI will become my friend for today. So for Debian, you need to edit grub file like this: 
sudo vi /etc/default/grub

In particular, this line:

GRUB_CMDLINE_LINUX_DEFAULT="quiet splash video=hyperv_fb:1024x768"

I am using laptop T440, so 768px vertical is just ok. If you have to update the grub, reboot and off you go. 

sudo update-grub

Note: If you are not familiar with VI editor (I use usually VIM), just follow the manual – VI basics


Third “problem”, quite annoying with Linux and HyperV is missing copy / paste feature. You certainly do not want to type all stuff and links manually. Forget about Hyper-V VMConnect then and connect to your VM via SSH (use Putty for example). That way you can copy paste, no drama. There are other options, but this one is by far the easiest, I reckon. 

To connect, you will need its IP address, so use a bridge mode (external switch). This will expose the VM to the internet too, so keep that in mind and put ideally a firewall in between. To connect:

ssh root@IP_OF_YOUR_VM

Fourth “problem”, you cannot connect. By default root has remote ssh turned off. To turn it on: connect as per usual using VMConnect, open:

vi /etc/ssh/sshd_config

Remove # symbol from the line below and change to “yes”, like this:

PermitRootLogin Yes

Don’t forget to restart the SSH:

/etc/init.d/ssh restart

Ok. We are ready for the next step. 

Installing Google Drive on Debian

Unfortunately, there is no offical Google Drive app for Linux. So, we will be using drive originally developed by Burcu Dogan, now maintained by Emmanuel T Odeke. It should do the basics. As usual, there are some pre-requisites.

Install GO

Drive is using GO, an open-source programming language, so we have to install it first.

To download GO, visti the official site and chose the right distribution for you and download it from your VM using wget:

wget https://dl.google.com/go/go1.13.3.linux-amd64.tar.gz

Then install/extract the package as per below (using the correct file name):

 tar -C /usr/local -xzf go1.13.3.linux-amd64.tar.gz

Add /usr/local/go/bin to the PATH environment variable, by editing  /etc/profile (system wide) with:

export PATH=$PATH:/usr/local/go/bin

Test it by running creating and building hello app

Note: if you cannot execute “go build” for your hello.go file, see if you downloaded the correct distro of GO.

Download Drive

We have GO, now we can download DRIVE from Github as per the manual.

 

First thing, however, we need to update the export PATHs for .bashrc. This is one way of doing it:

cat << ! >> ~/.bashrc
> export GOPATH=\$HOME/gopath
> export PATH=\$GOPATH:\$GOPATH/bin:\$PATH
> !
source ~/.bashrc # To reload the settings and get the newly set ones # Or open a fresh terminal

Then download the DRIVE, I used this option:

go get -u github.com/odeke-em/drive/drive

Problem? missing get? Install it first.

Try to get the DRIVE again:

go get -u github.com/odeke-em/drive/cmd/drive

In my case, this just got stuck, so I went for the other option:

go get -u github.com/odeke-em/drive/drive-google

Which also failed but at least told me that I have ggc missing. You could install it separately, but I used the bundle package to same me some time with other potential dependencies (not suggested in production!):

apt-get install build-essential

Re-try the Drive install again:

go get -u github.com/odeke-em/drive/drive-google

BINGO. You can check it by running its command:

drive-google

Finally, Connecting to my G-Drive

If you expect you click and authorise, then I will dissapoint you. You will have use GCP (Google Cloud Platform), create project, security account, keys, delegate access to G-Drive, download and push json file onto VM. Handy hint: using OAuth and service account;).

So once you have the GCP part done and ready, run the following (update the location of your json file):

drive init --service-account-file <gsa_json_file_path> ~/gdrive
cd ~/gdrive

There should be hiddne folder called “.gd” (find by “ls -a”) and within should be a file called credentials.json

Open and edit this file again with our VI:

vi credentials.json 

Find and edit the Subject=”” with an e-mail address whose Google Drive you wish to use. For example: Subject=”it@mycompany.com”.

Important: if you skipped this steps, the actual projects’ Google Drive will be used instead, meaning none of your actual data will be displayed. It uses the service account’s drive by default. This might be handy for other automation and deployments but not when I want to see my files!

How to test it?

The best is to check the manual first, by typing:

drive-google 

The handy commands are:

list, about, push, pull 

Combine this solution with custom scripts to move/copy files around using CRON and you have a nice integration betwen Google Drive and your Debian / VPS. Also, be aware of the GCP requests limits, otherwise your integration might not work that well if you reach them. 

Conclusion

Although, not a straightforward solution, but as you can see – it is do-able and fun to play with. Keep in mind however, that if you provide this solution to a third part, you need to maintain it and keep it functional (consider updates, security, etc). I see a fit for this, where a custom solutions are required, but would rather opt-out for CMS-plugins or host-provider’s paid service to facilitate for example a backup solution. If you have ideas to share or discuss with me, please get in touch with me on LinkedIn or contact me

Posted on

Newsletter systems in Czech for SMB

When it comes to newsletters, the first word I hear is MailChimp. It is quite powerfull application that helps you to manage e-mail marketing effectively.

There are other alternatives like Aweber, Constant Contact, Drip, GetResponse, Benchmark, SendinBlue, iContact and many more. None of them, however, are customised specifically for the Czech market. Unless your team speaks and operates in English, you might have to look into a Czech solution instead. So are there any?

Yes, however, the e-mail marketing in Czech still seems to be in early stage and the market is not flooded with many solutions. One of the project supporting the growth is Mailing 2020, yearly conference since 2016. If you are super serious about e-mail marketing, I suggest you look through the list of speakers and follow their works. 

In terms of market share (only percieved value), there are two major players: Ecomail and SmartMailing. Other solutions exists too such as Mailkit (CZ) and then Sendy (using AWS SES, EN), Mautic (EN) which require a bit more work to set up. You can find some tutorials in Czech for Sendy/Mautic from Petr Novák. It seems that newsletters (“odběr novinek”) is a tools used in Czech by rather medium or large businesses, but with expansion of those tools, small businesses are or will be catching up shortly. 

I had an opportunity to assist a small business in Czech with their e-mail marketing strategy refresh. I was shocked how cumbersome some processes were and lacked any automation. These include: e-mail addresses managed and stored in Word documents, duplicated data, out-dated design, no reports or visibility over the past campaigns, manual subscription management and more. 

Afterter reviewing the setup, I looked into the market for a system that would bring more efficiency and transparency. The first choice would have been MailChimp, but due to the language barrier of the customer, this was not an option. Ecomail and SmartMailling looked promissing and ticked the language box. Based on the needs of business, the Ecomail was chosen. It provided simple interface with template editor, easy contacts manager, lower pricing and had good reviews. Due to the nature of business and its irregularity when it comes to contacting potential customers, I suggested to use the credit system rather than subscription model. The customer support was excelent, though the documentation could cover more content to start with.

Along the way, there were some surprises in regards to GDPR and how the newsletters supposed to be used without violation of law. Any contacts loaded to the system have to be already subscribed to your newsletter, which means you have to use other channels to faciliate the subscription process. Very common solution is to get the subscribers from your website, but what if you collected (legally) hundreds of contacts you wish to approach? You have to contact them somehow in order to gain their permission for receiving your offers. Individual call, e-mail, letter, IM message is the correct way but not necesarily efficient. How would you automate it? Leave me a message on LinkedIn or e-mail

So, to set up the system properly is one thing, but to teach the customer how to use it is another. I would suggest to create visual workflow, which customer can come back to (screen recordings). Also, Ecomail has automation section which I highly recommend to play with. Unfortunately, forget about bulk managing your contacts in Ecomail. These features are not there and you have to use import process to overwrite certain data. You should be using custom fields, rather than labels, because these cannot be removed (only by Ecomail admin through customer care request). Do not forget also to refresh/review your contact database regularly, ideally by creating a campaign to confirm the interest of your recipients. You can automate this process too, but we leave this for some other time. 

If you want to learn more about e-mail marketing, I suggest you to read E-mail marketing: Velký test doručitelnosti (CZ) from Daniel Nytra. Another short comparison is at Včeliště. Alternatively, you can always contact me with your queries, ideas and tips. 

Posted on

Choosing a domain name xyz.CZ vs xyz.COM

There is already plenty of resources online, providing a guide on how to choose a domain name. In this post, I will just leave few links for a quick reference and tips and tricks from my personal experience. 

Firstly, it is quite important to note, that selecting a domain whose customers are non-english speakers is quite different than for example dealing with Aussies as the target audience. Not only the customers are used to their national domain suffix, but also the local search engines can be excluding .COM sites from indexing or prioritising results that have the local suffix (in this case .CZ for Czech Republic). 

I have been dealing with domains and websites since the year 1999 and learned the hard way that it is better to chose less attractive domain name but with .CZ suffix rahter than aim for czech version with .COM. As an example: instead of choosing kvetiny.cz, you might want kvetiny.com, beacause only the .COM is availabel. I would suggest to find an alternative domain name available with .CZ suffix instead. The example of that could be: cerstvekvetiny.cz, kvetinyodAleny.cz or kvetinyBrno.cz. People are used to search their native domain suffix (.CZ) rather than .COM. If you wish to be more specific and deal with roses only, go for ruzezbrna.cz but keep in mind that you might extend your business in future and will have to buy other domains and/or change the marketing if you start selling orchids and other type of flowers.

Another important aspect is to avoid numbers, symbols and problematic words, especially because Czech is hard language and people often cannot spell the words properly. Examples include “i/y, s/z, mne/me” and more. Suffix .COM can be pronouced in Czech as “kom” or “com”, which complicates any audio-relating marketing plans. 

Think also about your business and project that this domain will serve. You want the domain name to represent it in the best possible way. It should fit into your marketing trategy. You also want to avoid any lawsuits and conflicts with competitors, so check trade marks / registered businesses upfront. 

Do not worry too much where you buy the domain name. Chose one provider you like or have been recommended by a trusted source and deal with that one only. The few Czech Korunas you will save buy purchasing one domain here and another there (because they are currently on special), might cost you extra time and money in the long run. 

Secure alternative versions of the domain name, because there is always someone that wants to make money on your business easily. Domain names are cheap, so if you plan on expanding to other countries, think about it in advance. 

Lastly, you can use generator to boost your creativity, but make sure it corresponds with your business and plans. If the domain is taken, put offer together and buy it off from current owner (if the price is reasonable).

Ok, that’s it from me. Below is the list with other resources if you wish to know more. Alternatively, you can get in touch with me via LinkedIn or e-mail and discuss this further. 

https://wpnavod.cz/jak-vybrat-domenu/

https://jecas.cz/domena

https://www.cesky-hosting.cz/domeny/jak-vybrat-domenu/

https://domeny.cz/jak-na-to/jak-vybrat-spravnou-domenu-33/

Posted on

vCard (.vcf) projects

First, what is vCard or VCF?

Well, it is a file format standard for electronic business cards. The latest standard is vCard 4.0 defined in RFC 6350. “VCF’ (virtual contact file) is extension used to identified this file format. 

You can create one in Outlook app, online website, in your text editor or export it from your ERP solution (if they follow standards). You can also send vCards via e-mail, MMS, instant messeger or put them on your website and even better your mobile website version. Also, you can turn them into QR code.

Basically, they can contain name and address information, telephone numbers, e-mail addresses, URLs, logos, photographs, and audio clips. 

List of projects to generate vCard

MS Outlook
Outlook supports vCard and helps you to store contacts in exchangeable format. It is generated locally so no privacy issues. I don’t use it, but here is a tutorial for you: https://www.lifewire.com/create-vcard-outlook-1173507

Text editor (Notepad/PSPad/TextEdit)
Follow the standard RFC 6350 and crunch it yourself. Not practical, unless you want to be VCF master or code some apps or addons with it. No privacy issues. 

http://bvcard.com/vCard-vcf-generator
Project from bbros.us (two web developers), that provides QR/hcard option on top of classic vCard, easy to use but no privacy page / information about what is happening to your data. 

https://vcard.com/
Moreso a project to centralise and simplify vCard management around the globe. It’s more like a movement. Aiming high, looks promising but I am not sure if people’s motivation will be strong enough to gian the needed adoption globally. Certainly, worth trying. Privacy policy looks reasonable too, storing only your photo. 

https://vcardmaker.com/ 
Most user friendly generator, but based on their privacy-policy, they do collect data – in particular in Jordan. No info about 3rd parties. I leave that one with you. 

http://www.moongate.ro/en/products/qr_code-vcard/
This one covers vCard, QR and Matrix + they provide a bulk generation upon request (as a service). The site scares with lots of text, but it gives you better understanding of how to use it in return. No info about privacy.  

https://www.microsoft.com/en-us/p/vcard-generator/9wzdncrdr3wl?activetab=pivot:overviewtab
If you dare to use Microsoft Store, then give this one a try. I assume it would be locally generated with no data collection in the backend. The negative review is not relevant, so it might do the job. I have not test it it.

https://github.com/joonhocho/vcard-generator
The most safest generator, but also very painful for non-tech person. To generate it, you need to learn how to run Node.JS with NPM. The source-code is public and you will generate it locally, so no issue with privacy. More suitable for developers.

Posted on

G-mail vs G-suite

This is a quick recap why I chose to use G-Suite instead of free G-Mail account or other e-mail services.

First, I had to ask myself if I want to have professional e-mail address or not. Sure, I can setup G-Mail, Yahoo, Seznam e-mail in no time, but how does it look when the e-mail comes from free services that provide zero guarantee? Yes, you can lose any e-mail any time, nothing guaranteed. After all, it’s free right? So, having my own domain and proper e-mail address was a choice number one.

Once I had a domain name registered, I could opt-out for e-mail services from domain registrator (sometime host provider), but these usually run on Roundcube (PHP) web app using IMAP protocol. Although this app is using AJAX and can be reasonably user friendly, sometimes it lags a lot and still does not compare to G-Mail or Outlook experience. So I thought, I would be better off using my desktop client or mobile app, but I looked further. 

I looked at ProtonMail, which I helped translated in the past, a great service from Switzerland that provides built-in end-to-end encryption. (they provide VPN too). The pricing for e-mail services is however nearly the same as a complete G-Suite that provides additional services / apps. So, if I have to pay, I want to get as much as possible for my money and I looked furhter again.

I also considered Office 365, but since I work with it at most of the businesses, I decided to give Google a chance. Plus, it is nice to refresh the knowledge from the Google world too and stay up to date. 

When I first used G-Suite (in the past), it was branded Google Apps and it was free for business. However, these times are gone and they offer only paid opition. So, I knew I will go for the paid version (named G-Suite) unless there is a way to use Google services for free. 

Sure there is, but read before you try. To keep using only my personal free G-Mail account, I would setup all incoming e-mail redirect from my domain’s mailserver (@company.com) to my personal G-Mail address (@gmail.com). I would then add “send-mail-as” into my personal G-Mail account to allow me sending e-mails from my domain but directly from my personal G-Mail interface. This way I could use free G-Mail and Google Apps like I normally do, for free and with my professional e-mail address.

However, there is a catch. Since I send e-mails from my G-Mail account, the e-mail does not go back to my company domain mailserver (servered by Roundcube app), but it is sent directly from my personal G-Mail account (@gmail.com address) to the recipient. That creates two problems:

  1. My customers might see my personal G-Mail address instead of my professional one with the correct domain (this happens when they use Outlook clients, when you set OutOfOffice and other instances). Basically there is no guarantee they will see the correct e-mail address in the “from” section. They could see something like this:
    ‘From yourname@gmail.com on behalf of othername@otherdomain.com’.
    In other cases, these e-mails can easily fall into their spam folder. Gmail servers won’t be in DNS records as authorised sender and forget about newsletters and other e-mail marketing. 
  2. The sent e-mails are held only in my personal G-Mail account, but you won’t find them in the original mail server from where I redirected my mail address to my G-Mail. Roundcube web app will show only incoming (if I ticked “keep copy when redirect”) but not outgoing. This can become a problem if I need to share access to those e-mails, sell the business and also in case of ownership disputes. 

But, that’s not all. If I deside to use personal G-Mail accounts for my business and take advantage of other apps like Drive / Docs / Sheets, they all essentially reside in this personal account and any access has to be shared “publicly” with other users. This means that the ownership of data is not held in my business, but is distributed to other users/owners of those free G-Mail accounts. Getting access to those e-mails/files is left with their merci.

Not to mention the migration/permission mess when I would have multiple users with personal accounts and wanted to migrate them into one G-Suite. Each account has to be migrated manually/separately and permissions recreated. 

Therefore, it is better to “measure twice and cut once” and pay few dollars for G-Suite right from the beginning. 

What services do you like to use? Get in touch with me via LinkedIn or leave me a mail.

Posted on

E-commerce in Czech

A brief extract from Business Leaders magazine (03/2019) about e-commerce in Czech Republic and other online resources I came across while doing the research. 

  • e-shop/person ratio is the highest out of EU (around 42,167 e-commerce solutions currently running in Czech, yearly +3.5%)
  • estimated turnover for 2019 – 165miliard CZK (currently 122,215,343,123 Kč)
  • expected growth in small-business market = 13%
  • e-commerce brings around 10.2% of total turnover for small businesses
  • 60% of e-commerce solutions cost around 300,000 Kč (out of box solution, often labeled as custom but it core+addon/edits)
  • full custom e-commerce solution sells around 1milion Kč (limited supply)
  • full price range is 80,000 – 10,000,000 Kč (b2c / b2b)
  • majority of agencies are located in Prage (78), South Moravia/Brno (28), Selesia / Ostrava (33)

Available solutions / options on the market:

  • template – open source or subscription based – shopify, webnode, wix, simply to launch but limited in functionality / customisation 
  • out of box – usually based on core system provided by agency extended by add-ons, custom design, some add-ons already built but changes are driven by the main market target of the agency, otherwise custom development can become pricy or not allowed by agency
  • custom solution – custom coded, most expensive 
  • in-house development  – several employees working on e-commerce, usually used where e-commerce is primary  business activity

!Note! Out of box is sometimes sold as “custom solution” to customers surprise. 

source: https://exec.shopsys.cz/vyzkum#
Note: e-commerce solution delivery time (excludes negotiation)
Czech e-commerce is primarily driven by custom solutions provided by agencies!
New functions (dark purple) vs corrections (light purple)

Extract from shoptet e-commerce feedback (common problems):

  1. welcome banner with discount = not welcomed, should be used for regular customers (new customers has not developed trust yet and wants to know the site/products better), potentially slowing down page load, should be used elsewhere
  2. registration process, if possible allow no registration and get the details later
  3. company info = business address, if missing the trust lowers customers interest, similarly contact section having only a form with no info of the recipient or who do you deal with can become a problem = loss of business
  4. too many categories with a few products = too many clicks
  5. returns of product = customer comes always first, even if they don’t read the condition of sale, find a way to make them happy = negative review means loss of business; be upfront with conditions and do not hide them in terms and condition section made by lawyer 
  6. Products in stock = must be in stock, be carefull with marketing where you state you have it in stock. If not in stock, offer alternative product. Try to provide as accurate data as possible. “Unknown” = not good. 
  7. Late delivery = customers not picking up products, negative review
  8. Communication = late reply means no business, no feedback means no possitive reviews too, Order updates must be sent regularly and checked – otherwise again = loss of business. Be available where you are mostly active, customers automatically expect your presence there. Feedback from multiple sources / heureka, product review, and make sure you respond to most of the customers (most importantly those with negative feedback). Build on relationship with those that give positive feedback – little perks, bonuses etc.
Payment types: customers preference for the payment method in Czech Rep?
Pay on delivery = 34% | Pay in person/pickup = 22%
Bank Transfer = 34% | Online payment = 10%
Delivery method – usage in % by e-commerce businesses.

Price comparison sites and their popularity/usage (source):

  • heureka.cz 53%
  • zbozi.cz 42%
  • glami.cz 30% (only in fashion)
  • srovname.cz 2%
  • hledejceny.cz 3%

source: https://www.ceska-ecommerce.cz/

Reasons for shopping online (source):

  • 47% easy goods comparision
  • 18% comfort shopping (home, no queues)
  • 11% broader selection
  • 10% time savings
  • 8% lower price
  • 6% re-order option

Reasons customers fear the most (source):

  • 43% product is not suitable (cannot touch or test)
  • 21% return issues
  • 17% nothing / no reason
  • 8% misuse of payment details
  • 6% misuse of personal details
  • 5% no help from seller

Devices used for shopping online (source):

  • mobile phones 42% (up)
  • notebook 65% (down)
  • desktop 53% 
  • tablets 17%
  • read more about DPD report (cz) and market share info

2018 e-commerce market dominance in Czech (source):

  • 1. fashion (43 %)
  • 2. leisure goods (37 %) 
  • 3. health and beauty (35 %)
  • 4. electronics (33 %)
  • 5. books (29 %)

Helpful links for understanding the process and comparing solutions:

  • https://www.vybrat-eshop.cz
  • https://www.mujprvnieshop.cz/ (sponsored by shoptet)

Common obstacles: 

  • wrong product (23% returns) = extra delivery costs
  • delays in delivery = loss of customer
  • peak seasons (christmas period) = logistic issues

Case study (BIOOO.cz)

  1. promoting healthy lifestyle
  2. supporting sustainability by making clear choices 
  3. openness – product content is exposed – open discussion and testing
  4. branding – creating community “#BiOOOcz” – “O” is pushed everywhere and clearly stands 
  5. multi-channel strategy (see comparison omni vs multi) – real people behind the business, community driven engagements
  6. target audience varies – not strict to vegan/vegetarians but open to other healthy conscious people

Blog relevance

  • keywords selection is a priority and blog should be integrated in e-commerce
  • extend the content to various searched phases (search, evaluate, select, specify) = mobile phones / smartphones / iPhones / iPhone XS 16GB
  • voice search optimisation = extends keywords into phrases
  • take advantage of business’ location or related social activity (health products + events, fashion + beauty…)
  • seasonal trends = stay ahead with content creation in advance (give time to SE to index your content), example GDPR was announced in advance – marketing advantage 
  • be active / responsive = react to news / GFA – Google Fresh Algorithm

E-mail marketing 

  • declining but open rate can be still held 30-40% and 80% with personalised campaigns 
  • common issues
    • general emails / non personalised e-mails = collect data and use it for targeting (left shopping cart, favourite product/colour etc, create engagement with customers to know their preference)
    • no recipients = collection of subscribers is not effective, can result in 50% loss of sales, a product selector can collect data necessary for future sale
    • pop-up to be used only on new customers
    • 80% e-commerce solutions lacks protection for spam bots (online forms missing reCaptcha) or typos (e-mail address) = 13% e-mail addresses fail (seynam.cy) => autocomplete fixes it 
    • form positioning = not visible, commonly “thank you” page is not used well = advise about “promotion” or “bulk” category in e-mail clients
    • double opt-in is a must (Seznam.cz claims no delivery upon being caught in the spam trap), servers as a proof 
    • expecting 100% delivery = 76% might not be delivered
    • usage of same domain for marketing and transactions
    • missing relevant domain records (SPF, DKMI, TXT)
    • outdated database = must stay relevant, otherwise remove from database
    • ignorance of mobile devices = optimise for mobile viewing, avoid full size pictures and allow clearly “unsubscribe” option otherwise there is 43% changes of getting marked as spam
    • open rate < 10% => check DNS
    • open rate < 20% => check segmentation, e-mail template, remove inactive contacts
    • open rate < 30% => improve e-mail marketing = A/B testing 

Future forecast:

  • personalisation
  • bots automation
  • drove delivery
  • instant payments (crypto)
  • virtual dressing rooms
  • cost prediction (AI) 
  • voice search optimisation

Other resources:

  • samba.io – artificial intelligence used for marketing and personalisation
  • ecommerceday.cz – conference in Brno, education source
  • eshopiste.cz – eshop marketplace, investment opportunities
  • smartlook.com – insights into visitors behaviour (extends GoogleAnalytics)
  • Besteto.cz – meetup and outsourcing e-commerce activity / marketing
  • onlinePeople.cz – headhunting agency focused on e-commerce

If you want to share your thoughts, ideas, project or simply want to get connected, follow me on LinkedIn or leave me an e-mail with your favourite platform you use for networking.

Posted on

Internet of Money by Andreas Antonopoulos

I finished listening to an audio version of the book called “The Internet of Money” by Andreas Antonopoulos. This book is structured into very short, numbered talks which are quite handy when you need to navigate elsewhere and also if you need a refresher. Each chapter starts with a title that makes it really easy to remind yourself whether you’ve listened to it or not. Great for a distanced driving.

In regards to the content of the book, as you would assume, it relates to Bitcoin technology and refers to it all throughout the book. There are quite good examples and is easy to understand. Here are a few points that stood in my mind after finishing this book (version 1).

  • bitcoin as a platform, language, currency
  • telephone system examples and complex network with dumb device vs a simple network with a complex device (smartphone)
  • net neutrality and related issues
  • lego and building blocks as a reference to Bitcoin
  • a freedom we fight for (a reminder of William Wallace-Braveheart)
  • UX problems with wallets
  • focus on technology, not the price
  • one person, one bank
  • joe’s coin and a new era of banking
  • …more…

Now I can jump on the second edition and will update this post after finishing it.

 

Also, I would like to thank Andreas and other people that spend their valuable time working on this piece. I provide a link here, so this book can reach a wider audience. I hope you will enjoy it as I did.

https://www.audible.com.au/pd/The-Internet-of-Money-Audiobook/B071RPBKL1

Posted on

CRYPTO: Ledger Nano S

If you have some crypto coins, secure them in hardware wallet! I can recommend Ledger Nano S as shown below. I used it for about 3 months, pretty straightforward to use, portable and reasonably priced. If you have any questions, leave me a message.

Ledger Nano S - The secure hardware wallet

 

Posted on

Wave Apps – online invoicing switch

As of 1st May 2018, I will be utilising WaveApps.com and moving away from FreshBooks for invoicing and accounting purposes. They both provide similar features and Credit Cards integration with Stripe payment platform, but WaveApps takes it to the next level with zero monthly cost. This package is, however, designed for small businesses and there can be issues with GST calculations on invoices as this product primarily targets the US market. For non-GST-registered individuals, it is a great and free tool. Tools like MYOB Essentials, XERO, Quickbooks have been taken into consideration, but I do not see a value for money (with respect to my current needs). Let me know your experience with this or similar product.

Posted on

SECURITY: TPG modem admin bypass to enable DSL

Problem:

you have Huawei HG659 that came from TPG pre-configured, but it doesn’t work on ADSL. You set up bridge mode to 3rd party ADSL modem and still no success. Reason being – it’s preconfigured for VDSL and you cannot change it without root admin access. On top, TPG won’t give you the password for root.

Solution:

Forget about root admin Continue reading SECURITY: TPG modem admin bypass to enable DSL

Posted on

CRYPTO: Bitcoin is not always Bitcoin!

Bitcoin is not always Bitcoin!

Warning! Before you invest in Bitcoin, please do a proper research and/or ask people you trust for advice in this field. There is a very nasty marketing approach circling Bitcoin and has been for a while, as everyone wants to cut their piece and profit. Don’t let them profit on you.

You might come across websites, social network profiles or forum campaigns, which claim that they sell or offer services of Bitcoin, but they are actually selling a forked version of Bitcoin. Continue reading CRYPTO: Bitcoin is not always Bitcoin!

Posted on

WEB: webserver sizing and testing

Here are few links I recommend to start with for a web server design, load testing and performance.

  1. Web server sizing – network, processor, memory, HDD
    http://www.dell.com/content/topics/global.aspx/power/en/ps3q01_graham?c=us&l=en&cs=04
  2. Load testing – load impact – nice tool to put a web under (test)load 🙂
    https://loadimpact.com
    http://support.loadimpact.com/knowledgebase/articles/174121-how-do-i-interpret-test-results
Posted on

CRYPTO: handy BTC tools for TXs and fees

Below is a list of tools you might need for checking a transaction fee or its details. Handy for cutting some TXs cost and troubleshooting crypto transactions (mostly BTC).

  1. Unconfirmed transaction and fees estimator; shows price per byte and eta for confirmation
    https://bitcoinfees.earn.com
  2. Unconfirmed transactions in mem-pool, variation of #1
    https://dedi.jochen-hoenicke.de/queue/
  3. Bitcoin Fee calculator, calculate size and fee estimation
    https://coinb.in/#fees
  4. Accelerators – for stuck transactions
    ConfirmTX – free below 300bytes, larger $5
    ViaBTC’s accelerator – free, 100 txs, starts every hour, FIFO
    Coolwave accelerator – forum, register first (bitcoinTalk forum)
  5. Block explorer – review transaction details and info about network
    Blockchain.info – info + wallet (BTC)
    Blockr.io – BTC/LTC info
    Blockexplorer.com – grandpa explorer
    Insight.is  – API tool for data
    Chain.so – multi-currency block explorer
    Blocktrail – explorer and wallet
    BitcoinChain – explorer and other info
Posted on

CRYPTO: GDAX – CoinBase security flaw

Let’s assume you enabled 2FA on your GDAX/Coinbase account. Currently, you cannot withdraw funds from GDAX to outside address or bank account without two-factor authentication (2FA).

However, you can move the funds from GDAX to Coinbase account and from there you can then send them to outside address without 2FA! I consider this a security flaw and will demonstrate the issue in the example below.

If for example, you have a device (PC/MAC/Mobile, etc.) where you have activated “remember me for 30 days” feature to avoid providing 2FA everytime you log in, this device becomes a target for potential theft. Once someone will get an access to this device and steal your login credentials, they can then move the funds from GDAX to Coinbase and from there move it to an outside address to which you no longer have access. GDAX and Coinbase share the security settings (including login details), so attacker needs just your login details to access both platforms to action it.

Vulnerability above assumes that attacker will gain access to login credentials and to the device with active “remember me for 30 days”, so please make sure you have both secured very well if you happen to have this kind of set up.

@COINBASE: kindly fix it pls!

Posted on

How to make public facebook posts private (the quicker way)

I randomly came across a problem related to Facebook privacy and public posts. If you have ever posted something on Facebook, you might also know that there are some privacy options available for each post. While you might have your default visibility set up to “friends” only, there still might be some older posts on your timeline with privacy set to “public“.

That essentially means that anyone who googles your profile can see your public posts, such as links, photos, videos, notes etc. Remember those pictures with your awesome hairstyle from the 80’s? Your dance creations on New Year’s Eve? Or maybe those links about political affairs? Whatever is the case, you might feel like you want to hide them all. Continue reading How to make public facebook posts private (the quicker way)

Posted on

Short forecast of computing era in relation to AI

AI = artificial intelligence, has been on rapid growth during the millennium age and we are shifting into cognitive era of computing, where computer software can listen, learn and analyse unstructured data. Cognitive thinking is natural to humans but it’s been a great challenge for digital world. These limitations however, are falling apart and the future we envision and sometimes dream about, might be closer than we think. Scary and exciting at the same time. Continue reading Short forecast of computing era in relation to AI

Posted on

iPhone wifi issue solved by hair dryer

Ok. So this has happened to me already 4 times and technique below is not guaranteed at any circumstances. However, it worked for me all the time. So what is the issue? iPhone 4s simply stop providing me wifi feature since I updated the iOS to newer version. It has happened with any major iOS update 7.x, 8.x. Wifi was working perfectly fine, then I updated iOS and boom – wifi button grayed out. Soft reset, hard reset, factory restore, nothing helps. Apple support claiming it as a hardware fault. Continue reading iPhone wifi issue solved by hair dryer

Posted on

Password security

I am currently working on revision of my password management. Recently, I’ve been a victim of a scam e-mail from pretending to be from Gumtree and my password was exposed. Rookie mistake in a rush. I immediately took actions, however I realised, I don’t have a clear idea, where else have I used that password and hence those services is under potential threat. Continue reading Password security