Again I have not been able to copy the cells as how they are shown, i.e. not quotes, without going through word.
2012-10-23
Excel: copy paste of cells with multiline text show up with quotes "
Current workaround is to copy paste into word and then into any editor/terminal of your choice.
Again I have not been able to copy the cells as how they are shown, i.e. not quotes, without going through word.
Again I have not been able to copy the cells as how they are shown, i.e. not quotes, without going through word.
Excel: Transpose anyone? Much needed feature easily accessed
I started it all wrong with some excel table and decided I need to switch rows with columns and thought that it takes me some time to actually do it manually or find a feature in excel to do it.
Excel to the rescue: Transpose
Just select the table or rows/columns then CTRL-C, go to a new Sheet or wherever and CTRL-V, then select T or transpose icon. Done.
I just have not been able to do this without choosing another place or Sheet, i.e. no same place transpose? Anyone any idea?
2012-10-18
for fun: use beautiful google datacenter pictures as windows 7 login screen image
The process is quite simple but I like this little utility much more:
http://www.julien-manici.com/windows_7_logon_background_changer/
I even did not have to reboot to check out if it works, just used WIN+L and boom there it was
links:
http://www.intowindows.com/how-to-change-windows-7-logon-screen-easily-without-using-hacks-tools/
http://www.julien-manici.com/windows_7_logon_background_changer/
I even did not have to reboot to check out if it works, just used WIN+L and boom there it was
links:
http://www.intowindows.com/how-to-change-windows-7-logon-screen-easily-without-using-hacks-tools/
2012-10-11
End of the debate: Microsoft SMB can work over tcp/445 period, over and out.
The many discussions you're facing if you don't want to open ports udp/137, udp/138 and tcp/139 in your firewalls end here:
http://technet.microsoft.com/en-us/library/cc940063.aspx
Direct hosting over TCP/IP uses TCP port 445 instead of the NetBIOS session TCP port 139.
Direct hosting has been available since Windows 2000!
Ok, but just yesterday we have had a machine that we could not teach to use tcp/445 for SMB it always defaulted to NetBIOS over TCP/IP. Was a W2K8 R2 and has some registry corruption issue that prevented it to connect to any fileshare. Solution to that was to set the server to DHCP and then back to static, but it now only goes over 137-139.
http://technet.microsoft.com/en-us/library/cc940063.aspx
Direct hosting over TCP/IP uses TCP port 445 instead of the NetBIOS session TCP port 139.
Direct hosting has been available since Windows 2000!
Ok, but just yesterday we have had a machine that we could not teach to use tcp/445 for SMB it always defaulted to NetBIOS over TCP/IP. Was a W2K8 R2 and has some registry corruption issue that prevented it to connect to any fileshare. Solution to that was to set the server to DHCP and then back to static, but it now only goes over 137-139.
2012-10-03
Excel: row numbering
It took me more than 5 minutes to actually find the right link for my problem to number rows automatically with some correction on where to start.
=ROW()-9
If placed in A10, this will give you 1.
Here's the original article, where I found it from:
http://agsci.psu.edu/it/news/2010/11/automatically-number-rows-in-excel
=ROW()-9
If placed in A10, this will give you 1.
Here's the original article, where I found it from:
http://agsci.psu.edu/it/news/2010/11/automatically-number-rows-in-excel
2012-09-19
Did apple steal the clock design in iOS 6 for iPad from Mondaine?
The first thing you'll notice after upgrading to iOS 6 on iPad will probably be the clock application. Since it is the biggest improvement for many people not having to rely on other clock applications and stop watches. (No you probably only have to wait for iOS 7 to deliver the weather app).
But for any swiss person or someone having travelled through switzerland it's apparent that the design is from our official swiss rail clock (mondaine), which we have come to love.
Is it licensed or just ripped of?
But for any swiss person or someone having travelled through switzerland it's apparent that the design is from our official swiss rail clock (mondaine), which we have come to love.
Is it licensed or just ripped of?
2012-08-17
tcpdump: output to pcap file and display on console
Many thanks for this blog entry where it explained on how to use tcpdump to write to a file and simultanously print on the console.
tcpdump -U -w - host 1.2.3.4 | tee file.pcap | tcpdump -r -
http://jbits.se/blog/2010/02/19/tcpdump-output-to-file-and-console/
tcpdump -U -w - host 1.2.3.4 | tee file.pcap | tcpdump -r -
http://jbits.se/blog/2010/02/19/tcpdump-output-to-file-and-console/
Google Calendar sync issue: Use DocMessageClass to resolve the issue
You might notice that some entries are not synced from outlook to google and this is because Outlook has different Message classes especially for meeting requests.
I use a free portable app DocMessageClass to fix these items, but it is a manual process and I've seen some scripts on the web but have not made the effort to actually put them to work.
http://www.publicshareware.com/public-share-outlook-utilities.php
I use a free portable app DocMessageClass to fix these items, but it is a manual process and I've seen some scripts on the web but have not made the effort to actually put them to work.
http://www.publicshareware.com/public-share-outlook-utilities.php
Google Calendar sync with Outlook tool: Really great for keeping your Business/Private calendar in sync
http://support.google.com/calendar/bin/answer.py?hl=en&answer=98563
Using for a long time with almost no issues.
Using for a long time with almost no issues.
2012-08-16
Checkpoint proxy arp and manual nat
In checkpoint if you have a manual NAT entry the firewall will not do proxy ARP, which means it will not answer to arp requests on the network where the NAT will take effect.
Solutions are:
- use automatic NAT rule
- there's article on Checkpoint support that describes on how to correctly add an entry to a file that the firewall will do the proxyARP, apparently different for single or Cluster XL
- define a static host route to the firewall from the other device.
In my case they forgot to that and the SYN traversed 2 firewalls but the SYN/ACK was lost due to one firewall not being able to find via ARP a MAC address to talk to.
Solutions are:
- use automatic NAT rule
- there's article on Checkpoint support that describes on how to correctly add an entry to a file that the firewall will do the proxyARP, apparently different for single or Cluster XL
- define a static host route to the firewall from the other device.
In my case they forgot to that and the SYN traversed 2 firewalls but the SYN/ACK was lost due to one firewall not being able to find via ARP a MAC address to talk to.
Rant: Windows 8
I have just read a very nice piece on somebody's experience in regard to windows 8 and some parts feel like they are my thoughts.
image found on google images: http://i-dothink.com/index.php/windows-8-phone-functionality-spotted/
iOS and MacOSx are definitely advanced in many aspects, but the major improvements are still missing in regards to information connectivity.
The article talks about Dashboard that could have been the windows 8 tiles UI. And I think he's right. I never was able to really make use of the dashboard and today mostly land on it by error. I use the iPad daily between 1 to 5 hours over a 16 hour period, 99% consumption. And clearly the presentation of the information on the main screen is lacking, the integration between apps and data is lacking, best example is try to install a pinterest bookmark, i.e. it should just be natural to click on whatever to share with whatever that's out there.
The windows 8 UI will probably help me avoid going into my top 5 applications all the time. Also notification in iOS and OSx are less than optimal. I want to have all information on one big screen. I don't think the widgets of android are going to do the trick, since most of them take to much screen real estate and have a non identifiable form.
I will install the 90 days windows 8 evaluation version tonight and try to spend another few hours to try and see if I get the same productivity as the author said he does.
Maybe at one point some really good guy will develop an OS where all information can be used in whatever form we like and multiple times in different places but all linked to the same info. As an example the worst thing today is that a reminder is not really a note, not really appearing in the calendar, not really an alarm entry, not being editable by penultimate, not able to print using the papers app .....
Microsoft tried in some office version to actually put tasks onto the calendar at the bottom but not in the calendar. I still crave for this that the tasks will actually be put into the calendar and reflect the actual time spent or whatever I want it to be and if completed will change color, allow tagging and more.
Most probably we won't get most of this for another decade or so, as it took from the perfect Palm Pilot to a somewhat great iPhone. Is it really that people forget this so soon. Everything was here and it took 20 years to improve.
Well here is the link to the article:
http://www.theverge.com/2012/8/16/3246185/this-is-my-next-windows-8
image found on google images: http://i-dothink.com/index.php/windows-8-phone-functionality-spotted/
iOS and MacOSx are definitely advanced in many aspects, but the major improvements are still missing in regards to information connectivity.
The article talks about Dashboard that could have been the windows 8 tiles UI. And I think he's right. I never was able to really make use of the dashboard and today mostly land on it by error. I use the iPad daily between 1 to 5 hours over a 16 hour period, 99% consumption. And clearly the presentation of the information on the main screen is lacking, the integration between apps and data is lacking, best example is try to install a pinterest bookmark, i.e. it should just be natural to click on whatever to share with whatever that's out there.
The windows 8 UI will probably help me avoid going into my top 5 applications all the time. Also notification in iOS and OSx are less than optimal. I want to have all information on one big screen. I don't think the widgets of android are going to do the trick, since most of them take to much screen real estate and have a non identifiable form.
I will install the 90 days windows 8 evaluation version tonight and try to spend another few hours to try and see if I get the same productivity as the author said he does.
Maybe at one point some really good guy will develop an OS where all information can be used in whatever form we like and multiple times in different places but all linked to the same info. As an example the worst thing today is that a reminder is not really a note, not really appearing in the calendar, not really an alarm entry, not being editable by penultimate, not able to print using the papers app .....
Microsoft tried in some office version to actually put tasks onto the calendar at the bottom but not in the calendar. I still crave for this that the tasks will actually be put into the calendar and reflect the actual time spent or whatever I want it to be and if completed will change color, allow tagging and more.
Most probably we won't get most of this for another decade or so, as it took from the perfect Palm Pilot to a somewhat great iPhone. Is it really that people forget this so soon. Everything was here and it took 20 years to improve.
Well here is the link to the article:
http://www.theverge.com/2012/8/16/3246185/this-is-my-next-windows-8
2012-08-06
2012-08-05
disk performance utilitiy: crystel disk mark
http://crystalmark.info/software/CrystalDiskMark/index-e.html/
2012-08-03
Filezilla, Websense: Using ftp upload/download over websense proxy using filezilla client
http://www.websense.com/content/support/library/web/v75/wcg_help/conf_ftp_clients.aspx
The most important is the part:
FTP Proxy:
Custom:
USER %u@%h
PASS %p
proxy host: server:2121
user and password sometimes have to be defined and sometimes not, in my case the user was important but not the password.
The most important is the part:
FTP Proxy:
Custom:
USER %u@%h
PASS %p
proxy host: server:2121
user and password sometimes have to be defined and sometimes not, in my case the user was important but not the password.
2012-08-02
2012-07-16
Mac OS X: iTunes keep an extra copy in addition to time machine (Updated 2014-11-29)
Actually this was a good idea, but it takes a millennia to start to copy actually something.
rsync -avr --delete /Volumes/Toshiba/iPhoto\ Library/ /Volumes/LACIE/iPhoto\ Library/
Then I had to copy two backups and was fed up about the rsync never actually to start copying for hours.
I found this article
http://blog.brettalton.com/2013/08/05/how-to-speed-up-rsync-on-your-mac-and-stop-the-dreaded-building-file-list/
and installed homebrew and then the new rsync and am using the following command now:
rsync -a --info=progress2 /Volumes/WD_2TB/ /Volumes/Toshiba/
Now there is some action, but disappointingly it crawls and I don't know why. Is it because there are gazillions of small files or is something else broken?
Let's wait and see.
Don't know but I feel more comfortable with this command as it actually does go ahead for now (still don't understand enough about the processing):
rsync -aP /Volumes/WD_2TB/ /Volumes/Toshiba/
and this with rsync 3.1.1
rsync -avr --delete /Volumes/Toshiba/iPhoto\ Library/ /Volumes/LACIE/iPhoto\ Library/
Then I had to copy two backups and was fed up about the rsync never actually to start copying for hours.
I found this article
http://blog.brettalton.com/2013/08/05/how-to-speed-up-rsync-on-your-mac-and-stop-the-dreaded-building-file-list/
and installed homebrew and then the new rsync and am using the following command now:
rsync -a --info=progress2 /Volumes/WD_2TB/ /Volumes/Toshiba/
Now there is some action, but disappointingly it crawls and I don't know why. Is it because there are gazillions of small files or is something else broken?
Let's wait and see.
Don't know but I feel more comfortable with this command as it actually does go ahead for now (still don't understand enough about the processing):
rsync -aP /Volumes/WD_2TB/ /Volumes/Toshiba/
and this with rsync 3.1.1
2012-06-27
2012-06-14
Mac OS X: Lion install USB or Disk. Restore does not work anymore! 2nd attempt
Now using carbon copy cloner.This works perfectly.
Download Carbon Copy Cloner
Install it as it says you should
Right Click Install Mac OS X Lion and select show package contents
Go to Contents->Shared Support and select InstallESD.dmg
Drag InstallESD.dmg out on your desktop or whereever you'll be able to select it from again in CCC .
Start disk utility and select USB stick or disk and select parition, choose 1 partition and under Options... select GUID. Then hit apply.
Start CCC and select as source InstallESD.dmg
Select USB stick (>4GB) or USB Disk and hit clone.
This worked fine for both (stick and disk) and you can still try to use the Lion Disk Installer for USB Sticks less than or equal 4GB. In the blog he removes some packages that are not critical.
Have fun.
Mac OS X: Lion install USB or Disk. Restore does not work anymore!
http://blog.gete.net/lion-diskmaker-us/
Update could not complete, because I had Zipeg installed and that interrupted the applescript Lion DiskMaker is using when trying to get some .png in a zip file.
Failed.
2012-06-12
Pimp your Outlook 2010 incoming email alert with Star Trek sounds!
http://office.microsoft.com/en-us/outlook-help/change-the-sound-played-when-an-email-message-arrives-HP010354979.aspx
http://www.franksradio.net/startrek/sounds/
http://www.franksradio.net/startrek/sounds/
Black Monday for the millions of iPad (first generation users)
Many people I know own an original iPad. The device might only be 2 1/2 years old or younger and it will most probably live on for another 3 to 5 years. The quality of the device is superb, it is even better at handling drops due to the rubber in between the frame and the glass. Just in our family most original iPads have suffered this and sport a bump in the side or at the corner and are still fully functional.
My iPad 2 died within 3 weeks due to the smart cover, which I was able to hold on to while my iPad2 slipped to the ground and the glass shattered. This would not have happened with the original cover and now Apple has introduced the new case that will prevent this from happening again.
Why is it such a bad day for millions of iPad owners? Schools, families etc. will not afford to upgrade just now to a newer version. Most of us run some computers at home that are 5 to 7 years old, even my geek companions that have all the latest gear still have some computers that is still used for some reason and is of old age. Now we won't benefit from the new safari browser, the new maps, the clock, iMessage improvements ...... It does not sound to bad to start with, but on almost all computers you can upgrade the applications to a certain level, i.e. chrome 19 on a windows xp machine that is 10 years old. Most problematic will be that Safari will not be updated and expose us to all sorts of issues and incompatibilities within one or 2 years. This is only one of the applications that will need continuous support for at least 3 years.
Maybe it will be the same as for the Dell Axim V61 and all other PDAs of the past, where some hackers have kept us up to date, so that we could use the devices long past their reasonable usage time.
And Jailbreak will be new way to go forward most likely, enabling us to enjoy some of the benefits and maybe more (app switching, user profiles, file access etc.).
Let's wait and see.
In the past this has happened with our old iMacs and iBooks and it will happen now with the MacBook (black), but the big difference was that most of the applications were continuously updated and could be installed and now some of the most critical features will be integrated into the basis which will not be updated separately.
The best will be if someone like GeoHot will provide us with an easy install of the official release on the iPad, since I really don't like to jailbreak.
My iPad 2 died within 3 weeks due to the smart cover, which I was able to hold on to while my iPad2 slipped to the ground and the glass shattered. This would not have happened with the original cover and now Apple has introduced the new case that will prevent this from happening again.
Why is it such a bad day for millions of iPad owners? Schools, families etc. will not afford to upgrade just now to a newer version. Most of us run some computers at home that are 5 to 7 years old, even my geek companions that have all the latest gear still have some computers that is still used for some reason and is of old age. Now we won't benefit from the new safari browser, the new maps, the clock, iMessage improvements ...... It does not sound to bad to start with, but on almost all computers you can upgrade the applications to a certain level, i.e. chrome 19 on a windows xp machine that is 10 years old. Most problematic will be that Safari will not be updated and expose us to all sorts of issues and incompatibilities within one or 2 years. This is only one of the applications that will need continuous support for at least 3 years.
Maybe it will be the same as for the Dell Axim V61 and all other PDAs of the past, where some hackers have kept us up to date, so that we could use the devices long past their reasonable usage time.
And Jailbreak will be new way to go forward most likely, enabling us to enjoy some of the benefits and maybe more (app switching, user profiles, file access etc.).
Let's wait and see.
In the past this has happened with our old iMacs and iBooks and it will happen now with the MacBook (black), but the big difference was that most of the applications were continuously updated and could be installed and now some of the most critical features will be integrated into the basis which will not be updated separately.
The best will be if someone like GeoHot will provide us with an easy install of the official release on the iPad, since I really don't like to jailbreak.
2012-05-21
Wireshark shows packets larger than MTU
TCP segment of a reassembled PDU
wireshark shows a frame with 2574 Bytes,
tcpdump shows the same frame as 2574 Bytes
A very good post:
http://sandilands.info/sgordon/segmentation-offloading-with-wireshark-and-ethtool
and you are sure that the MTU is 1500 or lower (no jumbo frames), since you saw the MSS in the SYN and SYN/ACK, so both sides are certainly below 1500.
Apparently this is because of the NIC doing tcp segmentation offloading:
# ethtool -k eth0
Offload parameters for eth0:
rx-checksumming: on
tx-checksumming: on
scatter-gather: on
tcp-segmentation-offload: on
udp-fragmentation-offload: off
generic-segmentation-offload: on
generic-receive-offload: off
large-receive-offload: on
wireshark shows a frame with 2574 Bytes,
tcpdump shows the same frame as 2574 Bytes
A very good post:
http://sandilands.info/sgordon/segmentation-offloading-with-wireshark-and-ethtool
and you are sure that the MTU is 1500 or lower (no jumbo frames), since you saw the MSS in the SYN and SYN/ACK, so both sides are certainly below 1500.
Apparently this is because of the NIC doing tcp segmentation offloading:
# ethtool -k eth0
Offload parameters for eth0:
rx-checksumming: on
tx-checksumming: on
scatter-gather: on
tcp-segmentation-offload: on
udp-fragmentation-offload: off
generic-segmentation-offload: on
generic-receive-offload: off
large-receive-offload: on
ethtool -K eth0 tso off
ethtool -K eth0 gso off
ethtool -K eth0 gso off
I turned off tcp first but the generic did prevail so I turned off gso and thought I saw only smaller packages but when enabling and disabling it again I did not see the small packets anymore, so maybe a restart is necessary.
Would be nice to see it working or not the 2nd time you disable it. But I won't restart the system.
Would be nice to see it working or not the 2nd time you disable it. But I won't restart the system.
2012-05-11
Networking: Troubleshooting: MTU with ping -l 1472 -f
windows:
ping -f -l 1472 destIP
linux:
ping -M do -s 1472 -c 1 destIP
2012-05-04
linux: fat32 bootable usb stick with ESXi
http://pubs.vmware.com/vsphere-50/index.jsp?topic=%2Fcom.vmware.vsphere.install.doc_50%2FGUID-33C3E7D5-20D0-4F84-B2E3-5CD33D32EAA8.html
linux: ubuntu: map c drive from a windows machine over the network
Start Nautilus, i.e. click on the home folder icon.
Press CTRL-L (for location) and enter smb://<ip or name>/share, e.g. smb://10.0.0.1/c$
It will then ask for domain, username and password
Press CTRL-L (for location) and enter smb://<ip or name>/share, e.g. smb://10.0.0.1/c$
It will then ask for domain, username and password
linux: ubuntu: change keyboard mapping from terminal
setxkbmap fr
http://wiki.laptop.org/go/Keyboard_Files
http://wiki.laptop.org/go/Keyboard_Files
2012-05-03
linux: multiple default gateways (even for aliases)
A really great blog entry, which solved all my issues in no time. The only thing is now that I have multiple distributions and have to find out where to place the commands so that after a reboot it will come back correctly.
http://kindlund.wordpress.com/2007/11/19/configuring-multiple-default-routes-in-linux/
http://kindlund.wordpress.com/2007/11/19/configuring-multiple-default-routes-in-linux/
linux: alias
ifconfig eth0:0 10.0.0.2 netmask 255.255.255.0 up
ifconfig eth0:0 10.0.0.2 netmask 255.255.255.0 down
ifconfig eth0:0 10.0.0.2 netmask 255.255.255.0 down
Subscribe to:
Posts (Atom)