Magento Tutorial

Changing the ordernumber in Magento

When moving to Magento, some people might want to change the default ordernumber 000000001 to some other number - either fooling the customer into thinking this is a very popular shop, or when migrating from another webshop to Magento. Here's how to change that order number.

MySQL table eav_entity_store

New ordernumbers are determined by a value called the increment_id, and this increment_id is stored in the database table eav_entity_store. You should login to the MySQL database using a program likephpMyAdmin, and then you will be able to edit the contents of this table.

If the database table is empty, this means that the system has not created any orders yet. Instead of trying to hack the database, it's best to create a fake order. To create a fake order you will also need to create a customer and a product, so it's probably best to perform this task just before you're going live with your shop.

Changing which increment_id?

Once you have completed orders, the table eav_entity_store will contain various records, and every record contains a different increment_id. The logic here is that increment_ids are used by various Magento entities, like orders and customers. In a default situation the record for customers has an entity_type_id of 2, while orders have an entity_type_id of 11. So to change the ordernumber for orders, you will need to edit the row with entity_type_id 11.

If you really want to know the IDs used for the different entities in the Magento database, take a look in the database table eav_entity_type, which lists various parts of an entity (like underlying PHP-classes and other MySQL tables).

What can you do with the ordernumber?

We recommend not changing the length of the ordernumber, nor the starting number of the increment_id(which should be the same as the increment_prefix) in the same table. But you can easily change some of the zeroes into other numbers.

Note that this will not change any data already stored in the database.

Disable admin notification popup

Every time you log in to the Magento Admin Panel, you see an admin notification popop message telling you there's a new Magento version. As a developer, it's best to stay informed about new releases by reading blogs, tweets and lots of other news channels - besides this, upgrades should never be taken lightly. It's possible to remove this notification popup message.

To remove this notification popup message.

• Login to your Magento Admin Panel
• Go to System >> Configuration >> Advanced
• Disable the Mage_AdminNotification module

https://www.yireo.com/tutorials/magento

Outlook 2013 Error 0x800CCC13 Cannot connect to the network

First create a new shortcut to Outlook 2013. Right click/Run As Administrator. Send/receive. 

If it works, it tells that it is the permissions. Then Right click /Compatibility/ Privilege Level/ Run This Program As Administrator. Send/Receive. 

If it works, it tells that it is the permissions. 

You could just leave it, OR, do this: got to C drive/ Program Files/ Microsoft Office/ Office 15 Folder/ Right Click/ Properties/ Security/ Administrators and Users All Checked Full Control. This should fix it permanently. Send/receive.

Block EXE/DLL downloads in Watchguard Firewall And by pass proxy

login to watchguard
go to policy manager

save and exit

How to set up a VPN Server on Windows Server 2012

Add roles and features




















VPN Access

After connecting VPN cause my internet to not work?

What you are looking to do is called split tunneling. If you are using a Microsoft PPTP VPN, you need to uncheck "Use default gateway on remote network" in the TCP/IPv4 advanced settings for the VPN connection.

If you are using another VPN client, you need to look for something related to split tunneling in the VPN client's documentations. Please note that some VPN's allow the administrator to disable split tunneling.

How to Change the Apache Port in XAMPP

Edit the httpd.conf file to change the port Apache listens on.
(1) Locate the file httpd.conf. This file should be found in C:\xampp\apache\conf (or whichever directory you installed XAMPP in – mine is on my D-drive because that is where I installed XAMPP)



(2) Open the file using a text editor or programmer’s editor 

(3b) Change the port number (80) to a different number (for this tutorial, I changed it to 50500).

(3c) Save the file.

(4) Restart the Apache Server to have the change take effect. 

How to reset Surface Pro

Reset it like Windows 8. If the factory partition is not working.

Log in to Microsoft account
Download the Image from surface pro (it a free zip file - 5GB)

Create a USB recovery drive (8GB or more)
Format the drive to FAT32

Extract zip image file and copy the files across

Boot through USB drive and continue the installation (To Boot via USB, Press the volume down key and turn on the surface pro. Once see the logo release the volume down key) 

VMware vSphere 5 virtual machine thin provisioned disk size greyed out! Need to expand the drive size

Shutdown the guest VM. if it is still grayed out. create a snapshot and delete the existing one





Start the VM and expand the drive partition on the disk management

Share Excel workbook to edit simultaneously

The workbook however need to be in a network share. it must have a write privilege to all your team members. 

 Here follow these steps.

1. Open your workbook.
2. Navigate to Review on the toolbar
3. Click on the Share Workbook icon
4. Place a check on the check box that says Allow more than one user at the same time.
5. Click on OK
6. Now, save your workbook on a network share

Installing an SSL Certificate in Microsoft Exchange Server 2010

1. Create a new certificate in exchange.

         Enter certificate name  -> Enable Wildcard certificate  -> Organization and Location

2. Open the certificate in note pad and copy the key. (CSR)

3. Login to godaddy and paste the key for new certificate.

4. Checked email, validate and download certificate.

5. Import the certificate into the one created before.

6. Assign services to certificate.

Exchange server 2010 requires a Multiple Domain (UCC) Certificate to run all services securely.

To Install an SSL Certificate in Microsoft Exchange 2010

