ybierling – Page 24

ybierling February 18, 2017February 17, 2017 assignment, code, combination, company, creation, customization, en, error, issue, material, MM01, plant, request, SAP, SPRO

SAP How to solve error Tables TCURM and T001W inconsistent

When facing the SAP error M3820 Tables TCURM and T001W inconsistent; contact your systems administrator, most likely during material creation

Notepad++ how to extract email addresses from a file : Final file containing only email addresses

Various

ybierling February 4, 2017January 19, 2018 address, bookmark, delete, email, en, english, extract, extract email adress, extract email adresses from file, extract emails, file, find, line, mark, notepad ++ extract emails, notepad++, notepad++ extract, notepad++ extract from file, regexp, remove, replace, search, simple, text, useful, various

Notepad++ how to extract email addresses from a file

Having a file, for example an extraction from your mailbox, and you want to extract only the email addresses ?

Various

ybierling January 29, 2017January 18, 2017 builtin, column, count, countif, easy, en, Excel, function, list, MSOffice, option, row, sheet, simple, table, unique, value, values

How to count the number of occurrences in a list with functions in Excel

Having a list of values, for example city names, and want to know how many times each unique entry is

Various

ybierling January 28, 2017September 10, 2018 column, count, en, Excel, list, MSOffice, option, pivot, row, sheet, table, unique, values, various

How to count the number of occurrences in a list with a pivot table in Excel

Having a list of values, for example city names, and want to know how many times each unique entry is

How to free storage space in Android by clearing cache : Going from smartphone's storage empty to clear

Various

ybierling January 22, 2017January 18, 2017 android, application, cache, clear, data, easy, en, fast, free, internal, phone, quick, settings, simple, smartphone, space, storage, useful, various

How to free storage space in Android by clearing cache

If your Android is getting slow, or throw at you an “Insufficient storage” error message when trying to install an

International

ybierling January 21, 2017August 14, 2017 Belgium, BestWestern, Brussels, ClubCarlson, en, free, HHonors, Hilton, hotel, Ibis, IHG, LeClub Accor, Marriott, membership, night, Radisson Blu, reward, Scandic

Best hotel in Brussels

Going to Brussels, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

How to combine two data sets and create all possible combinations with Excel : Result of combination of two data sets by creating some ID columns, and applying some vlookups

Various

ybierling January 15, 2017July 4, 2017 automatic, cell, column, combine, customer, data, en, Excel, expand, file, function, line, list, merge, Microsoft, MSOffice, product, roundup, sheet, spreadsheet, various, vlookup

How to combine two data sets and create all possible combinations with Excel

Having two different data sets, for example a customers list and a products list, and want to combine them to

Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, ...) : Voucher entry in Prestashop order

Web-en

ybierling January 14, 2017July 4, 2017 1.6, amount, cart, code, coupon, create, cufflinks, discount, ecommerce, en, fixed, maleraffine, menu, online, options, order, percentage, Prestashop, rule, shop, technology, voucher, web

Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, …)

Creating a percentage discount code, meaning the customer enters a specific character string at the end of order process, and

International

ybierling January 8, 2017January 7, 2017 Aegean, AirOlympic, Austrian, book, en, flight, frequent, FTL, gold, international, lot, Lufthansa, miles, Miles&More, Miles+Bonus, silver, Staralliance, status, swiss, travel, traveler

How to get faster Gold Frequent Traveler with Staralliance, or why I switched from Miles&More to Miles+Bonus

Being a frequent traveller, with silver FTL status at Miles&More for longer than 5 years, I never got to the

Various

ybierling January 7, 2017January 6, 2017 android, Apple, en, force, freeze, Galaxy, google, hard, hardware, HTC, iPad, iPhone, iPod, phone, Pixel, reboot, reset, restart, Samsung, smartphone, soft, stuck, unresponsive, various

Phone frozen how to force restart it with a hard reset

Having a phone (or, most likely, smartphone) not responding, probably making noise that won’t stop until the non removable battery

