Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Raspberry PiとGoogleスプレッドシートで作るCTIシステム

3ce25d825c45c0dc8aacde8e835bc9fd?s=47 TAKAHASHI Taro
September 25, 2019

Raspberry PiとGoogleスプレッドシートで作るCTIシステム

3ce25d825c45c0dc8aacde8e835bc9fd?s=128

TAKAHASHI Taro

September 25, 2019
Tweet

Transcript

  1. 3BTQCFSSZ1Jͱ(PPHMFεϓ ϨουγʔτͰ$5*Λ࡞ͬͯΈͨ ΠϯλʔϚϯגࣜձࣾߴڮଠ࿠

  2. ࣗݾ঺հ w ߴڮଠ࿠ w ৬ۀɿαʔόʔαΠυΤϯδχΞ w ॴଐɿΠϯλʔϚϯגࣜձࣾ

  3. ࠷ۙߟ͍͑ͯΔ͜ͱ w αʔόʔαΠυΤϯδχΞͷੜଘઓུ w Ϋϥ΢υͷൃୡʹΑΓαʔόʔαΠυΤϯδχΞͷधཁ ͕ٸམ͢Δͱ༧૝ w ٸ଎ʹਐΉαʔόʔϨεԽ w ϑϩϯτΤϯυٕज़͚ͩͰαʔϏεΛ࡞ΕΔ࣌୅

    w αʔόʔαΠυΤϯδχΞɺ͍Βͳ͍Μ͡Όͳ͍ʁ
  4. ੜ͖࢒Δʹ͸ w αʔόʔαΠυҎ֎΋Ͱ͖ΔΑ͏ʹͳΔ w χονͳ෼໺Λ߈ΊΔ w ઐ໳ੑΛߴΊΔ

  5. χονͳ෼໺Λ߈ΊΔ w ຊ೔ͷ࿩͸ w ΦʔϓϯιʔεͰ࡞Δి࿩γεςϜ w $5*Λ࡞ͬͯΈΔ w ͳͥి࿩ͳͷ͔ w

    ฼਺͕େׂ͖͍ʹγεςϜԽ͕ਐΜͰ͍ͳ͍ࣄۀऀ͕ଟ͍ w ΤϯδχΞ͔Βͷਓؾ͕͋·Γͳ͍
  6. Φʔϓϯιʔεͷి࿩γεςϜ w "TUFSJTL w Φʔϓϯιʔεͷ*11#9 w ಺ઢి࿩໢Λ࣋ͬͨίʔϧηϯλʔΛ࡞Δ͜ͱ͕Ͱ͖Δ w ઃఆ͸͘͢͝೉͍͠ w

    'SFF1#9 w "TUFSJTLΛϒϥ΢β͔ΒઃఆͰ͖ΔΑ͏ʹ͢Δ࢓૊Έ w 'SFF1#9%JTUSPͱ͍͏-JOVYσΟετϦϏϡʔγϣϯ ΋͋Δ
  7. "TUFSJTLͷઃఆϑΝΠϧ

  8. None
  9. None
  10. 3BT1#9 w 3BTQCFSSZ1J༻ͷ-JOVYσΟετϦ Ϗϡʔγϣϯ w "TUFSJTLͱ'SFF1#9͕࠷ॳ͔Βೖͬ ͍ͯΔ w ͜Ε͚ͩͰ಺ઢి࿩໢ͷߏஙɺ֎ઢ ͱͷ઀ଓɺ'"9ૹड৴ɺ࿥Իɺࣗಈ

    Ի੠Ԡ౴ͳͲɺ͓Αͦίʔϧηϯ λʔʹඞཁͳ΋ͷ͸ԿͰ΋Ͱ͖Δ w ઃఆ͸͔ͳΓ೉͍͠ͷͰɺઃఆํ๏ Λઆ໌͢Δ͚ͩͰຊ͕Ұ࡭ॻ͚Δ
  11. $5*ͱ͸ w $PNQVUFS5FMFQIPOZ*OUFHSBUJPO w ి࿩͕͔͔͖ͬͯͨΒ૬खͷৄ͍͠৘ใΛදࣔ͢Δ࢓૊ Έ w εϚʔτϑΥϯͰి࿩ாʹొ࿥໊ͨ͠લ͕ࣗಈͰදࣔ͞ ΕΔͷ΋$5*ͷҰछͱ͍͑Δ͔΋ w

    ίʔϧηϯλʔͰ͸$5*͕ͳ͍ͱ࢓ࣄʹͳΒͳ͍΄Ͳศ རͳγεςϜ
  12. σϞ w 99999999ʹ99999999͔Βి࿩Λ͔͚ Δ w (PPHMFεϓϨουγʔτʹ99999999ͷ൪߸ͱ ͦͷి࿩൪߸ʹඥͮ͘ސ٬৘ใ͕දࣔ͞ΕΔ

  13. None
  14. None
  15. ࢓૊Έ

  16. ᶅͷ۩ମతͳ಺༰ w ి࿩͕͔͔ͬͯ͘Δͱ3BT1#9͕DVSMίϚϯυΛൃߦ ͠ɺIUUQTTDSJQUHPPHMFDPNNBDSPTTIPHFIPHF FYFD OVNCFS99999999ʹΞΫηε w 63-ʹରԠ͢Δ(PPHMF"QQT4DSJQU͕࣮ߦ͞Εɺి࿩ ൪߸ͱλΠϜελϯϓ͕(PPHMFεϓϨουγʔτʹॻ͖ ࠐ·ΕΔ

    w εϓϨουγʔτͷؔ਺Ͱผγʔτʹ͋Δސ٬৘ใΛి ࿩൪߸Ͱݕࡧͯ͠දࣔ
  17. 3BT1#9ଆ

  18. (PPHMF"QQT4DSJQU

  19. ηΩϡϦςΟ w $5*ͷ8FCIPPL͸ೝূͳ͠ w 63-͕ྲྀग़͢Δͱ$5*ʹ೚ҙͷి࿩൪߸Λॻ͖ࠐΊΔ w ސ٬৘ใ͸҆શ w 0"VUIͰೝূ͔ͯ͠ΒεϓϨουγʔτʹॻ͖ࠐΉํࣜ ΋ࢼ͕ͨ͠ɺ஗͗ͯ͢࢖͍෺ʹͳΒͳ͔ͬͨ

    w 'JSFCBTFͷ$MPVE'JSFTUPSF΁ͷॻ͖ࠐΈ͸ɺೝূ͋ΓͰ ΋࣮༻తͳ଎౓͕ग़ͨ
  20. ͪͳΈʹ w Ϋϥ΢υ͚ͩͰ΋ίʔϧηϯλʔ͸࡞ΕΔ w 5XJMJP w "NB[PODPOOFDU

  21. ·ͱΊ w χονͳ෼໺ʹ͸·ͩαʔόʔαΠυΤϯδχΞͷՄೳ ੑ͕࢒͍ͬͯΔ w 3BTQCFSSZ1J͕͋Ε͹ίʔϧηϯλʔ͸࡞ΕΔ w (PPHMFεϓϨουγʔτͰ΋࣮༻తͳ$5*Λ࡞ΕΔ