GLAMSLAM 2018 Twitter Analysis

During GLAMSLAM 2018, I was approached by Deb Verhoeven to collect and analyse the Twitter action from #GLAMSLAM2018.

Never having done this before, it was a new experience but a fun one. I downloaded RStudio, got a Github account, signed up as a developer through the Twitter API and got cracking. If you want to know more about how I did this check the notes on my Github account.

Let me apologise in advance for the graphics, I would have loved to do a flashy infographic for you all but I ran out of time. If there’s anyone out there who does have time it would be great to see this in infographic form.

I harvested #GLAMSLAM2018 tweets starting from 21/02/2018 going until 02/03/2018. I saved them into a .CSV and deleted the ‘spammy’ tweets that weren’t conference relevant. I ended up with a data set that includes 597 tweets made during or after the conference and 466 retweets for a total of 1063 tweets.

I colour coded the Tweets by sector: Historian/Researcher, Archives, Museum, Gallery, Library, Software/Programming and unknown. This was problematic as many individuals work across different fields but I tried to categorize accounts as they described themselves in their Twitter profile. Here are the results of that analysis:

Total Number of Tweets by Sector
Historian/Researcher

432

Library

271

Archives

155

Museum

125

Gallery

8

Software/Programming

8

Unknown

64

Total

1063

tweets by sector

As you can see, the biggest group by far of the GLAM tweeters are the historians and researchers, which funnily enough aren’t represented in the acronym GLAM. I am proud to say that libraries came in as second, followed by archives.

Here are some analysis point that came from the RTweet application:

The Twitter word cloud below shows that ‘digital’, ‘collections’ and ‘access’ were frequently mentioned in tweets. You can also see that keynote speaker Sarah Ogilvie featured in many of the tweets.

GLAMSLAM2018_WordCloud_Small
Twitter Word Cloud

 

The most prolific tweeter of the day was @OzAlleyCat aka military historian Catherine C. Turner.

GLAMSLAM2018_TopTweeters

Another interesting fact… the GLAM tweeters love to tweet using their iPhones:

GLAMSLAM2018_Source

GLAMSLAM2018 Top Retweets

screen_name text retweet_count
lizatthelibrary Stanford dropped funding for MOOCs after they realised it wasn’t democratising Education, but was being accessed by white males in affluent countries with masters degrees @ogilviewords #glamslam2018 31
statelibrarynsw Smaller GLAM organisations may find these Digital Practice guidelines for Public Libraries useful! #GlamSlam2018 https://t.co/pX4t8mX6c5 23
statelibrarynsw We would love the humanities sector to experiment with our collections – new interpretations, new uses and serendipitous experiences! A great message for the end of our #glamslam2018 day @bestqualitycrab 21
jinglefrisbee Oh no someone is unironically calling the GLAM sector “Switzerland” and a safe space for dangerous conversations. I disagree, we aren’t a safe space for everyone and we aren’t neutral. #glamslam2018 21
cap_and_gown Hands up who think the arts provides a richer and more meaningful life? #glamslam2018 https://t.co/dwTj0vxKVw 20
jinglefrisbee Marcus Hughes from @maasmuseum now repudiating the idea of GLAM as a safe space but telling truth about exploitation of First Nations culture by GLAM. How complicit have we become & what are our choices? #glamslam2018 17
mikejonesmelb Ogilvie asking how the larger, better funded members of the GLAM Fam can help support others, not just locally but globally. A single networked collection of materials around the world. #glamslam2018 16
jessmcdnor FYI: Trigger warnings are not censorship! Breann Fallon says it helps students engage, it doesn’t make them disengage as feared #GLAMSLAM2018 https://t.co/SQJlsKpBpX 13
sallyturbitt GLAM orgs are repositories or places of human expression has descended and we are the caretakers. We care for it on behalf of the community, it’s not our stuff. #glamslam2018 @GionniDG 11
BonnieWildie “I’ve got young people who want a job. I don’t want them to be volunteers. I want to employ them.”

Yes! Let’s have this conversation, please.
#glamslam2018

10

GLAMSLAM2018 Top Favourites

