search

Planteome / CO_321-wheat-traits

Wheat trait ontology
https://cropontology.org/term/CO_321:ROOT
5 stars 2 forks source link

Wheat TD file format issue #10

Open ShresthaR opened 4 years ago

ShresthaR commented 4 years ago

Hi @marieALaporte, Could you please provide me the latest version of the wheat TD in Excel format? I downloaded the wheat_TD.csv from here (github) which is available under the "Code" tab but when I tried to open it, the file was screwed up. We can use "semi-colon" as a delimiter in Excel, and it looks better but since "comma" has been used in many columns to separate authors, or in descriptions or in Reference columns, the changing into .csv file causing this issue I guess. So, when we use this option, is does not work properly and cannot see information correctly in designated columns/headers. I could not find an easy way to formatting it. The TD that we can download from the CO website has also same problem. It would be easier for the curators if they can just download Excel.
Many thanks

ShresthaR commented 4 years ago

I removed the commas from the wheat_TD.csv and now with the semi-colon delimiter, it is workable.

cooperl09 commented 4 years ago

I was able to open the wheat_TD.csv in both Excel and Google sheets, with no issues. Just select the semicolon as the delimiter.

kadreher commented 4 years ago

Greetings @marieALaporte , @cooperl09 , and @ShresthaR . I would like to add my request to please provide the trait dictionary in an easily accessible format, e.g. an Excel file available for download and immediate use. I understand that it is not ideal to use proprietary formats but I think that many people can access Excel or Google sheets to use an .xlsx file. At least for me, the .csv file extension is problematic because applications like Excel then assume that it is comma-delimited. I could only open it successfully without getting distorted and separated information if I first re-saved it with .txt extension and then tried to re-open it in Excel where I could then choose a different delimiter. However, I think that it would be wonderful if we could save others from having to do these manipulations by providing an Excel file for download from this site or the Crop Ontology site or both.

elizabetharnaud commented 4 years ago

@kadreher Hi Kate. Did you tried to directly open the csv in Excel with 'File', 'open' ? I usually do that and there is no r'esulting problem of format. If you use the 'import' , 'csv' file then it is a problem indeed. Let me know

kadreher commented 4 years ago

Hi @elizabetharnaud . Thank you for checking. When I download the csv file from the Crop Ontology site or try to save it from Github and then just try to open in Excel, unfortunately, it appears in a format that I cannot use. Here is an image: image

cooperl09 commented 4 years ago

Here is an easy way to open the wheat_TD.csv file in Excel:

  1. Open a new blank spreadsheet in Excel
  2. Under File > import > csv file. Select the wheat_TD.csv file on your local computer
  3. Select 'Delimited', if not already selected > click 'Next'
  4. Select Semicolon as the delimiter. Uncheck 'Tab'
  5. Leave Column data format 'General' on next screen
  6. Click Finish Sheets displays fine: image
cpommier commented 4 years ago

If this method works for everybody, it could be added in a README.md alongside the wheat_TD.csv. We could even include a "how to contribute" section to clarify the workflow. What do you think @elizabetharnaud ? I can create a pull request with that one if you want.

elizabetharnaud commented 4 years ago

Yes. I was thinking even to add these explantions to the web site directly . We are currently revising the Guidelines for developing a TD and i wish to have specific guidelines for the submission workflow that appears a bit complexe to the curators .