cant import data - Githubissues

CandidCritters commented 2 years ago

I can't seem to import data from Movebank. When I try it directly I get an error. When I download the file and then try to import the file I also get an error. I tried this with 3 different studies. I'll attach the data. cheers Roland

Movebank 220229 - Tsavo Lion Study.csv Movebank 11948467 - NCSU Mammalogy Campus Carnivores.csv

Movebank 1573471517 - OC Vultures.csv

xhdong-umd commented 2 years ago

There are various data quality problems in the input files:

Movebank.1573471517.-.OC.Vultures.csv have wrong format of timestamp like 00:53.0.

> as.telemetry("e:/Movebank.1573471517.-.OC.Vultures.csv")
0 outlier markings ignored.
Error in as.POSIXlt.character(x, tz, ...) : 
  character string is not in a standard unambiguous format

The other two files have some rows with empty identifier name. This caused some problem in my code when I sorted the individual by names, also we need to identify and access each individual by name. I'll make some changes to assign a temporary name to fix this problem.

CandidCritters commented 2 years ago

Ok. Thanks. This is how the data came from Movebank

Get Outlook for iOShttps://aka.ms/o0ukef

From: xianghui dong @.> Sent: Thursday, October 14, 2021 1:08:04 PM To: ctmm-initiative/ctmmweb @.> Cc: Kays, Roland @.>; Author @.> Subject: [External] Re: [ctmm-initiative/ctmmweb] cant import data (#136)

CAUTION: External email. Do not click links or open attachments unless you verify. Send all suspicious email as an attachment to Report @.***>

There are various data quality problems in the input files:

Movebank.1573471517.-.OC.Vultures.csv have wrong format of timestamp like 00:53.0.

as.telemetry("e:/Movebank.1573471517.-.OC.Vultures.csv") 0 outlier markings ignored. Error in as.POSIXlt.character(x, tz, ...) : character string is not in a standard unambiguous format

The other two files have some rows with empty identifier name. This caused some problem in my code when I sorted the individual by names, also we need to identify and access each individual by name. I'll make some changes to assign a temporary name to fix this problem.

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHubhttps://urldefense.com/v3/__https://github.com/ctmm-initiative/ctmmweb/issues/136*issuecomment-943552203__;Iw!!HYmSToo!LZzV_goQ9hM3DJ2rOAkzgAQ_xOi6pMn8okRyo-cy2oJVje7StMhCGK9R8Nn7IGjTUpOLXRiE$, or unsubscribehttps://urldefense.com/v3/__https://github.com/notifications/unsubscribe-auth/AIDV2N55QP6XG3PHTVPD4R3UG4E7JANCNFSM5F7P6LSQ__;!!HYmSToo!LZzV_goQ9hM3DJ2rOAkzgAQ_xOi6pMn8okRyo-cy2oJVje7StMhCGK9R8Nn7IGjTUtSbh2eU$. Triage notifications on the go with GitHub Mobile for iOShttps://urldefense.com/v3/__https://apps.apple.com/app/apple-store/id1477376905?ct=notification-email&mt=8&pt=524675__;!!HYmSToo!LZzV_goQ9hM3DJ2rOAkzgAQ_xOi6pMn8okRyo-cy2oJVje7StMhCGK9R8Nn7IGjTUpSZDN-O$ or Androidhttps://urldefense.com/v3/__https://play.google.com/store/apps/details?id=com.github.android&referrer=utm_campaign*3Dnotification-email*26utm_medium*3Demail*26utm_source*3Dgithub__;JSUlJSU!!HYmSToo!LZzV_goQ9hM3DJ2rOAkzgAQ_xOi6pMn8okRyo-cy2oJVje7StMhCGK9R8Nn7IGjTUsqfOhm3$.

xhdong-umd commented 2 years ago

I made some changes and it can process data 1 and 3 (data 2 have timestamp error and cannot be processed) now.

ctmm-initiative / ctmmweb

cant import data #136