Integrate Cool Applications with WordPress.com


Integrate Cool Applications with WordPress.com.

The API gives developers access to posts and comments, as well as the ability to Follow, Like, or Reblog content for users. Other features from WordPress.com, like the daily handpicked content on Freshly Pressed, are also available through the API.

An excellent example of an application that uses the new API is the Windows 8 WordPress.com app, available now.

Our goal with the new API is to simplify the experience of using and adding to the data available on WordPress.com. To do this, we now use the OAuth2 protocol to authenticate requests for data. To retrieve public data, you can make unauthenticated requests. To perform actions, such as making new posts or comments, you would need to make authenticated requests. When the API returns data, we now return a standardized JSON object for ease-of-use.

The REST API also self-documents itself; as we add new endpoints, the documentation on our Developer Resources blog will auto-update to provide you with the latest information. In addition, you’ll also have access to a Developer Console, which will allow you to run real REST API queries and see real JSON data directly in your web browser. You can read more about the Console here.

Ready to build an app and integrate it with WordPress.com? Great! You can now sign up for and manage your OAuth2 tokens without waiting through an approval cycle. If you have any questions or feedback on the API, please get in touch with us. Make sure to follow the Developer Resources blog for news, updates, and documentation about the REST API and other awesome services we are making available to developers seeking to integrate with WordPress.com.

Advertisements

Memories of Amsterdam.


Entering Amsterdam through the beautiful Centraal Station…devouring every dessert my stomach can hold at Unlimited Delicious in the Jordaan…shopping (window shopping, really) at Amsterdam’s largest department store – De Bijenkorf…observing the stylish women of Amsterdam on bike after bike after bike… (they’re so well put together!)

 

via Memories of Amsterdam..

Easier Invitations Mean More Followers and Blog Contributors


Easier Invitations Mean More Followers and Blog Contributors.

First, now you can invite people to follow your blog. If your blog is public, anyone can use the Follow button to sign up to receive an update each time you publish new content. But if you’d like to share your blog with specific people, we’ve made it easy to send them an invitation to check out your site.

Introduction to SQL


SQL Tutorial

SQL (Structured Query Language) is used to modify and access data or information from a storage area called database. This beginner sql tutorial website teaches you the basics of SQL and how to write SQL queries. I will be sharing my knowledge on SQL and help you learn SQL better. The sql concepts discussed in this tutorial can be applied to most of database systems. The syntax used to explain the concepts is similar to the one used in Oracle database.

SQL Introduction

SQL stands for “Structured Query Language” and can be pronounced as “SQL” or “sequel – (Structured English Query Language)”. It is a query language used for accessing and modifying information in the database. IBM first developed SQL in 1970s. Also it is an ANSI/ISO standard. It has become a Standard Universal Language used by most of the relational database management systems (RDBMS). Some of the RDBMS systems are: Oracle, Microsoft SQL server, Sybase etc. Most of these have provided their own implementation thus enhancing it’s feature and making it a powerful tool. Few of the sql commands used in sql programming are SELECT Statement, UPDATE Statement, INSERT INTO Statement, DELETE Statement, WHERE Clause, ORDER BY Clause, GROUP BY Clause, ORDER Clause, Joins, Views, GROUP Functions, Indexes etc.

In a simple manner, SQL is a non-procedural, English-like language that processes data in groups of records rather than one record at a time. Few functions of SQL are:

  • store data
  • modify data
  • retrieve data
  • modify data
  • delete data
  • create tables and other database objects
  • delete data

SQL SELECT Statement

The most commonly used SQL command is SELECT statement. The SQL SELECT statement is used to query or retrieve data from a table in the database. A query may retrieve information from specified columns or from all of the columns in the table. To create a simple SQL SELECT Statement, you must specify the column(s) name and the table name. The whole query is called SQL SELECT Statement.

Syntax of SQL SELECT Statement:

SELECT column_list FROM table-name
[WHERE Clause]
[GROUP BY clause]
[HAVING clause]
[ORDER BY clause];

  • table-name is the name of the table from which the information is retrieved.
  • column_list includes one or more columns from which data is retrieved.
  • The code within the brackets is optional.

database table student_details;

