Fredrik the developer

How to remove Sharepoint from default site

2010-09-06T11:41:00.000-07:00

I have started to play around with Sharepoint a bit and it was frustrated that it for some reason took control over my default website. I Googled around a bit and couldn't find any simple "this is how you do it". Doh! It as so easy! Just enter the Central Administration - Application Management and click "Remove Sharepoint from IIS website". Then select your default IIS website and make sure you don't delete it and click OK. Sharepoint is now removed from your site and all is ok! Simple! :)

Remote debugging with Delphi 5

2010-08-08T02:44:00.000-07:00

I am a longtime Delphi 5 user and the main reason of why I haven't upgraded to the latest Delphi-version is that I have som many 3rd party components that need to be upgraded as well. Unfortunately one of the key component pack I have without source and the supplier seem to be out of business. Big mistake I made back then but anyway. Since I have upgraded to Windows 7 and 64-bit it's not optimal to run Delphi 5 on it due to the fact that Delphi 5 breaks some of the security thoughts implemented in Windows. There are ways to fix it but I figured that it was about time to try out and work with Delphi 5 in a VMWare instance of Windows XP with Delphi 5 installed. And it's working like a charm. VMWare starts a lot faster than my old computer used to do and now I have some instances of Delphi 5 already running so I just can start code instantaneously.

Now to my key issue - remote debugging. It has been there for 10 - 12 years (at least) and I have never even tried it! What I have done is installed the Borland Remote Debugger on my Windows 7 PC and then I add the remote debugger symbols and flag that the project should be run remotely. Very nice! Now I can try the application out in Windows 7 and sort out any compability issues while still coding in my good old Delphi 5.

As a sidenote.. I am working on migrating to Delphi 2007 and then to the latest edition... but it takes time... :)

Migrating IBExpert to a new computer

2010-08-02T07:20:00.000-07:00

I have got a new computer that I will run Windows 7, 64-bit on and I am using IBExpert frequently. I have also several databases already registered so this is how I went about to fix it.

1. Rename the new computer to the name the old computer had (the license is tied to computer name).
2. Locate the files in file://oldcomputer/c$/Documents and Settings\\Application Data\HK-Software\IBExpert
3. Copy the files to C:\Users\\AppData\Roaming\HK-Software\IBExpert
4. Done!

Pretty simple when you know how. :)

X-marks to the rescue!

2010-07-26T02:43:00.000-07:00

I have been using X-marks from http://www.xmarks.com/ for about a year now or so and I am quite happy with it. I haven't really mentioned it to anyone but today I have to shout it. I am working on a new computer and will be using IE and Firefox simultaneously so I installed X-Marks to work with both browsers. Unfortunately my sync got messed up so it removed all my quick links! I was a bit shocked but fortunately X-marks has a feature that allows you to go back and use older revisions of your bookmarks. Brilliant! So if you aren't using it.. get it now! :)

Experiencing HTC Hero and Android

2009-09-27T13:23:00.000-07:00

A month or so ago I had my HTC S710 Windows Mobile out while canoeing and it rained heavy so it hasn't been the same since then. Especially the screen just going black is quite irritating and not to say very unproductive. Curious on this new Android-platform and having a desire to develop software for it made me look on Android-phones, yesterday I went out and bought a HTC Hero.

My first experiences wasn't all that well. I tried it out of the box and it seemed okay. Then I remembered that my old HTC needed a ROM-upgrade very early on and it totally cleaned everything so I decided to upgrade to the latest ROM from start. Unfortunately it made the HTC Sync software unable to connect to my phone. After uninstalling/installing the software and upgrading to XP and numerous other stuff it finally got sync with Outlook up and running again. I hope it stays that way.

Next problem... I can't find the files on the phone! And the device that Windows claim is the new one states that "Please insert disk into drive". After heavy googling I finally figured out that you must slide the USB-icon on the phone downwards and Mount the drive! I find it hard to believe that it works that way but I guess I have to face the reality and now I know...

And that is all for the moment. I hope I am able to write more about my experiences with HTC Hero and Android later on in this blog.

Transparent form for Delphi

2009-05-28T02:48:00.000-07:00