screen_name text favorite_count
jinglefrisbee Oh no someone is unironically calling the GLAM sector “Switzerland” and a safe space for dangerous conversations. I disagree, we aren’t a safe space for everyone and we aren’t neutral. #glamslam2018 91
cap_and_gown Hands up who think the arts provides a richer and more meaningful life? #glamslam2018 https://t.co/dwTj0vxKVw 71
jessmcdnor FYI: Trigger warnings are not censorship! Breann Fallon says it helps students engage, it doesn’t make them disengage as feared #GLAMSLAM2018 https://t.co/SQJlsKpBpX 34
jinglefrisbee Marcus Hughes from @maasmuseum now repudiating the idea of GLAM as a safe space but telling truth about exploitation of First Nations culture by GLAM. How complicit have we become & what are our choices? #glamslam2018 33
lizatthelibrary Stanford dropped funding for MOOCs after they realised it wasn’t democratising Education, but was being accessed by white males in affluent countries with masters degrees @ogilviewords #glamslam2018 32
statelibrarynsw We would love the humanities sector to experiment with our collections – new interpretations, new uses and serendipitous experiences! A great message for the end of our #glamslam2018 day @bestqualitycrab 29
BonnieWildie “I’ve got young people who want a job. I don’t want them to be volunteers. I want to employ them.”

Yes! Let’s have this conversation, please.
#glamslam2018

29
statelibrarynsw We’re heading off to #glamslam2018 – ready to share our ideas and projects with the GLAM community. Anticipating a great day! https://t.co/pIAZMuBF2U 29
cap_and_gown Look at you all! Fantastic GLAMSLAMMERS at #glamslam2018 https://t.co/2oO4VYaIOp 25
mikejonesmelb Ogilvie asking how the larger, better funded members of the GLAM Fam can help support others, not just locally but globally. A single networked collection of materials around the world. #glamslam2018 22

Want to see a visualization of the Twitter network? I was going to do one but someone beat me to it! Check out this one from Stuart Palmer:

Twitter Network Visualization

Hope you enjoyed the Twitter analysis. If you want to see the data and my colour coded file you can download it here. Please let me know what you think!

Advertisements

Reflections on GLAMSLAM 2018

There has been much talk about galleries, libraries, archives and museums (GLAM) as a collective lately. GLAMSLAM 2018 united us over one long, inspiring, jam-packed day. Usually when I write about events I have attended I will write about certain presentations or workshops and interesting people I met. This time, I want to talk about the general themes and ideas floating around during the day without attributing them to any one person. That is because this conference felt like a very interactive collaborative effort and I kept hearing the same things from different people over the course of the day.

Here are my main takeaways from the day:

  • While Galleries, Libraries, Archives and Museums have much in common and much to learn from each other, we should be wary of convergence and despecialisation. We are all different and our differences make us great together.
  • GLAM professionals LOVE their jobs. We are a dedicated, overcommitted, self-sacrificing lot. We are overworked and underpaid but when people show us the value what we do, it makes it worthwhile. We are passionate about what we do. If you are in a GLAM institution and are not passionate about what you do, then do something else!
  • GLAM institutions should be always be not just customer-focused but community-focused. We need to LISTEN to our users and SEEK them out to let them know that we are here for them. GLAM institutions are here for EVERYONES benefit, not just the privileged. We need to encourage diversity in our collections, diversity in our user base and diversity in our workforce.
  • GLAM institutions need to stop being afraid. We are too cautious about copyright, too precious about our standards and protocols, too ready to declare ourselves ‘totally unbiased and neutral parties’. No cultural institution is neutral, no matter how hard they might try to be or how fervently they believe theirselves to be.
  • We need eachother. We need to band together and advocate. The GLAM sector in Australia has been suffering from funding cuts and budget slashing and things are getting dire. We need to make what we do more visible and show that we are not only wanted but needed. GLAM institutions make life better.
  • We need to stop making assumptions. We shouldn’t assume to know what our customers want. We shouldn’t assume that people in the humanities are ‘on the same page’. We shouldn’t assume that we know better. We shouldn’t assume that our actions won’t be offensive and insulting because we are ‘trying to do the right thing’.

So what was the day really about? There was a fair amount of showing off (as I tend to do), patting each other on the back, networking and learning about each other’s day to day work and special projects. This is the usual conference stuff.

What was different was that there was also a desperate need to be better and to improve our intuitions and a lot of constructive talk on how we can be better. It is challenge to hear someone say, “We think we are great at this, but we are not.” It is vital that these problems are acknowledged. Moving forward from that we can keep experimenting, keep learning, keep improving and build a better GLAM future.

