Saturday, January 31, 2009

What do you want to know about Exact Tables: GBKMUT AMUTAK BACOAPPLOG ?

I use Google Analytics on my blog to get information of the visitors who are visiting my web blog. Sometimes I got hits on searches for Exact tables like: GBKMUT, AMUTAK, BACOAPPLOG etc.... I have no idea what the reason is for these searches. Maybe I can help you.


Image credits to doraeimages


On the web site of Exact Software, database documentation is available for:

Exact Globe click here to open.
Exact Synergy Enterprise click here to open.

If you need help, please leave a comment with an explanation what you are looking for or to tell if the database documentation was usefull.




Here is a list of all Exact tables:
aaccod, aacmut,aactbl,AbsenceEntitlements,AbsenceMainTypes,Absences,AbsenceTypes,accncd
AccountAdministrations,AccountCategories,AccountCategoryNames,
AccountClassesAccountClassNames,AccountConversionTypes,AccountMandatory,
AccountReportCategories,AccountStatus,AccountTypeProperties,AccountTypes,Addresses,
AddressPostCodes,AddressStates,AddressTypes,afgper,amutak,amutas,artext,artlnk,
artoms,artver,artleve,BacoAccessServers,BacoAppLog,BacoAppLogApps,BacoAppLogDays,
BacoAppLogHours,BacoDelegations,BacoDiscussionCategories,BacoDiscussionCounts,
BacoDiscussionFixedGroups,BacoDiscussionFixedTypes,BacoDiscussionGRoles,
BacoDiscussionGroups,BacoDiscussionLayoutLanguage,BacoDiscussionNewsLayouts,
BacoDiscussionPictures,BacoDiscussions,BacoDiscussionStates,BacoDiscussionStdPictures,
BacoDiscussionSubCategories,BacoDiscussionVersions,BacoErrorLog,BacoFreeNumbers,
BacoFunctionRoles,BacoFunctions,BacoLicenceOptions,BacoProcessLog,BacoProducts,
BacoReplicationArticles,BacoReplicationArticleSubtopics,BacoReplicationConflicts
BacoReplicationPushedSubtopics,BacoReplicationPushedTopics,BacoReplicationReplicatedArticles
BacoReplicationReplicatedSubtopics,BacoReplicationReplicatedTopics,BacoReplicationSubtopics
BacoReplicationTopics,BacoSearchTemplateFields,BacoSearchTemplates,BacoSettings
BacoUserGroups,Balance,BankAccounts,BankAuthorizations,BankFormats,BankNames,
BankTransactions,Barcodes,bdgmth,bdgtbl,bdgvrs,BDPictureRefs,BDViewColumns,bedryf,
betcd,bnkacc,bnkkop,btwavk,btwkpl,btwkpp,btwtrs,btwvrt,Budgets,CardSettings,
cicmpy,cicntp,ciFreeFields,Cisect,Cisize,Classifications,CompanyClasses,CompanyClassNames,
CompanyCostcenters,CompanyEmployees,CompanyLogs,CompanyParticipations,
CompetenceMatchProfiles,ConsolidationBalances,ConsolidationStructures,
ContractParameters,CostcenterClasses,CostcenterClassNames,CRMPageContent,CRMPages
CurrencyPeriodExchangeRates,dagbk,DataSource_Type,DaylightSavingDates,DDBrowseInfo,
DDColumns,DDIndexColumns,DDIndexes,DDReferenceColumns,DDReferences,DDTables,
DDTests,DivisionCreditors,DivisionDebtors,DocumentReferences,DocumentStatistics,
dtproperties,EbcBasicTypes,EbcBrowsers,EbcColumnGroups,EbcComponentRelations,
EbcComponentRelationTypes,EbcComponents,EbcComponentTypes
EbcDataComponentTypes,EbcDataLog,EbcDefaultStates,EbcDefaultTypes,EbcEnabledStates,
EbcEntities,EbcEntityRelations,EbcGroups,EbcLogCustom,EbcPropRelations,EbcPropRelationStates
EbcPropRelationTypes,EbcProps,EbcPropTypes,epavlk,epavlr,evbswz,evloc,ExactLicense,
ExactOptions,ExactTrialModules,fadpre,fadprm,fadprt,fagrp,fakcod,fakvcd,fatran,
FavoriteCategories,Favorites,frhkrg,frhsrg,frhstx,frkrg,frsrg,frstx,frvkrg,frvsrg,frvstx,
FunctionGroupDetails,FunctionGroups
gbkmut,grtbk,hrcomp_resource,hrcomp_trans,HRCompanyPeriods,HRCompetencies,
HRCompetencyRatings,hrcomponentitemlinks,hrcomponents,HREffectivedateDataLog,
HREmployeePeriods,HRErrorLog,hrfin,hrfint,hrfree,hrFreeFields,HRHumresLinks,hrjbtl,hrloc,
HRMainFint,HRMCompetenceGroups,HRMCompetenceLinks,HRMCompetenceProfiles,
HRMCompetenceRelations,HRMCompetences,
HRMFieldTypes,HRMFormElements,HRMFormLayouts,,HRMSelectionValues,HrPasswds
hrpayroll,hrpayrolldeclarations,,HRProcessLogs,HRProcessRequests,HRProcessTypes,
HRRoleDefs,HRRoleLevels,HRRoleLog,HRRoles,hrsk,hrwdoc,humres,intfac,inthav,inthis,
intlev,intmtf,intnr,intreg,intshp,intstl,intta,inttb,inttra,INWHSM,ItemAccounts,
ItemAssortment,ItemAttachmentArchive,ItemAttachments,ItemBaskets,ItemCatalogs,
ItemClasses,ItemClassLinks,ItemClassNames
ItemCountries,ItemCountryTranslations,ItemDivisions,ItemNumbers,ItemPrices,ItemProcess,
ItemProcessTypes,ItemRelations,ItemRelationTypes,ItemRelationTypeState,,ItemReleases
ItemReleaseStatus,Items,ItemTranslationLog,ItemTranslations,ItemUnits,kplkop,kplvrd,ksdrek
ksprek,kstdr,kstpl,land,landClasses,landClassNames,LastAction,laycrd,laydeb,layouts,laytype
License_Management,magaz,MailMergePending,mapfil,mapfld,mapfor,mapmsc,NLSal,
NLSalHrFint,NLSalSettings,NoiseWords,NoteLinkTableFields,notes,Numbers,
Numeric_field,Operations,Opportunities,OpportunityAccounts,OpportunityContacts,
OpportunityHistories,OpportunityItems,OpportunityProjects
OpportunityReasons,OpportunityRoles,OpportunitySources,ordlev,ordlog,ordsel,orhkrg,orhsrg
orhstx,orkrg,orsrg,orstx,orvkrg,orvsrg,orvstx,perdat,PeriodMaps,PortalFrames,Portals,pospreset
prafd,pred,prFreeFields,PRMember,ProductivityReports,ProjectAccounts,PRProject,PublicHolidays
pwfunc,pwmagaz,pwrole,pwrprm,pwruc,rates,RatingAmounts,RatioDefinitions,RatioFilterAccounts
recipe,RequestActions,RequestFieldOptions,RequestFields,RequestItems,RequestPaymentTypes,
RequestPriorities,RequestStatHistory,RequestStatus,RequestTasks,RequestViewColumns,
ResellerNews,ResourceStatus,ResourceTypes,RoleFunctionGroups,Routings,SearchTemplateFields,
SearchTemplates,Settings,ShippingDays,staffl,stfoms,SubSectors,syscrc,sysmnu,sysmnuusr,
taal,taxcod,taxdef,TaxSchedule,Templates,Terms,TimeZones,TransactionsPending,
TransactionTypes,Transfer,usrbar,usrmnu,valuta,VendorDetails,VendorTaxReturns,
Version_Detail_log,Version_Log,verslg,voorrd,WebContent,WebStyle,WordReferences,
Words,WordSynonyms,Workcenters,WorkflowOwnershipOptions,WorkScheduleGroups
WorkScheduleLinks,WorkSchedules,XMLEvents,XMLFiles,XMLGLTransactionsLog,
XMLReplications
XMLReplicationSources,XMLTopicDefinitions,XMLTopicHistory,XMLTopics,XMLTopicsDefinition
ZipCodeRanges

