See Word, Excel, Powerpoint and PDF documents on your website

 viewer office online

A WordPress you can upload any type of Word file, Excel, Powerpoint or PDF files and then link them so that your visitors can see or download them but and if we offer to see them directly on our website?

I do not mean offer a link to the Google Docs previewer which we already saw it, but directly embed the document on our website, within an entry or page.

There are several ways to get it, and one of the most immediate is using Google Drive technology specifically its preview script, to do it. The process is very simple.

Open your function plugin or file functions.php and add the following code:

The only thing you have to customize for this code are the parameters widht and height so that they fit the width of your WordPress theme, which in the example are set to 550 and 650, those of my personal blog .

With this step we have created a shortcode which we can use in our WordPress editor to show – embedded – all the document formats that the Google Drive viewer can display that is: PDF, DOC, XLS, PPT, PPS, etc.

To display a document we just have to use the shortcode in this way:

[verdoc href="http://midominio.es/nombre_del_archivo.doc"]

And what we get is that our visitors can see directly and l document on our website …

 see document embedded in wordpress

Yes, I know, some are already thinking about that " Vale Fernando, it's cool but Is not there a plugin that does the same ?, that makes me want to touch code ".

Well yes, for the more miedicas there is a super plugin called Google doc embedder that comes to do the same.

As in the previous code, it offers a shortcode in this case of type [gview href="http://midominio.es/nombre_del_archivo.doc"]but to make things easier you also have a button on the visual editor that makes it even easier to use.

NOTICE : this publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say we have not warned you.

Loading …

That may also help you:

Export list of WordPress users to Excel

Surely more than once you've asked, I assure you that I do, and that's why I started looking for a simple way to power easily export the list of users registered in WordPress to a spreadsheet .

 users wordpress

The reasons can be diverse, but the most obvious is for marketing campaigns. That is, remember that you must always inform users of what it means to register on your site if you are going to use their information otherwise you would be committing an illegality.

Well, there are many ways to do it, and the most usual is usually exporting table loquesea_users from PHPmyAdmin to your computer and then opening the exported file in your preferred spreadsheet application, but there is an even easier way, more WordPress-style, accessible from wherever you are.

 export users wordpress phpmyadmin

Yes, you guessed it, it's a plugin, and it's called Export users to csv . The settings you have are as follows:

  • Exports all user fields
  • Exports user meta data
  • Exports users by profile
  • Exports users by date

 export users wordpress csv ]

Everything you configure in a single page and what it offers you, when you click on the button " Export ", it is a file with extension " csv " you can open with Microsoft Excel or your favorite application, Google Drive included .

Using any of the chosen systems the spreadsheet that it generates is very complete, showing the following fields by default:

  • ID User
  • User Visible Name
  • Coded User Password
  • User Registration Name
  • User Email
  • User's Web
  • Registration Date and Time
  • Full Name of user

Then, the use of What you give is already yours.

NOTICE : This publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say we have not warned you.

Loading …

That may also help you:

Emergency data sheet of the owner of a WordPress website

The other day I found a fact sheet that I thought was a great idea and also with several possible uses. The approach is to provide a page where to enter the basic connection and access data that any WordPress web owner may need at some time.

The basic situations for which this sheet would serve would be, for example …

The idea is to have that sheet, print it, complete the data of it and keep it safe, for the day you might need it.

Of course I have translated it into Spanish , passed to Excel in case you want it adapt and modify to your liking and here you have it in PDF and XLS format for you to use. I already have a good one for each web that I have, which are a few.

Add tables in WordPress in a simple way • WordPress Help

But, look where, we've never seen how to do it the easy way, with plugins. Let's see the simplest ones to use:

And you will ask yourself which one is better ?, because you will see. I, already, would use the TinyMCE advanced, because it also offers you other interesting and useful buttons that you can add to the editor. But come on, the best thing is for you to try them all and stay with the one that convinces you the most.

How to migrate bbPress users to WordPress

When you talk about integrating WordPress and bbPress you usually start from the idea that you already have a user base in your WordPress and what you want is that a recent installation from bbPress allow those users to access the forums with the same data.

Up to that point, but what if you want the opposite? if you already have one user base in bbPress and you want to also have access to WordPress .

Things get complicated but following these simple steps you can do it:

  1. Access PHPmyAdmin and export the table ' bb_users ' (if you use another prefix adapt this step to your configuration) as Excel file csv .
  2. Open file csv and delete the user with the ID 1 that will be the Admin, in order to share the user o.
  3. Rename the file csv to something like ' users.csv '.
  4. Upload the file ' users.csv ' to the folder of your active theme in WordPress.
  5. Edit the file ' functions.php ' of your active theme and add the following code:
     global $ wpdb;
    require (ABSPATH. WPINC. '/registration.php');
    $ file_handle = fopen (TEMPLATEPATH. "/users.csv", "r");
    while (! feof ($ file_handle)) {
      $ field = fgetcsv ($ file_handle, 1024);
      $ ID = $ field [0];
      $ user_login = $ field [1];
      $ user_pass = $ field [2];
      $ user_nicename = $ field [3];
      $ user_email = $ field [4];
      $ user_URL = $ field [5];
      $ user_registered = date ("Y-m-d H: i: s", strtotime ($ field [6]));
      $ user_status = $ field [7];
      $ display_name = $ field [8];
      $ adduser = "
      INSERT INTO $ wpdb-> users
        (ID, user_login, user_pass, user_nicename, user_email, user_URL, user_registered, user_status, display_name)
      VALUES
        ('$ ID', '$ user_login', '$ user_pass', '$ user_nicename', '$ user_email', '$ user_URL', '$ user_registered', '$ user_status', '$ display_name')
      ";
      $ results = $ wpdb-> query ($ adduser);
      $ data = array (
        "ID" => $ ID,
        "role" => 'subscriber'
      );
      wp_update_user ($ data);
    }
    fclose ($ file_handle); 
  6. Save the changes
  7. What you have is the bbPress users in WordPress. Enter and check it out.

  8. From here you follow with the integration as we saw in this tutorial