Reflections on OA and Institutional Repositories

Towards the end of last year I was lucky enough to get a short-term contract to work on the Research Support Services team at my library, working with our institutional repository. Coming from special collections to research support was a great experience and I learned so much. This blog is a reflection of the time I spent on that team.

As someone who had never had dealings with an institutional repository, I knew what it was (a storage area for research outputs, with a focus on providing information and links to publications associated with the university and, if copyright allows, full-text versions of the publications). This was about all I knew and I had no idea how the records got into the repository.

The process starts with the university’s research output management system which is managed by individuals within the research support team. Once approved, the records go from this system into another, which acts as a holding tank for the records. They are then quality-controlled for metadata accuracy and the research team check copyright to see if they can post an open-access full-text copy in the repository and contact the author(s) for copyright permissions and author’s versions of the paper if necessary. From this point it is published into the main institutional repository. All theses for Phd work are also published through this institutional repository system.

This team is also in charge of liaising with academics to publish several open access journals. This is fascinating work as well, and I had the opportunity to do some basic format editing for one of these journals.

What is so important about institutional repositories? They freely disseminate quality research information and support open access (OA).

In the most simple terms OA articles are those that FREE to read online, no subscription required. If you are interested in open access I would highly recommend reading ‘The State of OA’ (Piwowar, et al., 2017). This paper goes into discussion on different levels of open access and discusses findings from analyzing data from online journals. They found that on average, open access articles receive 18% more citations. The authors also note an overall increase in OA papers. They estimate that in 2015, around 44.7% of articles were OA.

It’s clear open access is here to stay, and it’s important. For researchers, it can be difficult to understand the rules copyright around OA, they change from publisher to publisher.  Many publishers that have content behind a paywall actually allow authors to publish a version of their paper in their institutional repository, sometimes with an embargo period. Before working on the research support team, I already had an appreciation of Creative Commons licensing. Now I LOVE Creative Commons licensing because it makes copyright so easy and clear cut for institutional repositories.

Any researchers out there wanting to make their work OA? Talk with the publisher about Creative Commons licensing, some will ask you to pay for this privilege but it may be worth it if you really want to get your research out there. If you are already published and unsure of copyright, talk to a research support librarian, they will help you figure out the if, when and how of making your publications OA.


Piwowar H, Priem J, Larivière V, Alperin JP, Matthias L, Norlander B, Farley A, West J, Haustein S. (2017) The State of OA: A large-scale analysis of the prevalence and impact of Open Access articles. PeerJ Preprints 5:e3119v1 https://doi.org/10.7287/peerj.preprints.3119v1

Planning PD for the Year Ahead

Congratulations, we have made it to 2018. In fact, I’m posting this on the last day of January, the year is flying by already. Last year was a huge year for me in my professional development (PD). I attended a conference for the first time, presented at a conference for the first time, I had the opportunity to work with our library’s institutional repository team, and I learned a bit more about research in practice. In my previous blog post I noted the importance of planning for professional development and I’ve set aside a few hours today for planning.

The biggest challenge I face with PD (besides the obvious, finding time to do it!) is that I am interested in many different things, archives/rare books and special collections, research, academic libraries, library carpentry and digital humanities just to name a few! So how do I choose?

Since I’m a member of ALIA, the first thing I did was sign up for a Data Specialization in the ALIA PD scheme. I think this would be a good way to focus my PD efforts and I can branch out into my different interest through the lens of ‘data’. If you are an ALIA member, signing up involves filling out a form and sending it to ALIA (which they were very quick to reply to).

I have been in the ALIA PD scheme for a number of years but found it difficult to get past the rules of how many points you were allowed to earn per activity type. They have a more simplified scheme and now one hour of activity equals one point, simple. I have also found for many of my PD activities, instead of recording a activity reflection in the ALIA PD tracker, I can post blog about what I learned from the activity and put the link to the blog in the PD tracker.  The process of written reflection will be vital to my PD this year, as it will reinforce what I have learned and give me something to look back on.

How the Data Specialization works is that there is a list of core competencies and I complete activities around those core competencies. These are further explained in the Data Specialization Skills Audit which gives some examples of resources that can be consulted. The scheme is designed over three years and there are ten competencies. I will be aiming to cover one core competency every 3-4 months. Even though I would have many of these competencies already, I feel that going through all ten will add to my knowledge and help me keep track of new trends.

