Skip to content

Import Export PowerTool

import data into Entry tables

Viewing 6 posts – 1 through 6 (of 6 total)
  • Author
    Posts
  • #8307
    Valcea M.

    Hi,

    Thanks for  “Import Export PowerTool”, very good and flexible tools for data migration.

    I’m using  this tool for data migration from one company to another in BC 365 SaaS implementation and is not working for G/L Entry table: the error is related to permission missing.

    In the past I modified the XML permission in order to write data to G/L Entry but this is not possible anymore.
    Is this a limitation or is missing permissionset ?

    Thanks again for your great works
    Mihai
    <div id=”simple-translate” class=”simple-translate-system-theme”>
    <div>
    <div class=”simple-translate-button isShow” style=”background-image: url(‘chrome-extension://cllnohpbfenopiakdcjmjcbaeapmkcdl/icons/512.png’); height: 22px; width: 22px; top: 34px; left: 294px;”></div>
    <div class=”simple-translate-panel ” style=”width: 300px; height: 200px; top: 0px; left: 0px; font-size: 13px;”>
    <div class=”simple-translate-result-wrapper” style=”overflow: hidden;”>
    <div class=”simple-translate-move” draggable=”true”></div>
    <div class=”simple-translate-result-contents”>
    <p class=”simple-translate-result” dir=”auto”></p>
    <p class=”simple-translate-candidate” dir=”auto”></p>

    </div>
    </div>
    </div>
    </div>
    </div>

    #9610
    Travis P.
    Insight Works

    Since you are importing data, make sure that your user has SUPER permission with no company restrictions.

    In this case you will need to allow access to both updates and protected tables on the Import Export PowerTool Setup page.

    Don’t forget to disable Import Export PowerTool Setup once you are done with the tool, to prevent accidental usage.

    #9658
    Juan H.

    Hi!

    I have the same problem as Mihai.

    I am trying to import table General Ledger Entry. During the procees, the application asks me for “No write permission on General Ledger Entry. Continue?“. And I click “Yes“. Then, it ends the process by saying that 13 rows have been imported. But in General Ledger Entry no entry is shown.

    My user has SUPER permission and in “Import Export PowerTool Setup” the field “Update Access” = “Allow” and “Protected Tables” = “Allow Access”.

    I think this tool would be very powerful if it could insert and modify entry tables.

    Thanks for all

    Juan Carlos

    #9798
    Joselyn L.

    Can you confirm if the tool can import to Entry tables, or if it is a limitation? I tried Job  Ledger Entries and it is giving permission issues. Thanks!

    #9799
    Joselyn L.

    I have the correct permission sets but the system still does not allow updating the Ledger Entries. Can you confirm if it is possible to use this tool for Entry tables?

    #9801
    Terri V.
    Insight Works

    Hello Joselyn,

    The Import Export Power Tool is not able to access the Job Ledger Entries table at this time. We are looking to add this functionality to a future release.

    Thank you,

Viewing 6 posts – 1 through 6 (of 6 total)
  • Sign in below to reply.