id first_name last_name age subject games
100 Rahul Sharma 10 Science Cricket
101 Anjali Bhagwat 12 Maths Football
102 Stephen Fleming 09 Science Cricket
103 Shekar Gowda 18 Maths Badminton
104 Priya Chandra 15 Economics Chess

NOTE: These database tables are used here for better explanation of SQL commands. In reality, the tables can have different columns and different data.

For example, consider the table student_details. To select the first name of all the students the query would be like:

SELECT first_name FROM student_details;

NOTE: The commands are not case sensitive. The above SELECT statement can also be written as “select first_name from students_details;”

You can also retrieve data from more than one column. For example, to select first name and last name of all the students.

SELECT first_name, last_name FROM student_details;

You can also use clauses like WHERE, GROUP BY, HAVING, ORDER BY with SELECT statement. We will discuss these commands in coming chapters.

NOTE: In a SQL SELECT statement only SELECT and FROM statements are mandatory. Other clauses like WHERE, ORDER BY, GROUP BY, HAVING are optional.

How to use expressions in SQL SELECT Statement?

Expressions combine many arithmetic operators, they can be used in SELECT, WHERE and ORDER BY Clauses of the SQL SELECT Statement.

Here we will explain how to use expressions in the SQL SELECT Statement. About using expressions in WHERE and ORDER BY clause, they will be explained in their respective sections.

The operators are evaluated in a specific order of precedence, when more than one arithmetic operator is used in an expression. The order of evaluation is: parentheses, division, multiplication, addition, and subtraction. The evaluation is performed from the left to the right of the expression.

For example: If we want to display the first and last name of an employee combined together, the SQL Select Statement would be like

SELECT first_name || ' ' || last_name FROM employee;

Output:

first_name || ‘ ‘ || last_name
———————————
Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra

You can also provide aliases as below.

SELECT first_name || ' ' || last_name AS emp_name FROM employee;

Output:

emp_name
————-
Rahul Sharma
Anjali Bhagwat
Stephen Fleming
Shekar Gowda
Priya Chandra

Introduction to SAP


What is SAP?

SAP is the leading Enterprise Information and Management Package worldwide. Use of this package makes it possible to track and manage, in real-time, sales, production, finance accounting and human resources in an enterprise.

SAP the company was founded in Germany in 1972 by five ex-IBM engineers. In case you’re ever asked, SAP stands for Systeme, Andwendungen, Produkte in der Datenverarbeitung which – translated to English – means Systems, Applications, Products in Data Processing. So now you know! Being incorporated in Germany, the full name of the parent company is SAP AG. It is located in Walldorf, Germany which is close to the beautiful town of Heidelberg. SAP has subsidiaries in over 50 countries around the world from Argentina to Venezuela (and pretty much everything in between). SAP America (with responsibility for North America, South America and Australia – go figure!) is located just outside Philadelphia, PA.

The original five founders have been so successful that they have multiplied many times over such that SAP AG is now the third largest software maker in the world, with over 17,500 customers (including more than half of the world’s 500 top companies). SAP employs over 27,000 people worldwide today, and had revenues of $7.34 billion and Net Income of $581 million in FY01. SAP is listed in Germany (where it is one of the 30 stocks which make up the DAX) and on the NYSE (ticker:SAP).

There are now 44,500 installations of SAP, in 120 countries, with more then 10 million users!

So what made this company so successful? Back in 1979 SAP released SAP R/2 (which runs on mainframes) into the German market. SAP R/2 was the first integrated, enterprise wide package and was an immediate success. For years SAP stayed within the German borders until it had penetrated practically every large German company. Looking for more growth, SAP expanded into the remainder of Europe during the 80’s. Towards the end of the 80’s, client-server architecture became popular and SAP responded with the release of SAP R/3 (in 1992). This turned out to be a killer app for SAP, especially in the North American region into which SAP expanded in 1988.

The success of SAP R/3 in North America has been nothing short of stunning. Within a 5 year period, the North American market went from virtually zero to 44% of total SAP worldwide sales. SAP America alone employs more than 3,000 people and has added the names of many of the Fortune 500 to it’s customer list (8 of the top 10 semiconductor companies, 7 of the top 10 pharmaceutical companies etc). SAP today is available in 46 country-specific versions, incorporating 28 languages including Kanji and other double-byte character languages. SAP also comes in 21 industry-specific versions.

