Skip to main content
S
sagarwal-41-Visitor
1-Visitor
May 26, 2017
Question

How to import Excel file in Integrity via using gateway wizard or any other customization?

  • May 26, 2017
  • 1 reply
  • 11924 views

I have tried to edit gateway file, mapping file but unable to find any solution for import of Excel document in Integrity..Could anybody know the solution for this..?

    1 reply

    V
    VolkerEckardt17-Peridot
    17-Peridot
    May 26, 2017

    Hi Shubham,

    I see generally two options:

    1. You can go with the Integrity Standard. You create the Document header (doc Item) only and then you use the Document Edit capability (Excel Integration) to add more rows as needed.
      • Document header must exists
      • This integration can not handle section levels (at least I am not aware of)
    2. You can use my own Excel Loader via Gateway
      • This is a customization on top of the standard gateway.
      • You need to have some local java classes (jar files)
      • It fully supports document header creation
      • It fully supports section levels.
      • You may also use it for later updates, even if not intended.
      • It can handle also some basic formatting elements (coloring, bold, underline) - only if you use a local MS HTML converter (VBasic)
      • I am attaching herewith an example of how the template will look like.

    Let me know if you like to get more details about the Excel Loader in option #2.

    Volker

      S
      sagarwal-41-VisitorAuthor
      1-Visitor
      May 26, 2017

      Hi Volker,

      As we Import any Word document by creating template and by using gateway feature. Now Suppose we have a Customer requirement Document in Excel and want to import that in integrity, how to do that..?

      V
      VolkerEckardt17-Peridot
      17-Peridot
      May 26, 2017

      Let me explain a bit more:

      1/ This is pure Integrity Standard.

      Read the documentation for the MS Excel Add On at our Support Page (Software Download)

      2/

      I will send you a document explaining the customization.

      It's written in Java and contains about 6 files (jar, xml, one addition to gateway.lax, etc.)

      It has to be added to the Gateway configuration to take affect.

      The installation will usually take 1h.

      If you just have to upload 1 document, then I would go with the Excel Standard Add-On Integration.

      If the Excel doc upload will be executed more than once, I would turn to the solution #2.

      But if technical support is critical for you, then you can only go with #1.

        Terms & ConditionsCookie settingsAccessibility statement