Monday, July 13, 2009

Windows Remote Desktop - XP

Windows Remote Desktop

Connecting to a remote desktop is fairly straightforward, but a few elements must be in place first:

  • The host desktop must have Internet access (preferably high-speed).
  • The local system (the PC connecting to the remote desktop that will serve as the host) must be running Windows XP Professional (or a Windows 2003-flavor server) or have the appropriate Terminal Services tools installed.
  • Firewalls between the local system and the remote host must be configured to pass the appropriate traffic.
  • Remote Desktop must be installed and enabled on the target system.

Installing Remote Desktop

Remote Desktop is an optional Windows XP Professional service. To install it on a host system (to enable a computer to accept a remote connection request), Microsoft recommends you:

  1. Click Start.
  2. Click Control Panel.
  3. Select Add Or Remove Programs.
  4. Select Add/Remove Windows Components.
  5. Select Internet Information Services.
  6. Click the Details button.
  7. Select World Wide Web Service.
  8. Click the Details button.
  9. Check the Remote Desktop Web Connection checkbox.
  10. Click OK.
  11. Click Next.
  12. Click Finish to complete the wizard.
  13. Click Start.
  14. Select Run.
  15. Enter Net Stop w3svc and click the OK button or press Enter.
  16. Click Start.
  17. Select All Programs.
  18. Select Microsoft Update.
  19. Select Scan For Updates.
  20. Install all critical updates on the host system.
  21. Click Start.
  22. Select Run.
  23. Enter Net Start w3svc and click the OK button.

Installing Remote Desktop connection on non-XP systems

Non-Windows XP systems can also access Windows systems running Windows Remote Desktop. The local system used to access the remote computer must have the remote connectivity client software installed. To install the required Terminal Services components:

  1. Insert a Windows XP Professional CD in the local system’s CD or DVD drive.
  2. From the resulting Welcome To Microsoft Windows XP screen, click Perform Additional Tasks.
  3. Click Setup Remote Desktop Connection from the What Do You Want To Do Screen.
  4. The InstallShield Wizard will open; click Next on the Welcome To The InstallShield Wizard for Remote Desktop Connection.
  5. Read and accept the license agreement and click Next.
  6. Enter the customer name and organization, and specify whether the desktop connection is to be available to all users or only the logged in user and click Next.
  7. Click Install.
  8. Click Finish.

The older Windows system can now open the Remote Desktop Connection menu by clicking Start | Programs | Accessories | Communications | Remote Desktop Connection or by opening a command prompt and typing mstsc.

Firewall settings

Before attempting a Remote Desktop session, ensure the host system’s Windows Firewall is set to enable the connection. Follow these steps to confirm the Windows Firewall is properly configured:

  1. Click Start.
  2. Click Control Panel.
  3. Access the Windows Firewall menu (by clicking Windows Firewall using Control Panel’s Category View or by clicking Security Center and selecting Windows Firewall using the Classic Vew).
  4. Click the Exceptions tab.
  5. Confirm the Remote Desktop checkbox is checked and isn’t overridden by a group policy.

When working with other firewalls, it’s usually best that port 3389 (and port 80) be opened to enable Terminal Services traffic (and the connection to the Remote Desktop application). This is especially true when attempting to connect to Small Business Server 2003 desktops.

Enabling user access

To ensure a remote system is configured to support Remote Desktop, follow these steps:

  1. Click Start.
  2. Click Control Panel.
  3. Select Performance and Maintenance and click System (if the view is set to Category; if the Classic View is in use simply click the Control Panel’s System applet).
  4. Click the Remote tab.
  5. Confirm the Remote Desktop checkbox is checked (Allow Users To Connect Remotely To This Computer).

Next, you need to specify which users can access the system remotely. To do so:

  1. Open the Remote tab again (following the steps just described).
  2. Click the Select Remote Users button, shown in Figure A.
  3. Click the Add button.
  4. Specify those users that should receive permission to access the system remotely.
  5. Click OK to close the Select Users window.
  6. Click OK to close the Remote Desktop Users window.

Figure A

Confirm a system is set to enable a Remote Desktop connection using the Control Panel’s System applet’s Remote tab.

By default, any members of the Administrators group can connect to the system, even if they’re not specifically authorized using the Remote Desktop Users window. Should you wish to remove a user’s permission to log on remotely, highlight that user’s name and click the Remove button.

Configuring Remote Desktop

Once those conditions are met, users and administrators should be able to access systems using Remote Desktop by:

  1. Clicking Start.
  2. Selecting Run.
  3. Typing mstsc and clicking OK.

