Arctos: how do I keep the date format in the CSV file? I can't bulkload the accessions.

[mbprondzinski]

* Please use the "Report Bad Data" link where available to ensure the correct Curator receives your message. *

* Outages should be reported to the contacts listed at https://arctosdb.org/arctos-down/ *

* Arctos Documentation is http://handbook.arctosdb.org/ *

* Learn more about Arctos at https://arctosdb.org/ *

* Please include enough information to re-create the problem if this request involves Arctos forms. Links and screenshots are helpful. *

[campmlc]

1) create your file as a xlxs file, use custom format yyyy-mm-dd - you may
need to create it.
2) When you are ready to create the csv, save as csv, but do not open it up
again in Excel, or Excel will reformat all your dates.
3) If you need to look at it, open it in a text editor.
4) If you need to make any edits, open the original xlsx file and make
edits there, then resave, and then resave again as a csv, replacing the old
one.
Isn't Excel fun!

On Wed, Nov 25, 2020 at 12:38 PM Mary Beth [e-mail] wrote:

• [EXTERNAL]*

* Please use the "Report Bad Data" link where available to ensure the
correct Curator receives your message. *

* Outages should be reported to the contacts listed at
https://arctosdb.org/arctos-down/ *

* Arctos Documentation is http://handbook.arctosdb.org/ *

* Learn more about Arctos at https://arctosdb.org/ *

* Please include enough information to re-create the problem if this
request involves Arctos forms. Links and screenshots are helpful. *

—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
https://github.com/ArctosDB/arctos/issues/3242, or unsubscribe
https://github.com/notifications/unsubscribe-auth/ADQ7JBAPOLUUKRFOX36XJ53SRVMMDANCNFSM4UC2FGBQ
.

[dustymc]

https://handbook.arctosdb.org/documentation/dates.html#excel-hates-me-help

[mbprondzinski]

I am well aware of all the above, and have tried using South African English to set the date format, but it still reverts back in some of the cells. But that is currently the least of my problems! I finally was able to upload the document, but every record has a problem, including "locality attributes" and the "agent names," which are all entered previously, some as "aka"s but does that matter or do they have to be entered as the "preferred name"? I also got back some strange "Higher Geography" doesn't exist messages, except it does because I did a search and it's already in Arctos. So I'm not sure what I need to do next... Any help would be appreciated. I have attached the file for perusal...except I had to save it as an excel workbook because github doesn't accept CSV.
bulkloader_stage.xlsx

[campmlc]

Try zipping the csv file and attaching it here - that way we don't have to
reformat all your dates!

On Mon, Nov 30, 2020 at 10:26 AM Mary Beth [e-mail] wrote:

• [EXTERNAL]*

I am well aware of all the above, and have tried using South African
English to set the date format, but it still reverts back in some of the
cells. But that is currently the least of my problems! I finally was able
to upload the document, but every record has a problem, including "locality
attributes" and the "agent names," which are all entered previously, some
as "aka"s but does that matter or do they have to be entered as the
"preferred name"? I also got back some strange "Higher Geography" doesn't
exist messages, except it does because I did a search and it's already in
Arctos. So I'm not sure what I need to do next... Any help would be
appreciated. I have attached the file for perusal...except I had to save it
as an excel workbook because github doesn't accept CSV.
bulkloader_stage.xlsx
https://github.com/ArctosDB/arctos/files/5617542/bulkloader_stage.xlsx

—
You are receiving this because you commented.
Reply to this email directly, view it on GitHub
https://github.com/ArctosDB/arctos/issues/3242#issuecomment-735927734,
or unsubscribe
https://github.com/notifications/unsubscribe-auth/ADQ7JBFZZSGQIWYRMNO4Q3DSSPIVHANCNFSM4UC2FGBQ
.

[mbprondzinski]

Oh, so that's how you keep the dates from changing!
bulkloader_stage.zip

I'm really trying to learn how to do this. Teresa took my original file and prepared it for the bulkloader so I no longer have it in excel, just the csv.

[dustymc]

All of the agent problems I can see are providing nothing (NULL) where something's required. https://handbook.arctosdb.org/documentation/bulkloader.html#fields

I checked a flagged geography, it's got extra spaces.

For the attribute I checked, Upper Cretaceous is mapped to Stage/Age. https://arctos.database.museum/info/ctDocumentation.cfm?table=ctlocality_att_att

[Jegelewicz]

Here is the excel I have.
Copy of IMLS upload.xlsx

[mbprondzinski]

Okay, thanks, Teresa. That will help me to make the additional changes. Do the agent names have to be entered in the records as the "preferred name" or can they be an "aka"? I got a number of names back that were supposedly not there.
Thanks!

[Jegelewicz]

aka should work UNLESS some other agent has the same name. Using preferred name is the safest bet.

[Jegelewicz]

@mbprondzinski by the way - all the files I have worked on for you or anybody else at ALMNH are in the dropbox which I just shared with you - I should have done that ages ago!

[dustymc]

https://handbook.arctosdb.org/documentation/bulkloader.html#agent-names

[mbprondzinski]

Hi Teresa,

Thanks for these files, but I am going to have you share them with the DMRC Dropbox as I have no room left in my personal dropbox. I will have to get that information to you, but probably not until tomorrow.

