Pull datal errors

When Searcher use semicolon or enter key data will not be at the suitable
column
What the steps to correct this errors

Survey.xlsx (75.3 KB)

Sam,

By "Searcher," do you mean the person sending the data?

What was the data that was entered that triggered the problem? (Give one or
two examples.)

What service/tool did you use to gather the data? Was it ODK on a smart
phone?

Do you also use ODK to collect and analyze the data?

We're interested in testing this, if you can answer these questions.

Ted Johnson | Media and Communications Manager
www.hni.org | www.DataWinners.com
http://www.facebook.com/humannetworkinternational
http://www.facebook.com/datawinners
@DataWinners

ยทยทยท On Sunday, January 25, 2015 at 9:09:33 PM UTC+3, Sam wrote: > > When Searcher use semicolon or enter key data will not be at the suitable > column > What the steps to correct this errors >

Hi Sam

To reprouce and understand your issue, I've created an XLSForm with a text type:
http://hni.org/wp-content/uploads/2015/02/health_survey.xls

Then I made 3 different Smartphone submissions:

  1. with a semicomma: http://hni.org/wp-content/uploads/2015/02/SmartphoneSubmissionWithSemiComma.png
  2. with a Enter key: http://hni.org/wp-content/uploads/2015/02/SmartphoneSubmissionWithEnterKey.png
  3. with a comma: http://hni.org/wp-content/uploads/2015/02/SmartphoneSubmissionWithComma.png

I then looked at the Submission Log and all 3 Submissions are displayed correctly:
http://hni.org/wp-content/uploads/2015/02/Submissions-AnalysisPage.png

I also exported the submissions to an Excel file and it worked correctly:
http://hni.org/wp-content/uploads/2015/02/Submissions-ExportToExcel.1.xlsx

Could you let me know if I've reproduced your issue correctly as it works fine for me. It would also help to get your form you used.

Best
Sandra

Director of User Experience
www.hni.org | www.datawinners.com

IF The searcher use coma or enter key when he full data by odk survey in mobile the data will field in other field after he send survey to the server "Website"
Can you tell me the steps to reorder data in excel after i pull it with this error

Yes sir

Yes for example if he use , the data will go to the next question
Or if he use Enter key the data from this point will go to the next row

Searcher mean who send data