automate inconvenient and lengthy manual proccesses
The X3 Folder copy/refresh process is a manual procedure that involves either working directly in X3 to extract data from a source folder and import it into a destination folder or working within the X3 Management Console to perform the same functions.
This module has been developed by Net at Work to automate the X3 Folder Refresh process using the Microsoft BCP (Bulk Copy Process) and other in-house developed functions to fulfill this requirement. The Microsoft BCP utility is used to speed up the X3 data extract/import process and improve overall program performance as the default X3 SVG function can be time consuming for large database environments.
Because the X3 Folder refresh process typically requires work outside of regular business hours, someone usually has to work late at night, early in the morning, or on weekends. This module eliminates that need by automating the scheduling and execution of folder refreshes. It can be configured to run as a Windows scheduled task, enabling automatic folder refreshes, detailed logging of results, and email notifications for progress updates.
KEY BENEFITS
- Reduces the amount of manual work the Client needs to perform to keep their X3 development folders in line with their PRODUCTION environment.
- Significantly speeds up the X3 SQL data export and import function to get your users back in the system as quickly as possible.
- Schedules automated folder refreshes at specific times outside of business hours.
- Provides detailed logs recording the outcome of a folder refresh.
- Emails notification with detailed log files of process start and end.
- Ability to copy X3 Folders within the same X3 server environment.
- Copy the PRODUCTION Folder to a secondary folder in the same X3 implementation.
- Ability to copy X3 Folders between different X3 server environments.
- Copy the PRODUCTION Folder to a secondary folder on a separate TEST X3 server environment.
- Leverages SOAP Web services native to Sage X3.
- Cleans up all process control files after the completion of a folder copy.
- Runs from any server that has network connectivity and domain access to the source and destination X3 environments.
