Data Extract Service

As with most data driven systems, there is always the need to extract data from the database for reporting purposes, export/import processing between multiple systems or for troubleshooting and analysis. Usually this can be done with a member of your staff skilled in writing Structured Query Language scripts. This is fine for a one time situation but can quickly begin to take up manpower resource quickly when this data is needed on a routine bases. This is where the Data Extract Service can help! You can take the script that you have written to extract the data you need and then have the service automate it for you.

 Automated and Scheduled SQL execution

The power of easy of the Data Extract Service is in its run scheduler. You can configure the Extract Service to execute a job for any situation. Here are some examples of how you can schedule an extract job: - Every 5 minutes - Every hour but only during the week - At 5am every Monday - During a two week period before a holiday - Every second Tuesday of the month If you need to have the data extracted in any hour, day, month configuration, the Data Extract Service can schedule it for you. The Extract Service will create character delimited files for you with the results of the database extract query and FTP that file to you. Or if you prefer, it can utilize and network access SMTP server to send you the data via email!

Our Custom Menu tool allows you to add your custom jobs, SQL scripts, reports, stored procedures onto an internal web page

Fluent Customizer

The FluentCustomizer is a menu tool that allows you to add your custom jobs, SQL scripts, reports, stored procedures onto an internal web page to make it simple to run reports. You can then organize them into groups and assign security that defines who can run them. In addition, it will prompt the user for any variable information that needs to be inserted into the job.

 Report Select Demo

The grouping feature allows the administrator to create groups of common reports.  You can even nest groups to create groups within groups.  For example you might have a group called Month End Reports.  Within that group you might have  a couple of groups called: Financial reports and Warehouse reports. 

The prompting features allows you to indicate where variable data needs to go in your scripts.  For example you might want to prompt for a date range and insert the start and end dates into the script.  Not only will it prompt the user, but can also validate the user inputs.

You can also define administrators of the groups. For example, you could allow customer service to administer just the customer service groups and the users that can run the reports within that group. Admins can define new groups by clicking the add button.

We have a series of Inventory tools that do things such as bulk stock moves, bulk location creation, unassigning primary locations, and many others.  This is particularly useful when re-arranging a warehouse or moving a warehouse.  If you are in need to some inventory tools give us a call.  Chances are we've written something like it in the past.

Item Maintenance

 Simple flow of Maintaining Items

Item Maintenance provides you multiple means to accomplish your goals. You can use the API’s file based processing which allows you to push batch item data files to the API for processing. The files can be processed using the Item Maintenance Service which can be configured to watch a specified directory for input files, or by calling the executable. The Item Maintenance executable can be called via command line interface or from a batch file or job stream using our Job Stream Wrapper tool. You can even write your own solution using the .Net class structures provided to you via the API dlls. This allows you to integrate the power of the Item Maintenance API within your own code solutions. It just cannot get any easier than that!

Simplicity

The Item Maintenance API allows you to set up a default item which it will use to base all new items on. All item values are inherited from this default item and then all you have to do is change the properties that you want to be different. This makes creating new items consistent and easy. If you need to update an item, you do not need to update all of the item’s values. Just pass the values that you wish to have changed and the API will change only those items. Everything else remains the same.

When using the API in your own code, the Item Maintenance API classes provide detail error messages so that you can quickly identify any problems saving you potentially hours in development time.

We can even assist you with any custom development that you are under taking!

Item Purge

The Ecometry Item Purge Utility is multithreaded Windows console application which can be called via command line, batch file or Ecometry job stream with the help of our Ecometry Job Wrapper utility. Simply put, the Item Purge Utility it purges your Ecometry database of all of the accumulated items which are no longer being used which are taking up valuable database resources and slowing your database down..

 Command Line Execution

Over the years you can accumulate thousands or even millions of items which are no longer available to your customers. Some may have been test items some may be temporary seasonal items or discontinued items. Deleting these items from your Ecometry database has just gotten easy.

Call the Ecometry Item Purge Utility passing it specific criteria to identify the items that you would like to delete and let it do the work! You can pass it specific EDPNOs or ITEMNOs to purge or give it a date range to delete all items within a specified date range or even delete items by their Ecometry item status!

The Item Purge Utility will not delete any items specified which have inventory or are on any orders. This prevents you from removing an item which should not be deleted! You even have the ability to tell it not to delete item data from specific Ecometry data tables.

This helpful utility is easy to install, configure and run! This makes purging items from your Ecometry database now a much simpler task.

Job Stream Wrapper

The Ecometry Job Stream Wrapper or more simply known as FETIWrap is a simple yet powerful utility that allows you to do the one thing that you always seem to need to do from within an Ecometry job stream job but can’t, execute an external process or application. Not only will FETIWrap allow you to run your own external processes from with Ecometry’s job streams but it will wait for that process to complete before allowing the job stream to resume its normal execution. This is amazingly powerful! This means that at any time within any Ecometry job stream you can execute any other executable, batch file or needed command line process and halt the job stream execution until it finishes.

 Sample Job

Setup is as easy as copying a few files into your Ecometry PRO folder! Usage is even easier, just call FETIWrap from within your job stream and you’re done! It cannot be any simpler than that. Once you have the power to control the flow of execution of your Ecometry job stream jobs, you will be able to do a ton more within your Ecometry jobs.

M.I.C.E

M.I.C.E is a web based tool that provides documentation on the Ecometry database. It includes info on control blocks, copylibs, status',Supertool definitions, and much more. Designed specifically for Ecometry on the HP3000 it is still found to be useful for those on Open Systems.

 Information on ORDER-HEADER table

MICE is the must have tool for Ecometry administrators.  Providing dataset layouts and field definitions as well as suprtool defines that you can copy and paste into suprtool. Multi-user options to allow as many people as you want in your organizaton to login at the same time. MICE by the way stands for MACS Internals Controls Etc.  (direct commerce was first call MACS before Ecometry and Direct Commerce).  MICE improves on your ability to solve Ecometry problems and diagnose problem orders.  You can sign up for a free trial at mice.fluentedge.com

Offer Item Load

Creating item pricing for multiple offers can be a very tedious task in Ecometry. Well it doesn’t have to be a daunting task anymore The Offer Item Load Utility will create or update offer items entries and multi-pricing entries based on fixed length or comma delimited input files. A user created input file is read in and processed. If the item in the file is found then the item is updated with the data contained for that item in the file, if it is not found then the offer item entry is created. The utility can optionally update UPSELL data as well.

Call the Offer Item Load application from a batch file or via command line passing it the file containing all of the data that is needed. If find that you may need to run this process from with an Ecometry job stream job, our Job Stream Wrapper tool can help you do that too.

The input file format is simple and easy to understand so that you can quickly generate the file. If you do not have the means to create the file yourself, we can help! We can assist you in your efforts or write a custom application to help you get started to an easier way to manage Ecometry’s offer item pricing.

Pack Check

Pack Check is a plug in replacement for Ecometry’s Auto Check/ Order Check program which offers custom enhancements and additional features. It has similar features to that of Ecometry’s Auto Check program and lots more.

 Scan Wrong Item Screen Shot

The Pack Check program provides scanning progress feedback by changing the color of the line items as you scan. Errors and scanning completion are also indicated by screen color changes. The color combinations are completely configurable so you can set things up the way that you would like to see them. This product came into being because many clients have custom features they'd like to see in the pack check program. Let us know if you have special features you'd like to see.

Paymentech Transfer Service

The Paymentech Interface consists of a Windows service which is configured to receive credit card files from Ecometry to be batch processed through Chase/Paymentech’s NetConnect processing system. The Paymentech Interface service is configured using a simple configuration administration program. This configuration application provides you not only with the tools you need to configure the Interface service to communicate with the Chase/Paymentech NetConnect system, but it also provides you with the means to easily recover from possible network related failures that can occur during file transfers. The service handles the sending of the credit card data to NetConnect and also the return file which is sent to Ecometry while kicking off the Ecometry job stream to load it. This is done automatically, seamlessly and securely. The credit card files are encrypted using industry standard encryption algorithms and send to NetConnect over secure socket connections (SSL). This means that your customer’s sensitive credit card data is double encrypted for added security.

Installation is simple and easy. Integration with Ecometry is done quickly and smoothly. Configuration is uncomplicated and straightforward.

The Paymentech Interface provides you with a dual environment setup; Test and Live. This means that you can safely configure your Ecometry Test environment for credit card processing when testing process changes prior to implementing them into your production environment.

 Sample Config Screen

Stock Move API and Service

The Stock Move API and Window service provides an automated method of doing stock adjustments and stock moves in Ecometry.

The Ecometry Stock Maintenance API is an invaluable tool when automating stock movements or adjusting stock due to physical inventory counts or adjusting for bad stock items. There are three main functions which the API performs; Stock Move, Stock Adjust and Stock Set. The API consists of three database stored procedure scripts which, once installed, you can call directly for stock quantity manipulations or through the API’s Stock Maintenance by File service.

Automate as a Service

The included Windows service can be configured to watch a specified directory for input files. These files when found in the watch directory will be read and each record will be processed by the service performing the directed stock maintenance process; a Stock Move, Stock Adjust or Stock Set. This means that maintaining proper stock levels can be completely automated just by dropping a properly formatted file into a directory. The Ecometry Stock Maintenance Service will take care of the rest. The Ecometry Stock Maintenance API provides you with the maximum flexibility to implement the solution that works to maintain proper stock levels.

TMeditor is an editor for TapeMacs files. Easy identification and validation of key fields. Fixing existing records and adding to ones.