Import Failure while importing from one line item to another in same module.

aakash

Can anyone explain me the cause of the error " No value loader exists for this type: NONE " . Error Details.PNG

Any help would be appreciated.

Thanks

Accepted answers

usman.zia

Hi @aakash

As @Hayk mentioned the DCA you should try removing the DCA and seeing if you have this issue and then you will know if its the DCA that is causing the issue.

Thanks,

Usman

All comments

usman.zia

Hi @aakash

This error could be due to importing from one format to another. Such as text to number or a list to a non list format, or date to text.

It would be good to see a screen shot of the where you are importing from and where you are importing too.

Thanks,

Usman

Hayk

Hi @aakash ,

do you use DCA for target module/line item?

Regards

Hayk

aakash

@Hayk

Yes I am using DCA for the Target . Please let me know what impact will it have on the import .

There is no difference of dimensions as the source is a view of the target module.

I have verified both the source and target have same format (Boolean)

Please find source and target below respectively. (First one is source and second one is target).

Thanks and Regards

Aakash

usman.zia

Hi @aakash

As @Hayk mentioned the DCA you should try removing the DCA and seeing if you have this issue and then you will know if its the DCA that is causing the issue.

Thanks,

Usman

aakash

Hi @usman.zia , @Hayk

I tried removing DCA and the import is now working fine. But still I can't remove DCA from the module as per the business requirements , can you suggest some workaround for the same problem?

Thanks and Regards

Aakash

usman.zia

What’s does the DCA drive? Because you could use this to create a saved view driven by the same Boolean that drives the DCA using filtering.

You could create a saved view and test to see if having the saved view is the same as having the DCA? However depending on how you create this view there will be a risk of being able to access the source module data but you will need to test this.

I hope that this helps.

Thanks,

Usman

rob_marshall

@aakash ,

Since you are using DCA and that field is read only, you will need to either have someone else load the data who has write access or create a process where the process first changes the DCA access to write, loads the data, and then changes the DCA back to read only access.

Hope this helps,

Rob

aakash

Hi All

Thanks for all your suggestions but I am still unable to understand how does DCA interferes with the import as it is clearly mentioned on the anapedia that workspace admins can import data into all the cells including read only and invisible cells.

aakash

What I observed was that when I don't specify a read access driver but do specify a write access driver , the import does not work whereas when I turned the field to read only from invisible by specifying a read access driver, the import is working fine.

Thanks and Regards

Aakash

Quick Links

Can you help?

Unanswered questions

Anaplan Matillion Integration
I have a requirement to extract last 90 days data from an Anaplan model through Matillion. I wanted to know is there any API which I can use to achieve the same? I have taken a look at the (Integration APIs) Bulk API as well as Transactional API and none of them has a relevant query parameter which I can use to apply the…
How to create Anaplan formula MTD with Input Date
Hi, I'm trying to create a month to date line that is based on a specific input date, not the actual date. Is this possible?
How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…