153
Template metadata tags are required in a specific tabular format. The metadata tags row order
is important, but the column order is not. The first five rows of data (for Excel-based templates),
or the first six rows (for text-based templates) must contain the metadata tags.
The sample Excel template shown has five rows of metadata tags and 4 rows of imported data.
Rows 1-5 contain the metadata tags and rows 8 through 11 contain the data values.
In order to define the completed template in Excel, you must create a range name that includes
all the metadata and the data value cells. This range name must begin with the prefix “ups.” In
this example, the range is created and named [upsBudget (A1 to K11)].
The sample text file that follows has six rows of metadata tags and four rows of imported data.
Rows 1-6 contain the metadata tags and rows 7 through 10 contain the data values. Whatever
delimiter separates the dimensions in Row 6 must be used as the delimiter that separates the
data values. Valid delimiters include commas, semicolons, pipes (“
|
”), tabs, and exclamation
points.
1
T
e
x
as
2
B
udget
3
01
/
31
/
2004
4
12
5
R
,
N
,
Y
6
A
,
C
,
D
,
V
,
V
,
V
,
V
,
V
,
V
,
V
,
V
,
V
,
V
,
V
,
V
7
1100,
TX
,
C
ash
I
n
B
ank,” 43,016 “,” 43,451 “,” 43,890 “,” 44,333 “,” 44,781
8
1100-101-000-00,
TX
,
D
a
ll
as
N
at
i
ona
l
B
ank,” 1,791 “,” 1,809 “,” 1,827 “,” 1
9
1100-102,
TX
,
H
ouston
B
ank
O
ne,” 5,959 “,” 6,020 “,” 6,080 “,” 6,142 “,” 6,
10
1100-103,
TX
,
Mi
d
l
and
B
ank
&
Tr
ust,” 98,487 “,” 99,482 “,” 100,487 “,” 101,
11
1100-104,
TX
,
Fir
st
N
at
i
ona
l
B
ank,” (8,953)”,” (9,044)”,” (9,135)”,” (9,227
12
1190,
TX
,Pett
y
C
ash, 448 , 452 , 457 , 461 , 466 , 471 , 475 , 480 , 485 ,
Meta
D
ata
T
ags Structure
The metadata header (rows 1-5 for Excel templates, and rows 1–6 for text templates) tells FDM
how to find the relevant segments of data within the main body of the template.
144
I
mport
i
ng
O
ther
D
ata
Fil
es