Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Importing into IM.Price Issues

Status
Not open for further replies.

powerwav

Programmer
Jan 28, 2004
2
0
0
US
I am tring to Import a csv file with import master on MAS90 3.61 and it will not import for nothing. Her is a sample of my csv file

Price_Code_Rec, Price_Code, PC_Cust_Prc_Lvl, ItemNumber, IM_Cust_Prc_Lvl, Division_No, Customer_No, Disc_Mkup_Prcr1
___________________________________________________________
"1",,,"G1001 ","B",,,19.76
"1",,,"G1001 ","F",,,27.5
"1",,,"G1001 ","R",,,54.94
"1",,,"G1001 ","W",,,35.75
"1",,,"G1001 ","Y",,,0
"1",,,"G1001 ","Z",,,11
"1",,,"G1001*10 ","B",,,19.76
"1",,,"G1001*10 ","F",,,27.5
"1",,,"G1001*10 ","R",,,54.94
"1",,,"G1001*10 ","W",,,35.75
"1",,,"G1001*10 ","Z",,,11
___________________________________________________________

I have those select fields listed in the import master data, when importing i see the first record (1) and nothing else. Can someone please help?

Thank you.
Loren Erickson
 
I'd used the import below with success, however, we are still on the older version 3.21

1st section will be the import configuration then below will be the data:

Run Date: 03/17/04 IMPORT MASTER MAINTENANCE LISTING REPORT NAME: PRICE DESCRIPTION: PRICE BREAK IMPORT
--CONFIGURATION INFORMATION---------------------------------
FILE NAME: IM.PRICE I/M Price Code File
IMPORT FILE: i:\imports\price.csv
FILE TYPE: Delimited DELIMITER: ,
INSERT ALL REQUIRED FIELDS DURING SETUP: Y
HEADER INFORMATION INCLUDED IN DETAIL LINES: N
PASSWORD: NO
--DATA ITEMS------------------------------------------------ITEM ITEM NAME TYPE OP COLMN DISPLAY MASK
------------------------------------------------------------
1 PRICE_CODE_REC STRING REPL 00001 Start: 001 Len: 001
2 BREAK_QTY1 NUMBER REPL 00002
3 BREAK_QTY2 NUMBER REPL 00003
4 ITEM_NUMBER STRING REPL 00004 Start: 001 Len: 015
5 IM_METHOD STRING REPL 00005 Start: 001 Len: 001
6 DISC_MKUP_PRCR1 NUMBER REPL 00006
7 DISC_MKUP_PRCR2 NUMBER REPL 00007

--RECORD TYPE SELECTIONS------------------------------------RECORD TYPE DESCRIPTION COLUMN START LENGTH RELATION VALUE
------------------------------------------------------------
SKIP RECORD
1 PRICE RECORD
2 ITEM PRICE RECORD 00005 001 01 = O
3 ITEM/CUST PRICE REC



Here is data:


A03-10-1185,1,3,A03-10-1185,O,15,15
A03-10-1185,3,99999,A03-10-1185,O,15,13.5
A03-10-1186,1,3,A03-10-1186,O,15,15
A03-10-1186,3,99999,A03-10-1186,O,15,13.5
A03-12-1086,1,3,A03-12-1086,O,22.5,22.5
A03-12-1086,3,99999,A03-12-1086,O,22.5,20
A03-12-1248,1,3,A03-12-1248,O,19.5,19.5
A03-12-1248,3,99999,A03-12-1248,O,19.5,16.5
A03-12-847,1,3,A03-12-847,O,22.5,22.5
A03-12-847,3,99999,A03-12-847,O,22.5,19.5


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top