Tech Home The Bacon

Technology Blog

Magento 2.2 SQL Rollback Failed

Problem:

I took a SQL backup of my Magento 2.2 dev site before I did some testing. The testing didn’t go as planned so I tried the rollback feature from inside the Magento admin panel. The rollback process started, but then the page just went blank. 

When I did a refresh the page said I was in maintenance mode. I decided to SSH into the AWS instance and see what was going on. The server seemed okay, but it was stuck in maintenance mode. I disable maintenance mode and decided to run the rollback from the terminal

Continue reading

Magento 2 and AWS SES – Password Resets Not Sending

Problem: 

I’ve setup the SMTP extension from Mageplaza and successfully sent and email with AWS SES. I tried resetting a user’s password, but the end user never receives the password reset email. 

Solution: 

The password reset emails use the Customer Support email address. If this is not configured SES will not deliver it. 

Go to Stores –> Configuration –> General –> Store Email Addresses and configure your customer support sender email address that is authorized to send through SES. 

Python 3 & Wget – Download Images from CSV.

Objective

I wanted to download a list of files from an S3 bucket using python 3. I used a standard CSV in UTF-8 format. Here is an example CSV. It’s one column with just the filenames. 

I could have built out the full url in the CSV, but I decided to just do it in the code.  Below is the full python script. 

import csv
import wget
#open import file
with open("c:\\csv\\files-to-download.csv", newline='', encoding='utf-8') as f:
#Assign the import file to the DictReader "reader"    
    reader = csv.DictReader(f)
    #Now loop through all rows and build out variables    
    for row in reader:
        filename = row['name']
        print('Beginning file download with wget module')
        url = 'http://www.example.com/images/'
        wget.download(url + filename, 'c:\\csv\\images\\' + filename) 

Continue reading

Cursor Spins While Trying To Print in Microsoft Word

Problem:

Enduser called complaining their mouse cursor was acting erratically when trying to print. The cursor was spinning and page size selection was flashing like it was being pressed multiple times. After a reboot, the problem remained. We did end up getting the document to print, but the spinning cursor would remain after printing.  

Solution: 

Removing the network printer and adding it back fixed the issue. I did not change the drivers. This was a Ricoh C306Z. 

Magento 2 CE Product Import Succesful, But No Products Imported.

Problem: 

I had all the necessary fields in my Magento product upload file, and the import would show no problems with the data check test. When I reviewed the import history page it said my import had 0 created, 0 updated, and 0 deleted. Nothing happened. 

magento 2 CE import history page

Solution:

The CSV needed to be saved as UTC-8
In excel click File –> Save As –> Choose CSV UTF-8 (Comma delimited) (*.csv)  

Magento 2 CE – Not Saving Product Attributes Values

Problem: 

You add a product attribute to your store, but when you try to save a value in that field, it just keeps coming up blank after the page reloads. 

Solution: 

You can’t just simply flush the Magento cache, you need to flush the cache storage first then you will be able to see your newly save product attribute. 

System –> Tools –> Cache Management 


Magento 2 – 500 Errors After Installation

I’m working on getting Magento 2 install with Amazon Aurora. The installation went well with no errors but, the page would not load and I was receiving 500 errors. 

Option 1:

Go to the app folder in your root Magento 2 directory, open the file bootstrap.php and uncomment th line – ini_set(‘display_errors’, 1);

Option 2:

Inside your Magento root folder go to var/log/ and check your exception.log for errors.

Sage 100 & Shopify – Inventory Updates

This is a brief nontechnical overview for anyone wanting to know how I push our Sage inventory to one of our Shopify stores. 

In the above image, we start with our on-premise Sage 100 and create a visual integrator (vi) job that exports out the SKUs, quantity available to ship, and retail pricing in a CSV format. 

The vi job exports the CSV file to our internal FTP server that is automated to send the file at certain times to our public web server.

The web server just holds the file for a 3rd party Shopify app called Syncee to pick up and import into our Shopify store. 

Syncee provides email notifications after each job has finished. This email contains details on how many products were updated and how many errors each job encountered. 

Syncee is not a free app by no means, but it worth every penny from my perspective. Syncee plans are based on how many products you want to update and how many times a day you want to run the job.

The devs/support staff are great when you have problems and they will help you get things mapped out before you automate the jobs. After the job is scheduled there really isn’t much to it after that, just make sure you monitor your job status via the email notifications. 

Windows Server 2016 RDS Problems with Sage 100 2017 RemoteApp

sage 100 remoteapp problem windows not appearingRemoteApp Problems – Windows Not Showing:

We deployed a new RDS server this week with Sage 100 2017 published as a RemoteApp. One of our remote sites called in and said it was taking an unusual amount of time for the windows to open. I remoted into their machine and walked through some normal operations of creating a sales order. The window to select a customer account seemed to be taking a long time to appear, but when I hovered over the icon in the taskbar it was showing the new window was already running. If you click on the area where the new window was supposed to be it would appear. The windows of the RemoteApp were not drawing to the screen. To the user, the window wasn’t appearing at all, but when the user got frustrated they would start clicking randomly and the window would finally appear.

Continue reading

Trouble After Migrating Azure AD Connect

Moving Azure AD Connect From Windows Server 2012 to 2016

Last week I stood up a new Windows Server 2016 domain controller as we prepared to decommission the older ones. One task I needed to complete was to migrate our Azure AD Connect software. I followed Paul Cunningham guide Migrating Azure AD Connect to a New Server. Everything went well and we did our testing to make sure that everything was pushing out to o365 and it was. The o365 admin portal was showing our new DC id under the ADD Connect Status.  I thought all was well. 

Continue reading

« Older posts

© 2018 Tech Home The Bacon

Theme by Anders NorenUp ↑