ISoft Wiki - User contributions [en]

User:Bmoore

2010-08-17T15:16:17Z

Bmoore: /* Mostly Falsehoods */

== Mostly Falsehoods ==
B-Moore, who is often mysteriously referred to only as "Brad", is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right, guitars right, and boards both. B-Moore is known to be adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets (and musical instruments and languages that no one else in Nebraska knows.)

== Bold-Faced Lies ==
Psychologically, B-Moore is an INTJ with some other strange elements thrown in. Ideologically, he is an epistemic skeptic, a dualist, a soft-determinist, a hard consequentialist, and a Jesus Freak. Etymologically, his full name means "broad high wetland". Logically, there exists an X such that X is B-Moore.

== Vague Non-Information ==
Some years ago, B-Moore achieved notoriety for his involvement in the "band folder" incident. When asked to comment on the matter, he requested a moment to gather his thoughts, after which he succinctly concluded: "Your face."

== More Falsehoods ==
In the political sphere, B-Moore has established a 25+ year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that he is probably the next President of the United States of America.

== Phone Extension ==

Ext. 106

[[Category:ISoft Employees]]

User:Bmoore

2010-08-17T15:13:30Z

Bmoore: /* More Falsehoods */

== Mostly Falsehoods ==
B-Moore, who is often mysteriously referred to only as "Brad", is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right, and boards regular - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets (and musical instruments and languages that no one else in Nebraska knows.)

== Bold-Faced Lies ==
Psychologically, B-Moore is an INTJ with some other strange elements thrown in. Ideologically, he is an epistemic skeptic, a dualist, a soft-determinist, a hard consequentialist, and a Jesus Freak. Etymologically, his full name means "broad high wetland". Logically, there exists an X such that X is B-Moore.

== Vague Non-Information ==
Some years ago, B-Moore achieved notoriety for his involvement in the "band folder" incident. When asked to comment on the matter, he requested a moment to gather his thoughts, after which he succinctly concluded: "Your face."

== More Falsehoods ==
In the political sphere, B-Moore has established a 25+ year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that he is probably the next President of the United States of America.

== Phone Extension ==

Ext. 106

[[Category:ISoft Employees]]

User:Bmoore

2010-08-17T15:12:38Z

Bmoore: /* Phone Extension */

== Mostly Falsehoods ==
B-Moore, who is often mysteriously referred to only as "Brad", is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right, and boards regular - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets (and musical instruments and languages that no one else in Nebraska knows.)

== Bold-Faced Lies ==
Psychologically, B-Moore is an INTJ with some other strange elements thrown in. Ideologically, he is an epistemic skeptic, a dualist, a soft-determinist, a hard consequentialist, and a Jesus Freak. Etymologically, his full name means "broad high wetland". Logically, there exists an X such that X is B-Moore.

== Vague Non-Information ==
Some years ago, B-Moore achieved notoriety for his involvement in the "band folder" incident. When asked to comment on the matter, he requested a moment to gather his thoughts, after which he succinctly concluded: "Your face."

== More Falsehoods ==
In the political sphere, B-Moore has established a 25-year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that he is probably the next President of the United States of America.

== Phone Extension ==

Ext. 106

[[Category:ISoft Employees]]

User:Bmoore

2010-08-17T15:12:20Z

Bmoore:

== Mostly Falsehoods ==
B-Moore, who is often mysteriously referred to only as "Brad", is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right, and boards regular - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets (and musical instruments and languages that no one else in Nebraska knows.)

== Bold-Faced Lies ==
Psychologically, B-Moore is an INTJ with some other strange elements thrown in. Ideologically, he is an epistemic skeptic, a dualist, a soft-determinist, a hard consequentialist, and a Jesus Freak. Etymologically, his full name means "broad high wetland". Logically, there exists an X such that X is B-Moore.

== Vague Non-Information ==
Some years ago, B-Moore achieved notoriety for his involvement in the "band folder" incident. When asked to comment on the matter, he requested a moment to gather his thoughts, after which he succinctly concluded: "Your face."

== More Falsehoods ==
In the political sphere, B-Moore has established a 25-year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that he is probably the next President of the United States of America.

== Phone Extension ==

#106

[[Category:ISoft Employees]]

Replikwando/Installation

2010-08-10T21:38:16Z

Bmoore: /* Windows Server */

==Windows Server==

Service version of [[Replikwando]], which will backup database in case of hard drive failure in addition to updating inventory on heavytruckparts.net automatically.

-Need SSL keys from Brian

#Connect to server thru VNC
#Create Replikwando account on [http://www.heavytruckparts.net/tools/rreport.php Replikwando Records] website
#:Update Kungfu to show the new HTP account informatoin
#Download Replikwando Install pack from [http://tools.isoftdata.com tools.isoftdata.com]
#Copy certificates over to %PROGRAMFILES%\Isoft Data Systems\Certificates
#Edit Replication.ini file
##Check sqlyog that the following matches the clients:
##:Use frontend to check the username and password (like, not Duff's converter, but the "frontend" thing you can find on File)
##:[fromServer]
##:Host
##:Database
##:Username
##:Password
##:binlogpath - Should be the path to their MySQL 'data' directory
##:mysqlbinpath - Should be the path to their MySQL 'bin' directory
##Set Username and Password for [toDatabase] with same account info setup on Replikwando Records
##:Use Frontend to convert pass to hash
##:Add "Z" in front of hash
##Set database = product code (Can be found Replikwando Records)
##[ssl]
##:Set path = path to the folder where the SSL Certificates are stored
##:Set prefix = company name
##:Copy company name from certs, everything before -cert
##:Ex. for ABC-Company-cert prefix=ABC-Company
##[heartbeat]
##:Set the Process ID (for heartbeat) to the company's product code
##Set use_compression=True if the connection uses the internet, False if it's on the local network (or same machine)
#Edit my.ini file (default location %PROGRAMFILES%\MySQL\MySQL server 5.1\my.ini)
##Add the following under [mysqld]:
##:log-bin
##:expire-logs-days=10
#Stop and Start the MySQL service
#:Either
##Restart service in control panel -> Admin tools -> services
##in command prompt:
##:net stop mysql
##:net start mysql
#Set up Task Schedule to run Replikwando once after business hours.
#:Only need to set up schedule if installing during business hours so that you don't lock up clients database
#Tell Brian user and Product code so he can set up triggers on HTP.net

