View Single Post
You want to export a list of your completed items, or you want to remove them from the database? I'm assuming the latter, based on your other posts.

Is it possible to edit the XML files by hand? Yes. Does it make sense to do so? Probably not. Without meaning to be too snarky about it, the set of people one might encourage to pursue this is pretty much the set of people who could figure out how to do it :-)

To do this, you would probably want to use a Mac or a PC. You'll want your database to be compacted before starting (just 1 zip file). On the Mac, you'd mount the WebDAV volume from the Finder, select the database file, right-click and select Show Package Contents, which should reveal a file named 0000<.....>.zip. Unzip the file and you should get a file called contents.xml. Open that up with TextWrangler or something similar.

I took the introductory database and marked a single item complete to serve as an example. Here is a snippet including the single completed item:

Code:
 
  <task id="auGxids5H9K">
    <project>
      <last-review>2007-11-09T08:00:00.000Z</last-review>
      <next-review>2007-11-16T08:00:00.000Z</next-review>
      <review-interval>@1w</review-interval>
   <rank>-1073741824</rank>
  </task>
   </project>
    <added order="21">2011-12-17T19:26:29.833Z</added>
    <modified>2011-12-17T19:26:39.759Z</modified>
    <name>Get started with OmniFocus</name>
    <rank>-1073741824</rank>
  </task>
  <task id="nF1pkXhtoS3">
    <task idref="auGxids5H9K"/>
    <added order="22">2011-12-17T19:26:29.833Z</added>
    <modified>2011-12-17T19:26:39.759Z</modified>
    <name>Watch the OmniFocus Quick Start video</name>
    <note>
      <text>
        <p>
          <run>
            <style>
              <value key="link">http://omnigroup.com/applications/omnifocus/quickstart</value>
              <value key="paragraph-alignment">left</value>
            </style>
            <lit>http://omnigroup.com/applications/omnifocus/quickstart</lit>
          </run>
        </p>
        <p>
          <run>
            <style>
              <value key="paragraph-alignment">left</value>
            </style>
            <lit>Note: be sure to mark this task complete when you're done!</lit>
          </run>
        </p>
      </text>
    </note>
    <rank>0</rank>
    <context idref="oQrYXVieqcS"/>
    <completed>2011-12-17T19:26:39.620Z</completed>
  </task>
  <task id="doOd0htrSs_">
    <task idref="auGxids5H9K"/>
    <added order="23">2011-12-17T19:26:29.833Z</added>
    <name>Process items in OmniFocus inbox into projects and actions</name>
    <note>
      <text>
        <p>
          <run>
            <style>
              <value key="paragraph-alignment">left</value>
            </style>
            <lit>Note: be sure to watch the Quick Start video first for tips on processing!</lit>
To delete that completed action, you would need to delete everything from <task id="nF1pkXhtoS3"> through </task>, and the way you would recognize that the action had been completed is by the presence of <completed>2011-12-17T19:26:39.620Z</completed>. To delete a project, you have to delete the project entry, such as this:
Code:
 <task id="auGxids5H9K">
    <project>
      <last-review>2007-11-09T08:00:00.000Z</last-review>
      <next-review>2007-11-16T08:00:00.000Z</next-review>
      <review-interval>@1w</review-interval>
   <rank>-1073741824</rank>
  </task>
   </project>
    <added order="21">2011-12-17T19:26:29.833Z</added>
    <modified>2011-12-17T19:26:39.759Z</modified>
    <name>Get started with OmniFocus</name>
    <rank>-1073741824</rank>
  </task>
and you have to delete all of the actions which refer to it via <task idref="auGxids5H9K"/>. Finally, you need to zip up the file again, put it in place of the original, and get the iPad to reload it from the server. Hopefully you didn't mangle anything in the process, because I didn't instruct you to make a backup before opening up the patient!

Whether or not you've got the technical chops to do this, it probably isn't a good use of your time. Pester Omni to supply a solution, or buy a cheap (used?) Mac and a copy of OmniFocus for Mac, or just delete them with the program one by one. Or maybe just leave them alone while you wait — OF for iPad can handle thousands of actions, though it will get a bit slower as the database grows. I find the excess search results to be the most annoying side effect, myself, though sometimes I want completed actions to show up, so I'm not pressing for them to be removed...