Skip to main content
V
V_B_THAKARE6-Contributor
6-Contributor
April 3, 2024
Question

API for Import from spreadsheet and BOM extraction code.

  • April 3, 2024
  • 1 reply
  • 2279 views

Hi @HelesicPetr,

Can you please help me into below queries:

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.

1 reply

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
April 3, 2024

Hi @V_B_THAKARE 

1. No the dedicated API does not exist, You need to write own code to do so. Read the excel and create or update the parts in the system. 

2. what exactly you need? create multilevel bom by own code and write the results to your excel file ? Yes it is possible. 

 

for excel manipulation I use org.apache.poi.xssf.usermodel.package for xlsx XSSFWorkbook.class 

 

PetrH

V
V_B_THAKARE6-ContributorAuthor
6-Contributor
April 4, 2024

Hello @HelesicPetr, 

 

I want "Import from spreadsheet" option in Project container.

Currently this functionality is limited to Product and Library.

 

If we can't extend existing "Import from spreadsheet" functionality to project container.

 

Then we need to create custom action with Validator class so that the custom action will be visible only in Project container.

And then need to create class file with help of that we import spreadsheet within Project container.

 

So for that I need API or code which, I can use in my class file logic.

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire II
22-Sapphire II
April 4, 2024

Hi @V_B_THAKARE 

You don't understand. There is no general api for import from spreadsheet.

It is covered by Wizard Processor import from spreadsheet that works only with Product and Library. That is limitation of the function.

 

If you would use same function in the project, just remove the OOTB validator. But I'm sure it can not work that way. 

 

PS> just additional point of my experience: it is less time consuming to write own import function then to investigate how the OOTB function works and ho to rewrite it.

PetrH

    Terms & ConditionsCookie settingsAccessibility statement