Using the ‘Format’ and ‘Special’ Advanced Data Fields

Summary:

The Format and Special advanced data fields allow users to include formatting information in their import data. The Format data field is used to set properties such as box shape, color, and field layout. The Special advanced data field is used to specify the chart properties such as background, title, and header and footer information. The Special field can also be used to exclude a record (i.e. calculations, totals, etc.) if it does not pertain to your hierarchy.

Procedure:

In order to take advantage of the Format and Special fields you must include them in your data source.

For example, importing the following data:

ID Reports To Name Title Special Function
title=”My Corp” font= “Verdana, 24”
chart_fill=”solidfill, green”
1 Lynn Brewer CEO fields_show=”Name, Title”, font=”Verdana, 12, blue”
2 Larry Stevens VP Sales fields_show=”Name,” , font=”Verdana, 9″, box=”round_rect”
3 Claire Chancellor VP Engineering

The Special field can also be used to ignore any row from the import data source. For example, as shown below, an Excel file containing a summary row.

ID Reports To Name Title Salary Special
1 Lynn Brewer CEO 125,000
2 1 Larry Stevens VP Sales 75,000
3 2 Claire Chancellor VP Engineering 100,000
Total 300,000 Ingore

The following tables describe the different keywords, attributes and values that can be used with the Format and Special advanced data fields.

Format Options

Keyword Attribute Allowed Values Example
font [Fields] Field names defined in the data source. If no fields are specified, font properties are applied to all fields font=”[Name, Email, Title], Tahoma, 16, normal, center, vcenter, green”
Font Name All available font names
Font Size all sizes from 8pt to 72pt
Font style bold, normal, italic, underline
Font Alignment center, left, right, top, bottom, vcenter
Font Color red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
box Shape Type rect, roundrect, octagon, triangle, circle, triangleinrectangle, circleinsquare, circleintriangle, invtriangleinrectangle box=”roundrect, double, dotted, FFFFFF”
Box Border Type hair, single, double, triple, quad, singlesingle, doublesingle, triplesingle, quadsingle, singledouble, singletriple, singlequad
Box Line Type solid, dotted, dashed
Border Color red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
box_fill Fill Type nobackground, transparent, solidfill, gradient, texture, picture box_fill=”nobackground, green, yelloww, diagonalup, 3, fittobox”
Fill Color 1 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Fill Color 2 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Gradient Type horizontal, vertical, diagonalup, diagonaldown, fromcorner, fromcenter
Variant Gradient 0,1,2,3 (positions of the gradients)
FitTo fittochart, fittobox
fields_show Fields field names as defined in the datasource fields_show=”Name,Title,Email”
connector Line Color red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF] connector=”red,solid,1.0″
Line Type solid, dotted, dashed
Line Weight 0.0 – 6.0
Style Arrow  in, out (use both to put arrows on either end of a connector)
box_shadow Shadow Type noshadow, drop, continuousdrop, diffuselightfrontdrop, pointlightfrontdrop, raisedline, sunkenline, raised, sunken, lineshadow box_shadow=”drop,4,4,down_right,green”
Xoffset horizontal offset 0-100
Yoffset vertical offset 0-100
Offset Type down_right, down_left, up_right, up_left
Shadow Color red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]

Special Options

Keyword Attribute Values Example Special Format
chart NA Text Chart=”2005 structure”
title NA Text title=”Infoquest Corp.” font=”Verdana,28,bold”
left_header NA Text left_header=”2006″ font=”Verdana,8″
center_header NA Text center_header=
“Executive Board”
font=
“Verdana,16,italic”
right_header NA Text right_header=
“01/17/2006”
font=”Verdana,8″
left_footer NA Text  left_footer=
“Development”
font=”Verdana,8″
center_footer NA Text center_footer=
“New York Office”
font=”Verdana,10″
right_footer NA Text right_footer=”page 1″ font=”Verdana,8″
chart Chart Border Type hair, single, double, triple, quad, singlesingle, doublesingle, triplesingle, quadsingle, singledouble, singletriple, singlequad chart=”double,dotted,yellow”
Chart border Type solid, dotted, dashed
Chart Border Color red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
chart_fill Fill Type  nobackground, transparent, solidfill, gradient, texture, picture chart_fill=”gradient,dark blue, black, fromcorner,2,fittochart”
Fill Color 1 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Fill Color 2 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Gradient Type horizontal, vertical, diagonalup, diagonaldown, fromcorner, fromcenter
Variant Gradient 0,1,2,3 (positions of the gradients)
FitTo fittochart, fittobox
chart_shadow Shadow Type noshadow, drop, continuousdrop, diffuselightfrontdrop, pointlightfrontdrop, raisedline, sunkenline, raised, sunken, lineshadow chart_shadow=”drop, down_right, black”
Offset Type down_right, down_left, up_right, up_left
Shadow Color 1 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Shadow Color 2 red, green, blue, dark blue, yellow, cyan, white, black, etc. and range [000000 – FFFFFF]
Xoffset float value of the shadow offset
Yoffset float value of the shadow offset