SAP R/3 is delivered to a customer with selected standard process turned on, and many many other optional processes and features turned off. At the heart of SAP R/3 are about 10,000 tables which control the way the processes are executed. Configuration is the process of adjusting the settings of these tables to get SAP to run the way you want it to. Think of a radio with 10,000 dials to tune and you’ll get the picture. Functionality included is truly enterprise wide including: Financial Accounting (e.g. general ledger, accounts receivable etc), Management Accounting (e.g. cost centers, profitability analysis etc), Sales, Distribution, Manufacturing, Production Planning, Purchasing, Human Resources, Payroll etc etc etc. For a full description of the modules included in SAP, see the related articles. All of these modules are tightly integrated which – as you will find out – is a huge blessing … but brings with it special challenges.

SAP are maintaining and increasing their dominance over their competitors through a combination of

  • embracing the internet with mySAP.com (a confusing name we believe) to head off i2 etc
  • extending their solutions with CRM to head off Siebel
  • adding functionality to their industry solutions

What Makes SAP different?

Traditional computer information systems used by many businesses today have been developed to accomplish some specific tasks and provide reports and analysis of events that have already taken place. Examples are accounting general ledger systems. Occasionally, some systems operate in a “real-time” mode that is, have up to date information in them and can be used to actually control events. A typical company has many separate systems to manage different processes like production, sales and accounting. Each of these systems has its own databases and seldom passes information to other systems in a timely manner.

SAP takes a different approach. There is only one information system in an enterprise, SAP. All applications access common data. Real events in the business initiate transactions. Accounting is done automatically by events in sales and production. Sales can see when products can be delivered. Production schedules are driven by sales. The whole system is designed to be real-time and not historical.

SAP structure embodies what are considered the “best business practices”. A company implementing SAP adapts it operations to it to achieve its efficiencies and power.

The process of adapting procedures to the SAP model involves “Business Process Re-engineering” which is a logical analysis of the events and relationships that exist in an enterprise’s operations.

 

 

SAP Application Modules

 

Home »SAP introduction » SAP Application modules

SAP Application Modules

SAP has several layers. The Basis System is the heart of the data operations and should be not evident to higher level or managerial users. Other customizing and implementation tools exist also. The heart of the system from a manager’s viewpoint are the application modules. These modules may not all be implemented in a typical company but they are all related and are listed below:

  • FI Financial Accounting–designed for automated management and external reporting of general ledger, accounts receivable, accounts payable and other sub-ledger accounts with a user defined chart of accounts. As entries are made relating to sales production and payments journal entries are automatically posted. This connection means that the “books” are designed to reflect the real situation.

 

  • CO Controlling–represents the company’s flow of cost and revenue. It is a management instrument for organizational decisions. It too is automatically updated as events occur.
  • AM Asset Management–designed to manage and supervise individual aspects of fixed assets including purchase and sale of assets, depreciation and investment management.
  • PS Project System–is designed to support the planning, control and monitoring of long-term, highly complex projects with defined goals.
  • WF Workflow–links the integrated SAP application modules with cross-application technologies, tools and services
  • IS Industry Solutions–combine the SAP application modules and additional industry-specific functionality. Special techniques have been developed for industries such as banking, oil and gas, pharmaceuticals, etc.
  • HR Human Resources–is a complete integrated system for supporting the planning and control of personnel activities.
  • PM Plant Maintenance–In a complex manufacturing process maintenance means more than sweeping the floors. Equipment must be services and rebuilt. These tasks affect the production plans.
  • MM Materials Management–supports the procurement and inventory functions occurring in day-to-day business operations such as purchasing, inventory management, reorder point processing, etc.
  • QM Quality Management–is a quality control and information system supporting quality planning, inspection, and control for manufacturing and procurement.
  • PP Production Planning–is used to plan and control the manufacturing activities of a company. This module includes; bills of material, routings, work centers, sales and operations planning, master production scheduling, material requirements planning, shop floor control, production orders, product costing, etc.
  • SD Sales and Distribution–helps to optimize all the tasks and activities carried out in sales, delivery and billing. Key elements are; pre-sales support, inquiry processing, quotation processing, sales order processing, delivery processing, billing and sales information system

 