Alternatively, one can:

  1. Click Start.
  2. Click All Programs.
  3. Click Accessories.
  4. Click Communications.
  5. Click Remote Desktop Connection.

The Remote Desktop Connection Screen will appear. By default, an abbreviated version displays, as shown in Figure B

Figure B

By default, a simple Remote Desktop Connection menu appears.

To display more remote connectivity options and configure additional settings, click the Options button. Clicking the Options button reveals five tabs, from which additional settings are configured, as shown in Figure C

Figure C

Clicking Options reveals a host of additional Remote Desktop Connection settings.

From the General tab, you can enter the IP address or fully qualified domain name (FQDN) of the computer you wish to connect to within the Computer field. If you use the default menu shown in Figure A the remote computer will prompt you for a username and password.

However, from the General tab, you can specify the username, password and domain in the appropriate fields and skip the logon process. Saving this information makes quick work of logging on to remote connections, such as those used often by employees wishing to connect to their office desktops from home.

The Display tab, shown in Figure D provides options for configuring the desktop size. It’s important to match the remote system’s desktop size to the local PC, otherwise the user may go crazy trying to navigate menus that can consistently reach beyond his or her monitor’s range if configure incorrectly.

Figure D

The Display tab enables changing desktop size and color settings.

Use the Local Resources tab, shown in Figure E to set sound, keyboard and local device options. For example, you can configure remote system events to generate sounds on the local PC (by selecting Bring To This Computer within the drop down box within the Remote Computer Sound section or automatically connect to remote printers, disk drives and even serial ports (by selecting the respective checkbox from within the Local Devices section).

Figure E

The Local Resources tab provides access to remote printers and disk drives and enables triggering system sounds, among other options.

The Programs tab, shown in Figure F, permits users to trigger a specific program upon establishing the remote connection. To enable the feature, check the Start The Following Program On Connection box and specify the program’s location using the provided fields.

Figure F

Use the Programs tab to start a specific program upon connecting to the remote system.

The Experience tab, shown in Figure G makes it possible to configure the remote connection’s look and feel. For example, you can set the connection speed to maximize performance, apply the remote system’s theme and even display its desktop background. Or, to optimize performance, you can turn off menu and window animation, forego displaying the remote system’s desktop background, etc.

Figure G

Configure options on the Experience tab to optimize the remote connection’s network performance.

Saturday, July 11, 2009

Digital Pro Tutorials

http://www.toonboom.com/support/digital/eLearning/templates/

Thursday, July 9, 2009

How to Convert MOV to MKV With Free MKV Converter

http://www.wikihow.com/Convert-MOV-to-MKV-With-Free-MKV-Converter

How to Convert MOV to MKV With Free MKV Converter

MKV file is a Matroska file for Videos with audios and subtitles, and if you noticed there are two sentences outstanding at the MKV official homepage: “It is NOT a video or audio compression format (video codec); It is an envelope for which there can be many audio, video and subtitles streams, allowing the user to store a complete movie or CD in a single file.” In simple words through my understanding, it’s saying the format significantly features combination-only and envelope without file internal structure rebuilding and data recompressing. In other words, it’s a pure multimedia container format just as I mentioned above.

  1. Download and install the free MKV converter and launch it.
  2. Click Add button and highlight the MOV file before Open button clicked to add the MOV file you chose.
  3. Select the destination folder you are going to save the MKV file with Browse pressed.
      • If you want to attach any other file into the output MKV file, there are also some options to do it. Cause the MOV format doesn't support subtitle adding, we chose a subtitle file for the trial. Going into the Attachments tab to add the attachment by clicking Add button. And never forget choose a file type under MIME type for the attachment.
      • Of cause you can merge more other files as output, just press the Append button to repeat steps above.
      • You can also choose to split the output file with huge size inside into more little ones. Just press into the Global tab, and select a proper size option under ...after this size after activated the Splitting section and Enable splitting....
  4. Right now, you can start converting MOV to MKV by click Start muxing button.


Wednesday, July 8, 2009

Continue installing Mac - Built-in Network Card

for ASUS P5KPL-CM ACPI BIOS REVISION 0514
CPU : Intel Core 2 Duo E8500 @ 3.16
Kingston DDR 2 800
NVIDIA 9400GT PCIE 512mb 128bit

No Network Card - Solution

http://www.insanelymac.com/forum/index.php?showtopic=144020&st=0

If that does not work then you can do this manual method

1. Download this and extract it :
Attached File AttansicL1eEthernet.zip ( 149.86K ) Number of downloads: 228

2. Open Terminal, type in the path where you have extracted the folder like the example shown below and press Enter

Example: cd /Users/Robert/Downloads/AttansicL1eEthernet/

3. Now type sudo sh installrelease.sh and press Enter
4. Ready to go....


Tuesday, July 7, 2009

How To:Dual-Boot XP and Leopard

http://maconpc.distinctlyjordan.com/2008/03/20/how-todual-boot-xp-and-leopard/

How To:Dual-Boot XP and Leopard

The Following Guide is for creating a dual-boot system using Kalyway’s 10.5.1 boot DVD and a Windows XP install.

I wanted to be able to dual boot the new 10.5.1 install, but most of the tutorials already on the web are for Vista, which I don’t own. :-( So here is my Guide for Noobs on how to install 10.5.1 with XP.

Materials:

Procedure:

Windows and Partition Set-Up

  1. The First thing you need to do is install Windows XP. When asked which partition to install XP to; delete all your existing partitions (Note: This will erase ALL your data! Make sure you have backups of important files.)
  2. Create a new Partition for XP that is more than 10 GB, but also make sure that your drive will have 10GB for the OSX partition we will create later. (Example: If I have a 40GB drive and I want 25GB to be XP, then I type 25000 into the box. That leaves me with 15GB to install OSX on.)
  3. I won’t sayhow to do the rest of the XP instal, because I assume most of you know how to already. (If you do need help, email me at jordan AT tv3wiki.com)
  4. Once you have a nice good install of XP open a command prompt by pressing Windows Key+R. Type “cmd” (withouth quotes) and hit enter.
  5. In the newly opened window, type diskpart.
  6. type select disk 0 (zero)
  7. type list partition
  8. You should now see a list that has all the partitons on your hard drive.
  9. type create partition primary id=af
  10. You should get a conformation that diskpart created a partition succsesfully.
  11. type list partition
  12. If you see a table that has two partitions, and one says unknown format, then you’re good! (skip to step 14)
  13. If not please email me at jordan AT tv3wiki.com for help.
  14. Now type select partition x Were “x” is the partition that has an unknown format.
  15. type active
  16. type exit and close the window.

OS X Install

  1. Now we get to the cooler part of the install. Put your Kalyway disk in your drive and restart your computer.
  2. If your computer boots back into XP, change your boot order settings to read from the DVD before the hard drive.
  3. when you get to the screen that says “starting Mac OS X installer”, press the F8 key on your keyboard.
  4. then type “-v” (no quotes) and hit enter.
  5. The DVD will now boot into the Installer for OS X. Be patient as this can take a while.
  6. After the installer starts up, hit the arrow and wait for the Welcome screen to pop-up.
  7. Now, before you hit continue, at the top of the screen click on the menu that says ‘Utilities’, then click on ‘Disk Utility’.
  8. When the disk utility comes up, you should see on the left side of the screen your hard disk.
  9. Select the partition that you are going to install OS X on. Make sure the partition you select is not your Windows
  10. partition. You can make sure of this by checking the file format of the partition in the bottom-left portion of the window.
  11. Once you have the correct partition selected press the tab that reads ‘Erase’.
  12. In the drop-down menu select ‘Mac OS X (Journaled)’ and name it something simple like ‘osx’ or ‘leo’. DO NOT use a “space” in the name or any other special characters such as % or &.
  13. Press Erase and press it again in the pop-up.
  14. Close out of the Disk Utility by clicking on the red button in the top left corner of the window.
  15. You’ll now see that you are returned to the Welcome screen. Click Continue and agree to the Licence.
  16. In the Installation destination screen select the partition you just made. Click Continue.
  17. Now click the customize button.
  18. At the bottom open up the sub-selection menu and de-select the bootloader for GUID. Then select the bootloader for MBR. This is the MOST important part of the entire install! If you do not select MBR, you will be stuck with a non-working install!
  19. Close the customization window.
  20. Click Install. (You can skip the media check if you wish.)
  21. At this point depending on the amount of RAM you have, and the speed of your processor, The install can take anywhere from 4 1/2 hours(512mb ram), to 15 min(1Gb ram).

Boot Loader Configuration

  1. After the Installation has completed, restart your computer with the Gparted Live CD in the drive.
  2. Press enter for all the defaults whenit asks. (Unless, of coarse, you have a different keyboard layout.)
  3. When the graphical interface is done loading, find your Windows partition (it will be formated as NTFS.) and click on it.
  4. Now right click it, and choose “Flags”
  5. Now place a check mark in the “boot” checkbox.
  6. Close the window, and click Exit. As your computer restarts, remove the Gparted CD from your drive and boot into XP.
  7. Once in XP open up My Computer and go into your C: Drive.
  8. If it says that the fles on this drive are protected, just click the continue button.
  9. In the Menu bar click Tools –> Folder Options
  10. Click the view tab in the new window.
  11. Check Hide protected System Files and Show Hidden Files and Folders.
  12. Now Close that window and go back to your drive. Open the file named boot.ini or just boot.
  13. copy this into the last line of text C:\chain0="Mac OS X86"
  14. Save and close the file.
  15. Put your Kalyway DVD in your drive.
  16. Copy the file called “chain0″ to your C: drive.
  17. Close and restart without the Kalyway in your drive.

Saturday, July 4, 2009

SQL Dump of PBooks Database

http://www.pbooks.org/wiki/SQL_Dump_of_PBooks_Database

CREATE TABLE IF NOT EXISTS `pb_accounts` (
`id` int(11) NOT NULL auto_increment,
`name` text,
`account_type_id` int(11) NOT NULL default '0',
`description` text,
`creation_datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`account_number` int(11) default NULL,
`parent_account_id` int(11) default NULL,
`hide` enum('yes','no') default 'no',
`group_id` tinyint(2) default NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `account_number` (`account_number`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_accounts_metadata` (
`meta_id` int(11) NOT NULL auto_increment,
`account_id` int(11) NOT NULL,
`meta_key` varchar(255) NOT NULL,
`meta_value` varchar(255) NOT NULL,
PRIMARY KEY (`meta_id`),
KEY `account_id` (`account_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_account_groups` (
`ID` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default 'Undefined',
`description` varchar(255) NOT NULL default ' ',
PRIMARY KEY (`ID`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_account_group_parents` (
`account_group_id` int(11) NOT NULL default 0,
`parent_group_id` int(11) NOT NULL default 0,
UNIQUE KEY `account_group_id` (`account_group_id`,`parent_group_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_entries` (
`entry_id` int(11) NOT NULL auto_increment,
`entry_datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`memorandum` text,
`entry_type` enum('adjusting','budget','comparative','external-accountant','standard','passed-adjusting','eliminating','proposed','recurring','reclassifying','simulated','tax','other') NOT NULL default 'standard',
`status` tinyint(2) default 2,
`fiscal_period_id` int(11) NOT NULL default 0,
PRIMARY KEY (`entry_id`),
KEY `entry_datetime` (`entry_datetime`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `pb_entry_amounts` (
`entry_amount_id` int(11) NOT NULL auto_increment,
`entry_id` int(11) NOT NULL default '0',
`entry_type_id` enum('Credit','Debit') default NULL,
`entry_amount` decimal(10,2) default NULL,
`account_id` int(11) default NULL,
`memorandum` varchar(100) NOT NULL,
PRIMARY KEY (`entry_amount_id`),
KEY `pb_entry_amounts_ibfk_1` (`account_id`),
KEY `entry_index` (`entry_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;

CREATE TABLE IF NOT EXISTS `pb_entry_metadata` (
`meta_id` int(11) NOT NULL auto_increment,
`entry_id` int(11) NOT NULL,
`meta_key` varchar(255) NOT NULL,
`meta_value` varchar(255) NOT NULL,
PRIMARY KEY (`meta_id`),
KEY `entry_id` (`entry_id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_general_ledger` (
`transaction_id` int(11) NOT NULL auto_increment,
`entry_datetime` timestamp NOT NULL default CURRENT_TIMESTAMP,
`memorandum` text,
`entry_amount` decimal(10,2) default NULL,
`account_id` int(11) NOT NULL default '1002',
`entry_id` int(11) NOT NULL default '0',
`entry_amount_id` bigint(20) NOT NULL,
`fiscal_period_id` int(20) NOT NULL default '0',
PRIMARY KEY (`transaction_id`),
KEY `pb_general_ledger_ibfk_1` (`account_id`),
KEY `pb_general_ledger_ibfk_2` (`entry_id`),
KEY `entry_amount_id` (`entry_amount_id`)
)ENGINE=InnoDB AUTO_INCREMENT=1 ;


CREATE TABLE IF NOT EXISTS `pb_options` (
`option_id` smallint(11) NOT NULL auto_increment,
`option_key` varchar(255) NOT NULL default 'untitled',
`option_value` varchar(255) default NULL,
`option_type` enum('text','textarea','option','select','checkbox','other') NOT NULL default 'other',
PRIMARY KEY (`option_id`)
) ENGINE=MyISAM;

INSERT INTO `pb_options` (`option_key`,`option_value`,`option_type`) VALUES ('pbooks_database_version','e','other');


ALTER TABLE `pb_accounts_metadata`
ADD CONSTRAINT `pb_accounts_metadata_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `pb_accounts` (`id`) ON DELETE CASCADE;

ALTER TABLE `pb_account_group_parents`
ADD CONSTRAINT `pb_account_group_parents_ibfk_1` FOREIGN KEY (`parent_group_id`) REFERENCES `pb_account_groups` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION,
ADD CONSTRAINT `pb_account_group_parents_ibfk_2` FOREIGN KEY (`account_group_id`) REFERENCES `pb_account_groups` (`ID`) ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE `pb_entry_amounts`
ADD CONSTRAINT `pb_entry_amounts_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `pb_accounts` (`id`),
ADD CONSTRAINT `pb_entry_amounts_ibfk_2` FOREIGN KEY (`entry_id`) REFERENCES `pb_entries` (`entry_id`) ON DELETE CASCADE;

ALTER TABLE `pb_entry_metadata`
ADD CONSTRAINT `pb_entry_metadata_ibfk_1` FOREIGN KEY (`entry_id`) REFERENCES `pb_entries` (`entry_id`) ON DELETE CASCADE ON UPDATE NO ACTION;

ALTER TABLE `pb_general_ledger`
ADD CONSTRAINT `pb_general_ledger_ibfk_1` FOREIGN KEY (`account_id`) REFERENCES `pb_accounts` (`id`),
ADD CONSTRAINT `pb_general_ledger_ibfk_2` FOREIGN KEY (`entry_id`) REFERENCES `pb_entries` (`entry_id`) ON DELETE CASCADE;


CREATE TABLE `auth_group` (
`group_id` int(11) NOT NULL auto_increment,
`name` char(25) default NULL,
PRIMARY KEY (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=6 ;


INSERT INTO `auth_group` (`group_id`, `name`) VALUES
(1, 'PBooks Admin'),
(4, 'Prodgex Admin'),
(5, 'User Admin');

CREATE TABLE `auth_group_role` (
`group_id` int(11) default NULL,
`role_id` int(11) default NULL,
KEY `role_id` (`role_id`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `auth_group_role` (`group_id`, `role_id`) VALUES
(1, 1001),
(NULL, 1001),
(4, 1002),
(5, 1003);

CREATE TABLE `auth_role` (
`role_id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL default 'Untitled',
`description` varchar(255) default NULL,
PRIMARY KEY (`role_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1004 ;


INSERT INTO `auth_role` (`role_id`, `name`, `description`) VALUES
(1001, 'pb_admin', NULL),
(1002, 'prodgex', NULL),
(1003, 'user_admin', NULL);

CREATE TABLE `auth_user` (
`user_id` int(11) NOT NULL auto_increment,
`user_name` varchar(60) NOT NULL default '',
`user_password` varchar(64) NOT NULL default '',
`user_nicename` varchar(50) NOT NULL default '',
`email` varchar(100) NOT NULL default '',
`user_url` varchar(100) NOT NULL default '',
`user_registered` timestamp NOT NULL default CURRENT_TIMESTAMP,
`user_activation_key` varchar(60) NOT NULL default '',
`user_status` int(11) NOT NULL default '0',
`display_name` varchar(250) NOT NULL default '',
PRIMARY KEY (`user_id`),
KEY `user_login_key` (`user_name`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=1017 ;


INSERT INTO `auth_user` (`user_id`, `user_name`, `user_password`, `user_nicename`, `email`, `user_url`, `user_registered`,
`user_activation_key`, `user_status`, `display_name`) VALUES
(1016, 'demo', '$1$Iw/GCM2A$BNcUnIIawg7wFq9Iw3VA4/', '', 'demo', '', '2007-04-24 13:36:21', '', 0, '');

CREATE TABLE `auth_user_group` (
`user_id` int(11) NOT NULL default '0',
`group_id` int(11) NOT NULL default '0',
UNIQUE KEY `user_group_index` (`user_id`,`group_id`),
KEY `group_id` (`group_id`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;


INSERT INTO `auth_user_group` (`user_id`, `group_id`) VALUES
(1000, 1),
(1000, 4),
(1012, 4),
(1000, 5);

INSERT INTO `pb_accounts` (`id`, `name`, `account_type_id`, `description`, `creation_datetime`, `account_number`, `parent_account_id`) VALUES
(0, 'PLACEHOLDER', 0, 'DO NOT DELETE', '2007-05-30 20:01:03', 0, NULL),
(1010, 'Petty Cash', 10000, '', '2007-04-01 01:01:01', 1010, NULL),
(1020, 'Cash on Hand', 10000, '', '2007-04-01 01:01:01', 1020, NULL),
(1030, 'Cheque Accounts', 10000, '', '2007-04-01 01:01:01', 1030, NULL),
(1040, 'Savings Accounts', 10000, '', '2007-04-01 01:01:01', 1040, NULL),
(1050, 'Payroll Accounts', 10000, '', '2007-04-01 01:01:01', 1050, NULL),
(1070, 'Money Market Investments', 10000, '', '2007-04-01 01:01:01', 1070, NULL),
(1080, 'Short-Term Investments ( less than 90 days)', 10000, '', '2007-04-01 01:01:01', 1080, NULL),
(1090, 'Interest Receivable', 10000, '', '2007-04-01 01:01:01', 1090, NULL),
(1100, 'Accounts Receivable', 10000, '', '2007-04-01 01:01:01', 1100, NULL),
(1150, 'Allowance for Doubtful Accounts', 10000, '', '2007-04-01 01:01:01', 1150, NULL),
(1200, 'Notes Receivable', 10000, '', '2007-04-01 01:01:01', 1200, NULL),
(1250, 'Income Tax Receivable', 10000, '', '2007-04-01 01:01:01', 1250, NULL),
(1300, 'Prepaid Expenses', 10000, '', '2007-04-01 01:01:01', 1300, NULL),
(1400, 'Supplies Inventory', 10000, '', '2007-04-01 01:01:01', 1400, NULL),
(1420, 'Raw Material Inventory', 10000, '', '2007-04-01 01:01:01', 1420, NULL),
(1440, 'Work in Progress Inventory', 10000, '', '2007-04-01 01:01:01', 1440, NULL),
(1460, 'Finished Goods Inventory', 10000, '', '2007-04-01 01:01:01', 1460, NULL),
(1500, 'Land', 10000, '', '2007-04-01 01:01:01', 1500, NULL),
(1550, 'Bonds', 10000, '', '2007-04-01 01:01:01', 1550, NULL),
(1600, 'Buildings', 10000, '', '2007-04-01 01:01:01', 1600, NULL),
(1620, 'Accumulated Depreciation of Buildings', 10000, '', '2007-04-01 01:01:01', 1620, NULL),
(1650, 'Equipment', 10000, '', '2007-04-01 01:01:01', 1650, NULL),
(1670, 'Accumulated Depreciation of Equipment', 10000, '', '2007-04-01 01:01:01', 1670, NULL),
(1700, 'Furniture and Fixtures', 10000, '', '2007-04-01 01:01:01', 1700, NULL),
(1720, 'Office Equipment', 10000, '', '2007-04-01 01:01:01', 1720, NULL),
(1730, 'Accumulated Depreciation of Office Equipment', 10000, '', '2007-04-01 01:01:01', 1730, NULL),
(1740, 'Software', 10000, '', '2007-04-01 01:01:01', 1740, NULL),
(1750, 'Accumulated Depreciation of Software', 10000, '', '2007-04-01 01:01:01', 1750, NULL),
(1760, 'Vehicles', 10000, '', '2007-04-01 01:01:01', 1760, NULL),
(1770, 'Accumulated Depreciation Vehicles', 10000, '', '2007-04-01 01:01:01', 1770, NULL),
(1780, 'Other Depreciable Property', 10000, '', '2007-04-01 01:01:01', 1780, NULL),
(1790, 'Accumulated Depreciation of Other Depreciable Prop', 10000, '', '2007-04-01 01:01:01', 1790, NULL),
(1800, 'Patents', 10000, '', '2007-04-01 01:01:01', 1800, NULL),
(1850, 'Goodwill', 10000, '', '2007-04-01 01:01:01', 1850, NULL),
(1900, 'Future Income Tax Receivable', 10000, '', '2007-04-01 01:01:01', 1900, NULL),
(2010, 'Bank Indedebtedness (overdraft)', 20000, '', '2007-04-01 01:01:01', 2010, NULL),
(2020, 'Retainers or Advances on Work', 20000, '', '2007-04-01 01:01:01', 2020, NULL),
(2050, 'Interest Payable', 20000, '', '2007-04-01 01:01:01', 2050, NULL),
(2100, 'Accounts Payable', 20000, '', '2007-04-01 01:01:01', 2100, NULL),
(2150, 'Goods Received Suspense', 20000, '', '2007-04-01 01:01:01', 2150, NULL),
(2200, 'Short-Term Loan Payable', 20000, '', '2007-04-01 01:01:01', 2200, NULL),
(2230, 'Current Portion of Long-Term Debt Payable', 20000, '', '2007-04-01 01:01:01', 2230, NULL),
(2250, 'Income Tax Payable', 20000, '', '2007-04-01 01:01:01', 2250, NULL),
(2340, 'Payroll Tax Payable', 20000, '', '2007-04-01 01:01:01', 2340, NULL),
(2350, 'Withholding Income Tax Payable', 20000, '', '2007-04-01 01:01:01', 2350, NULL),
(2360, 'Other Taxes Payable', 20000, '', '2007-04-01 01:01:01', 2360, NULL),
(2400, 'Employee Salaries Payable', 20000, '', '2007-04-01 01:01:01', 2400, NULL),
(2410, 'Management Salaries Payable', 20000, '', '2007-04-01 01:01:01', 2410, NULL),
(2420, 'Director / Partner Fees Payable', 20000, '', '2007-04-01 01:01:01', 2420, NULL),
(2450, 'Health Benefits Payable', 20000, '', '2007-04-01 01:01:01', 2450, NULL),
(2460, 'Pension Benefits Payable', 20000, '', '2007-04-01 01:01:01', 2460, NULL),
(2480, 'Employment Insurance Premiums Payable', 20000, '', '2007-04-01 01:01:01', 2480, NULL),
(2500, 'Land Payable', 20000, '', '2007-04-01 01:01:01', 2500, NULL),
(2550, 'Long-Term Bank Loan', 20000, '', '2007-04-01 01:01:01', 2550, NULL),
(2560, 'Notes Payable', 20000, '', '2007-04-01 01:01:01', 2560, NULL),
(2720, 'Office Equipment Payable', 20000, '', '2007-04-01 01:01:01', 2720, NULL),
(2740, 'Vehicle Payable', 20000, '', '2007-04-01 01:01:01', 2740, NULL),
(2760, 'Other Property Payable', 20000, '', '2007-04-01 01:01:01', 2760, NULL),
(2800, 'Shareholder Loans', 20000, '', '2007-04-01 01:01:01', 2800, NULL),
(2900, 'Suspense', 20000, '', '2007-04-01 01:01:01', 2900, NULL),
(3100, 'Capital Stock', 30000, '', '2007-04-01 01:01:01', 3100, NULL),
(3200, 'Capital Surplus / Dividends', 30000, '', '2007-04-01 01:01:01', 3200, NULL),
(3300, 'Dividend Taxes Payable', 30000, '', '2007-04-01 01:01:01', 3300, NULL),
(3400, 'Dividend Taxes Refundable', 30000, '', '2007-04-01 01:01:01', 3400, NULL),
(3500, 'Retained Earnings', 30000, '', '2007-04-01 01:01:01', 3500, NULL),
(4100, 'Product / Service Sales', 40000, '', '2007-04-01 01:01:01', 4100, NULL),
(4200, 'Sales Exchange Gains/Losses', 40000, '', '2007-04-01 01:01:01', 4200, NULL),
(4500, 'Consulting Services', 40000, '', '2007-04-01 01:01:01', 4500, NULL),
(4600, 'Rentals', 40000, '', '2007-04-01 01:01:01', 4600, NULL),
(4700, 'Finance Charge Income', 40000, '', '2007-04-01 01:01:01', 4700, NULL),
(4800, 'Sales Returns and Allowances', 40000, '', '2007-04-01 01:01:01', 4800, NULL),
(4900, 'Sales Discounts', 40000, '', '2007-04-01 01:01:01', 4900, NULL),
(5100, 'Production Expenses', 50000, '', '2007-04-01 01:01:01', 5100, NULL),
(5200, 'Purchases Exchange Gains/Losses', 50000, '', '2007-04-01 01:01:01', 5200, NULL),
(5500, 'Direct Labour Costs', 50000, '', '2007-04-01 01:01:01', 5500, NULL),
(5600, 'Freight Charges', 50000, '', '2007-04-01 01:01:01', 5600, NULL),
(5700, 'Inventory Adjustment', 50000, '', '2007-04-01 01:01:01', 5700, NULL),
(5900, 'Purchase Discounts', 50000, '', '2007-04-01 01:01:01', 5900, NULL),
(6100, 'Advertising', 50000, '', '2007-04-01 01:01:01', 6100, NULL),
(6150, 'Promotion', 50000, '', '2007-04-01 01:01:01', 6150, NULL),
(6200, 'Communications', 50000, '', '2007-04-01 01:01:01', 6200, NULL),
(6250, 'Meeting Expenses', 50000, '', '2007-04-01 01:01:01', 6250, NULL),
(6300, 'Travelling Expenses', 50000, '', '2007-04-01 01:01:01', 6300, NULL),
(6400, 'Delivery Expenses', 50000, '', '2007-04-01 01:01:01', 6400, NULL),
(6590, 'Benefits', 50000, '', '2007-04-01 01:01:01', 6590, NULL),
(6600, 'Other Selling Expenses', 50000, '', '2007-04-01 01:01:01', 6600, NULL),
(6900, 'Professional Services', 50000, '', '2007-04-01 01:01:01', 6900, NULL),
(7040, 'Management Salaries', 50000, '', '2007-04-01 01:01:01', 7040, NULL),
(7050, 'Management Salary deductions', 50000, '', '2007-04-01 01:01:01', 7050, NULL),
(7060, 'Director / Partner Fees', 50000, '', '2007-04-01 01:01:01', 7060, NULL),
(7070, 'Director / Partner Deductions', 50000, '', '2007-04-01 01:01:01', 7070, NULL),
(7080, 'Payroll Tax', 50000, '', '2007-04-01 01:01:01', 7080, NULL),
(7090, 'Benefits', 50000, '', '2007-04-01 01:01:01', 7090, NULL),
(7150, 'Dues and Subscriptions', 50000, '', '2007-04-01 01:01:01', 7150, NULL),
(7200, 'Accounting Fees', 50000, '', '2007-04-01 01:01:01', 7200, NULL),
(7210, 'Audit Fees', 50000, '', '2007-04-01 01:01:01', 7210, NULL),
(7220, 'Banking Fees', 50000, '', '2007-04-01 01:01:01', 7220, NULL),
(7230, 'Credit Card Fees', 50000, '', '2007-04-01 01:01:01', 7230, NULL),
(7240, 'Consulting Fees', 50000, '', '2007-04-01 01:01:01', 7240, NULL),
(7260, 'Legal Fees', 50000, '', '2007-04-01 01:01:01', 7260, NULL),
(7280, 'Other Professional Fees', 50000, '', '2007-04-01 01:01:01', 7280, NULL),
(7300, 'Business Tax', 50000, '', '2007-04-01 01:01:01', 7300, NULL),
(7350, 'Property Tax', 50000, '', '2007-04-01 01:01:01', 7350, NULL),
(7390, 'Corporation Capital Tax', 50000, '', '2007-04-01 01:01:01', 7390, NULL),
(7400, 'Office Rent', 50000, '', '2007-04-01 01:01:01', 7400, NULL),
(7450, 'Equipment Rental', 50000, '', '2007-04-01 01:01:01', 7450, NULL),
(7500, 'Office Supplies', 50000, '', '2007-04-01 01:01:01', 7500, NULL),
(7600, 'Automotive Expenses', 50000, '', '2007-04-01 01:01:01', 7600, NULL),
(7610, 'Communication Expenses', 50000, '', '2007-04-01 01:01:01', 7610, NULL),
(7620, 'Insurance Expenses', 50000, '', '2007-04-01 01:01:01', 7620, NULL),
(7640, 'Miscellaneous Expenses', 50000, '', '2007-04-01 01:01:01', 7640, NULL),
(7650, 'Travel Expenses', 50000, '', '2007-04-01 01:01:01', 7650, NULL),
(7660, 'Utilities', 50000, '', '2007-04-01 01:01:01', 7660, NULL),
(7700, 'Ammortization Expenses', 50000, '', '2007-04-01 01:01:01', 7700, NULL),
(7750, 'Depreciation Expenses', 50000, '', '2007-04-01 01:01:01', 7750, NULL),
(7800, 'Interest Expense', 50000, '', '2007-04-01 01:01:01', 7800, NULL),
(7900, 'Bad Debt Expense', 50000, '', '2007-04-01 01:01:01', 7900, NULL);

UPDATE pb_accounts SET id=0 WHERE name='PLACEHOLDER';

Open Source Community Collaboration Best Practices

http://osofbiz.blogspot.com/2009/06/open-source-community-collaboration.html


The Best of Practices


The title to this article falls a little bit short of accurate... I actually only want to talk about a single best practice that seems to consistently determine whether or not an interaction with others in the community will be successful or not. The idea of this give and take is really simple, and goes back to the basic definition of collaboration:


1. the action of working with someone to produce or create something

2. traitorous cooperation with an enemy


Apache OFBiz offers a great deal of functionality, including:

  • advanced e-commerce
  • catalog management
  • promotion & pricing management
  • order management (sales & purchase)
  • customer management (part of general party management)
  • warehouse management
  • fulfillment (auto stock moves, batched pick, pack & ship)
  • accounting (invoice, payment & billing accounts, fixed assets)
  • manufacturing management
  • general work effort management (events, tasks, projects, requests, etc)
  • content management (for product content, web sites, general content, blogging, forums, etc)
  • a maturing Point Of Sales (POS) module using XUI as rich client interface
  • and much more all in an open source package!