I got the question if I could make one of my applications transparent. Well, I know it's possible but I have no clue on how to do it. I tried a lot of different examples on the web but none of them seemed to work with my Delphi 5 application. They also simply ignored the panel that I had on the form. Then I stumbled upon this link:

http://users.telenet.be/ws36637/transparent1.html

Simple code and real easy to implement. The example was well written and the code got the job done. Thanks Serhiy for it! Apparantly he has a page called the Delphi beacon at

http://users.telenet.be/ws36637/

I think I will spend a few more minutes on his page and see what he is doing. :)

PDF for the programmer...

2009-03-22T05:51:00.000-07:00

Since PDF is probably the de-facto format when distributing documents on the Internet today it's good to know how to generate such files. I will try to gather a couple of links here for PDF-programming and write a few lines if possible.

PDF Creator
http://www.pdfforge.org/products/pdfcreator
Has a free driver but fly2pdf which is the Active X library is not free for commercial use.

Joomla/VirtueMart and restrict content

2009-02-08T07:11:00.000-08:00

My customer requested that certain parts of VirtueMart only would be accessible if you are registered user. This is pretty easy when you have found the proper object to call. You need to retrieve the user object and then check if it has an ID:

$user =& JFactory::getUser();

if ($user->id > 0)
{ /* do code */}

That's all to it. When you have gotten the user-object you can of course access a whole lot more information which is documented in the user class. Below are two interesting links if you need to find out more.

http://api.joomla.org/Joomla-Framework/User/JUser.html

http://www.jlleblanc.com/joomla/Tutorials/JUser_tutorial_for_Joomla!_1%115/

VirtueMart not showing all related products...

2009-02-02T09:09:00.000-08:00

Today I found a little bug in VirtueMart 1.13 or perhaps it's a feature. When using related products on your product page only 4 items of related products would show. If you modify
administrator/components/com_virtuemart/html/shop.product_details.php

at line 85:

$q .= "AND FIND_IN_SET(#__{vm}_product.product_id, REPLACE(related_products, '', ',' )) LIMIT 0, 4";

to

$q .= "AND FIND_IN_SET(#__{vm}_product.product_id, REPLACE(related_products, '', ',' )) ";

you remove this silly limit. Easy! :)

VirtueMart experiences while building a pretty large site

2009-02-01T04:28:00.000-08:00

Currently I am building a website with a whole lot of products and categories... well to be exact there is currently 22623 products and a total of 6973 categories! Yes, that's a whole lot of categories and some might think it sounds crazy but it gives an organized look and the number of products will rise up and probably beyond 100000 but the categories will probably remain the same.

Initially I wasn't aware of that the customer wanted to have these huge amounts of data in the system. Having run systems with less than 1000 products and 20 - 30 categories or so I figured that this customer was about the same ratio. Was I up for a big surprise...

The import of the product was done using a custom application built in Delphi that took the Excel-files and added the data directly into the MySQL-database. The categories was worse. They didn't exist! Adding all of them in VirtueMart would have taking forever as well. We also did experience a whole lot of slowness over the Internet since the test-site was located far away from us and due to issues with VirtueMart and Internet Explorer 7. I decided to create a small GUI in Delphi now titled "WorkMan ViMA", except a public release in a few months time. It allowed my customer to add multiple categories entered in a textbox and just selecting appropriate parent category in a treeview. Adding all of those categories was suddenly quite easy and fast.

The next big issue was the category menu at the frontpage - it was dead slow. After trying all possible menus and some Ajax-trees I found a plaintext XHTML-tree that was rock solid and fast as a racecar. I forgot the link but if I find it I will update this blog.

Issues with administration in Internet Explorer was also a nightmare. Operation aborted error popped up all the time. Out of chance we tried Firefox - what a difference! It actually works okay in there now. Future customers will have to download and install FF and use it for administration.

While working with products it occured that the search-possibilities aren't quite optimal when you have more than 10-20 categories or a whole lot of products. Hopefully someone is looking at this and provide a fix in a future update. I will look around for tweaks but I am not sure I will find one. Otherwise I will take a shot at adding better search possibilities than those that exists today.

Well, that's my initial take on VirtueMart and a whole lot of data. Expect to read more about it soon.