Drupal 6 Content Administration

000e7e48j

In Detail

Often a company hires a web designer to build its Drupal site, and then takes over running the site in house. This book is for the Content Editors concerned with the ongoing creation and maintenance of the site content.

In a few hours, you’ll have the knowledge needed to maintain and edit your web site as a content-rich place that visitors return to again and again. There are many books available to help you administer a Drupal site, but this is the only one specifically for Content Editors. This book doesn’t cover designing or creating a site. However, anybody who has built their own site but needs some help using the article management features will also benefit from it.

This book is a quick-start guide, aimed at Content Editors. The author’s experience enables him to explain in an efficient and interactive manner how you can keep your site up to date. The book begins with a discussion of content management and Drupal and then teaches you how to create content, add elements to it, and make the content findable. You will then learn to set up the framework for a creative team and the various options for editing content offline, their benefits and pitfalls.

This book helps you to quickly and easily solve problems, and manage content and users for a web site. It will help you become a more effective and efficient manager of Drupal-based web sites.

What you will learn from this book

  • Learn the various methods of inputting text , the various content creation and editing capabilities that are available to users
  • Add elements to your content to spice it up: teasers, links, images, embedded sound, embedded video, PDFs
  • Make changes to the article you created, use a PHP snippet to provide content, edit a revised article
  • Apply basic Search Engine Optimization by creating a URL and category tags to complement the content
  • Create a text block in order to make content available in multiple locations, create a video block to use in the site margin, create a blog entry
  • Set up the framework for a creative editorial team having editors with different roles and privileges, working together to keep the site up to date
  • Use options for creating and editing content offline and via email and apply each of the methods you learned to send content to the project site

Approach

This is a fun, informative, hands-on learning guide that uses an actual case study. In an interactive and informal manner, this guide presents purposeful examples that continue to build on each other. Clear, concise instructions and practical examples mean you can learn quickly how to take care of the content in your Drupal site.

Who this book is written for

This book is designed for those who run the site day-to-day but didn’t set it up, and aren’t necessarily that well versed in Drupal or web technologies.

You could be a content editor, proofreader, graphic artist, feature editor, or anyone else concerned with managing content on a Drupal installation.

download

Zen Cart: E-commerce Application Development

000e7e36j

This book will teach you how to install, configure, and customize your e-commerce shop using popular open-source Zen Cart and how to use its promotion and public-relations tools to attract customers to the shop. It will also teach you to customize the look and feel of your Zen Cart shop by localizing and customizing templates.

In Detail

Zen Cart is a popular open-source PHP/MySQL-based e-commerce solution available under GPL that is designed to put the merchants’ and shoppers’ requirements first. Not only does Zen Cart offer a very long list of features, but the system is designed with both store owners and web developers in mind. There’s no sacrifice of usability or power.

This easy-to-follow book will teach you how to install, configure, and customize a Zen Cart shop and use its promotion and public-relations tools to attract customers to the shop. It will also teach you to customize the look and feel of the Zen Cart shop by localizing and customizing templates. With this excellent tutorial, you will be able to extend and tweak the Zen Cart store.

What you will learn from this book

  • Install and configure your Zen Cart shop
  • Manage, import, and export products in bulk
  • Configure zones, currencies, payment processors, and shipping modules
  • Use discounts, salemaker, cross-sell and up-sell to promote products
  • Use gift certificates, discount coupons, and newsletters to attract customers
  • Localize your shop by translating and adding new language and locales
  • Create or customize templates for your shop
  • Migrate products and customers from osCommerce to Zen Cart
  • Integrate Zen Cart shop with other CMSs like e107, xoops, gallery2, WordPress, phpBB, etc.

Chapter 1 is a brief introduction to Zen Cart and its functionalities.

Chapter 2 and Chapter 3 deal with how to get everything you need up and running on a development machine and also briefly look at how all the requisite technologies gel together to produce a working Zen Cart site. Chapter 2 will help you with downloading and installing Zen Cart on your machine and Chapter 3 in configuring the store.

Chapter 4 will help you make the shop more attractive with the help of already available templates as well as by customizing templates.

Chapter 5 will discuss important configuration options for localizing Zen Cart defining countries and zones, zones for taxes, tax classes, tax rates, and assigning tax rates to specific zones. We also discuss adding, editing and updating currencies in a Zen Cart shop that uses multiple currencies and creating, and editing languages for Zen Cart shop and translating language files to another language.

In Chapter 6 we discuss several promotion and public-relations tools available for Zen Cart shop and use of these tools effectively and in a planned way to enhance the sales dramatically.

Chapter 7 discusses migrating from osCommerce to Zen Cart. The chapter covers points to be considered before migration, a brief discussion of differences between osCommerce and Zen Cart database structure, and finally actual data migration from osCommerce to Zen Cart, converting osCommerce modules for Zen Cart, and common problems during migration.

