How to create CIM file

casorohi

Member
Hello everyone,
I am new to mfgpro and I want to dump the all the data for 25.3.13 to create a Cim file from one db. And upload the data in another db through cim upload.

I see many example on this forum how to upload the data through cim upload under 36 option.
I want to first how I'll create cim for all the records under 25.3.13..
Help me out to how create a sim file for including all data under said menu.

Thanks
 

Pechadre

Member
Hello.

You must have for instance a excel macro.
With that you can create excel file with QAD CIM format. and after you can upload data in QAD.
You must respect each frame format (for example, you have a format for 1.4.1, an another for the 16.1 program etc. ).

I can give you the excel macro if you want and one or two examples ?

Bests regard.
 

qadvietnam

Member
Pechadre,

Could you let me know how to use CIM load data to MFG?

I want to Upload to:
  • Items Master
  • Inventory Transfer (location to location)
  • Reiceving Materials
Thanks
QAD Vietnam
 

Pechadre

Member
Hello,

You can see my answer for the next ticket "Could you let me know how to use CIM load data to MFG/PRO?"

For Items Master, your file entry must be like that :

@@batchload ppptmt.p
5391006
"EA" "Pochons pour coussin 409" ""
"NEGO" - - - - "COLLECT" "NEGO-WSA" - - - - "C1"
"A" - "WNA" "ENT" - "NON" - "" 90 120 - "NON" "OUI" - "Non" - "Non"
- "" "LB" - "" "LB" "" "CF"
"Oui" "Oui" 0 "POQ" 0 28 3 0 0 - "OUI" "NEGO-WSA" "SU000007" "WNA" "P" - "NON" 0 0 45 - "Non" - - "Non" 1 "" "" "Non" 100 0 0 "Non-taie" "Non" - 5391 -
.
@@end
@@batchload ppptmt.p
5392006
"EA" "Pochons pour coussin 409" ""
"NEGO" - - - - "COLLECT" "NEGO-WSA" - - - - "C1"
"A" - "WNA" "ENT" - "NON" - "" 90 120 - "NON" "OUI" - "Non" - "Non"
- "" "LB" - "" "LB" "" "CF"
"Oui" "Oui" 0 "POQ" 0 28 3 0 0 - "OUI" "NEGO-WSA" "SU000007" "WNA" "P" - "NON" 0 0 45 - "Non" - - "Non" 1 "" "" "Non" 100 0 0 "Non-taie" "Non" - 5392 -
.
@@end

One line for one frame
ppptmt.p program
French configuration
- means default value
. means F4

With this file, i can create 2 items, 5391006 & 5392006
pt_um = "EA", pt_desc1 = "Pochons pour coussin 409" etc...
pt_prod_line = "NEGO" etc....
pt_abc = "A", etc...
pt_ship_wt_um = "LB" etc....
pt_ms = Oui.

You can find the excel file and the excel macro for generate CIM ( excel version 2007 max ).

Bests regards.
 

Attachments

  • 141.xlsx
    11.1 KB · Views: 204
  • CIM50-97.XLA.zip
    111.6 KB · Views: 283

Pechadre

Member
Hello

I use a excel macro, it's not a qad tool.
You can find it in the prev ticket, it 's the CIM50-97.xla file.
You can use it with old excel's version until 2007.

Bests regards.
 
Last edited:
Top