Debuging MAGENTO locally
Quick tips
- Use XAMPP 1.7.1 – the version is important! v1.6.8 may also work.
http://sourceforge.net/projects/xampp/files/XAMPP%20Windows/1.7.1/xampp-win32-1.7.1.exe/download - Enable curl in php.ini
- Install from http://127.0.01 and NOT localhost
XAMPP
To run a PHP/MySQL site on a PC you need a Linux distro, giving you an Apache server on your PC. We use XAMPP – it’s reliable, well-supported and easy to install. When you install XAMPP, the version is VERY important:
XAMPP 1.7.2 uses PHP5.3 which the curent version of Magento can’t handle
XAMPP 1.7.1 is the version I’m using – recommended
XAMPP 1.7.0 does NOT work with Magento – Apache will crash during Magento install
XAMPP 1.6.8 has been reported to work with Magento but I can’t verify this
So if you’re starting from scratch, use v1.7.1. If you have an existing install, check your version and upgrade if necessary. XAMPP project: http://www.apachefriends.org/en/xampp-windows.html. Older versions can be downloaded from SourceForge: http://sourceforge.net/projects/xampp/files/. Choose the XAMPP Windows versions.
Installing Magento
Download the latest version of Magento: http://www.magentocommerce.com/product/community-edition
Unzip the folder into your /htdocs/ folder. By default this will unzip into a /magento/ folder.
Create a blank database via your PHPMyAdmin (http://localhost/phpmyadmin)
Go to: http://127.0.0.1/magento/index.php/install and follow the install procedure.
Note that I’m saying “127.0.0.1″. If you use “localhost” cookies won’t work (except in Opera), you won’t be able to log into admin and you will have URL warnings. Localhost isn’t recognised as valid domain name by Magento. Using “127.0.0.1″ gets round that problem as it contains dots.
You’re done & ready to develop your Magento shop offline!
Sources: From:
2011 Auto Show Calendar
Posted by: admin in Other Interest on April 26th, 2011
- Jan 15-23 Detroit Auto Show (NAIAS)
- Feb 11-20 Chicago Auto Show
- Mar 3-13 Geneva Motor Show
- Apr 22 - May 1 New York Auto Show
-
Aug 18-21 Pebble Beach Concours
Aug 20 Woodward Dream Cruise
Sep 15-25 Frankfurt Motor Show
Nov 1-4 SEMA Show
Nov 18-27 L.A. Auto Show
Dec 3-11 Tokyo Motor Show
ARMARIUM | custom wood work
Posted by: admin in .NET Development Blog on January 12th, 2011
Armarium Designs is a small boutique, by appointment-only business, which uses only the best materials currently available in United States and Europe. Excellent customer service, fast turnaround time, and top quality product comes standard with our service.
Armarium Designs is a owner operated business, dedicated for more than 10 years to design, manufacture and install state-of-the-art kitchen cabinetry, custom furniture, vanities, media centers, and closet and walls coverings for apartments, houses, offices, Stores, clinics and hospitals, medical offices, religious centers, restaurants, yachts and boats, public institutions and more. More over Armarium Designs is the exclusive representative for several lines of Italian kitchens
Here are two video versions for the DVD
(Hay 4 videos en el DVD, aqui esta el primer video y el segundo.)
Video:
http://www.dyerprojects.com/DVDpreliminarversion7_2.wmv
Armarium Stand at Trade Show Town Center Mall:
Using Google Analytics to Track Email Campaigns
Posted by: admin in .NET Development Blog on December 2nd, 2010
What is Google Analytics?
Google Analytics has become one of the industry’s most powerful Internet Marketing tools and the best allie of developers, website owners and advertisers. GA not only improve sales conversion and campaign targeting but also marketing initiatives.
Email Marketing Campaign Set-Up
In my case I received around 2000 new emails per month from our business and I would love to track the amount of people who click the link in the email to my website.
The trick is use the Google link generator to create the links that will be used on my Email Templates. Each link will provide information about my campaigns as country target, lanaguage etc. You specify the variables in whatever way makes sense to you. Let’s say the link in your newsletter email campaign is http://www.yoursite.com/page1 then the tagged url would look something like:
Google Analytics looks for a few basic values in each link, namely the campaign source, campaign medium and campaign name. To set-up these values manually, simply change the parameter names shown in parentheses below:
1. Campaign Source (utm_source). This identifies the name of your email marketing system, such as StreamSend. If you don’t use an email marketing system, you can label your campaign source ‘Email Marketing’.
2. Campaign Medium (utm_medium). This identifies the campaign instrument used. In the case of email marketing, your medium is ‘email’.
3. Campaign Name (utm_campaign). This identifies the name of your campaign. The Campaign Name helps you differentiate between various campaigns or unique messages within each. Most Email Marketers use their message subject line or other identifying value for this parameter.
Using this process, campaign managers can monitor in-bound visitor traffic for any destination URL, whether a main landing page, a product page or other sub-page.
Tracking Email Campaign Results
Once an email campaign is properly coded and delivered, Google Analytics automatically monitors resulting website traffic. Find out which links were most popular with your recipients, when they visited your website, how long they stayed and where they navigated following arrival. Then adjust campaigns, body text layout and other variables to improve results over time.
To view campaign results:
1. Log into your Google Analytics account.
2. On your Dashboard, click ‘Traffic Sources’.
3. View your ‘Top Traffic Sources’ or click ‘View Full Report’ to see all traffic sources.4. Locate and click the link identifying your email marketing Campaign Source. In our example above, your Campaign Source is your email marketing product, i.e. StreamSend, or ‘Email Marketing’.
On your Campaign Source page, Google Analytics provides details on the number of visitors generated by your campaign, the number of pages they visited, average time on your website, percent of new visitors to your website and the average bounce rate.
Campaign managers can also drill-down using the segments drop-down menu. This provides even greater detail on individual campaigns, keywords, geographic regions, browser types, operating systems and visitor activity, like the most popular landing and exit pages. Each results page provides the means to drill-down even further and fine-tune your data.
Google Analytics dramatically enhances the abilities e-commerce firms have in retaining and converting customers. Simply use the E-commerce tab to display purchase information to calculate ROI numbers for your campaigns.
Using Google Analytics, Email Marketers can discover simple ways to more effectively tailor their promotional messages, design and layout to their audience’s preferences, minimize steps in the purchase process, reduce shopping cart abandonment, improve landing page effectiveness and keep visitors on your website even longer by identifying and optimizing the weak links where most of your visitors exit. Use today’s robust delivery and tracking tools, and make each message count.
PHPLIST, Importing Emails from Table via PHPMYADMIN
Posted by: admin in .NET Development Blog on November 6th, 2010
- login in HostMonster
- click on pgpMyAdmin: diy !@
- Click on Query Tab
- Ad the following query
- CREATE TABLE `phplist_import_user` (
`id` int(11) NOT NULL auto_increment,
`email` varchar(255) NOT NULL default ”,
`confirmed` tinyint(4) default ‘0′,
`blacklisted` tinyint(4) default ‘0′,
`bouncecount` int(11) default ‘0′,
`entered` datetime default NULL,
`modified` timestamp(14) NOT NULL,
`uniqid` varchar(255) default NULL,
`htmlemail` tinyint(4) default ‘0′,
`subscribepage` int(11) default NULL,
`rssfrequency` varchar(100) default NULL,
`password` varchar(255) default NULL,
`passwordchanged` date default NULL,
`disabled` tinyint(4) default ‘0′,
`extradata` text,
`foreignkey` varchar(100) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `email` (`email`),
KEY `idx_phplist_user_user_uniqid` (`uniqid`)
) TYPE=MyISAM AUTO_INCREMENT=497 ;
- CREATE TABLE `phplist_import_user` (
- click process
- check if the new table ‘phplist_import_user’ has been created at the left ‘dyi_php1′ window
- confirmed, table created
- Preparing the text file
You first need to prepare the text file so that it’s in the right format. The simplest way is to change the name of the txt file for csv, there is one single column in this file so remember to call it ‘email’. No comas are required in this file. - Use Excell to delete repeated emails and also filer data using To filter for invalid email addresses in Excel,
1. From the Data menu, select Filter. This will add a drop-down list box at the top of each column.
2. Click the down arrow control in the top right of the column containing your email addresses.
3. From the drop-down menu, select (Custom…).
4. In the Custom AutoFilter dialog, enter in two filter criteria using the “does not contain” selection. Make certain to use the Or radio button option.
5. Click OK.
Once you click OK, Excel will show the emails that don’t have either the @ sign or a period. - Other way to filter email address in Excel is via Data Validation with a Custom>Formula like: =AND(FIND(”.”,A2),FIND(”@”,A958958))
- Change the “Format of imported file” to CSV. Do not choose “CSV using LOAD DATA”; it will not work. Use , instead of ; also use column ‘email’. Check ‘ignore duplicate rows’
- Click GO.
- #1062 - Duplicate entry ‘acmxx@acxx.es ‘ for key ‘email’
Meaning the email address are being taken as ID therefore the cannot be repeated. - You will see a message as ‘Import has been successfully finished, 38453 queries executed’
- Then I copied the phplist_attribute table and renamed to phplist_import_attribute. The same with phplist_user_attribute to phplist_import_user_attribute . Use tab ‘Operations’ option ‘Copy Table to’, copy Structure and DATA!!. Also you mat copy phplist_user for phplist_importSapain_user, phplist_ImportMexico_user
- Once all the emails are in MySQL login ito PHPLIST and import from Database:
Server: localhost
User: diybr*****
Password: Mar*****
Database Name: diy*****_php1
Table prefix: phplist_
Usertable prefix: phplist_import_
select THE LIST!
Object reference not set to an instance of an object
Posted by: admin in .NET Development Blog on June 11th, 2010
System.NullReferenceException - Object reference not set to an instance of an object. 3 common causes in VB.Net.
FEnd: <tr id=”TDMortgageCalculatorBlock”>
CB= Protected WithEvents TDMortgageCalculatorBlock As System.Web.UI.HtmlControls.HtmlTableRow
Solution: add runat=”server”
<tr id=”TDMortgageCalculatorBlock” runat=”server”>






