blog

Adding Web User Control to aspx page

Veröffentlicht am

As you cannot add a web user control to your Visual Studio 2005 toolbox I struggled how to do it the easy way. Here is the solution: To add a Web user control to a aspx page simple switch to the design view (of the aspx file) and drag the ascx file from the solution explorer onto the page. Visual Studio does the rest for you. No need for you to add the register tag at the top of the page or think of any stuff like that. Source: http://msdn.microsoft.com/en-us/library/3457w616(VS.80).aspx Share on Facebook

Share on Facebook
blog

Using quick parts in Office 2007

Veröffentlicht am

A nice feature of office 2007 is the quick parts functionality. I use this in Outlook to insert often used texts into my e-mails. The only problem is to remove entries off the list. I found an easy article describing a way to do this with Word 2007. You can find it here: http://www.watchingthenet.com/save-and-reuse-frequently-typed-text-in-outlook-2007-with-quick-parts.html If you only want to change a quick part, you can just save the changed text using the same name. Outlook will replace the previous one. Share on Facebook

Share on Facebook
blog

Cleaning the asyncoperationbase table in MSCRM 4 part 2

Veröffentlicht am

PLEASE NOTE my update on this on 2009-Apr-05: http://www.kornelius.org/index.php/blog/2-news/43-cleaning-the-asyncoperationbase-table-in-mscrm-4-pt-3 I previously posted about the asyncoperationbase-table in Microsoft Dynamics CRM. In the meantime I found out, that it would take several days with 100% CPU usage on our databases server to get all records deleted with the posted method. So I decided to go into deep and do it myself. I placed the following statements to the database to delete all completed jobs: update AsyncOperationBase set deletionstatecode=2 where deletionstatecode=0 and statecode=3 and AsyncOperationBase.completedon is not null delete from workflowlogbase where AsyncOperationid in (select AsyncOperationid from AsyncOperationBase where deletionstatecode=2) update DuplicateRecordBase set DeletionStateCode=2 where asyncoperationid in (select DuplicateRecordBase.asyncoperationid from DuplicateRecordBase left join asyncoperationbase on (DuplicateRecordBase.asyncoperationid=asyncoperationbase.asyncoperationid and asyncoperationbase.deletionstatecode=0) […]

Share on Facebook
blog

Managing size of AsyncOperationBase table in CRM 4.0

Veröffentlicht am

