Creating DCR from excel sheet using Java customization

India123

Hi,

 

We are creating Data capture record from excel data using java customization but when I am trying to open that record it is not opening in the form of Template. 

 

Please fine below the xml not opening as template:-

 

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE record SYSTEM "dcr4.5.dtd">
<record name="testing" type="content"><item name="SIC-Code"><value>1743</value></item><item name="SIC-Name"><value>Terrazzo, tile, marble, mosaic work</value></item><it
em name="Classification-Name"><value>Tile, Stone, Marble, Mosaic or Terrazzo Work - int</value></item><item name="Classification-Codes"><value>99746</value></item><item
name="States"><value>AL</value></item><item name="Line-of-Business"><value>BOP</value></item><item name="Industry"><value>Artisan Contractors</value></item><item name=
"Keywords"><value>,installation,building,service,residential,commercial,school,institutional,contractor,construction,sub-contractor,subcontractor,terrazzo,tile,marble,g
ranite,interior,slate,stone,ceramic,floors,floor,countertops,grouting,grout,contractor,contracting,sub contractor,subcontracting,artisan contractor,1743</value></item><
item name="Business-Desc"><value>This classification applies to contractors engaged in the setting and installing of interior ceramic tile, marble and mosaic tile and i
n mixing of marble particles and cement to make terrazzo flooring at the site of new construction or inside of an existing building. This classification does not includ
e manufacturing precast terrazzo steps, benches and other terrazzo articles away from the construction site.</value></item><item name="Elligible-Operations"><value>"Cer
amic tile installation
Granite, interior, installation
Mantel, marble or stone, installation
Marble, granite and slate, interior, contractors
Mosaic work
Slate, interior, installation
Stone flooring installation
Terrazzo and tile refinishing
Terrazzo contractors
Tile (except resilient) contractors
Tile (except resilient) laying and setting"</value></item><item name="Inelligible-Operations"><value>Exterior marble, granite, and slate work</value></item><item name="
Underwriting-Highlights"><value>test</value></item><item name="Related-Classification"><value>test</value></item><item name="Link-Name"><value>http://claimssp.farmersin
surance.com/BI/BIPMO/PM/CAG/Shared%20Documents/2.%20Initiation/Related%20Do</value></item><item name="Notes"><value>test</value></item></record>

 

Please let me know how to resolve this issue.

Garth McMillan

Are you creating a DCR or a DCF? Your XML looks kind of like a DCF (though perhaps an older version that I'm not familiar with - it's definately not valid with the current TeamSite DCF schema).

 

Assuming you are creating a DCR:

 

1. Make sure it's valid XML (I've never seen "<!DOCTYPE record SYSTEM "dcr4.5.dtd">" in our DCRs, but perhaps yours are an older format, 4.5, and that's how they are.). Obviously, the XML needs to match to the DCF scheme.

 

2. Make sure you set the appropriate TeamSite Extended Attributes (EAs) for the DCRs.

 

Have a look at the properties of a DCR created by the interface and you will see some properties like "TeamSite/Templating/DCR/Type" and "iw_form_valid". The DCR won't open without these properties.

 

You can create them programatically via the CSSDK or you can use the command line tools that are provided with TeamSite.

 

On a general forum post note: If you are posting code, please use the "code" block so that it formats nicely.