Export SQL query to CSV

1. Execute your Query with "Results to Grid" option selected (You can select this option with its icon or by menu "Query - Results To - Results to grid"). 2. Once your Query has finished, right-click on the results grid and select the option "Save results As...". 3. Save as Type: CSV.

Find Public Key Token of my Project in Visual Studio 2012

In order to find the public key token of your project you need to follow this: 1. Open the Developer Command Prompt fot VS2012. 2. Write this command (Use full path of your DLL file): sn -T C:MyDLLdirectoryMyDLLfile.dll 3. Automatically it shows you your token: Microsoft (R) .NET Framework Strong Name Utility Version 4.0.30319.17929 Copyright …

Sigue leyendo Find Public Key Token of my Project in Visual Studio 2012

Project Professional: Get Current Project Resource Rates with VBA

You can obtain the Current Project Resource Rates by the following code in Visual Basic for Applications: Public Sub UpdateCostRates() Dim ProjectName As Project Set ProjectName = ActiveProject Dim N As Assignment Dim Names As String For Each T In ProjectName.Tasks For Each I In T.Resources For Each P In I.Assignments Set N = P …

Sigue leyendo Project Professional: Get Current Project Resource Rates with VBA

How To: Obtain Workflow Trace in SharePoint

You can get a LOG file with your workflow trace following this steps:1. Edit web.config.2. Insert the following code just BEFORE <appSettings> (always AFTER </System.Workflow.ComponentModel.WorkflowCompiler>): <system.diagnostics> <sources> <source name="System.Workflow.Runtime" > <listeners> <add name = "System.Workflow"/> </listeners> </source> <source name="System.Workflow.Runtime.Hosting"> <listeners> <add name="System.Workflow"/> </listeners> </source> <source name="System.Workflow.Activities"> <listeners> <add name="System.Workflow"/> </listeners> </source> </sources> <sharedListeners> <add name="System.Workflow" type="System.Diagnostics.TextWriterTraceListener" initializeData="C:MyWorkflowTrace.log" …

Sigue leyendo How To: Obtain Workflow Trace in SharePoint