Sage 100

 View Only

  • 1.  importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 10:52
    Hoping someone can help.  I need to import Extended Text to the W/T Templates in Prod Mgmt (below) and I'm just not seeing a way to do it re: the PM_Template file, and it doesn't appear we can import directly to CI_ExtendedDescription. I was kinda expecting it to be somewhat similar to importing I/M items with ext desc, where the ext desc is imported to the description field and it automatically writes to CI_ExtendedDescription as needed.

    This is related to Upgrading from Work Order to Prod Mgmt; the W/T Templates Extended Text didn't come over with the migration.  This was actually an issue back with v2019 which Scanco fixed, but apparently it's back.



    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------


  • 2.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 11:12
    Oh, I think I got it:  header 'Template Text' field.

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------



  • 3.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 11:36
    Of course now I have to figure out how to first join the multiple lines together for each Template, e.g. below, in Excel.  Anyone have a way to do that?




    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


  • 4.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 11:51
    Concatenate in your source data before importing, or perhaps:
    • Temp field, file assign for the previous value.
    • Temp field, replace with your column data.
    • Then have a calculation that concatenates the two temp fields together.


    ------------------------------
    Kevin Moyes
    Technical Systems Analyst
    Munjal White Consulting Co.
    ------------------------------

    Original Message


  • 5.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 11:52
      |   view attached
    If it helps, I use this report to export the step instructions from WOD.

    ------------------------------
    Amber Prayfrock, Blytheco
    ------------------------------

    Attachment(s)

    rpt
    WOD Routing Instructions Export.rpt   45 KB 1 version
    Original Message


  • 6.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 12:03
    Seems like a use case for Excel's TEXTJOIN and array function: https://theexcelclub.com/looking-up-and-combining-text-using-textjoin-and-array-if-statements/

    ------------------------------
    Steve Iwanowski, NextStep Technology Advisors, aka DSD Lancaster PA ¯\_(ツ)_/¯
    ------------------------------

    Original Message


  • 7.  RE: importing Extended Text data into PM_Template (Prod Mgmt)

    Posted 01-19-2023 12:11
    Thanks, all!  I think I found a way to do it via this Excel formula =IF(A2=A1,F1&", "&E2,E2), but I'm definitely gonna look at @Amber Prayfrock 's  rpt.



    ​​

    ------------------------------
    Brett Zimmerman
    Net at Work
    Greater Boston Area
    ------------------------------

    Original Message


Related Content