Sunday, January 25, 2009

How to execute a script on multiple databases?

This blog post will describe how you can execute a script on multiple databases. For instances to retrieve the number of records in a table or to retrieve a specific value. The concept of the script is to generate the script which you want to execute on all database. In the example I will use, the script will retrieve the release of the software on the databases of Exact. If it is not an Exact database the script will not be executed.

-- Begin script: How to execute a script in multiple databases?

SET NOCOUNT ON

IF EXISTS (SELECT TOP 1 * FROM tempdb.dbo.sysobjects
WHERE Xtype ='U' AND ID = object_id(N'tempdb..#TableExport'))
BEGIN
DROP TABLE #TableExport
END
-- Create table to store retrieved data.
CREATE TABLE #TableExport (DBNAME NVARCHAR(256),Value nvarchar(3))

DECLARE DB CURSOR FOR SELECT DBID,NAME FROM MASTER..SYSDATABASES WHERE DBID > 4 -- Select Database ID and Name of all User databases
OPEN DB
DECLARE @DBNAME varchar(256); -- Database name
DECLARE @DBID nvarchar(3); -- Database ID
DECLARE @SQL nvarchar(4000); -- Generated SQL Script which will be executed against all databases

FETCH NEXT FROM DB INTO @DBID,@DBNAME
WHILE @@FETCH_STATUS = 0
BEGIN
-- Generate SQL script for the first database in paramater @SQL
SET @SQL = N'USE [' + @DBNAME + ']IF OBJECT_ID(''ExactLicense'') IS NOT NULL'
+ ' INSERT INTO #TableExport (DBNAME,Value)'
+ ' SELECT '''+@DBNAME + ''' as dbname,B.longvalue
FROM ['+@DBNAME+']..BacoSettings B
WHERE SettingType = 0 AND SettingGroup = ''General'' AND Settingname = ''Batch''
'
EXEC SP_EXECUTESQL @SQL -- Execute the generated script.

FETCH NEXT FROM DB INTO @DBID,@DBNAME -- Generate and execute script for the second database
END
CLOSE DB
DEALLOCATE DB
SELECT * FROM #TableExport ORDER BY DBNAME --Retrieve all data.
DROP TABLE #TableExport

-- END script: How to execute a script in multiple databases?

Wednesday, January 21, 2009

Are you able to scale up your site in a few minutes ?

On the 20th januari, Barack Obama was sworn in as the 44th president of the United States of America. Google has published statistics about the impact of the inauguration on the search activities. As a web site owner, you need to be prepared to handle the extra traffic to your site during these events. Here an example of the increased number of searches for people who where part of the inauguration.

I think Google did a good job, the search was functioning very well during and after the inauguration.

What happens in the world can have impact on your site. This also applies to actions executed by your company. For instance an e-mail to a group of customers or prospects. Planning of these activities should be done in cooperation with your web site administrator. Your site should be able to handle all traffic as a result of your mailing. To handle all traffic after an emailing, you should be able to scale up your site temporarily. Monitoring of your own site traffic and the usage of the underlying hardware is essential for this.

Are you able to scale up your web in  a few minutes if needed?

Sunday, January 18, 2009

Why did we build our own search engine in Exact Synergy Enterprise?

In Exact Synergy Enterprise we have made major changes to the search logic. Sometimes I got questions from people why we did not implement Google or other available engines. I think this is a valid question. In my previous blog: Why is Enterprise search more complex than we search? I explained the difference between Enterprise search and web search.

In this blog I will explain the main reasons for our own developed search engine:

  1. Exact Search engine is integrated in the software. No additional deployments steps are necessary to use the engine.
  2. No additional configuration is not needed. Index process is configured out of the box. Only one background job to schedule the indexing process.
  3. No additional hardware is needed to use the search engine.
  4. Access control of content is integrated in the Exact Search engine.
  5. Development costs versus license fee of external search technology.
  6. Training of support and consultancy.
Can it happen that we will use an external search engine in the future? Yes, there will be a moment that we will make use of external search technology. If you ask when, I do not know at this moment. We continually follow available products. The quality of the result set is not the only factor for a decision. We will take the mentioned reasons into account.

If you know search engines who has a good answer on the mentioned reasons feel free to contact me.

Saturday, January 10, 2009

Product review of your product by popular bloggers



A lot of customers are using the web to look for review of products they are looking for. On a lot of sites consumers can tell about their experiences of the product. Bloggers also write about their experiences with products. This can be positive or negative. It fully depends if the expectations meets the experience of the product. Here are some examples:

The kinds of Products I want to touch in 2009
Windows 7 First Impression
Online forms: just ask what's really needed

Everybody in the world can start blogging. Popular bloggers have a lot of followers (ChrisBrogan.com 17.129 readers via feed burner) These bloggers are influencers for the products they are reviewing. A positive review about your product is a free advertisement. Imagine what the impact is of a blog post with a negative product review of your product. It is not the question if you want that a popular blogger will review your product. It is the choice of the blogger if he wants to share his experiences about your product. You can't influence this as product manager. Therefore as a product manager you should ask yourself the question:

Is my product good enough for a review by a popular independent blogger?

Have you ever asked yourself this question?

Tuesday, January 6, 2009

Why is Enterprise Search more complex than web or desktop search?

Within an enterprise, people expect to find their information, in the same and easy way, as they find their information on the web with Google. During a project I did, to improve the search of Exact Synergy Enterprise, I had one principle:

Search = Find

Why should you store information if you can't find it!



A user will start a search if he expects to find the information he is looking for. This principle applies to the 3 different types of search:
1) Web search. Like Google, Yahoo etc.
2) Desktop search. Search tools to find the content of a user's own computer.
3) Enterprise Search. Search technology to find information within an organization.

Access control to the data is a big difference between Enterprise search and the other 2 search types.  On the Web, everybody is allowed to see the data. On your desktop you are allowed to see all data, because you are the owner. Web and desktop search can index all the data without to take access control into account. Within an Enterprise, access control to data is very important. For instance payroll slips should only be accessible by the HR department and the resource itself. Other people are not allowed to see this payroll slip.

Therefore Enterprise search is a bigger challenge in comparison with web search or desktop search. A lot of tools are available to index your data in your Enterprise. For instance Microsoft Search Server 2008, Fulltext index of SQL Server, Autonomy a leader in Enterprise Search.
However these tools index the data on the same way as web search. They are not aware of the security model in your enterprise application. With these tools, you still need to implement your security model in the search application. In combination with the configuration and deployment of these tools your enterprise application can get very complex.
This is one of the main reasons why we have developed an search engine which is aware of the security model of Exact Synergy Enterprise. However Search, or better Find, is never finished and we are always looking to further improve the search.

Do you also experience the challenge of access control to your data in your search application?
If yes, how have you implemented the security model of your application in your Enterprise Search?