Hi Kotrappa,
The CSV approach is a good idea. The code already has some support for this. There are some issues to be worked out on how to deal with multiple worksheets and mapping that to the csv. We ran into the same issue with the license list excel file. We solved this by creating external .txt files and hyperlinking from the spreadsheet to the text files. Do you think this approach would work for you? You can see an example at http://git.spdx.org/?p=license-list.git;a=blob_plain;f=spdx_licenselist_v2.0 rc3.xls;hb=HEAD I'm pretty booked for the next 2-3 weeks with SPDX 2.0 work, so it will be a while before I can get to the fix. If you or others on the distribution list would like to create a fix and send me a patch or a pull request on the github clone (https://github.com/goneall/SPDX-Tools), I can do a quick build. Another approach would be to pre-process the SPDX document to check for the license text length and truncate it with a warning. Best regards, Gary From: [email protected] [mailto:[email protected]] Sent: Tuesday, March 17, 2015 12:18 AM To: [email protected] Cc: [email protected]; [email protected] Subject: RE: SPDX tools 1.2.9 - "Per File Info" sheet is kept blank when "TagToSpreadsheet" has been run Hello Gary, In your busy work, Sorry to ask you on the below bug. Do you have any updates on resolving this issue? Since it is limitation of excel, how do you plan to resolve this? One possible solution would be, can we have one more option in tool to convert .spdx into .CSV files? I mean .spdx would be converted to "<PackageName_version>_PerFileInfo.CSV", "<PackageName_version>_ExtractLicInfo.CSV" etc, In this way, we can avoid the limitation of excel cell, and since .CSV can be text file, limitation won't exist in CSV file. Best regards, Kotrappa. From: Gary O'Neall [mailto:[email protected]] Sent: 02 February 2015 02:27 To: Kotrappa DeverShetty (WT01 - Manufacturing & Hi Tech) Cc: [email protected]; Ravishankar T.S (WT01 - Manufacturing & Hi Tech) Subject: RE: SPDX tools 1.2.9 - "Per File Info" sheet is kept blank when "TagToSpreadsheet" has been run Hi Kotrappa, It appears you have hit a limitation in Microsoft Excel. When I ran the utility against libXcursor, I got the following error message: Unexpected error translating the tag-value to spreadsheet: The maximum length of cell contents (text) is 32,767 characters This was due to the GPL 3 text being added as an extracted license. I do think there is a bug in the error message - it could be more descriptive. I added a bug report to address this: https://bugs.linuxfoundation.org/show_bug.cgi?id=1251 I'll take a look at possible solutions after I finish upgrading the tools to the new SPDX 2.0 spec. Let me know if that error message was not produced - it could indicate another bug. Gary From: [email protected] [mailto:[email protected]] Sent: Wednesday, January 28, 2015 5:29 AM To: [email protected] Cc: [email protected]; [email protected] Subject: SPDX tools 1.2.9 - "Per File Info" sheet is kept blank when "TagToSpreadsheet" has been run Hello Gary, For the attached .spdx files, the SPDX tools 1.2.9 which you shared in your last email does not work. "Per File Info" is kept blank when .spdx is converted to Spreadsheet. Please let us know if there is any discrepancy in input .spdx files. Thanks & Regards Kotrappa. The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com
_______________________________________________ Spdx-tech mailing list [email protected] https://lists.spdx.org/mailman/listinfo/spdx-tech