*Note: Replikwando will lock up the entire database during the initial push, so it may be a good idea to run it at the end of the work day.

==Linux Sever==

Replikwando on Linux using Wine

#Connect to the customer's server using sftp (it's a *nix app, may need to install Cygwin-X)
#:Do `put “Replikwando with Wine.tar.gz” .` to put the install files on their server
#:You can also put the customer's key and cert now, as well
#Connect to the customer's server using SSH/putty
#:Extract the files using `tar -zxf “Repikwando with Wine.tar.gz”`
#:If that fails, use `gunzip “Replikwando with Wine.tar.gz”`, `tar -xf “Replikwando with Wine.tar”
#You will now have two new files in your directory, replikwando_install.sh and ISoft/*
#:Type ./replikwando_install.sh
#:Depending on the system configuration, several prompts may show up. Just read them and follow what they tell you to do.
#:The script will tell you when it is done running.
#Navigate to ~/.wine/drive_c/Program\ Files/Replikwando
#:This directory will contain the error logs, sqlite file, and so on.
#:Put in the required values for replication.ini (see above)
#Type ~/replikwando_startup.sh to start Replikwando for the first time.
#:Confirm that Replikwando is running correctly using the error logs here
#:Type `vi <filename>` to open the file in an editor to read it. Type :q<enter> to quit.
#To connect to the mysql server, type `mysql -utestuser -hlocalhost -p`
#:You'll have to type a 'use <database>' command before running queries
#Once Replikwando is confirmed running, type `sudo vi /etc/rc.local` and place the following lines just above the last line that says 'exit 0':
# start replikwando
#sudo -H -u isoft /home/isoft/replikwando_startup.sh
#Done!
<br>
*Some quick tips:<br>
Quick linux commands:
:ls : shows you what is in the directory
:sudo : lets you run powerful & dangerous commands (requires password)
:cd : change directory
:rm : deletes a file (use rm -r to delete a folder)
:deletes cannot be undone!
:You can't open Replikwando's UI to see if it's pushing data, so you have to rely on the error logs and test database changes.
:All normal Replikwando caveats apply (initial push db lock, query error logs, so on so forth)

After the initial push, be sure to copy over functions and stored procedures as necessary, as replikwando doesn't do this automatically.

If you have any additional questions, ask Justin.

[[Category:Replikwando]]
[[Category:HeavyTruckParts.net]]
[[Category:ITrack/Support]]

Replikwando/Installation

2010-08-10T21:37:22Z

Bmoore: /* Windows Server */

==Windows Server==

Service version of [[Replikwando]], which will backup database in case of hard drive failure in addition to updating inventory on heavytruckparts.net automatically.

-Need SSL keys from Brian

#Connect to server thru VNC
#Create Replikwando account on [http://www.heavytruckparts.net/tools/rreport.php Replikwando Records] website
#:Update Kungfu to show the new HTP account informatoin
#Download Replikwando Install pack from [http://tools.isoftdata.com tools.isoftdata.com]
#Copy certificates over to %PROGRAMFILES%\Isoft Data Systems\Certificates
#Edit Replication.ini file
##Check sqlyog that the following matches the clients:
##:Use frontend to check the username and password (like, not Duff's converter, but the thing you can find on File)
##:[fromServer]
##:Host
##:Database
##:Username
##:Password
##:binlogpath - Should be the path to their MySQL 'data' directory
##:mysqlbinpath - Should be the path to their MySQL 'bin' directory
##Set Username and Password for [toDatabase] with same account info setup on Replikwando Records
##:Use Frontend to convert pass to hash
##:Add "Z" in front of hash
##Set database = product code (Can be found Replikwando Records)
##[ssl]
##:Set path = path to the folder where the SSL Certificates are stored
##:Set prefix = company name
##:Copy company name from certs, everything before -cert
##:Ex. for ABC-Company-cert prefix=ABC-Company
##[heartbeat]
##:Set the Process ID (for heartbeat) to the company's product code
##Set use_compression=True if the connection uses the internet, False if it's on the local network (or same machine)
#Edit my.ini file (default location %PROGRAMFILES%\MySQL\MySQL server 5.1\my.ini)
##Add the following under [mysqld]:
##:log-bin
##:expire-logs-days=10
#Stop and Start the MySQL service
#:Either
##Restart service in control panel -> Admin tools -> services
##in command prompt:
##:net stop mysql
##:net start mysql
#Set up Task Schedule to run Replikwando once after business hours.
#:Only need to set up schedule if installing during business hours so that you don't lock up clients database
#Tell Brian user and Product code so he can set up triggers on HTP.net

*Note: Replikwando will lock up the entire database during the initial push, so it may be a good idea to run it at the end of the work day.

==Linux Sever==

Replikwando on Linux using Wine

