Interfacing Randr Orderportal with VAI System 200

To interface the Randr Orderportal with VAI System 2000, there are several points of interface. In addition, there are some files and programs that are required if you are pushing orders into VAI from Orderportal. These are all saved in savf (save file) OP_SRC.

Key points of interface:

  • When you create a user, enter the VAI customer number in the external customer number field. Note, if you want customers to create their own profiles and have these automatically created in the VAI customer table, please contact us and we can show you where to make that change.
  • When the customer signs in the Account inquiry and the View order history go against the VAI data base. (VARARTR, VCOHEAD/VCODETL and VSAHEAD/VSADETL).
  • Orders will push directly into the VAI data base (see below for the programs and files needed.
  • In the Orderportal appConfig.xml file, set the following:
  1. VAI_ENABLED - set to true
  2. All VAI files, set the correct library (make sure there is a period at the end of the library name, e.g. R36FILES.)
  3. iSeries user id and password set up for Orderportal (sample jobd in in op_src)
  4. Journal all the files that will be updated from the Orderportal. See our forum post on how to do this: http://www.randrinc.com/jforum/forums/show/25.page
  5. We have some other points of interface (e.g. Pricing, updating) but have not included those in the base Orderportal. Please contact us if you want a copy of those changes.
  6. In java source under orderportal, there is a VAI folder, it contains all the vai classes.
  7. In java source under common/adapter/orderportal are the EOPortalToVai adapters.
  8. hese things should be in Orderportal starting in January, 2008 at http://sourceforge.net/projects/orderportal/

Thank you

Ann Richmond - ann@randrinc.com

Mike Croteau - mike@randrinc.com

Randr, Inc. www.randrinc.com

1-800-669-3427

OP_SRC:

OP_SRC savf contains library OP_SRC. It was saved in V5R1M0. This can be downloaded to your desktop.

It is located at. Right click to download: http://www.randrinc.com/2d_randr/files/op_src

To move the savf from your pc to the AS400/iSeries, do the following:

  1. create a savf in qgpl call op_src. (CRTSAVF)
  2. move the op_src object into C:
  3. start a batch session (cmd)
  4. then FTP xxx.xxx.xxx.xxx to your iSeries
  5. enter user id and password
  6. key in: binary
  7. key in: put c:\op_src qgpl/op_src (replace
  8. when the file is on the iSeries, do RSTLIB OP_SRC, *savf as the device and op_src and qgpl as the savf name and library.
  9. op_src library should be restored. Copy to where you want things and compile.

Library OP_SRC contains the following:

  1. webdw jobd - job description used for user setup Orderportal to connection to AS400/iSeries.
  2. Source file - contains:
    1. Opt Member Type Text
    2. EDCRORCWE2 CLP call edcrorn to create order- new verison
    3. EDCRORN RPGLE Create cust ordrs from EDI files- new web
    4. VEDCMPT PF 850 components from web
    5. VEDPODHL1 LF Select only records with EWDEL=blank
    6. VEDPODHL2 LF Select only records with EWDEL=N - new web
    7. VEDPOEXT PF 850 detail work file for POs received
    8. VEDPOHWL1 LF Select only records with EHDEL=blank
    9. VEDPOHWL2 LF Select only records with EHDEL=N - new web

    These are the additional files added to VAI to handle orders pushed from Orderportal into VAI. The program that writes to the VAI orders files is edcrorn and the cl that is called from Orderportal is edcrorcwe2.

Download Order Portal





Your banner could be HERE! Please contact us.