Set up Stock Feed Processing

Back Top Previous Next

Info

This stock feed how to and configuration is not applicable for suppliers that have a specific stock feed processing module. Contact support@happen.biz for supplier-specific instructions.

 

Configuring the Jim2 eBusiness Connect (Vendor Stockfeeds)

1.Set up an email account.

A dedicated email address is required for receiving the stock feeds. This email account must obe accessible using) the POP3 protocol. The Stock Feed module will process all emails sent to this account. Emails that match the selection criteria for a vendor's feed will be processed, and all other emails will be forwarded to the configured email address.

2.Create a working directory.

Create a suitable working directory for Jes to use in processing the stock feed emails. Note that this directory must be accessible by the Jes service, ie. access must be granted to the user account under which the Jes service is running.

3.Configure Jes.

Use the Jim2 Configuration Manager (JesCM.exe) to configure Jes. If the Stock Feed module is not already included in the Jes configuration, add it.

add stockfeed

Select the Stock Feed module.

stockfeed confg

For details on the meaning of the parameters refer to the Stock Feed module. Enter the appropriate values for the stock feed parameters. Specify the directory created in step 2 above as the FeedDirectory.

 

Polling Interval

The EmailPollSeconds parameter requires a value greater than 0, and is critical to processing stock feeds. However, EmailPollSeconds will only apply to the initial (once daily) processing of the URL-based feed. If the last time a file is downloaded is within 24 hours (Jim2 keeps track of this), Jim2 does nothing, so the file is only downloaded from the URL once a day..

Right click in the grid and select Add Param to add the POP3UseSSL parameter.

4.Configure the feed processing.

Select Feeds. For each vendor that is sending a feed to be processed by this module, click Add New. Enter a Stock Feed Name. This is required when setting up an email rule.

enter feed name

Enter the vendor code for the vendor. This is the card code for the vendor's cardfile in the Jim2 database.

Sender and subject match expression do not need to be entered.

Enter the file name expression. The Stock Feed module uses these expressions to determine if an email that has been received is a data feed from the vendor code just entered. Generally, put the exact text expected in this field. However, if a vendor's emails change each feed (for example, if the subject includes a date) a regular expression will need to be built to match the expected changes. Leaving any of the expressions blank means that check is not required.

Info

There could be times where the file name may change. In this case, replace the File name expression with PRICEDLR.* The "." character in reg ex matches any character, and when it is followed by * this means 'repeated 0 or more times'. For more information on regular expression, google RegEx Cheat Sheets.

The regular expressions are not case sensitive.

Enter the path to the directory (Directory PickUp) for picking up the stock feed, or enter the Download URL.

If the data feed is being sent in a .zip file, tick Feed file sent in zip'd. In this case the Zip file name expression must match the file name within the .zip file and the Zip file name expression must be entered to match the name of the .zip file that will be attached to the data feed email.

Info

Feed is Gzip'd relates to a different file compression format, which is rarely used, particularly on Windows systems.

5.Depending on the feed type (.xml for .CSV):

Configure the XML specific options.

For .xml type feeds, select XSLT. If the vendor is sending the stock feed in the Jim2 XML format, this should be left blank. If not, select the vendor's XSLT mapping file from the XSLT drop down list.

vendor pref

Configure the CSV specific options.

configure feeds

For CSV type feeds, select the Field Mapping appropriate to the vendor. Generally, this will be specific to the vendor, ie. the name of the mapping will match the vendor name.

6.Click Save.

Save the configuration and re-start Jes if necessary.

7.Arrange for the stock feed to be sent.

Contact the vendor to arrange for their stock feed to be emailed to the email account set up in Step 1 above.

 

Create an email rule for the stock feed. On the ribbon, go to Email > Email Rules.

 

Set up Email Rules

Email rules need to be created for each vendor stock feed.

 

emailrules

 

Select New, then Via Specific Account and enter the email account as set up via Jim2 Config Manager.

 

emailfeedsetup

 

Then select Sender Contains, and enter the Text as set up via Config Manager.

 

sendercontains1

 

Click Next, then double click Process Stock Feed and enter the name as it appears in the StockFeed module in Jim2 Configuration manager.

 

processstockfeed

 

Click Next and name the email rule, tick Stop other rules if this rule is run, then click Finish.

 

dynamicstockfeed

 

Further information

Stock Feed module.

Jim2 .xml feed file format

Generic CSV feeds

Is Your Vendor Supported?

Alloys Setup

Bluechip Infotech Setup

Dicker Data Setup

Dynamic Supplies Setup

Ingram Micro Setup

Konica Minolta Setup

Leader Systems Setup

Multimedia Technology Setup

Ricoh Setup

Synnex Setup

Techdata Setup