Upgrading from Minivend 4.0 to Interchange 4.6

if item-price suddenly starts returning 0, check PriceField in the catalog.cfg

minivend.cfg

  • Remove references to MiniMate.

  • Add this line to minivend.cfg:

    #include lib/UI/ui.cfg

Make sure the files catalog_before.cfg and catalog_after.cfg are there, or add their contents to etc/your_cat_name.before and etc/your_cat_name.after only for some catalogs.

Access Manager

You need to get the minimate.asc file renamed to access.asc and add the following fields to the first line:

groups
last_login
name
password

Remove these catalog.cfg lines:

Variable   MINIMATE_META   mv_metadata
Variable   MINIMATE_TABLE  minimate
Database   minimate        minimate.asc      TAB

Add this one:

  Database   affiliate       affiliate.txt     TAB

Authentication for admin users is now done from a separate table than customers, and passwords are encrypted.

Database Editing

Update the mv_metadata.asc file as appropriate.

Order Manager

Some things that are needed for the order manager:

  • Add these fields to transactions:

    affiliate  approx. char(32)
    

  • Add these fields to transactions:

    affiliate  approx. char(32)
    

  • Remove this field from userdb:

    mv_credit_card_info

  • Add these fields to userdb:

    inactive char(1)
    

  • Create the directory logs/.

  • Create the directory orders/ if it doesn't already exist.

  • Update your order routes to those in the Interchange distribution. Note that the route log_entry is necessary if you want to enter orders from the Interchange UI.

  • Update the etc/log_transaction file.

  • Add the etc/log_entry file.

  • Add this to catalog.cfg:

    ## Don't want people setting their credit_limit directly
    

Affiliates

Add a tab-delimited affiliate table:

affiliate name    campaigns   join_date   url timeout active  password

You can find a recommended database configuration in standard/dbconf/*/affiliate.*.

Page Editor

Add the directories templates/ and backup/. Copy the contents of the Interchange simple/templates/ to templates/.

Item Editor

Add a merchandising table with the following fields:

Database  merchandising  merchandising.txt __SQLDSN__
Database  merchandising  DEFAULT_TYPE text

sku char(32) featured char(32) banner_text banner_image blurb_begin blurb_end timed_promotion char(16) start_date char(24) finish_date char(24) upsell_to cross_sell cross_category char(64) others_bought times_ordered

Index the fields with char(*) types. You can find the recommended database configuration in standard/dbconf/*/merchandising.*

Preferences Editor (KNAR)

Create the tab-delimited file variable.txt with these fields:

code  Variable  pref_group

Add this as the first line of catalog.cfg:

VariableDatabase variable

Route Editor

Create the file route.txt with these fields:

code
report
receipt
encrypt_program
encrypt
pgp_key
pgp_cc_key
cyber_mode
credit_card
profile
inline_profile
email
attach
counter
increment
continue
partial
supplant
track
errors_to

Add this line in catalog.cfg:

RouteDatabase route

Transactions database

The back office UI should work fine for editing database tables. Obviously the things which are specific to the order transaction setup will break unless you have the right fields, but even these can be controlled by configuring the UI.

Add a new field to transaction.txt called archived.

DocBook! Interchange!