what are the content conversion parameters for this structure

[Former Member]

Hi All,

The below file is the text file. what are the content conversion parameters are required and what is the structure to create in the IR to convert into xml.

-

---

Schedule D - District/Port List (by District Code) [Produced13APR11]

-

---

District | Port | Name

Code | Code |

-

---

01 | | PORTLAND, ME

| 0101 | PORTLAND, ME

| 0102 | BANGOR, ME

| 0103 | EASTPORT, ME

| 0104 | JACKMAN, ME

| 0105 | VANCEBORO, ME

| 0106 | HOULTON, ME

| 0107 | FORT FAIRFIELD, ME

| 0108 | VAN BUREN, ME

| 0109 | MADAWASKA, ME

| 0110 | FORT KENT, ME

| 0111 | BATH, ME

| 0112 | BAR HARBOR, ME

| 0115 | CALAIS, ME

| 0118 | LIMESTONE, ME

| 0121 | ROCKLAND, ME

| 0122 | JONESPORT, ME

| 0127 | BRIDGEWATER, ME

| 0131 | PORTSMOUTH, NH

| 0132 | BELFAST, ME

| 0152 | SEARSPORT, ME

| 0181 | LEBANON AIRPORT

| 0182 | MANCHESTER USER FEE AIRPORT, NH

-

---

02 | | ST. ALBANS, VT

| 0201 | ST. ALBANS, VT

| 0203 | RICHFORD, VT

| 0206 | BEECHER FALLS, VT

| 0207 | BURLINGTON, VT

| 0209 | DERBY LINE, VT

| 0211 | NORTON, VT

| 0212 | HIGHGATE SPRINGS/ALBURG

-

---

[Former Member]

since in this case you dont seem to have a key value to figure out what your header is, it is better to go for a two level mapping. i.e first read all the data - each line as an xml tag. and in the first mapping group it as required and then use it for your original mapping.

Regards,

Ninu