In this project, we leverage the power of Excel, Python, and Tableau to analyze a real-world Netflix dataset sourced from Kaggle. By harnessing these tools and technologies, we uncover valuable insights and provide strategic recommendations to optimize Netflix’s content landscape and user experience.

Netflix is a renowned streaming platform that offers a wide range of movies and TV shows to a global audience. It has revolutionized the way people consume entertainment by providing on-demand access to a vast library of content.

The dataset utilized in this analysis is sourced from Kaggle, offering comprehensive information about Netflix’s content library, including titles, directors, cast, countries, release dates, ratings, durations, genres, and descriptions.

The analysis is based on a custom-built Netflix analytics dashboard, which provides visualizations and insights derived from the dataset.

https://public.tableau.com/app/profile/dinoco/viz/NetflixDashboard_16890075388300/Netflix

Let’s delve into the key findings that emerged from the data analysis.

• Movies: 68.42% TV Shows: 31.58%

• Movies dominate Netflix’s library, comprising 68.42% (4,265 titles), while TV shows make up 31.58% (1,969 titles).

• Netflix offers a diverse array of content, catering to a wide range of viewer preferences and ensuring an immersive entertainment experience.

• Top 5 Countries: United States, India, United Kingdom, Japan, Canada.

• Netflix sources content from major countries worldwide, providing a global perspective and appealing to a diverse international audience.

• Top 5 Ratings: TV-MA, TV-14, TV-PG, R, PG-13

• TV-MA and TV-14 are the most common ratings, indicating a balance between mature and family-friendly programming.

• Netflix offers content for a wide range of age groups and preferences.

• Documentaries, Stand-Up Comedy, Dramas, International Movies, Kids’ TV

• Documentaries, Stand-Up Comedy, and dramas with international movies are popular genres.

• Netflix provides a broad range of content for different demographics, including Kids’ TV and Children & Family Movies.

• The number of movies and TV shows on Netflix has consistently increased.

• The number of movies and TV shows on Netflix has witnessed consistent growth, indicating a commitment to expanding the content library.

• Netflix remains at the forefront of the streaming industry, continuously enriching the viewing experience for subscribers.

Strategically invest in compelling original TV series to augment the existing movie-focused library and cater to diverse viewer preferences. Expand content offerings from countries with substantial contributions to enhance global appeal and cultural relevance.

Leverage the popularity of genres like Documentaries, Stand-Up Comedy, and internationally flavored dramas to attract and engage viewers with varying interests. Tailor marketing campaigns to highlight region-specific content, tapping into local demographics and cultural connections.

Refine recommendation algorithms by leveraging individual viewing habits, ratings, and genre preferences to deliver personalized content suggestions. Introduce innovative features and curated playlists to facilitate content discovery and offer an immersive viewing journey.

Through the utilization of Excel, Python, and Tableau, this data portfolio project presents in-depth insights and strategic recommendations for Netflix’s content landscape and user engagement. By harnessing the power of these tools and technologies, we enable data-driven decision-making and highlight the importance of personalized recommendations and genre expansion.

In case anyone’s really interested in reading this:

Just a little test to try out the behavior of the new fossil git export feature of Fossil SCM.

Here is the slightly larger test version of the function by the author(s) himself, which mirrors the source code of Fossil.

The whole thing is actually only intended for storage and it cannot be ruled out that the behaviour of the then modified software will lead to undesired results.

Check possible bugs in behavior with an unpatched version of fossil before you report a bug at Fossil SCM.

The latest official versions of Fossil SCM: https://fossil-scm.org/home/uv/download.html

The diff contains a few changes for Fossil SCM and unravels the command input for ambiguous commands according to personal preferences.

The current default behavior of Fossil would be (which is pretty cool in itself):

$ fossil cl
fossil: ambiguous command prefix: cl
fossil: could be any of: clean clean-glob clearsign clone close
fossil: use "help" for more information

The diff command can now also use -u for --unified and -q instead of --brief.

The -h switch for global use has been added to display the help.

Disadvantages

You must use the long form of option -h in the following commands:

--html at commands: help, wiki
--versions at command: diff
--dereference at commands: sha1sum, sha3sum, test-tarball, test-filezip

The command call of fossil stash without further options now points to fossil stash list and not to fossil stash save as before.

The hidden test commands test-grep and test-diff are now more visible as fgrep xgrep and fdiff xdiff default since v2.17 (and mainly intended as a help for Windows use). Wir hatten ja nichts.

Visible as 1st tier command (fossil help): tkdiff, pool, xgrep
Visible as 2nd tier command (fossil help -x): addrm, private, tgz

With this commit the new method was introduced and described and is included in Release v2.20.
Thank you for this new feature among the other wonderful things.

• fnc: an interactive text-based user interface for Fossil
  See also: man fnc

• GWSL makes pretty windows when fossil runs on Windows in WSL.

• The environment variable FOSSIL_USER is useful to keep the name of the committer stable between machines and operating systems.
  For the commands fossil init -A (aka new) and fossil clone -A a different admin user name should be specified with the -A option.

Go to the root directory of the source files and do something like that patch -u -p 0 --dry-run < cmd-aliases.diff for testing.

My currently preferred build options:
./configure --disable-fusefs --json --with-openssl=auto --with-tcl=1 --with-tcl-private-stubs=1
or
./configure --disable-fusefs --json --with-openssl=auto
or
nmake /f Makefile.msc FOSSIL_ENABLE_SSL=1 FOSSIL_ENABLE_JSON=1 FOSSIL_ENABLE_TCL=1 OPTIMIZATIONS=4 clean fossil.exe

See also:

• Compiling and Installing Fossil
• Release Build How-To
• How to build Fossil into OCI compatible containers

Reminder for me: If patch is not lying around under Windows, then busybox or wsl -e is my friend.

Another way to get changes in (since v2.16): fossil patch and patch -h

• and (local) online as a Windows Service fossil winsrv create -P 8080 -S auto -R D:/Path/to/Repos --repolist & fossil winsrv start
• and wide fossil uv –help
• Althttpd with CGI

Using the Sonos Binding to allow openHAB to function as web radio by playing .mp3 live streams. If the URI contains aac or does not end by .mp3 you have to add x-rincon-mp3radio.

You have to create for each live stream a Switch item. Later a rule will trigger when a Switch item changed to ON and play an live stream by using its URI.

Group Webradio "Webradio" <receiver>

Switch Webradio_SWR1_BW "SWR1 BW" (Webradio)
Switch Webradio_SWR1_RP "SWR1 RP" (Webradio)
Switch Webradio_SWR2 "SWR2" (Webradio)
Switch Webradio_SWR3 "SWR3" (Webradio)
Switch Webradio_SWR_Aktuell "SWR Aktuell" (Webradio)
Switch Webradio_DASDING "DASDING" (Webradio)
Switch Webradio_SWR4_BW "SWR4 BW" (Webradio)
Switch Webradio_SWR4_RP "SWR4 RP" (Webradio)
Switch Webradio_Antenne1 "Hitradio antenne 1" (Webradio)

