1. Ben Antwi
  2. Valentina Reports ADK
  3. Вторник, Апрель 12 2022, 04:18 PM
  4.  Подписаться через 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
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@Sergey Pashkov Please I have started a new discussion with the below url, Thanks in advance.
Ссылки
  1. https://valentina-db.com/en/discussion-forums/9292-how-to-display-an-image-from-database-for-valentina-report
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@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.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Вложения
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@Sergey Pashkov please find the attached link to the log file from Process Monitor
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
Sorry for the late reply below is the new link to the log event
https://www.dropbox.com/s/pxjxdnm7yya70tv/Logfile.zip?dl=0
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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)
Ссылки
  1. https://www.dropbox.com/s/1bk736rluz18u83/pycharm_procmon.mov?dl=0
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@Sergey Pashkov I have attached the link for the captured process
https://www.dropbox.com/s/jm6tgao2v9fuzu7/Logfile.zip?dl=0
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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?
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
Please after the compression of the captured system logs, the file size was 119MB
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
Looks like it is from Process Explorer.
Please use Process Monitor, it writes a log (attached screenshot)
Вложения
Ссылки
  1. https://download.sysinternals.com/files/ProcessMonitor.zip
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
Please check the attached file whether I did the right thing.
Вложения
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Ссылки
  1. https://download.sysinternals.com/files/ProcessMonitor.zip
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
Yes please the error is with Pycharm
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
So the error is with PyCharm?
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@Sergey Pashkov I would really appreciate it if you could make the detailed instructions available. Thank you in advance.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Ссылки
  1. https://learn.microsoft.com/en-us/sysinternals/downloads/process-explorer
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
@Sergey Pashkov Please I'm still experiencing import Error.
Комментарий
There are no comments made yet.
Sergey Pashkov Ответ принят
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.
Ссылки
  1. http://valentina-db.com/docs/dokuwiki/v12/doku.php?id=valentina:products:vstudio:help:report_editor:controls:picture
Комментарий
There are no comments made yet.
Ben Antwi Ответ принят
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.
Комментарий
There are no comments made yet.
  • Страница :
  • 1
  • 2
  • 3
  • 4
  • 5


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

Categories

Announcements & News
  1. 0 subcategories
Valentina Studio
  1. 2 subcategories
Valentina Server
  1. 4 subcategories
Valentina Database ADK
  1. 0 subcategories
Valentina Reports ADK
  1. 0 subcategories
Other Discussions
  1. 2 subcategories
BETA Testing
  1. 0 subcategories
Education & Research
  1. 0 subcategories