Loading ...
Sorry, an error occurred while loading the content.

CSV to STK

Expand Messages
  • westerman@chanuteks.com
    I have a cabinet design software that outputs the following CSV file for the parts needed to build the cabinet. This represent 7 of the parts. There are
    Message 1 of 2 , Jul 1, 2001
    • 0 Attachment
      I have a cabinet design software that outputs the following CSV file
      for the parts needed to build the cabinet. This represent 7 of the
      parts. There are actually many more.


      "APS Fleet","APS FLEET","1-12","1","28","29","28","29","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T05Y0","","","","","",""
      "APS Fleet","APS FLEET","1-9","1","28","26","28","26","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T0410","","","","","",""
      "APS Fleet","APS FLEET","1-10","1","28","26","28","26","BACK","1/2
      MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071T04Z0","","","","","",""
      "APS Fleet","APS FLEET","1-
      12","1","4","27.5","4","27.5","NAILERS","1/2 MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071P05X0","","","","","",""
      "APS Fleet","APS FLEET","1-
      12","1","4","27.5","4","27.5","NAILERS","1/2 MELAMINE-2
      SIDES","","","","","","","","","","","","","","","","","","","Length",
      "071P0600","","","","","",""
      "APS Fleet","APS FLEET","1-
      7","1","23","46.5","22.97","46.5","FLOOR","3/4 MELAMINE-2
      SIDES","1L","Front","1 mm 15/16 PVC Edg
      Bnd","0.03","","","","","","","","","","","","","","","Length","072H03
      10","","","","","",""
      "APS Fleet","APS FLEET","1-
      7","1","23","46.5","22.97","46.5","FLOOR","3/4 MELAMINE-2
      SIDES","1L","Front","1 mm 15/16 PVC Edg
      Bnd","0.03","","","","","","","","","","","","","","","Length","072N03
      20","","","","","",""

      I need a clip that will create two or more new files from a sorting
      of the data in cell 10. In this case cell 10 is 1/2 MELAMINE-2 SIDES
      for some parts and 3/4 MELAMINE-2 SIDES for other parts. There may be
      as many as 6 different materials listed in cell 10.

      After the clip sorts this into two or more new files, the files need
      to be named from the first 6 characters of the data in cell 1 and two
      numbers starting with 01. Thus, file one would be APSFLE01.STK, file
      two would be APSFLE02.STK, etc. STK files go directly into another
      software that optimizes the parts layout on a sheet of material to
      get the best yield.

      Then each of these two or more files would need to be reformated into
      the following STK format. Only data from cell 4,7,8 and 9 to be used.
      The rest is discarded.


      first file


      [ISTK-1]
      L=28.00 ;7th piece of data
      B=29.00 ;8th piece of data
      A=1 ;4th piece of data
      REF=BACK ;9th piece of data
      [ISTK-1]

      [ISTK-2]
      L=28.00
      B=26.00
      A=1
      REF=BACK
      [ISTK-2]

      [ISTK-3]
      L=28.00
      B=26.00
      A=1
      REF=BACK
      [ISTK-3]

      [ISTK-4]
      L=4.00
      B=27.5
      A=1
      REF=NAILERS
      [ISTK-4]

      [ISTK-5]
      L=4.00
      B=27.5
      A=1
      REF=NAILERS
      [ISTK-5]


      second file


      [ISTK-1]
      L=22.97
      B=46.5
      A=1
      REF=FLOOR
      [ISTK-1]

      [ISTK-2]
      L=23.25
      B=46.5
      A=1
      REF=FLOOR
      [ISTK-2]


      Then each to be saved.

      Is this something within the abilities of a NoteTab clip? Or should I
      seek other software to do this? I spend several hours retyping data
      from one software into another each week.

      Thanks

      Craig ><>
      westerman@...
    • RS
      Hi Craig , ... Yes, it can be done with a clip. Depending on the size of the files, it could take a while to complete the task. But you can always have some
      Message 2 of 2 , Jul 1, 2001
      • 0 Attachment
        Hi Craig ,

        At 02:29 AM 7/2/01 -0000, you wrote:
        >I have a cabinet design software that outputs the following CSV file
        >for the parts needed to build the cabinet. This represent 7 of the
        >parts. There are actually many more.
        >
        >
        >"APS Fleet","APS FLEET","1-12","1","28","29","28","29","BACK","1/2
        >MELAMINE-2
        >SIDES","","","","","","","","","","","","","","","","","","","Length",
        >"071T05Y0","","","","","",""

        >Is this something within the abilities of a NoteTab clip? Or should I
        >seek other software to do this? I spend several hours retyping data
        >from one software into another each week.


        Yes, it can be done with a clip.

        Depending on the size of the files, it could take a while to complete the
        task. But you can always have some coffee in the meantime ... :)

        If speed is of the essence, you might prefer a small compiled program in
        Delphi or C++.

        I, personally, would try NoteTab first. You might be surprised how
        efficient it can be.


        Best regards,

        Ramon Silvera

        ----------------------------------------------------------------------------

        ClipWriter 2.5 http://ptools.home.att.net/ClipWriter/cw.htm
      Your message has been successfully submitted and would be delivered to recipients shortly.