To help me on my data journey, I will start on the resources from the Open Data Institute.

In addition I want to work my way through some Library Carpentry lessons, which include data related lessons.

I will also be looking at conference papers and journal articles over my lunch break and blogging about them, a series I’m calling ‘Lunch Time PD’. How this will work is over an hour lunch break I will spend 20 to 30 minutes reading an article and 20 to 30 minutes typing up a reflection on what I’ve learned from the article in my blog. I’m not doing this every day, one a week will be great food for thought!

Now I just have to put some time aside for PD in my calendar and I’m ready to go. For more on the ALIA PD scheme, check out this post.

So do you have a PD plan for this year?

 

DIY PD for LT – ALIA’s Lib Tech 2017 Conference Recap

When I heard that the ALIA Lib Tech Conference were looking for abstracts, I thought, why not give it a go? So I ended up standing in an auditorium full of fellow library technicians talking about what I do, and it was a fantastic experience.

The one overarching theme of the conference was DIY PD for LT (Do it Yourself – Professional Development for Library Technician’s). The conference provided an opportunity see the range of issues that library technicians face and how these cross over to what I do working with a special collections repository.
Another theme was, ‘we’re all in this together, let’s collaborate’. There were a great range of social activities for networking opportunities. The sessions were great but perhaps even more valuable were the connections I made with others in my field. It was also wonderful to be a presenter at a smaller conference like this, people were very friendly.

Here’s a day by day recap of the conference.

The Tours – Day 0

I toured the fantastic digitisation lab at State Library of NSW and the Art Gallery of NSW Library. Both of these were fantastic but I won’t dwell on these but simply say, if you have a chance to tour either of these facilities, take it! An interesting tidbit, the State Library refers to their library users as ‘readers’ not ‘clients.

IMG_3563
Mitchell Library Reading Room, State Library of NSW

The Sessions – Day 1

The conference started with a bang with President of ALIA Vicki McDonald discussing the need for information professionals to both take advantage of opportunities and create opportunities for themselves. You are in charge of your own professional development (this came up time and time again throughout the conference).

Debra Gilmore who won the LT Research Award presented on the question, is there a need for increased ICT training in library technician courses in Australia? Great research here. Debra surveyed libraries and library technicians and the answer was an overwhelming, Yes.

Trent Tascon-Guillame had a wonderful presentation on connecting youth with the community. It was really interesting to see the ways in which he and library he works at are encouraging cross-generational learning and collaboration. He discussed three challenges in engaging with young people: change, age-based biases and ‘token’ participation. Trent used the slide below to point out some of the differences between age groups in their use of ICT, a good example of knowing your audience.

IMG_3594
Statistics on age difference and IT use from Trent’s talk

Renate Beilharz asked the question, Is programming essential for metadata specialists? She said that catalogers represented a very small piece of the pie in the world of data (see picture below). We don’t need to become programmers to be catalogers but we need to understand the underpinnings.

Metadata Universe capture
Excerpt from Seeing Standards – A Visualization of the Metadata Universe from Jenn Riley, http://jennriley.com/metadatamap/ CC BY NC SA, referred to in Renate Beilharz’s talk

Dr. Edmund Balnaves gave an interesting overview on harvesting to build institutional knowledge resources and discussed how cataloguing and search were essential for access.

The Q&A open forum panel discussion was with two librarians from America and one from Canada about differences in how how library technicians, professional organisations and conferences work in North America to how they work in Australia. One interesting fact from this one: the ALA conference usually has about 20,000 delegates! I can’t imagine what a conference like that would be like.

I also presented on this day and I will make a separate post with that content later.

The Sessions – Day 2

Day 2 started off with Dr. Perry McIntyre from Anchor books talking about how she believes in the value of physical/print books, an interesting perspective in an increasingly digital world.

Roxanne Missingham (rock star of the Australian library profession) discussed bridges for new careers and libraries as bridges of knowledge. Her presentation was very engaging with some live polling taking place during the presentation. She urges that we needed to be open to movement across sectors, especially since we have a lot to learn from each other.

‘A student walks into a University Library’ by Gaynor Cotter and Elizabeth Quilty of University of Sydney, explored some of the ways they support and encourage their students. I was amazed at the similarity between what they are providing at their library and what we are doing for students at the University of Newcastle.

