Current blog publishing workflow

I’ve been working on some wordpress blogs lately and have a process that I follow to keep things as automated for “publishing” as possible.

The issue is that we can do things manually and keep it “pure” as they say but there’s a lot of tools that let you connect and push so lets make things better for sharing your thoughts with the world as quickly as possible when you hit the Publish button.

I currently have a blog setup and one way to help automate the “publishing” of your blog post is to use Jetpack. Using Jetpack, you can connect your blog to Facebook, Twitter, Google+ etc. so when a new post is released, it also shares it with those sites.

Another tool for you to us is Buffer.com which allows you to do that same thing as Jetpack but has a couple other social media platforms i.e. Pinterest & Instagram to connect to.

I’m on a schedule of one post a week right now and I use the mobile phone app for wordpress to post things on the fly but I always know that once a week I have something to share.

It’s the slow growth model and based on my reading, it’s going to take about a year of consistent posting before you even sniff a large user base but that shouldn’t really be your goal. Your goal IMHO should be to get the right people reading your blog and speaking to them in a way that you both can learn from a discussion you generated.

MY CURRENT PROCESS: I post using WordPress.com which uses the Jetpack plugin, that covers posting to my accounts on Facebook, Twitter, Google+, LinkedIn, Tumblr, Path & Eventbrite. I then go to Buffer.com and setup a post for Pinterest & Instagram.

featured image by “unsplash” which is the most amazing site for images, please share yours and we all win

SQL Query to create XML Elements

I recently had to create an XML file from a Microsoft SQL Server table. I was starting like normal to get my query results and then had to loop thru them in order to assign the data to the XML elements.

Since this table had 150+ fields, it was going to be quite literally a data entry nightmare I didn’t want to face so I figured that I would write a query to loop thru all of the database columns and then append the data needed to make my XML elements.

This query worked like a charm and took a couple minutes to create.

SELECT 'xWriter.WriteElementString("' + name + '", item.' + name + ');'
FROM sys.columns
WHERE object_id = OBJECT_ID('dbo.YOUR_TABLE_NAME')

Change my connectionstring for debug and release config

This is part of a multi page blog post where I talk about what I do after I setup my Visual Studio ASP.NET MVC (non-Core) project.

To go back to the previous posts or start at the beginning, please go to the links below:

  1. How I Setup my Visual Studio Website Project Asp.Net MVC (non-Core)

At this point I don’t like to use the LocalDb for my database but SKIP THIS STEP if you’re OK using the LocalDb provided.

In my Web.Config file, find the section which should be on top and change the entry from this:

    <connectionStrings>
        <add name="DefaultConnection" connectionString="Data Source=(LocalDb)\MSSQLLocalDB;AttachDbFilename=|DataDirectory|\aspnet-vsStarterKit.mdf;Initial Catalog=aspnet-vsStarterKit-20170302095959;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>

to this:

    <connectionStrings>
        <add name="DefaultConnection" connectionString="Data Source=(local);Initial Catalog=YOUR_DB;Integrated Security=True" providerName="System.Data.SqlClient" />
    </connectionStrings>

At the same time, I also change my Web.Release.config connection string to point to my live database when I publish.

On publish, it will swap the connection string so one less step.

<?xml version="1.0"?>
<configuration xmlns:xdt="http://schemas.microsoft.com/XML-Document-Transform">
    <connectionStrings>
        <add name="DefaultConnection" connectionString="Data Source=(local),1533;Initial Catalog=YOUR_DB_NAME;Persist Security Info=True;User ID=YOUR_LOGIN_ID;Password=YOUR_PWD;MultipleActiveResultSets=True" xdt:Transform="SetAttributes" xdt:Locator="Match(name)"/>
    </connectionStrings>
    <system.web>
        <compilation xdt:Transform="RemoveAttributes(debug)" />
    </system.web>
</configuration>

Step #3 – Coming Soon

Site for wicked cool Text Logos and it’s free

When I create new websites I’ll go with LogoNerds.com to get an initial logo completed and the cost is $27.

CapturFiles-Mar-12-2017_01.38.25

I do that because I can get as many revisions as I want for the first logo and it’s early on in the website process so if the site doesn’t work out I can dump it and it didn’t really cost me a lot of money.

HOWEVER

I just found a new site Textcraft which is a graphical text/logo generator that you use over the web. You can use it to make Minecraft, 8-bit and other styles of text.

It’s really slick so now I make a fun text logo for my new sites and if the site makes it thru all the testing and has some promise, I’ll move back to LogoNerds.com but for now Textcraft is very slick and free for now.

CapturFiles-Mar-12-2017_12.05.42

Which Flash Blocker to use and How to Disable Flash Blocker

It’s somewhat hypocritical of me to use a Flash Blocker I’ll admit especially since I have a website that depends on advertising i.e. my Diners, Drive-ins and Dives site with Guy Fieri on the Food Network (FlavortownUSA.com) but some of these sites are STILL USING FLASH and it’s downright annoying so I do use one.

WHICH ONE DO I USE?

I go with a new one called “Flash Block (Plus)” and I’m using it for Chrome. I don’t know if they have it for other browsers but they have it for Chrome and I highly recommend you use this browser.

CapturFiles-Mar-12-2017_10.17.55

The biggest reason I like it is for it’s simplicity and big notifications of the sections where it’s being blocked.

Other software in the past make it hard to block and keep the sections tiny so as an old man, it’s harder to see.

The other reason and it’s below is that they make it easy to white list sites and disable flash block so see the picture below.

HOW DO I DISABLE FLASH BLOCKER FOR SITES

Just click on the “+” sign to white list a site or disable Flash for sites you want to do this for. Very simple, super easy flash blocker that I am currently endorsing.

CapturFiles-Mar-12-2017_10_08_32