۲۰ اسفند ۱۳۹۹

There were substantial improvements

There were substantial improvements, especially in Email functionality.  Now you can email Invoices and Purchase Orders directly from Special screw user interface without third party add-ons.  We also like relatively large selection of Word Templates (as alternative to old-good-day Report Writer modified report: SOP Blank Form, for example).  Microsoft Management Reporter is by its demonstration more flexible comparing to traditional FRx.  All these features formed pretty good impression and numerous customers were added in 2010 and earlier 2011 ERP implementation seasons.  However old traditional Dexterity logic was broken in initial release of 2010 and even remained not fixed in Service Pack 1.  Let’s take a look at Integration Manager OLE connectors:
1. Advanced ODBC Data Source.  Unlike traditional CPA style application consultants, we are pioneering with deploying IM in quasi real time ecommerce shopping cart data feeding, parsing human friendly reports (coming as text files from something old, UNIX for example).  There are two popular drivers in that scenario.  First one would be basing your IM Data Source on MS SQL Server native driver and reading SQL custom view.  Second method is Advanced ODBC Data Source, based on text file driver.  In this scenario you can weed out such non-structural lines, as page number, report header, etc.  Plus if document lines are actually located in the table row and should be split – you can separate them by introducing Union construction in Query SQL statement.  All these were cool features and were very reliable in the past (there are known issues with Microsoft Text Driver, but we long time figured out the work around).  The sad news was the fact that Advanced ODBC data source linking was broken and the integration itself was losing the majority of records from child query.  Imagine if you are integrating SOP Invoices as images of ecommerce shopping carts – the document header is created, but lines are lost (Inventory Items) partially (with very high percentage).  We usually do not recommend new version upgrade until at least the first service pack is released.  And even in SP1 the issue was not resolved.  Hot Fix was released in late March of 2011
2. Windows 2008 64 bit and SQL Server 2008 with new SSIS.  Well, we typically recommend new trends and it is natural that 64 bit Windows is faster and SQL Server should be given the advantage of 64 bit computations.  However it is now a problem (we are using this technology ten years or more) to use such popular constructions as Linked Server, Openrowset.  If you would like such trivial in the past thing as importing Text file (without wizard, where SSIS is deployed) automatically from your custom programmed SQL trigger or stored procedure – it doesn’t work out of the box, we spent hours reading internet posts from programmers in the same situation and then decided to forget about it and move on to SSIS (which is nice tool, but at this time it looks like black box when integration is created and packaged – in contrast to its predecessor DTS or Data Transformation Services)
3. Integration Manager and eConnect.  It is definitely good news that more connectors are now available, based on eConnect technology.  If you are not familiar – eConnect is coded in encrypted SQL Stored procedures to replicate GP business logic (in creating, modifying or deleting master records and work documents), originally programmed in Great Plains Dexterity.  Based on direct SQL call, eConnect based integration should be considered as a way faster and it likely is.  If your historical integrations, currently deployed in production environment on the old version 10.0, 9.0, 8.0, you should expect some homework and technical paper reading.  The Finish cut part reason is simple – Microsoft changes envelop for eConnect install on your Server or Windows workstation.  With version 8.0 it was using SQL Login and Password (connecting from IM via SQL Driver).  Version 10.0 changed this way to COM+ object.  And release 2010 is deploying .Net assemblies

 

۸ اسفند ۱۳۹۹

YouTube represents a very powerful marketing channel and opportunity

Nielson Net Ratings reported in 2008 that YouTube has over 68 million unique visitors per month and has the 6th largest visitor audience in the U.S. (ahead of Special Screw Manufacturers eBay, Amazon and Wikipedia).   More than 2/3 of the U.S. population over the age of 25 has watched a YouTube video and 91% of users have purchased something online.  YouTube represents a very powerful marketing channel and opportunity for exposure on the net. 
 There are ways to tap into this immense audience with big ad spend, however I will focus on more غير مجاز مي باشدt effective “organic” tactics.  These require time but not a direct cash outlay.   For the purposes of this article, I will assume that you have already created a branded YouTube channel and are now looking for ways to leverage your channel, broaden your reach and increase your subscriber base.   (If you are new to YouTube and have not yet built your channel, the YouTube help center is a great place to start.)
 The first step in maximizing the effectiveness of your YouTube channel is to take a step back and examine your purpose for marketing on YouTube.  Is it traffic, distribution, brand?  Once you have established a firm purpose, you can begin to put together a targeted plan of attack.  Your channel design should reflect your purpose and it is necessary to regularly to take a look at your layout, logo, images and profile information.  Make sure your design adequately reflects your brand and mesغير مجاز مي باشدe.  Think of your YouTube channel as an extension of your website; therefore, it should closely resemble the look and feel of your website and other business materials. 
 Include information in your profile that describes the type of content that can be found in your channel and website.  Further, make sure that you link to your website and include your contact information outside of YouTube.   Further, make it known in your profile that you would like users to add comments, rate, share, add video responses and to subscribe to your channel. 
 When adding video content to your channel, make sure that each video has a clear mesغير مجاز مي باشدe and is not obscure and confusing.  Keep your content fresh and upload a steady supply of 1 to 2 new videos per week on the same schedule so your subscribers know when to expect new content.  Further, update the featured videos frequently.    You have the opportunity to feature nine videos on your channel and can control the order and placement of your featured videos.  Further, use the playlist feature as a way to organize your videos.  Building out playlists by subject matter will help users and subscribers find videos that they are looking for as well as expose them to content that they might not otherwise see.
 Also, pay attention to the quality of your videos.  YouTube has the capability of displaying videos at a higher quality level.  The quality of the uploaded video combined with the individual viewers’ bandwidth will determine if the video is displayed at higher quality.  Higher quality video means improved sharpness and visual clarity. The difference is especially noticeable in videos that contain text or fast movement and in full-screen mode.   When uploading a video make sure your video resolution is 480 x360 or higher and a frame rate of 24fps (frames per second) or higher.
 Each time that you upload a new video, pay specific attention to the types of videos that have done well in the past as well as VSEO (video search engine optimization).  Copy the format and subject of videos that have a lot of views, comments and ratings to try to re-create the success.   Include specific keywords in the title that people will be searching for in YouTube as well as external search engines.  Further, make sure that your description is keyword rich, clear,specific and give credit to participants who appear in the video (same applies to Non-standard Rivets Manufacturers location).