Xcode and Bitbucket gives Authentication Failed

No Comments

When cloning a Bitbucket repository from Xcode (using current version 9.2) I get Authentication failed.

Solution is to insert Password into URL.


  1. Copy repository URL from Bitbucket – Overview, select HTTPS (not SSH)
  2. Paste it in to Xcode Clone window for Adding GitHub account (for example click “Clone an existing Project” from Xcode start screen)
  3. Before clicking the Clone button, edit the url to insert your Bitbucket password.
    Url looks something like this:
    Add password like this, colon and your password:
  4. Click Clone button and it should work

Solved: Email not received and no NDR on Office365 Microsoft online

No Comments

I recently had the problem where a person sent me a zipped file from his gmail account to my email account at Microsoft online/Office365. The email never reached me and the sender never received any NDR (Non Delivery Report). So I thought he hadn’t sent me anything while he was sure I had received it. Luckily in this case, I was expecting an email from him so I got in touch and we could start troubleshooting. How many other emails like this I have not received since I started using Microsoft online years ago, I will never know.

After some troubleshooting including going into Office 365 Admin – Exchange Admin Center – Mail Flow -Message Trace I found the messages and could see that the zip file had incorrectly been deemed as malware. Messages were marked as deleted and not delivered. I opened a support ticket with Microsoft and found out that the default setting in Microsoft online is to just delete emails with suspected malware without notifying anyone about it.

In my opinion this is not the smartest default setting but fortunately you can change it:

  1. Sign in as admin to Office365 Admin at microsoftonline.com
  2. Go to Exchange Admin Center
  3. Go to Protection – Malware filter
  4. If you have not made changes to the Malware filter before you probably only have one Malware filter rule: Default. Doubleclick it to edit.
  5. Under Settings + Malware Detection Response, I changed from “Delete the entire message” to “Delete all attachments and use default alert text”, this means you as a recipient will receive the msg but without the suspected malware.
    There are also other settings you can change such as Sender Notifications and Administrator Notifications if you lso or instead want the Sender or Admin to be notified.

I hope this helps someone else out!


Set separator delimiter in CSV file to open correctly in Excel

1 Comment


I made a PHP script to export a SQL query (from MySql) to a CSV file for opening in Excel. I cannot control how different users have their Excel setup, ie what separator delimiter they have set (this differs with language settings or user may have changed setting)

So the field separator delimiter gave me some problems, ie Excel would not automatically open file columns correctly but put each row in a single cell, unless you use Import data to make it work.

Some forums suggested setting the separator delimiter in the csv file (delimiter is third argument for fputcsv) to tab (\t) but that did not help.

Solution (use csv header sep=)

Then I stumbled upon the possibility to add a parameter as a header to the actual csv file, simply add sep=<delimiter> to the beginning of your csv file and Excel will parse it. So for separator delimiter use comma (,), pipe (|), tab (\t) or whatever you set in your php code.

However I found a few caveats:

  • “sep=\t” needs to be in quotes (otherwise it will use header but also for some reason also show it as data in the spreadsheet and put it in its own cell and move all other cells on that row one position to the right)
  • You need to add newline \n after the sep= header (otherwise it will use header but also show it as data concatenated with first cells data)
  • Use fwrite as fputcsv will not work

Example to use tab as separator:

fwrite($fp, "\"sep=\t\"\n");


I could not find much info on the subject of csv headers but this is the full thread that lead me on the to it (thanks Burhan Ali)

Tested with Excel 2016 on Windows 10 and Excel for Mac (15.25) on OSX El Capitan (10.11.15).

I have not tested on other spreadsheets software like OpenOffice, LibreOffice etc, so please share in the comments if you have any success with this.

Solution: USB Memory stick not showing in File explorer

No Comments


I have some USB Flash Memory drives that I had used on a non-Windows system (ie a TV) so it is using another file system than Windows’ NTFS, FAT or FAT32. When I insert them into my Windows 10 laptop they are connected, ie they are found by Windows and show up under “Safely Remove Hardware and Eject Media” and in the Device Manager. But they are not assigned a drive letter and do not show up as a drive in the File Explorer (aka My Computer in earlier Windows versions) or command prompt.

