Distribution, Manufacturing, and Internet Modules

[NPIC]

I can important bill of material header information to BM1 table thru VI but no luck on the components.  Can anyone be helpful for this?

[BigLouie]

Sure, how many zeros (0) can you put on a check, hahaha....

When importing into files in which there is a head and detail or in this case a kit and component it is important to setup the Records section correctly. If not then you get no details.  Can you do the following.

1. State which version of MAS you are on.

2. Copy and paste the import job here.

[NPIC]

  BigLouie

The version of MAS 200 extended Enterprise Suite is 4.30.0.18

Here are the import job:

-------------------------------------------------------------------------------------------------------------
ITEM   ITEM NAME         FG TYPE      OPERATION     COLUMN   IMPORT MASK               SUB-STRING
-------------------------------------------------------------------------------------------------------------
00001  BILL_NUMBER       H  STRING    REPLACE       00001    Start: 1   Len: 15        No
00002  BILL_REVISION     H  ACCOUNT   REPLACE       00002    ###                       No
00003  MAIN_BILL_BLNKS   H  STRING    REPLACE       00003    Start: 1   Len: 3         No
00004  BILL_TYPE         H  STRING    REPLACE       00004    Start: 1   Len: 1         No
00005  CURRENT_REV       H  ACCOUNT   REPLACE       00005    ###                       No
00006  PRNT_COMP         H  YES/NO    REPLACE       00006    Start: 1   Len: 1         No
00007  ROUTING_NUM       H  STRING    REPLACE       00007    Start: 1   Len: 20        No
00008  HAVE_OPT          H  YES/NO    REPLACE       00008    Start: 1   Len: 1         No
00009  OPT_INT           H  YES/NO    REPLACE       00009    Start: 1   Len: 1         No
00010  OPT_CATS          H  STRING    REPLACE       00010    Start: 1   Len: 1         No
00011  DESCRIP_1         H  STRING    REPLACE       00011    Start: 1   Len: 30        No
00012  DESCRIP_2         H  STRING    REPLACE       00012    Start: 1   Len: 30        No
00013  DRAW_NUM          H  STRING    REPLACE       00013    Start: 1   Len: 20        No
00014  DRAW_REV          H  STRING    REPLACE       00014    Start: 1   Len: 3         No
00015  MAX_LOT_SIZ       H  NUMBER    REPLACE       00015                              No
00016  YIELD_PERCNT      H  NUMBER    REPLACE       00016                              No
00017  ITEM_CODE         L1 STRING    REPLACE       00017    Start: 1   Len: 15        No
00018  LINE_TYPE         L  STRING    REPLACE       00018    Start: 1   Len: 1         No
00019  COMP_REV_CODE     L1 ACCOUNT   REPLACE       00019    ###                       No
00020  WO_STEP           L1 STRING    REPLACE       00020    Start: 1   Len: 4         No
00021  QTY_PER_BILL      L4 NUMBER    REPLACE       00021                              No
00022  SCRAP_PERCENT     L1 NUMBER    REPLACE       00022                              No
00023  FIND_NUM          L1 STRING    REPLACE       00023    Start: 1   Len: 5         No
00024  MISC_SLASH        L5 STRING    REPLACE       00024    Start: 1   Len: 1         No
00025  MISC_GL_ACCNT     L3 STRING    REPLACE       00025    Start: 1   Len: 12        No
00026  POST_BY_WHSE      L3 YES/NO    REPLACE       00026    Start: 1   Len: 1         No
00027  SETUP_CHARGE      L3 YES/NO    REPLACE       00027    Start: 1   Len: 1         No

   RECORD SELECTION
-------------------------------------------------------------------------------------------------------------
ITEM   TYPE   DESCRIPTION                       COLUMN  START   LENGTH  RELATION  VALUE
-------------------------------------------------------------------------------------------------------------
00001    1    Component Line                    00017   00001   00001   =         
00002    2    Comment Line                      00017   00001   00001   =         

   VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM   FIELD                         METHOD         SKIP  FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00001  BILL_NUMBER                   EXPRESSION      N    BM1$(1,20)<>DIM(20)
00002  BILL_REVISION                 EXPRESSION      N    BM1$(21,3)<>DIM(3)
00003  MAIN_BILL_BLNKS               EXPRESSION      N    BM1$(24,3)=DIM(3)

Run Date: 07/21/2010                              Dummy Company                               Page: 2
V/I Date: 07/21/2010                  JOB DEFINITION PRINTING FOR JOB: BOMT                   Time: 01:59 PM

   VALIDATION RECORDS
-------------------------------------------------------------------------------------------------------------
ITEM   FIELD                         METHOD         SKIP  FILE/STRING/EXPRESSION
-------------------------------------------------------------------------------------------------------------
00004  BILL_TYPE                     STRING          N    SKPEI
00005  ROUTING_NUM                   FILE            Y    WO.ROUTING
00006  HAVE_OPT                      UPPERCASE       Y    N
00007  CURRENT_REV                   EXPRESSION      N    BM1$(138,3)<>DIM(3)
00008  OPT_INT                       STRING          Y    YN
00009  OPT_CATS                      STRING          Y    YNR
00010  PRNT_COMP                     UPPERCASE       N    YN
00011  ITEM_CODE                     FILE            N    IM.ITEM
00012  LINE_TYPE                     STRING          N    123
00013  COMP_REV_CODE                 EXPRESSION      N    BM2$(22,1)<>DIM(3)
00014  MISC_SLASH                    STRING          N    /
00015  MISC_CODE                     FILE            Y    BM.MISC
00016  MISC_GL_ACCNT                 FILE            N    GL_Account
00017  POST_BY_WHSE                  UPPERCASE       N    YN
00018  SETUP_CHARGE                  UPPERCASE       N    YN
00019  UDF_TYPE                      LIST            Y    L

[TomTarget]

Search the knowledgebase.  There is a nice article in there on exactly how to do it.

resolution id 505147

[BigLouie]

RECORD SELECTION
-------------------------------------------------- -----------------------------------------------------------
ITEM   TYPE   DESCRIPTION                       COLUMN  START   LENGTH  RELATION  VALUE
-------------------------------------------------------------------------------------------------------------
00001    1    Component Line                    00017   00001   00001   =         
00002    2    Comment Line                      00017   00001   00001   =         

Well heck here's your problem. You are telling the import that if at column 17 start 1 and length of 1, if this value is BLANK then it is a component.  You need to have a value or have <> instead of =

Notice that you have Comment Line in there also looking at the same spot.

[NPIC]

BigLouie,

I tried your suggestions:

1) Added a value to the column 17

2) Moved the comment line

But I still couldn't get anything imported to BM2.  Do you know why?

NPIC

[BigLouie]

*sigh*

Let's say that you put a value of 1 in column 17 of your source file. Then the record section should say:

00001    1    Component Line                    00017   00001   00001   =       1