In Chapter 8, we discuss integration of Zen Cart with other Content Management Systems. In detail, it covers the necessity of integration, characteristics of successful integration, and ways to integrate CMS along with the ways to integrate Zen Cart with other CMS like WordPress, Gallery2, e107, and phpBB.
Once we have set up, configured, and customized our online shop, to take it to live production, we need to carry out some routine maintenance tasks to keep it running.

In Chapter 9, we discuss common maintenance and troubleshooting activities for a Zen Cart online shop.

The Appendix gives details of resources for Zen Cart.

Approach

This is a highly practical book that can act as a reference material to which you will want to return again and again. The discussion in the book is right up-to-the point and it is filled with ample practical examples.

Who this book is written for

This book is primarily for professional developers interested in building, enhancing, or extending Zen Cart sites for customers. It is also a useful reference for those who have got Zen Cart running on their own store, and want to improve it. It will also benefit those who want to migrate from osCommerce or other engines to Zen Cart.

download

Small Business Server 2008 � Installation, Migration, and Configuration

51admd7gqe

In Detail

Small Businesses need to capitalize on the investments they make in IT to drive the business forward. SBS 2008 is uniquely positioned to deliver, but a poor implementation becomes a hindrance rather than a benefit to your business. Well implemented solutions enable your business to appear larger, yet more dynamic than many enterprises.

It’s easy to get Small Business Server 2008 up and running when you’ve got this book to hand. It helps you in a clear and friendly manner to understand how to implement SBS 2008 inside your business in a way that matches your business needs. The author’s experience enables him to share a tried and tested path to deliver the business benefits without becoming bogged down in unnecessary details that are not relevant to small businesses.

SBS 2008 is a fantastic investment for Small Businesses to make towards a well managed and highly functional IT solution in their business. This book is the culmination of many years advising small business owners and consultants on the recommend, tried and tested path to implement small business technology from Microsoft. Through this book you will gain an understanding of the features you can choose to use and then how to securely implement the server to deliver them. It will guide you through the installation and configuration process with the help of step-by-step instructions and plentiful screenshots. It will also explain how you can benefit from the collaboration tools based on SharePoint and how you can protect all your business data with a back-up process that covers anything from deleted files to a fire in the office.

Imagine how great you’ll feel when your Small Business Server 2008 is ready and working, and you can get back to surfing the Internet!

What you will learn from this book

  • Install SBS 2008, based on Windows Server, 2008 into your business environment
  • Upgrade from SBS 2003 to SBS 2008 reliably
  • Securely configure network access and access from the internet
  • Enable Exchange 2007 for email, calendar, and contacts
  • Deliver collaboration tools based on SharePoint to improve finding and sharing of information across your business
  • Manage the updates and security of all the PCs in your business network avoiding viruses and data leakage
  • Empower people to work remotely away from the office, but be as productive as if they were in the office
  • Understand how to manage the services delivered to your users
  • Gain the basic systems management knowledge to start the task of keeping your server running smoothly

Approach

This book presents step-by-step guidance through the installation and configuration process with the help of numerous screenshots. It contains many snippets of information and guidance on decision making. As every eventuality can’t be covered, there are links to online information as well as pointers to forums the author personally interacts with to answer additional questions.

Who this book is written for

This book is designed for anyone who needs to install and configure SBS 2008. You don’t need to be a technical consultant who wants to tweak every setting to become an SBS success. This book will help those with a basic understanding of technology and a desire to install and use SBS 2008 quickly and continue with their business.

download

Oracle 10g/11g Data and Database Management Utilities

000e7d35_medium

In Detail

Does your database look complicated? Are you finding it difficult to interact with it? Database interaction is a part of the daily routine for all database professionals. Using Oracle Utilities the user can benefit from improved maintenance windows, optimized backups, faster data transfers, and more reliable security and in general can do more with the same time and resources.

You don’t have to reinvent the wheel, just learn how to properly use the Oracle Utilities to achieve your goals. This is what this book is about; it covers topics oriented towards data management, session management, batch processing, massive deployment, troubleshooting, and how to make the most out of the frequently used DBA tools to improve your daily work.

Data management is one of the most frequently required tasks; doing a backup is a must-do task for any company. Data management includes several tasks such as data transfers, data uploading and downloading, reorganizing data, and data cloning, among many others. If people learn to use a tool and things appear to go well, few will question if their approach is optimal. Often it is only when maintenance windows start shrinking, due to the amount of data and business availability, that problems with any particular approach get identified. If people get used to the old export/import utilities to perform data management and if it works, they probably will consider the problem solved and will continue to use an obsolete tool. This book explores further possibilities and new tools. It makes the user question if his/her current environment is optimized and teaches how to adopt more optimized data management techniques focusing to the tools and the requirements most frequently seen in modern production environments.

