I am having exported the data using ODK briefcase into CSV. Can we use import data from CSV file data into sql server by using import/export wizard and store the data in sql server database???
on more question is I have form that is in spanish but when i exported into CSV i am receiving accent marks for some characters.How to resolve this?????
Hello, yes it’s possible to import csv file into sql server.
For the second question what do you mean by accents mark, could you make a capture of the problem, pleas?
This is a Unicode problem and I'm not sure where in your pipeline it's happening.
First look at your CSV in a text editor with good unicode support (e.g., https://notepad-plus-plus.org) to confirm that the data you are importing is Unicode. If it is, then the problem is in your database.
I'm not familiar with SQL Server, but my guess is that the tables you created don't have Unicode support.
Thank you so much for your response @yanokwa
I am so sorry for my unclear response.
I am quiet new to this ODK tool. I am trying to understand the tool inorder to retrieve the data from it.
The incorrect accents are coming when I am directly exporting the data from ODK aggregate and opening the file directly in excel as opposed to importing the file in excel.
Yes I am able see the the correct in notepad and in web broswer.
If i use ODK briefcase and extract the data. then I am not seeing that weird accents marks..
=============================================
one more question I have form question aout the dateofbirth if the household members by selecting the date from the calender.
problem: The format of date in xml file looking good but the date format CSV file is coming as
MONTH DAY,YEAR. so year is coming in different column
Is there any to get the date in the format MONTH-DAY-YEAR format???