WordPress.org

Ready to get started?Download WordPress

Forums

Advanced CSV Importer With Ultimate User Friendly Features
[resolved] HTML body is truncated - partial content upload (8 posts)

  1. simpleblogger
    Member
    Posted 11 months ago #

    This is the content of the post content column

    <p style="text-align: right;"><span style="font-family: verdana, geneva;"><em>by Guest Contributor <a href="http://www.kellogg.northwestern.edu/Faculty/Directory/Calkins_Timothy.aspx">Tim Calkins</a>     </em></span></p><p><img __jive_ID="2943" __jive_id="2943" alt="TC Competitive Race.jpg" class="jive-image" src="http://yulisays.com/wp-content/uploads/2013/05/TC-Competitive-Race.jpg" style="display: block; margin-left: auto; margin-right: auto;"/></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Great brands stumble when they fail to respond to competitive threats.  Motorola, Kodak, Blackberry, Nokia, Best Buy, Blockbuster and Zocor, for example, all struggled when competitors attacked.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">One of the reasons business executives fail to defend effectively is that they simply underestimate the risk.  When a competitive development looks like a small threat, it is hard to justify a major defensive effort.  You don’t redirect spending from promising offensive programs unless there is a compelling reason to do so.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">It is easy to fall into this trap.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Let’s assume you are running a specialty machine tool business with annual revenues of $350 million.  You have variable costs of $170 million, leaving a variable profit of $180 million.  Your fixed costs total $100 million, which includes both marketing and overhead. This leaves an operating profit of $80 million, or 23% of revenue.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">One day a new competitor appears, threatening to take 10% of the market.  How big a risk is this?</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">The calculation seems quite simple; you just multiply the potential revenue loss of $35 million times the margin, or 23%.  This results in a risk of $8.1 million, a meaningful risk but not terrifying for a business with $80 million in operating profit; worst case, the competitive move will result in a 10% decline in operating profit.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">There is just one problem:  this calculation doesn’t come even close to calculating the total risk.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">The first problem is that by using the 23% margin figure you are assuming fixed costs will decline as revenue falls. This is not likely to be the case; a brand will find it difficult to cut spending when faced with a new competitive threat.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">The correct figure to use is the variable profit margin, or in this case 51%.  With this figure the risk increases to $17.9 million.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">But this figure doesn’t capture the full risk, either, because it captures the risk in just one year.  If the new entrant gets into your category your profits will suffer this year, next year, and the year after that.  To properly value the risk you need to look at it as a perpetuity.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">If we value a stream of $17.9 million loses at a discount rate of 5%, the risk increases to $358 million.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Yet this figure still doesn’t capture the entire risk.  Once you have a new competitor it might be difficult to increase prices or reduce costs.  And the new entrant will surely seek to grow further after capturing the initial 10% share.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">The truth is that a new entrant can do massive financial damage to an established brand.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">It is critical to evaluate competitive threats accurately; it is the only way to plan and respond appropriately.  A major competitive threat can warrant a major response:  perhaps a new product launch to make it difficult for the new entrant to get distribution, a dramatic investment in promotions to block the competitor’s trial, or a new advertising campaign to raise doubts about the new entrant’s safety.  A big risk can even justify a multi-billion dollar acquisition; sometimes the best way to deal with a threatening competitor is to buy it.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Many business leaders, especially marketing executives, are by nature optimistic.  This optimism is important for motivating a team and moving projects forward.  But optimism can be dangerous, too.  A manager with a positive mind-set will be inclined to downplay competitive threats and believe in the power of her own programs.  The result will be investment in offensive programs designed to build the business instead of defensive programs that protect the business.  This puts a brand at risk, and companies get into trouble when they can’t address competitive threats.</span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><br/></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Defensive strategy is incredibly important; pushing back new entrants and responding to competitors must be a top priority for anyone running a business.  The first step is correctly evaluating competitive threats.</span></p><p></p><p style="background-color: #f5faf0; font-size: 12px; color: #333333; font-family: Arial, Verdana, sans-serif; font-style: normal; font-weight: normal; text-indent: 0px; text-align: center;"><span style="font-size: 10pt; font-family: verdana, geneva;">***********</span></p><p style="background-color: #f5faf0; font-size: 12px; color: #333333; font-family: Arial, Verdana, sans-serif; font-style: normal; font-weight: normal; text-indent: 0px; text-align: center;"><span style="font-size: 10pt; font-family: verdana, geneva;"><span style="font-size: 13px; color: black;">D</span><span style="font-size: 13px; color: black;">on't miss a </span><span style="font-size: 13px; color: black;"><span style="font-size: 13px;"><span style="font-size: 13px;"><em>MENG</em></span><span style="font-size: 13px;"><em> Blend</em></span></span> post. <a class="jive-link-external-small" href="http://feedburner.google.com/fb/a/mailverify?uri=MengBlend" style="font-size: 12px; color: #355491; text-decoration: initial;">Sign up now</a></span><span style="font-size: 13px; color: black;"> for direct delivery </span><span style="font-size: 13px; color: black;">to your email inbox.<br/></span></span><span style="font-size: 10pt; color: black; font-family: verdana, geneva;"><br/></span><span style="font-size: 10pt; font-family: verdana, geneva;">**********<br/>MENG is the indispensable community of executive level marketers who share their passion and expertise to ensure each member’s success.</span></p><p style="background-color: #f5faf0; font-size: 12px; color: #333333; font-family: Arial, Verdana, sans-serif; font-style: normal; font-weight: normal; text-indent: 0px; text-align: center;"><span style="font-size: 10pt; font-family: verdana, geneva;"><a _jive_internal="true" href="/community/about_meng" style="font-size: 13px; padding-top: 1px; padding-bottom: 1px; padding-left: 17px; color: #355491; background-position: no-repeat no-repeat;">Learn more</a> -- <a class="jive-link-external-small active_link" href="https://s07.123signup.com/servlet/SignUp;jsessionid=1CB4375749BB4868D2F79C9DDAD20628?PG=1532824182200&P=153282400" style="font-size: 13px; color: #355491;">Apply for Membership</a></span></p><p style="background-color: #f5faf0; font-size: 12px; color: #333333; font-family: Arial, Verdana, sans-serif; font-style: normal; font-weight: normal; text-indent: 0px; text-align: center;"><span style="font-size: 10pt; font-family: verdana, geneva;"><br/></span></p><p></p><table border="5" cellpadding="3" cellspacing="0" class="jiveBorder" style="width: 100%; border: 5px solid #990000;"><tbody><tr><td><p><img __jive_ID="2942" __jive_id="2942" alt="Tim Calkins Photo 9 LR (2) 2.jpg" class="jive-image" src="http://yulisays.com/wp-content/uploads/2013/05/Tim-Calkins-Photo-9-LR-%282%29-2.jpg"/></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><strong>       Tim Calkins</strong></span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"><strong><br/></strong></span></p><p><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><a href="http://www.kellogg.northwestern.edu/Faculty/Directory/Calkins_Timothy.aspx"><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Tim Calkins</span></a></span><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> is author of <em><a href="http://www.amazon.com/Defending-Your-Brand-Competitive-ebook/dp/B008FPSUKO">Defending Your Brand: How Smart Companies Use Defensive Strategy to Deal with Competitive Attacks</a> </em>and<em> <a href="http://www.amazon.com/Breakthrough-Marketing-Plans-ebook/dp/B004L2KTIG">Breakthrough Marketing Plans</a>.  </em>He is clinical professor of marketing at </span><span style="font-size: 11.0pt; font-family: 'Calibri','sans-serif';"><a href="http://www.kellogg.northwestern.edu/?utm_source=google&utm_medium=cpc&utm_term=kellogg%20school%20of%20management&utm_campaign=Brand%20Chicago%20Geo%20Target&gclid=CJGpmcftmbMCFUOK4AodYFgADQ"><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';">Northwestern University’s Kellogg School of Management</span></a></span><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> where he teaches marketing strategy, branding, and biomedical marketing.  He also works with companies around the world on strategy and branding.  Prior to joining Kellogg, he spent almost eleven years in marketing at Kraft Foods.</span></p></td></tr></tbody></table><p></p><p></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p><span style="font-size: 10.0pt; font-family: 'Verdana','sans-serif';"> </span></p><p style="text-align: left;"><span style="font-family: verdana, geneva;"><em><br/></em></span></p>

    The importer stops at:

    <p style="text-align: right;"><span style="font-family: verdana, geneva;"><em>by Guest Contributor <a href="http://www.kellogg.northwestern.edu/Faculty/Directory/Calkins_Timothy.aspx">Tim Calkins</a></em></span></p>

    Nothing else is imported.
    This is consistent to all the posts I try to import.
    Any Ideas?

    Thank you!

    http://wordpress.org/extend/plugins/wp-ultimate-csv-importer/

  2. smackcoders
    Member
    Plugin Author

    Posted 11 months ago #

    Can you ensure that your csv is in UTF-8 format?

  3. simpleblogger
    Member
    Posted 11 months ago #

    Thank you for your response!
    Yes, It was UTF-8. I even installed notepad++ to make sure of the formatting.
    I used other importer and saw that some special characters where making weird symbols.
    What I ended doing is looking for the special characters that made problems and change those special characters with something similar. i.e. I had " slanted right and left and I changed those with 2 '
    Not the most beautiful solution but I least I could import it with a different plugin.
    I can send you a small sample of the file if that can help you in the future.
    Thank again.

  4. webblish
    Member
    Posted 10 months ago #

    I have the same problem, will try to figure something out.

    Bad timing anyway, I was hoping to upload about 8000 posts but the test with 20 stories already went wrong...

    By the way: I used the plugin a fwe weeks ago to import 1200 stories (also with quite some content) without any hassle.

  5. webblish
    Member
    Posted 10 months ago #

    Update:
    - Excel made some double "" which the plugin doesn't need -> removed
    - Converted the coding to "UTF without BOM" in Codepad++

    The testfile is now imported without any problem. Now the bigger file (in parts), fingers crossed.. :-P

  6. webblish
    Member
    Posted 10 months ago #

    OK, I imported 8 sets of 1000 posts without any problem. I used "UTF8 without BOM" coding and removed al the double/extra "" and " Excel produced. The plugin knows how to handle these characters so you won't need them.

    Edit: I'm not 100% sure about the ""'s, whether you need them or not...

  7. webblish
    Member
    Posted 10 months ago #

    To be complete: if you convert the CSV file made by Excel to "UTF without BOM" in Codepad++, everything works fine.

    I'm more than happy with this plugin, I'm now having a website with over 9,500 pages and over a million words of text online... :-D

  8. smackcoders
    Member
    Plugin Author

    Posted 8 months ago #

    Thanks @webblish. The thread is closed for further discussions. Start a new one for support.

Reply

You must log in to post.

About this Plugin

About this Topic

Tags

No tags yet.