2 Replies Latest reply on Nov 15, 2012 1:22 AM by ziceg

    How to script an import from excel to a portal?

    ziceg

      As always scripting is my weakest point.... I would like to set up an easy way to import from excel some records to go into a portal. Let me explain this a bit better...

       

      I have:

      - Table A with various fields, and ID field

      - Table B (part no, description, qty) ID field and link field to Table A ID field

      - Layout 1 where all the info for Table A shows and via a Portal info of Table B is shown

       

      The aim is that whenever the user is in a particular record on Table A he can import from an excel sheet various items into Table B for that particular record on Table A. This is going to be a recurring thing so I would like to put in a scripted button to make it easy on the user.

       

      Thanks