Web-en

ybierling December 30, 2016December 23, 2016 add, administration, Analytics, en, google, ID, install, module, Prestashop, settings, settingsa, tracking, web, website

How to link Prestashop with Google Analytics

In order to analyse your Prestashop website with Google Analytics, all you have to do is to install the module

International

ybierling December 29, 2016August 14, 2017 BestWestern, Crowne Plaza, en, free, HHonors, Hilton, Holiday Inn, hotel, Ibis, IHG, international, LeClub Accor, Marriott, membership, Mercure, night, Pullmann, rewards, SPG

Best hotel in Barcelona

Going to Barcelona, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

International

ybierling December 28, 2016August 14, 2017 BestWestern, en, France, free, HHonors, Hilton, Holiday Inn, hotel, Ibis, IHG, international, LeClub Accor, loyalty, membership, Mercure, night, rewards, Sofitel, Strasbourg

Best hotels in Strasbourg

Going to Strasbourg, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

International

ybierling December 27, 2016August 14, 2017 accor, best, BestWestern, ClubCarlson, concierge, en, free, HHonors, hotel, international, LeClub Accor, loyalty, membership, Mercure, night, Novotel, Poland, Radisson Blu, rewards, Scandic, Sofitel, travel, Wroclaw

Best hotels in Wroclaw

Going to Wroclaw, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

SAPLogon Add server manually to the server list : Enter the System Connection Parameters

SAP-en

ybierling December 26, 2016December 23, 2016 add, connection, custom, en, list, logon, options, parameters, SAP, server

SAPLogon Add server manually to the server list

Adding a new server to the server list displayed is quite simple. You may have to do so in case

Web-en

ybierling December 23, 2016July 4, 2017 change, configuration, en, image, logo, Prestashop, settings, site, technology, update, upload, web, website

Prestashop how to change logo

How to change the website‘s logos on Prestashop ? Simply go on Preferences => Themes. From there, you can change

Various

ybierling December 22, 2016July 4, 2017 activated, arrow, en, Excel, key, keyboard, lock, Microsoft, press, scroll, various, vlookup

Excel keyboard arrows moving page instead of cell

If you have happen to be moving the page viewed instead of the cell selected in Microsoft Excel, do not

Web-en

ybierling December 21, 2016July 4, 2017 en, google, indexing, property, SearchConsole, site, submit, technology, URL, web, website

How to add a website on Google for indexation

If you have just created a new website, and want it to be indexed by Google as soon as possible,

Web-en

ybierling December 21, 2016December 23, 2016 account, admin, Analytics, en, google, howto, ID, options, setup, tracking, web, Wordpress

Google Analytics how to add a website to your account and get a Tracking ID

It might be a little tricky to add a new your website to your account. See below an example adding

International

ybierling December 20, 2016August 14, 2017 Armenia, BestWestern, ClubCarlson, en, free, HHonors, Hilton, hotel, Hyatt, international, loyalty, Marriott, membership, night, Radisson Blu, reward, Yerevan

Best hotels in Yerevan

Going to Yerevan, and wondering how to get free reward nights as fast as possible, which loyalty program to choose,

YB.Digital

Author: ybierling

SAP How to solve error Tables TCURM and T001W inconsistent

Notepad++ how to extract email addresses from a file

How to free storage space in Android by clearing cache

Best hotel in Brussels

Prestashop how to create a discount / coupon / voucher code (percentage, fixed amount, …)

How to get faster Gold Frequent Traveler with Staralliance, or why I switched from Miles&More to Miles+Bonus

Phone frozen how to force restart it with a hard reset

How to link Prestashop with Google Analytics

Best hotel in Barcelona

Best hotels in Strasbourg

Best hotels in Wroclaw

Prestashop how to change logo

Excel keyboard arrows moving page instead of cell

How to add a website on Google for indexation

Google Analytics how to add a website to your account and get a Tracking ID

Best hotels in Yerevan