wynalazkowo - eksperymenty małe i duże

Omnitracker – import of data from Powershell

Omnitracker – import of data from Powershell

$objOTApp = New-Object -ComObject OTAut.OtApplication$objOTSession = $objOTApp.MakeSession($strServerName, $strServerPort, $strLoginName, $strPassWd)$objOTFolder = $objOTSession.GetRequestFolderByPath($strFolderName)                  Do {                        Start-Sleep -Seconds 2                        Write-Host „Waiting for OT response…”                        $objImport = $objOTFolder.MakeImport()                        #$objImport                                          }                    Until ($objImport.Datasource -eq „”) #$objOTFolder.ImportDefinitionsWrite-Host „Importing objects to Omnitracker”$objImport.Datasource = $strFileName$objImport.Run($ImportName)$objImport$objOTSession.Logoff()

Omnitracker – reports in different way

Omnitracker – reports in different way

‚pokazuje wszystkie pola z danego katalogu oprocz inherited select  ufd.id, pa.parent,ufd.area, pa.name asFolder, ufd.label, ufd.alias, ufd.run_time_field, otFieldTypes.field_type, case   when ufd.[type] = 254 then ‚ReferenceList’+ Convert(nvarchar(50),  ufd.id)   else”   end as RefTable, case  when ufd.[type] = 254 then ‚ReferenceList’+ Convert(nvarchar(50), ufd.id) + ‚.Request = ‚+ rtrim(pa.name) + ‚ Object’  else”  end as Description_Request, case   when ufd.[type] =Więcej oOmnitracker – reports in different way[…]

Windows Server 2008 R2 – permissions for COM objects

Windows Server 2008 R2 – permissions for COM objects

Sometimes it is needed to set individual user permissions to chosen COM objects like (Excel). Here is short explanation what are these permissions and how to set them: Dcomcnfg.exe provides a user interface for modifying certain settings in the registry. By using Dcomcnfg.exe, you can enable security either on a computer-wide or a process-wide basis. … OrWięcej oWindows Server 2008 R2 – permissions for COM objects[…]

Omnitracker – SVN integration

Omnitracker – SVN integration

‚script retrieves all scripts from OT and stores it in current directory ‚in current directory following folders have to exist:globalScripts,folderScripts,globalforms,folderforms Dim objApp,objSession,scriptsG,scriptsF Dim script Dim AllFolders Dim formsF,formF Dim formsG,formG Dim objFS, objFile Dim CurrentDirectory Dim newfolderpath,newdir Set objApp = CreateObject („OtAut.OtApplication”) Set objSession = objApp.MakeSession („localhost”, 5085, „superuser”, „superuser”) Set objFS = CreateObject(„Scripting.FileSystemObject”) CurrentDirectoryWięcej oOmnitracker – SVN integration[…]