text:
Hi - This seems like a really simple questions, but I just can't sort it out. Where do I add a header and global blocks to the blog index page?
Adding header and global blocks to blog index page
Hi There,
The blog index page is the
Posts Page - Indexes in the header manager, you can assign your header to this page:
To add the global blocks to the blog index page, please make sure you've installed and activated the child theme first: https://theme.co/apex/forum/t/setup-how-to-setup-child-themes/57.
After that add this custom code under
functions.php file locates in your child theme:
function top_content() {
if ( is_home() ) {
echo do_shortcode('[cs_gb id=351]');
add_action( 'x_before_view_global__index', 'top_content' );
Don't forget to replace the
[cs_gb id=351] shortcode with yours.
Let us know how it goes!
Hi! Is the header manager part of Pro? I'm in the standard theme. If it is a part of both themes, please help me navigate to it.
Hi There,
The header & footer manager is only available in Pro theme only:
So, how do I accomplish this with the regular theme? How do I add a header to the blog page?
Hello @Moonpup,
Thanks for updating the thread.
In X Theme to have custom header will require custom development which falls outside the scope of support we can offer. However, to get started you can take a look at following article for some help.
You will have to use WordPress conditional tags to make the necessary changes. Here's resource that you can take a look:
In case you are not comfortable with programming, I suggest you to please take help from a developer.
Okay. Thanks… one last thing - how do I assign any header to the blog page? That should be pretty straightforward - right? It sounds like the standard theme is really getting phased out.
Hello @Moonpup,
Thanks for updating the thread.
First, I would like to make it clear that X Theme is not getting phased out. In fact we are investing more to make X Theme more useful and constantly adding more features. However, we launched Pro Theme as we realised that our community members were looking for more control on the website layout. And that's why we launched Pro Theme that comes with Header and Footer builder, using which users can create global or page specific header and footers.
By default X Theme comes with a global header that's consistent across the website. To have a different header on a specific page will require custom development. I shared the resources that can be used to get the desired effect. Please take a look at the same.
Great! Thanks for the explanation. That is reassuring since I've built so many sites on X. Slider revolution makes it easy to set headers on certain pages, I just can't sort out how to set it on the blog index page. Can you please tell me where to set the global header? I'm not sure why I've had so much difficultly locating this feature. I've used it before, but clearly I need a paper trail this time.
Hello There,
Thanks for updating in!
Please be informed that the global header is the default header when you are using X theme. You cannot set any other header for other pages. If you are referring to the slider above your header and would like to add a slider as a global header, there is no setting for it since the slider can only be assigned on a page by page basis. Please check out this article on how you can integrate a slider into your header: https://theme.co/apex/forum/t/features-sliders/97/1
And if you are referring to Pro theme, simply go to Pro > Headers then select a header and you will see the pages on the right side. You can simply click "Make Global".
Hope this helps.
I am referring to the standard theme. Where do I create a header for the website on the standard X theme that can be applied to the blog page? Anyone that can tell me this information would be my personal hero.
Hello @Moonpup,
As explained in previous responses, in X Theme you get one header that's consistent across the website. As of now in X Theme you don't get the option to create separate header for specific page which in your case is Blog page.
However, if you are comfortable with programming then you can definitely have separate header for blog page. We have shared the resources in earlier responses that you can take a look to get started.
Thanks for understanding.
It sounds like we are miscommunication. The way I've been adding headers to all my pages is by selecting the header on the page editor. How do I set one header for the whole site - one that is consistent on all pages - and therefore also on the blog page? I have the navigation set up correctly, but I don't see a way to add a main header - the one that is consistent across the website. Does that make sense? I don't feel like I am explaining myself very well.
Hello There,
Let me clarify first. Are you referring the the slider as the global header?
With X theme, you do not have any option to add a global header. What you can do is add a custom php code in your child theme's functions.php file. Perhaps something like this:
function add_global_header() {
echo do_shortcode('[revolution slider shortcode here]');
add_action( 'x_before_view_global__index', 'add_global_header' );
And when this displays in all over the pages, you might need to disabled the sliders assigned to the respective pages.
Hope this helps.
Amazing… perfect! Thank you. I'll give it a try and let you know if I have any other questions.
You are most welcome. If you have any questions, please create a new ticket and someone from Themeco support team will help you out.
Hey @Moonpup if I were you I would check out Pro (your X licenses can be converted to Pro).
You have much more freedom in terms of customization and will be able to assign different headers and navigation menus to specific pages as you wish (without more coding). I used to use X theme for clients, and now converted all of them to Pro. And wouldn't go back.
I know you're looking for a solution for X but I'm just saying this in general.
Hi @emile,
Thanks for the clarification!
This topic was automatically closed 10 days after the last reply. New replies are no longer allowed.


text:
Have you heard about FPV, if you don't you can refer to here. build a FPV is not a easy task, but now you can buy a RTF FPV helicopter from RC FEVER, manufacture buy Hubsan.As it is a FVP helicopter, it needs a build in camera on the helicopter. It has a tiny size with light weight that does not disturb the flying performance. You can see there are some sponge balls on the landing skid that protect the camera.
The front snapshot of the helicopter, the camera won't affect the overall outlook of helicopter.
Rotor hand, balance bar and blade holder, all use the metal structure. Very firm and resist to crash, it increase the overall weight of helicopter, so the helicopter also resist to wind.
Westland Lynx outlook of the helicopter, camouflage in color, really a great outlook.
Transmitter uses the foldable antenna design, that allow us much more easy to carry out.
For the protection of the monitor, it is a three layer covers. Prevent the monitor get scratched. Below have the button for setting, a buckle that allows the use of transmitter neckband.
The protection cover becomes the sun shield to prevent the sun light affects the use of monitor. So that we can still see the view clearly although under sun light.
Let's see the testing FPV of the helicopter, the screen also display the position of control stick and the flight mode etc.
Buy it now from RC FEVER.

subset: commoncrawl


text:
Very fun! I just wish there were more levels.
Our goal is for Newgrounds to be ad free for everyone! Become a Supporter today and help make this dream a reality!
Very fun! I just wish there were more levels.
Good concept, poor delivery. I'd have enjoyed it more if you had put more thought into designing the puzzles.
cool to see
its fun to see how that water is oin trough the pipes thanks for make this game.
It has one major error
When the water pours from another pipe it cannot fall out, it should be able to enter the pipe below that is not directly connected.
nice puzzle game
Good balance of easier puzzles and harder puzzles. I found levels 19 and 27 particularly difficult (the only ones I needed a glance at the walkthrough for). I especially like the use of red herring piping, etc. to make working out the math and the routes more brain-intensive.
The graphic design overall is good, but the water is a bit too square to look like water.


text:
- Home
- Woodwinds
- Saxophones
- Alto Saxophones
- P. Mauriat Professional Alto Saxophone - System 76, 2nd Edition - (Various Options)
P. Mauriat Professional Alto Saxophone - System 76, 2nd Edition - (Various Options)
Product Sku: SYSTEM-76A
Questions?We're here to help. Speak to one of our experts today. 877-884-9766
An alto sax that personifies vintage.
With an expanded bore and bell the P. Mauriat System 76 Alto Saxophone produces a bigger sound with a core that is full of rich overtones. This beautifully engraved instrument features a Super VI style neck, abalone key touches, and is available in vintage dark lacquer and also in classic gold lacquer. The vintage dark lacquer has warmer subtleties compared to the slightly more brilliant gold lacquer. Both, however, allow the player to deliver the highest performance possible due to the System 76's superior craftsmanship.
-Range: high F#
-Neck: Super VI
-Large bore and large bell
-Finish: vintage dark or gold lacquer
-Hand engraved bell and bow
-Key touches: genuine abalone
-Professional class
Other Options:
System-76 Series Alto Saxophones are available in 3 unique finishes: vintage dark lacquer (DK), classic gold lacquer (GL), & raw brass (UL). Each finish lends a different color to the sound.
SYSTEM-76ADK - The vintage dark lacquer finish produces a warm round sound players will fall in love with.
SYSTEM-76AGL - A gold lacquer finish has a slightly more brilliant tone than the vintage dark lacquer and offers players the classic look, feel, and response that one should expect of a professional saxophone.
SYSTEM-76AUL -Unfinished raw brass allows this sax to resonate freely. In addition, the absence of lacquer allows the brass to age over time, creating a unique vintage look and feel.
P. Mauriat is a leader in the industry as an innovator of modern vintage saxophones and trumpets. Each horn is handcrafted from start to finish out of the very finest materials. From fresh ideas in metal combinations, to cutting-edge neck designs and trendsetting finishes, P. Mauriat continually works to solidify their reputation for creating horns that offer the sound, response, ergonomics and intonation that will impress even the most demanding players.
Excellent Professional Sax
Posted by Kenneth Lee on 19th Aug 2016
I have now owned the System 76 for over a year now. I moved to this horn after playing my Selmer SA80 for 3 decades. The Selmer is an excellent horn, but in my opinion the System 76 has a better sound. The action is superb, the tone is centered and focused. You can easily play low and high notes, it is a very free blowing horn. If you are hesitant in purchasing this horn, I highly recommend you give it a try. I use a variety of mouthpieces depending on what type of music. For concert band I use a Vandoren Optimum and jazz a Jody Jazz HR.
Customers also viewed


text:
Grace loves Barbie.
She saw the Barbie A Perfect Christmas DVD at Walmart a few weeks ago, and the begging began. I knew that we were getting a copy to review, so I explained that she'd have to be patient and wait for it.
When you're 4, there is no waiting patiently.
On the other hand, I'm 32, and there is no waiting patiently, so perhaps being 4 doesn't have much to do with it.
My Thoughts about Barbie's A Perfect Christmas
This was perhaps my favorite Barbie movie so far.
You know that I cringe when I say that, but it is true. I have had concerns about some of the Barbie DVDs we've rented from the public library. Some have had questionable themes and oddly inappropriate language, and that bugs me.
In this DVD, there was none of that stuff. It's about Barbie and her little sisters, mostly normal kids (one is a blogger!), and they are trying to get to New York City to visit their aunt. Because of bad weather, their plane lands in Minnesota (or was it Montana?), and they get stuck at a festive inn for Christmas.
The story is fundamentally about disappointment and finding happiness in your situation, no matter what happens. That is a message I can stand behind.
Still, I wouldn't be me if I didn't notice a couple of oddities:
- The girls made snowmen without gloves on.
- The weather is too bad for Barbie and her sisters to get to New York City, but scores of people make it in for the big finale concert.
- After the concert, Barbie and Skipper burst out in ball gowns. You know, 'cause everyone has a ball gown in her suitcase for an occasion like this!
- The girls go outside to sing Christmas carols around the large Christmas tree in sleeveless and strapless dresses and no coats.
Okay, I'm done.
I'm aware that some of my points above are silly, and that it is a cartoon. I'm just telling the truth here.
Grace's Thoughts about Barbie's A Perfect Christmas
Grace loved the movie so much that she watched it twice straight through, and she has been singing the songs ever since. In the week or so since it came, we've watched A Perfect Christmas at least six times.
Don't judge me. It has a good message.
Win a Barbie A Perfect Christmas DVD
Barbie and One2One Network are providing me with a copy of the Barbie A Perfect Christmas DVD to give away to one lucky Feels Like Home reader. All you have to do to enter is answer this question in a comment:
What makes a perfect Christmas for you?
For extra entries:
- Like Feels Like Home on Facebook and leave a comment about it
- Subscribe to Feels Like Home via RSS or email and leave a comment about it
- Tweet the following (only once):
What's your perfect Christmas? Leave a comment to enter to win Barbie's A Perfect Christmas DVD from @TaraZiegmont http://wp.me/pOQz4-3m9
Good luck! I'll choose a winner randomly from the comments after noon on December 22.
I received a copy of the Barbie A Perfect Christmas DVD to review as well as compensation for my time. This post contains affiliate links. All opinions are my own.
© 2011 – 2018, Tara Ziegmont. All rights reserved.


text:
La Vista City
Discover this breathtaking contemporary Villa featuring one bedroom with a dressing area and four bedrooms with six bathrooms, La Vista City Villa covers a land area of 530m2 surrounded by garden area of 350m2, providing a spacious home for the whole family to be comfortable in. Featuring two living rooms, a maid's quarter, a laundry area and a roof area of 58m2, the two-decker grand villas respond to your everyday needs and spoil you with exclusive luxuries.
La Vista Developments is pleased to announce its new project over 910 Acre "La Vista City" which occupies a very prime location in the New Capital's entrance, directly on the Central Regional Road in New Cairo. The project includes various residential units from Villas, Town and Twin House, while all the units are overlooking Landscape & Water Features.
Subscribe to our newsletter and stay updated with the latest developments and special offers!


text:
An ancient wisdom known only to Gnostics had previously become lost to humanity in the mists of time. This secret knowledge is now revealed to you for the first time, in The Key to the Great Secret, and can be seen in paintings by Poussin and Teniers – so there is no mistaking its existence. What is revealed in the paintings is a secret method of prayer that allows one to have a direct experience of God, just as Gnostics have always maintained. Furthermore, access to God allows one to develop to a much higher level of consciousness and wisdom, allowing them to ultimately attain The Holy Grail of spiritual immortality.
This Gnostic Heresy was almost wiped out by the Catholic Church, but has survived and exists in secret organisations to this day. These remaining Gnostics are the trustees to our natural inheritance and hopefully will now feel free to come forward to guide us on our true path.
The Key to the Great Secret provides readers with the opportunity to unlock the reality of The Holy Grail, so that they may see with spiritual eyes and understand with Gnostic wisdom.
"In all honesty and humility, if everything in this book is true, then it has to be one of the most important books ever written – simply because of what it contains. This book contains the greatest secret in the world. Is this a hoax or not? You must decide," says author T. Findley.
T. Findley was born in Leicester in 1947 and, after leaving school at 16, worked as a draughtsman for 16 years before leaving to go to Loughborough University where he gained a BSc. Hons. degree in Social Psychology. He then worked for several years as a psychotherapist before joining the NHS mental health team in Leicester.
Click here to browse inside.


text:
"Washington is one of maybe ten things he does in his job," said a Comcast spokeswoman. Cohen also oversees the company's corporate communications, diversity and other functions.
Cohen is not the only influential figure who, despite being the face of Comcast in Washington, does not have to register as a lobbyist. Former lawmakers symbolize the tightrope between influencer and lobbyist — several who have taken lobbying-related jobs are not registered, including former senators Chris Dodd (D-Conn.), Mark Begich (D-Alaska) and Mark Pryor (D-Ark.).
Former Senate Majority Leader Tom Daschle (D-S.D) was emblematic of this trend until just recently. Since leaving Congress in 2005, he has worked at a number of firms, eventually opening his own lobby business in 2014, a subsidiary of the law firm Baker Donelson. But he only earlier this year formally registered as a lobbyist.
"Part of it had to do with my decision that I was unlikely to go back into public service," Daschle said. "While I had some interest in doing that in the past, I think I hit a stage in my career and in my life when that is unlikely."
This year, for the ninth consecutive time, the number of registered lobbyists in Washington has fallen. The figure has dropped nearly 30 percent from about 14,800 in 2007 to 10,500 today, according to the Center for Responsive Politics, which tracks lobbying activity. But ask virtually any member of Washington's booming influence industry and they will tell you: there aren't fewer lobbyists, there are just fewer people labeling themselves as such.
Eschewing the lobbyist label in favor of more palatable designations — policy adviser, strategic counsel or government relations adviser are popular ones — is not new. But it appears to have grown more prevalent during the two terms of President Obama, who put greater restrictions on lobbyists working in the executive branch than any other president.
If Hillary Clinton wins the election in November, there is speculation that she may roll back those restrictions or change them significantly.
Lobbyists in both parties say Obama's policy encouraged some lobbyists to de-register — and would-be lobbyists not to register — in order to preserve their prospects of working for the administration. But there are other forces driving the trend, and the model of "unregistered" lobbyists seeking to influence the government is likely here to stay unless the next president and Congress close loopholes that allow the practice to flourish.
The Lobbying Disclosure Act, the federal law that governs lobbying, was passed in 1995 and most recently revised in 2007. It requires those who spend at least 20 percent of their time on lobbying activities for a client in a three-month period to register with the Senate. It allows many people who make their living influencing policy to not register and still comply with the law.
"It's as porous as a sieve," said Norm Eisen, the former White House "ethics czar" who helped author and enforce Obama's executive order on lobbyists. "It's written to capture the activity from the days of two-martini lobbying lunches. And we're so far beyond that now. It has to be updated."
The influence industry has since grown larger and more sophisticated, with lobby firms increasingly adding public affairs, consulting and public relations divisions — and the law has not been changed along with the industry.
"You have to mow the lawn more than once every ten years," Eisen said. "I'm not criticizing any individual lobbyist, I'm criticizing a system that's broken."
It is difficult to come up with an exact number of "unregistered" lobbyists. But many people who advise on lobbying strategy as part of their job — including some former prominent lawmakers who now work at lobby firms, or who lead trade groups that lobby Congress — are not required to register because they fall below the 20 percent threshold, creating the perception there are fewer lobbyists than there really are.
Some legislators who join lobby firms after leaving office want to avoid the lobbyist label in case they want to run for political office, or accept a political appointment, in the future.
Daschle said advising clients does not always constitute lobbying.
"I strongly believe that lobbying involves having contact with members of Congress," he said. "There's a big difference between advising clients…versus engaging in the day-to-day relationship development with members of Congress. Not everyone agrees with that distinction but I think it's an important one."
Many former lawmakers who joined lobby firms after leaving office have not registered. Under ethics rules, ex-senators must wait two years before they can lobby lawmakers; former House members must to wait one year.
Pryor chairs the government affairs group at legal powerhouse Venable, which last year employed about 30 lobbyists who pulled in nearly $10 million in lobbying revenue. His job title is partner.
Begich, the former Democratic senator from Alaska, is a strategic adviser at Brownstein Hyatt, the nation's second-largest lobby firm. The firm lists him as an "independent contractor" in the government affairs division.
Neither Begich nor Pryor, who both joined K Street after leaving Congress in 2015, is a registered lobbyist, though the firms they work at are major players in the influence industry. Begich, Pryor and spokespeople for their firms either did not respond to requests for comment or declined to comment.
Former Minnesota Gov. Tim Pawlenty (R) is chief executive of Financial Services Roundtable, the trade group that lobbies on behalf of banks and investment firms. Pawlenty also is not a registered lobbyist.
"His time spent on activities defined as lobbying does not meet the threshold for registration and an attorney regularly monitors, reviews and confirms that determination," a spokeswoman for the group said.
Dodd has been the CEO since 2011 of the Motion Picture Association of America, a major figure in town as the MPAA lobbies on behalf of major studios. The MPAA declined to comment.


text:
Search Blog
Listen to the Ali on the Run Show!
Follow @AliOnTheRun1
- We knew this was the very likely outcome, but man. Sucks to see it. (Reminder that it's OK to know this is the abso… https://t.co/DQMnzEBC3x about 12 hours ago ReplyRetweetFavorite
Recent Posts
- May 27, 2020 by AliAli on the Run Show Episode 242: Shalane Flanagan
- May 25, 2020 by AliAli on the Run Show Episode 241: On the Job with JoMarie Flores, Funeral Director
- May 21, 2020 by AliAli on the Run Show Episode 240: Lee Glandorf, Tracksmith Head of Communications
- May 20, 2020 by AliAli on the Run Show Episode 239: Dinée Dorame, Citizen of the Navajo Nation
- May 13, 2020 by AliAli on the Run Show Episode 238: Sasha Wolff, Founder of Still I Run
Tag Archives: Friday Night Lights
1 post(s) found
All The Things I'm Loving Right Now
Date: February 18, 2016 at 3:26 pm- by Ali- Comment(s): 11
Consider this a twist on Thankful Things Thursday. This week has been the excitingly busy kind of nuts. But amidst the madness, there are some things I'm really into right now. Let's discuss… Running! Running continues to go watchless and well. Nothing […]
Posted in Ellie!, Gym Classes, Happy Things, NYC, Running, Work, Workouts and tagged AKT in Motion, Alo, Anna Kaiser, Bandier, Ellie, Flex Pilates, Friday Night Lights, Hamilton, November Project, Running, Tone House-


text:
Service Times
Sunday 10:00AM | 6:00PM
Wednesday 7:00 PM
Sunday 10:00AM | 6:00PM
Wednesday 7:00 PM
338 Matthews Avenue
Sikeston, Missouri 63801
Directions: maps.google.com/maps
From Hwy 60 go North on Hwy 61 (Main Street) to Matthews Ave on Left.
From I-55, go West on Malone Ave, then South on Hwy 61 (Main Street). Go 2 blocks south on Main to Matthews on right.
Church is located 2 blocks West of South Main Street.


text:
My company has a few accounts for TF and a bunch of apps. There's few testers downloading app from TF and one of them ending testing on his device by pressing red button.
And issue is I'd like to find some info about latest actions in appstore connect as administrator. Does someone know, if appstore provides similar functions? Thank in advance, Julia.
Retrieving data ...


text:
Big Sandy Community and Technical College
Big Sandy Community and Technical College is an Associate's college with 4715 students located in Prestonsburg, KY.
Big Sandy Community and Technical College is an Associate's college with 4715 students located in Prestonsburg, KY.
|Total Undergraduates
|53% Male / 47% Female
|Enrollment Breakdown
|52% Full Time / 48% Part Time
|99% In State / 1% Out of State / 0% International
|Socio-Economic Diversity
|80% of students received Pell Grants, which are provided by the U.S. government to students from middle and lower income families. It gives you an idea of a school's socio-economic diversity.
|Ethnic Diversity
Liberal Arts and Sciences/Liberal Studies (53%), Multi-/Interdisciplinary Studies, Other (10%), Medical Administrative/Executive Assistant and Medical Secretary (7%), Social Work (4%), Respiratory Care Therapy/Therapist (4%), Criminal Justice/Law Enforcement Administration (4%)
A program that prepares individuals to apply artistic and computer techniques to the interpretation of technical and commercial concepts. Includes instruction in computer-assisted art and design, printmaking, concepts sketching, technical drawing, color theory, imaging, studio technique, still and life modeling, multimedia applications, communication skills and commercial art business operations.
Job Opportunities:
A program that is a structured combination of the arts, biological and physical sciences, social sciences, and humanities, emphasizing breadth of study. Includes instruction in independently designed, individualized, or regular programs.
Job Opportunities:
A program that generally prepares individuals to plan, organize, direct, and control the functions and processes of a firm or organization. Includes instruction in management theory, human resources management and behavior, accounting and other quantitative methods, purchasing and logistics, organization and production, marketing, and business decision-making.
Job Opportunities:
A program that prepares individuals to clean teeth and apply preventive materials, provide oral health education and treatment counseling to patients, identify oral pathologies and injuries, and manage dental hygiene practices. Includes instruction in dental anatomy, microbiology, and pathology; dental hygiene theory and techniques; cleaning equipment operation and maintenance; dental materials; radiology; patient education and counseling; office management; supervised clinical training; and professional standards.
Job Opportunities:
A program that prepares individuals to perform the duties of special assistants and personal secretaries for practicing physicians and nurses, health care facilities and services administrators, and other health care professionals. Includes instruction in business and medical communications, medical terminology, principles of health care operations, public relations and interpersonal communications, software applications, record-keeping and filing systems, scheduling and meeting planning, applicable policy and regulations, and professional standards and ethics.
Job Opportunities:
A program that generally prepares individuals in the knowledge, techniques and procedures for promoting health, providing care for sick, disabled, infirmed, or other individuals or groups. Includes instruction in the administration of medication and treatments, assisting a physician during treatments and examinations, Referring patients to physicians and other health care specialists, and planning education for health maintenance.
Job Opportunities:
A program that prepares individuals, under the supervision of physicians, to assist in developing respiratory care plans, administer respiratory care procedures, supervise personnel and equipment operation, maintain records, and consult with other health care team members. Includes instruction in the applied basic biomedical sciences; anatomy, physiology, and pathology of the respiratory system; clinical medicine; therapeutic procedures; clinical expressions; data collection and record-keeping; patient communication; equipment operation and maintenance; personnel supervision; and procedures for special population groups.
Job Opportunities:
Any instructional program in multi/interdisciplinary studies not listed above.
A program that prepares individuals to apply basic engineering principles and technical skills in support of civil engineers engaged in designing and executing public works projects such as highways, dams, bridges, tunnels and other facilities. Includes instruction in site analysis, structural testing procedures, field and laboratory testing procedures, plan and specification preparation, test equipment operation and maintenance, and report preparation.
Job Opportunities:
A general program that focuses on computing, computer science, and information science and systems. Such programs are undifferentiated as to title and content and are not to be confused with specific programs in computer science, information science, or related support services.
Job Opportunities:
A program that prepares individuals to generally apply technical skills to create working drawings and computer simulations for a variety of applications. Includes instruction in specification interpretation, dimensioning techniques, drafting calculations, material estimation, technical communications, computer applications, and interpersonal communications.
Job Opportunities:
A program that prepares individuals to apply mathematical and scientific principles to the delineation, determination, planning and positioning of land tracts, land and water boundaries, land contours and features; and the preparation of related maps, charts and reports. Includes instruction in applied geodesy, computer graphics, photointerpretation, plane and geodetic surveying, mensuration, traversing, survey equipment operation and maintenance, instrument calibration, and basic cartography.
Job Opportunities:
A program that prepares individuals to apply technical knowledge and skills to repair, install, service and maintain the operating condition of heating, air conditioning, and refrigeration systems. Includes instruction in diagnostic techniques, the use of testing equipment and the principles of mechanics, electricity, and electronics as they relate to the repair of heating, air conditioning and refrigeration systems.
Job Opportunities:
A program that prepares individuals to apply technical knowledge and skills to join or cut metal surfaces. Includes instruction in arc welding, resistance welding, brazing and soldering, cutting, high-energy beam welding and cutting, solid state welding, ferrous and non-ferrous materials, oxidation-reduction reactions, welding metallurgy, welding processes and heat treating, structural design, safety, and applicable codes and standards.
Job Opportunities:
|Dr. George D. Edwards
|Accredited by
|Southern Association of Colleges and Schools, Commission on Colleges
|Full-time Faculty
|Student : Faculty Ratio
|17 : 1
|Faculty Gender (% Male : Female)
|46 : 53
|Percentage of Faculty Members
|Tenured Faculty
|Tenure Track Faculty
|Non-Tenure Track Faculty
|No Status Faculty
|International Faculty
The average student pays $5,893 for tuition, fees, and other expenses, after grants and scholarships.
|Household Income
|Real Cost
Total stated tuition is $3,456, in-state and on-campus, before financial aid.
|Stated Tuition
|Same as On-Campus
|Total (before financial aid)
|Stated Tuition
|Same as On-Campus
|Total (before financial aid)
95% of students receive some form of financial aid.
|Undergrads Receiving Aid
|Average Aid Amount
|Federal Loans
|Federal Scholarships/Grants
|Institutional Grants
|Other Federal Grants
|Pell Grants
|State and Local Scholarships/Grants
|Student Loans
Learn more about financial aid at http://www.bigsandy.kctcs.edu/costs_and_financial_aid/forms_and_documents.aspx.
Estimate the net price for you at http://kctcs.edu/en/students/costs_and_financial_aid.aspx.
2% of students graduated on time.
16% of students graduated in six years.
56% of full time students continued studying at this school after freshman year.
Want more info about Big Sandy Community and Technical College? Get free advice from education experts and Noodle community members.
U.S. News & World Report ranks annual reports on schools, hospitals and products.
The Princeton Review is a test preparation and college admission services company offering test preparation services, tutoring and admissions resources, online courses, and books published by Random House.


text:
They're delicious served on their own with a little sugar and cream, baked into pies and cobblers, or turned into jams, jellies and sauces. Pick up a pint or two at a farmer's market and add them to your favorite summer meals.
Cherry Blackberry-Chocolate Smoothie
SURE.JELL for Less or No Sugar Needed Recipes - Blackberry Freezer Jam
Fresh Berry Dutch Berry Pancake


text:
Auto Glass Repaired or Replaced In Your Driveway!
Local Installers In Ecorse, Michigan Available
For both repair and replacement, trust First Choice Auto Glass Center for your auto glass needs. In MI, a cracked windshield is more than a nuisance, it's a safety issue. Ecorse, MI has some of the more reliable auto glass firms in the business. Among expert glass firms in Ecorse is Simbol Auto Glass Wyandotte. Our firms are eager to give you a repair quote.
Auto Glass Services Offered
- Windshield Repair
- Windshield Replacement
- Rear Windshield Replacement
- Car Window Replacement
Ecorse Loves our Qualified Glass Professionals!
Ford F Series F150 Windshield Replacement
5 5 1
9 months ago
I got everything I was told I would. I recieved a call before installer arrived. My installer was kind and very professional. He said when he would be done and was done under an hour. He cleaned up and I was very satisfied with the job.
Susan T• Northville, MI • 2010 Ford F Series F150
Honda Civic Windshield Replacement
5 5 1
2 years ago
Met more than my expectations. Everything was so easy and efficient. Would definitely recommend to everyone I know.
Ashutosh B• Allen Park, MI • 2016 Honda Civic


text:
About Statina Healthcare Australia
Statina Healthcare Australia is a wholly Australian owned and managed company based in Hornsby NSW. We have been supplying the healthcare industry with innovative and quality products since 1998. Our company has been instrumental in the implementation of Hovermatts into operating theatres around Australia for over twelve years. The HoverMatt Lateral Transfer system was designed to reduce back injuries from the repetitive strain of moving patients to and from the operating table and then to recovery and the wards. In addition to lateral transfers HoverMatts are widely used for patient repositioning in bed which can be another major cause of staff injuries. The HoverTech range now includes not only reusable HoverMatts but Single Patient Use HoverMatts that are available in a range of widths including 34", 39" & 50". Another two innovative products that have just been launched are the HT Roller & the HoverSling. Both of these devices are designed to assist with safe patient handling.
In addition to our range of Manual Handling & OH&S equipment Statina provides healthcare products to consumers via our online store at www.statina.com.au. Consumers are able to source Safehip Hip Protectors, Pressure Care Products, Post-surgical garments as well as our brand new range of Push Orthopedic braces.
Statina Healthcare has received our ISO 9001:2015 accreditation as part of our commitment to provide outstanding customer service to our clients. We are also in the final stages of providing product data to be uploaded to the National Product Catalogue (NPC). This will make it easier for all hospital departments to access information about our product range.
Our Quality Policy is available to view upon request.
Modern Slavery Code of Conduct


text:
The West has been at odds with the Far East for centuries. It began before the Opium Wars, laws and treaties were made and broken, but the issues remain the same old same old. Chinese stare down their noses at the rest of the world, regardless of the imbalance it causes for their end of … Continue reading
At the basement floor of the Chinese National museum in Beijing, there's a curated collection of China's imperial history from antiquity to the fall of the Qing Dynasty. The basement is where a multitude of visitors from around the country gather, entry is free for foreigners. At the end of the collection, is a British … Continue reading
I refer to Mr. Ocampo's article "Salazar's 1590 report on the Manila Chinese", PDI, which appeared on Feb 6th. I concur in a sense to the positive contribution of the early Chinese to our people and history. Indeed, contact between two people and two civilizations does not only result to clashes and conflict, there also … Continue reading
Taiwan warned officials and veterans Friday not to attend a military parade organised by China to mark Japan's defeat in the Second World War, as the former bitter rivals vie over the history of the conflict. Beijing claims Communist troops sealed victory against the Japanese in 1945 while Taiwan argues the nationalist Kuomintang (KMT) army … Continue reading
Zhao Kuangying (927-976), the founding emperor of the Song Dynasty (960-1279) , ordered all the succeeding emperors to promise by oath to respect intellectuals. As a result, Song emperors themselves received good education and were fond of intellectuals. However, they went too far and put academic and artistic achievements above moral integrity. There are the … Continue reading
If you ask a Chinese person about the length of Chinese history, it is easy for them to tell you we have 5,000 years history. But I suspect this easy answer is because so many historical materials were lost in the past 2,200 years since "Burning and Burying" (焚书坑儒, Fen Shu Keng Ru) in Qin … Continue reading
The following are the views of a Chinese netizen: Do the Chinese love China? For this question, the answer is easy – no! Perhaps you are shocked by seeing my answer because you may think the Chinese are really united and they often refute the criticism from other countries, especially western countries. But I am … Continue reading
As China becomes, again, the world's largest economy, it wants the respect it enjoyed in centuries past, but it does not know how to achieve or deserve it. Matthew Boulton, James Watt's partner in the development of the steam engine and one of the 18th century's greatest industrialists, was in no doubt about the importance … Continue reading
The following stories are first-hand recollections of life in China during the years immediately after the Communists took power (1949-1951). They are written by Chan Kai Yee, author of Tiananmen's Tremendous Achievements (see link in right sidebar). We would recommend this book for those interested in more first-hand perspectives of life in China, particularly the … Continue reading
The following stories are first-hand recollections of life in China during the years immediately after the Communists took power (1949-1951). They are written by Chan Kai Yee, author of Tiananmen's Tremendous Achievements (see link in right sidebar). We would recommend this book for those interested in more first-hand perspectives of life in China, particularly the … Continue reading
China Daily Mail contributor Chan Kai Yee has announced that 70% discounts on the Kindle version of his book are now in place until the end of June 2014. The discounts are now available in the countries listed below, using the links provided. For other countries not on this list, we recommend using the United … Continue reading
Paleontologists have made an exciting discovery near the city of Ganzhou, in southern China – the near complete fossil remains of a skull in a site that dates back to the Cretaceous period. The skull belongs to a dinosaur that has been scientifically designated Qianzhousaurus sinensis, a long-snouted species that belongs to the same species … Continue reading
Tokyo on Friday said it was puzzled over why Beijing approved national remembrance days to commemorate the Nanjing Massacre and its defeat in World War II, after decades of Japanese pacifism. The move is the latest in a vitriolic diplomatic spat between Asia's two largest economies, who are at loggerheads over disputed territory and differing … Continue reading
On 12 February 1912, the Xinhai Revolution, or the Hsin-hai Revolution, also known as the Revolution of 1911 or the Chinese Revolution, culminated with the overthrow of the Empress Dowager Longyu and the infant Emperor Puyi that marked the end of over 2,000 years of imperial rule and the beginning of China's so-called republican era. … Continue reading
Authorities in Hong Kong ordered 2,260 people to temporarily relocate as bomb disposal teams spent the better of portion of Friday removing a live World War II bomb from a construction site in the city. A police spokesperson told AFP that the one-ton bomb was the largest such ordnance found in Hong Kong. Technicians spent 15 hours … Continue reading
China is preparing to surpass the United States as the world's largest economy, in purchasing power parity terms (using China's grossly exaggerated economic figures). Already its economy is supposedly 80% the size of the US, and if current growth rate differentials persist, it could possibly take China only about four more years to surpass the … Continue reading
Almost all children around the world learn about Christopher Columbus, and how, as the popular poem starts, "In fourteen hundred ninety-two, Columbus sailed the ocean blue", and how Columbus reached the Americas in October of 1492. They also learn that he sailed with three ships: the Nina ("Girl"), the Pinta ("Pint"), and the Santa … Continue reading
"On this day in 1945, Japan announced unconditional surrender." The official account of China Central Television posted this information on Weibo, one of China's largest social media platforms, and it quickly spread. Three trending posts, with a combined 236,000 retweets, identified the day's significance and emphasized the number of Chinese who had been wounded and killed during … Continue reading
China summoned Japan's ambassador on Thursday to lodge a strong complaint after two Japanese cabinet ministers publicly paid their respects at a controversial Tokyo shrine for war dead, the Chinese Foreign Ministry said. The ministers' visit to the Yasukuni Shrine "seriously harms the feelings of the people in China and other Asian victim countries", the … Continue reading
On July 21st 1553, 120 Buddhist temple monks met an approximately equal number of "Japanese pirates" in battle. The so-called Japanese pirates, wakou or woku, were actually a confederation of Japanese, Chinese, and even some Portuguese citizens who banded together. (The pejorative term wakou literally means "dwarf pirates.") They raided China during the Ming Dynasty … Continue reading
The two introductory paragraphs from an article I posted last April, titled Is the 1950 Korea Mess Relevant to the New Korean Mess are provided below: The North Korean invasion of South Korea began on June 25, 1950 when North Korean troops — many of them battle-hardened veterans of Mao's fights against Chiang Kai-shek's Nationalists — crossed the … Continue reading
On June 24 1989, a Saturday, Zhao Ziyang was formally ousted as General Secretary of the Chinese Communist Party weeks after voicing sympathy for student demonstrators at Tiananmen Square. Jiang Zemin replaced him, and Zhao spent the rest of his life under house arrest. His removal from power was "effectively a coup," according to American … Continue reading
Chinese culture would have us believe that many of its heroes and heroines were either mightily good or extremely evil. The truth is somewhere between. Confucius, the old master, is quite clear about how to tell good people from the bad. Gratitude, honesty, trustworthiness and loyalty are among the Eight Principles of People, the good … Continue reading
Originally posted on Craig Hill Training Services:
On December 19th 1984, in the Hall of the People in Beijing, British Prime Minister Margaret Thatcher and Chinese Premier Zhao Ziyang signed an accord committing Britain to give Hong Kong back to China in 1997. In return, China incorporated terms pledging a 50 year continuation of Britain's…
"In Urumqi, China, an exhibit on the first floor of the museum gives the government's unambiguous take on the history of the border region: 'Xinjiang has been an inalienable part of the territory of China,' says one prominent sign. "But walk upstairs to the second floor, and the ancient corpses on display seem to tell … Continue reading
The Hong Kong Autonomous Movement claims that the displays of the Hong Kong British flag are not a call for a return to colonialism. Instead, they claim it is, "the defence of the lion and dragon and the blending of the East and West." Opponents of the movement argue that the flag belongs in a … Continue reading
Originally posted on Craig Hill Training Services:
Simulated picture of the Old Summer Palace before it burned down On October 18th 1860, British troops occupying Peking, China, looted and then burnt the Yuanmingyuan, the fabulous summer residence built by the Manchu emperors in the 18th century. China's Qing leadership surrendered to the Franco-British expeditionary force…
Originally posted on Craig Hill Training Services:
On October 16th 1934, the embattled Chinese Communists broke through Nationalist enemy lines and began an epic flight from their encircled headquarters in southwest China. Known as Ch'ang Cheng, the "Long March", the retreat lasted 368 days and covered 6,000 miles, nearly twice the distance from New York…
Originally posted on Craig Hill Training Services:
On October 5th 1989, the Dalai Lama, the exiled religious and political leader of Tibet, was awarded the Nobel Peace Prize in recognition of his nonviolent campaign to end the Chinese domination of Tibet. The 14th Dalai Lama was born as Tenzin Gyatso in Tsinghai Province, China, in…
Originally posted on Craig Hill Training Services:
Mao Zedong proclaims People's Republic of China On October 1st 1949, naming himself head of state, communist revolutionary Mao Zedong officially proclaimed the existence of the People's Republic of China; Zhou Enlai was named premier. The proclamation was the climax of years of battle between Mao's communist forces…
Originally posted on Craig Hill Training Services:
On September 21st 1949, at the opening of the Chinese People's Political Consultative Conference in Peking, Mao Zedong announced that the new Chinese government would be "under the leadership of the Communist Party of China." The September 1949 conference in Peking was both a celebration of the communist…
Originally posted on Craig Hill Training Services:
On September 9th 1976, Chinese revolutionary and statesman Mao Zedong, who had been suffering from Parkinson's disease and other health problems, died in Beijing at the age of 82. The Communist leader and founder of the People's Republic of China is considered one of the most influential figures…
Originally posted on Craig Hill Training Services:
On August 19th 1931, the Yangtze River in China was causing chaos, having peaked the previous day, during a horrible flood that killed 3.7 million people directly and indirectly over the next several months. This was perhaps the worst natural disaster of the 20th century. The Yangtze River…
Originally posted on Craig Hill Training Services:
Genghis Khan Genghis Khan, the Mongol leader who forged an empire stretching from the east coast of China west to the Aral Sea, died in camp during a campaign against the Chinese kingdom of Xi Xia. The great Khan, who was over 60 and in failing health, may…
Originally posted on Craig Hill Training Services:
On July 28th 1976, at 3:42 a.m., an earthquake measuring between 7.8 and 8.2 magnitude on the Richter scale flattened Tangshan, a Chinese industrial city with a population of about one million people. As almost everyone was asleep in their beds, instead of outside in the relative safety…
Originally posted on Craig Hill Training Services:
On June 14th 1963, according to a public statement made by the Chinese government, a much more militant and aggressive policy was needed in order to spread the communist revolution worldwide. There could be no "peaceful coexistence" with the forces of capitalism, and the statement chided the Russians…
Originally posted on Craig Hill Training Services:
Tung Chee Hwa and Jiang Zemin at the 1997 handover On July 1st 1997, at midnight, Hong Kong reverted back to Chinese rule in a ceremony attended by British Prime Minister Tony Blair, Prince Charles of Wales, Chinese President Jiang Zemin, and U.S. Secretary of State Madeleine Albright.…
On April 6th 1974, in Brighton, England, at the 19th Eurovision Song Contest, the tiny nation of Luxembourg was devastated when it failed to secure a third consecutive win at the pan-European musical event. The judges did the rest of the world a favour, however, by selecting the Swedish entry as the winner instead. The … Continue reading
On April 5th 1955, Sir Winston Leonard Spencer Churchill retired as prime minister of Great Britain. The British leader, who guided Great Britain and the Allies through the crisis of World War II, is widely regarded as one of the greatest war time leaders of the 20th century. Remembered as a statesman and orator, Churchill … Continue reading
On April 4th 1968, just after 6 pm, Martin Luther King Jr was standing on the balcony outside his second-story room at the Lorraine Motel in Memphis, Tennessee, when he was fatally shot. The civil rights leader was in Memphis to support a sanitation workers' strike and was on his way to dinner. A bullet struck him … Continue reading
On April 3rd 1942, the Japanese infantry staged a major offensive against Allied troops in Bataan, the peninsula guarding Manila Bay of the Philippine Islands. The invasion of the Japanese 14th Army, which began in December 1941 and was led by General Masaharu Homma, had already forced General Douglas MacArthur's troops from Manila, the Philippine … Continue reading
On April 2nd 2005, Pope John Paul II, leader of the Catholic Church, and history's second longest ruling Pope, died at the age of 84. John Paul II was the most widely travelled Pope, and the first non-Italian to hold the position since 1523. Acclaimed as one of the most influential leaders of the 20th … Continue reading
On April 1st 1984, the day before his 45th birthday, soul singer Marvin Gaye's life came to a tragic end, when he was shot and killed by his own father after a violent physical fight. At the peak of his career, Marvin Gaye was the Prince of Motown; the soulful voice behind hits as wide-ranging … Continue reading
On March 31st 1959, the Dalai Lama fled the Chinese suppression of a national uprising in Tibet, and crossed the border into India, where he was granted political asylum. Born as Tensin Gyatso on 6th July 1935 in Taktser, China, he was designated the 14th Dalai Lama in 1940, a position that eventually made him … Continue reading
On March 30th 1981, President Ronald Reagan was shot in the chest outside a Washington, D.C., hotel by a deranged drifter named John Hinckley Jr. The president had just finished addressing a labour meeting at the Washington Hilton Hotel and was walking with his entourage to his limousine when Hinckley, standing among a group of … Continue reading
On March 29, 2009, US President Obama and his administration requested and received the resignation of Rick Wagoner, the chairman and chief executive of troubled auto giant General Motors (GM). Wagoner spent more than 8 years in the top job at GM, during which the company lost billions of dollars. In 2008, GM was surpassed … Continue reading
On March 28th 1939, the Spanish Civil War came to an end after three years of bloody fighting, when the Republican defenders of Madrid raised the white flag over the city. In 1931, Spanish King Alfonso XIII approved elections to decide the government of Spain, and voters overwhelmingly chose to abolish the monarchy in favour … Continue reading
On March 27th 1977, on the runway at a Canary Islands airport, two 747 jumbo jets crashed into each other, killing 583 passengers and crew members. The crash still stands as the worst in aviation history. The airport was the Los Rodeos Airport on Santa Cruz de Tenerife. The Boeing 747s were both charter jets … Continue reading
On March 26th 1953, American medical researcher Dr Jonas Salk made public that a vaccine he had developed for poliomyelitis had been successfully tested. The crippling disease had reached epidem9ic proportions in 1952, with 58,000 new cases reported in the Unites States, of which over 3,000 had died. The disease is also called "infant paralysis" … Continue reading
On March 25th 1932, the Supreme Court handed down its decision in the case of Powell v. Alabama. The case arose out of the infamous Scottsboro case. Nine young black men were arrested and accused of raping two white women on train in Alabama. The boys were fortunate to barely escaped a lynch mob sent … Continue reading


text:
We don't want to be the biggest, but we want to be the best.
Don't put off the decision to buy a life insurance policy when we're around to help. The risks you take every day might turn into a major disaster for you and your family. That's when a life insurance policy comes into play!
Crosby-Nelson Inc will create a custom life insurance policy for you. We'll deal with top providers to come up with a scheme that gives you different levels of coverage at a cost that's advantageous to you. You won't regret making us your insurance agents!
Commercial and more
If you live in Ridgeland and need a life insurance policy, call us at


text:
I did this yesterday. So, gonna continue on the 30days blog challenge. Gonna redo the yesterday-supposed-to post now.
Day 8 = Your Dream Wedding
Ah ha! I bet everyone are like so keen to know whats my take on this. For some people, they have dream about their wedding days since they were small, having fantasies right from a very young age ( I guess influenced by the Disney fairytales ) to have their dream wedding.
I want to wear this kind of dress. I want to get married at this particular place. I want this type of ring. and the list goes on....
Sadly, I don't have that dream wedding thingy. Am I not normal?
I guess I can figure things out about my dream wedding when I finally feels like getting married kan.
Still I am wondering am I not normal not to have the dream wedding?


text: frost 0 Report post Posted February 20, 2013 Cannot install Content Box extension. Pagelines Sections is activated. Debug mode activated. I get this error: Destination folder already exists .../apps/wordpress/htdocs/wp-content/plugins/contentbox/ Danny at live support chat discovered there is a permissions issue in the directory, and thought it might have to do with the server setup. I used Bitnami could apps on AWS wordpress image. Then purchased the Pagelines theme. What is the easiest fix? Thanks. Share this post Link to post Share on other sites


text:
Effective human resource management is one of the most critical factors leading to the success of an organization and to the economic growth of PEI. Our people are our greatest resource.
In September 2017, the Chartered Professionals in Human Resources Association of Prince Edward Island (CPHR PEI), a newly formed not-for-profit corporation, was officially launched.
The Association is the exclusive granting body on PEI of the nationally recognized Chartered Professional in Human Resources (CPHR) designation, which is the leading standard for HR professionals in Canada.
Individuals carrying this designation are on par with other leading professional groups including accountants, engineers, and lawyers. The CPHR Competency Framework outlines 44 professional competencies organized in nine functional areas of knowledge that individuals must know to earn their designation.
Continuing professional development is a requirement for all professionals, further demonstrating the commitment toward staying current with leading practices and the ethical management of today's human capital.
Our members make a significant impact across all sectors on PEI. Members include CEOs, VPs, Directors of HR, HR Generalists, HR Advisors, Consultants, educators, students, and small-business owners.
At this time, our Board is focused on building the membership, providing professional development opportunities, engaging with those working in the field of human resources, and building the human resources community here on PEI.
Membership with CPHR PEI is open to all individuals who work, or have an interest, in the field of human resource management.
For further details, email [email protected].ca. Visit www.cphrpei.ca.
November Issue
Page 11
submitted by Detry Carragher, Chair of CPHR PEI


text:
Rachael Leigh Cook
Jump to navigation Jump to search
Rachael Leigh Cook (born October 4, 1979)[1] is an American actress, model and voice artist. She played Becky Thatcher in Tom and Huck (1995). She played Laney Boggs in She's All That (1999). She played Laura King in the movie Vampire (2011).
She was born in Minneapolis, Minnesota.
References[change | change source]
- ↑ "Rachael Leigh Cook Biography". TV Guide. Retrieved May 10, 2014.


text:
Kong Gyro Large
The KONG Gyro is sure to entertain with irresistible roll and flip action keeping dogs enticed and intrigued. With the center spinning orb and static outer ring, this dynamic toy encourages dogs to push, paw and roll the GYRO, delightfully dispensing tasty treat rewards along the way. Ideal for independent play, stuff with snacks or kibble for added fun and extended playtime. Available in large and small sizes.
Entertaining roll and flip action
Dispenses food and treats
Ideal for independent play
Spin me
Mentally stimulating treat dispenser
Twist top on lightly
With our Delivery Partners GLS, we are delighted to be able to offer delivery throughout Europe. Delivery Times to Countries to Vary.
- Ireland and Northern Ireland : 1 - 2 Days
- England, Scotland and Wales: 2 - 4 Days
- France, Germany, Luxembourg, Netherlands & Belgium: 3-5 Days
- Austria, Denmark and Switzerland: 4-6 Days
- Czech Republic, Hungary, Italy, Poland, Sweden, Slovenia, Slovakia, Finland, Norway, Spain, Portugal : 5-7 Days
We offer very Competitive Shipping Prices as well!
Ireland and Northern Ireland
- Spend Up to €29.99: €6.00 €30 and over: Free
England Scotland & Wales
- Spend Up to €59.99: €6.00 €60 and over Free
France, Germany, Luxembourg, Netherlands & Belgium
- Spend up to €19.99: €10.00 Spend €20-€59.99: €7.00 Spend €60.00 - €99.99 €5.00 €100 and over Free
Austria & Denmark:
- Spend upto €19.99: €11.00 Spend €20-€59.99: €8.00 Spend €60.00 - €99.99 €6.00 €100 and over Free
Switzerland & Norway
- Spend upto €19.99: €11.00 Spend €20-€59.99: €8.00 Spend €60.00 - €99.99 €6.00 €100 and over Free
For Switzerland and Norway there is also a Customs Charge of €25.00 per order
Czech Republic, Hungary, Italy, Poland, Sweden, Slovenia, Slovakia, Finland, Spain, Portugal
- Spend upto €19.99: €14.00 Spend €20-€59.99: €11.00 Spend €60.00 - €99.99 €9.00 €100 and over €6.00
Other Countries are available, please email us if you require and further information
For easy hassle free returns, we have a 14 day returns policy on any items ordered through our website and returned to us in their original condition.
To return a product, please contact us first on 01 6904422 or firstname.lastname@example.com
You can return Items ordered online to the store, please bring your online receipt with you.
Should you wish to exchange your items for an equivalent item, eg clothing in a different size, we will exchange this for you on receipt of the original item.
Normal shipping rates apply to the replacement item.
Where the replacement item is a different price we will either refund the difference or contact you to arrange for a top up payment.
Replacement is subject to availability
Where you wish to return an item for a full refund then we will refund you the amount paid within 7 days of receipt of goods.
Where you wish to return a faulty item the procedure is the same as a refund or exchange. We may also require you to send us a digital photograph of the item for initial assessment.
When an item is found to be faulty or needs to be returned, through an error on our behalf, we will refund the cost of posting it back to us or arrange for courier collection.
Refund, replacement or repair is subject to assessment of fault. This does not affect your statutory rights.


text:
Zoizite Var. Tanzanite (ex Nelson Coll.)
Add to OrderNot checked
A very gemmy zoizite crystal (this one has been treated like all tanzanites are) with a wonderful termination, excellent luster and the trichroic color change. There is a microscopic ding on one side of the C face, otherwise it is a perfect and facetable TN!
Price: $365.00
Location: Merelani, Arusha, Tanzania
Dimensions: 1.7 x .7 x .6cm
Size: Thumbnail


text:
It's evening, and Kimmila is in the kitchens with her arms crossed, watching the people work. She is actually without her clipboard, but she has a piece of paper that she's using a countertop to write on.
Hadria skips in, big smile on her face. Not paying any attention to where she is going, she knocks someone carrying an arm load of dishes. Almost causing a disaster, she squeaks "Sorry, oops. Really!" Trying to help a poor woman, the look on the kitchen staffers face clearly says that Hadria should just back away quickly. Hadi then looks around, touching the walls tapping her hand on the counters. The young weaver turned candidate is acting more unusual today, opening up cupboards and pressing on the walls. Almost as if it might move, looking disappointed and pouting.
Aengus edges his way into the kitchens, trying to look as nonchalant as possible. That seems to be a difficult thing to pull off for his man, considering his very noticeable hair and stature, both which stand out quite a bit from the bustling cooks and assistants runing through the room. Even so, he begins to slide slowly along one of the bare walls, one of his hands gently tapping on its surface as he seems to be searching for something. While he's trying to be very discreet about it, he just ends up looking extremely out of place, especially when he bends forward to peer underneath one of the nearby countertops and behind a stack of packaging crates full of fresh produce for cooking. Oddly enough he nearly runs into Hadria, who seems to bee doing the same thing as he is, however he manages to skid to halt before careening right into the other candidate. Only then does he actually notice Kimmila, who he gives a winning grin, "Kimmila. Giving your clipboard a break?"
Kimmila turns to observe Hadria and Aengus with a detached look before offering them both a thin smile, "Evening. How are you both? I lost it, Aengus. I put it somewhere and someone or something moved it, and now I can't find it." She sighs and then leans over to listen to one of the cooks before making a final note on the paper, folding it and tucking it into her pocket. "How are you both?"
Hadria looks up at Kimmila, answering quickly with way to much perk. "I'm just fine, and you ma'am?" Moving around and looking over to aengus, in a very bad attempt to whisper she says "Found anything?" The poor kitchen staff, Hadria is not really minding who's way she is in. Going so far as to ask one of the cooks, "Could you, maybe scoot a little? Just for a moment." The cook complies, simply staring at Hadi. As she is almost run into she ducks to go examine another wall, going to far is to stare at the ceiling.
Aengus leans forward conspiratorily towards Kimmila, lowering his voice to a rough whisper in his deep voice, "There's apparently a secret room of wonderfulness somewhere in these Kitchens. Not that there's much indication as to where it might be. But imagine what must be inside it." He widens his eyes to make his point and holds his arms out to explain, "Heaps of food, treasure … or maybe a stack of new clipboards for you?" And to add to that, he waggles his thick bushy eyebrows in Kimmila's direction and gives her a bright grin. "You sure someone moved it? You didn't just misplace it yourself?" Of course he tries to look innocent of moving the clipboard, considering the woman's attachment to the thing. He shuffles a bit closer to the wall nearby and gives it an experimental tap, glancing over his shoulder at Hadria, "Nothing yet. All these blasted cooks are in the way, of course. One of them is probably standing on it." Anh that thought, he begins to tap the floor stone with his feet with relish. "Got Searched today, actually. Surprise to me. The dragons never seemed interested in me before. Maybe it's my natural good looks, eh, Kimmila?" He indicates his Candidate knot, still brand new against his fairly worn shirt.
Kimmila blinks at the two of them before she looks around at the kitchens, her brows narrowed. "A secret room? Huh." Then she turns to gape at Aengus, her face flashing through a mix of emotions. First surprise, then guilt, then pure jealousy. "Congratulations," she says in a choked voice, staring fixated at that knot. She shakes her head firmly. "Congratulations," she says again. "G-good luck with that. Who said there was a secret room?" Change of subject, anyone?
Hadria watches Kimmila, "Thank you, I'm not that excited.. it's kind of scary." Sticking her head in a cabinet, "Maybe we should get a ladder, or you could put me on your shoulders?" Suggesting and skipping to near the cold storage, she opens the door and goes inside. If anyone ever wanted to get rid of Hadria, now would be the time. "Nothing in here, it's kind of cold." Well no duh. Coming out just in time to hear Aengus say something about his looks she says, "You look alright, for a boy." Obviously showing some of her preference.
From afar, Hadria snugs
A clipboard wedged up under the bronzer's arm as T'lin heads into the kitchen surely tells of the business that deals with vintner and wing. THe mention of the room, and the voice of Kimmi makes the rider turn his head towards the three. "What's this about a secret room?" His voice curious, but not too curious as it seems. He looks at the two candidates and chuckles a bit softly. "I see you two got snatched up. Congratulations to the both of you."
Aengus takes a few more steps to the middle of the kitchen, nearly colliding with a meandering cook as he stomps across the floor searching for hollow areas or secret compartments. All his work is to no avail, though, as all he seems to gather is the wrath of the cook he nearly ran into. Clearing his throat in some manner of apology, he sidesteps back towards Kimmila and Hadria, offering the former a reassuring grin, "Thanks. I'm not sure if I'll regret the choice or not. We'll see how the chores are. I s'pose the only drawback is no female relationships until the hatching is over, or perhaps longer." He makes somewhat of a face at that, scrunching his face up in displeasure. He must be fairly thick in the head, as he seems to fail to notice Kimmila's discomfort at the subject and merely continues to respond to Hadria, "That would be a man, not a boy. But I appreciate the comment. I am fairly handsome, I know." He strikes a fairly stoic pose, perhaps trying to show that fact off as he brushes a hand over his hair to be sure all the strands are in place. T'lin is given a small grin, breaking his pose for the moment, "Not too long ago, actually. I think the chores don't start til tomorrow, so I've been tryin' to find this secret room."
Kimmila stares at Hadria as well, "You too?" She shakes her head slowly, backing up against a wall so that she might get some support. Her hands are shoved into her pockets, "Congratulations," she mutters. She eyes the clipboard that T'lin carries, "Evening, sir," she greets quietly. She grins at Aengus, "Are all your girls going to be terribly disappointed?" she teases.
T'lin lets out a soft laugh as he looks over at Aengus and then over at Hadria. "What makes you think that there's a room in here? I mean, it's a kitchen." He glances over at Kimmi and nods back at her. "Evening, Kimmila. Doing well?" He grins warmly before he looks over at Aengus. "I do know that I might have to grab some of you guys to help out my wing. So, be ready to be snatched up in a hurry one of these days."
Hadria nods quickly, pushing her hair back and looking in a cooking pot, putting a finger in the boiling pot and taking it out quickly. Licking her finger she says, "Add something to that, it's just not ready." Turning around, leaning forward in an awkward curtsey as her skirt is to long to really allow such a movement. "Hello sir, I will be sure to be ready." Squeaking out in her high pitched voice and saying, "Umm, no reason sir. None at all." Shooting Aengus a look, her green eyes big and eyebrows raised. The posing suprises her, she shakes her head. "We should keep looking, not just stand around." Pushing both hands on the wall, trying her best to move it.
Aengus edges around the room further, shuffling and stomping on different parts of the room much to the dismay of many of the kitchen staff that he ignores profusely. As he walks, he comments on the side to T'lin, "I'll be at your beck and call tomorrow. I have one last day of freedom before chores take over, so I'm taking it to my advantage." As he passes Kimmila, he aims a bright grin at her, "Ah, don't look glum. I'm sure your clipboard will turn up. If you're curious, I swear I had nothing to do with moving it, no matter how muchI thought about doing it." He peers down atthe floor beneath his feet, murmuring on the side to Hadria, "It has to be around here somewhere. That note couldn't be there for a reason." As he clomps about with his boots, he suddenly steps on something hollow, causing him to stop short. Blinking once or twice in dumbfounded amazement, he jumps up and down on the spot, eliciting a satisfying hollow THUNK THUNK. "Hey! A trapdoor!" He kicks at the stone beneath his feet, trying his best to unearth the edges or the handle beneath whatever grime or dust might be covering it.
Kimmila frowns at Hadria, "Next time use a tasting spoon, alright?" the assistant headwoman advises in a flat tone of voice. "I'm sure the cooks know what they're doing." She turns to look at T'lin, surprised. "What do you need help with in your wing, sir?." She grins at Aengus, shaking her head, "I know it wasn't you. You would have asked for ransom already." She hastens over when Aengus finds something. "Wow. I never noticed that before."
T'lin quirks a brow at Hadria with a smirk. "No reason?" He shrugs a bit to himself before looking over at Aengus when he finds a trapdoor and he tilts his head in slight amusement, or is that confusion. Hard to tell. He looks over at Kimmila with a smile and says, "Filling sandbags and the like. Monsoon season is coming up in the future. Need to get a head start on things." He looks over at the trapdoor once more before he smiles just slightly.
Hadria watches as Aengus finds the door, quickly hopping over to him and saying "You found it, I mean.. something." Blushing guiltily and getting down on her hands and knees, "This is, interesting." Eyes scanning the door and she sighs, standing up and walking back over to the pot she was tasting earlier. This time she grabs a spoon, slurping up some of the soup and stirring the pot. Paying little attention she goes back to the door, whispering quickly as she passes Aengus "Good job, you found it!" Excited little squeak, though she looks to be hiding her excitement well.
Aengus straightens up from his work at the trapdoor, letting out his breath in a slight puff as he aims a wide toothy grin at Kimmila, "Well you have me pegged. If I do find it, I'll be sure to think of a suitable ransom for such a valuable object. I'm sure you'd be willing to find me some nice delicacies from the storage caverns for its safe return." The mention of filling sand bags doesn't do much to instill happiness or anticipation in the man's face. In fact, he wrinkles his nose in distaste but merely gives his shoulder a shrug, "Eh. Chores are chores. I suppose if I have to do em, I have to." He bends forward to brush at the dirty grime on the floor, unearthing a worn handle of some sort that provides purchase for his fingers. He digs both of his hands into the groove, steps off of the trapdoor and pulls with all his might. Despite much straining and bulging of muscles, he releases his hold with a grunt and gives the trapdoor an angry glare, "So much for finding it, eh, Hadria? It seems to be locked." He looks over his shoulder at T'lin, "You sure you don't know anything about this thing? You must have been here as a candidate before, eh?"
Kimmila nods at T'lin, "Alright, sir. I can make sure that enough shovels and bags are requisitioned to your wing." She's assuming she won't have to help with the actual task of filling sand bags. "We should ask the leadership about it. I'm sure they know it's here."
T'lin shakes his head with a smile, "Guys. You're going to be in here so many times throughout your candidacy. Why not try and figure things out a bit at a time?" He looks over at Aengus, "Yea, I was a candidate here. And as for the trapdoor. Don't know anything about it." He shrugs a bit before he looks over at Kimmi. "Thanks for that. I'm sure the candidates will have a good bit of fun with filling sand."
Hadria nods to Aengus, looking back at the door and grabbing a bowl. Filling the bowl with the soup she was previously tasting, she leaves. Saying to Kimmila, "Thank you."
Aengus kicks absently at the door once more before trodding on it again and jumping on it a few more times. THUNK THUNK THUNK. Seems like no amount of jumping and pulling will get the door to budge, which seems to frustrate the man quite a bit. After the excitement of finding the thing, there's the let down of not being able to open it. "Yeah, I s'pose. But most likely we'll be peeling tubers or gutting fish or whatever it is Candidates are forced to do in here. I suppose I could try levering it open with a tuber next time I come in." He quirks a lopsided grin at that, glancing back at T'lin and Kimmila. "Well. I need to get going. Got to talk to the other Hunters and make sure my spot is covered before I move fully into the dorms." He scratches idly at the stubble on his face before glancing once more at the trapdoor that he uncovered, "I'll get that open somehow. There has to be somethin' good in there. Perhaps some nasty creature that has been living there in the dark for turns upon turns." With a final wave to the others, he heads out of the kitchens and into the living cavers after Hadria, humming somewhat tunelessly to himself. It seems he can't sing very well either, alas.
Kimmila shrugs after the Candidates, staring at the trap door. "I know that if I had something to hide I wouldn't hide it in the middle of the kitchens," she says to the rider with a chuckle. "This place is hardly ever empty, how would you get your stuff out?"
T'lin looks over at Aengus and gives a wave to the candidate. Then he looks back at Kimmi with a smirk. "It's not really a place to hide stuff." He walks over towards the trap door, covering it back up with a knowing fashion. "It's a place to hide, really." He looks back up at her and smiles. "Don't worry about it."
Kimmila shakes her head with a laugh, "I'm not worried about it." She looks at the door and laughs again, "To hide? That's a terrible place to hide. How would you know when it's safe to come out again?"
T'lin chuckles a bit. "You can hear the ambient noises in here quite well from down in there. There's a small little hole that lets the sound come through easily." He looks down at where the door is covered and hms a bit. "Wonder how long it'll take 'em."
Kimmila laughs, "How do you know so much about it? Did you ever have to hide from someone? Do you have the key? Maybe we should put something down there for them to find. I /know/ they won't rest until it's open."
T'lin grins a bit. "Because it was me who clued them in to where it was. I found a page from my journal in my bags when I was cleaning through my weyr. I gave it to my firelizard, Rioja, and he dropped it off in the dorms."
Kimmila laughs, "You're sneaky. You do know that this means that they'll be less focused on chores, though, right?"
T'lin gives Kimmi a smile. "Come now, Kimmi. If I see them not doing their chores. I'm preetty sure I can grab the Candidate Coordinators and show 'em the room." He chuckles darkly. "And I wouldn't be afraid to do it."
Kimmila chuckles, "Sounds like you've got a plan then. I should get back to my duties, T'lin. Clear skies."
T'lin gives a wave to Kimmi with a smile. "A plan for a good bunch of things really. Have a good night, Kimmila."


text: Item #: L2HO03BIF8 Houla Island Hoodie £21.50 21.5 43 Write A Review Share: Share on Facebook Share on Twitter Share on Pinterest Share Black Colour: Black Size: View size chart View size chart Out of Stock Add to Bag Find In Store + Add to Wishlist Features Specs Materials & Care Bring tropical vibes to winter days. The Billabong Houla Island Pullover tops a boy?s hoodie with original graphics from Australian artist Marty Schneider printed at the chest and sleeves, and a woven label at the pouch pocket. The core fit boys hoodie is made from 280g brushed fleece.


text:
Authentic NBA wisdom … from 'The Greatest' player of All-Time' …
The Big Ticket speaks with Mr. Russell
"Since I've know him (KG) for several years, our relationship is really solid because I respect his basketball skills and community service. It's really important to note: He's not a basketball player. Like me, he's a man who plays basketball." – No. 6
Mandatory reading for all.
Tags: Bill Russell, Boston Celtics, Kevin Garnett


text:
Jesus, Eboue's starting, it was like an echo but it was actually everyone saying so after the teams were announced. Ade and Toure returned with Bendter and Djourou dropping to the bench.
As soon as the game kicked off it was clear we had moved up a gear from last week. The pace was fast and we have the Magpies pegged back in their own half for basically off of the first half
Inside the first few minutes we had a stonewall penalty shout turned down by the FA's man in green. Fabregas played The Pers through on goal with a lovely reverse pass, only for Coloccini to put in a last ditch tackle that saw him take sweet FA of the ball. To be fair considering our luck with referees we were lucky to even have the corner given in our favour. The corner was smacked off an unlucky Newcastle defender and went out for another. The second was of a better standard and I think the whacked Magpie crapped himself. The Pers floated the ball in which was flicked on by Bacary Sagna and Gallas should have buried it. He never.
Kolo Toure felt left out by Gallas and had a mazy run up field….well mazy for a defender. He thumped the ball so hard that Joey Barton was seen to flinch. Given pulled off a splendid save and diverted the ball wide for yet another corner. Nothing happened.
Robin Van Persie won us another bloody corner that we never done anything from. Anyhow Cesc took it and after a bit of proverbial ping pong in the box from the Newcastle defence the ball landed at Ade's feet. Ade's attempt to put in a cross was stopped by Paul Scholes, who today has made himself look like Charles N'Zogbia. Handball, penalty. The spot kick is to be taken by The Pers who looks like the epitome of coolness as he steps up to take it. So James Dean in an igloo with penguins drinking ice cool beer aka The Pers strolled up and stuck the ball past Shay Given who had guessed the right way. Unfortunately for Given and fortunately for us Van Persie had hit the perfect penalty and it flew past Given into the bottom left of his net. As the Pers scores it is another result for me as I take more of the bookies money home.
Adebayor is then tripped by Coloccini who is actually lucky to still be on the field after this. He intentionally tripped Ade as he was about to latch onto Van Persie's pass and received only a yellow card. It was great vision from Van Persie to spot Adebayor's lung bursting run into the box. It was Cesc's turn to take the free kick this time and it was smashed it off the wall. He wanted to break his duck but chose to whack a magpie instead.
Van Persie had been outstanding, his match sharpness was back and he looked like he wanted to make up for those terrible free kicks last week. He almost did when we won another free kick. The Pers wins it after he jinked around the Newcastle defence who had nothing else to do but bring him down. He hit a glorious free kick with his left foot which was matched by the right paw of Given. Corner again, nothing again.
Toure must have been getting jealous of Gallas and his two goal tally this early in the season and he tried to score from an angle even The Pers would find it hard to do. He got points for trying though, he wanted to break his duck as well but his duck is still alive.
Over 35 minutes of time had been played before Newcastle even got a sniff. Michael Owen tried it but he and Ameobi are tramps and they balls it up.
My special friend almost shed a few tears from the glorious movement upfront. Cesc (who's name is just suited to this kind of football) played a lovely ball through to Van Persie who's back heel invited in Adebayor. Ade probably could have hit his shot a little earlier, he didn't but he took the ball round his man his shot came to nothing. Shame really.
A few minutes later and the Cesc-y football had an affair with Emmanuel Eboue, yes you read that right Eboue! Like Bill and Monica, Sven and Nancy, my mate Si and my mate Steve's mum it was a timeless affair as Eboue made a fantastic run, laid the ball off to Adebayor who then played the ball back to Eboue who had carried on his penetrating run. Van Persie arrived in the box just in time to slide onto Eboue's back heel. As The Pers shoots and score me and 60,000 other Gooners do as well….even the birds. It's times like this you wish you could still light up a cigarette in public.
Newcastle made a substitution straight after. Bassong comes on for Jose Enrique who had been worried about the duck breaking stuff and thought that Eboue might confuse a magpie for a duck. Eboue's ripped it out of him enough today.
Manuel Alumnia who had rewrote War an Peace today finally had something to do just as halftime approached. Because he was so bored he made Owens header seem like it was harder to save than it actually was. Bread and butter stuff really.
After the break Newcastle remembered the were allowed to attack. Nicky 'I'm a scumbag t***er with ginger hair' Butt took this literally and ran his studs down Van Persie's leg. The Pers ends up on the ground and we all held our breath…not for too long right enough because we didn't want to die and The Pers got up anyway.
Newcastle won a free kick after that gimpy looking ex scouse Danny Guthrie just ran into Denilson and fell on his thieving arse. Quite apt that he should sign for a team nicknamed the magpies isn't it? Anyway the free kick ended up being saved by Bob in Row E. Well done.
Fabregas then received a yellow card after Shay Given sprinted out his box like a mental case protesting about Cesc's mis-timed challenge on Beye. Given received a yellow card to match his minging shirt for being a t**t and Cesc got one because Given was a t**t.
Samir Nasri had been quiet but really effectful today, he picked the ball up inside our penalty box and steamed toward the halfway line before he offloaded it to Denilson. Fantastic work rate and a gem of a player.
Nicky Butt had a chance to pull it back to 2-1 with a header which hit the cross bar. Ha ha.
Ade then found Van Persie who is tried to play the ball to the back post, pinged off a Newcastle defender and out for a corner. The corner, yes nothing happened. Landed safely in Given's arms.
Out third goal came after Nasri joined RVP in the igloo of coolness with James Dean, the penguins and the ice cold beer. He kept his cool on the box after he originally lost it. Denilson won it back and gave Nasri the reigns before Nasri shared the love with Ade who teed up Denilson. The boy from Brasil made up for last weeks catastrophe by hitting the ball home, there was a hint of a deflection but he breaks his Premier League duck. Quack.
Oh I love Samir Nasri and we are now best friends.
The Pers then had his hat trick attempt cruelly rejected by the cross bar. He ended up on the ground again and after a sparkling performance it went flat as he had to come off. Hopefully it's nothing too serious and Vela replaces him.
We won a corner just before Vela comes on after my best mate cracks a shot which smacks a Geordie. The corner comes to nothing. Shock.
Alexandre Song was then bought on for Denilson, straight swap as Song slotted into place alongside Cesc in centre mid.
Gael Clichy mugged Beye and his swerving shot almost ended up in the back of the net. I hate Shay Given when he's on his day because I really wanted Clichy to score.
Nasri dealt in Carlos Vela who showed great strength in holding off his man. In the end the attack ground to a halt but we're 3-0 up and cruising.
TW14 was then ready to make an entrance and did so in place of Eboue who made a fine contribution to The Pers' second goal.
Walcott being the nice lad that he is used his pace and played a lovely ball to Vela who was desperately trying to impress. He took a shot and won us the corner as it was deflected off some Geordie. We actually almost scored from this corner as Kolo Toure flew through the air like Superman on steroids but his header was more like Wonder Woman. He hit it straight at the keeper and we waste another one. I do think one day we will take advantage of these corners.
Another free kick is won on the edge on the box. To be fair Ade looked a little Eboue-esque as he went down. Nasri and King Kolo were stood over it and Samir has a crack and his attempt was thwarted by Given…again. We do win another corner though. Again we have a great chance to score as Gallas sees his header cleared off the line and Ade almost finished with the follow up.
Theo Walcott, nice lad but what a tease? Carlos Vela started the move with a lovely pass on the turn into the feet of Cesc Fabregas. Cesc then back heeled it to Ade, I can't remember a game where there were so many back heels, Soccer AM's showboating section better be full of us. Anyhow back to the game, Ade then bides his time before giving Walcott the chance to finish a quite simply orgasmic move. Close but no Cubana.
Joey 'Jailbird' Barton is brought on and receives a wonderful reception. To be fair to him the takes it on the chin…and up the bum.
His first involvement was a crazy lunge at Nasri which was surely a free kick and could have put him back behind bars. Nasri then 'tripped' Barton. He didn't really though as Barton is just a dick and fell to try to make Nasri look like a t**t. If you watch closely at the close up replays as I did you will see Samir Nasri does not touch Barton at all. First of all because he doesn't want to catch rabies/scabies/bo/hiv and secondly because he isn't that stupid.
Clichy then got in on the Barton Bashing as he megged him. Up you, mate. Nasri then got booked for his 'trip' on Barton. He better have that turned over.
The whistle blows and we left happy as Larry, whoever he is.


text:
Latest News
CAMPAIGNERS against gas mining have declared they will not back down despite police warning they could be arrested if they repeat yesterday's blockade stunt.
About 15 members of the Limestone Coast Protection Alliance swarmed in front of two oversized heavy vehicles entering Beach Energy's new conventional Haselgrove-3 exploration site south of Penola yesterday.
It is understood a number of activists defied direct orders to


text:
Migrating from Excel to MySQL
I have not written about MySQL and Python for a long time, so today I tell you how to migrate a table that you have in Excel to MySQL, all this using Python. And all, in less than 50 lines. This entry today is a totally different approach to using MySQL for Excel, which I already told you about a while ago.
Previous knowledge
For the solution I propose, I used SqlAlchemy, and pandas. Obviously, you need to have a MySQL server. .
SqlAlchemy is an Object Relational Model library, this is ORM, which facilitates the writing of Python code that will be the ORM that is responsible for translating it into the language of the database. I have not used it in many projects, and the truth is, it is a little uncomfortable for me to write Python code that will be executed in the database, as well as not to use SQL, and to do it in a Python language, adapted to the imposed rules by SqlAlchemy. It's not that it's a bad thing, but it's more of a personal mania, and in fact, I have not used it on almost any project.
However, today is one of those moments where you can get good performance from SqlAlchemy!
Pandas is the library par excellence to work with data in Python. Although with this library I have worked on multiple projects, the truth is that I have named the blog little. But hey, it should ever be the first!
Before continuing, I assume that you have installed Anaconda, the best distribution of Python (to me, is the one I like and I use). In case you do not have it, I recommend that you install the python MySQL client with the command:
pip install mysqlclient
The fact of installing this MySQL client waas due to an error I was receiving, because I don't have installed the module:
Error loading MySQLdb module: No module named 'MySQLdb'
So, if you receive this error, you now know what do you need in order to solve it: install the MySQL client.
The second thing to consider is that you need to have installed SqlAlchemy, (it is included in Anaconda !!) and you can check it with:
import sqlalchemy
The third consideration is that, to work with UTF-8, it is necessary to have the correct connection string, and in fact, it was good for me to read this answer: https://stackoverflow.com/questions/16394332/unicodeencodeerror-latin-1-codec-cant-encode-characters-in-position-0-1-ordi.
The code for migrating from Excel to MySQL
We have all the requirements ready, now you only need to modify the variables to locate the route, the Excel file, the tab that will become a table, and for MySQL, in addition to the connection data, how you want your new table to be called.
The code is this:
# coding: utf-8
# --------------------------------------------------------------------
# Name: Excel 2 MySQL # Copyright: (c) ManejandoDatos.es 2019
# -------------------------------------------------------------------- __APP__ = "Excel 2 MySQL - Version %s (%s)"
__VERSION__ = "1.0.0"
__FECHA__ = "7 Marzo 2018"
nl = "\n"
print((__APP__ + nl) % (__VERSION__, __FECHA__))
ruta = r"C:\" fichero = "file.xlsx"
solapa = "sheet_name"
tabla = "table_name"
host = "localhost"
user = "user"
passwd = "***"
database = "your_db"
try:
 import sys
 import pandas as pd
 from sqlalchemy import create_engine
except Exception as e:
 print(" *** ERROR FATAL *** Error inicial al cargar librerias!! ")
 print(e) sys.exit(0) def excel2mysql():
try:
 try:
 xls = pd.ExcelFile(ruta + "\\" + fichero)
 x1 = xls.parse(solapa)
 x1.columns = map(str.lower, x1.columns)
 # Columnas a lower
 engine = create_engine('mysql://%s:%s@%s/%s?charset=utf8&amp;amp;use_unicode=1' % (user, passwd, host, database), encoding='utf-8')
 with engine.connect() as conn, conn.begin():
 x1.to_sql(tabla, conn, if_exists='replace')
 print ("Migración terminada!")
except Exception as f:
 print('Imposible conectar con Base de datos %s!! Revise datos de conexión!!' % (host))
 print(f)
except Exception as e:
 print('ERROR!! Imposible abrir fichero')
 print(e)

if __name__ == '__main__':
 excel2mysql()
Easy, isn't it? If you like it, you can help me for mainining this blog with a beer!
As additional information, I recommend that you use the echo = True option in create_engine so that you can see all the SQL statements that are taking place in the process, although when you have become accustomed to this little script, it will be dispensable! Como información adicional, te recomiendo que uses la opción echo=True en create_engine para que vayas viendo todas las instrucciones SQL que van teniendo lugar en el proceso, aunque cuando te hayas acostumbrado a este pequeño script, te será prescindible!
También quiero hacer notar que hay que indicar que vas a trabajar con UTF-8 tanto en la cadena de conexión, como en la opción encoding de create_engine.
Happy coding!