Group Webradio_Antenne1 "Hitradio antenne 1" <receiver> (Webradio)

Switch Webradio_Antenne1_Live "Hitradio antenne 1 Live" (Webradio_Antenne1)
Switch Webradio_Antenne1_80er "Hitradio antenne 1 80er" (Webradio_Antenne1)
Switch Webradio_Antenne1_90er "Hitradio antenne 1 90er" (Webradio_Antenne1)
Switch Webradio_Antenne1_2000er "Hitradio antenne 1 2000er" (Webradio_Antenne1)
Switch Webradio_Antenne1_Top40 "Hitradio antenne 1 Top 40" (Webradio_Antenne1)
Switch Webradio_Antenne1_ClassicRock "Hitradio antenne 1 Classic Rock" (Webradio_Antenne1)
Switch Webradio_Antenne1_ModernRock "Hitradio antenne 1 Modern Rock" (Webradio_Antenne1)
Switch Webradio_Antenne1_SoftNLazy "Hitradio antenne 1 Soft & Lazy" (Webradio_Antenne1)
Switch Webradio_Antenne1_WeihnachtsHits "Hitradio antenne 1 Weihnachts-Hits" (Webradio_Antenne1)
Switch Webradio_Antenne1_SommerHits "Hitradio antenne 1 Sommer-Hits" (Webradio_Antenne1)
Switch Webradio_Antenne1_DeutschPop "Hitradio antenne 1 Deutsch-Pop" (Webradio_Antenne1)
Switch Webradio_Antenne1_PartyKracher "Hitradio antenne 1 Party-Kracher" (Webradio_Antenne1)
Switch Webradio_Antenne1_UnpluggedAcoustic "Hitradio antenne 1 UnpluggedAcoustic" (Webradio_Antenne1)
Switch Webradio_Antenne1_Oldies "Hitradio antenne 1 Oldies" (Webradio_Antenne1)
Switch Webradio_Antenne1_InTheMix "Hitradio antenne 1 In The Mix" (Webradio_Antenne1)
Switch Webradio_Antenne1_Schlager "Hitradio antenne 1 Schlager" (Webradio_Antenne1)

Group Webradio_SWR3 "SWR3" <receiver> (Webradio)

Switch Webradio_SWR3_Live "SWR3 Live" (Webradio_SWR3)
Switch Webradio_SWR3_Lyrix "SWR3 Lyrix" (Webradio_SWR3)
Switch Webradio_SWR3_Rock "SWR3 Rock" (Webradio_SWR3)
Switch Webradio_SWR3_Party "SWR3 Party" (Webradio_SWR3)
Switch Webradio_SWR3_Mottotage "SWR3 Mottotage" (Webradio_SWR3)
Switch Webradio_SWR3_Specials "SWR3 Specials" (Webradio_SWR3)

Besides the Switch items for each live stream one <playuri_item> is needed. The <playuri_item> is refered to your Sonos speaker which uses the Sonos Binding to play a given URI. Also you need an <control_item> that you can stop playing the live stream.

rule "Webradio Hitradio antenne 1 changed to ON"
when
    Item Webradio_Antenne1 changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/a1stg/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne 1 changed to OFF"
when
    Item Webradio_Antenne1 changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Live changed to ON"
when
    Item Webradio_Antenne1_Live changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/a1stg/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne 1 Live changed to OFF"
when
    Item Webradio_Antenne1_Live changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 80er changed to ON"
when
    Item Webradio_Antenne1_80er changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/80er/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne 80er changed to OFF"
when
    Item Webradio_Antenne1_80er changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 90er changed to ON"
when
    Item Webradio_Antenne1_90er changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/90er/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne 90er changed to OFF"
when
    Item Webradio_Antenne1_90er changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 2000er changed to ON"
when
    Item Webradio_Antenne1_2000er changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/2000er/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne 2000er changed to OFF"
when
    Item Webradio_Antenne1_2000er changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top 40 changed to ON"
when
    Item Webradio_Antenne1_Top40 changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/top40/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top 40 changed to OFF"
when
    Item Webradio_Antenne1_Top40 changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Classic Rock changed to ON"
when
    Item Webradio_Antenne1_ClassicRock changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/rock/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Classic Rock changed to OFF"
when
    Item Webradio_Antenne1_ClassicRock changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Modern Rock changed to ON"
when
    Item Webradio_Antenne1_ModernRock changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/modernrock/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Modern Rock changed to OFF"
when
    Item Webradio_Antenne1_ModernRock changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Soft & Lazy changed to ON"
when
    Item Webradio_Antenne1_SoftNLazy changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/soft/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Soft & Lazy changed to OFF"
when
    Item Webradio_Antenne1_SoftNLazy changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Weihnachts-Hits changed to ON"
when
    Item Webradio_Antenne1_WeihnachtsHits changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/weihnachtshits/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Weihnachts-Hits changed to OFF"
when
    Item Webradio_Antenne1_WeihnachtsHits changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Sommer-Hits changed to ON"
when
    Item Webradio_Antenne1_SommerHits changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/sommerhits/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Sommer-Hits changed to OFF"
when
    Item Webradio_Antenne1_SommerHits changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Deutsch-Pop changed to ON"
when
    Item Webradio_Antenne1_DeutschPop changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/deutschpop/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Deutsch-Pop changed to OFF"
when
    Item Webradio_Antenne1_DeutschPop changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Party-Kracher changed to ON"
when
    Item Webradio_Antenne1_PartyKracher changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/partykracher/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Party-Kracher changed to OFF"
when
    Item Webradio_Antenne1_PartyKracher changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Unplugged Accoustic changed to ON"
when
    Item Webradio_Antenne1_UnpluggedAccoustic changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/unplugged/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Unplugged Accoustic changed to OFF"
when
    Item Webradio_Antenne1_UnpluggedAccoustic changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Oldies changed to ON"
when
    Item Webradio_Antenne1_Oldies changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/oldies/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Oldies changed to OFF"
when
    Item Webradio_Antenne1_Oldies changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top In The Mix changed to ON"
when
    Item Webradio_Antenne1_InTheMix changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/inthemix/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top In The Mix changed to OFF"
when
    Item Webradio_Antenne1_InTheMix changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio Hitradio antenne 1 Top Schlager changed to ON"
when
    Item Webradio_Antenne1_Schlager changed to ON
then
    <playuri_item>.sendCommand("http://stream.antenne1.de/schlager/livestream2.mp3?usid=H-M-09-0-0")
