- Posts: 6
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Column headers in the export file (CSV)
- EdenResident
- Topic Author
- Offline
- New Member
Less
More
5 years 4 months ago #176352
by EdenResident
Column headers in the export file (CSV) was created by EdenResident
Hello,
When I export survey responses from Offline Survey to CSV files, my column headers are all codes like this
948522X12X64 948522X12X65 948522X12X66 948522X12X67
This is from DBResults.csv. easyResults is even worse with blank headers. Looking at these headers, I have to guess which one corresponds to which question Code from LimeSurvey. For example, those 4 headers above correspond to
CITY, DISTRICT, WARD, SPCODE in my LimeSurvey design.
So my question is, how can I tell Offline Survey to export the human-readable question codes as column headers instead of those machine codes above?
Thanks.
When I export survey responses from Offline Survey to CSV files, my column headers are all codes like this
948522X12X64 948522X12X65 948522X12X66 948522X12X67
This is from DBResults.csv. easyResults is even worse with blank headers. Looking at these headers, I have to guess which one corresponds to which question Code from LimeSurvey. For example, those 4 headers above correspond to
CITY, DISTRICT, WARD, SPCODE in my LimeSurvey design.
So my question is, how can I tell Offline Survey to export the human-readable question codes as column headers instead of those machine codes above?
Thanks.
The topic has been locked.
- lfanfoni
- Offline
- Platinum Member
Less
More
- Posts: 904
- Thank you received: 213
5 years 4 months ago #176355
by lfanfoni
Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
Replied by lfanfoni on topic Column headers in the export file (CSV)
You can buy a comfortable and cheap license to synchronize automatically your responses
Se mi vuoi contattare, non mandare messaggi privati qui, bensì scrivi a lfanfoni at gmail.com
Per le livestream in italiano vai su: www.youtube.com/playlist?list=PLOSjjxAG9...SiiCsSz_JxIH7xJwLdPd
Le soluzioni LimeSurvey per l'Italia si trovano su: github.com/lfanfoni
The topic has been locked.
- aaskoura
- Offline
- Premium Member
Less
More
- Posts: 83
- Thank you received: 9
5 years 4 months ago #176478
by aaskoura
Replied by aaskoura on topic Column headers in the export file (CSV)
Hi, I recommend you to rely solely on DB_results.csv file, with column headers like 948522X12X64 948522X12X65 948522X12X66 948522X12X67... These are the same headers LimeSurveys use...
The other more user friendly column headers, we fetch by scrapping the HTML, we cannot guarantee its accuracy while supporting LimeSurvey templates starting 1.92+. you could send me privately (support [at] offlinesurveys.com) your survey url and I will make sure it is fixed though
The other more user friendly column headers, we fetch by scrapping the HTML, we cannot guarantee its accuracy while supporting LimeSurvey templates starting 1.92+. you could send me privately (support [at] offlinesurveys.com) your survey url and I will make sure it is fixed though
The topic has been locked.