Had a user who started to get this message. “Your message couldn’t be delivered because you weren’t recognized as a valid sender”. Logged into their Office 365 Admin account and went to Protection >> Action Center. Saw the user there and clicked “unblock” them. It took a minute, and came back with the user still in the list. I tried to send an email at the user and got the same error. In the Admin panel >> Action Center the user was still listed. I clicked “unblock” again and this time the user wasn’t listed. I tried to send another email, and got the same error again. I see a alert on the Action Center page to go to the new “Restricted Users page“. This page didn’t show the user being blocked.
I looked at the error in the Non-Deliverable Report in the returned email. The error in the message is “550 5.1.8 Access denied, bad outbound sender“.
This page was a help to let me know it could take a few hours for the email to resume.
We often switch between using WAMP and XAMPP because sometimes one works better than the other and WAMP has an older version of PHP. Today after a Windows update our XAMPP won’t start.
We removed WAMP from the Startup and looked to end all “Applications” and “Processes” running; however this didn’t solve the issue. Instead under the “Services” tab we saw “wampapache64” process was running. Simply right-clicking on this service and trying to stop it will not work. You will need to run the “services” under an Administrator account.
Search for “services“. Then right-click on the services and choose “run as administrator“. Scroll down to “wampapache64” and stop the service. We set the service to start manually.
Had a customer with an issue of Outlook “Not Responding“, and a dialog box would popup saying: Microsoft Outlook Contacting: \\googleads.g.doubleclick.net\pagead\viewthroughconversation\877065211”.
Running Outlook in safe mode would stop this from happening. Go to run and type in “outlook /safe” and hit enter.
The following article lead us to possible Malware. There were no obvious browser add-ins or extensions that could be causing this. We found the following article which prompted us to install and run RougeKiller.
RougeKiller found 3 items that we didn’t really see as a threat. One was just a shortcut, but one was a registry entry. We recreated the short and let RougeKiller Quarantine the three items. We restarted the machine and the issue didn’t popup again. We uninstalled RougeKiller and restarted the machine and Outlook was working properly.
I recently had to remove permissions from a mailbox where another user had “Full Access” or “Full Permissions” over. The original setup was done on the old Exchange 2010 server that was upgraded to 2016.
Log into the web interface of the Exchange.
Locate the mailbox and double-click on the mailbox display name.
While looking at a website in Firefox I was prompted to check out “Firefox Monitor” because the website had been compromised in the past. It gave me a button to click to see if I had been compromised. Here is the link.
On this page you put in your email and if a company has reported a breach then you will find out which ones. For me it was Adobe, LinkedIN, and Dropbox. All of these site are so popular, and that fact that I didn’t know before makes me grateful that Firefox has provided this service. It is nice to know you can still find useful free stuff on the internet.
In January we set up Google Analytics to send reports to some customers automatically. This year when we were setting this up the Analytics Dashboard has changed and it took us a minute to locate what we were looking for. Here are the steps.
Log into your account and go to the account you need to send the reports from.
Go to one of the “Reports” on the left side such as “Audience” or “Acquisition“.
In the upper-right you will see the icon to “Export“. From here it is like it was before.
There are some good automated service to match up the fields and move the data over; however, we have found that the data isn’t always entered correctly and needs to be manually evaluated and corrected before importing.
We did a full export form Salesforce and we got 140 separate .csv files. The ones were really concerned with moving were the following:
Feed Tracked Change
File Search Activity
Opportunity Contact Role
These were the .csv files that had content in them. We started by opening the Contacts and reviewing the data and how the tables linked. The field “AccountId” links to the field “Id” in the “Accounts” .csv file. We reduced the number of contacts down to just 10 users and ran through the import process.
Once logged into Hubspot, in the top menu go to “Contacts >> Companies“. Next click on the “Import” button.
Go to “Start an import“.
Select “File from computer“.
Upload your file. Since we were coming from SalesForce we did not check “Update existing companies using “Company ID” exported from HubSpot.
In SalesForce the Company has a unique id column called “ID“. This matches up with “Accounts ID” in the accounts table. While importing the Hubspot calls this column “Company ID“. The import wasn’t allowing us to pick so we created it. Seemed scarey at first but worked fine.
This import didn’t go as planned. The company was automatically created, but it didn’t link it to the contact. In addition, when reviewing the small import I discovered it put the the company in City that didn’t exist in that State. I have no idea where this data came from.
After some research I discovered this feature of importing two different .CSV’s files such as contacts and companies and matching a field to link the data. It is still in Beta. Here is a link to Hubspot’s how-to.
I tried a small import; however, nothing matched between the “ID” in “Accounts” export and “AccountId” in “Contacts“. I discovered the first 10 items I tried to import didn’t have a matching account with a matching contact.
I used Excel to find how many don’t match and create a new CSV with just the ones that matched.
I copied the Accounts sheet to the Contacts sheet by using the following method.
Right-Click on the tab of the sheet I want to copy and select “Move or Copy“.
Use the dropdown arrow to select the other workbook.
Select where you want it to go. I didn’t care so I choose “(move to end)“.
Make sure to check “Create a copy” or it will move the sheet out of the workbook.
The next step I used the help from this YouTube video to do the Match calculation.
Here is the calculation I ended up using.
I took those results and filtered them by going to Data >> Filter. I could then select just the matched results and export them.
This next article showed me how to just export the visible once I filtered my view to just the “True” or matched items.
We then reduced both files down to just 15 matched rows to test. We had to make a common field to make the association so we changed “Id” in the “Accounts” to be “AccountId” like it is in the “Contacts“.
We logged into hubspot and started the import process but this time chose “Multiple objects with Associations“.
Selected “Contacts” and “Companies” and hit “Next“.
Drag and drop your .CSV files.
Next we had to associate the matching columns between the .CSVs and assign a “Unique Key“. Since this ID was originally the Accounts ID we associated it with “Company“.
When we got to the import screen for Account or Company the AccountID was asssociated with any hubspot property, so we created one.
Click “Create a new property“.
Then give it a name. We did “AccountID” so it would match.
We checked “Don’t import data in unmatched columns“.
This worked for the most part; however, if the address wasn’t in the “Accounts.csv”, Hubspot automatically created the address which in some cases was way off. It had a business in Washington DC with an address in Chicago.
When importing an export .CSV I found it necessary to open the .CSV, copy everything, and paste it back into a new Excel sheet and save it as a .CSV. If I didn’t the import would crash or time out. I would get error #2006 - MySQL server has gone away
The large .CSV imports into MySQL through PHPmyAdmin were failing. I moved over to MySQL workbench and this worked quicker; however, it only imported 894 of 48,000 records. The is next article got me on the path to use “HeidiSQL“. Heidi knocked out the import in 5 seconds.
Steps for getting the MySQL Tables Ready for combining:
I took a working table and copied it with “Add AUTO_INCREMENT value”.
Adding an PRIMARY_KEY speeds up the query process to I needed to change the “AccountId” I was joining on. I went into “Structure”, checked the row I wanted to change and hit “change”. I had to change the “AccountId” to a “varchar” and added the “value” of “255” and hit “Save”.
I went into “Structure”, checked the row I wanted to change, scroll to the bottom and hit the “Primary” button.
This above method did not work.
I used the MySQL Workbench and “altered” the table and put primary keys and an index on the tables.
In the WorkBench click on the “wrench” icon.
I added a “Primary Key” and hit “apply”, but here I changed the “Alter” query to be add “index”.
I get the following screen.
I changed the query so it was adding an “Index” and not a “Primary Key”. The new query looked like this “ALTER TABLE blog ADD INDEX(blogID);”
With this completed the queries would no longer time out and happened in seconds.
I ended up having to use SQL to join the data. I used the following query.
This is working:
UPDATE accounts AS a
INNER JOIN contacts AS c ON a.AccountId = c.AccountId
SET a.BillingStreet = c.MailingStreet,
a.BillingCity = c.MailingCity,
a.BillingState = c.MailingState,
a.BillingPostalCode = c.MailingPostalCode
WHERE a.BillingStreet = “”
The next step I used MySQL Workbench to export the table to a CSV. I right-clicked on the Table name and selected “Table Data Export Wizard” and saved the file as a .CSV. I then took this CSV files for Contacts and Accounts and went through the process of uploading multiple files in Hubspot.
There were a few errors but they were only related to the “Industry” field where it was trying to add a industry listed from Salesforce that didn’t exist in Hubspot. Not a big deal for us since we were only after the contact and companies.