end

rule "Webradio Hitradio antenne Top Schlager changed to OFF"
when
    Item Webradio_Antenne1_Schlager changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR1 BW changed to ON"
when
    Item Webradio_SWR1_BW changed to ON
then
    <playuri_item>.sendCommand("https://d131.rndfnk.com/ard/swr/swr1/bw/mp3/128/stream.mp3?aggregator=web&cid=01FC1X3K2Z71SMDKMEC68DM7MW&sid=2D9g9Jx51DuDZCf3L3y7b3BiHwQ&token=k_FTXGAGjgcQvgGM8KfOsmFtC8X1JI-LUYNnFUMna0I&tvf=tIGCxNz-CRdkMTMxLnJuZGZuay5jb20")
end

rule "Webradio SWR1 BW changed to OFF"
when
    Item Webradio_SWR1_BW changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR1 RP changed to ON"
when
    Item Webradio_SWR1_RP changed to ON
then
    <playuri_item>.sendCommand("https://f111.rndfnk.com/ard/swr/swr1/rp/mp3/128/stream.mp3?aggregator=web&cid=01FC1X3Q82Y5KQ31V7YJVJJ07W&sid=2D9gUDldYx4rOlV7ycvKlgwIncZ&token=FWfMBjq_y0Tz7xNa88jSJpJFZbmw5PSh1CIu8DjgzPk&tvf=40H_bwP_CRdmMTExLnJuZGZuay5jb20")
end

rule "Webradio SWR1 RP changed to OFF"
when
    Item Webradio_SWR1_RP changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR2 changed to ON"
when
    Item Webradio_SWR2 changed to ON
then
    <playuri_item>.sendCommand("https://d131.rndfnk.com/ard/swr/swr2/live/mp3/256/stream.mp3?aggregator=web&cid=01FC1X4J91VJW1CVH6588MZEE3&sid=2D9gbkxIZPCONkbgNsF1JSsPTfq&token=WjX9HlSm5tKRLZOBAI2ZAMOMHZ73mbrVHKM3guPlzn0&tvf=myxZXRH_CRdkMTMxLnJuZGZuay5jb20")
end

rule "Webradio SWR2 changed to OFF"
when
    Item Webradio_SWR2 changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR3 changed to ON"
when
    Item Webradio_SWR3 changed to ON
then
    <playuri_item>.sendCommand("https://d121.rndfnk.com/ard/swr/swr3/live/mp3/128/stream.mp3?aggregator=web&cid=01FC1X5J7PN2N3YQPZYT8YDM9M&sid=2D9gfBju8QbeDa0gfuafFLgMDhk&token=fP3ORreQOqCrnJjY36dldQse5lYtgarP3gVoRlvcAHU&tvf=wqO5qBf_CRdkMTIxLnJuZGZuay5jb20")
end

rule "Webradio SWR3 changed to OFF"
when
    Item Webradio_SWR3 changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR Aktuell changed to ON"
when
    Item Webradio_SWR_Aktuell changed to ON
then
    <playuri_item>.sendCommand("https://d121.rndfnk.com/ard/swr/swraktuell/live/mp3/128/stream.mp3?aggregator=web&cid=01FC1X68PSW211RY56CDZQEEEN&sid=2D9gio7RTx4O2hROsDfuEG5MRT1&token=Lk-mn_cvfvuC7jlaFTGeswYchJFLSyrgtV5ZWUcz4QQ&tvf=p-uJRB7_CRdkMTIxLnJuZGZuay5jb20")
end

rule "Webradio SWR Aktuell changed to OFF"
when
    Item Webradio_SWR_Aktuell changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio DASDING changed to ON"
when
    Item Webradio_DASDING changed to ON
then
    <playuri_item>.sendCommand("https://f141.rndfnk.com/ard/swr/dasding/live/mp3/128/stream.mp3?aggregator=web&cid=01FBVQWZT2B1KGPFJ7TDHQ1Y2B&sid=2D9glq9pLGPdixItc8XSQx2XIaW&token=wzVN2Bn8BX4tVTafk4I9LF65avwOf7vLOO4RiVGgBVY&tvf=Eyyv4iP_CRdmMTQxLnJuZGZuay5jb20")
end

rule "Webradio DASDING changed to OFF"
when
    Item Webradio_DASDING changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR4 BW changed to ON"
when
    Item Webradio_SWR4_BW changed to ON
then
    <playuri_item>.sendCommand("https://f111.rndfnk.com/ard/swr/swr4/bw/mp3/128/stream.mp3?aggregator=web&cid=01FC1X86VT36Q01G4NBJ3Q4R1Z&sid=2D9gptklQZ1pfbwJELHsqAJFfcl&token=nn2-VBTumDScaj-shgLiMw3H0PugYRvJuAOShR3qBYM&tvf=T-IIniv_CRdmMTExLnJuZGZuay5jb20")
end

rule "Webradio SWR4 BW changed to OFF"
when
    Item Webradio_SWR4_BW changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

rule "Webradio SWR4 RP changed to ON"
when
    Item Webradio_SWR4_RP changed to ON
then
    <playuri_item>.sendCommand("https://f131.rndfnk.com/ard/swr/swr4/rp/mp3/128/stream.mp3?aggregator=web&cid=01FC1XCV71QFMQD2RNKF4BC5HG&sid=2D9gsbtnfcAb1UHhBHqAG3wlYvK&token=n91pcPHq14yLfEC9hQlTcD7-utPHSLAjBWaMXGSAK7o&tvf=1El-hjD_CRdmMTMxLnJuZGZuay5jb20")
end

rule "Webradio SWR4 RP changed to OFF"
when
    Item Webradio_SWR4_RP changed to OFF
then
    <control_item>.sendCommand(PAUSE)
end

At least you have to add following to your sitemap:

Text label="Webradio" icon="receiver" {
    Switch item=Webradio_SWR1_BW label="SWR1 BW"
    Switch item=Webradio_SWR1_RP label="SWR1 RP"
    Switch item=Webradio_SWR2 label="SWR2"
    Switch item=Webradio_SWR3 label="SWR3"
    Switch item=Webradio_SWR_Aktuell label="SWR Aktuell"
    Switch item=Webradio_DASDING label="DASDING"
    Switch item=Webradio_SWR4_BW label="SWR4 BW"
    Switch item=Webradio_SWR4_RP label="SWR4 RP"
    Switch item=Webradio_Antenne1 label="Hitradio antenne 1"
    Text label="Hitradio antenne 1" icon="receiver" {
        Switch item=Webradio_Antenne1_Live label="Hitradio antenne 1 Live"
        Switch item=Webradio_Antenne1_80er label="Hitradio antenne 1 80er"
        Switch item=Webradio_Antenne1_90er label="Hitradio antenne 1 90er"
        Switch item=Webradio_Antenne1_2000er label="Hitradio antenne 1 2000er"
        Switch item=Webradio_Antenne1_Top40 label="Hitradio antenne 1 Top 40"
        Switch item=Webradio_Antenne1_ClassicRock label="Hitradio antenne 1 Classic Rock"
        Switch item=Webradio_Antenne1_ModernRock label="Hitradio antenne 1 Modern Rock"
        Switch item=Webradio_Antenne1_SoftNLazy label="Hitradio antenne 1 Soft & Lazy"
        Switch item=Webradio_Antenne1_WeihnachtsHits label="Hitradio antenne 1 Weihnachts-Hits"
        Switch item=Webradio_Antenne1_SommerHits label="Hitradio antenne 1 Sommer-Hits"
        Switch item=Webradio_Antenne1_DeutschPop label="Hitradio antenne 1 Deutsch-Pop"
        Switch item=Webradio_Antenne1_PartyKracher label="Hitradio antenne 1 Party-Kracher"
        Switch item=Webradio_Antenne1_UnpluggedAcoustic label="Hitradio antenne 1 UnpluggedAcoustic"
        Switch item=Webradio_Antenne1_Oldies label="Hitradio antenne 1 Oldies"
        Switch item=Webradio_Antenne1_InTheMix label="Hitradio antenne 1 In The Mix"
        Switch item=Webradio_Antenne1_Schlager label="Hitradio antenne 1 Schlager"
    }
    Text label="SWR3" icon="receiver" {
        Switch item=Webradio_SWR3_Live label="SWR3 Live"
        Switch item=Webradio_SWR3_Lyrix label="SWR3 Lyrix"
        Switch item=Webradio_SWR3_Rock label="SWR3 Rock"
        Switch item=Webradio_SWR3_Party label="SWR3 Party"
        Switch item=Webradio_SWR3_Mottotage label="SWR3 Mottotage"
        Switch item=Webradio_SWR3_Specials label="SWR3 Specials"
    }
}

26.0.0 – RX 6600 8GB – x86_64

15.1.1 – WX 9100 16GB – x86_64 – Credits: @athleticat

15.1 – RX 6650 XT 8GB – x86_64 – Credits: @f0xb4t

15.0 Beta 1 – RX 6600 8GB – x86_64

14.7 – RX 5700 XT 8GB – x86_64 – Credits: @Naymmmm

14.5 – RX 6600 8GB – x86_64

14.4 Beta – RX 6600 8GB – x86_64

14.3 – RX 6600 8GB – x86_64

14.2.1 – RX 6750 XT 12GB – x86_64 – Credits: @heliokroger

14.1 – RX 6800 XT 16GB – x86_64 – Credits: @haxi0

14.0 – RX 6600 8GB – x86_64

13.5.1 – RX 6600 8GB – x86_64

13.5 – GTX 1050 Ti 4GB – x86_64 – Credits: @Zormeister

13.5 – RX 5600 XT 6GB – x86_64 – Credits: @rolowilde

13.4 – RX 6600 8GB – x86_64

12.7.5 – RX 6600 8GB – x86_64

11.7.10 – VESA / VGA Graphics – x86_64

11.0.0 – Developer Preview 1 (20A4299v) – VESA / VGA Graphics – x86_64

AppleInternal GoldenGateSpike (20A2314a) – VESA / VGA Graphics – x86_64

10.15.7 – VESA / VGA Graphics – x86_64

10.14.4 – VESA / VGA Graphics – x86_64

10.13.6 – GTX 470 1280MB

10.12.5 – AppleInternal Phoenix (16F5049f) – GTX 470 1280MB

10.12 – VESA / VGA Graphics – x86_64

10.11.6 – VESA / VGA Graphics – x86_64

10.10 – VESA / VGA Graphics – x86_64

10.9.5 – VESA / VGA Graphics – x86_64

10.8.5 – VESA / VGA Graphics – x86_64

10.7.5 – GTX 470 1280MB – x86_64

10.6.8 – ATI Radeon HD 5450 2GB – x86_64

10.6.8 Server – ATI Radeon HD 5450 2GB – x86_64

10.6.2 – AppleInternal Factory (10C540) – ATI Radeon HD 5450 2GB – i386

10.6 – Developer Preview 1 (10A190) – PowerPC

10.5.8 – VESA / VGA Graphics – i386

10.5.4 – VESA / VGA Graphics – PowerPC

10.5 Server – VESA / VGA Graphics – i386

10.4.11 – VESA / VGA Graphics – i386

10.4.11 Server – VESA / VGA Graphics – i386

10.4.11 – VESA / VGA Graphics – PowerPC

10.4.7 – VESA / VGA Graphics – i386

10.4.1 – Apple DTK Build 8B1025 – VESA / VGA Graphics – i386

10.3 – VESA / VGA Graphics – PowerPC

10.2 – VESA / VGA Graphics – PowerPC

10.1 – VESA / VGA Graphics – PowerPC

10.0.3 – VESA / VGA Graphics – PowerPC

1. Install/Update brew

   • Visit https://brew.sh/ for instructions and information.

2. Install/Update ruby

   • Once brew is installed, you can run brew install ruby in your terminal.
   • If using ZSH (any recent versions of macOS) Be sure to read the post install text as it suggest you should run the following command to export to PATH:
     • echo 'export PATH="/usr/local/opt/ruby/bin:$PATH"' >> ~/.zshrc
     • Restart Terminal for changes to apply.

3. Install/Update gem and bundler

   • Run gem update in your terminal window.
   • Run gem install bundler in your terminal window.

4. Fork DarwinKVM, git clone your fork, navigate to Docs directory.

   • git clone --recursive git@github.com:yourusername/DarwinKVM.git
   • cd DarwinKVM/docs

5. Installing Docs dependencies, and running the server.

   • Run bundle install in your terminal window.
   • Running bundle exec jekyll serve --incremental will build and run a live copy of the DarwinKVM docs on port 4000 by default.
   • To change the port, you can specify the IP address and port to run on, allowing local mobile devices to also connect and preview DKVM Docs.
     • bundle exec jekyll serve --host YOUR_IP_ADDRESS --port PORT --incremental

A C++ library for parsing, editing and serialising NBT data used in Java edition Minecraft.

I should warn you that this is not a finished library. Also I might rewrite it later but for now I stopped working on this

Currently the only docs are in tests/README.org, I will be figuring out a way to generate a github.io soon probably.

That readme I mentioned is just a description of what tests do and I may get rid of it if that readme will prevent me from just rewriting the tests or changing my mind about which implementation seems more logical or intuituve.

All started with an idea to make a procedural world generator, but since minecraft uses the same format for all it’s files this became a general purpose parser for NBT.