At first, I just thought that the USB Memory stick was not working but after having the same problem with several USB Memories I realized it probably had something to do with the format on them. I tried to download the HP USB Disk Storage Format Tool, but the USB drive did not show up there either.

So how can I reformat the USB memory stick if it does not show up in the Windows File Explorer?


I found a solution that works for me from Mosely5165.

WARNING: Make sure you know what you’re doing before trying this. If you select the wrong disk you may loose your data or entire system.

1. Open a Windows Command Prompt as Administrator


2. Run Diskpart


This should launch Diskpart and give you the DISKPART> prompt.

3. List available disks

list disk

4. From the list of disks select the one that is your USB drive, make sure to identify the right one.
WARNING: If you select the wrong disk you may loose your data or entire system

select disk x

5. Create a primary partition

create partition primary

If this gives you an error saying there is not enough space, give the Clean command, then try to create the partition again.

create partition primary

6. Give the following commands.

select partition 1
format fs=ntfs quick 

Full thread can be found at Tom’s Hardware here.

Windows cannot connect to iPhone Personal Hotspot


I have ran into this a few times so I thougt I’d write down the solution as I seem to keep forgetting it. There are probably tons of other problems you can have with iPhone Personal Hotspot and Windows Wifi but this is the solution to one I keep running into.


I turn on the Personal Hotspot on my iPhone and it shows up fine as an available Wifi network in Windows only the Wifi name looks a little off in Windows compared to the iPhone. My iPhone name is “Max’s iPhone” but in Windows the apostrophe looks “scrambled” and is replaced by two “trash” characters, something like this: “Max¿Ǝ iPhone”.

When I try to connect my Windows laptop over Wifi it just keeps trying to connect – showing message “Checking network requirements” – before I finally get “Can’t connect to this network“. On the iPhone I get the blue Personal Hotspot field on top of the screen flashing on and off while Windows tries to connect.


Solution is to change the name of your iPhone to remove or replace the apostrophe.

To change name of your iPhone in iOS: Settings – General – About – Name

More info

I just fixed this and unfortunately cannot recreate or remember exact what the scrambled or trash characters in my iPhone name looked like but I think one of the characters was an upside down letter E and/or question mark. So it looks something like this “Max¿Ǝ iPhone”.

So this seems to be what messes things up for Windows.

For me it has worked both to remove the apostrophe or replace it, ie delete it and then type it again. The name will look the same in your iPhone but after this it will also look ok in Windows Wifi selection and Windows should be able to connect to your iPhone Personal Hotspot without any problem.

It seems this problem keeps reoccuring for me. I do not use Personal Hotspot that often so I’m not sure when or why this reoccurence happens but my best guess is that an iOS upgrade or switching to a new device and installing from backup may be the cause.

Currently running iOS 9.0.2 on an iPhone 6 and Windows 10 but I have had this problem in previous versions of both iOS and Windows.

Did this solution work for you?

Please let me and others know by commenting, provide what version of Windows and iOS you are using if you know it.

Windows 10 international support lacking

No Comments

I have noticed a couple of things where Windows 10 does not support international the way I would expect a 2015 operating system to do. I have not found any solutions yet so any more info on these issues would be appreciated.

Compressed (zipped) folder

I tried to zip a folder in Windows 10 by right clicking and then selecting Send to – Compressed (zipped) folder but got this error:

xxx cannot be compressed because it includes characters that cannot be used in a compressed folder, such as ". You should rename this file or directory. 

The folder contains files with Swedish characters åäö in it. I cannot remember having any problems with this in Windows 7?


The calculator (calc.exe) only accepts the period sign (.) as decimal delimiter. In Sweden we have comma (,) as decimal delimiter and this has always worked in all Windows programs for as long as I can remember. Of course any properly written Windows app would know to take such settings from Windows regional settings but apparently the decimal separator is hardcoded in the Windows 10 version of the calculator.

Batch rename files in Windows from Command Line

1 Comment

This is an easy way to add a prefix to any set of files in a Windows folder, from a command prompt type this

for %a in (*.*) do ren "%a" "prefix - %a"


