Hi,
We faced the following error when trying to import case data. Case properties with dot(.) are not found in the drop down of the case properties to match with the excel fields. Is there a way to force the import?
Column names correspond to [case property names](https://confluence.dimagi.com/display/commcarepublic/Case+Configuration). They must start with a letter, and can only contain letters, numbers and underscores. Please update the following: indices.client.
Thank you,
Hi, @sirajhassan.
Is the "faulty" column (indices.client) one you got from doing a case export?
Hi @CharlSmit ,
Yes, some fields of the exported data from the previous database and the existing one have dot(.).
We tried to modify the excel field with underscore ( _ ) to match with the case properties. However, the fields with dot are not appearing in the dropdown to match the excel fields and case properties. It forces to use underscore (e.g. indices_client) even though the case property is 'indices.client'.
DET fields:
Ah, the indices.<something> type columns are referencing case indices (typically child cases where <something> is the case_type of the indexed case) and are not case properties on the case being imported, hence you won't be able to find those columns in the dropdown.
On a tangential note:
some fields of the exported data from the previous database
Are you importing the data to a fresh new database? If so, what happened to the database this was exported from?
If you want to import case relationships, check out this wiki:
https://confluence.dimagi.com/pages/viewpage.action?pageId=20218117
Exported the data from the database(CommCare) that has something wrong and wanted to import to the restored from backup.
I see. Let me know if you run into further issues with the import considering that case relationships are imported as described in the link in my previous comment.
Tried to import using POST method. The same error prevented the process.
* TLSv1.2 (OUT), TLS header, Supplemental data (23):
* TLSv1.2 (OUT), TLS header, Supplemental data (23):
* We are completely uploaded and fine
* TLSv1.2 (IN), TLS header, Supplemental data (23):
< HTTP/2 500
< server: nginx
< date: Tue, 12 Dec 2023 13:38:05 GMT
< content-type: application/json
< content-length: 318
< http_x_openrosa_version: 1.0
< x-frame-options: DENY
< vary: Accept-Language, Cookie
< content-language: en
< cache-control: private, no-cache, no-store, must-revalidate, proxy-revalidate
< expires: Thu, 01 Dec 1994 16:00:00 GMT
< pragma: no-cache
< set-cookie: formplayer_session=c8d750b0ecb7897b50117136f7dab2ca; Path=/
<
* Connection #0 to host www.echisethiopia.org left intact
{"code": 500, "message": "Column names correspond to <a target=\"_blank\" href=\"https://confluence.dimagi.com/display/commcarepublic/Case+Configuration\">case property names</a>. They must start with a letter, and can only contain letters, numbers and underscores. Please update the following: indices.pregnancy_pp."}
[This] (Updating Cases using Excel File - CommCare Public - CommCare Public) is an import example with column(info.case_id) that has dot(.). Is there any requirement update?
Thank you,