In real use case just using this library is insufficient since it doesn’t handle compression which is present in almost all minecraft files. Thus you will need to use gzip or zlib for decompression purposes.

This library also doesn’t read data from the file directly and instead uses a custom implementation of stream to access data. This in my opinion is better than using fstream since you can parse anything you really want and you are not restricted to compression type, position of the data in the file and the way you save/retrieve data from the file (FILE* vs fstream vs iostream, etc). And there is a safeguard build into the stream implementation to prevent infinite recursion after you run out of data.

Currently the development has stopped and I am adding Google test to catch any bugs and I know there are many. After all the code is finished I will get to work on increasing performance and efficiency.

You must have basic knowledge of C++ and some understanding of NBT.

It is a CMake project so all you need is this line in the terminal:

# run this in the root of the project
$ cmake -S . -B build

You should see CMake build an object library and automatically run google test. There is no sample executable yet.

Quote from Web Archieve: NBT specification by Notch:

NBT (Named Binary Tag) is a tag based binary format designed to carry large amounts of binary data with smaller amounts of additional data.
An NBT file consists of a single GZIPped Named Tag of type TAG_Compound.

A Named Tag has the following format:

byte tagType
    TAG_String name
    [payload]
  

There were originally 10 data types, but since snapshot 12w07a, (release version 1.2.1)[fn:1] 2 more tags have beed added making 12 total. Here is a list of all the tags:

Where: ID is byte tagType from NBT specs above.

If you spend some time reading the specs by Notch you will soon realize that there are 4 categories (kinds) of NBT tags[fn:2]:

Primitive

A non-array type

• Byte
• Short
• Int
• Long
• Float
• Double
• String

Array

Mono-type non-recusrive array container

• Byte Array
• Int Array
• Long Array

List

Potentially[fn:3] recursive and multi-type array container

Compound

Multitype potentially recursive container

Attempting to create an object of invalid tag (e.g. ArrayTag<unsigned int> instead of signed version) will result in undefined reference to [Kind]Tag::type().

[fn:1] Minecraft Wiki: Anvil file format.

[fn:2]End tag is excluded from the list since it is useless and dangerous to keep in memory as a class or struct, except for one case (list of end tags) where it is useless as a separate type either.

[fn:3] ListTag<ListTag<...> > is totally possible and in fact is part of minecraft files.

Even though the nested ListTag has a defined type, that type is undefined at a parent level (well, it is defined, but it’s a list, which is ambigious).

The above makes ListTag recursive and multitype.

This is a basic demo showing a Quarkus app, Apache Kafka backend and Apache Flink on Confluent Cloud.

Quarkus is a Kubernetes-native Java framework tailored for GraalVM and OpenJDK HotSpot. It optimizes Java specifically for containers, enabling developers to create applications that are lightweight and fast.

Apache Kafka is a distributed event streaming platform capable of handling trillions of events a day. It is used for building real-time data pipelines and streaming applications. In this demo, Kafka serves as the backbone for data transmission.

Apache Flink is a stream processing framework that allows for the processing of data in real-time. It is designed for high-throughput and low-latency data processing, making it ideal for analytics and event-driven applications.

Confluent Cloud is a fully managed Apache Kafka, Flink and other related services that simplifies the deployment and management of Kafka clusters. It provides a scalable and reliable environment for streaming data.

The Netflix user information is initially loaded from a CSV file. This data includes various metrics related to user engagement.

The loaded data is sent to a Kafka topic. This topic acts as a conduit for the data, allowing it to be streamed to the Confluent Cloud broker.

The data is serialized in Apache Avro format, which provides a compact binary representation and schema evolution capabilities.

Once the data is aggregated in Kafka, two Flink queries are executed:

• Average View Duration: This query calculates the average time users spend watching content.
• Daily Engagement Titles: This query identifies the titles that have the highest user engagement on a daily basis.

This demo used the confluent cloud stack cli documented here

Its a very useful cli that will provsion the entire environemt, cluster and most improtantly the registry as well. It also has the option to destroy the entire thing once done. Which is actually very helpful!

Anyways here is a similar out from what you should be able to see at the end after you run the command as per instructions on the link shared above.

To destroy this Confluent Cloud stack run ->
./ccloud_stack_destroy.sh stack-configs/java-service-account-sa-234cdf.config

try to view the config file and you should find most of the information required for the application.properties file. Except a couple more that you will find at Confluent cloud >> environment >> cluster >> topics. On top you will see the option for clients. Click that and in the Java Clients you should get the client id and more.

Following is the local configuration in the application.properties. All you need to do before starting the quarkus is set the env variables. You will need to get most of the information from Confluent cloud >> environment >> cluster >> topics. On top you will see the option for clients You can also setup the CSV_FILE_PATH which is the documents directory in this project folder.

# messaging connector settings.
mp.messaging.connector.smallrye-kafka.bootstrap.servers={BOOTSTRAP_SERVER}

# Kafka Security Settings
mp.messaging.connector.smallrye-kafka.security.protocol=SASL_SSL
mp.messaging.connector.smallrye-kafka.sasl.mechanism=PLAIN
mp.messaging.connector.smallrye-kafka.sasl.jaas.config=org.apache.kafka.common.security.plain.PlainLoginModule required username={CONNECTOR_USER} password={CONNECTOR_PASSWORD}

# Schema Registry Configuration
mp.messaging.connector.smallrye-kafka.schema.registry.url={REGISTRY_URL}
mp.messaging.connector.smallrye-kafka.schema.registry.basic.auth.credentials.source=USER_INFO
mp.messaging.connector.smallrye-kafka.schema.registry.basic.auth.user.info={REGISTRY_AUTH_KEY}

# Kafka Topic Replication Factor (for Confluent Cloud)
mp.messaging.connector.smallrye-kafka.replication.factor=3

# DNS lookup setting
mp.messaging.connector.smallrye-kafka.client.dns.lookup=use_all_dns_ips

# Consumer-specific settings
mp.messaging.connector.smallrye-kafka.consumer.session.timeout.ms=45000

# Producer-specific settings
mp.messaging.connector.smallrye-kafka.producer.acks=all
mp.messaging.connector.smallrye-kafka.producer.client.id={CLIENT_ID}

# set the connector for the outgoing channel to `smallrye-kafka`
mp.messaging.outgoing.users-uk-netflix-out.connector=smallrye-kafka
mp.messaging.outgoing.users-uk-netflix-out.value.serializer=io.confluent.kafka.serializers.KafkaAvroSerializer
mp.messaging.outgoing.users-uk-netflix-out.key.serializer=org.apache.kafka.common.serialization.StringSerializer
mp.messaging.outgoing.users-uk-netflix-out.topic=users-uk-netflix-out
mp.messaging.outgoing.users-uk-netflix-out.schema.registry.url=${mp.messaging.connector.smallrye-kafka.schema.registry.url}
mp.messaging.outgoing.users-uk-netflix-out.auto.register.schemas=true
#mp.messaging.outgoing.users-uk-netflix-out.use.schema.id=100002

