Archive for May, 2016

Setting Up Amazon Author Central

Amazon Author Central

 

Amazon Author Central is the site through which you can setup your author’s page. This page will have list of all the books which you have published once you have added and you can link it with blog, twitter or even have videos. Also it can give the list of customer reviews, Sales Info. It can also get the RSS feed from your website if you have one.

So here’s the process to do that.

Steps to configure

 

Once you login you will see as shown below.

image

How to Add books in Amazon Author Central

To Add books, Click on the Books Link on the top.

Here you will see the buttons for Adding More books. Click on that.

 

image

 

In the next screen you can search your books by entering either the title, author or ISBN. In this case I entered my Author Name. Now if the books are already added then the buttons below the books will show as “Already Added”. Else it will be “This is my book”

 

image

 

So click on “This is my book” for the book which you want to add. Make sure that you add only your book. Once you add it, it will be added in the list as show belwo.

It will take some time to really reflect in Amazon database for these books.

image

 

How to add multiple Pen Names

If you have published your books under different pen names then the process for adding the books are as given below.

  • Click on Add More books
  • Now in the screen where you search for the book, Enter your book title or Author name
  • If you find the books created under pen name, then click on “This is my book”.
  • It will show a message that “Do you see your name below”.

image

  • Click on “This is Me” button. Make sure this is your book
  • Now this will show another message, Here you select “This is my pen name”

image

Once you do that, you will see it creates second author profile.

With Multiple pen names, You can switch b/w Pen names by clicking on the dropdown next to your author name, This will list all the pen names if you have added.

image

 

Amazon Author Central doesn’t allow more than 3 pen names. Once you try to add more pen names, It will error out as show below.

image

If you have more than 3 pen names then the way to add it would be to create another account in Amazon Author Central using different email. Here’s the mail which I received  from Amazon customer service which mentions about creating another account with different email.

 

image

Right now it seems to be the only way.

How to add Biography, blogs, photos etc in Amazon Author Central

To add more information about the author, you can click Author Page from top. Here you can see Biography, photos, blog etc, You can click on respective items and click on “add” button to add the items.

image

So add your author page and manage your profile through Amazon Author Central.

In the next blog I’ll show what all information you can get from Amazon Author Central. Stay tuned.

Email me if you have any questions to clarify or you can also comment below.

Seize your day. Bye for now.

How to customize the date picker in Form Maker

I trying to set up the Date format for one Form using Form Maker. Its an amazing tool but for free version it supports only 7 controls. In the site of Form Maker I was unable to find the format which I can select for setting different types of input for Date.  Here’s the help from Form Maker which gives basic idea of how to use the date. I’m pasting the screenshot.

image

I was struggling with the date picker control which looks as given below.

Here once you select the date, it fills the text box with default date format which is set in your form.

image

 

Like in this case I selected 27 May, I’ll see following in the text box.

image

 

Now the question is how to set different format for the date. By default following format will be shown

%Y-%m-%d

This will show as 16-05-27. But if you want in different format here’s what you need to do

1. Click on the Date Type Control and select Edit, This look like a pencil icon.

image

2. Now you will see following dialog. Here you can see Date Format is set as “%Y-%m-%d”

So to change this to another format for instance “Month-Date-Year”. Change to

%m-%d-%Y

 

image

Here are some of the settings.

a) Changing short year to long year format use %Y

b) Change long year to short year use %y , here “y” is small. short year would be just 2 last digit of year, like for 2016 it would be only 16.

c) To show as month/date/year use %m/%d/%Y

So depending on the format you want, you can set appropriate settings in the date.

Happy Blogging. Please leave the comments below to share your experience or if you have any questions.

How to Fix and Protect your PC from ransomware attack

ransomeware, cryptXXX

 

Last week my machine was infected with this deadly Trojan called Ransomware/CryptXXX and I was able to recover 95% of files corrupted by this. This is really one of the nastiest virus you will come across.

How did this happen?

Recently I was download lot of tools from different sites and also visiting some malicious sites for researching. I’m not really sure how it started to affect. My best guess is initially it got affected with some Trojan which opened the gate to this deadly Virus.

 

How did I found out?

My system for few days was behaving very erratically, actually the performance of pc went down. I saw lot of extra applications in my task manager. One of the noticeable process was conhost.exe and sahookmain.exe.

Read more »

How to work with wordpress offline

Wordpress Offline

 

There are many advantages to work with wordpress offline.

1. You might be travelling and you don’t have internet connection and you want to finish of some coding.

2. Internet connection is slow and working offline would be very fast.

3. You don’t want to publish your result to the world before making sure everything is working fine.

 

So for all this advantage, You can use wordpress locally. To do that these are the steps

1. Download Wamp /XAMPP server. I’ll be guiding  you for wamp.

2. Install Wamp server on your machine.

