sigconnects lite painfree cim formatting
Download
Skip this Video
Download Presentation
SIGConnects/Lite Painfree CIM Formatting

Loading in 2 Seconds...

play fullscreen
1 / 29

SIGConnects - PowerPoint PPT Presentation


  • 130 Views
  • Uploaded on

SIGConnects/Lite Painfree CIM Formatting. MFG/PRO Midwest Users Group March 26, 2002. CIM in Review. QAD’s “legacy” mechanism to update MFG/PRO Based on Progress redirection ‘INPUT FROM’ or ‘INPUT THROUGH’ Ability to drive a standard QAD screen programs from a data file. Why use CIM?.

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha
Download Presentation

PowerPoint Slideshow about 'SIGConnects' - brit


An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
sigconnects lite painfree cim formatting

SIGConnects/LitePainfree CIM Formatting

MFG/PRO Midwest Users Group

March 26, 2002

cim in review
CIM in Review
  • QAD’s “legacy” mechanism to update MFG/PRO
  • Based on Progress redirection

‘INPUT FROM’ or ‘INPUT THROUGH’

  • Ability to drive a standard QAD screen programs from a data file
why use cim
Why use CIM?
  • Retains database integrity
    • Ensures updates to all associated tables
  • Complete editing of input data
    • Same as if entered manually
  • Any screen can be updated *

(*well, almost any!?)

  • Support from QAD is not compromised
  • “Easier” upgrades to new releases
cim format
CIM Format
  • Single line of data for each input request
  • Fields are separated by spaces
  • Character fields surrounded by quotes (“ ”)
  • Dates formatted as 99/99/99
  • Hyphen (-) acts as TAB key
  • End of input line acts as GO key
  • Single period (.) acts as END key
  • Tilde (~) allows continuation on next line
cim data format example
CIM Data Format Example

“1397-04”

“ea” “Warble-vane”

“ajb” - - “Drawing” “FINGOOD” “AC”

“A” - “10000” - - no “Article” 30 90 ~

- no yes

yes yes 0 “POQ” 100 - - - - “A”

.

can a function run in cim
Can a function run in CIM?
  • CIM-able - All screen navigation requires only Tab, Go or End keys
  • Non-CIM-able - Requires more than Tab, Go or End keys to navigate
    • Function keys other than Go or End
    • Scrolling windows that require cursor movement and Enter key
    • Radio buttons, slider bars, etc
cim not a perfect solution
CIM – Not a perfect solution
  • Unforgivingly ugly file format
  • Not all functions can be executed
  • Poor error reporting
  • Performance concerns
  • At upgrade, reformatting required whenever the UI changes
sigconnects lite
SIGConnects/Lite
  • You define your input file
  • You map your input to the provided screen definition
  • You add your edits
  • SIGConnects/Lite reformats your data ready to CIM
template driven approach
Template-Driven Approach
  • Screen format
    • Describes the MFG/PRO screen
      • Fields
      • Screen navigation – Go and End keys
      • Conditional Fields
  • Input format
    • Describes your input file
      • Fields, delimiters, lengths, etc
  • Template
    • Binds input format to screen format
sigconnects screen formats
SIGConnects Screen Formats

Seq Field CC Cnt SIG Data Cnd

=== ============== == === ======== ===

1 pt_part

2 F1

3 lot_serialqty

4 site

  • Field: used to map from the input definition
  • CC: designates controls for F1 or F4
  • Cnt: number of times the entry repeats
  • SIGData: sets a variable for use in edit routines or reporting
  • Cnd: Conditional field
sigconnects conditional fields
SIGConnects Conditional Fields

Seq Field CC Cnt SIG Data Cnd

=== ============== == === ======== ===

23 comment_line1 yes

24 comment_line2 yes

Condition

comments = “yes”

  • Enter the expression to check to determine whether input is required.
screen definition libraries
Screen Definition Libraries
  • SIG provides over 100 MFG/PRO transactions
  • Specific to version and letter release
    • 7.4h through eB
  • Includes every required field and most common use of a given MFG/PRO program
  • You can modify screen definitions to support your customizations or specific use
input formats fixed position
Input Formats – Fixed Position

Definition Name: Unpl Rcpt Delimited: no

Delimiter:

Seq Field Field Label Pos Len

=== ============ ============ === ===

1 pt_part Item 1 18

2 site Plant 22 4

3 lot_serialqty Qty 26 7

  • Field: used to map to the screen definition
  • Label: used for reporting
  • Pos: starting position of the data
  • Len: length of the data
input formats delimited
Input Formats – Delimited

Definition Name: Unpl Rcpt Delimited: yes

Delimiter: ,

Seq Field Field Label

=== ============ ============

1 pt_part Item

2 site Plant

3 lot_serialqty Qty

  • Delimiter: character used to separate input fields
  • Field: used to map to the screen definition
  • Label: used for reporting
templates binding input to output
Templates – Binding Input to Output

Template Definition: Unplanned Receipts

Multiple Format:

Data Transforms:

Input Definition: Unpl Receipts - Fixed

Output Definition: Receipts - Unplanned

  • Multiple Format: for complex transactions
    • Header, line items, trailers, etc
  • Data Transforms: for editing conditions
  • Template validation: compares input definition fields to output definition fields
