Sunday, April 16, 2017

A Joomla CLI script to send database query output as a CSV attachment via email





image from: https://pixabay.com/en/linux-window-terminal-command-154766/

This Joomla CLI script lets you send a DB query output as a CSV attachment via Email.

You need to have a working Joomla website instance with emails setup done.

PHP Joomla CLI Script:
To use this:
1. Open terminal, Browse to Joomla root

cd /var/www/my-joomla-site

2. Execute PHP file 


php cli/joomla-cli-script-email-csv-attachment.php

3. You will see this as o/p on successful email sending 


Email sent

You can also setup cronjob to automate email sending.

Monday, September 26, 2016

Positive (+ve) words and adjectives list for sentiment analysis

Here is a list of some of the common English adjectives and words which can be used for positive feelings or used to describe positivity in the objects. This list of 1204 words can be used for the sentiment analysis of the text.

Yes

image from: http://www.freeimages.com/photo/letters-1-yes-1188348



abiding
able
absolutely
absorbing
abstinence
abundance
abundant
accelerate
accept
acceptance
accessible
acclaimed
accommodating
accomplished
accomplishment
accountable
ace
achievement
achieving
acknowledging
acquiescent
action
active
activist
acumen
adaptable
add
adjust
admirable
admire
admiring
adopt
adorable
adore
adored
adoring
adroit
advanced
adventure
affable
affectionate
affirmative
affirming
affluent
agile
aglow
agree
agreeable
airy
alert
alive
alliance
alluring
alter
altruistic
amaze
amazing
ambitious
amenable
amiable
amicable
amity
amorous
amused
amusing
angelic
animated
answer
apologetic
appealing
appreciation
appreciative
approachable
appropriate
approval
approve
approving
aptitude
aroma
articulate
artistic
aspiring
assertive
assisting
assured
astonish
astounding
astute
athletic
attacks
attentive
attraction
attractive
authentic
authoritative
autonomous
awake
award
awards
aware
awesome
balanced
bargain
basic
beaming
beats
beautiful
believable
believe
believing
benefactor
beneficent
benefit
benevolent
benfits
benign
best
bestowing
better
bid for
big-hearted
bighearted
bits
blameless
blessed
bliss
blissful
blithesome
bloom
bold
boost
bounce
boundaries
boundless
bountiful
bounty
brainy
brave
bravery
breakthrough
breezy
brief
bright
brilliant
brimming
bubbly
bullish
bunch
burgeon
buy
calm
candid
capable
captivating
care
careful
caring
casual
caution
celebrate
cerebral
certain
change
character
charismatic
charitable
charming
chaste
chatty
cheeky
cheer
cheerful
cherish
chic
choice
civil
clarity
classy
clean
clearheaded
clears
clever
clinches
closeness
co-operative
cognizant
coherent
colorful
comedic
comely
comfortable
comforting
comfy
commend
commendable
committed
companionable
companionship
compassionate
compatible
compelling
competent
complete
complex
compliment
composed
comradeship
concerned
conciliatory
concise
confidence
confident
confirming
congenial
connect
connected
connoisseur
conscientious
conscious
considerate
consistent
consoling
constant
consummate
contemplative
content
contributing
controlled
conviction
convincing
convivial
convulsive
cool
cooperative
copious
cordial
core
correct
coupled
courageous
courteous
coy
cozy
creamy
create
creative
credible
crisp
cuddle
cuddly
cultivate
cultured
cure
curiosity
curious
cute
daring
dashing
dazzling
debonair
decent
decisive
decorous
dedicated
deep
defined
delectable
deliberate
delicate
delicious
delight
delightful
deliver
deluxe
demand up
democratic
dependable
deserving
desirable
desire
detached
detailed
determination
determined
devoted
devotion
devout
diamond
difference
dignified
diligent
dimple
diplomatic
direct
disarming
discerning
disciplined
discover
discreet
discretion
discriminating
distinctive
distinguished
divine
dominate
donate
donates
doubles
dreamy
drool
dutiful
dynamic
eager
earnest
easy
easy-going
economy
ecstasy
ecstatic
educated
effective
effervescent
efficient
effortless
elated
electrifying
elegance
elegant
eloquent
embrace
embraces
eminent
empathetic
empathy
empowering
enchanted
enchanting
encompassing
encourage
encouraging
endless
endorse
endurable
energetic
energized
energy
engaging
enhance
enjoy
enkindled
enlightened
enormous
enormously
enriched
ensure
enterprising
entertaining
enthuse
enthusiastic
enticing
entirely
equitable
essence
essential
established
esteem
esteemed
ethical
even-tempered
everyday
exact
exactly
excellent
excelling
exceptional
excited
exciting
exclusive
exhilarating
exhilaration
exotic
expand
expert
explore
express
expressive
exquisite
extol
extra
extraordinary
exuberant
exultant
eye-catching
fab
fabled
fabulous
fair
fair-minded
faith
faithful
familiar
family
famous
fantastic
fascinating
fashionable
fast
favorable
favorite
fearless
felicitous
fertile
fetching
fidelity
fine
finesse
finest
fires up
firm
first
fit
fixes
fizz
flair
flattering
flexible
flip
flourishing
focused
foolproof
forbearing
forceful
foresighted
forever
forgiving
forthright
fortitude
fortuitous
fortunate
fortune
fragrance
frank
free
fresh
freshness
friendly
friendship
fruitful
fulfilled
full
fun
fund
funny
gains
gallant
galore
gather
generous
genial
genius
genteel
gentle
genuine
get
gifted
giggle
give
giving
glad
glamorous
gleeful
glitter
glorious
glow
glowing
go-ahead
goal-oriented
godly
golden
good
good looking
good mannered
good news
good-natured
goodhearted
goodness
gorgeous
grace
graceful
gracious
grand
grateful
gratitude
great
green
gregarious
grin
grounded
group
grow
growing
guaranteed
gutsy
handsome
handy
happy
hardy
harmless
harmonious
harmony
head for
head towards
healed
healing
healthful
healthy
heartwarming
hearty
heat up
heavenly
heedful
helped by
helpful
here
heroic
high
hike
hilarious
hires
hit highs
hold
holy
honest
honorable
honored
hopeful
hospitable
hug
humane
humble
humor
humorous
idea
ideal
idealistic
illuminated
illustrious
imaginative
immaculate
immense
impartial
impeccable
important
impressive
improve
improving
in focus
incentives
incomparable
increase
incredible
independent
individual
industrious
ineffable
influential
ingenious
initiative
innate
innocent
innovate
inspire
inspired
inspiring
instant
instantaneous
instinct
instinctive
integrity
intellectual
intelligence
intelligent
interdependent
interested
interesting
intimate
introduce
intuitive
inventive
invents
invest
invigorating
invincible
inviting
involved
irresistible
jazzed
jewel
join
join forces
joined
jolly
jovial
joy
joyful
joyous
jubilant
jubilation
juicy
jumps
just
k.o.
keen
keenest
key
kind
kind-hearted
kindhearted
kiss
kissable
know-how
knowing
knowledge
knowledgeable
laudable
laugh
launch
law-abiding
lays out
leader
leads
learn
learned
legend
legendary
leisure
lenient
level
liberal
lifts
light
likeable
lingering
lively
lofty
logical
longest
look ahead
love
loveliness
lovely
loving
lowly
loyal
lucid
lucidity
lucky
lucrative
luminous
luscious
luxurious
magic
magnanimous
magnetic
magnifies it
maintain
majestic
marvelous
master
masterful
masterly
matchless
mature
maxi
meaningful
meditate
meek
memorable
mend
merciful
meritorious
merry
metamorphosis
meticulous
mighty
mild
mind-blowing
mindful
ministering
miracle
mirthful
model
moderate
modern
modest
moral
more
motivated
motivating
mouthwatering
mover
moving
multi
munchy
mystical
nab
natural
naughty
need
neighborly
new
nice
nimble
noble
nominate
notable
nourish
nourished
nourishing
novel
nurture
nurturing
nutritious
o.k.
obedient
objective
observant
offer
on track
open
open-minded
openhanded
oppurtunity
optimistic
opulent
orderly
organised
organized
original
outlasts
outline
outmuscle
outperform
outrageous
outstanding
painstaking
palate
palatial
pamper
paradise
party
passionate
patch
patient
peace
peaceful
peak
pearl
penitent
perceptive
perfect
persevering
persistent
personable
persuasive
phenomenon
philanthropic
philosophical
pick-me-up
picks up
pious
placid
plans
plausible
playful
pleasant
pleases
pleasing
pleasure
plenteous
plentiful
plenty
plethora
plucky
plum
plump
plus
poetic
poise
polish
polished
polite
popular
positive
potent
power
powerful
practical
pragmatic
prayerful
precious
prefer
prepared
prestige
pretty
priceless
pride
prime
principle
privileged
prize
productive
professional
profit
profound
progress
progressive
project
prolific
prominent
promising
promote
prompt
proper
propitious
prosperous
protect
protection
protective
proud
provident
provider
prudent
punctual
pure
purpose
purposeful
pushes boundaries
qualified
quality
quantity
quenching
quest
questioning
quick
quick-minded
quiet
radiant
raise
rally
rational
ravishing
reach goal
ready
real
reap
reasonable
receptive
reciprocating
recognized
recommend
recommendation
recovery
refined
refinement
reflective
refresh
refreshing
reign
reinvents
rejoice
rejoicing
relax
relaxed
reliable
reliance
relieved
religious
rely
remains
remarkable
renew
renown
renowned
repentant
replenished
reposed
reputation
resigned
resolute
resolution
resound
resourceful
resources
respect
respectful
resplendent
responsible
responsive
rest
restore
restrained
reveal
revealing
revered
reverent
revolutionize
rewarding
rhetorical
rich
right
right now
righteous
righteousromantic
robust
romantic
rosy
rousing
royal
rule
sacrificial
safe
safety
sagacious
saintly
sanctified
satisfaction
satisfied
save
scholarly
scores
secure
sedate
seductive
seeker
seemly
select
selective
self-assured
self-reliant
selfless
sensation
sensational
sensible
sensitive
sensual
sentimental
serene
serenity
service
service-oriented
set
set to tussle
sexy
shapely
share
sharp
sheer
shift
shine
shoots
showcase
shown
shrewd
shy
signs
silence
silent
silly
silver
simple
simplicity
sincere
sincerity
singular
sizzling
skilful
skillful
slick
smart
smashing
smile
smiles
smiling
smooth
smooth solution
sobriety
sociable
soft
soft-spoken
solar
solid
solid quarter
sophisticated
soul
soulful
sound
sparkling
special
spectacular
speed
speedy
spice
spicy
spirit
spirited
spiritual
splendid
spontaneous
spotless
spotlight
sprite
spruce
spry
stable
star
steadfast
steady
stellar
steps up
stillness
stimulating
stir
stirring
stokes
strength
striving
strong
studious
stunning
stupendous
style
stylish
suave
sublime
submissive
subtle
success
successful
succinct
succulent
sun
sunny
super
superb
superlative
supersonic
support
supportive
supreme
sure
surge
surprise
sustain
sweet
swell
sympathetic
symphony
synchronized
systematic
tackle
tactful
talented
talkative
tan
tangy
tasty
team
temperate
tempting
tenacious
tender
terrific
thankful
therapeutic
thorough
thoroughbred
thoughtful
thrifty
thrilled
thrilling
thrive
thriving
tidy
tied
timeless
tingle
tiny
to add
to open
together
tolerant
top
top seller
tops
totally
tough
toughness
traditional
tranquil
transform
transformation
treasure
treat
trendy
triples
triumph
TRUE
trust
trustful
trusting
trustworthy
truth
truthful
ulltimate
ultimate
ultra
unbeatable
unbelievable
unbiased
unblemished
unconcerned
undeniably
understanding
undoubtedly
unfailing
unique
unity
unquestionably
unrestrained
unrivaled
unselfish
unsurpassed
unusual
unveils
unwavering
up
upbeat
uplifting
upright
v.i.p.
valiant
valuable
valued
vanish
varied
vary
venerated
venture
venturous
versatile
vibrant
victor
victorious
victory
vigilant
vigorous
vintage
virtuous
vision
visionary
visualize
vital
vivacious
volitional
voyage
wake up
warm
wealth
wealthy
wee
welcome
well
well-rounded
whimsical
whiz
whole
wholesome
whopper
willing
win
winner
winsome
wisdom
wise
witty
wonder
wonderful
wondrous
woos
work on
worldly
worthy
yes
young
youthful
yule
zany
zap
zeal
zealous
zest
zip
zoom