User Tools

Site Tools


do_it_best_setup

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
do_it_best_setup [2015/04/08 07:55 (9 years ago)] swinddo_it_best_setup [2021/05/11 21:42 (3 years ago)] (current) – [Do It Best Integration] plagrada
Line 1: Line 1:
 ====== Do It Best Integration ====== ====== Do It Best Integration ======
  
-[[http://wws5.com/|{{http://wws5.com/images/topxxxgif-ani.gif  |Windward Software}}]] 
  
  
Line 7: Line 6:
  
 ====== Preliminary System Five Setup ====== ====== Preliminary System Five Setup ======
 +  * [[ftp://ftp.windward-ca.com/pub/special/doitbest.zip]] (Added 2015-07-17,cm)
  
-You will need to create the Do It Best supplier account before doing anything else.+Extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder. 
 + 
 +ThisDoItBest folder will contain all the stylesheets needed for the integration to function correctly. 
 + 
 + 
 +At this point you will need to create the Do It Best supplier account before doing anything else.
  
 Make a note of the unique number of the supplier account as it will need to be entered into the "orderconfirmation.xsl" file.  Make a note of the unique number of the supplier account as it will need to be entered into the "orderconfirmation.xsl" file. 
Line 14: Line 19:
 {{:doitbest:supplierunique.jpg|}} {{:doitbest:supplierunique.jpg|}}
  
-When you edit the xsl file; the <DIBMember> is the account number from Do It Best. The <SupplierID> is the supplier unique number from System Five.+The six digit DIBMember number is specified from Do-It-Best. You can find this inside the first row of the “ORDCNFM_010” file.  
 + 
 +{{:doitbest:ordcnfm_010.jpg|}} 
 + 
 +To find this number, refer to the first line of the ORDCNFM_010 file from DoItBest. Count in 11 digits. This is the first digit of the 6 digit DIBMember number. Make a note of digits 11 through 16. In the example this is 06777D. You will also notice that the DIBMember number exists within the first number of each line of the ORDCNFM_01 file . 
 + 
 +When you edit the xsl file; the <DIBMember> is the Do It Best Member number or account number from Do It Best. The <SupplierID> is the supplier unique number from System Five.
  
 example example
  
    <config:settings>    <config:settings>
-      <DIBMember>12345D</DIBMember> +      <DIBMember>06777D</DIBMember> 
-      <SupplierID>49</SupplierID>+      <SupplierID>2556</SupplierID>
    </config:settings>    </config:settings>
  
  
-The DIBMember is specified from Do-It-Best. You can find this inside the first row of the “ORDCNFM_010” file.  
- 
-{{:doitbest:orderconfirmation.jpg|}} 
  
 Next you will need to set up the following categories as per Do-It Best's category structure. Next you will need to set up the following categories as per Do-It Best's category structure.
Line 55: Line 63:
  
 *** You must create these categories, and if you have already assigned these inventory categories to something else, you will need to change those categories so that they use numbers that are not being used by the Do It Best Integration. *** *** You must create these categories, and if you have already assigned these inventory categories to something else, you will need to change those categories so that they use numbers that are not being used by the Do It Best Integration. ***
- 
- 
-Extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder. 
- 
- 
-====== Setting Up The Purchase Order Confirmation ====== 
- 
-The first thing you need to do to set up the Purchase Order Confirmation will be to open System Five and determine the unique number of the Do It Best supplier account. 
- 
-Go To setup Tools - Utilities - XML Central 
- 
-Follow the instructions in the self help for setting up import 
- 
-http://mywindward.wws5.com/selfhelp/viewarticle.php?f=t&u=http://mywindward.wws5.com/selfhelp/helpfile/systemfive/index.html?intdoitbestpurchaseorderinfo.htm 
  
  
Line 79: Line 73:
   * Do It Best will supply you with the documents outlining what each of these files are.   * Do It Best will supply you with the documents outlining what each of these files are.
   * They will also supply you with an FTP Communication Guide for details on setting up your FTP client software.   * They will also supply you with an FTP Communication Guide for details on setting up your FTP client software.
- 
-  
- 
-====== Setting Up The Import ====== 
- 
-If You have not already done so, you need to extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder. 
-  * Start System Five. 
-  * Go To setup Tools - Utilities - XML Central 
-  * Follow the instructions in the self help for setting up import 
-http://mywindward.wws5.com/selfhelp/viewarticle.php?f=t&u=http://mywindward.wws5.com/selfhelp/helpfile/systemfive/index.html?intdoitbestpurchaseorderinfo.htm 
  
  
Line 175: Line 159:
  
  
-======  ====== 
  
 +====== Setting Up The Purchase Order Confirmation ======
  
 +The first thing you need to do to set up the Purchase Order Confirmation will be to open System Five and determine the unique number of the Do It Best supplier account.
  
 +Go To setup Tools - Utilities - XML Central
  
  
-======  ======+====== Do-It-Best Order Confirmation Import ======
  
 +If You have not already done so, you need to extract the DoItBest.zip file to a DoItBest folder in the System5\Bin folder.
  
 +To setup System Five for importing Do-It-Best order confirmation files, select Import From XML in the XML Central window. 
 +
 +{{:doitbest:1.jpg|}}
 +
 +From the Import XML window, click on the [New] button. 
 +
 +{{:doitbest:2.jpg|}}
 +
 +In the Message window, enter a name for the settings entry, as shown. 
 +
 +{{:doitbest:3.jpg|}}
 +
 +In the Import XML window, set the Import File Type, to the prime character, "`", located on the same key as the Tilde, "~" character, as shown below. Set Import From to Import From File. In the options to the right, check Import PO Lines. In the XSL Filter set the path to the orderconfirmation.xsl file, and also check the Prompt for filename option before selecting [Exit]. 
 +
 +{{:doitbest:xmlimport.jpg|}}
 +
 +To add the new setting to the Quick List, right click on Quick List in the menu, select Customize Lists click the [Add Import/Export] button, select the entry created as shown, click the [OK] button and then the [Save Changes] button. The setup is now complete. 
 +
 +
 +{{:doitbest:4.jpg|}} 
 +
 +To import a file, click on the New Import option, then navigate to the file and double click. The file will always be ORDCNFM_010 unless it has been renamed after it was downloaded. 
 +
 +{{:doitbest:5.jpg|}} 
 +
 +The newly imported purchases orders can viewed by selecting recent in the List Purchase Orders window. 
 +
 +======  ======
  
 ---- ----
Line 189: Line 204:
  
  
-Created by Steve Wind Dec 22 2014+Created by Steve Wind Dec 22 2014 updated April 8 2015
  
 ====== ======
 [[http://mywindward.wws5.com|{{  http://wws5.com/support/images/cust_support_banner_bottom.jpg  |myWindward [[http://mywindward.wws5.com|{{  http://wws5.com/support/images/cust_support_banner_bottom.jpg  |myWindward
do_it_best_setup.1428504917.txt.gz · Last modified: 2015/04/08 07:55 (9 years ago) by swind