#Connect to the customer's server using sftp (it's a *nix app, may need to install Cygwin-X)
#:Do `put “Replikwando with Wine.tar.gz” .` to put the install files on their server
#:You can also put the customer's key and cert now, as well
#Connect to the customer's server using SSH/putty
#:Extract the files using `tar -zxf “Repikwando with Wine.tar.gz”`
#:If that fails, use `gunzip “Replikwando with Wine.tar.gz”`, `tar -xf “Replikwando with Wine.tar”
#You will now have two new files in your directory, replikwando_install.sh and ISoft/*
#:Type ./replikwando_install.sh
#:Depending on the system configuration, several prompts may show up. Just read them and follow what they tell you to do.
#:The script will tell you when it is done running.
#Navigate to ~/.wine/drive_c/Program\ Files/Replikwando
#:This directory will contain the error logs, sqlite file, and so on.
#:Put in the required values for replication.ini (see above)
#Type ~/replikwando_startup.sh to start Replikwando for the first time.
#:Confirm that Replikwando is running correctly using the error logs here
#:Type `vi <filename>` to open the file in an editor to read it. Type :q<enter> to quit.
#To connect to the mysql server, type `mysql -utestuser -hlocalhost -p`
#:You'll have to type a 'use <database>' command before running queries
#Once Replikwando is confirmed running, type `sudo vi /etc/rc.local` and place the following lines just above the last line that says 'exit 0':
# start replikwando
#sudo -H -u isoft /home/isoft/replikwando_startup.sh
#Done!
<br>
*Some quick tips:<br>
Quick linux commands:
:ls : shows you what is in the directory
:sudo : lets you run powerful & dangerous commands (requires password)
:cd : change directory
:rm : deletes a file (use rm -r to delete a folder)
:deletes cannot be undone!
:You can't open Replikwando's UI to see if it's pushing data, so you have to rely on the error logs and test database changes.
:All normal Replikwando caveats apply (initial push db lock, query error logs, so on so forth)

After the initial push, be sure to copy over functions and stored procedures as necessary, as replikwando doesn't do this automatically.

If you have any additional questions, ask Justin.

[[Category:Replikwando]]
[[Category:HeavyTruckParts.net]]
[[Category:ITrack/Support]]

ITrack/Installation

2010-04-14T19:20:13Z

Bmoore: /* Installing ITrack */

This guide will help you setup ITrack for a new user. It is meant for both Pro and Enterprise.

==Server Side==
===MySQL Installation===
{{Tip| Server side setups only need to be completed for new customers}}
#Download [http://tools.isoftdata.com/mysql-essential-5.0.24-win32.msi MySQL 5.0 from dl.isoftdata.com]
#Install [http://en.wikipedia.org/wiki/Mysql MySQL]
#Run the MySQL Server Instance Configuration Wizard
##Detailed Configuration
##Developer Machine
##Non-Transactional Database Only
##Uncheck "Enable Strict Mode" and check "Add firewall exception"
#Check to make sure port 3306 is allowed in any [http://en.wikipedia.org/wiki/Firewall firewall] that may exist
===Database Setup===
#[http://tools.isoftdata.com/SQLyog814.exe Download and Install SQLyog]
#Run the SQL scripts in [http://en.wikipedia.org/wiki/Subversion_(software) SVN] to create/populate/update the database
#Run the scripts in this order:
##Clean Pro Database
##Update
##Reports
#Create a directory somewhere and share it so that everyone has read/write privileges
##Create Reports, Images and Attachments sub directories
##Copy the latest reports from SVN to the reports directory
===And Don't forget===
#[[HeavyTruckParts.net/How to install Image Uploader|Setup the Image Uploader]]
#[[Replikwando/Installation|Setup Replikwando]]

==Client Side==
===Installing ITrack===
# Download the ITrack installer for the specific product
## [http://dl.isoftdata.com/ITrack%20Pro%20Truck%20Installer%209.1.7351b.exe ITrack Pro Installer (HT)]
## [http://dl.isoftdata.com/ITrack%20Pro%20Car%20Installer%209.1.7351b.exe ITrack Pro Installer (Auto)]
## [http://dl.isoftdata.com/ITrack%20Enterprise%20Installer.exe ITrack Enterprise Installer]
# Run the Installer
# The setup program will install the following:
## ITrack
## Crystal 11
## PDF Creator
## MySQL ODBC connection
## Instant VNC
## ITrack Registration
#Durring the installation of PDF Creator you do '''NOT''' need to put an icon on the desktop. Also, when the installer for PDF Creator finishes, there is no need to restart the computer.
# You will need to generate a code using the pseudo-random Code Generator which is available in SVN: ITrack/General/CodeGenerator/CodeGenerator.html
##'''You will need to remember the product code for later'''
## If you have access to the right server, it would also be both polite and smart of you to check the isoftupdates DB in SQLYog, and make sure that this product code has not already been taken. Although unlikely, it occurs more often than you would think (hence the term "pseudo-random"). Whenever it does occur - it causes big headaches for the poor support person who has to deal with that.

===Configuration===
# Open up the directory where ITrack is installed
# Open the host.ini file with a text editor
# In the database section set hostname equal to the name of the server
##The server name can be found by doing a customer search on [http://kungfu.isoftdata.com/ Kung Fu].
# In the general section set the reportsdir, imagesdir, and attachdir to their corresponding directory created on the server (see step 7.1 in the "Server Side" section)
##Go to my computer and type the name of the server into the address bar, preceded by two backslashes (''\\<server name>'')
##This will allow you to find what the directories are called
# Put the computer in the [http://isoftdata.com/autoupdate/Auto Update System]
## Add a new customer
# Turn on updates for this computer
## Go to Manage Customers
## Select the computer that you are working on (the company, then the same name as your VNC Connection)
## '''When installing Pro''' - select all of the updates '''EXCEPT''' Master Test, New Update Test, and QB Extension List.
## '''When installing Enterprise''' - select all of the appropriate extensions. For example, if you are installing ITrack for a customer who doesn't need the QuickBooks extension... don't select the QuickBooks extension. This section is being rapidly changed/updated at the moment, but using common sense will help you get the job done.
# Launch ITrack
# Confirm that it downloads the latest updates
# Restart ITrack
# Setup the [[ITrack/ODBC|MySQL ODBC Connector]]
# Pat yourself on the back

