sgn icon indicating copy to clipboard operation
sgn copied to clipboard

Add xlsx format option to pedigree upload

Open titima15 opened this issue 1 year ago • 7 comments

Expected Behavior

For Bugs:

Environment

Steps to Reproduce

titima15 avatar Sep 27 '23 19:09 titima15

This would be very helpful! Explaining to staff the difference between an "Excel file" and a tab-delimited file can be very difficult. Also would improve user experience to have a consistent file type for uploads. I believe this is one of the few tab-delimited uploads left in the system.

ch728 avatar May 22 '24 11:05 ch728

@ch728 I will change priority for this ticket to high. Hopefully I can start working on it early next week.

titima15 avatar May 22 '24 12:05 titima15

@titima15 Have you started working on this? If not, I've started working on a Generic Data File Parser that would support csv, tab-delimited, and excel files that could be used for the different file uploads.

dwaring87 avatar Jun 13 '24 15:06 dwaring87

@dwaring87 Yes, I'm working on it and it's almost done. However, If you are going to finish that File Parser soon. We can use that for pedigrees as well.

titima15 avatar Jun 13 '24 22:06 titima15

@titima15 Sorry, I should have started this sooner! The file parser is working now, I've just updated the locations upload as an example (in the topic/generic_file_parser branch). Would you like me to convert the pedigree upload to this or would you like to give it a try?

dwaring87 avatar Jun 14 '24 12:06 dwaring87

@dwaring87 No problem. Yes, I would like to give it a try. I will be traveling Monday and Tuesday. I will take a look after I get back. Thanks.

titima15 avatar Jun 14 '24 12:06 titima15

@titima15 Great, here is the Location upload I just converted if you want to use that as an example. Let me know if you have any questions using it.

dwaring87 avatar Jun 14 '24 13:06 dwaring87

Done via #5037

titima15 avatar Jul 30 '24 20:07 titima15