1. Ben Antwi
  2. Valentina Reports ADK
  3. Tuesday, April 12 2022, 04:18 PM
  4.  Subscribe via email
Valentina is a great reporting tool but I'm still finding it difficult to search a record from sqlite database with python. Please I need help
Comment
There are no comments made yet.
Ben Antwi Accepted Answer
@Sergey Pashkov Please I have started a new discussion with the below url, Thanks in advance.
References
  1. https://valentina-db.com/en/discussion-forums/9292-how-to-display-an-image-from-database-for-valentina-report
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 1
Sergey Pashkov Accepted Answer
Maybe it is better to create a new discussion for it.
Please add details on how it is stored - as a BLOB or as a path or filename.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 2
Ben Antwi Accepted Answer
@Sergey Pashkov Thanks a lot the error message is no more showing. Now the only thing is the image to come from the image field from database. I need assistance on how to do that.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 3
Sergey Pashkov Accepted Answer
Thank you, so now it is clear that python is looking for VComponents DLLs in the wrong places:

  • EC-PROJECT folder
  • Python38 folder
  • System32 folder


And not in:
C:\Program Files\Paradigma Software\vcomponents_win_vc

Please check that this path is in the system variable Path.

So the project should work if you copy the contents of vcomponents_win_vc to EC-PROJECT.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 4
Ben Antwi Accepted Answer
@Sergey Pashkov please find the attached link to the log file from Process Monitor
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 5
Ben Antwi Accepted Answer
Sorry for the late reply below is the new link to the log event
https://www.dropbox.com/s/pxjxdnm7yya70tv/Logfile.zip?dl=0
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 6
Sergey Pashkov Accepted Answer
Thank you, unfortunately, the log file doesn't contain any python.exe entry which happens when you run the project.
I've attached a link to a short video on how to capture a log, at the end it shows how to apply a filter (that's not necessary, just to check if python.exe is there)
References
  1. https://www.dropbox.com/s/1bk736rluz18u83/pycharm_procmon.mov?dl=0
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 7
Ben Antwi Accepted Answer
@Sergey Pashkov I have attached the link for the captured process
https://www.dropbox.com/s/jm6tgao2v9fuzu7/Logfile.zip?dl=0
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 8
Sergey Pashkov Accepted Answer
Yes, that's a lot for attachment.
Could you please upload it to some cloud storage, e.g. Dropbox or Google Drive, and share a link?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 9
Ben Antwi Accepted Answer
Please after the compression of the captured system logs, the file size was 119MB
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 10
Sergey Pashkov Accepted Answer
Looks like it is from Process Explorer.
Please use Process Monitor, it writes a log (attached screenshot)
Attachments (1)
References
  1. https://download.sysinternals.com/files/ProcessMonitor.zip
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 11
Ben Antwi Accepted Answer
Please check the attached file whether I did the right thing.
Attachments (1)
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 12
Sergey Pashkov Accepted Answer
Process Monitor better fits the needs (it's from a Microsoft representative, too)

1. So download and uncompress it (the URL is at the bottom).
2. Run PyCharm and open the project
3. Run procmon.exe - no need to apply any filters - click OK in the dialogue if asked

Now it should register all events on the PC (new events are constantly added)

4. Run a project in PyCharm.
5. Once an import error is recorded switch to procmon.exe and click the Capture button (which has a magnification lens) to stop the recording.
6. Save the recording to a file (File->Save...), use all default settings, compress if it is too big and attach it here.
References
  1. https://download.sysinternals.com/files/ProcessMonitor.zip
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 13
Ben Antwi Accepted Answer
Yes please the error is with Pycharm
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 14
Sergey Pashkov Accepted Answer
So the error is with PyCharm?
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 15
Ben Antwi Accepted Answer
@Sergey Pashkov I would really appreciate it if you could make the detailed instructions available. Thank you in advance.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 16
Sergey Pashkov Accepted Answer
This error is only in PyCharm and with Jupyter Notebook it works, right?

There is a tool to debug such problems - Process Explorer.
I'll add detailed instructions if you wish.
References
  1. https://learn.microsoft.com/en-us/sysinternals/downloads/process-explorer
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 17
Ben Antwi Accepted Answer
@Sergey Pashkov Please I'm still experiencing import Error.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 18
Sergey Pashkov Accepted Answer
A Picture control dialog has URL from field option where you can select a field containing a path to the picture.
So you can add something like CONCAT( "C:/Users/.../img/", fileName ) AS path to your query and select path in the dialog.
References
  1. http://valentina-db.com/docs/dokuwiki/v12/doku.php?id=valentina:products:vstudio:help:report_editor:controls:picture
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 19
Ben Antwi Accepted Answer
After adding my datasource in Valentina Studio Pro, all fields are showing except the image field. All images are stored in a "img/" folder in working directory and the image name is stored in database as text so when I insert the image field I see only the image name stored in the database not the image itself.Please I need assistance.
Comment
There are no comments made yet.
  1. more than a month ago
  2. Valentina Reports ADK
  3. # 20


There are no replies made for this post yet.
However, you are not allowed to reply to this post.