Note: If you want to run ITrack with a different configuration file, create a shortcut and change "Target" in its properties to have a -i configfile at the end (where configfile is the name of the new configuration file). Example: "C:\Program Files\ISoft Data Systems\ITrack Pro\itrack.exe" -i host2.ini

ITrack/Installation

2010-04-14T19:18:34Z

Bmoore: /* Installing ITrack */

This guide will help you setup ITrack for a new user. It is meant for both Pro and Enterprise.

==Server Side==
===MySQL Installation===
{{Tip| Server side setups only need to be completed for new customers}}
#Download [http://tools.isoftdata.com/mysql-essential-5.0.24-win32.msi MySQL 5.0 from dl.isoftdata.com]
#Install [http://en.wikipedia.org/wiki/Mysql MySQL]
#Run the MySQL Server Instance Configuration Wizard
##Detailed Configuration
##Developer Machine
##Non-Transactional Database Only
##Uncheck "Enable Strict Mode" and check "Add firewall exception"
#Check to make sure port 3306 is allowed in any [http://en.wikipedia.org/wiki/Firewall firewall] that may exist
===Database Setup===
#[http://tools.isoftdata.com/SQLyog814.exe Download and Install SQLyog]
#Run the SQL scripts in [http://en.wikipedia.org/wiki/Subversion_(software) SVN] to create/populate/update the database
#Run the scripts in this order:
##Clean Pro Database
##Update
##Reports
#Create a directory somewhere and share it so that everyone has read/write privileges
##Create Reports, Images and Attachments sub directories
##Copy the latest reports from SVN to the reports directory
===And Don't forget===
#[[HeavyTruckParts.net/How to install Image Uploader|Setup the Image Uploader]]
#[[Replikwando/Installation|Setup Replikwando]]

==Client Side==
===Installing ITrack===
# Download the ITrack installer for the specific product
## [http://dl.isoftdata.com/ITrack%20Pro%20Truck%20Installer%209.1.7351b.exe ITrack Pro Installer (HT)]
## [http://dl.isoftdata.com/ITrack%20Pro%20Car%20Installer%209.1.7351b.exe ITrack Pro Installer (Auto)]
## [http://dl.isoftdata.com/ITrack%20Enterprise%20Installer.exe ITrack Enterprise Installer]
# Run the Installer
# The setup program will install the following:
## ITrack
## Crystal 11
## PDF Creator
## MySQL ODBC connection
## Instant VNC
## ITrack Registration
#Durring the installation of PDF Creator you do '''NOT''' need to put an icon on the desktop. Also, when the installer for PDF Creator finishes, there is no need to restart the computer.
# You will need to generate a code using the Code Generator which is available in SVN: ITrack/General/CodeGenerator/CodeGenerator.html
##'''You will need to remember the product code for later'''
## If you have access to the right server, it would also be both polite and smart of you to check the isoftupdates DB in SQLYog, and make sure that this product code has not already been taken. Although unlikely, it occurs more often than you would think. Whenever it does occur - it causes big headaches for the poor support person who has to deal with that.

===Configuration===
# Open up the directory where ITrack is installed
# Open the host.ini file with a text editor
# In the database section set hostname equal to the name of the server
##The server name can be found by doing a customer search on [http://kungfu.isoftdata.com/ Kung Fu].
# In the general section set the reportsdir, imagesdir, and attachdir to their corresponding directory created on the server (see step 7.1 in the "Server Side" section)
##Go to my computer and type the name of the server into the address bar, preceded by two backslashes (''\\<server name>'')
##This will allow you to find what the directories are called
# Put the computer in the [http://isoftdata.com/autoupdate/Auto Update System]
## Add a new customer
# Turn on updates for this computer
## Go to Manage Customers
## Select the computer that you are working on (the company, then the same name as your VNC Connection)
## '''When installing Pro''' - select all of the updates '''EXCEPT''' Master Test, New Update Test, and QB Extension List.
## '''When installing Enterprise''' - select all of the appropriate extensions. For example, if you are installing ITrack for a customer who doesn't need the QuickBooks extension... don't select the QuickBooks extension. This section is being rapidly changed/updated at the moment, but using common sense will help you get the job done.
# Launch ITrack
# Confirm that it downloads the latest updates
# Restart ITrack
# Setup the [[ITrack/ODBC|MySQL ODBC Connector]]
# Pat yourself on the back

Note: If you want to run ITrack with a different configuration file, create a shortcut and change "Target" in its properties to have a -i configfile at the end (where configfile is the name of the new configuration file). Example: "C:\Program Files\ISoft Data Systems\ITrack Pro\itrack.exe" -i host2.ini

ITrack/Installation

2010-04-14T19:18:02Z

Bmoore: /* Installing ITrack */

This guide will help you setup ITrack for a new user. It is meant for both Pro and Enterprise.

