Sage 100

 View Only
  • 1.  Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 14:12
    Anyone ever imported image links to Item Maintenance? I can see the field ImageFile in CI_Item, but it does not contain a path, where does the path go?


  • 2.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 14:23
    Isn't it MAS90\Images\XXX\ where XXX is the company code?


  • 3.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 14:53
    I believe @ThereseLogeais is correct. It is a hard coded path.


  • 4.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 14:55
    * In Windows Explorer, copy the image files to ..\Mas90\Images\xxx folder (xxx = company code). * In the import job, import only filenames into the CI_Item field. Do not include path information. For example, import ""Image1.jpg"" rather than ""C:\Mas90\Images\Abc\Image1.jpg."" * If the items are already defined in Inventory Maintenance, import only the ItemCode (key field) and Image fields. Note: 1. Only .JPG, .GIF, and .BMP files can be used. 2. JPG and .GIF files are recommended because .BMP files are usually large and affect performance. 3. The image will not display in Sage 100 Advanced or Premium if a mapped drive was used when running Workstation Setup. Use a UNC to connect to the server and run Workstation Setup.


  • 5.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 15:18
    Since the file types are limited (PDF not available) I have written button scripts that can be used to access a PDF based on the part number on the panel.


  • 6.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 15:57
    They live under MAS90\Images\XXX where XXX is the company code.


  • 7.  RE: Anyone ever imported image links to Item Maintenan

    Posted 04-22-2015 17:24
    Oh ok I get it now, when I linked to a file that was not in the images folder, it copied it there. That was the part I was missing. Thanks everyone.