xml/sql conversion and balance sheet report rollup issue

[hasmeta at yahoo.com]

Thanks. A few interesting lines from the log during opening the xml file at startup with --debug option:

*   WARN <gnc.engine.scrub> [xaccTransFindOldCommonCurrency()] unable to find a common currency in txn bc18df66da64077fb0cb33a5039cfb7b, and that is strange.
*   WARN <gnc.engine.scrub> [xaccTransScrubCurrency()] no common transaction currency found for trans="opening balance" (bc18df66da64077fb0cb33a5039cfb7b)
*   WARN <gnc.engine.scrub> [xaccTransScrubCurrency()]  split="" account="TRY" commodity="TRY"
*   WARN <gnc.engine.scrub> [xaccTransScrubCurrency()]  split="" account="TRY" commodity="TRY"

Snippets from the xml:

<gnc:transaction version="2.0.0">
  <trn:id type="guid">bc18df66da64077fb0cb33a5039cfb7b</trn:id>
  ...snip...
  <trn:description>opening balance</trn:description>
  <trn:splits>
    <trn:split>
      <split:id type="guid">02247d73ac908514144459f175e8be86</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>A/B/split:value>
      <split:quantity>C/D</split:quantity>
      <split:account type="guid">03334a661c30478810c94ccc706964c9</split:account>
    </trn:split>
    <trn:split>
      <split:id type="guid">28b624021869f8ceb4dfb9672e651b1f</split:id>
      <split:reconciled-state>n</split:reconciled-state>
      <split:value>-A/B</split:value>
      <split:quantity>-C/D</split:quantity>
      <split:account type="guid">97d49787ec41d00bebc07c2e73974403</split:account>
    </trn:split>
  </trn:splits>
</gnc:transaction>

<gnc:account version="2.0.0">
  <act:name>TRY</act:name>
  <act:id type="guid">03334a661c30478810c94ccc706964c9</act:id>
  <act:type>CASH</act:type>
  <act:commodity>
    <cmdty:space>ISO4217</cmdty:space>
    <cmdty:id>TRY</cmdty:id>
  </act:commodity>
  <act:commodity-scu>100</act:commodity-scu>
  <act:parent type="guid">e4254557e03759b9a11dd80e3d5a2da6</act:parent>
</gnc:account>

<gnc:account version="2.0.0">
  <act:name>TRY</act:name>
  <act:id type="guid">97d49787ec41d00bebc07c2e73974403</act:id>
  <act:type>EQUITY</act:type>
  <act:commodity>
    <cmdty:space>ISO4217</cmdty:space>
    <cmdty:id>TRY</cmdty:id>
  </act:commodity>
  <act:commodity-scu>100</act:commodity-scu>
  <act:parent type="guid">4a51a41e18714b041f598373e907746a</act:parent>
</gnc:account>

--Hasmet