Data download - not all data downloaded

User Support Data Management
, , ,
#1

Hi,

I have modified the data using the online Data view and saved the editing. It looks alright both in the Data->Table view and Data->Report view but when I download the Excel file some of the data variables or single cases (the ones edited) are not appearing. I have tried to refresh/download several times. Any lead what could be the problem?

Many thanks in advance

1 Like
#2

Hello @Giul, welcome to the community :slight_smile:

Can you share a screenshot of the data missing in the excel and the data that should be seen in Table View?

All the best,

1 Like
#3

Hello @hakan_cetinkaya, thanks for support!

Here the screentshoot from Table View with missing data:

image
image721Ă—378 6.38 KB

1 Like
#4

And here the excel file here those data do not appear:

image

You see also there are two additional columns that do now appear in Table view.

Thanks for any support! Best,
Giulia

1 Like
#5

@Giul,

Can you share a screenshot of Data > Downloads > Advanced options?

Best,

1 Like
#6

image
image821Ă—429 11.6 KB

here we go

1 Like
#7

Can you take a screenshot after you click on the Advanced options so it can expand? :slight_smile:

1 Like
#8

ah ok yes#

image
image824Ă—456 11.8 KB

1 Like
#9

Hi @Giul,

  • Did your edit affect the calculate question?
  • Did any of your redeployment (versions) change the calculate question?
1 Like
#10

Mm…there are actually no calculate questions…totals are all values inputed

1 Like
#11

@Giul, Can you try XLS (Legacy) export type in your Select export type and check if the data missing in there too?

1 Like
#12

Thanks @hakan_cetinkaya ! Data are in this version :slight_smile: so on legacy it works but not on the normal way to download, is this a case or I have to do something to be able to export the data also on the project´s download?

2 Likes
#13

Well, @Giul, I’m glad it worked. However, that question is beyond my knowledge :slight_smile:

Pinging @Kal_Lam for his knowledge on the subject.

All the best,

1 Like
#14

:slight_smile: anyway many thanks for this!! let´s see if I can solve this also for the future @Kal_Lam

Have a good day!

2 Likes
#15

Hello @Kal_Lam,
seems a reproducible case. So, please, can we have a GitHub entry and a developer checking this issue?
@Giul,

  1. Can you share the related extract of your form, please?
  2. Did you change the form (esp. around the cited question) during data collection?
  3. What do you get, if you export the data with (normal) XLS option and only last form version?
    .
2 Likes
#16

Hi @wroos ,

Many thanks for your message!

  1. what do you mean with extract?
  2. yes, I did change the form and added the variable with the cases missing later on once I already entered the data. I then enterered manually the values missing on Data->Table (I know not ideal, but it normally works)
  3. I actually only see this option and ´None`, I can´t save only last form version

image

1 Like
#17

@Giul, thank you for bringing this to the community! Could you list the exact steps you did that led to this (data missing)? Maybe we could also try reproducing this at our end.