How to Export User list from WordPress Database for mailing lists

How to Export User list from WordPress Database for mailing lists

[private]

** Please read important!

1-Login to your hosting account in this case i am currently hosting my site at HostMonster , usually the Cpanel is the same . 2-After you login to CPanel Look for PHP My Admin 3-Now look for Databases Tab And then click on the appropriate Database you want to export user list from After the Database open look for the Query Tab on the top And now you must run a Query! In this Tab you will look for the following box ie Use Tables > Select Wp-users Next Since our Mailing list requires  the list in the following order Username , User Email Address , User Display name I chose the following option for the Query. Hit Update Query and you will get something like this Hit Submit Query Button and you will get a full list of users something like this Click on Select All ( located at the end of the list) Now click on the Export button located at the end of the list and in the next window that opens use the options or set them up according to your mailing list provider , ie how to separate the id , email address and name by , or ; My selection is the following And now i hit go to save the CSV file , ready for my use!

Please Note!

**I have very limited knowledge of handling database and coding , i am more of a designer that too self taught 🙂
this is just a presentation of How I export my CSV file . Please do not play around with the database if you do not have enough understanding of what you are doing . I/this site will take no responsibility if you experience any difficulties in the final outcome or any loss of data while you are following this tutorial. It is more of a recording and blogging on my part to save my everyday learning experiences.

I hope this helps you somehow though ! 🙂 Happy exporting![/private]

Creating graphics in Power point

Creating graphics in Power point

Frankly speaking i never did explore the power of point , except for creating once in a while backgrounds for presentations for my work . Which in fact is fun and quite rewarding . But using it as a drawing tool? never quite thought of it until Tom Kuhlmann created a similar power point tutorial version of one of my previously written tutorial  How to create an envelope icon with a satin Feel

This is how my version’s outcome looked like and below is Tom’s Version created entirely in PowerPoint

Tom also shares a video and step by step tutorial on his site Go take a look![/private]

How to Create a Vector Diamond Necklace and a Chain

How to Create a Vector Diamond Necklace and a Chain

This detailed tutorial will show you how i created the Diamond necklace available to download freely from Aivault through this post. The steps described here will take you through the process of drawing then coloring using very simple steps.

It is not a basic learning tutorial , i expect you to already know drawing tools , basics of drawing , pathfinder tool , live paint and using guides.

OR if you are starting out Read more tutorials on this site

Step 1

CREATING THE DIAMOND SHAPE

Star-off by creating a circle and we all know how to it by now 🙂

Next we will make use of the guides and star dividing the shape with equally sized straight lines and guide as a reference.

Step 2

USING GUIDES FOR DIVIDING THE SHAPE

Create a copy of one horizontal and one vertical line , select the rotate tool , while pressing alt create and rotate a copy of both lines as well as the guide lines.

Keeping the intersecting point of the guides and the lines as a reference align a square inside it , similar to the one seen below.

As shown below create a copy like we did with the lines and rotate it .

Now we need more guides placed , now i dont know any other way of creating the angled guides , i never really explored how to do it 🙂 , my process is to first unlock your diagonal and vertical guide select both using select tool , click on the intersecting point hold shift+alt and rotate the copy . Holding Shift will give you a snap to the middle point. hope it is clear below you can see the screen shot while i rotated the guides.

And here i have a copy done again you can do this by hitting CTRL+D which will repeat your last action.

With guides being our reference start drawing lines as shown below these are in pink color so you can see the progress

Step 3

ADDING DETAILS



Step 4

COLORING

Now turn off the guides once you are done. select the full divided / drawn circle with lines and square and using the Paint Bucket Tool fill it up with one color.
Ok you might say why not just fill the circle with foreground color change , the technique i used here is to break the full drawing up in sections and i prefer using live color option HOW? see below.
Here the full drawing is selected and then filled up with one single color . the bounding box you see below show that this is a live color object now .

Click on Expand which you will see on the top bar. This will break the full drawing into devided section making it easy for us to color each. Before doing that left click and ungroup.

Fill it up with gradience as show below

Create a star shape , i will not go into detail on how i did this one in short select the star shape tool with 6 points. create a copy place above and give a slightly tinted color.

Step 5

CREATING THE BACKGROUND

I created a black bounding box now and had sent it to back so i can better develop the final image. create a circle , and go to object>path offset path to create a bit smaller circle placed inside this one.

Using live Paint fill it up with gradient Create a copy and align in the middle

Group the diamond shape that we created above and start placing it inside the RING that we created.



Give a gradient to the rings as show below.

I created another ring silightly broader to place at the back of this whole drawing. ( create one , offset and use pathfinder to intersect You may want to learn the tools if you dont know then See the Guide here )

Again take a copy of this broader circle and place at the top , and draw an oval shape filled with same gradient.

Step 6

CREATING THE CHAIN

Start building the chain with the copy of the same thing



And Finally the whole thing is complete give a finishing touch by using copy of the SHINE we create using star shape and place it on top

FINAL PREVIEW

Create more copies and give a bit of transparencies.

 

[private]I’m Done! Share what you created if you create something using same technique! OR  download the Vector File to explore my work place.[/private]

DOWNLOAD THE SOURCE FILE WHEN YOU ARE A MEMBER. Login Or Sign up

You May also like Some more Vector Basic Drawing Tutorials Or Complete list of Tutorials!

[categorythumbnaillist 13]

 

Pin It on Pinterest