There was more to this day but this post is getting too long…I will post more about the conference’s PD theme and ‘future-proofing’ your career next week.

 

 

 

So you want to be a conference presenter

Earlier this year I attended my first ever conference, now I’m getting the chance to write about presenting at a conference for the first time.

I am writing this for any librarians (or other GLAMRs) out there who might be reading this and think, “I could never do that” or “I could do that, why haven’t I?”.  Maybe there are people reading this interested in presenting at a conference and not sure where to start. This is the best conferencing advice I have so far (after completing only one, I am now an expert 😉).

My first experience presenting was at the Oral History Australia conference on a panel and my next one is in two weeks’ time at ALIA’s Library Technician conference present by myself. Next year I am presenting at VALA 2018 with my boss. The completed OHA presentation was on the Voices of the Hunter oral history project.

Below is a photo of my co-presenters and our panel Chair. Left to right are Alistair Thomson (Chair), me (Paige Wright), Rosie Heritage, Tyler Hersey and Lyn Keily. Rosie started the panel by introducing the oral history collection and it’s creator, Jack Delaney. Lyn and I talked more about the collection, data and how we enrich and provide access to the collection through our Living Histories @ UON site and through community outreach. Tyler discussed how to examine data from site traffic and use that to connect with audiences better. Lyn, Rosie and I worked together on the Voices of the Hunter project and Tyler works for NZMS whose community engagement platform Recollect runs the Living Histories @ UON site.

conference team

So how did I get there?

The first step is getting your abstract accepted and I have some very particular advice about this:

If one of your peers from another institution, library, whatever dropped by to see what you do at work, what would you tell them about your job? Is there anything new or exciting you want to share? The thing that you want to share with everyone about your job is the thing you should be writing an abstract and giving your presentation about. What is your story? It could be a story of success or a story of failure, people are interesting in hearing both at conferences. You don’t have to present Research at a conference but you can if you want. Sometimes you present first and end up doing a research project later (see Annelie de Villier’s experiences).

Also for a first-timer, why not present as a duo or part of a group? I found I was very comfortable presenting alongside my colleagues for the OHA conference. The amount of work you have to do in abstract writing, paper writing, and presenting in a group is less than if you had to present by yourself.

Once you’ve found the topic you want to present, then find a conference to suit. My first approach to abstract writing was to pick a conference that I really wanted to go to and make up something that I thought people at that conference would like to hear. Guess what? That one was not accepted because it wasn’t ‘real’, I wasn’t connected enough to what I wanted to say.

Instead of looking at conferences related to your particular GLAMR field, why not try a different one or one that would suit more than one profession. The OHA conference is an example of one that is attending by GLAMR people from many different types of institutions. You can also go the other way and try to find the conference that most specifically suits your nice, such as mine as a library technician. In any case, both of these are smaller conferences and I would suggest STARTING SMALL. It’s less pressure, less people and overall a more comfortable atmosphere.

I also want to point out the importance of knowing your conference. Do you have to write a peer-reviewed paper? Do you have to write a paper at all or just do a presentation? Find this out before you say ‘yes’ to presenting as it can make a big impact on how much time and work it will take you to prepare for the conference.

Building professional-level public speaking skills has been something I have worked on for years. In the lead up to this, I was given many opportunities to present to groups at workshops and events, and even presented to my colleagues at a university library staff update. All of these have helped build my presenting confidence but I still get nervous. One of my work mentors gave me some really great advice on this she said, “Just remember, you are the expert on this. They are not listening to you trying contradict you are prove you wrong, they just want to learn from you.”

One other piece of advice I can give is the more preparation you do, the better your presentation will be. Go over your slides, again and again and again. Practice them in front of people. Write notes on your Powerpoint  (you can see these during the presentation).

This first conference experience has been so positive. Everyone has been wonderful in telling me and my co-presenters that they enjoyed our session. Also, it was great getting feedback on the presentation on Twitter. I was so flattered that someone posted a photo of me presenting, it felt wonderful that others were so interested in a project that I had put so much work into.

One of the most helpful things I did in the lead up to my first conference presentation was to attend a VALA webinar on writing and presenting conference papers. You can still see the content of the webinar here. They outline some excellent do’s and don’ts of presenting and, unlike myself, the individuals speaking in the webinar have years of conference presenting experience.