==Server Side==
===MySQL Installation===
{{Tip| Server side setups only need to be completed for new customers}}
#Download [http://tools.isoftdata.com/mysql-essential-5.0.24-win32.msi MySQL 5.0 from dl.isoftdata.com]
#Install [http://en.wikipedia.org/wiki/Mysql MySQL]
#Run the MySQL Server Instance Configuration Wizard
##Detailed Configuration
##Developer Machine
##Non-Transactional Database Only
##Uncheck "Enable Strict Mode" and check "Add firewall exception"
#Check to make sure port 3306 is allowed in any [http://en.wikipedia.org/wiki/Firewall firewall] that may exist
===Database Setup===
#[http://tools.isoftdata.com/SQLyog814.exe Download and Install SQLyog]
#Run the SQL scripts in [http://en.wikipedia.org/wiki/Subversion_(software) SVN] to create/populate/update the database
#Run the scripts in this order:
##Clean Pro Database
##Update
##Reports
#Create a directory somewhere and share it so that everyone has read/write privileges
##Create Reports, Images and Attachments sub directories
##Copy the latest reports from SVN to the reports directory
===And Don't forget===
#[[HeavyTruckParts.net/How to install Image Uploader|Setup the Image Uploader]]
#[[Replikwando/Installation|Setup Replikwando]]

==Client Side==
===Installing ITrack===
# Download the ITrack installer for the specific product
## [http://dl.isoftdata.com/ITrack%20Pro%20Truck%20Installer%209.1.7351b.exe ITrack Pro Installer (HT)]
## [http://dl.isoftdata.com/ITrack%20Pro%20Car%20Installer%209.1.7351b.exe ITrack Pro Installer (Auto)]
## [http://dl.isoftdata.com/ITrack%20Enterprise%20Installer.exe ITrack Enterprise Installer]
# Run the Installer
# The setup program will install the following:
## ITrack
## Crystal 11
## PDF Creator
## MySQL ODBC connection
## Instant VNC
## ITrack Registration
#Durring the installation of PDF Creator you do '''NOT''' need to put an icon on the desktop. Also, when the installer for PDF Creator finishes, there is no need to restart the computer.
# You will need to generate a code using the Code Generator which is available in SVN: ITrack/General/CodeGenerator/CodeGenerator.html
##'''You will need to remember the product code for later'''
## If you have access to the right server, it would also be both polite and smart of you to check the isoftupdates DB in SQLYog, and make sure that this product code has not already been taken. Although unlikely, it occurs more often than you would think; and whenever it does - it causes big headaches for the poor support person who has to deal with that.

===Configuration===
# Open up the directory where ITrack is installed
# Open the host.ini file with a text editor
# In the database section set hostname equal to the name of the server
##The server name can be found by doing a customer search on [http://kungfu.isoftdata.com/ Kung Fu].
# In the general section set the reportsdir, imagesdir, and attachdir to their corresponding directory created on the server (see step 7.1 in the "Server Side" section)
##Go to my computer and type the name of the server into the address bar, preceded by two backslashes (''\\<server name>'')
##This will allow you to find what the directories are called
# Put the computer in the [http://isoftdata.com/autoupdate/Auto Update System]
## Add a new customer
# Turn on updates for this computer
## Go to Manage Customers
## Select the computer that you are working on (the company, then the same name as your VNC Connection)
## '''When installing Pro''' - select all of the updates '''EXCEPT''' Master Test, New Update Test, and QB Extension List.
## '''When installing Enterprise''' - select all of the appropriate extensions. For example, if you are installing ITrack for a customer who doesn't need the QuickBooks extension... don't select the QuickBooks extension. This section is being rapidly changed/updated at the moment, but using common sense will help you get the job done.
# Launch ITrack
# Confirm that it downloads the latest updates
# Restart ITrack
# Setup the [[ITrack/ODBC|MySQL ODBC Connector]]
# Pat yourself on the back

Note: If you want to run ITrack with a different configuration file, create a shortcut and change "Target" in its properties to have a -i configfile at the end (where configfile is the name of the new configuration file). Example: "C:\Program Files\ISoft Data Systems\ITrack Pro\itrack.exe" -i host2.ini

ITrack/Installation

2010-04-14T19:16:44Z

Bmoore: /* Installing ITrack */

This guide will help you setup ITrack for a new user. It is meant for both Pro and Enterprise.

==Server Side==
===MySQL Installation===
{{Tip| Server side setups only need to be completed for new customers}}
#Download [http://tools.isoftdata.com/mysql-essential-5.0.24-win32.msi MySQL 5.0 from dl.isoftdata.com]
#Install [http://en.wikipedia.org/wiki/Mysql MySQL]
#Run the MySQL Server Instance Configuration Wizard
##Detailed Configuration
##Developer Machine
##Non-Transactional Database Only
##Uncheck "Enable Strict Mode" and check "Add firewall exception"
#Check to make sure port 3306 is allowed in any [http://en.wikipedia.org/wiki/Firewall firewall] that may exist
===Database Setup===
#[http://tools.isoftdata.com/SQLyog814.exe Download and Install SQLyog]
#Run the SQL scripts in [http://en.wikipedia.org/wiki/Subversion_(software) SVN] to create/populate/update the database
#Run the scripts in this order:
##Clean Pro Database
##Update
##Reports
#Create a directory somewhere and share it so that everyone has read/write privileges
##Create Reports, Images and Attachments sub directories
##Copy the latest reports from SVN to the reports directory
===And Don't forget===
#[[HeavyTruckParts.net/How to install Image Uploader|Setup the Image Uploader]]
#[[Replikwando/Installation|Setup Replikwando]]