running a template
Running a Template

Input File Name:

c:\lite\in\unplfixed.txt

Output File Name:

c:\lite\out\unplcim.txt

Exception Report File Name:

c:\lite\rpt\unpl.rpt

Output Format: CIMLoad

  • Specify file names to process
  • Output format: CIMLoad or Quickloader
    • Quickloader is CIM without @@ lines
data transforms
Data Transforms

(Input) (Output)

Seq Field Pre-edit Constant Value

=== ============ ========= ==============

1 pt_part v_item.p

2 reason QC Use

  • Pre-edit: Progress routine to check incoming data
  • Constant Value: to set values not on input file
pre edit routines
Pre-edit Routines

* v_item_1.p - item number must exist */

DEFINE SHARED VARIABLE err_flag AS ...

DEFINE SHARED VARIABLE error_msg AS ...

DEFINE SHARED VARIABLE current_data AS ...

DEFINE SHARED VARIABLE identifier_1 AS ...

DEFINE SHARED VARIABLE identifier_2 AS ...

FIND FIRST pt_mstr WHERE pt_part = current_data

NO-LOCK NO-ERROR.

IF NOT AVAILABLE pt_mstr THEN DO:

err_flag = TRUE.

error_msg = "Item does not exist.“

END.

  • Current_data is the input data value.
  • Error_msg will appear on exception report
  • Identifier fields also appear on exception report.
pre edit routines can transform input
Pre-edit Routines Can Transform Input

* v_plancode.p – reformat planning codes */

DEFINE SHARED VARIABLE err_flag AS ...

DEFINE SHARED VARIABLE error_msg AS ...

DEFINE SHARED VARIABLE current_data AS ...

DEFINE SHARED VARIABLE identifier_1 AS ...

DEFINE SHARED VARIABLE identifier_2 AS ...

IF current_data = “A”THEN current_data = “POQ”.

  • Current data can be modified by Pre-edit routine.

Or translated into Tab, Go or End keys.

exception reports
Exception Reports

Run 03/23/02 SIGConnects Exception Report Page: 1

Rec# Current Data Key #1 Key #2 Validation Routine

==== ================== ============= =========== ==================

1 22-100ABC v_item_1.p

Item does not exist.

Totals: 4 Records Processed

1 Errors Recorded

0 Warnings Recorded

1 Records Affected

  • Each transaction is edited independently.
  • Errors are excluded from output.
complex transactions
Complex Transactions
  • For transactions with variable repeating screens
    • Order header
    • Multiple line items
    • Order trailer
  • Managed with multiple record types on a single input file
  • Expressed as combination of templates
    • Specify Multiple Formats on Template Definition
    • Hint: Define the individual templates first!
complex transactions1
Complex Transactions

Template Name Control Chars(Preceding)

Seq In Ident Control Chars(Following) Dep

=== ================ ======================== ===

1 Sales Header P: no

Hdr F: F1

2 Sales Detail P: yes

Det F: F1 F4 F4

3 Sales Trailer P: yes

Trl F: F1

  • Each format requires its own template.
  • Control Characters define the navigation between formats with preceding or following control codes.
  • Dependence – Should an error on a previous format cause this format to be bypassed?
complex transaction data example
Complex Transaction Data Example

Hdr::0002000,Bright,03/25/99,Rush Approved

Det::22-100,1000,35,45.50,3/25/99,,Red

Det::22-4000,1000,3,18.75,3/25/99,,

Det::22-230,1000,4,22.50,3/25/99,yes,

Trl::UPS 2-Day,43.58

  • Each record type has a record identifier with double colons ‘::’ to demark record identifier from data.
  • Fixed length formats define position 1 as after the double colons.
automating with sigconnects lite
Automating with SIGConnects/Lite
  • sigbtch.p for unattended processing
  • Run parameters from input file maparam.dat

/* parameters - 1 - input file name */

/* 2 - template definition name */

/* 3 - output file format */

/* 4 - exception report file name */

/* 5 - output file name */

/* 6 - audit report file name */

/* 7 - version */

/* 8 - release */

how to get sigconnects lite
How to Get SIGConnects/Lite

www.strategic.com

  • Fill in form with contact information
  • We email you with access password and download instructions from SIG’s FTP site
  • You download SIGConnects/Lite and documentation
  • Install it yourself
  • Email support group for support
sigconnects family
SIGConnects Family
  • Fully automated interfaces
    • Runs MFG/PRO software directly
    • Error suspension, correction, resubmission
    • Post-processing routines
    • Background Processor
  • Q/Linq support
  • Messaging support
  • Realtime version
sigconnects family1
SIGConnects Family
  • Additional formats
    • XML
      • Import/export XML definitions using DTD
    • Tag and Value
    • QAD Triplet
  • Output formatting
    • Any supported format
sigconnects family2
SIGConnects Family
  • Upgrade from SIGConnects/Lite
    • No reinstallation of software
    • No loss of SIGConnects/Lite templates or definitions
strategic information group
Strategic Information Group

Thank you!

Phil Coy

VP, Product Development

+1 724 251 9861

[email protected]

ad