Google sheets power tools for DSpace CSV exports

[Bram Luyten]

Hello,

we have released a suite of power tools that allow following post-processing on CSVs exported from DSpace:

• removal of authority keys
• consolidating different columns for the same metadata field (language code variations)
• removing unselected columns

A walkthrough video for these tools is available from

https://www.youtube.com/watch?v=iF3Xs1-oSoA

The tools themselves have documentation and can be copied from

http://bit.ly/atmire-csv-power-tools

Shout out to my colleagues David Cavrenne and Benoît Wéry for their help with this.

cheers,

Bram

Bram Luyten 250-B Lucius Gordon Drive, Suite 3A, West Henrietta, NY 14586 Gaston Geenslaan 14, 3001 Leuven, Belgium atmire.com

[Anne Lawrence]

Bram,

Thank you for these power tools and video. They look quite useful. I have a request for additional functionality: to identify duplicate values in a given field.

Anne

[Benoît Wéry (@mire)]

Hello Anne, 

While this would be technically possible, it would probably be relatively heavy in terms of performance if we have to support that for any field (or all). 

Alternatively, I would suggest that you address this with plain formulas, e.g., assuming A1 is the cell that you want to deduplicate, have a new column B added with, in B1, the following formula that you can then drag down for all your rows: 

=join("||",transpose(unique(transpose(split(A1,"||")))))

(just replace A1 in there with whatever works for you). 

I hope this will do the trick for you. 

Best regards,

Benoît

[kelley...@sil.org]

Hi Bram -

I have used the Atmire Power Tools in Google Sheets with great success in the last few days (and love them!) but today I get this error when trying to Consolidate Multilingual Columns.

TypeError: Cannot find function concat in object Sun Mar 25 1900 07:00:00 GMT+0100 (CET).DetailsDismiss

Message details

TypeError: Cannot find function concat in object Sun Mar 25 1900 07:00:00 GMT+0100 (CET).

Any thoughts?

Thank you,

Kelley Canon

[kelley...@sil.org]

I obtained a new copy of the power tools google sheet to start from scratch.

I do the steps to Remove Authorities and it seems to work.  But then after I import my data into a new sheet and try to use Consolidate Multilingual Columns, I am again told that " A script attached to this document needs your permission to run. "  So I go through the authorization steps again but the script never works.  It always prompts me for authorization.

I appreciate this tool and would love to avoid spending the extra time to do this work manually.

Thanks,

Kelley Canon

[Kelley Canon]

Update:

I tried Remove Authorities one more time using my PERSONAL Google account instead of my work account, which I don't think I've ever had to do before, and this time it worked.

Maybe this information will help someone else get past this issue.  I'm not thrilled about using my personal account and would like to know why the work account did not allow authorities to be removed.

Kelley Canon

Language & Culture Archives

REAP Administrator

SIL International

--
All messages to this mailing list should adhere to the DuraSpace Code of Conduct: https://duraspace.org/about/policies/code-of-conduct/
---
You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group.
To unsubscribe from this group and stop receiving emails from it, send an email to dspace-tech...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/8e23ba70-fa26-471e-a166-c94095eb17c2n%40googlegroups.com.