So get out there, build your skills, write an abstract and if it’s not accepted don’t take rejection to heart (I didn’t).

FYI – Just in case you didn’t know, presenters are required to PAY to go to the conference, just like everyone else, but usually at a discounted rate. You might be able to get your employer to pay for the conference fee out of their PD fund (it’s worth a shot?). 

Will I have even more advice after my presenting by myself at the Lib Tech conference? Tune in, in about two weeks’ time for the answer.

 

 

VALA 2018 – Watch it online

In February I had the wonderful experience of attending AND presenting at VALA. It was a truly wonderful experience. So why am I writing about it now? They have JUST released videos from almost every session. So now you can read the conference papers, and watch the presentations.

Here are my top 5 takeaways from VALA 2018:

  1. ALWAYS consider your audience.
    Source: The Science of Interpretation: Lessons learned at the Science Museum, London, Natasha McEnroe, #p1, (Video)
    Notes: Natasha’s talk is a wonderful example of how librarians can learn from other professions. She gives a unique museum perspective on audience and includes some great anecdotes around social media.
  2. Now is the time for digital data and eResearch platforms for humanities, arts and social sciences – experiment and be bold.
    Source:  Cinderella Collections come to the digital humanities ball, Ingrid Mason and Roxanne Missingham #s3 (Paper) (Video)
  1. The revolution is here. Libraries are not neutral (and they never have been), libraries should advocate for ourselves and for our users.
    Source: The Revolution Will Not Be Standardized, Angela Galvan, #p4 (Video)
    Notes: Angela’s talk was thought-provoking and brought up many issues around critical librarianship including privacy and advocacy.
  2. You don’t want your library users to be ‘happy’, you want them to want MORE.
    Source: The C Equation: Content + Connection + Community = Contented Customer, David Lee King, #p5 (Video)
    Notes: David talks about ways to build community around libraries by connecting with users. A great perspective from the USA.
  1. Anyone can make fake news, when you see something on social media don’t take it at face value, investigate it.
    Source: We need to talk about fake news, Glenn Harper, #s35 (Paper) (Video)
    Notes: We have all heard about ‘fake news’. What I learned from Glenn is the sheer enormity of it. One example used was a Facebook meme supporting peaceful protest, that seemed like a positive empowering message. It took on a more sinister tone when the speaker revealed that the meme was actually circulated by the Russian government. Glenn argues that learning to spot fake news is a vital digital literacy skill.

Lunchtime PD: Academic Libraries and FB

For today’s #lunchtimePD exercise, I read:

Al-Daihani, S. and Abrahams, A., Analysis of Academic Libraries’ Facebook Posts: Text and Data Analytics. The Journal of Academic Librarianship, Vol 44, Issue 2 (2018).

A fascinating approach to LIS research, Al-Aihani and Abrahams used data and text-mining and sentiment analysis to analyse over 18,000 Facebook posts from the libraries of top ranked universities in the USA, UK, Canada and Australia. While the results weren’t necessarily surprising, they were insightful. The researchers found that the most engaging posts (with the most likes and comments) were those that had accompanying media content or photos. The most popular posts were about: animals, the library receiving accolades, new content from special collections and rare books, historical content, contests and the weather. I learned a lot just by reading about their analysis techniques and the tools that they used. This method could also be used for Twitter content analysis. Something to note though, this was a discussion of the data and findings but doesn’t draw inferences on how the data can inform best practices for academic libraries.

How to make a Twitter Bot without Coding Skills

Coding is wonderful but not everyone can do it. In an effort to make hacking more accessible to the everyday GLAMmer here is one solution for making a history/culture Twitter bot without coding. The goal of this is to automate tweets with photos of collection items and links back to digital item. If you do it right, it should look something like this @LivingHistUON :

Tweet

The method I used utilizes free accounts in all the services. Here is how it works

.CSV (spreadsheet) -> Google Calendar -> IFTTT -> Buffer -> Twitter

I would suggest you look into IFTTT and Buffer if you are not familiar with them. IFTTT can be used to ‘hack’ many different services and I think of it as a service that ‘does coding for you’. IFTTT has a really super simple interface. The most difficult part of this is getting the .CSV formatted correctly to import into Twitter. It is a lot of steps but focus on one service at a time and you will get through it. I would estimate if you aren’t familiar with these services that this should take you about two hours the first time.