# Single CSV File, can also be found in documents dir
csv-file-path={CSV_FILE_PATH}

You can run your application in dev mode that enables live coding using. It will start sending messages out. I am not printing them out on the console, but they should be visible in the cloud console, under topics>>messages.

./mvnw quarkus:dev

Daily engagement titles, T10

SELECT 
    DATE_FORMAT(TO_TIMESTAMP_LTZ(dateTime, 3), 'yyyy-MM-dd') AS watch_date,
    title,
    COUNT(*) AS daily_view_count,
    SUM(duration) AS daily_total_watch_time
FROM `ccloud-stack-sa-917qyv-ccloud-stack-script`.`demo-kafka-cluster-sa-917qyv`.`users-uk-netflix-out`
GROUP BY DATE_FORMAT(TO_TIMESTAMP_LTZ(dateTime, 3), 'yyyy-MM-dd'), title
ORDER BY watch_date DESC, daily_total_watch_time DESC
LIMIT 10;

Average duration watched T10

SELECT 
    title, 
    AVG(duration) AS avg_watch_duration
FROM `ccloud-stack-sa-917qyv-ccloud-stack-script`.`demo-kafka-cluster-sa-917qyv`.`users-uk-netflix-out`
GROUP BY title
ORDER BY avg_watch_duration DESC
LIMIT 10;

Please read the following instructions carefully.

A Progressive Web Application (PWA) is designed to look and behave in a way similar to a native application, scaled to fit the entire screen on iOS.

You create unique splash screens for each individual device.

• Tested using Sketch 52.5

Manually place the file in the following location to have it included in your templates in Sketch:

~Library/Application Support/com.bohemiancoding.sketch3/Templates

Or you can simply double click on the file and it will open in the app.

When you’ve created all the images, export as PNG x1 – the image sizes have been created to suit the retina screens (x2).

More information from Apple on creating and configuring Web Applications.

There is a blank_images folder with PNG files ready for you to modify in your preferred image editor.

• Check out the latest master to make sure the feature hasn’t been implemented or the bug hasn’t been fixed yet
• Check out the issue tracker to make sure someone already hasn’t requested it and/or contributed it
• Fork the project
• Start a feature/bugfix branch
• Commit and push until you are happy with your contribution
• Create a Pull Request to merge into the Master branch of the origin repository

This is free and unencumbered software released into the public domain.

Anyone is free to copy, modify, publish, use, compile, sell, or distribute this software, either in source code form or as a compiled binary, for any purpose, commercial or non-commercial, and by any means.

In jurisdictions that recognize copyright laws, the author or authors of this software dedicate any and all copyright interest in the software to the public domain. We make this dedication for the benefit of the public at large and to the detriment of our heirs and successors. We intend this dedication to be an overt act of relinquishment in perpetuity of all present and future rights to this
software under copyright law.

THE SOFTWARE IS PROVIDED “AS IS”, WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NON-INFRINGEMENT.

IN NO EVENT SHALL THE AUTHORS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.

For more information, please refer to http://unlicense.org

Este script realiza a análise de um banco de dados do Sistema de Informação de Agravos de Notificação – SINAN, em formato DBF, que tenha sido previamente geocodificado em um sistema de coordenadas UTM.
O objetivo é identificar casos suspeitos que tenham vínculo epidemiológico com casos confirmados por laboratório. Os critérios avaliados são a proximidade geográfica e a incidência em um mesmo intervalo de tempo, ambos configuráveis.

Este passo a passo pressupõe que o Python 3 já esteja instalado no sistema. O script faz uso de alguns módulos externos que precisam ser baixados da internet. Isso é feito de forma “semi-automática” pela ferramenta pip, que faz parte do Python.

O processo pode ser ligeiramente diferente a dependar da distribuição do Python que estiver instalada (Anaconda, WinPython, etc), mas na versão básica é o seguinte:

1. Através da opção Code > Download ZIP (acima), baixar o arquivo com o conteúdo deste repositório

2. Extrair o arquivo ZIP na pasta de sua preferência

3. Navegar até esse local pelo Explorador de Arquivos do Windows

4. Com a pasta aberta, segure a tecla shift do teclado e clique em qualquer espaço da janela com o botão direito do mouse

5. No menu “pop up”, selecione a opção Abrir janela do PowerShell aqui (ou Abrir janela de comando aqui, em versões mais antigas do Windows)

6. Checar se a linha de comando exibe o caminho da pasta correta. Opcionalmente, digite o comando dir (e tecle Enter) para se certificar de que o arquivo requirements.txt é listado

7. O ideal é que os módulos a serem baixados fiquem instalados em um ambiente virtual exclusivo deste script. Para criar esse ambiente, digite o comando: python3 -m venv env e tecle Enter

8. A depender da versão de terminal que estiver usando, digite um destes comandos para ativar o ambiente virtual:

   • PowerShell: env\Scripts\activate.ps1
   • Prompt de Comando: env\Scripts\activate.bat

   Atenção ao “S” maiúsculo.

9. Se o ambiente virtual foi ativado com sucesso, o indicador (env) vai aparecer antes da linha de comando. Isso feito, digite o comando pip install -r requirements.txt e tecle Enter

10. Os pacotes necessários serão instalados. Caso precise de informações mais detalhadas sobre ambientes virtuais, consulte as referências a seguir:

    • https://docs.python.org/pt-br/3/tutorial/venv.html
    • https://conda.io/projects/conda/en/latest/user-guide/tasks/manage-environments.html

1. Navegar até a pasta do programa pelo PowerShell ou pelo Prompt de Comando, como descrito acima

2. Ativar o ambiente virtual:

   • PowerShell: env\Scripts\activate.ps1
   • Prompt de Comando: env\Scripts\activate.bat

3. Executar o comando: python busca_ve.py

NOTA: Caso opte por instalar os pacotes na “raiz” do Python, sem o uso de ambiente virtual, os passos 7 e 8 da instalação e o passo 2 da execução podem ser ignorados.

O arquivo config.py pode ser modificado com qualquer editor de texto. Através dele podem ser feitos ajustes a eventuais alterações nos “dicionários de dados” do SINAN ou nos parâmetros considerados para vínculo epidemiológico. Como padrão, estão configurados os seguintes critérios:

• Distância de casos confirmados laboratorialmente em raio de 200 metros
• Intervalo de 15 dias antes ou depois de casos confirmados laboratorialmente

Caso seja editado, o arquivo config.py precisa ser salvo com a codificação UTF-8.

A Python library for isogeometric analysis (IGA) using FEniCS. The following article outlines the design of tIGAr:

@article{Kamensky2019,
title = "{tIGAr}: Automating isogeometric analysis with {FEniCS}",
journal = "Computer Methods in Applied Mechanics and Engineering",
volume = "344",
pages = "477--498",
year = "2019",
issn = "0045-7825",
doi = "https://doi.org/10.1016/j.cma.2018.10.002",
author = "D. Kamensky and Y. Bazilevs"
}

• Any meaningful usage requires FEniCS (version 2019.2) and its dependencies.
• SciPy is required. (SciPy is already included in FEniCS Docker distributions.)
• Usage of the NURBS module requires igakit.
• Compiling the API documentation requires Sphinx.
• The most convenient program for visualizing results is ParaView.

Install all dependencies, clone the repository (or download and extract from an archive), and append the top-level directory of the repository (viz. the one with subdirectories tIGAr, docs, etc.) to the environment variable PYTHONPATH, e.g., by adding

export PYTHONPATH=/path/to/repository/:$PYTHONPATH

to your ~/.bashrc file (and source-ing it). To (optionally) build the API documentation, change directory to docs and type make html. The main documentation will then be in ./_build/html/index.html, which can be opened with a web browser.

The most convenient way to use FEniCS (and therefore tIGAr) on HPC clusters is via Singularity. A singularity recipe for using tIGAr is in the file singularity-recipe.def. Some additional notes are provided in the comments of that file.

• petsc4py.PETSc.Mat object has no attribute PtAP: This is due to an old version of petsc4py. Try installing the latest version via pip3.
• ImportError: No module named dolfin: This occurs when attempting to use python rather than python3. FEniCS 2018.1 and newer no longer support Python 2.
• Python.h: No such file or directory: This requires installing the header files for the Python C API. On Ubuntu, these can be installed via sudo apt-get install python3-dev.
• ModuleNotFoundError: No module named 'scipy._lib.decorator': Try re-installing SciPy, which can be done with the command pip3 install --force-reinstall scipy.
• Errors due to old versions of FEniCS: Run dolfin-version in a terminal to check your version of FEniCS. Note in particular that Ubuntu PPAs for the current stable version of FEniCS are only maintained for the most recent few Ubuntu releases. Installing via the package manager on an old Ubuntu release may install an older version of FEniCS.
• libgfortran.so.3 cannot be found, or other issues with libgfortran when using the Singularity container: Try adding apt-get -y install libgfortran3 under the %post section in the file singularity-recipe.def.

PHP package to interface with ClickUp. We strongly encourage you to review ClickUp’s API docs to get a feel for what this package can do, as we are just wrapping their API.

We solely use Laravel for our applications, so this package is written with Laravel in mind. We have tried to make it work outside of Laravel. If there is a request from the community to split this package into 2 parts, then we will consider doing that work.

Branch	Status	Coverage	Code Quality
Develop
Master

• Installation
• Laravel Setup
  • Configuration
    • Optional Keys
• Generic PHP Setup
  • Examples
• Authentication
  • OAuth
  • Personal Token
• Usage
  • Supported Actions
  • Using the Client
    • Getting the Client object
    • Models
    • Relationships
    • Advanced filtering using “where”
  • More Examples
• Known Issues

Install ClickUp PHP Package via Composer:

$ composer require spinen/laravel-clickup

The package uses the auto registration feature of Laravel.

1. You will need to make your User object implement includes the Spinen\ClickUp\Concerns\HasClickUp trait which will allow it to access the Client as an attribute like this: $user->clickup

   <?php
   
   namespace App;
   
   use Illuminate\Contracts\Auth\MustVerifyEmail;
   use Illuminate\Foundation\Auth\User as Authenticatable;
   use Illuminate\Notifications\Notifiable;
   use Spinen\ClickUp\Concerns\HasClickUp;
   
   class User extends Authenticatable
   {
       use HasClickUp, Notifiable;
   
       // ...
   }

2. Add the appropriate values to your .env file

   Optional Keys

   CLICKUP_CLIENT_ID=<Application ID, if using OAuth to generate user tokens>
   CLICKUP_CLIENT_SECRET=<Application Secret, if using OAuth to generate user tokens>
   CLICKUP_OAUTH_URL=<url to clickup OAuth flow, default is v2>
   CLICKUP_URL=<url to clickup API, default is v2>

3. [Optional] Publish config & migration

   Config

   A configuration file named clickup.php can be published to config/ by running…

   php artisan vendor:publish --tag=clickup-config

   Migration

   Migrations files can be published by running…

   php artisan vendor:publish --tag=clickup-migrations

   You’ll need the migration to set the ClickUp API token on your User model.

To get a Spinen\ClickUp\Api\Client instance…

$ psysh
Psy Shell v0.9.9 (PHP 7.3.11 — cli) by Justin Hileman
>>> $configs = [
     "oauth" => [
       "id" => "<client_id>", // if using OAuth
       "secret" => "<client_secret>", // If using OAuth
       "url" => "https://app.clickup.com/api",
     ],
     "route" => [
       "enabled" => true,
       "middleware" => [
         "web",
       ],
       "sso" => "clickup/sso",
     ],
     "url" => "https://api.clickup.com/api/v2",
   ];
