CSV to CaseXML

Moses_Katembu · June 11, 2012, 6:00pm

Hello everyone,

Are there tools in commcare that can export data from mysql db or CSV
file and generate a CaseXML based on particular Commcare Module Form.
I should be able to submit this CaseXML to commcare using the
submission API.

So far I have just created a CaseXML template using django Templating
Language. Am then populating the variables and pushing the it to
commcare using the submission API. So far this seems to work for me,
but I would like to get a more concrete solution that I can use in
long run instead of creating django templates.

czue · June 12, 2012, 8:30pm

Hi Moses,

···

On Mon, Jun 11, 2012 at 2:00 PM, Moses Katembu wrote:

Hello everyone,

Are there tools in commcare that can export data from mysql db or CSV
file and generate a CaseXML based on particular Commcare Module Form.
I should be able to submit this CaseXML to commcare using the
submission API.

So far I have just created a CaseXML template using django Templating
Language. Am then populating the variables and pushing the it to
commcare using the submission API. So far this seems to work for me,
but I would like to get a more concrete solution that I can use in
long run instead of creating django templates.

We have a couple different libraries to do this, but they rely on including
many of commcare-hq's shared codebase.

Since you're working in python, a good place to look/start would be our
test-case-xml generator class[1].

Actually this thing is mostly standalone, so could easily be pulled out and
used.

To get an example of its use you could look through some of our unit tests.
Here is one example[2].

Note: in the future probably good to use the commcare-developers[3] google
group for questions like this, over the user group.

cheers,
Cory

[1]

github.com

dimagi/casexml/blob/master/casexml/apps/case/tests/util.py#L79


      
                  actual_lines = parsed_actual.split("\n")
                  test_case.assertEqual(
                      len(expected_lines),
                      len(actual_lines),
                      "Parsed xml files are different lengths\n" +
                      "Expected: \n%s\nActual:\n%s" % (parsed_expected, parsed_actual))
          
                  for i in range(len(expected_lines)):
                      test_case.assertEqual(expected_lines[i], actual_lines[i])
          
              except AssertionError:
                  import logging
                  logging.error("Failure in xml comparison\nExpected:\n%s\nActual:\n%s" % (parsed_expected, parsed_actual))
                  raise
          
          
          def assert_user_has_case(testcase, user, case_id, **kwargs):
              return check_user_has_case(testcase, user, CaseBlock(case_id=case_id, version=V2).as_xml(),
                                         should_have=True, line_by_line=False, version=V2, **kwargs)

[2]

github.com

dimagi/casexml/blob/master/casexml/apps/case/tests/test_indexes.py#L25


      
          USER_ID = 'test-index-user'
          
          
          class IndexSimpleTest(SimpleTestCase):
          
              def setUp(self):
                  self.i1 = CommCareCaseIndex(
                      identifier='i1',
                      referenced_type='t1',
                      referenced_id='id1'
                  )
                  self.i2 = CommCareCaseIndex(
                      identifier='i2',
                      referenced_type='t2',
                      referenced_id='id2'
                  )
                  self.case = CommCareCase(indices=[self.i1, self.i2])
          
              def testHasIndex(self):
                  self.assertEqual(True, self.case.has_index('i1'))
                  self.assertEqual(True, self.case.has_index('i2'))

[3] Redirecting to Google Groups