Nicolleta

So I am exporting some tables from my old version of Magento to my new version. I was told to do the below to get this but I don't even know where I enter this code. In my browser? Also where is reads "path/example" am I supposed to put something there?

To make export:

mysqldump -u username -p databasename mp_blog_authors mp_blog_categories mp_blog_categories_store mp_blog_comments mp_blog_comments_notifications mp_blog_comments_subscriptions mp_blog_drafts mp_blog_posts mp_blog_posts_category mp_blog_posts_store mp_blog_posts_tag mp_blog_tags mp_blog_views mp_search_index mp_search_index_word mp_search_query mp_search_result mp_search_type mp_search_word > path/example.sql

To make import:

mysql -u username -p databasename mp_blog_authors mp_blog_categories mp_blog_categories_store mp_blog_comments mp_blog_comments_notifications mp_blog_comments_subscriptions mp_blog_drafts mp_blog_posts mp_blog_posts_category mp_blog_posts_store mp_blog_posts_tag mp_blog_tags mp_blog_views mp_search_index mp_search_index_word mp_search_query mp_search_result mp_search_type mp_search_word < path/example.sql

Question, I am growing some plants in water. I purchased liquid fertilizer. It says 7 drops per quart of water or 1/8 tsp. So my indoor plants in water are in a small amount of water. So how much liquid fertilizer would I need per ounce? That would make it easier on me.

Has anyone read the entire "Outlander" series? I'm on the last two books and not sure if I should bother. 900 pages per book is a huge commitment of time. Anyone out there know if they are any good? I was not that impressed by the last one and I don't want to commit the next few months of my life to these books if they are going to be lame.

[11/13/14 1:24:24 AM] Nicole: Excell question

[11/13/14 1:33:56 AM] Nicole: I need to combine a bunch of lines that look like this:

Line1,

Line2,

Line3,

Line4,

Line5,

Line6,

to look like this:

Line1,Line2,Line3,Line4,Line5,Line6,

Now I know I could do:

=A1&A2&A3&A4&A5&A6

But I literally have like 1000 lines to combine so I need something that tells it to do this over a range of cells. How do I do that?

I have found the code that needs to be modified but I guess I am doing it wrong because every time I remove the h1 tag and refresh my website the logo gets really big! What is the proper way to modify this?

<h1 class="logo"><strong><?php echo $this->getLogoAlt() ?></strong><a href="<?php echo $this->getUrl('') ?>" title="<?php echo $this->getLogoAlt() ?>"><img src="<?php echo $this->getLogoSrc() ?>" alt="<?php echo $this->getLogoAlt() ?>" /></a></h1>

In Excel how do I merge a single cell of data that has been separated by the return key into a comma separated list. So for example the SINGLE CELL (these are not in multiple cells) looks like this. (note the extra space between the words like I pressed the return key twice before starting the next word):

dog

cat

gold fish

train engine

I want it to look like this:

dog, cat, gold fish, train engine

Someone on the internet gave me this formula =TRIM(SUBSTITUTE(SUBSTITUTE(A1,CHAR(13),""),CHAR(10),","))

but that came out like this:

dogcatgold fishtrain engine

it is missing the commas separating the phrases. Needs to be:

dog, cat, gold fish, train engine

Can anyone help?

In Excel how do I merge a single cell of data that has been separated by the return key into a comma separated list. So for example the SINGLE CELL (these are not in multiple cells) looks like this. (note the extra space between the words like I pressed the return key twice before starting the next word):

dog

cat

gold fish

train engine

I want it to look like this:

dog, cat, gold fish, train engine

Can this be done?

So If I did a total of $211,953.32 sales in all states and charged 9% tax rate on CA orders only and the total tax I charged on these CA orders was $2,719.40 what was the total actual taxable total? Meaning what was the actual total value of the orders I actually charged CA tax on?

He is not fighting and does not seem upset at all. He seems like he is just playing and he gets so frisky his tail gets all puffed up. I Thought cat's only did that when they are upset but my cat is clearly not upset in these situations. He just seems really fisky!

My individual tax return for year 2010 is being audited by the IRS Small business and Self Employed department. They are mostly looking at some deductions my husband took on a schedule C for some work he did as a "sole proprietor." We also own S-Corps and our S-Corps declared large losses that year that carried down to our personal taxes and contributed to our refund for 2010. But it does not look like they are technically auditing the S-Corp businesses. If they want to Audit the S-Corps as well can they do it in this audit or do they have to declare additional audits for the S-Corps separately since they are separate tax entities from our personal taxes? I hope that makes sense. I guess I am asking are they allowed to basically start to "Audit" the S-Corps when the audit was called on our personal tax return not our business tax returns? Seems like that is a separate audit. Also if not how much do we even have to explain those deductions to her in the audit from the S-Corps?

I plan on taking him to the vet on Monday but does anyone have any idea for a remedy in the mean time? I would like to give my baby some relief in case it hurts.

This has been going on for a few days now. Seems like allergies but I am not really sure. Any thoughts?