Anonymous avatar Anonymous committed 48f35c1

add trx.s field to complete round-trip

Comments (0)

Files changed (5)

         tx = trx['trx']
         db.insert(txw,
                   # django adds _id to ref fields
-                  ('id', 'acct_id', 'date', 'payee', 'num', 'ty', 'memo'),
+                  ('id', 'acct_id', 'date', 'payee', 'num', 'ty', 's'),
                   (tid, accounts[tx['acct']],
                    isoDate(tx['date']),
                    tx.get('payee', None),
                    tx.get('num', None),
                    tx.get('ty', None),
-                   tx.get('memo', None)
+                   tx.get('s', None)
                    ))
         
         for split in trx['splits']:
  
     ty = models.CharField(maxlength=80, null=True)
  
-    memo = models.CharField(maxlength=80, null=True)
+    s = models.CharField(maxlength=80, null=True)
  
 
     class Admin:
 
 <h1>QFM database</h1>
 
-<p>see also: <a href="qdbload.py">qdbload.py</a></p>
+<p>see also: <a href="../qdbload.py">qdbload.py</a></p>
 
 <table border="1">
 <tbody>
 <td>int</td>
 <td></td>
 <td>and categories</td>
-<td></td>
 </tr>
 <tr>
 <td></td>
 <td>id</td>
 <td>int</td>
 <td></td>
-<td></td>
-<td></td>
+<td>aka class</td>
 </tr>
 <tr>
 <td></td>
 <td>text</td>
 <td></td>
 <td></td>
-<td></td>
 </tr>
 </tbody>
 <tbody>
 </tr>
 <tr>
 <td></td>
-<td>memo</td>
+<td>s</td>
 <td>text</td>
+<td></td>
+<td>split flag. mostly redundant, but needed for round-trip testing</td>
 </tr>
 </tbody>
 
 <td>int</td>
 <td></td>
 <td></td>
-<td></td>
 </tr>
 <tr>
 <td></td>
 <td>int</td>
 <td>Transaction</td>
 <td></td>
-<td></td>
 </tr>
 <tr>
 <td></td>
 <td>text</td>
 <td></td>
 <td></td>
-<td></td>
 </tr>
 <tr>
 <td></td>
 <td>memo</td>
 <td>text</td>
 <td></td>
-<td></td>
-<td></td>
+<td>Quicken has a per-transaction memo as well as
+a per-split memo, but it doesn't show up in the transaction
+report.</td>
 </tr>
 <tr>
 <td></td>
 <td>float</td>
 <td></td>
 <td><em>hmm... decimal?</em></td>
-<td></td>
 </tr>
 </tbody>
 <tbody>
 <td>id</td>
 <td>int</td>
 <td></td>
-<td></td>
-<td></td>
+<td><em>not yet used</em></td>
 </tr>
 <tr>
 <td></td>
 <td>text</td>
 <td></td>
 <td></td>
-<td></td>
 </tr>
 </tbody>
 </table>
         <owl:onProperty>
           <owl:DataTypeProperty r:about="#id">
             <s:range r:resource="http://www.w3.org/2001/XMLSchema#integer"/>
-            <s:comment/>
+            <s:comment>aka class</s:comment>
           </owl:DataTypeProperty>
         </owl:onProperty>
         <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
     <s:subClassOf>
       <owl:Restriction>
         <owl:onProperty>
-          <owl:DataTypeProperty r:about="#memo">
+          <owl:DataTypeProperty r:about="#s">
             <s:range r:resource="http://www.w3.org/2001/XMLSchema#string"/>
-            <s:comment/>
+            <s:comment>split flag. mostly redundant, but needed for round-trip testing</s:comment>
           </owl:DataTypeProperty>
         </owl:onProperty>
         <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
         <owl:onProperty>
           <owl:DataTypeProperty r:about="#memo">
             <s:range r:resource="http://www.w3.org/2001/XMLSchema#string"/>
-            <s:comment/>
+            <s:comment>Quicken has a per-transaction memo as well as
+a per-split memo, but it doesn't show up in the transaction
+report.</s:comment>
           </owl:DataTypeProperty>
         </owl:onProperty>
         <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
         <owl:onProperty>
           <owl:DataTypeProperty r:about="#id">
             <s:range r:resource="http://www.w3.org/2001/XMLSchema#integer"/>
-            <s:comment/>
+            <s:comment>not yet used</s:comment>
           </owl:DataTypeProperty>
         </owl:onProperty>
         <owl:cardinality r:datatype="http://www.w3.org/2001/XMLSchema#integer">1</owl:cardinality>
 
         tx["dtstart"] = dtstart
 
-        num, splitflag, trxty = numField(tx.get('num', ''))
-        tx['num'] = num
-        tx['ty'] = trxty
+        tx['num'], tx['s'], tx['ty'] = numField(tx.get('num', ''))
 
         yield t
 
Tip: Filter by directory path e.g. /media app.js to search for public/media/app.js.
Tip: Use camelCasing e.g. ProjME to search for ProjectModifiedEvent.java.
Tip: Filter by extension type e.g. /repo .js to search for all .js files in the /repo directory.
Tip: Separate your search with spaces e.g. /ssh pom.xml to search for src/ssh/pom.xml.
Tip: Use ↑ and ↓ arrow keys to navigate and return to view the file.
Tip: You can also navigate files with Ctrl+j (next) and Ctrl+k (previous) and view the file with Ctrl+o.
Tip: You can also navigate files with Alt+j (next) and Alt+k (previous) and view the file with Alt+o.