Sage 100

 View Only

  • 1.  Importing Item Extended Description

    Posted 06-24-2020 02:03
    I am importing inventory descriptions and many have extended descriptions.  I know the data past 30 characters normally goes to the extended description.  My client does not want the first 30 characters going to the first part of the description.  They have a range where the 1st part would display somewhere between 3 to 30 characters.  On the descriptions less than 30 for the 1st part I'm trying to figure out how to only get those characters in the first part and then have the rest go to the extended description.I have tried many options with the excel file and with visual integrator.  So far I have only come up with adding an * to make the first part 30 characters.  Any ideas?

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------


  • 2.  RE: Importing Item Extended Description

    Posted 06-24-2020 09:05
    What about using the below 'Record' option to control the position of the data being imported?



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



  • 3.  RE: Importing Item Extended Description

    Posted 06-24-2020 09:13
    I tried several attempts with the Record Substring, however I did not put any temp fields in.  What is your calculation as I cannot read it?

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 4.  RE: Importing Item Extended Description

    Posted 06-24-2020 09:34
    Sorry, that calc has nothing to do with this; it was just present on the field I happened to pull up for the screen-shot.  But fyi that formula, SUB(Temp001$,"|",$0d$), replaces any pipes in the import source file with a carriage return, in order to retain the carriage returns in the extended item descriptions (of which originally we had to first replace the carriage returns in Excel with a pipe).

    Also, is this a one-time import or an ongoing import?  If the former, I would think you could manipulate the data in Excel so that it imports how you need, although it sounds like you've already tried some of that.

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

    Original Message


  • 5.  RE: Importing Item Extended Description

    Posted 06-24-2020 10:22
    It is a one time import.  I have the ASAP Excel Utility add on and I could not get the end result I wanted in Excel even with it.  However I did try a carriage return and anything after the carriage return did not import.  So, your formula may actually get me to the desired outcome.  Can you send me your import job?

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


  • 6.  RE: Importing Item Extended Description

    Posted 06-24-2020 10:09
    After many attempts to use Sage fields in ways that are not part of the system design, I have a general aversion to even trying. 
    My recommendation: use the stock description field the way it was intended and add a UDF for their other business goal.

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



  • 7.  RE: Importing Item Extended Description

    Posted 06-25-2020 10:14
      |   view attached
    @Michele Herzog, attached... ​

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

    Original Message


  • 8.  RE: Importing Item Extended Description

    Posted 06-25-2020 10:39
    Thank you so much @Brett Zimmerman, I will give this a try.​

    ------------------------------
    [Michele] [Herzog] [CPA,CITP, CGMA]
    [Overland Park] [KS]
    [816-520-1365]
    ------------------------------

    Original Message


Related Content