Another question: since half the taxonomy is out-dated, if I want to keep all the old synonymy, how do I do that? Is there another field I should add?

Thanks! (Today was supposed to be my day off…as usual, that went by the wayside!)

From: Teresa Mayfield-Meyer [e-mail]
Sent: Monday, November 30, 2020 1:38 PM
To: ArctosDB/arctos [e-mail]
Cc: Prondzinski, Mary Beth [e-mail]; Mention [e-mail]
Subject: [EXTERNAL] Re: [ArctosDB/arctos] how do I keep the date format in the CSV file? I can't bulkload the accessions. (#3242)

@mbprondzinskihttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmbprondzinski&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038067997%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nua7vtBbeTXHHCuP%2B%2FlF7em3eirUDdWL4edotij2UEQ%3D&reserved=0 by the way - all the files I have worked on for you or anybody else at ALMNH are in the dropbox which I just shared with you - I should have done that ages ago!

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FArctosDB%2Farctos%2Fissues%2F3242%23issuecomment-735997407&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038077988%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=wLMMm1M8qbL%2BU2938PRrr632u5D8V27CQ4ChTBgxIec%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAKJWLECHUVVZUU3SOILTPILSSPYBJANCNFSM4UC2FGBQ&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038077988%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=1TV1cUzwoJuPkU2DNSVjU26xv8HsSIQ%2Fu9T9p2oDOQY%3D&reserved=0.

[Jegelewicz]

since half the taxonomy is out-dated, if I want to keep all the old synonymy, how do I do that? Is there another field I should add?

My advice would be to add the records with the original (outdated) identification, then bulk add new identifications with the current taxonomy.

[mbprondzinski]

Hi Teresa!

Here is our DMRC email: [email protected][e-mail]

Send the files to me there. Thanks!

MB

From: Teresa Mayfield-Meyer [e-mail]
Sent: Monday, November 30, 2020 1:38 PM
To: ArctosDB/arctos [e-mail]
Cc: Prondzinski, Mary Beth [e-mail]; Mention [e-mail]
Subject: [EXTERNAL] Re: [ArctosDB/arctos] how do I keep the date format in the CSV file? I can't bulkload the accessions. (#3242)

@mbprondzinskihttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fmbprondzinski&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038067997%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=nua7vtBbeTXHHCuP%2B%2FlF7em3eirUDdWL4edotij2UEQ%3D&reserved=0 by the way - all the files I have worked on for you or anybody else at ALMNH are in the dropbox which I just shared with you - I should have done that ages ago!

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FArctosDB%2Farctos%2Fissues%2F3242%23issuecomment-735997407&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038077988%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=wLMMm1M8qbL%2BU2938PRrr632u5D8V27CQ4ChTBgxIec%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAKJWLECHUVVZUU3SOILTPILSSPYBJANCNFSM4UC2FGBQ&data=04%7C01%7Cmbprondzinski%40ua.edu%7C51672cc40eac4cc8f54108d895677fe1%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423619038077988%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=1TV1cUzwoJuPkU2DNSVjU26xv8HsSIQ%2Fu9T9p2oDOQY%3D&reserved=0.

[Jegelewicz]

done!

[mbprondzinski]

Thank you!

From: Teresa Mayfield-Meyer [e-mail]
Sent: Monday, November 30, 2020 6:32 PM
To: ArctosDB/arctos [e-mail]
Cc: Prondzinski, Mary Beth [e-mail]; Mention [e-mail]
Subject: [EXTERNAL] Re: [ArctosDB/arctos] how do I keep the date format in the CSV file? I can't bulkload the accessions. (#3242)

done!

—
You are receiving this because you were mentioned.
Reply to this email directly, view it on GitHubhttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2FArctosDB%2Farctos%2Fissues%2F3242%23issuecomment-736138786&data=04%7C01%7Cmbprondzinski%40ua.edu%7C33cc65ee006a4bc3f0e008d895908a45%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423795309432072%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=Pxfpx1y37T8FIUtrgEFQzHt6zDB06obUIBmpeg1Z%2FQk%3D&reserved=0, or unsubscribehttps://nam11.safelinks.protection.outlook.com/?url=https%3A%2F%2Fgithub.com%2Fnotifications%2Funsubscribe-auth%2FAKJWLEGM4AT7GAV4AKLKSVLSSQ2QRANCNFSM4UC2FGBQ&data=04%7C01%7Cmbprondzinski%40ua.edu%7C33cc65ee006a4bc3f0e008d895908a45%7C2a00728ef0d040b4a4e8ce433f3fbca7%7C0%7C0%7C637423795309442066%7CUnknown%7CTWFpbGZsb3d8eyJWIjoiMC4wLjAwMDAiLCJQIjoiV2luMzIiLCJBTiI6Ik1haWwiLCJXVCI6Mn0%3D%7C1000&sdata=n0WADSm%2FpWK7JEcpjKuq%2BzrLrSemIbrFzvASd37oO%2B4%3D&reserved=0.

[atrox10]

Just as an aside, I do all my bulkloaders in googlesheets and download them directly as CSVs from there. I never make them excel files, thus I don't have all the date formatting (and other) issues.