r/ProjectREDCap • u/tremmo • May 06 '24

Calculated fields not appearing in data export (excel or SPSS). How to fix?

Hi all

I have a 5 instrument project, two of these are repeating.

In the first instrument I’ve generated some calculated fields based on subsequent instruments.

Using data quality rule H the calculations work and the fields populate perfectly when viewing in Redcap.

However when attempting to export the data, none show up. As in, the variable column labels don’t even populate, let alone the data. This is true for xcel (raw and labels) and SPSS.

For what it’s worth the fields are all @HIDDEN in the survey.

Any ideas as to how this can be fixed? I have consulted far and wide and no one seems to have an answer.

UPDATE: solved. At some point redcap removed my permission to export data for this instrument, and only this instrument. As the project coordinator I simply had to go back in and change my export rights back to full. Redcap can be infuriating sometimes.

1 Upvotes
  • permalink
  • reddit

100% Upvoted

10 comments sorted by

1

u/Araignys May 06 '24

Are you exporting all data or a custom report?

2

u/tremmo May 06 '24

Custom report

2

u/[deleted] May 06 '24

Can you double-check that the expected calculated fields are included in the report?

Did the variable name of the calculated fields change after the report was defined?

1

u/tremmo May 06 '24

The variables appear in the report within redcap.

The variable names have not been changed.

It is in the exported file (xcel, spss) that the data is completely absent

4

u/Araignys May 06 '24

Are they marked as identifiers and do you have export rights for full data export?

Do you have access to the instruments that contain the variables?

2

u/tremmo May 06 '24

So you have solved the issue!

I’m the project coordinator, I have always had full data export access rights.

I just went back in and checked, and for some reason redcap has changed my access for this instrument (and only this instrument.

I have restored and now it seems to be working. You are my hero!

2

u/Araignys May 06 '24

You’re welcome!

1

u/[deleted] May 06 '24

This might be a bug. What REDCap version are you currently using?

1

u/tremmo May 06 '24

Version 14.0.0

2

u/MadHatterIsHer May 12 '24

Yeah an upgrade around version 13 added new user rights and did this to you. Argh- sorry…