SYMPTOMS
After implementing a Database Fields Foreign Key scenario, the field values are not showing in the result list and document view.
CAUSE
This is related to a misconfiguration in the Databasefields.xml file.
RESOLUTION
Make sure following modules are enabled:
Databasefields
Xmlwrapper
Index Engine
- Hapi Index
Create Database connection using the Databse Wizard.
Verify that the following settings are set for the Primary Field.
Location of the Databasefields.xml (\ZyLAB Data\Indexes\.....\ZxpPlugins\Database fields)
<fielddefinitions table="DatabaseFields" version="1.0"> <fielddefinition dbsync="1" id="ForeignKey" name="ForeignKey" type="3" size="10">
Working example Fields.txt
[Plugins]
P1={CD95DF0A-7EB5-4095-813B-1234A338A147}, Database Fields
P2={8581537B-35E9-430b-A246-396EEA8167E9}, XML Wrapper
[Data Extractors]
[General]
LockName=
LockUser=
LockPid=0
[Version]
Version=1.1
[Field1]
Name=ForeignKey
Type=0
DefaultValue=
FixedValue=
ValueFileName=
Required=0
InputForSearchingRequired=0
ReadOnlyInZyFIND=0
ShowInZySCAN=1
StartDelimiter=<ForeignKey>
EndDelimiter=</ForeignKey>
PrimaryPluginField=0
This is an Example of a correctly cofigured Foreign key scenario Xmlwrapper fields file once a document has been added to the index:
<?xml version="1.0" encoding="UTF-16" standalone="no"?>
<zylab>
<document guid="{4FA4E686-39E4-4594-848F-6C3B1AFA4AB2}" name="0000002L.TXT" path="C:\ZyLAB Data\Index Data\TEST\txt\2013\00000000\" key="" date="20131104" time="15:39:03.788" size="267">
<fields>
<field id="ForeignKey">003</field>
</fields>
</document>
</zylab>
APPLIES TO
6.3
Comments
0 comments
Article is closed for comments.