ICM Cloud Imports

Log In

Several imports that might need to be changed:

SADetailLines import:   

Ross Program:   scc_sa_u_summary_update_commissions.dml customer80\sa\src\

SCC_COMMISSION_LINES into SADetailLines import:   

Ross Program:   scc_sa_u_ICM_commission_lines.dml       customer80\sa\src\

PAYEE import:

Ross Program:   scc_sop_m_payee.dml customer80\sa\src\

Google Chrome

cloud.varicent.com

1. create SQL to fill table using the "AS" to make the names match the table in ICM
   1. Composer
   2. Tables
   3. Regions
   4. View Data

2.  create SQL

SELECT 

      [CODE_DESCRIPTION]

      ,[PAYEE_NUMBER]      

      ,SALESPERSON_CODE as RegionID

            ,SCC_REGION_DESCRIPTION as RegionDescription

      ,SCC_TT_INCLUDE_FLAG as TopTenIncludeFlag

      ,SCC_RM_BONUS_INCLUDE_FLAG as RMBonuseIncludeFlag

      ,SCC_ACTIVE_FLAG as ActiveRegionFlag

      ,LOCATION as Division 

      ,SCC_NEW_LOCATION as New_Division

  FROM [fin_prod].[dbo].[SALESPERSONS]

  where SCC_ACTIVE_FLAG = 'Y'

  order by SALESPERSON_CODE

3. save as excel

4. save as csv

5.User options

1. download
2. import file
3. open
4. Overwrite

get ready to create a new import from the csv

1. Composer
2. Tables
3. Regions
4. Import
   1. Text File
   2. Drop file or click to upload
   3. Open selected file
   4. Next
   5. Import text file
      1. First record is a header
      2. Comma
      3. check date format
      4. next
   6. Import text file
      1. Save this import as
         1. 2025-03 Regions_Import

view import

1. Model settings
2. Manage
   1. Saved Imports

                                2025-03 Regions_Import

*****************************************************************************************************

if you cannot log into FileZilla 

sftp://spartanchemicalprod@ftp.cloud.varicent.com

load the csv directly into ICMProd 

https://cloud.varicent.com/

Remove from the scheduled jobs

           2 Web Portal - Imports ManualPayment, ReserveCheck, ComRates

                            ComRates Import SCC_COMMISSION_RATES_LOAD 

                                       ...        Delete

Delete the prior Import

           Model Settings  ( Gier )

                   Manage

                           Saved imports

                                   Search by name           ManualPaymentByRegion Import

                                                                       ReserveCheckAmount Import

Down Load csv

User Options (person next to the gier in upper right)

Downloads

ICM Cloud           Imports

click on the next csv

Open

CREATE NEW IMPORT

Composer

           Tables

                   ComRates

                           View Data

                                   Import                     

Import data from SPM storage

                                                                               Text File

                                                                                       The first record is a header

                                                                                               Automatch        Date Format            Next        Done

Add To Scheduled Job

               Add task

                       Import            Save

Review the import

model settings

               Manage

                           Saved Imports

                                   Saved Imports selection     202407_res    to find 202407_ReserveCheckAmount Import

                                           ...        Edit

                                           Select a file to import:

                                                       ReserveCheckAmount Import SCC_COMMISSION_RESERVE_CK_LOAD.csv

                                                       ManualPaymentByRegion Import SCC_COMMISSION_ADJUST_LOAD.csv

                                           Save this import as:

                                                        202407_ReserveCheckAmount Import 

                                           ck          The first record is a header

                                           Delimiter    Comma

                           Select the destination table:

                                            ReserveCheckAmount

                            Import Data            Automatch

                                                           Date format       Month/Day/Year            Save          Next      Update existing rows    Done

********************************************************

********************************************************

********************************************************

select Automatch

O L D   D I R E C T I O N S

********************************************************

********************************************************

********************************************************

Composer        Tables        click on a table            

Use View Data    (N O T Import)

Import

Import data from SPM storage   Select  (orange one)

Text File

Click on the crop down and select the import

****************************************************************

Text File