Highlighted
Master Anaplanner/Community Boss

Re: Module to module import issue

Hi,

 

Could it be due to Dynamic Cell Access?

 

Thanks,

LipChean

Highlighted
Contributor

Re: Module to module import issue

@LipChean_Soh 

Does the Dynamic Cell Access impact the imports? Coz all the Target Line Items for my import have read access enabled on them.

 

Saurabh

Highlighted
Master Anaplanner/Community Boss

Re: Module to module import issue

Yes

Read DCA access will prevent end users loading data into the lines

Admins and Full access can run the imports regardless of DCA settings

David

Highlighted
Contributor

Re: Module to module import issue

Thanks @DavidSmith and @LipChean_Soh , I will test this now.

 

Saurabh

Highlighted
Contributor

Re: Module to module import issue

Hi @saurabh.raheja 

Did you find a solution to this?

I´m facing the same challenge..

Cheers,
Stig

Highlighted
Contributor

Re: Module to module import issue

Hi @Stig 

 

Yes, the issue was due to Dynamic Cell Access. 

I had applied Read Access to the line item end user was importing in which prevented this. Let's call this Import "Update Previous Cycle Data"

 

To get around this issue while still keeping the Read access intact, I did the following.

 

- Added 4 Boolean line items to the Access Control module which previously only had 1 Line Item "Read Access"

1. Read Access - Formula: TRUE

2. Write Access - Input (Used as a Write Access driver in the Target line item for the import in question)

3. Grant - Formula: TRUE 

4. Revoke - Formula: FALSE

 

- Created 2 import actions within Access Control module as below

1. Grant Access - Imports the value of line item "Grant" into Write. This gives the user temporary write access.

2. Revoke Access - Imports the value of line item "Revoke" into Write. This takes back the write access.

 

- Created a Process with Import actions in the following order.

1. Grant Access

2. Update Previous Cycle Data

3. Revoke Access

 

Regards

Saurabh

Highlighted
Contributor

Re: Module to module import issue

Thanks a mill @saurabh.raheja  - I'll try this out.