I found this (http://blogs.msdn.com/crm/archive/2008/07/29/managing-size-of-asyncoperationbase-table-in-crm-4-0.aspx) very interesting article about the size of your MSCRM database. Several GB were present in ours already, mostly because of the AsyncOperationBase table. I had the change the code to get it working on my CRM 4. I remove the part about the operationtype to delete all kind of objects, but left it for this example. Here is the result: QueryExpression expression = new QueryExpression(); expression.EntityName = EntityName.asyncoperation.ToString(); ColumnSet cs=new ColumnSet(); cs.Attributes=new string[] { „asyncoperationid“ }; expression.ColumnSet = cs; ConditionExpression cState = new ConditionExpression(); cState.AttributeName = „statecode“; cState.Operator = ConditionOperator.Equal; cState.Values = new object[1]; cState.Values[0] = (int)AsyncOperationState.Completed; ConditionExpression cCompletedon = new ConditionExpression(); cCompletedon.AttributeName = „completedon“; cCompletedon.Operator = ConditionOperator.OlderThanXMonths; cCompletedon.Values = new […]

Share on Facebook
blog

Customize SharePoint Services 3.0 search results

Veröffentlicht am

To customize the layout of your WSS search results page you just need to edit the file searchresults.aspx located in C:\Programme\Gemeinsame Dateien\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS or C:\Program Files\Common Files\Microsoft Shared\web server extensions\12\TEMPLATE\LAYOUTS Look for the SearchWC:CoreResultsWebPart tag and add the attribute OnPreRender=“PreRender_Handler“ On the top of the page add the following code-snipped: <script type=“text/javascript“>mce:0</script> I used this to add a link to the results parent folder. Unfortunately you have to handle this with regular expressions. Perhaps there is a better way, but I did not find any. Share on Facebook

Share on Facebook
blog

PDF Ausgabe in Lexware professional und x64

Veröffentlicht am

Lexware bringt eine die Möglichkeit der PDF-Ausgabe praktischer weiße gleich mit. Dies hat immer gut funktioniert, bis wir auf einen 2003 Server mit 64 bit umgestiegen sind. Bei Anwahl der PDF-Exports stürzte Lexware prompt ab. Dies nahmen wir erst einmal so hin, da es auf einem anderen Server (kein x64) funktionierte. Bei der Installation auf einem anderen Rechner fiel mir auf, dass Lexware die PDF-Engine von Amyuni verwendet und zwar in Version 2.5. Da wir diese selbst einsetzen wusste ich, dass auch in dieser veralteten Version bereits rudimentäre x64 Unterstützung (wenn evtl. auch nicht offiziell) gegeben war. Die Lösung war schnell gefunden und simpel. Es musste nur beim „Lexware PDF-Export 3“-Drucker ein neuer „lokaler Port“ […]

Share on Facebook
blog

Falsches Datum in Fotos ändern

Veröffentlicht am

Nach einer Woche Urlaub musste ich feststellen, dass das Datum in meiner Kamera nicht richtig eingestellt war. So musste das Datum von Januar 2004 auf August 2008 ändern. Das Tool Exif-Batch hat mir hierbei wunderbare Dienste geleistet. Einfach den Order mit den Bildern öffnen und Monat/Jahr einstellen und setzen. Den Unterschied der Tage kann man dann ganz einfach in Stunden um rechnen und abziehen/addieren lassen. Zu guter Letzt kann man das Bilddatum aus den Exif-Daten als Dateierstellungsdatum setzen lassen. Das Programm ist unter http://www.heise.de/software/download/exif_batch/55678 bzw. unter http://elephanty.com/reise-highlights zu finden. Share on Facebook

Share on Facebook
blog

Different keyboard layout in Flash

Veröffentlicht am

Firefox 3 introduced a new bug, which causes Flash to ignore the local keyboard layout (ie. deDE) in input fields like a textbox. Instead it uses the default: enUS. This problem occurs if you set the parameter „wmode“ to „opaque“ or „transparent“. Removing that parameter fixes the problem. The problem is: if wmode is not set to opaque, you cannot debug your flash application with Flex Builder 3 and Firefox 3. So, now you have to choose what you want to achieve. Or switch the parameter before publishing a new release. Share on Facebook

Share on Facebook
blog

Watch your component-ids in Adobe Flex 3

Veröffentlicht am

Using Flex Builder brought me to a frustrating problem. As soon as my application got a vertical scrollbar a (about 50px high) margin appeared above the scrollbar and all content was moved down. It was still flash content up there – so not the flash itself was moved down – but it was not used for any controls. Working on this and circling around it brought me to the strange solution. One of my controls had the ID-attribute value „controlBar“ (at first it was an mx:ApplicationControlBar with that ID till i changed it to a canvas or button for testing later). When I changed that id to „controlBar2“ everything was fine again. Maybe Ids with […]

Share on Facebook
blog

F7 keyboard shortcut in Visual Studio

Veröffentlicht am

In some scenarios, the F7 key does not switch between code and designer and back anymore. The only thing it does is switch from designer to code. This seems to be related to some profilesettings. To fix this, you can do the following: Go to Tools – Options – Environment – Keyboard (Extras – Optionen – Umgebung – Tastatur) Set focus in „Press Shortcut Keys“ text box („Tastenkombination drücken“) Press F7 or some other keystroke you want The „Shortcut currently used by“ („Tastenkombination wird momentan verwendet von“) box will show the command currently invoked by the keystroke. Set focus to „Show Commands Containing“ („Befehle mit folgendem Inhalt anzeigen“) and type ToggleDesigner („AnsichtDesigner“) This will select […]

Share on Facebook