logo

Server
Client

[-] [+] System Requirements

[-] [+] Version Details
View Release Notes

[-] [+] Install Instructions
[-] [+] Server Install or Upgrade
Step Screen Shot
Watch HowTo Video

1


Download Server Installer "DownloadAPS.exe"

2


Enter valid serial code.

3


Select software version to install.

4


Select install location.

5a


If you'd like to use PlanetTogether Sign-In then leave "PlanetTogether Sign-In" selected....

5b


If you'd like to install the client to a folder of your choosing then select "Full Client" and choose location.

6


Install summary/review page.

7


Install progress.

8


Install complete!

Click "Launch" button to open Instance Manager program.

[-] [+] Instance Creation or Upgrade
Step Screen Shot

1


Open/Launch "APSInstanceManager.exe"

Click New or Copy

2


  • Select Server Manager, Version and Integration Code
  • Name the Instance
  • Enter Serial Code

Click Create

3


Instance Created

[-] [+] APS Sign-In Configuration
Step Screen Shot

1


Launch PlanetTgether from Desktop and add Server Location.

2


Click "Save" to confirm and save connection.

3


If needed...Click "Change Server Connection" to add or change a server location.

4


Choose Instance Name from drop-down list.

5


Enter Username and Password.

Click Sign-In.

Default:
Username: admin
Password: none

[-] [+] Upgrade Instructions (if upgrading from 2014.3.31 or earlier)

Follow the Install Instructions above, then follow steps below...

Step Screen Shot

1


Re-Map CapabilityExternalId source field on the "Required Capabilities Mappings" page of the Data Mappings Wizard

2


Run script adding new Stored Procedures to the Publish Database

ClearAllHistoryData
ClearOldHistoryData
-- =============================================
-- Create date: 2014.4.1
-- =============================================

CREATE PROCEDURE [dbo].[ClearAllHistoryData] 
	@PublishInventory bit, 
    @PublishCapacityIntervals bit
AS
BEGIN
	IF @PublishInventory = 1
	BEGIN
		DELETE FROM JobProductSalesOrderDemands;
		DELETE FROM JobProductForecastDemands;
		DELETE FROM JobProductSafetyStockDemands;
		DELETE FROM JobProductTransferOrderDemands;
		DELETE FROM JobProductDeletedDemands;
		DELETE FROM PurchaseToStockSalesOrderDemands;
		DELETE FROM PurchaseToStockForecastDemands;
		DELETE FROM PurchaseToStockSafetyStockDemands;
		DELETE FROM PurchaseToStockTransferOrderDemands;
		DELETE FROM PurchaseToStockDeletedDemands;
		DELETE FROM JobActivityInventoryAdjustments;
		DELETE FROM SalesOrderDistributionInventoryAdjustments;
		DELETE FROM ForecastShipmentInventoryAdjustments;
		DELETE FROM PurchaseToStockInventoryAdjustments;
		DELETE FROM TransferOrderDistributionInventoryAdjustments;
		DELETE FROM SalesOrderLineDistributions;
		DELETE FROM SalesOrderLines;
		DELETE FROM SalesOrders;
		DELETE FROM ForecastShipments;
		DELETE FROM Forecasts;
		DELETE FROM TransferOrderDistributions;
		DELETE FROM TransferOrders;
	END

	IF @PublishCapacityIntervals = 1
	BEGIN
		DELETE FROM CapacityIntervalResourceAssignments;
		DELETE FROM CapacityIntervals;
		DELETE FROM RecurringCapacityIntervalResourceAssignments;
		DELETE FROM RecurringCapacityIntervalRecurrences;
		DELETE FROM RecurringCapacityIntervals;
	END

	DELETE FROM JobPaths;
	DELETE FROM JobOperationAttributes;
	DELETE FROM JobMaterialSupplyingActivities;
	DELETE FROM Capabilities;
	DELETE FROM JobResourceBlockIntervals;
	DELETE FROM JobResourceBlocks;
	DELETE FROM JobActivities;
	DELETE FROM JobProducts;
	DELETE FROM JobMaterials;
	DELETE FROM JobResourceCapabilities;
	DELETE FROM JobResources;
	DELETE FROM JobOperations;
	DELETE FROM ManufacturingOrders;
	DELETE FROM Jobs;
	DELETE FROM ResourceCapabilities;
	DELETE FROM Resources;
	DELETE FROM Departments;
	DELETE FROM Plants;
	DELETE FROM PurchasesToStock;
	DELETE FROM Inventories;
	DELETE FROM Warehouses;
	DELETE FROM Items;
	DELETE FROM PlantWarehouses;
	DELETE FROM Schedules;
	DELETE FROM KPIs;
	DELETE FROM ProductRules;
END
GO

SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

-- =============================================
-- Create date: 2014.4.1
-- =============================================