==Client Side==
===Installing ITrack===
# Download the ITrack installer for the specific product
## [http://dl.isoftdata.com/ITrack%20Pro%20Truck%20Installer%209.1.7351b.exe ITrack Pro Installer (HT)]
## [http://dl.isoftdata.com/ITrack%20Pro%20Car%20Installer%209.1.7351b.exe ITrack Pro Installer (Auto)]
## [http://dl.isoftdata.com/ITrack%20Enterprise%20Installer.exe ITrack Enterprise Installer]
# Run the Installer
# The setup program will install the following:
## ITrack
## Crystal 11
## PDF Creator
## MySQL ODBC connection
## Instant VNC
## ITrack Registration
#Durring the installation of PDF Creator you do '''NOT''' need to put an icon on the desktop. Also, when the installer for PDF Creator finishes, there is no need to restart the computer.
# You will need to generate a code using the Code Generator which is available in SVN: ITrack/General/CodeGenerator/CodeGenerator.html
##'''You will need to remember the product code for later'''
## It would also be both polite and smart of you to check the isoftupdates DB in SQLYog, and make sure that this product code has not already been taken. Although unlikely, it occurs more often than you would think; and whenever it does - it causes big headaches for the poor support person who has to deal with that.

===Configuration===
# Open up the directory where ITrack is installed
# Open the host.ini file with a text editor
# In the database section set hostname equal to the name of the server
##The server name can be found by doing a customer search on [http://kungfu.isoftdata.com/ Kung Fu].
# In the general section set the reportsdir, imagesdir, and attachdir to their corresponding directory created on the server (see step 7.1 in the "Server Side" section)
##Go to my computer and type the name of the server into the address bar, preceded by two backslashes (''\\<server name>'')
##This will allow you to find what the directories are called
# Put the computer in the [http://isoftdata.com/autoupdate/Auto Update System]
## Add a new customer
# Turn on updates for this computer
## Go to Manage Customers
## Select the computer that you are working on (the company, then the same name as your VNC Connection)
## '''When installing Pro''' - select all of the updates '''EXCEPT''' Master Test, New Update Test, and QB Extension List.
## '''When installing Enterprise''' - select all of the appropriate extensions. For example, if you are installing ITrack for a customer who doesn't need the QuickBooks extension... don't select the QuickBooks extension. This section is being rapidly changed/updated at the moment, but using common sense will help you get the job done.
# Launch ITrack
# Confirm that it downloads the latest updates
# Restart ITrack
# Setup the [[ITrack/ODBC|MySQL ODBC Connector]]
# Pat yourself on the back

Note: If you want to run ITrack with a different configuration file, create a shortcut and change "Target" in its properties to have a -i configfile at the end (where configfile is the name of the new configuration file). Example: "C:\Program Files\ISoft Data Systems\ITrack Pro\itrack.exe" -i host2.ini

ITrack/Enterprise/Work Orders

2010-03-09T15:46:13Z

Bmoore: /* Master Part */