So, here it goes:

  1. Start with a spreadsheet full of data from one collection. Your collections data needs at least three columns of metadata the title, link to the item and the link to the photo related to the item.
    1. You can add any extra text you want at this stage. For the above example, I used a feature called (CONCATENATE) in Excel to add “by Ralph Snowball” to the title.
    2. Then, combine the columns with the title and link to the item.
    3. For simplicity, keep your collections data in these two columns – “Title” and “Photo URL”.
  2. Format your data for Google Calendar. There are good instructions here: https://support.google.com/calendar/answer/37118?hl=en

You need to use the method laid out in “Create or edit a CSV file”. Rename your metadata rows in your spreadsheet, make sure the columns are in this order:

Subject =  Insert a column, unique identifier for each tweet, example Pic 001 (autofill down)

Start Date = Insert a column,  Date of first tweet

Start Time = Insert a column,  Time of first tweet

End Date = Insert a column,  Same as Start Date

End Time = Insert a column,  Five minutes after Start Time

All Day Event = Leave this row out, do not use

Description = Rename existing ‘Title’ column to Description. This is the text that will be tweeted.

Location = Rename existing ‘Photo URL’ column with image URL for what you want to tweet

Private = Leave this row out, do not use

After you have done the above, create a new Google Calendar on an existing account or new account, import the .CSV, and give the calendar a unique name (Twitter bot 1) make the calendar ‘public’.

I would recommend starting out with a list of 10 rows. Once you have the hang of it, you can used this method to queue thousands of Tweets at one time.

  1. Make a new Twitter account for your bot. DO NOT start with an existing account. Creating a new one leaves you room for error.
  2. Make an account in IFTTT. My advice would be to hook it up to your pre-existing Google account.
    1. Make a New Applet
    2. Click on ‘THIS’ – Choose Google Calendar
      1. Pick ‘New event from search added’
        1. Which calendar? (i.e. Twitter Bot 1)
        2. Keyword or phrase? Use ‘Pic’ (remember, I put the word Pic in the first column of my spreadsheet as an identifier)
        3. Click on ‘Create Trigger’
      2. Click on ‘THAT’ – Choose Buffer
        1. At this point it will prompt you to set up a Buffer account, do this and make sure your Buffer account is linked to your newly created Twitter account and that account is chosen
          1. Pick ‘Add photo to Buffer’
          2. Photo URL – Click on Add Ingredient, Choose ‘Where”
          3. Description – Click on Add Ingredient, Choose “Description”
          4. Click on ‘Create Action’
        2. You will end up with a ‘Recipe’ like this:
          Recipe.png
      3. Once you have this done, log into Buffer and adjust your Tweet schedule
        1. If you have done it correctly, once an event passes in the calendar, you should see a correlating tweet pop up in your Buffer queue. Buffer will then tweet it according to the schedule you have set within Buffer.

Don’t get discouraged if it’s not working the first time around, you might not have your .CSV file quite right. Just start over again from the beginning and you will get it figured out. Comments welcome.

Lunch Time PD: Learning from other professions

Last year I went to the ALIA Lib Tech conference and I wrote about some of the interesting papers I saw presented there. One paper I missed (I was presenting at the same time) was Rob Thomson’s (@RobThomson2528) paper ‘Studios and Libraries – Comparing two very different institutions’. While I have read the paper a few times since September, I haven’t sat down to write about and reflect on what Rob is saying, so I read it again today for my #lunchtimePD.

Rob discusses some of the similarities between studios and libraries: both thrive on technology, both have been digitally disrupted, both are constantly evolving. Libraries have much to learn from the studio industry. One thing in particular of note is how studios and libraries can work together to meet the deadline to digitise analogue mediums (VHS, cassette) before 2025 when these formats will no longer be readable.

Rob puts out a challenge for librarians to “get out of the library and go and talk to the creatives”.

He emphasizes the importance of collaboration within the GLAM sector and also touches on how GLAM institutions can collaborate with the public. He ends with a call to be creative when looking for funding to support strategic initiatives.

I urge you to read Rob’s paper for yourself. The one thing I took away from it is that important conversations happen when you interact with other professionals, especially those outside your profession. GLAMers have a lot to learn from each other and like Rob, I can’t wait for the rumored GLAM joint conference in 2020.