Under normal curcimstances Omnitracker enables import of data in easy and userfriendly way in following formats: csv Excel file/Access file LDAP DB connection via ODBC string data from another instance of Omnitracker data from MSExchange Usually configuration of import of data takes about 15-30 minutes. Import of data takes 15-60minutes (in assumtion that nobody usesWięcej oOmnitracker – import of data[…]
‚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[…]
Last week I attended interesting IT conference related to the program, which I administer every day. Just now I am involved in upgrade of two OT servers, so I could test versions: 11.2, 11.3.3 and 11.4.0. After real disappointment with version 11.4.0 , which didn’t work at all for one of my databases and hadWięcej oOmnitracker Customer Day 2019[…]
Without autoarchivization OT administrator has to once a year/month review all the folders and create subfolders with proper date and exclude them from main OT Index. Otherwise your OT index grows so fast that Omnitracker perfomance is really bad (imagine 4GB Index file). In order to have all your folders autoarchivized, use below script: AutoarchivizationWięcej oOmnitracker – autoarchivization[…]
Here are some good scripts for Omnitracker github integration. Scripts were written by Marc Kohaupt, whom I strongly recommend: https://github.com/debuglevel/omnitracker-git http://debuglevel.de/consulting/
For time critical systems it is recommended to proactively monitor them in real-time. If you use Omnitracker for more than 100 users I would recommend to ensure this system working smoothly. Here are some metrics, which should be checked as recommended by Omninet: Service availability (of all OMNITRACKER services for every instance) Availability of relevantWięcej oOmnitracker monitoring[…]
Invoke your favorite VBA-capable application, such as Word97 or Excel97, and invoke the Visual Basic environment.
Czytaj więcej o Jak „zdalnie” podłączyć się do Omnitrackera …
Czasem się zdarza, że trzeba dokonać rzeczy dziwacznej – a mianowicie połączyć się z poziomu (Excela np.) poprzez Visual Basic do bazy Microsoft SQL Server.
Podzielę się na szybko – może się komuś przyda:
Ten wpis jest bardziej dla mnie ku pamięci…
Czytaj więcej o VisualBasic Script – formatowanie daty po swojemu …