API for Import from spreadsheet and BOM extraction code.

[V_THAKARE]

Question 1 : Is there any API for Import from spreadsheet.

Question 2 : Anyone know about BOM extract report code so that we can use similar to create a BOM.

[avillanueva]

Import from spreadsheet is a UI action in the Folder page. There are other avenues if you want to import BOMs via spreadsheet like CSV2XML or direct Java APIs.  What are you looking to do?

I am not sure what you are asking about the second question. Can you clarify?

[V_THAKARE]

Hi @avillanueva,

I want Import from spreadsheet action in Project container.

Currently this functionality is limited to Product and Library.

[V_THAKARE]

Hi @avillanueva ,

If I run jcaDebug in Project container, I can see Import from spreadsheet option which is grayed out(see attached screenshot).

Question : Import from spreadsheet is grayed out in Project container, Is it due to ACL or OOTB validator?

[HelesicPetr]

@V_THAKARE 

Generally it is based on the validator. 

if the function is greyed out based on ACL it is also checked by validator and the validator checks the ACLs. 

PetrH