What you will learn from this book

  • Improve performance and manageability using the advanced features of direct export/import utilities among different databases
  • Optimize your maintenance windows related to data management tasks such as importing data from one database to another using Data Pump and SQL*Loader
  • Perform more than just the ETL processes by taking advantage of the external tables feature
  • Use Oracle Scheduler to specify maintenance windows, assign priorities, configure job classes and many more features, and take decisions based on the task outcome
  • Get acquainted with all the possibilities the Oracle Universal Installer tool offers to make the installation task more efficient
  • Execute effective database creations: not just default creations, but comprehensive database creations
  • Configure and manage an ASM environment using DBCA
  • Improve performance and reduce the impact of recovery manager database backups in production environments
  • Increase the security in an Oracle environment, protect the backups, and manage certificates using Oracle Wallet Manager
  • Perform installations in batch environments and manage your software updates related to Critical Patch Updates (CPU) or individual patches using OPatch

Chapter 1: Data Pump � Data Pump is a versatile data management tool. This is much more than just an exp/imp upgrade, it allows remapping, dump file size estimation, restartable tasks, network transfers, advanced filtering operations, recovering data after a commit has been issued, and transferring data files among different oracle versions. It includes a PL/SQL API so it can be used as a base to develop data pump-based systems.

Chapter 2: SQL*Loader � SQL*Loader the tool to upload plain text format files to the database; if it is properly tuned you can boost the upload performance. Loading data taking care of the character set will avoid unnecessary headaches and you can optimize your loading window. There are several tips and tricks to load different character sets to the database and load binary data to BLOB fields. This tool can be used to load data on the fly and you will learn how to proactively configure it to get a smooth load.

Chapter 3: External Tables � The external table is a concept oracle introduced in 9i to ease the ETL (Extraction Transformation and Loading) DWH process. An external table can be created to map an external file to the database so you can seamlessly read it as if it was a regular table. You can extend the use of the external tables concept to analyze log files such as the alert.log or the network log files inside the database. The external table concept can be implemented with the data pump drivers; this way you can easily and selectively perform data transfers among databases spanning different Oracle versions.

Chapter 4: Recovery Manager Advanced Techniques - Recovery manager can be optimized to minimize the impact in production environments, it can run faster using parallel techniques. It can be used to clone a database on the same O.S. or transport it over different platforms, or even change the storage method between ASM and conventional file system storage and viceversa.

Chapter 5: Recovery Manager � Recovery manager first appeared back in 8.0, but it was until 9i when it began to gain popularity among DBA’s as the default backup/recover tool. It is simple and elegant and the most frequently used commands are pretty simple and intuitive. This chapter presents several practical database backup and recovery scenarios.

Chapter 6: Session Management � The users are the main reason why a DBA exists. If it were not for the users, there would be no database activity and there would be no problems to be solved. How can you easily spot a row lock contention problem? What should be done to have this problem diagnosed and solved? What does it imply to kill a user session? Managing sessions means you can regulate them by means of the Oracle profiles; this may leave sooner or later snipped sessions; what are those snipped sessions? And what does it imply getting rid of them? This chapter discusses several user session management issues.

Chapter 7: The Oracle Scheduler � The Oracle scheduler is a powerful tool used to schedule tasks in Oracle. This tool can perform simple schedules as well as complex schedules; you need to understand time expressions and the Oracle scheduler architecture to take advantage of this utility.

Chapter 8: Oracle Wallet Manager � Oracle Wallet Manager is the cornerstone and entry point for advanced security management. You can manage certificates and certificate requests, you can store identity certificates and retrieve them from a central location, or you can use the registry in a Windows environment. You can hide passwords without OS Authentication mechanisms by storing the user password inside the wallet.

Chapter 9: Security � Most people worry about having a valid backup that can be used to effectively recover data, but not all of them are concerned about the backup security; if a backup can be used to recover data, this doesn’t actually mean the data will be recovered at the same site where it was taken from. OWM is a key tool to have the backup encrypted, so sensitive data can be secured not only from the availability point of view, but also from the confidentiality point of view. Security has to do also with identifying who the real user is; this can be achieved with the enterprise user. This chapter explains step by step how to set up an environment with enterprise identity management using the Enterprise Security Manager.

Chapter 10: Database Configuration Assistant � Creating a database is one of the first tasks the user performs when installing Oracle, but this tool goes far beyond the simple task of creating the database; it can be used to manage templates, create a database in silent mode, and configure services in an RAC environment. Configuring database options and enabling the Enterprise Manager DB Control can be done here. DBCA is also the easy way to start up and configure an Automatic Storage Management (ASM) environment.

