I have a standard QIF (quicken export) file which I am trying to convert to xml. The file looks like this:
!Type:Bank|D01-05-2007|N123|PPayeeName|MMemoText|T-123.45|C*|^|D01-06-2007|N|PPayeeName|MMemoText|T-333.33|C*|^|etc.,etc.
The pipe ( | ) characters above are actually LineFeed characters in the file. Each field is on a separate line of the file, but for some reason, the line terminators are Lf's instead of CrLf's. The field widths are not fixed. Each line/field ends with a linefeed instead of a CrLf. The "!Type..." line is a single header line, which may be ignored. Each logical transaction begins with a "D...." line and ends with a "^" line.
What I want is something like:
<File>
<Transaction>
<D>Tran date</D>
<N>12345</N>
<P>PayeeName</P>
<M>MemoText</M>
<T>Tran amount</T>
</Transaction>
.....
</File>
When I try to design a map and run it, I get:
"Error while translating: Invalid xmlLinguist Map: Missing ID Field. For Fixed-width map files, each line must contain a Field at the position identified in the Document properties"
Since the fields are not fixed width, I can't give them a length in the map file. I CAN give them a starting position, which is basically 2 (after the line identifier).
Any idea how to do this?
Thanks...
!Type:Bank|D01-05-2007|N123|PPayeeName|MMemoText|T-123.45|C*|^|D01-06-2007|N|PPayeeName|MMemoText|T-333.33|C*|^|etc.,etc.
The pipe ( | ) characters above are actually LineFeed characters in the file. Each field is on a separate line of the file, but for some reason, the line terminators are Lf's instead of CrLf's. The field widths are not fixed. Each line/field ends with a linefeed instead of a CrLf. The "!Type..." line is a single header line, which may be ignored. Each logical transaction begins with a "D...." line and ends with a "^" line.
What I want is something like:
<File>
<Transaction>
<D>Tran date</D>
<N>12345</N>
<P>PayeeName</P>
<M>MemoText</M>
<T>Tran amount</T>
</Transaction>
.....
</File>
When I try to design a map and run it, I get:
"Error while translating: Invalid xmlLinguist Map: Missing ID Field. For Fixed-width map files, each line must contain a Field at the position identified in the Document properties"
Since the fields are not fixed width, I can't give them a length in the map file. I CAN give them a starting position, which is basically 2 (after the line identifier).
Any idea how to do this?
Thanks...