>>> $guzzle = new GuzzleHttp\Client();
=> GuzzleHttp\Client {#2379}
>>> $clickup = new Spinen\ClickUp\Api\Client($configs, $guzzle) // Optionally, pass the token as 3rd parameter
=> Spinen\ClickUp\Api\Client {#2363}
>>> $clickup->setToken('<a token>') // Skip if passed in via constructor
=> Spinen\ClickUp\Api\Client {#2363}

The $clickup instance will work exactly like all of the examples below, so if you are not using Laravel, then you can use the package once you bootstrap the client.

ClickUp has 2 ways to authenticate when making API calls… 1) OAuth token or 2) Personal Token. Either method uses a token that is saved to the clickup_token property on the User model.

There is a middleware named clickup that you can apply to any route that verifies that the user has a clickup_token, and if the user does not, then it redirects the user to ClickUp’s OAuth page with the client_id where the user selects the team(s) to link with your application. Upon selecting the team(s), the user is redirected to /clickup/sso/<user_id>?code=<OAuth Code> where the system converts the code to a token & saves it to the user. Upon saving the clickup_token, the user is redirected to the initial page that was protected by the middleware.

NOTE: You will need to have the auth middleware on the routes as the User is needed to see if there is a clickup_token.

If you do not want to use the clickup middleware to start the OAuth flow, then you can use the oauthUri on the Client to generate the link for the user…

$ php artisan tinker
Psy Shell v0.9.9 (PHP 7.3.11 — cli) by Justin Hileman
>>> $clickup = app(Spinen\ClickUp\Api\Client::class)
=> Spinen\ClickUp\Api\Client {#3035}
>>> $clickup->oauthUri(route('clickup.sso.redirect_url', <user_id>))
=> "https://app.clickup.com/api?client_id=<client_id>&redirect_uri=https%3A%2F%2F<your.host>2Fclickup%2Fsso%2F<user_id>"
>>>

NOTE: At this time, there is not a way to remove a token that has been invalidated, so you will need to delete the clickup_token on the user to restart the flow.

If you do not want to use the OAuth flow, then you can allow the user to provide you a personal token that you can save on the User.

$ php artisan tinker
Psy Shell v0.9.9 (PHP 7.3.11 — cli) by Justin Hileman
>>> $user = App\User::find(1)
=> App\User {#3040
     id: 1,
     first_name: "Bob",
     last_name: "Tester",
     email: "bob.tester@example.com",
     email_verified_at: null,
     created_at: "2019-11-15 19:49:01",
     updated_at: "2019-11-15 19:49:01",
     logged_in_at: "2019-11-15 19:49:01",
     deleted_at: null,
   }
>>> $user->clickup_token = '<personal token>';
=> "<personal token>"
>>> $user->save()
=> true

The primary class is Spinen\ClickUp\Client. It gets constructed with 3 parameters…

• array $configs – Configuration properties. See the clickup.php file in the ./config directory for a documented list of options.

• Guzzle $guzzle – Instance of GuzzleHttp\Client

• Token $token – [Optional] String of the user’s token

Once you new up a Client instance, you have the following methods…

• delete($path) – Shortcut to the request() method with ‘DELETE’ as the last parameter

• get($path) – Shortcut to the request() method with ‘GET’ as the last parameter

• oauthRequestTokenUsingCode($code) – Request a token from the OAuth code

• oauthUri($url) – Build the URI to the OAuth page with the redirect_url set to $url

• post($path, array $data) – Shortcut to the request() method with ‘POST’ as the last parameter

• put($path, array $data) – Shortcut to the request() method with ‘PUT’ as the last parameter

• request($path, $data = [], $method = 'GET') – Make an API call to ClickUp to $path with the $data using the JWT for the logged in user.

• setConfigs(array $configs) – Allow overriding the $configs on the Client instance.

• setToken($token) – Set the token for the ClickUp API

• uri($path = null, $url = null) – Generate a full uri for the path to the ClickUp API.

The Client is meant to emulate Laravel’s models with Eloquent. When working with ClickUp resources, you can access properties and relationships just like you would in Laravel.

By running the migration included in this package, your User class will have a clickup_token column on it. When you set the user’s token, it is encrypted in your database with Laravel’s encryption methods. After setting the ClickUp API token, you can access the Client object through $user->clickup.

$ php artisan tinker
Psy Shell v0.9.9 (PHP 7.2.19 — cli) by Justin Hileman
>>> $user = User::find(1);
=> App\User {#3631
     id: 1,
     first_name: "Bob",
     last_name: "Tester",
     email: "bob.tester@example.com",
     email_verified_at: null,
     created_at: "2019-11-15 19:49:01",
     updated_at: "2019-11-15 19:49:01",
     logged_in_at: "2019-11-15 19:49:01",
     deleted_at: null,
   }
>>> // NOTE: Must have a clickup_token via one of the 2 ways in the Authentication section
>>> $user->clickup;
=> Spinen\ClickUp\Api\Client {#3635}

The API responses are cast into models with the properties cast into the types as defined in the ClickUp API documentation. You can review the models in the src/ folder. There is a property named casts on each model that instructs the Client on how to cast the properties from the API response. If the casts property is empty, then the properties are not defined in the API docs, so an array is returned.

>>> $team = $user->clickUp()->teams->first();
=> Spinen\ClickUp\Team {#3646
     +exists: true,
     +incrementing: false,
     +parentModel: null,
     +timestamps: false,
   }
>>> $team->toArray(); // Calling toArray() is allowed just like in Laravel
=> [
     "id" => <7 digit ClickUp ID>,
     "name" => "SPINEN",
     "color" => "#2980B9",
     "avatar" => <URL to avatar>,
     "members" => [
       [
    // Keeps going

Some of the responses have links to the related resources. If a property has a relationship, you can call it as a method and the additional calls are automatically made & returned. The value is stored in place of the original data, so once it is loaded it is cached.

$folder = $team->spaces->first()->folders->first();
=> Spinen\ClickUp\Folder {#3632
     +exists: true,
     +incrementing: false,
     +parentModel: Spinen\ClickUp\Space {#3658
       +exists: true,
       +incrementing: false,
       +parentModel: Spinen\ClickUp\Team {#3645
         +exists: true,
         +incrementing: false,
         +parentModel: null,
         +timestamps: false,
       },
       +timestamps: false,
     },
     +timestamps: false,
   }
>>> $folder->lists->count();
=> 5
>>> $folder->lists->first()->name;
=> "Test Folder"

You may also call these relationships as attributes, and the Client will return a Collection for you (just like Eloquent).

>>> $folder->lists;
=> Spinen\ClickUp\Support\Collection {#3650
     all: [
       Spinen\ClickUp\TaskList {#3636
         +exists: true,
         +incrementing: false,
         +parentModel: Spinen\ClickUp\Space {#3658
           +exists: true,
           +incrementing: false,
           +parentModel: Spinen\ClickUp\Team {#3645
             +exists: true,
             +incrementing: false,
             +parentModel: null,
             +timestamps: false,
           },
           +timestamps: false,
         },
         +timestamps: false,
       },
       // Keeps going

You can do advanced filters by using where on the models

>>> $team->tasks()->where('space_ids', ['space_id_1', 'space_id_2'])->where('assignees', ['assignee1', 'assignee2'])->get()->count();
=> 100
// If there are more than 100 results, they will be paginated. Pass in another parameter to get another page:
>>> $team->tasks()->where....->where('page', 2)->get();

NOTE: The API has a page size of 100 records, so to get to the next page you use the where method… ->where('page', 3)

>>> $team = $user->clickUp()->teams->first();
=> Spinen\ClickUp\Team {#3646
     +exists: true,
     +incrementing: false,
     +parentModel: null,
     +timestamps: false,
   }
>>> $first_space = $team->spaces->first();
=> Spinen\ClickUp\Space {#3695
     +exists: true,
     +incrementing: false,
     +parentModel: Spinen\ClickUp\Team {#3646
       +exists: true,
       +incrementing: false,
       +parentModel: null,
       +timestamps: false,
     },
     +timestamps: false,
   }
>>> $folder = $first_space->folders->first()->toArray();
=> [
     "id" => <7 digit ClickUp ID>,
     "name" => "Test folder",
     "orderindex" => 3.0,
     "override_statuses" => true,
     "hidden" => false,
     "task_count" => 79,
     "archived" => false,
     "lists" => [
         // Keeps going

// TODO: Document known issues as we find them