Chapter 11: Oracle Universal Installer � Installing Oracle is more than just a next ? next button pressing activity, OUI is a tool to manage software. Most people care about database backup, as well as configuration file backup, but what about the Oracle installer repository? This set of files is most often underestimated unless a hardware failure make the DBA understand what Oracle software maintenance is. OUI can perform silent and batch installations; it can also perform installations from a central software depot accessible through the Web.

Chapter 12: Enterprise Manager Configuration Assistant � Most DBAs use EM as the basic DBA administration tool; it is a very intuitive database management console. Most people depend on it to easily perform most of the administration and operation tasks that otherwise would be time consuming through character console mode. But what happens when it, somehow is not available, either by a change in the network topology or a firewall that restricts access to the managing port? Then the user requires to have the console reconfigured to bring it back into operation. EMCA is the character mode tool used to perform this task.

Chapter 13: OPatch � Patching the RDBMS is a required task to have the software up to date. When a patchset is to be applied OUI is used, but when a single patch or a CPU is to be applied OPatch must be used. You will learn how to perform a basic patch application task, list the patch inventory, find out if a patch has already been applied, maintain the software and the software inventory, and learn how and when to perform a patch application while the database is up and running.

Approach

This book is written using a practical approach that guides you through different practical scenarios. It provides a brief introduction to the topics; this way you can quickly get to know the main features, start being productive with the tool, and grow with it at a fast pace. You won’t have to spend too much time getting to the basics of the tool and can immediately progress towards the advanced tips.

Using this practical approach you don’t have to spend valuable time trying to decipher arid reference manuals; you can easily set up the practical scenarios, and try to follow up the presentations. The images used in the book come from real scenarios, and the output is always explained so you can easily interpret what is being displayed on the screen after issuing the commands.

Who this book is written for

This book is aimed at all Oracle professionals who interact with the database through the data and database utilities and are willing to optimize their interaction with it.

Entry-level users will get acquainted with the best practices to get their job done in a timely and efficient manner. Advanced users will find useful tips and How-Tos that will help them focus on getting the most out of the database utilities and fine-tune batch processing.

download

Oracle Essbase 9 Implementation Guide

000e7d82_medium

In Detail

The hot new data analysis trends involve business intelligence and analytics. The technology that supports business intelligence and analytics better than anything else is today’s multidimensional OLAP technology � and there is none better than Oracle Essbase! Although storing data in a cube and developing analytical applications leaves many people grasping for understanding, especially if their experience is with relational databases, embracing OLAP technology will pay big dividends in the long run.

It’s easy to develop multidimensional analytic OLAP solutions when you have got this Oracle Essbase book to hand. It is a step-by-step guide to timeless Essbase fundamentals, which takes you from a basic software installation through to launching a fully functioning Essbase database cube.

This book will guide you through every stage of installing Oracle’s Essbase software on your analytic server, the Essbase Administration Services client, and the client software itself. You will learn, in easy-to-understand language, the concepts of multidimensional database technology as you are taken step by step through building an actual Essbase application complete with database, database calculation scripts, and database report scripts.

Once you have your system built and functional, the next course of instruction covers the available automation features included in your Essbase software package and how to use them. These chapters alone are worth the price of admission!
As an IT professional you quite rightly have a desire to understand multidimensional OLAP � this book gives you that understanding. Should you wish to embark on an exciting career as an Essbase developer/administrator, this book provides a fantastic foundation from which to grow.

Best of all, this book is filled with the tips and tricks that you can only get from many years and countless hours spent playing with Essbase. You get them all in just the time it takes you to complete this book.

What you will learn from this book

  • Dig into the concept of multidimensional database cubes and explore the similarities to and differences from traditional relational databases
  • Build effective database outlines including dimensions and members
  • Extract data from source systems like SQL Sources or Input Data Files and load them into Essbase cubes
  • Create fast and efficient database calculation scripts for your Essbase applications
  • Extract data into reports or downstream systems by writing professional database report scripts
  • Make your work easier by automating Essbase processes like cube building or running calc and report scripts
  • Generate quality dynamic ad hoc spreadsheets and reports by using Microsoft’s Excel Add-In effectively
  • Perform required and optional maintenance and performance-tuning tasks just like an experienced Essbase administrator

Approach

This book uses a practical step-by-step approach with the next chapter always building on the knowledge foundation created by the previous chapter.

Understanding and really grasping the multidimensional concept is difficult enough without a lot of confusing jargon thrown in. This book speaks to the reader in plain English with plenty of easy-to-follow examples. You will create, build, and maintain data for a fictional automobile company.

Who this book is written for

This book is primarily for the IT professional who has a good understanding of IT principles and processes but is a multidimensional OLAP novice. Experienced OLAP professionals will also gain insight from this book.

Simply put, if you are in the IT field and wish to gain a functional level of knowledge in the world of Oracle Essbase, whether it be for a developer role or a PM or BA role, this is the book you need.

download