Once installed you can browse to following folder to check. C:\wamp, here you will find the files for this server. If this server is not started up after the installation then manuall start it. You can start this server from this location by double clicking on

C:\wamp\wampmanager.exe or by going to your programs listed in start menu and clicking on it.

image

3. Now open your browser and type in the address bar

localhost or 127.0.0.1, you will see extensions and tools and projects listed.

image

Here you can see link “phpmyadmin”, click on this.

4. You will see login screen. The default password for phpmyadmin would be empty and user name would be “root”

username: root

password :

image

 

5.  In the next screen you need to create database, Here on top you can see databases link. Click on it.

image

 

7. Now you enter database which you want to create, In my case I entered “freebookstoread” and press create button. This database will be listed on the left hand side once created.

image

 

8. Now if you check c:\wamp\www

You will see that new database would have been created.

image

 

9. Now you need to installed wordpress. You can visit following sites for downloading the latest version of wordpress https://wordpress.org/download/

image

 

10. Extract the zip file into your wamp server project location. Like in this case I had created project as “freebookstoread” and I extracted the wordpress into this location. Once you extract you will see similar files listed.

image

 

11. Here you will find a file called “wp-config-sample.php”. Open this file in a text editor.

Modify the line with  “database_name_here” to the new database name which you had created.

Like “define(‘DB_NAME’, ‘freebookstoread’) and

change the “username_here” to “root” and make “password_here” to empty.

image

image

Save this file after modification as wp-config.php.

12. Now if you open “localhost” in your browser, you will be able to see your project listed under Your Projects”. In this case “freebookstoread”

image

13. Now click on the newly listed project, this will take you through installation process for wordpress.

Select the language you want to work.

image

14. Now you need to configure your site title and site login(username, password), etc Save this password whatever you are going to give because this will be your site login.

image

15. Now click on “Install WordPress”, Once you are done you will see similar dialog as shown below.

image

16. Your site is setup for working offline. You can directly type in “localhost\<sitename>” in your browser and it will prompt for wordpress login and once you log, everything you see online you can see and configure offline.

In my case it would be “localhost\freebookstoread”

 

So Happy working with your site offline. All the best. If you have any doubts feel free to comment or send me mail.

Shared Addin Template for Office Applications

Metadata Editor

 

At times we would like to create our own Addin project for Office application. This can be done using the Addin Projects in Visual Studio.

Visual studio has stopped providing support for Shared addin project and at times we would like to have addin which would work in all major office application like Excel, Word, Powerpoint, Outlook etc.

Earlier

Visual Studio 2010

image

 

 

Visual Studio 2013

image

So Microsoft has removed the shared addin project. Now if you want to create addin, you can only do for specific application.

So to solve the Problem. I downloaded the template project from this site.

https://davecra.com/2015/10/28/a-complete-shared-add-in-template/

Here David gives instruction on how to use the project. You can download the template this works for Excel, Word, Powerpoint and Outlook and register using regasm and it will show up in your Office application Ribbon.

Here’s the link to the same project, I’ve put in the  (http://georgemkurian.com/download) section so that you download from here, incase some issue is present with the original site.

Here’s the modification which I did for using for my project.

1)

I commented the below lines in ThisAddIn_Startup(), As it was giving error.

 

image

 

2)

Ribbon Specific action can be handled in this code. Rest of the properties like type of button, size of button and the icon can be done in the xml itself.

image

3) I renamed the project to my use, I wanted to build one Metadata editor for excel, word, powerpoint document hence I renamed to project to MetaEditor.

4) Changed all the guid to new guid values which you can get from guid generator.

5) Rename the addin and its description here

 

image

6) My project needed only Excel, word, Powerpoint support hence I removed the outlook specific code.

7) Also I didn’t need the TaskPane, hence I removed that as well.

8)You can add your own Buttons in xmls which would be in the resources folder.

image

9) For giving icons, Add new icon in the resource and add following code in getImage Function which you need to add in connect.cs as shown below and in xml add following line

getImage=”getImage”

 

image

 

Now  you are ready to go. You can add different dialogs and use Ribbon button to laumch it.

 

For getting office specific functionality you can directly use following codes, I’m giving you example of Excel, this you can use for any application only thing which would change is the Type of application specified and the Document/Page it returns.

 

Microsoft.Office.Interop.Excel.Application oExcelApp;
Microsoft.Office.Interop.Excel.Worksheet oSheet = null;

              oExcelApp = Connect.office.GetExcel();
oSheet = (Excel.Worksheet)oExcelApp.ActiveSheet;

 

Here’s the screenshot of the project I had done. It will list all the Custom Properties, Shape objects, Document Variables, Tags etc in Excel, Word, Powerpoint Workbook/Document/Presentations. I’ll add link to my blog later giving information about this tool.

MetaData Editor

image

 

image

 

image

That’s all Folks. Let me know if you face any issues or need any help.