CREATE PROCEDURE [dbo].[ClearOldHistoryData] 
	@MaxScheduleDisplayDate datetime,
	@MaxWhatIfDisplayDate datetime,
    @ScenarioType nvarchar(50),
	@ClearInventory bit,
	@ClearInventoryAdjustments bit,
	@ClearProductRules bit,
	@ClearBlocks bit,
	@ClearBlockIntervals bit,
	@ClearCapacityIntervals bit,
	@MaxHorizonDays int
AS
BEGIN
	DELETE FROM Schedules 
	WHERE PublishDate < @MaxScheduleDisplayDate;
	DELETE FROM Schedules 
	WHERE PublishDate < @MaxWhatIfDisplayDate AND ScenarioType = @ScenarioType;

	--Delete objects that are not being saved in History, 
	--in reverse order, clearing dependent objects first.

	IF @ClearInventory = 1
	BEGIN
        DELETE FROM JobProductSalesOrderDemands;
        DELETE FROM JobProductForecastDemands;
        DELETE FROM JobProductSafetyStockDemands;
        DELETE FROM JobProductTransferOrderDemands;
        DELETE FROM JobProductDeletedDemands;
        DELETE FROM PurchaseToStockSalesOrderDemands;
        DELETE FROM PurchaseToStockForecastDemands;
        DELETE FROM PurchaseToStockSafetyStockDemands;
        DELETE FROM PurchaseToStockTransferOrderDemands;
        DELETE FROM PurchaseToStockDeletedDemands;
        DELETE FROM JobActivityInventoryAdjustments;
        DELETE FROM SalesOrderDistributionInventoryAdjustments;
        DELETE FROM ForecastShipmentInventoryAdjustments;
        DELETE FROM PurchaseToStockInventoryAdjustments;
        DELETE FROM TransferOrderDistributionInventoryAdjustments;
        DELETE FROM ForecastShipments;
        DELETE FROM Forecasts;
        DELETE FROM SalesOrderLineDistributions;
        DELETE FROM SalesOrderLines;
        DELETE FROM SalesOrders;
        DELETE FROM TransferOrderDistributions;
        DELETE FROM TransferOrders;
        DELETE FROM Items;
        DELETE FROM PlantWarehouses;
        DELETE FROM Warehouses;
        DELETE FROM JobProducts;
        DELETE FROM JobMaterials;
        DELETE FROM JobMaterialSupplyingActivities;
	END
	ELSE
		IF @ClearInventoryAdjustments = 1
		BEGIN
			DELETE FROM InventoryAdjustments;
		END

	IF @ClearProductRules = 1
    BEGIN
		DELETE FROM ProductRules
	END

	IF @ClearBlocks = 1
	BEGIN
		DELETE FROM JobResourceBlocks;
	END
	ELSE
		IF @ClearBlockIntervals = 1
		BEGIN
			DELETE FROM JobResourceBlockIntervals;
		END

	IF @ClearCapacityIntervals = 1
	BEGIN
		DELETE FROM CapacityIntervalResourceAssignments;
		DELETE FROM CapacityIntervals;
		DELETE FROM RecurringCapacityIntervalResourceAssignments;
		DELETE FROM RecurringCapacityIntervalRecurrences;
		DELETE FROM RecurringCapacityIntervals;
	END

	--Delete Activities that are too far after the ClockDate.  
	--(ie. only want to keep the short term schedule)
	DELETE FROM Jobs 
	WHERE Scheduled = 1 AND ScheduledStartDateTime > 
	(SELECT Max(Clock) From Schedules 
	WHERE Schedules.PublishDate=Jobs.PublishDate) + @MaxHorizonDays;
	DELETE FROM ManufacturingOrders 
	WHERE Scheduled = 1 AND ScheduledStart > 
	(SELECT Max(Clock) From Schedules 
	WHERE Schedules.PublishDate=ManufacturingOrders.PublishDate) + @MaxHorizonDays;
	DELETE FROM JobOperations 
	WHERE Scheduled = 1 AND ScheduledStart > 
	(SELECT Max(Clock) From Schedules 
	WHERE Schedules.PublishDate=JobOperations.PublishDate) + @MaxHorizonDays;
	DELETE FROM JobActivities 
	WHERE Scheduled = 1 AND ScheduledStartDate > 
	(SELECT Max(Clock) From Schedules 
	WHERE Schedules.PublishDate=JobActivities.PublishDate) + @MaxHorizonDays;
	DELETE FROM PurchasesToStock 
	WHERE ScheduledReceiptDate > 
	(SELECT Max(Clock) From Schedules 
	WHERE Schedules.PublishDate=PurchasesToStock.PublishDate) + @MaxHorizonDays;

END
GO

[-] [+] Additional Information

PlanetTogether Support Center

PlanetTogether Knowledge Center

Data Mapping / Object Help

Connecting to a Database

Keyboard Shortcuts

[-] [+] Related Resources