Each of these Modules may have sub-modules designed for specific tasks as detailed below.

System-Wide Features

 

Home »SAP introduction »system wide features

System-Wide Features

SAP uses certain system wide features that should be understood at the outset. These are used to logically, safely and flexibly organize the data in a business enterprise.

 

  • Customizing

is the configuring of the system to represent your organization’s legal structure, reporting requirements and business processes. Internal reporting is a managerial tool in the daily operations. External reporting is required by governmental units controlling the legal structure of the corporation, such as, the IRS state taxing authorities, SEC etc.

  • Organizational Elements
    • Financial–
      • client is a legal and organizationally independent unit at the highest level in SAP
      • company is an independent legal entity within a client
      • business areas are used to produce profit and loss statements and balanced sheets across marketing lines
    • Materials Management
      • Purchasing units
      • Plants
    • Sales and Distribution
      • Sales Organization
      • Distribution channel
      • Division
  • Master Data is records that remain in the database over an extended period of time. Examples:
    • Customer Master
    • Vendor Master
    • Material master
    • Account Master

This structure eliminates redundant data and is shared by all SAP Modules. It is a critical aspect of the robustness of the system.

  • Employee Self Service--your employees have access to the own HR records over the Internet.
  • Security is administered for objects, profiles and authorizations. Users are only authorized to see or change the parts of the system required by their job responsibilities.
  • Classification is the assignment of objects to a class. Each class has standard characteristics.
  • Matchcodes are query tools used to find specific information using search methods.

Business Processes and SAP Functionality

In order to understand a system like SAP a thorough understanding of the events and relationships that take place in a business is required. It is not enough to just realize the Sales, Production, Finance and Accounting have jobs to do in a business. The exact details of each action, the timing of that action and its interrelationships with every other process must be understood. In many large operations there may be no person that has a complete grasp of the situation. Before an operation can be automated or computerized a thorough study of the business must be undertaken. This task is called Business Process Engineering.

 

Sequential Walk Through

 

Home »SAP introduction »sequential walk through

Sequential Walk Through

  • Sales
    • Pre-sales activity–planning and availability support for the sales personnel
    • Sales Order–The actual entry of the sales order into the system done by the salesperson at the point of sales perhaps using a PC and Internet connections.
    • Determining where the most efficient source of the ordered product is in inventory and shipping it.
    • Delivery
    • Customer Billing
    • Customer Payment

 

  • Production
    • Sales and Operations Planning SOP where the sales forecasts are used in a production planning model to check feasibility.
    • Master Production Scheduling MPS–The actual plan for the whole production process
    • Material Requirements Planning MRP–Where the production plan is actually converted into raw materials input requirements.
    • Planned Order–When materials are available and capacity exists this plan is created and then converted into a
    • Production Order.
    • Shop Floor Control where the actual production takes place and is registered into the system as finished goods.
  • Purchasing
    • Requisition–Once the Production manager plans to manufacture something a requisition for the raw materials required but not on hand must be prepared.
    • Vendor Selection–made by the purchasing department
    • Purchase order sent
    • goods receipt increasing inventory
    • Invoice verification as it is received from vendor
    • Payment to vendor.
  • Finance and Accounting
    • Sales events must be captured at the proper time into the ledger system
    • Inventory must be adjusted to match goods shipped
    • Inventory must be adjusted to match raw materials received
    • Inventory must be adjusted to move value from raw materials to work in process
    • Inventory must be adjusted to increase finished goods when they are produced
    • Accounts Payable must be set up for purchases
    • Accounts Receivable must reflect goods billed but not yet paid for

Business Process Engineering must not only identify all these steps but must also find the most efficient way to minimize redundant actions. For example, when sales are made, inventory and manufacturing plans should be automatically updated. When manufacturing plans are updated raw materials should be automatically ordered from vendors. When finished goods are shipped customers should be automatically billed at the same instant. Real situations are far more complex than the simple explanation above.