Learning someone else’s code

I’ve gone into a group coding project for the first time this year. I have zero familiarity with Github, using branches, merging, making pull requests – and my knowledge of the underlying code (in React & GraphQL) is sketchy at best, although I understand it.

There’s all these terms that I don’t understand. I’ve never used Docker, althogh I understand its purpose. I have no idea what a Redis cluster is, or stunnel, or how the production dev and staging servers work. I’m getting very little help from anyone else at the moment.

It’s a minefield I need to battle through and do my best, but that involves a lot of learning along the way. Lets hope I have the capability to get it done!

My Own Quick Excel Formula Lookups

This will become my own page of quick Excel formulas that I find myself looking up elsewhere far too often! It should flesh out over time.

Excel String Manipulation

Does any cell in a range contain a substring?
(Is the string contained in cell F4 a substring of any of the cells in column B)

=COUNTIF(B:B,"*"&F4&"*")>0

Which row number in a range contains the partial match?

=MATCH(""&F4&"",B:B,0)

Return the contents of the column on the same row as the match.
(if the value A6 is found in the column A:A on AMAZON UPLOAD, then return the corresponding value in column O)

=INDEX(O:O,MATCH(A6,'AMAZON UPLOAD.xlsx'!$A:$A,0))

Excel Date Manipulation

Convert the date name into the date number

=MONTH(DATEVALUE(A1&" 1"))

Fixing Amazon Price & Quantity Update Loader File errors on Mac for Excel

There have been multiple reports of errors with the Flat.File.PriceInventory.TTH file on Excel for the Mac since 2014, and it doesn’t seem like Amazon want to do anything to fix it. Visual Basic Unexpected Error 465 prevents users from saving the file after making edits.

A quick workaround for this is to use Google Sheets. Import the downloaded Price & Quantity Update Loader File, make your updates through your browser on Google, then save it to your computer as a tab delimited file.

Change the file extension from tsv to txt, and upload to Amazon, making sure you specify that you’re uploading a Price & Quantity Update Loader File from the drop down menu there before you upload it.

After many hours, this has finally fixed the upload issue.

Getting Started with SSL on Amazon AWS

I was asked to install an SSL certificate on a client’s subdomain which they hosted through Amazon AWS today. I kid you not when I tell you Amazon AWS is complicated as anything, even if you’re a technical person, and you may struggle to even understand the very basics.

The very basics are this:

  • Amazon S3 hosting is static hosting – for websites that only require a little bit of javascript and no database.
  • Amazon EC2 is hosting for dynamic websites – you run a virtual machine with your database connected website on. When the machine is running, it is called an ‘instance’.
  • An Elastic IP allows you to assign a static IP to an instance.
  • It seems that a Load Balancer is also needed to host a SSL certificate on an EC2 instance, however, testing now has me doubting if this is the case (and it may be that a SSL certificate on the CPanel host is enough)

I intend to learn a lot more about Amazon AWS over the year. What I picked up today was very basic stuff, and it is in no way intuitive. Even the pricing levels are hard to understand. However, it’s meant to be one of the best cloud hosting environments out there, so I am intending to add this to my list of skills.

How to fix a 404 error on Magento Admin Page after SSL install

The CPanel solution I used resets the admin directory to its default location (at /admin/)

  1. Make sure /public_html/app/etc/env.php has the following:
'backend' => [
         'frontName' => 'admin'
     ],

2. Go into phpMyAdmin and edit the core_config_data table:
a) set admin/url/use_custom to 0
b) set admin/url/use_custom_path to 0
c) DELETE the row web/secure/base_url
d) DELETE the row web/unsecure/base_url

3. Go into fileManager and delete all the files in /var/cache

This worked for me after installing SSL, and I was able to access the /admin login page again.