4 Replies Latest reply on Nov 17, 2017 8:09 AM by Jouni Piirto

    PDM excel material list

    Jouni Piirto

      Hello.

      Information and guestion 1

      I have exel list for materials, like this. (alot bigger)

      picture 1.png

       

      I have similar structure folder in PDM:

      Foldet 1

           Material

                Alunimium

                     Plate

                Plastic

                     Plate

                Steel

                     Plate

                     Bar

                     BEAM

      .......

      and there i have part name "value 5", like PL-2 S235JRG2

      This part have all information Value 1-5 + others (value 6.7.8. lenght......)

      (We use native part that have all information, and we insert part to assebmy and save as command to project folder)

       

      I can make new part plate where is 2 holes, i save this in project folder and i want to give information.

      (Material, plastic, Plate, CONSUMPTION PLASTIC, S=6 PE1000 (+ others))

      Value 1-5 is trop down list, others is inside part for bill of materials properties, but value 1-5 is need to save part information too.

       

      Project folder sturucture

      Project

           Project 1

           Project 2

           Perject 3

                Design

                     POS 1

                     POS 2

                     POS 3

                          3D Models

       

      How i make File card?

       

      I have been tray to make Lists, text with alias..

      Kuva 2.png

      How i can use this exel or material folder structure in card?

       

      Question 1

      But File card come too heavy if i use several text with alias. (i had make this allredy)How to make file card? shomthing like this.

       

      kuva 3.png

       

      So i can take value 1 to value 5 step by step,

      or i ignore step 1-3 and only use step 4 an 5, when i use value 5, its write information 1-8 to data card and part.

       

      Question 2

      i need add 1 material, like this

      Material, plastic, Plate, CONSUMPTION PLASTIC, S=20 PE1000

      i give information value 6 75, value 7 1000, value 8 MATERIAL 24.

      how them come easy to datacard, i update exel, or only save this part to correct folder (or both)?

       

      Sorry for bad english.