View ProjeQtOr On SourceForge.net
ProjeQtOr - Project Management Tool
Support us on Capterra
OIN - Open Invention Network
ProjeQtOr free project management software - Requirements import from excel with images - ProjeQtOr
 
 

Requirements import from excel with images

More
05 May 2022 16:56 - 06 May 2022 11:24 #1 by LaurentC
Usually requirements are given by customers in excel or reqif format.Reqif (*.reqifz files) can be converted (with all cell images) to excel by the excellent pyreqif-0.7.zip library (for python language).Therefore, the question is: how to import a large excel file with a large number of images encapsulated in cells and potentially several images per cell ?Unfortunately Projeqtor does not import images from excel.In case of a small number of images, it can be done manualy. In case of hundreds of images ensapsulated in thousands of lines, it becomes tricky....The attached file is a answer to that concern.It's written in python 3. So you need python 3.x to execute it or convert it to an exe file (the produced exe file is to big to be uploaded to this forum). Also, you need a direct access to the server file system (could be obsolete in the future, for further development).Just fill in the config.ini and execute the script in a command window or in a python environnement like pyscripter or pycharm.Tested on large XLSX files with dozens of images.Could be translated in php. For further study.Feedback is welcomed in case anybody may use it.
Attachments:
Last edit: 06 May 2022 11:24 by LaurentC. Reason: Attachment version updated

Please Log in or Create an account to join the conversation.

More
06 May 2022 11:18 #2 by babynus
Thanks for your contribution.
If you agree, we'll share it on the download page.

We won't include it in Community version as we want to include only full PHP features.

Babynus
Administrator of ProjeQtOr web site

Please Log in or Create an account to join the conversation.

More
06 May 2022 11:31 #3 by LaurentC
Hello,
Yes, you can share the source file (*.py) and the windows exe file
I've the compiled exe file here:
drive.google.com/file/d/1vQlPrd-aF2Z2s3V...Y-p/view?usp=sharing

Feel free to download it.
 
The following user(s) said Thank You: babynus

Please Log in or Create an account to join the conversation.

Moderators: babynusprotion
Time to create page: 0.039 seconds

Cookies settings

×

Functional Cookies

Ce site utilise des cookies pour assurer son bon fonctionnement et ne peuvent pas être désactivés de nos systèmes. Nous ne les utilisons pas à des fins publicitaires. Si ces cookies sont bloqués, certaines parties du site ne pourront pas fonctionner.

Session

Please login to see yours activities!

Other cookies

Ce site web utilise un certain nombre de cookies pour gérer, par exemple, les sessions utilisateurs.