Work orders in [[ITrack Enterprise]] are a document that encompasses several core processes, which are divided into [[#Work Order Types|work order types]].

==Work Order Processes==
* Inventory rebuild/repair/remanufacture: this type of WO is designed to take parts, labor, and possibly a dirty core and create a new inventory item or increase the quantity of an existing inventory item. These processes are facilitated by the 'work on inventory' work order type. WOs of these types are usually priced at cost.
* Customer repair/rebuild: these types of WOs are designed for doing work on customers' units. They do not add value to inventory, they usually have an invoice associated with them to pass cost on to the customer, and they usually incorporate price markups.

==Work Order Parameters==
Each work order has many parameters and values that define its purpose and impact in the system. Most of these values can be saved into easy to use [[#Work Order Templates|templates]] to help avoid needing to reenter common data for each work order.

===Work Order Types===
Work order types are a named sets of data that describe defaults and parameters of work orders. All work orders have a work order type, and the list of types is user editable. Listed here are some of the more important work order parameters that can be set in a type:

* Name: a name defined by the user that should be useful and understandable by users. It describes the report type.
* Report: the type of report that should be printed for all work orders of this type.
* Work on inventory/work on customer unit: this is a very important field that defines which process work orders of this type are designed to perform. Work on inventory WOs create new stock or add value to existing stock, and all WOs of this type have a [[#Master Part|master part record]]. Work on customer unit WOs instead represent work done at the behest of a customer, and have a customer and customer unit associated with them. When finalized, WOs of this type are associated with an invoice to the specified customer.
* GL Defaults: specifies a default GL Department and GL Category for jobs on the WO. The category is used for the labor accounting.
* Part pricing defaults: these values allow the user to specify pricing methods and price markups for items on the WO.
** Cost: this pricing method uses part and labor cost to specify the work order price and the job prices.
** Customer: uses the customer pricing matrix of the customer on the WO.
** Markup: allows manual specification of a pricing level markup for prices on the WO.

==Work Order Components==
===Master Part===

This is the part that a work order is "done to". For example, if the work order is of a type that involves a customer unit - and that unit is NOT a misc. unit (i.e. it's a specific customer unit that you prefer to have regulated info about) - there will be a button near the upper left corner of your screen that lets you add/edit the customer unit which you are working on. On the other hand, if the current work order is of a type that must involve an item from inventory instead, that same button will take you to the search screen where you can select the part you have in mind.

===Jobs===

===Job Parts===

===Tasks===

===Labor===
* Labor is written to using either dotted form (1.5 is 1h30m) or clock form (1:30 is 1h30m).

==Work Order Templates==

[[Category:ITrack/Enterprise/Extensions]]

Car-Part.com

2010-03-01T18:46:59Z

Bmoore: /* How It Works */

[http://www.Car-Part.com Car-Part.com] is a company that runs a web site which indexes car parts for car yards across the US.

== Software ==
Car-Part.com distributes software that allows ITrack users to export parts from ITrack to Car-Part.com, as well as to search the Car-Part.com database from ITrack. So there are two main parts to Car-Part:
# Search - car-part
# Upload - pkzip

{{Tip|The Car-Part applications are in the 'ITrack - Tech Support - 3rd Party Software' directory on File.}}

You will also need the company's car-part login info, which you can get one of the following ways:
* In Kung Fu
* Asking fellow ISoft Employee to see if they have a copy of login info
* Emailing a car-part representative (Cristi at car-part dot com)

=== Search ===
(Car-part calls this "fkey" to confuse you.)

Place all of the car-part files in the %systemdrive%\car-part\ directory.

Run the Config.exe application:
* In the '''Inventory Management System''' drop down menu select '''ISoft'''
* Enter the Username, Password, and Site information that has been provided for you.
** The site name is usually something like: '''trade<some_number>.car-part.com'''
* The other fields are not required
* Save the Settings

Run '''windows_update_fix.reg'''

When a user clicks the car-part button on the search screen of ITrack, it launches this app. ITrack passes in the search criteria and the car-part app launches the search in their web browser.

{{Tip|If the customer is using Vista/Win7, and the Car-Parts Search is having problems loading - use Firefox instead.}}

=== Upload ===
The upload application needs to be in the %systemdrive%\pkzip\ directory, setuph.exe will put the files there for you.

#Run '''setuph.exe'''
#Run '''carpart.exe'''
#Enter the customers login info
##The site name should be isoft.car-part.com

=== How It Works ===

Car-part grabs inventory from ITrack based on interchange number, make and model, and maybe (or maybe not) a few more things. If the interchange number were wrong, Duff and Brad are fairly sure that would NOT cause the export to fail outright - it would just make stuff not show up on car-part.

There is no way to search around inside an ITrack database for stuff that is hanging around in ITrack but not showing up on car-part for whatever reason. That's because we really don't have access to car-part's tables - there's just a tool they made that knows how to access ours.

Car-Part.com

2010-03-01T18:46:30Z

Bmoore:

[http://www.Car-Part.com Car-Part.com] is a company that runs a web site which indexes car parts for car yards across the US.

== Software ==
Car-Part.com distributes software that allows ITrack users to export parts from ITrack to Car-Part.com, as well as to search the Car-Part.com database from ITrack. So there are two main parts to Car-Part:
# Search - car-part
# Upload - pkzip

{{Tip|The Car-Part applications are in the 'ITrack - Tech Support - 3rd Party Software' directory on File.}}

You will also need the company's car-part login info, which you can get one of the following ways:
* In Kung Fu
* Asking fellow ISoft Employee to see if they have a copy of login info
* Emailing a car-part representative (Cristi at car-part dot com)

=== Search ===
(Car-part calls this "fkey" to confuse you.)

Place all of the car-part files in the %systemdrive%\car-part\ directory.

Run the Config.exe application:
* In the '''Inventory Management System''' drop down menu select '''ISoft'''
* Enter the Username, Password, and Site information that has been provided for you.
** The site name is usually something like: '''trade<some_number>.car-part.com'''
* The other fields are not required
* Save the Settings

Run '''windows_update_fix.reg'''

When a user clicks the car-part button on the search screen of ITrack, it launches this app. ITrack passes in the search criteria and the car-part app launches the search in their web browser.

{{Tip|If the customer is using Vista/Win7, and the Car-Parts Search is having problems loading - use Firefox instead.}}

=== Upload ===
The upload application needs to be in the %systemdrive%\pkzip\ directory, setuph.exe will put the files there for you.

#Run '''setuph.exe'''
#Run '''carpart.exe'''
#Enter the customers login info
##The site name should be isoft.car-part.com

=== How It Works ===

Car-part grabs inventory from ITrack based on interchange number, make and model, and maybe (or maybe not) a few more things. If the interchange number were wrong, Duff and Brad are fairly sure that would NOT cause the export to fail outright - it would just make stuff not show up on car-part.

There is no way to search around inside an ITrack database for stuff that is hanging around in ITrack but not showing up on Car-Part for whatever reason. That's because we really don't have access to Car-Part's tables - there's just a tool they made that knows how to access ours.

Leprechaun

2009-12-28T19:34:42Z

Bmoore:

[[Image:Leprechaun.jpg|thumb|center|http://chaosmerchant.files.wordpress.com/2007/09/leprechaun.jpg]]

'''Oftentimes, when a mysterious problem occurs on ITrack it is the result of leprechauns. They use their mystical leprechauny abilities to screw with both ISoft computer programs and ISoft employees.'''

'''Although they are not generally quite as bothersome as [[Gremlins]], Leprechauns are still more prone to mischief than [[Magical Elves]] and should not be taken lightly. They are often armed and extremely dangerous.'''

Leprechaun

2009-12-28T19:33:32Z

Bmoore:

[[Image:Leprechaun.jpg|thumb|center|http://chaosmerchant.files.wordpress.com/2007/09/leprechaun.jpg]]

'''Oftentimes, when a mysterious problem occurs on ITrack it is the result of leprechauns. They use their mystical leprechauny abilities to screw with both ISoft computer programs and ISoft employees.'''

'''Although they are not generally quite as bothersome as [[gremlins]], leprechauns are still more prone to mischief than [[magical elves]] and should not be taken lightly. They are often armed and extremely dangerous.'''

ITrack/Crystal Reports Dos Error

2008-12-22T16:43:32Z

Bmoore: New page: A "Dos Error" is reported by Crystal when trying to print a report. ==Cause== This error most often occurs because ITrack is set to look for a reports directory in the wrong place. ==Sol...

A "Dos Error" is reported by Crystal when trying to print a report.

==Cause==
This error most often occurs because ITrack is set to look for a reports directory in the wrong place.

==Solution==
Make sure the report directory is valid (you can find it in the [[Options_Extension_(Enterprise)|Options]], on the General tab). Try opening the folder to make sure that it is a valid and correct path - and change it if necessary.

[[Category:Printing Error Messages (ITrack)]]
[[Category:Error Messages (ITrack)]]

ITrack/Enterprise/Options Extension

2008-11-20T15:25:14Z

Bmoore:

Many options (company wide and computer-specific) can be changed one place - the options dialog, which you can open by clicking the Edit menu at the top of ITrack and choosing "Options."

==General Tab==
===Server IP address===
The address of the ITrack database server.

===Directories===
The image and attachments directories are where images and attachments are saved on your computer.

The reports directory is where ITrack looks for the report files when printing.

Generally, these directories are pointed at a common location on a shared server.

==Printers Tab==
This tab allows you to choose what printers ITrack will use to print out various reports, such as sales orders and billing reports. All of these options are computer-specific, except for the Invoice Memo, which is a store-wide setting.

[[Image:Enterprise Options (Printers).JPG|right|thumb]]

===Printer Type===
Every report in ITrack has a printer type. Most of them should be self-explanatory - sales orders default to printing out on the Sales Order printer. Reports that are not obvious are usually filed under the general "Report" type.

===Changing Printers===
To change the printer for a type, simply pick the printer from the "Printer Name" dropdown. This list of printers will be the same list you see in your Windows Printers.

===Copies Per Invoice===
By changing this number, you can determine how many copies of your Sales Order will print out when you finalize (close) an invoice.

===Invoice Memo===
This text is printed at the bottom of every sales order report. This setting is store-wide, and affects everybody at your store.

[[Category:Enterprise Extensions]]
[[Category:Pro Extensions]]

ITrack/Reports print out with wrong size or orientation

2008-11-20T15:17:51Z

Bmoore: /* Cause */

Sometimes a report will print out successfully, but will print landscape instead of portrait (or vice versa) or will not fit on the page correctly.

==Cause==
Something must be wrong with the page layout (or size) in either Windows or Crystal.

==Solution==

1. Check to make sure all the settings for your printer are correct. (Find the printer in Windows, go into its properties, look at the margins, page setup, orientation, etc.) This is most often the culprit. To double-check that everything is set correctly, try comparing your printer's settings against another printer that you already know prints things out how they *should* be printed out.

2. If everything is set correctly in Windows and you are still experiencing problems, then it is probably an issue with the Crystal report or (more likely) the report's width/height/orientation settings in the database. Please contact ISoft and ask us to take a look at this issue.

[[Category:Problems (ITrack)]]

ITrack/Reports print out with wrong size or orientation

2008-11-20T15:17:15Z

Bmoore: /* Cause */

Sometimes a report will print out successfully, but will print landscape instead of portrait (or vice versa) or will not fit on the page correctly.

==Cause==
Something must be wrong with the page layout in either Windows or Crystal.

==Solution==

1. Check to make sure all the settings for your printer are correct. (Find the printer in Windows, go into its properties, look at the margins, page setup, orientation, etc.) This is most often the culprit. To double-check that everything is set correctly, try comparing your printer's settings against another printer that you already know prints things out how they *should* be printed out.

2. If everything is set correctly in Windows and you are still experiencing problems, then it is probably an issue with the Crystal report or (more likely) the report's width/height/orientation settings in the database. Please contact ISoft and ask us to take a look at this issue.

[[Category:Problems (ITrack)]]

ITrack/Reports print out with wrong size or orientation

2008-11-20T15:15:37Z

Bmoore: /* Solution */

Sometimes a report will print out successfully, but will print landscape instead of portrait (or vice versa) or will not fit on the page correctly.

==Cause==
Either
* Crystal thinks that the page is the wrong size.
* Windows thinks that the page is the wrong size.

==Solution==

1. Check to make sure all the settings for your printer are correct. (Find the printer in Windows, go into its properties, look at the margins, page setup, orientation, etc.) This is most often the culprit. To double-check that everything is set correctly, try comparing your printer's settings against another printer that you already know prints things out how they *should* be printed out.

2. If everything is set correctly in Windows and you are still experiencing problems, then it is probably an issue with the Crystal report or (more likely) the report's width/height/orientation settings in the database. Please contact ISoft and ask us to take a look at this issue.

[[Category:Problems (ITrack)]]

User:Bmoore

2008-10-20T19:11:56Z

Bmoore:

[[Category:ISoft Employees]]

B-Moore, who is often mysteriously referred to only as "Brad", is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right, and boards regular - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets (and musical instruments and languages that no one else in Nebraska knows.)

Psychologically, B-Moore is an INTJ with some other strange elements thrown in. Ideologically, he is an epistemic skeptic, a dualist, a soft-determinist, a hard consequentialist, and a Jesus Freak. Etymologically, his full name means "broad high wetland". Logically, there exists an X such that X is B-Moore.

Some years ago, B-Moore achieved notoriety for his involvement in the "band folder" incident. When asked to comment on the matter, he requested a moment to gather his thoughts, after which he succinctly concluded: "Your face."

In the political sphere, B-Moore has established a 25-year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that he is probably the next President of the United States of America.

User:Bmoore

2008-10-20T18:49:33Z

Bmoore:

User:Bmoore

2008-10-20T18:47:01Z

Bmoore:

[[Category:ISoft Employees]]

B-Moore is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets.

In the political sphere, B-Moore has established a 25-year track record of consistently supporting the general coolness. Running on this platform, recent poll results indicate that B-Moore is probably the next President of the United States of America.

User:Bmoore

2008-10-20T18:45:36Z

Bmoore:

[[Category:ISoft Employees]]

B-Moore is a 6'3" male from rural Nebraska. He bats left, throws left, shoots right - and is rather adept at throwing knives, playing tubas, speaking Portuguese, and other vitally important skill sets.

In the political sphere, B-Moore has established a 25-year track record of consistently supporting the general coolness. Running on this platform, recent polls indicate that B-Moore is probably the next President of the United States of America.