Tried in Windows 10. Thanks to ofer.sheffer in this Stackoverflow post where there is also an example on how to do this in PowerShell.

Solution: Windows 10 upgrade: “Couldn’t update the system reserved partition”

1 Comment


When trying to update my Windows 7 Home Premium 64-bit to Windows 10 the other day using Windows Update I got this error “Something went wrong” and “We couldn’t update the system reserved partition”.

After some searching it seems this is related to not enough disk space on update partition, needs to be 50MB (thanks for the informative error message Microsoft…)


Thanks to Mister_Kurtz who in this post describes a solution when upgrading Windows 8.1. I’m on Windows 7 and upgrading to Windows 10 RTM (Release to Manufacturing) but with some slight changes it worked for me. The trick is to free up 50MB space on the Data partition, which is used for the upgrade, by truncating the NTFS log to 5MB. The original post includes steps to delete language files but I did not have any such files on my computer.

These are the steps that worked for me:

  1. Your user need to have administrator rights (full access)
  2. Go in to Disk Management – Start button, in search box (or Win+R) type
  3. On the same disk as your C: drive the first partition will be Data of size 100MB. Right click on the Data partition and select Change Drive Letters and Paths. Then click Add an choose Y: as drive letter (or any other that is available)
  4. Open a Admin Command Prompt – Start button, in search box and type

    Right click the cmd.exe program and choose ‘Run as Administrator’.

  5. In the Admin Command Prompt goto Y:
    Run these commands:

    takeown /f . /r /d y
    icacls . /grant administrators:F /t 
    attrib -h -s -r bootmgr
    chkdsk Y: /F /X /L:5000
  6. Output from chkdsk should tell you that you now have at least 50MB free space.
    Retry running the Windows 10 upgrade, i did not need to reboot.


BOINC error when adding World Community Grid project


I just downloaded the latest version of BOINC, 7.4.27 for Windows 64-bit.

When trying to Add Project and select World Community Grid, enter my username and password I get this error:

Failed to add project
Messages from server:
missing or bad parameter: email_addr


This seems to be a regression bug from way back. For some reason the World Community Grid forum does not rank high in Google search results but in this thread I found the following workaround to add project from command line instead of GUI.

Do this:

  1. Login to worldcommunitygrid.org then click Settings and My Profile, at the bottom of that page you will find your Account key
  2. Have BOINC running
  3. Open a Windows Command Prompt and go to the BOINC program directory, for 64-bit this should be something like c:\Program Files\BOINC, for 32-bit c:\Program Files (x86)\BOINC
  4. Enter command:
    boinccmd.exe --project_attach www.worldcommunitygrid.org [Insert your Account key here]
  5. That’s it, World Community Grid should now be added as a project in BOINC

Yes SSD does work!

1 Comment

Just wanted to share this, probably old news to most of you out there, but: SSD actually does work!

I just installed an SSD (Solid State Drive) in my four year old (!) laptop and it is now lightning fast!

My laptop is an Acer Aspire 5741G with 4GB memory running Windows 7 64-bit. I switched the original 320GB HDD for a Samsung 840 EVO 250GB SSD.

Simple setup

Included with the SSD drive is a piece of software called Samsung Data Migration. You also need a SATA to USB cable, you can select to buy the SSD with this cable included if you don’t already own one.

The Data Migration tool was a breeze, I just ran it and my existing hard drive including Windows and everything else on it was copied to the new SSD drive. I then turned off my laptop and switched drives and everything – totally unexpected – just worked!

The only thing I had to do was delete and move some files since I was going from an almost full 320GB drive to 250GB. Also the SSD drive needs to have 20% free of the new drives available ca 230GB so that took me down to below 200GB.

After setup I ran the Samsung Magician software that is also included. There you can test performance and do optimizations. I have yet to figure out the various settings but enabling something called Rapid mode gave my benchmark tests a real boost.

Magician also reports that my laptop does not support SATA 3 (6Gb/s) hence not being able to use maximum performance of the SSD drive but that actually does not bother me as it is anyway superfast!

Some more info on SSD and Samsung software can be found here.

Conclusion: If you, like I did, don’t think SSD will do that much for your laptop (or desktop for that matter) – think again!

Older Entries