Difference between revisions of "Car-Part.com"

From ISoft Wiki
Jump to navigationJump to search
 
(12 intermediate revisions by 3 users not shown)
Line 6: Line 6:
# Upload - pkzip
# Upload - pkzip


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


You will also need the company's car-part login info, which you can get one of the following ways:
You will also need the company's car-part login info, which you can get one of the following ways:
* In Kung Fu
* Whatever system we're currently using to store customer information
* Asking fellow ISoft Employee to see if they have a copy of login info
* 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)
* Emailing a car-part representative (Cristi at car-part dot com)
Line 16: Line 16:
(Car-part calls this "Trading Partners" to confuse you.)
(Car-part calls this "Trading Partners" to confuse you.)


Place all of the car-part files in the %systemdrive%\car-part\ directory.
{{Tip|Make sure you put the car-part directory into the root of the C drive or the Car-Part search button in ITrack WILL NOT WORK}}
Place all of the car-part search files in the '''C:\car-part\''' directory.


Run the Config.exe application:
Run the Config.exe application:
Line 30: Line 31:


{{Tip|If the customer is using Vista/Win7, and the Car-Parts Search is having problems loading - use Firefox instead.}}
{{Tip|If the customer is using Vista/Win7, and the Car-Parts Search is having problems loading - use Firefox instead.}}
{{Tip|If the Search Online button is greyed out, make sure you go to Edit --> Options --> Company Info and set the yard's type (Car + Medium Duty Truck.}}


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


#Run '''setuph.exe'''
#Grab the zip file from \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part and transfer it to the customer's computer.
#Unzip the files and make sure that pkzip is in the root of the C:\ drive. Overwrite files if prompted.
#Run '''carpart.exe'''
#Run '''carpart.exe'''
#Enter the customers login info
#Enter the customers login info
##The site name should be "compatible.car-part.com"
#*The site name should be "compatible.car-part.com"
 
You can check if the information will export correctly by opening ITrack Pro and going to 'Data Import/Export', the Export tab. When you click the 'Export to Car-Part.com' button the Car-Part application should launch and blue loading bars should briefly scroll across it. You may need to go to Edit >> Options >>General and turn on the workstation as an Auto Yard for this button to become active.


=== How It Works ===
=== How It Works ===
Line 43: Line 49:
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 numbers 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.
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 numbers 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.
====The query it runs====
<source lang="mysql">
SELECT `year`, `model`, `typenum`, `interchangenum`, `side`, `suggestedprice`, `bottomprice`, `tagnum`, LEFT(`description`, 80), `store`
FROM `inventory`
WHERE `quantity` > 0
AND `status` = 'A'
AND (`typenum` LIKE '%%0' OR (`typenum` > 99 AND `typenum` < 1000))
</source>
 
== Troubleshooting ==
* If ITrack crashes when the button for the Car-Part upload is clicked, then the issue is probably related to host.ini. In the [general] section of host.ini, find the masterdir line and set it to masterdir=.
 
== Car-Part Contact ==
When we need to speak to someone at Car-Part, we typically speak to Tammy Cavnar. The number to reach Car-part is 859-344-1925.


[[Category:Integrations]]
[[Category:Integrations]]

Latest revision as of 12:59, 19 August 2024

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:

  1. Search - car-part
  2. Upload - pkzip
Tip
The Car-Part applications are in \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part

You will also need the company's car-part login info, which you can get one of the following ways:

  • Whatever system we're currently using to store customer information
  • 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 "Trading Partners" to confuse you.)

Tip
Make sure you put the car-part directory into the root of the C drive or the Car-Part search button in ITrack WILL NOT WORK

Place all of the car-part search files in the C:\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.
Tip
If the Search Online button is greyed out, make sure you go to Edit --> Options --> Company Info and set the yard's type (Car + Medium Duty Truck.

Upload

The upload application needs to be in the %systemdrive%\pkzip\ directory.

  1. Grab the zip file from \\bunnahabhain\ITRACK\Tech Support\3rd Party Software\Car-Part and transfer it to the customer's computer.
  2. Unzip the files and make sure that pkzip is in the root of the C:\ drive. Overwrite files if prompted.
  3. Run carpart.exe
  4. Enter the customers login info
    • The site name should be "compatible.car-part.com"

You can check if the information will export correctly by opening ITrack Pro and going to 'Data Import/Export', the Export tab. When you click the 'Export to Car-Part.com' button the Car-Part application should launch and blue loading bars should briefly scroll across it. You may need to go to Edit >> Options >>General and turn on the workstation as an Auto Yard for this button to become active.

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 numbers 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.

The query it runs

SELECT `year`, `model`, `typenum`, `interchangenum`, `side`, `suggestedprice`, `bottomprice`, `tagnum`, LEFT(`description`, 80), `store` 
FROM `inventory` 
WHERE `quantity` > 0 
AND `status` = 'A' 
AND (`typenum` LIKE '%%0' OR (`typenum` > 99 AND `typenum` < 1000))

Troubleshooting

  • If ITrack crashes when the button for the Car-Part upload is clicked, then the issue is probably related to host.ini. In the [general] section of host.ini, find the masterdir line and set it to masterdir=.

Car-Part Contact

When we need to speak to someone at Car-Part, we typically speak to Tammy Cavnar. The number to reach Car-part is 859-344-1925.