Hi Arturo,
The spreadsheet format supported by the online tools follows a specific format that includes all the fields as columns supporting the entire spec. It wasn’t intended to just support the LITE format, although that isn’t a bad idea. We could add an issue in the SPDX Spreadsheet Store <https://github.com/spdx/spdx-java-spreadsheet-store> to support a LITE version and see if we find any volunteers to implement it. I’ll be pretty focused on upgrading the libraries to 3.0 for the next few weeks, so it may be a while before I can look into it. Although the columns and sheets are required, you don’t need to have any values for any of the columns not in the LITE profile. What I would suggest is starting with the full spreadsheet and just fill in the columns which are relevant. You can take the SPDX example XLS document <https://github.com/spdx/spdx-spec/blob/development/v2.3.1/examples/SPDXSpreadsheetExample-v2.3.xls> and remove the data for as starting point. Using the Python API’s is also a good option for generating the output if that is easier. You can also use the Tag/Value, JSON or YAML formats and convert those to RDF/XML – YAML is a reasonably human readable / writable option. Regards, Gary From: [email protected] <[email protected]> On Behalf Of [email protected] Sent: Friday, June 2, 2023 8:34 AM To: [email protected] Subject: Re: [spdx] Interpretation of Errors and Exceptions from SPDX Online Tools #spdx Hello Gary, Sorry for late response. Thanks for your input, however let me first tell you a bit more of what I'm trying to achieve. Annex G of the SPDX v2.2.2 spec (SPDX Lite <https://spdx.github.io/spdx-spec/v2.2.2/SPDX-Lite/> ), there is a subset of mandatory fields of the Document Creation and Package Information sections to create the document and also "keep compatibility with SPDX tools". Even though I have ensured that these fields are introduced in my SPDX XLS Document, the validation tool throws these error messages: Analysis exception processing SPDX file: Column <Name_of_column> missing for SPDX <Clause> worksheet As I keep adding the missing columns in each of the worksheets the error message updates to the next missing column or worksheet missing. I'm not sure if this SPDX Lite format is supported by the tools. At the end I want to validate to be able to convert the XLS to RDF/XML. On the other hand, I've been using the python-tools API to create my desired output format. Let me know if it is still worth for me to report the issue, or is this expected behaviour. Regards, Arturo -=-=-=-=-=-=-=-=-=-=-=- Links: You receive all messages sent to this group. View/Reply Online (#1695): https://lists.spdx.org/g/spdx/message/1695 Mute This Topic: https://lists.spdx.org/mt/99231219/21656 Mute #spdx:https://lists.spdx.org/g/spdx/mutehashtag/spdx Group Owner: [email protected] Unsubscribe: https://lists.spdx.org/g/spdx/leave/2655439/21656/1698928721/xyzzy [[email protected]] -=-=-=-=-=-=-=-=-=-=-=-