This is an original content of WordPress Help – Resources, themes, plugins and tutorials in Spanish and published it Fernando Tellado first here: How to migrate bbPress users to WordPress

NASA promotes the use of WordPress

My friend Hector Russo warns me of an interesting page, reflecting the relevance that WordPress has acquired, in which NASA specifically NASA Glenn Research Center to use WordPress in the sites of the research center, using the template they have created for that purpose.

In this special site dedicated to WordPress in addition to posts with usage guides have a whole arsenal of WordPress promotion, such as the list of examples of created sites or the benefits of using WordPress a very well-crafted argument that I can not help but reproduce (abbreviated):

There are more details, relative to the plugins that have included. You will not deny me that it is a strong bet on WordPress, right?

If you know any more example of WordPress promotion by institutions put the link, it will be interesting to make a list for another post do you think?

Invoice your customers from WordPress • WordPress Help

I do not get over my astonishment, and that is that WordPress is becoming a MegaSuite, mainly thanks to the plugins. And now you can even bill your customers without leaving WordPress. Forget about Word or Excel to make the invoices, you can do everything without leaving your blog.

I love the idea, especially because although there are many applications free billing there are few that, being free, work as well as WP Invoice and above without leaving the administration panel of your blog.

Of course, there are things to improve or add but as a solution of web invoicing to customers is great, generates a record of invoices, has a search engine, you can mark them as paid, and everything online, without installing anything.

Did you imagine that there was something like that ?, it's more, do you know of any more WordPress virguería of this style?

Use spreadsheets to create tables and forms on your blog

A few days ago I did an article in which we explained how to create tables in your blog with an online utility and you know that there is also some plugin that can help you. Well, there is also a mode, if you want more advanced, but that uses the software installed on your computer – most of the time – a spreadsheet such as Excel, Numbers or the one included in the OpenOffice.org suite .

For this the trick is to use the function concatenate () and export the created table to valid XHTML manually. Let's see an example.

The Concatenate Function ()

The function concatenate () allows you to easily combine Excel data with XHTML marks when joining text and data contained in the cells of the spreadsheet.

The syntax of the function is simple: = concatenate (A1, "text", A2)

Basically, what you are saying is that take the value that is in cell A1 combine it with the text string, and then combine these two with the value of cell A2. In this way, if the number 3 is in cell A1 and the word "testing" in cell A2, the function will show you as a result: 3probando .

I think it's pretty understandable, but you I put a screenshot of the starting spreadsheet …

As you can see, there are 7 columns and a series of rows. What we will do is use the function concatenate () twice to create our table, one for the header and one for all the rows.

The Header Row

The function concatenate () for the header row will be only in one cell. If you look at the previous image you will see that the header data are in row 2, and go from column B to G ..

What we are going to do is insert our custom function in cell I2 (column I, row 2). What we actually do is take the data from this header row and combine it with the HTML tags

and

. To "trick" the system we will tell the spreadsheet that these labels with text enclose them in quotation marks ("")

The specific concatenation () function used in this row will be this:

If you look at detail we are creating the structure that, when exporting, will convert what we now declare as text into HTML code that our WordPress editor will understand and show as a table. The resulting text, understandable by the blog as a code, is this:

The Body of the Table

The next function concatenate () will be that of the other rows, and will combine the data of each row with labels

and

.

This function will be introduced first in cell I3. Once we have it, only will have to copy it down to the rest of the rows in column . The values ​​of the cell in the function are relative, so the function copied to the rest of the rows will be adapted to reference the cells of its same column. Your spreadsheet will do it on its own.

The function concatenate () specific to the rows of the body of the table is the one you have below:

Once you have copied the formula in the following rows you will have something like this …

Well, you already have the base of what you need to make your table in HTML.

Moving on to XHTML

The following is a little trick for which we use the possibility of copying and pasting special sheet s calculation . You just have to copy the cells, and paste them as I explain:

Copy cell I2, which is where we had the values ​​for the header.

Make a paste special, or paste values ​​ – depends of the spreadsheet you use-, in another cell of that same column. In the following rows of the column you are doing the same with each row. What you do is get a column with values ​​as text, without any reference to functions of the spreadsheet.

Once you have all the values ​​you just have to copy them into your HTML editor and you will get what you were looking for, all the codes and values ​​of your table (only without the label

of opening and closing).

Here you have the result:

JANUARY FEBRUARY MARCH APRIL MAY JUNE
UNO 1500 1800 1800 2600 2300 2500
DOS 2000 1600 1700 1900 2300 2400
THREE 3000 2500 2300 2800 ] 3100 3000
FOUR 1400 1100 900 1100 1400 1500

Although it seems somewhat tedious I assure you that it is much less than it is Write hundreds of "tr" and "td" in code. In this example we have few rows but imagine a table with dozens of them.

Thank you

NOTICE : this publication is from two years ago or more. If it's a code or a plugin it might not work in the latest versions of WordPress, and if it's a news story it might be obsolete. Then do not say we have not warned you.

Loading …

That may also help you: