search

GoMexSI / gomexsi-web

Explore Species Interactions in Gulf of Mexico with the GoMexSI webapp
http://gomexsi.tamucc.edu
3 stars 2 forks source link

unexpected headers in csv download file #64

Closed jhpoelen closed 11 years ago

jhpoelen commented 11 years ago

Steps to reproduce:

  1. In Taxonomy Query page, type "Ariopsis felis"
  2. Select Predator and Prey, click submit.
  3. click on download raw csv and inspect csv file.

Expected result:

First row in csv file contains the header with fields such as source_taxon_name, interaction_type and more.

Actual result: First row in csv file contains Ariopsis felis. The second row contains the desired header file. Also, when scolling down, an additional header row is found when the predator of Ariopsis felis are listed.

Suggested: remove first row (Ariopsis felis) and duplicate header halfway down the csv file.

example download (on Aug 8, 2013)

Ariopsis felis <--- first row                
source_taxon_name,interaction_type,target_taxon_name, latitude, longitude ...  <--- this looks great!
Ariopsis felis,preysOn,Micropogonias undulatus, 28.645202,  -96.099923 ...
Ariopsis felis,preysOn,Brevoortia patronus, 28.645202, -96.099923 ...
...
Ariopsis felis,preysOn,Anaitides,30.0625397381 ...
Ariopsis felis,preysOn,Acanthosquilla biminiensis,30.0625397381 ...
source_taxon_name,interaction_type,target_taxon_name,latitude, ... <--- duplicate header 
Ariopsis felis, preyedUponBy    Lagodon, rhomboides,    28.626777 ...
Ariopsis felis, preyedUponBy,Centropomus undecimalis,   26.823367 ...
Ariopsis felis, preyedUponBy    ,Centropomus undecimalis,   26.823367 ...
jhpoelen commented 11 years ago

@MikeCasavecchia let me know if this is easy to fix / whether you need some changes on the REST server side. . .

MikeCasavecchia commented 11 years ago

This should not be difficult at all

On Thu, Aug 8, 2013 at 4:03 PM, jhpoelen notifications@github.com wrote:

@MikeCasavecchia https://github.com/MikeCasavecchia let me know if this is easy to fix / whether you need some changes on the REST server side. . .

— Reply to this email directly or view it on GitHubhttps://github.com/jhpoelen/gomexsi/issues/64#issuecomment-22355601 .

jhpoelen commented 11 years ago

nice . . . let's fix it for 1.0!

MikeCasavecchia commented 11 years ago

I get back into town on thursday morning, I can update it then. Sorry about disappearing without any notice.

jsimons9 commented 11 years ago

Hi Michael,

Which town do you get back into??? ☺ When did you plan to come by TAMUCC??

Good to hear from you.

Take care,

Jim

From: Michael Casavecchia [mailto:notifications@github.com] Sent: Tuesday, August 13, 2013 9:41 AM To: jhpoelen/gomexsi Subject: Re: [gomexsi] unexpected headers in csv download file (#64)

I get back into town on thursday morning, I can update it then. Sorry about disappearing without any notice.

— Reply to this email directly or view it on GitHubhttps://github.com/jhpoelen/gomexsi/issues/64#issuecomment-22569544.

MikeCasavecchia commented 11 years ago

Removed the taxon name at the top as well as the duplicate header.

jhpoelen commented 11 years ago

Looking good! Thanks for fixing this. . .