How Can We Help?
Search
Print
Select the range of cells in which to delete duplicates.
Click on the Data tab and then on Remove Duplicates under the Data Tools section
Select the relevant columns that contain duplicates and click on OK
All duplicates have now been deleted.
How Can We Help?
Search
Print
Go to Menu and then Main Menu
Select the Default Menu item “To identify the default menu item you will see a star in the Default column“
Under the Basic Parameter options place a 0 next to # Links and click on save, refresh the Home Page and the More Article Links will disappear.
How Can We Help? Search Print Click on the form name under the Forms Management tab and ensure that Data storage is enabled Next click on the Validation Tab Scroll down to the Server Side Validation and set Enable Server Side Validationto yes In the text area Server Side Validation Code add the following code <?php $db =& JFactory::getDBO(); $query = " SELECT count(*) FROM...
How Can We Help? Search Print CSV stands for comma separated file, sometimes we don’t want to use comma’s in a CSV file and decide to rather use a Pipe Delimiter | especially in cases where one of the columns contains a paragraph with comma’s in. Open Office provides us with a option to choose the Delimiter when opening CSV files, but MS Excel does not. But luckily theres a way...
How Can We Help? Search Print Type in the following command SELECT id,clientid,company FROM config INTO OUTFILE '/tmp/List.csv' FIELDS TERMINATED BY ',' LINES TERMINATED BY '\n'; The command above will output the results from the MySql query into a Comma Separated File called List.csv, it will split the columns by using a comma “,” and will terminate every new line with the line break...
How Can We Help?
Search
Print The code below will do the trick, this line can be modified to accomodate your needs. A where clause can also be added
UPDATE databaseTableName SET tableColumnName = replace(tableColumnName,"findValue","replaceValue");
How Can We Help? Search Print The difference is the way the tables are joined if no common records are available. RIGHT – RIGHT JOIN is the opposite of LEFT JOIN and the same as RIGHT OUTER JOIN. Shows all records from the right table and only matching records from the left table. LEFT – LEFT JOIN shows all records from the left table does not matter if matching records in the right...
Over the last few months my team has been developing microsites to accompany our main website. The requirements for these sites included having their own domain, theme and separate content. After reviewing options in Drupal 7, I decided the best approach given our situation was to use the Domain Access Module. The Domain Access Module provides a very solid and powerful framework for developing...
InstaShow is a premium WordPress plugin that allows you to integrate the Instagram feed on your website. It has registered 6000+ sales on the ThemeForest marketplace. It is a highly customizable plugin that has a rating of 4.87/5. InstaShow is cheap and it provides amazing features. If you own a photography, product review website or a food blog, you can get more Instagram followers by installing...
Avada is a top-rated premium WP theme, which you can download from ThemeForest marketplace. There are plenty of free themes that haven’t surpassed 1000 downloads. Interestingly, Avada has 300K+ users. It is not only best-selling WordPress theme on the ThemeForest market place but also the most popular premium WP template. Themeforest is a marketplace where developers across from various...
The Yoast SEO plugin includes an option to import meta description and title tags from other popular plugins. While using other plugins, you may have noindexed or nofollowed some or several posts. There are a couple of plugins that enable you to move settings from AIOSEO to Yoast. Unfortunately, none of the plugins provide an option to bulk move noindex posts. People noindex posts to recover from...
WordPress tags are important, no matter how small or large a site is. Tags allow users to group posts. They make website navigation easier. They allow search engines to discover and index new posts quickly. WordPress Related posts plugins use tags to calculate post relevancy and display related articles below blog posts. Human beings make mistakes. Sometimes, a webmaster may delete an important...
Unlike tech and WordPress niche, food blogging is not a competitive niche. Hence, if you share unique recipes on the food blog, you can make good money online. If you’re planning to start a food blog or you already own a food blog, your objective should be to get as many loyal visitors as you can and make money from the site without affecting the visitor experience. To get desired results...
[vc_row height=”full” valign=”center”][vc_column][us_iconbox icon=”fas|cogs” size=”120px”][/us_iconbox][us_separator size=”small”][vc_column_text]
Site Is Under Construction
[/vc_column_text][/vc_column][/vc_row]
WordPress theme development companies don’t run for a long time unless they offer quality support to the customers or launch products that are worth the money. Themify is one of the most successful WP theme development firms. It has introduced several themes till date. The themes launched by this firm are active on 50000+ sites. The most popular theme from Themify is the Ultra theme. I had...
Magazine themes are used on WordPress News sites of all types of niches. A news website may have several categories and tags. To make sure that the visitor doesn’t get bored while browsing the site, your site should have attractive pages and powerful navigation system. Furthermore, the theme must allow users to customize pages with easy so that you can test the performance of various...
Typology comes with full support for our Meks Flexible Shortcodes WordPress plugin. Check out some of the examples of what you can create inside the page/post content with our shortcodes. You can add some columns… Perhaps some progress bars? Awesome font icons? Or some nice buttons? Perhaps some social icons? Dropcaps? xcepteur adipisicing try-hard kale chips et. Meh wolf anim delectus...
Nexus is a powerful WordPress magazine theme developed by ElegantThemes. For those who aren’t aware, ET is one of the top WP theme and plugin development companies. Some of its most popular products are Divi theme, Monarch social sharing plugin, etc. Nexus template has a beautiful layout and it provides a plethora of widgets. It is a customizable theme that supports full-width layout. It is...
Lorem ipsum Id tempor laborum in consequat ut in eu id eu incididunt ut sed elit quis veniam sint id sit Duis sunt laborum in consequat tempor laborum in consequat Excepteur consectetur reprehenderit culpa deserunt cillum aute dolor dolor dolor qui. Id tempor laborum in consequat Ut in eu id eu. Shoreditch gastropub whatever. Reprehenderit quis polaroid aben digeth manu. H1...
I am a software developer and online educator who likes to keep up with all the latest in technology. I also manage cloud infrastructure, continuous monitoring, DevOps processes, security, and continuous integration and deployment.