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 On Wed, Aug 5, 2020 at 4:03 PM kelley...@sil.org <kelley_ca...@sil.org> wrote: > 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 > > On Wednesday, August 5, 2020 at 11:15:01 AM UTC-5 kelley...@sil.org wrote: > >> 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 >> >> <https://docs.google.com/spreadsheets/u/0/?authuser=0&usp=sheets_web> >> 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 >> On Thursday, July 25, 2019 at 9:06:59 AM UTC-5 br...@atmire.com wrote: >> >>> 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 >>> >>> [image: logo] Bram Luyten >>> *250-B Luci*us Gordon Drive, Suite 3A, West Henrietta, NY 14586 >>> Gaston Geenslaan 14, 3001 Leuven, Belgium >>> atmire.com >>> <http://atmire.com/website/?q=services&utm_source=emailfooter&utm_medium=email&utm_campaign=braml> >>> >> -- > 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+unsubscr...@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 > <https://groups.google.com/d/msgid/dspace-tech/8e23ba70-fa26-471e-a166-c94095eb17c2n%40googlegroups.com?utm_medium=email&utm_source=footer> > . > -- 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+unsubscr...@googlegroups.com. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/CACXx6FsMafXXpOTN1O30ybUWOP-96udCSYPueTu%2B%2Bbeht5%3DTQg%40mail.gmail.com.
