Downloading Data

87 views
Skip to first unread message

R Chow

unread,
Jul 12, 2021, 6:02:10 PM7/12/21
to redcap open
Hi all,

I am currently working on a RedCap project, and have uploaded using the Excel template data. The data format is in rows, with multiple lines of rows corresponding to one study ID

However, when I export the data spreadsheet, I only get the first row of data. How do I export the data, such that I get all the rows of data?

Thanks!

Melissa Sherfield

unread,
Jul 12, 2021, 6:35:54 PM7/12/21
to redcap open, R Chow
R Chow,
It will depend on how the REDCap is set up. If it is patient level you could use repeating forms, then in your import indicate which line is which instance.
Melissa

From: redca...@googlegroups.com <redca...@googlegroups.com> on behalf of R Chow <rch...@uwo.ca>
Sent: Monday, July 12, 2021 6:02:09 PM
To: redcap open <redca...@googlegroups.com>
Subject: Downloading Data
 
--
You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/d0c6f812-2315-446f-92fd-d0fa3e171553n%40googlegroups.com.

Peter Macisaac

unread,
Jul 12, 2021, 11:26:26 PM7/12/21
to Melissa Sherfield, redcap open, R Chow
Don’t use excel it doesn’t play well with redcap. Try libreoffice or Mac numbers

Let us know if that doesn’t work

Peter

Sent from my iPhone

On 13 Jul 2021, at 8:35 am, Melissa Sherfield <melissa.s...@gmail.com> wrote:



Luciana R C Barros

unread,
Jul 13, 2021, 6:03:47 AM7/13/21
to Peter Macisaac, Melissa Sherfield, R Chow, redcap open
Hello R Chow,

You can change “comma” to “semi-colon” on REDCap export options where you choose csv file. But you can not import “semi-colon” separated file back to REDCap.
You can change this separators on notebook simply CTRL+H and substitute ; for , or vice versa.

Google docs also deal well with csv files, but libreoffice is your best choice.

Luciana

--
Luciana R C Barros

Centro de Investigação Translacional em Oncologia
Instituto do Câncer do Estado de São Paulo
Faculdade de Medicina da Universidade de São Paulo
Av. Dr. Arnaldo, 251.  Cerqueira César
CEP 01246-000 - São Paulo - SP - Brasil
Tel: + 55 11 38933014

davidmate...@gmail.com

unread,
Jul 13, 2021, 8:36:19 AM7/13/21
to redcap open
I know that feel bro, I spend almost a week getting me crazy with these thing. 
I checked all the examples and documentation, but the "issue" is in your computer and you won't find anything in the web, because all the examples and tutorials are done by people with different settings (usually US people) that we use (in from Spain)

You must go to your Windows locale, and check your format settings (check attached image)

Find the "list separator" and change to ,  (comma).
Now, reboot your pc and this should work
Captura.PNG

Luke Stevens

unread,
Jul 13, 2021, 5:56:27 PM7/13/21
to R Chow, redcap open

Is the data all there, just all on one line? Your Excel is not recognising the line breaks? Try opening the csv export file in a text Editor to take a proper look at exactly what's in it.

Luke

 


Sent: Tuesday, 13 July 2021 08:02
To: redcap open <redca...@googlegroups.com>

Subject: [EXTERNAL]Downloading Data

 

CAUTION:  External Email. Please be cautious with attachments and clicking links

 

--

You received this message because you are subscribed to the Google Groups "redcap open" group.
To unsubscribe from this group and stop receiving emails from it, send an email to redcap_open...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/redcap_open/d0c6f812-2315-446f-92fd-d0fa3e171553n%40googlegroups.com.



This e-mail and any attachments to it (the "Communication") are, unless otherwise stated, confidential, may contain copyright material and is for the use only of the intended recipient. If you receive the Communication in error, please notify the sender immediately by return e-mail, delete the Communication and the return e-mail, and do not read, copy, retransmit or otherwise deal with it. Any views expressed in the Communication are those of the individual sender only, unless expressly stated to be those of Murdoch Children’s Research Institute (MCRI) ABN 21 006 566 972 or any of its related entities. MCRI does not accept liability in connection with the integrity of or errors in the Communication, computer virus, data corruption, interference or delay arising from or in respect of the Communication.

Reply all
Reply to author
Forward
0 new messages