CSV template example?

203 views
Skip to first unread message

Sarah LeClaire

unread,
Oct 26, 2020, 1:51:28 PM10/26/20
to AtoM Users
Hello all,

I'm brand new to AtoM and am still trying to wrap my head around how to enter data into a CSV spreadsheet so it'll reflect the hierarchy and nest properly. Does anyone have an example spreadsheet they'd be willing to share so I can see how it's successfully done? Thank you so much in advance!

Dan Gillean

unread,
Oct 26, 2020, 4:51:56 PM10/26/20
to ICA-AtoM Users
Hi Sarah, 

First, a couple things that might help in general. I'm sure you've seen our documentation, but here's a link to some tips on preparing descriptions for CSV import:
We also have some slides from our Camps that you might find more accessible than a lot of text:  
They only have a few rows of placeholder sample data, much of which doesn't really reflect real archival description, but you still might find it helpful to take a look at the CSV templates we keep on our wiki - here are the description templates: 
More importantly, here's a suggestion for finding further examples of real descriptive data in AtoM production sites. Remember, AtoM 2.5 and later includes CSV export from the clipboard, including for public users. Because of this, you can therefore go find an existing AtoM site, add a fonds or collection to the clipboard and then export it - and compare that with how the description appears in AtoM's public interface. 

We keep an example list of public AtoM sites we know about on our wiki here: 
Instructions for using the clipboard, and exporting a CSV from the clipboard, for reference: 
As an example, I went to the Dalhousie University AtoM site, and found a fonds there - the A.M. Smith & Company Fonds: 
I've attached the clipboard export of this fonds for you to peruse. Keep in mind that Dalhousie is using the the Canadian RAD standard, so if you exported from a site using ISAD or another template, you may get slightly less columns on export. 

Hope this helps! 

Dan Gillean, MAS, MLIS
AtoM Program Manager
Artefactual Systems, Inc.
604-527-2056
@accesstomemory
he / him


On Mon, Oct 26, 2020 at 1:51 PM Sarah LeClaire <sarahle...@gmail.com> wrote:
Hello all,

I'm brand new to AtoM and am still trying to wrap my head around how to enter data into a CSV spreadsheet so it'll reflect the hierarchy and nest properly. Does anyone have an example spreadsheet they'd be willing to share so I can see how it's successfully done? Thank you so much in advance!

--
You received this message because you are subscribed to the Google Groups "AtoM Users" group.
To unsubscribe from this group and stop receiving emails from it, send an email to ica-atom-user...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/ica-atom-users/5bc16fb5-db68-46f3-993d-b764d3787198n%40googlegroups.com.
a.m.-smith-company-fonds.csv

Sarah

unread,
Oct 26, 2020, 8:27:42 PM10/26/20
to AtoM Users
Oh, wow! This is exactly what I was looking for. Thank you so much, Dan!
Reply all
Reply to author
Forward
0 new messages