- Posts: 27
- Thank you received: 0
Welcome to the LimeSurvey Community Forum
Ask the community, share ideas, and connect with other LimeSurvey users!
Can I mark somehow fields that I don't want see in export
- teksur
- Topic Author
- Offline
- Junior Member
Less
More
7 years 11 months ago #136840
by teksur
Can I mark somehow fields that I don't want see in export was created by teksur
I am using Version 2.50+ Build 160525.
Export to Excel. There are columns and I can take some away, but this I have to do every time. Can not save it. So, is any way to mark somewhere that I don't want some fields because they are just headers.
Export to Excel. There are columns and I can take some away, but this I have to do every time. Can not save it. So, is any way to mark somewhere that I don't want some fields because they are just headers.
The topic has been locked.
- holch
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 11683
- Thank you received: 2748
7 years 11 months ago #136849
by holch
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
Replied by holch on topic Can I mark somehow fields that I don't want see in export
I don't think so.
I answer at the LimeSurvey forum in my spare time, I'm not a LimeSurvey GmbH employee.
No support via private message.
The topic has been locked.
- DenisChenu
- Away
- LimeSurvey Community Team
Less
More
- Posts: 13693
- Thank you received: 2500
7 years 11 months ago #136871
by DenisChenu
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
Replied by DenisChenu on topic Can I mark somehow fields that I don't want see in export
Hi,
With 2.06 : i have a plugin framagit.org/SondagePro-LimeSurvey-plugin/quickSelectColumns but surely don't work in 2.50.
With 2.06 : i have a plugin framagit.org/SondagePro-LimeSurvey-plugin/quickSelectColumns but surely don't work in 2.50.
Assistance on LimeSurvey forum and LimeSurvey core development are on my free time.
I'm not a LimeSurvey GmbH member, professional service on demand , plugin development .
I don't answer to private message.
The topic has been locked.
- tpartner
- Offline
- LimeSurvey Community Team
Less
More
- Posts: 10116
- Thank you received: 3597
7 years 11 months ago #136877
by tpartner
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
Replied by tpartner on topic Can I mark somehow fields that I don't want see in export
It should be fairly trivial to create a macro in Excel to remove the columns.
Cheers,
Tony Partner
Solutions, code and workarounds presented in these forums are given without any warranty, implied or otherwise.
The topic has been locked.
- Ben_V
- Offline
- Platinum Member
Less
More
- Posts: 1128
- Thank you received: 329
7 years 11 months ago - 7 years 11 months ago #136885
by Ben_V
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Replied by Ben_V on topic Can I mark somehow fields that I don't want see in export
Unfortunately LS is lacking XML export facilities for answers even if this format is intensively used elsewhere (.lss, lsg, .lsq, etc.).
For people using advanced Excel documents (styles, formulas, macros etc.) there is a lot of advantages to import (static/local or dynamic/online) XML files compare to XLS or CSV files... (for example this approach to manage unwanted columns )
Loading XML files as data source is available in all Excel versions since 2007.
I'm talking about static local files. Using office 365 (and maybe recent desktop version I don't know) you can load online XML files... so if you can configure your own script to generate this file... you will pretty have nothing else to do further except opening your spreadsheet. Related post
For people using advanced Excel documents (styles, formulas, macros etc.) there is a lot of advantages to import (static/local or dynamic/online) XML files compare to XLS or CSV files... (for example this approach to manage unwanted columns )
Loading XML files as data source is available in all Excel versions since 2007.
I'm talking about static local files. Using office 365 (and maybe recent desktop version I don't know) you can load online XML files... so if you can configure your own script to generate this file... you will pretty have nothing else to do further except opening your spreadsheet. Related post
Benoît
EM Variables => bit.ly/1TKQyNu | EM Roadmap => bit.ly/1UTrOB4
Last Releases => 2.6x.x goo.gl/ztWfIV | 2.06/2.6.x => bit.ly/1Qv44A1
Demo Surveys => goo.gl/HuR6Xe (already included in /docs/demosurveys)
Last edit: 7 years 11 months ago by Ben_V.
The topic has been locked.