1. To install the intermediate certificate, click Start, and then click Run..
2. Type mmc, and then click OK. The Microsoft Management Console (Console1) window opens.
3. In the Console1 window, click File, and then select Add/Remove Snap-in.
4. In the Add or Remove Snap-ins window, select Certificates, and then click Add.
5. In the Computer Account window, select Computer Account, and then click Next.
6. In the Select Computer window, select Local Computer, and then click Finish.
7. In the Add or Remove Snap-ins window, click OK.
8. In the Console1 window, click + to expand the Certificates (Local Computer) folder on the left.
9. Right-click Intermediate Certification Authorities, mouse over All Tasks, and then click Import.
10. In the Certificate Import Wizard window, click Next.
11. Click Browse to find the intermediate certificate file.
12. In the Open window, change the file extension filter to PKCS #7 Certificates (*.spc;*.p7b), select the *_iis_intermediates.p7bfile, and then click Open.
13. In the Certificate Import Wizard window, click Next.
14. Select Place all certificates in the following store, and then click Browse.
15. In the Select Certificate Store window, select Intermediate Certification Authorities, and then click OK.
16. In the Certificate Import Wizard window, click Next.
17. Click Finish.
18. Click OK.
19. Close the Console1 window, and then click No to remove the console settings.
20. To install the primary certificate, click Start, click All Programs, Microsoft Exchange Server 2010, and then click Exchange Management Console.
21. In the Exchange Management Console, click Microsoft Exchange On-Premises, and then click Manage Databases.
22. Click Server Configuration.
23. In Exchange Certificates, select your certificate, and then, from the Actions panel on the right, click Complete Pending Request.
24. In the Complete Pending Request window, click Browse to locate the certificate file.
25. In the Open window, select All Files(*.*) as your file name extension, select your certificate (it might be saved as a .txt, .cer, or .crt), and then click Open.
26. In the Complete Pending Request window, click Complete.
    
    NOTE: If you receive the error, "The source data is corrupted or not properly Base64 encoded," check the Self Signed field. If it is True, refresh console by pressing F5 on your keyboard. If it still displays True, create a new CSR and then re-key your certificate.
27. Click Finish.
28. In the Exchange Management Console, select your certificate in Exchange Certificates.
29. From the Actions menu, click Assign Services to Certificate.
30. In the Assign Services to Certificate window, select the servers you want to assign services to, and then click Next.
31. Select services you want to assign to the certificate, and then click Next.
32. Click Assign.
33. Click Finish.

https://support.godaddy.com/help/article/5863/installing-an-ssl-certificate-in-microsoft-exchange-server-2010?countrysite=au

Watch Guard RDP Rule

Login to watched guard. Open policy manager

Save and exit

How do I move System Reserve partition to system partiton C:

If C is a primary partition - mark it active. (Disk management )

Mark sys reserved inactive ( elevated command :

diskpart

sel vol G: ( use E if E is sys resd drive letter )

inact

exi 

bcdboot c:\windows /s c:

Reboot.

BackupAssist - Volume Shadow Copy Error 0x8004230f - unexpected provider error

Solution 1

HDD sector size must be 512K

Not 4096K

Find the suitable HDD

Solution 2

Upgrade the BackupAssist software

The error basically means that the system doesn't have enough of a buffer to hold all write operations occurring during a backup.
You need to increase the area allowed to VSS to buffer such write operations.

Please follow the steps below to check and if need to, adjust the shadow copy space allocated for a particular volume.

To check the current limit set: vssadmin list shadowstorage

To change the limit: vssadmin Resize ShadowStorage /For=X: /On=X: /Maxsize=XX%

or

vssadmin Resize ShadowStorage /For=X: /On=X: /Maxsize=XXGB

This will resize the limit to XX size for the X: drive.

Windows 7 Does not assign a Drive Letter automatically

Open command prompt

type in

diskpart

automount enable

Import a WAB file into Outlook Contacts

Step 1: Import to Windows Contacts

Double click on the .wab file and click Import. (This step is so easy and so fast you might not realize what happened.)

If you don't have the .wab file and still have access to the old computer, look for it at C:\Documents and Settings\username\Application Data\Microsoft\Address Book. It may be named username.wab. Copy it to the new computer.

Step 2: Using Outlook 2010 and older

If you use Outlook 2010 or older, you can import the Windows Contacts.

1. Open the Import/Export wizard. In Outlook 2010/2013, it's at File, Open, Import; in older versions, it's on the File menu.
2. Choose Import Internet Mail and Addresses. Click Next.
3. Choose Outlook Express.

4. Deselect Import Mail.
5. Choose whether to allow duplicates to be created.
6. Click Finish.

Depending on how many contacts you have, it can take from a few seconds to a few minutes to import the contacts.

Step 2: Using Outlook 2013

Outlook 2013 has limited import options. Your choices are Comma Separated Values (CSV) or vCards so you'll need to export the contacts from Windows Contacts in either CSV or as vCards. Because it's annoying to import a large number of vcards unless you use a macro, I recommend exporting in CSV format.

1. Open Windows contacts. In Windows 7, type Contacts in the Start search field; in Windows 8, type Contacts on the Start screen. Press Enter to open Contacts.
   Click Export. If you don't see Export to the far right of Organize, expand the bar or maximize the window.

2. Choose CSV (Comma Separated Values) from the Export Windows Contacts dialog.
3. Click Export.

4. Click Browse and type in a name for your CSV file.
5. Click Save, then click Next.
6. Select the fields to include in the Export. I recommend select all fields. (You need to click in each box.)
7. Click Finish the Export.
8. Close the Export dialog.

Now switch to Outlook 2013.

1. Open File, Open & Export.
2. Select Import/Export to open the Import/Export wizard .
3. Choose Import from another program or file. Click Next.

4. Choose Comma Separated Values.
5. Browse to the file you exported earlier
6. Choose whether to allow duplicates to be created.
7. Select your Contacts folder.
8. Click Finish.