update_from_googlesheet: Update a CSV file from a google spreadsheet

Description Usage Arguments

View source: R/update.R

Description

Update a CSV file from a google spreadsheet

Usage

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
update_from_googlesheet(file, from)

update_antibodies(file = "antibodies/antibodies.csv",
  from = "https://docs.google.com/spreadsheets/d/1gyiZth6awGqdB6YiQqDLL9WSha7KxI525GYY6aoxcCI/edit?usp=sharing")

update_primers(file = "primers/primers.csv",
  from = "https://docs.google.com/spreadsheets/d/1tYxhHsEN4mBGJRZXqJS7vK7TJJdP7Wayv4P14R9wTMI/edit?usp=sharing")

update_media(file = "media/media.csv",
  from = "https://docs.google.com/spreadsheets/d/1mG2Vr1sMnNAIX-NCFC33O0WoUVDrI3F6no78Czs6Y8U/edit?usp=sharing")

update_queries(file = "queries/queries.csv",
  from = "https://docs.google.com/spreadsheets/d/1VgVEg1iJrbjOU6kh_9i4ZxmINBaVkrxoF-kGl0m51WM/edit?usp=sharing")

update_treatments(file = "treatments/treatments.csv",
  from = "https://docs.google.com/spreadsheets/d/1pWgFVl_rQ2HUtPSIthf0REjGvLNEUfzr7ob9rRAw2NI/edit?usp=sharing")

update_strain_collections()


  update_strain_collection_cispt_sensitive_1(file = "strain-collections/cispt-sensitive-1.csv",
  from = "https://docs.google.com/spreadsheets/d/1vTC2im5t2u-PW4QJNNia_M2fsAVXqodOj3UPmhJ7-4A/edit?usp=sharing")


  update_strain_collection_MATa_cispt_384_hb_V2(file = "strain-collections/MATa-cispt-384-hb-V2.csv",
  from = "https://docs.google.com/spreadsheets/d/1nHFLrPqMODgpJaBkkcDniEnp8Cq7tA8iOowvCPI5wuQ/edit?usp=sharing")


  update_strain_collection_MATa_cispt_384_hb(file = "strain-collections/MATa-cispt-384-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/1r9VKumSwjGvEcBP8XebfCsXJnKDHvh_AnCKiiBty3rk/edit?usp=sharing")


  update_strain_collection_MATa_cispt_96_hb_V2(file = "strain-collections/MATa-cispt-96-hb-V2.csv",
  from = "https://docs.google.com/spreadsheets/d/1eCjWKnrF-H9A0qdaufYuir3CdIy-ueMffLv3MVezjp0/edit?usp=sharing")


  update_strain_collection_MATa_cispt_96_hb(file = "strain-collections/MATa-cispt-96-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/1f9XuSwpJeN-j5_wQ3mwUGOlsGH-dixgBnHeamzl7PzU/edit?usp=sharing")


  update_strain_collection_MATa_deletion_384(file = "strain-collections/MATa-deletion-384.csv",
  from = "https://docs.google.com/spreadsheets/d/1dl89Nf4oI9c6lhAxAfApdM1-mz-RqkzZbrE4DOPQjxk/edit?usp=sharing")


  update_strain_collection_MATalpha_deletion_384_hb(file = "strain-collections/MATalpha-deletion-384-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/1yyBZh8OEfjmR0oMENEqgCgUj03STMELHIZ08_Kl_fHQ/edit?usp=sharing")


  update_strain_collection_MATalpha_deletion_96(file = "strain-collections/MATalpha-deletion-96.csv",
  from = "https://docs.google.com/spreadsheets/d/1whG-KPW9htHvIR8LutivZpW3w3pEBSdEtJpg66aOaq0/edit?usp=sharing")


  update_strain_collection_MATalpha_CTF4_RAD5_384_hb(file = "strain-collections/MATalpha-CTF4,RAD5-384-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/145J9KpYN38Ra8TAw2-dvAc_g80EJ_iAeWtqqp-NlPf8/edit?usp=sharing")


  update_strain_collection_MATalpha_CTF4_RAD5_96_hb(file = "strain-collections/MATalpha-CTF4,RAD5-96-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/19CJrfjAgspW-zE2dkRa9nvQDsrfuWYO45dc3PSxiQII/edit?usp=sharing")


  update_strain_collection_MATa_ts_384_hb(file = "strain-collections/MATa-ts-384-hb.csv",
  from = "https://docs.google.com/spreadsheets/d/1zlM9wxoVHtSk5yac209veMCGZPvOnGRUdt5OJSqdGmA/edit?usp=sharing")


  update_strain_collection_info(file = "strain-collection-info/strain-collection-info.csv",
  from = "https://docs.google.com/spreadsheets/d/12osNdQV8Al6lVhvssnvnVajLXxMZ7qH6Bv8bwvrUg5c/edit?usp=sharing")

update_plasmids()

update_plasmids_pWJ(file = "plasmids/pWJ.csv",
  from = "https://docs.google.com/spreadsheets/d/15DXiQUBR4QQsthB7v9IU84ZcmiZB-kBKfrOjpiyisvw/edit?usp=sharing")

update_plasmids_ZOO(file = "plasmids/ZOO.csv",
  from = "https://docs.google.com/spreadsheets/d/1P-F7s-SGvey6B3_PWf-HGv07iwjkEqhwuz-muSyQuyU/edit?usp=sharing")

update_strains()

update_strains_special(file = "strains/special.csv",
  from = "https://docs.google.com/spreadsheets/d/1UT1e4LyINK1F_z_koIpNC217R-om5fKL1IdwRPt0CLI/edit?usp=sharing")

update_strains_J(file = "strains/J.csv",
  from = "https://docs.google.com/spreadsheets/d/1XaqVTIWVFpV4PWi2-N8qUrZJZpxuRfDUqdB8CdsmnMw/edit?usp=sharing")

update_strains_R(file = "strains/R.csv",
  from = "https://docs.google.com/spreadsheets/d/1UT1e4LyINK1F_z_koIpNC217R-om5fKL1IdwRPt0CLI/edit?usp=sharing")

update_strains_rec(file = "strains/rec.csv",
  from = "https://docs.google.com/spreadsheets/d/19UL9r7UNu72PAZ6fqXIJ8TpP1YB5JfCcpcknPCrw0W8/edit?usp=sharing")

update_strains_TS(file = "strains/TS.csv",
  from = "https://docs.google.com/spreadsheets/d/1J4MvBQTcJJLk2umR5jhsXPqn1SZ-SNWi763nBq7mNQY/edit?usp=sharing")

update_strains_U(file = "strains/U.csv",
  from = "https://docs.google.com/spreadsheets/d/1sj6cKonhGEcsE65pt_0QnIageBLEwv2MG2BW-b5NwoM/edit?usp=sharing")

update_strains_W(file = "strains/W.csv",
  from = "https://docs.google.com/spreadsheets/d/1sDqH44-LWbf4_loE_BVDxsehEoiZ44E93apYCtpgs1M/edit?usp=sharing")

Arguments

file

Where to save the CSV.

from

Where to download the CSV. (Must be an accessible google spreadsheet URL)


EricEdwardBryant/rothfreezer documentation built on Nov. 7, 2018, 2:57 a.m.