Toggle Submenu
  1. Forums
  2. Recent
  3. カテゴリ
  4. タグ
  5. ユーザ
返信を追加 返信を表示 (91)

解決済み Generating dynamic python report using valentina Pro 12

  1. Ben Antwi
    Ben Antwi
  2. Valentina Reports ADK
  3. 火, 4月 12 2022, 04:18 PM
  4.  メールで購読
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
  1. Valentina Report ADK
  2. DB_SQLITE
  3. Python
  4. ADK_VPYTHON
コメント
There are no comments made yet.
返信 (91)
Ben Antwi
Ben Antwi 承諾済みの回答
I want to run the sql query example below to enable the user to type in any item_ID the user want , so that sql statement will return the exact record of the item_Id typed by the user. 



SELECT item_Id, FROM items WHERE item_Id=? ''',([Search_Id])

コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Hello Ben,

I've added valentina38.pyd.zip for Python 3.8, please download, uncompress, rename it as valentina.pyd and copy it to
C:\Users\RAZOR64\Documents\Paradigma Software\VPython_x64_12

msvcp140_codecvt_ids.dll should already be in C:\Program Files\Paradigma Software\vcomponents_win_vc

Will it work at this point?
In my test, the interpreter installed by PyCharm still is not working, however separate interpreter worked fine.

I've copied the contents of vcomponents_win_vc folder to VPython_x64_12 and Valentina works with a built-in interpreter.
So it turns out an extension wasn't able to find its dependencies however the Path variable is set correctly.
参照
  1. https://www.dropbox.com/s/z9h3216lr0vyraa/valentina38.pyd.zip?dl=0
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Yes I want to deploy to a user's windows PC.Please If you say "it is necessary to use valentina.pyd linked to the correct version of Python interpreter" you mean the python 3.7 and 3.8.10 interpreter right?
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
So you need to deploy an app to the user’s Windows PC?
valentina.pyd can be located in the same folder with Python script.
And the contents of vcomponents_win_vc can be copied to the same folder with valentina.pyd, that should be enough.
And again, it is necessary to use valentina.pyd linked to the correct version of Python interpreter. Unfortunately we can’t have a universal module for all interpreters on Windows.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Is the path correct?
On the screenshot, I can see C:/User/RAZOR64.
Usually, it is C:/Users

Hi Sergey,
You right it should be C:/Users/RAZOR64. It works now with Jupyter notebook. Please to get this report working with my .exe file which location and which files will I need because the user computer does not have Valentina Studio installed on it.Please what is the way forward?Thank you.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Is the path correct?
On the screenshot, I can see C:/User/RAZOR64.
Usually, it is C:/Users
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
I have tried what you instructed me to do but I get same error message which is very strange,
I tried running in jupyter notebook and I get this error in the image below.
Hi Sergey
Please what could be the cause of this error because I have the project file.vsp in my working directory and the runtime error says the .vsp project file does not exist.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Looks like they run the Python interpreter differently, so Jupyter Notebook can load the module.
So now VPython_x64_12 looks pretty much the same as in my screenshot, except for valentinaXX.pyd for different versions, right?
Yes you are right
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Looks like they run the Python interpreter differently, so Jupyter Notebook can load the module.
So now VPython_x64_12 looks pretty much the same as in my screenshot, except for valentinaXX.pyd for different versions, right?
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
I have tried what you instructed me to do but I get same error message which is very strange,
I tried running in jupyter notebook and I get this error in the image below.
添付ファイル
Screenshot (25).png Screenshot (25).png
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Hi Ben,

At first please try to copy the contents of vcomponents_win_vc folder to VPython_x64_12 and try to run.

What I got is on the right panel of the screenshot.

Also, I've just manually installed Python 3.8.10, it works, too (link attached)
添付ファイル
Screenshot 2022-09-12 at 13.37.33.png Screenshot 2022-09-12 at 13.37.33.png
参照
  1. https://www.python.org/ftp/python/3.8.10/python-3.8.10-amd64.exe
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
I tried running the code using pycharm with python interpreter 3.8 and I'm still getting same error message.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Hi Sergey
I have downloaded the valentina38.pyd.zip and uncompress, rename it as valentina.pyd and copied it to
C:\Users\RAZOR64\Documents\Paradigma Software\VPython_x64_12 as instructed.
Please which separate interpreter did you use for your successful testing? because you said pycharm interpreter is not working.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Yes, now you have modules for 3.7 and 3.8 (not necessarily 3.8.10, any 3.8.x).
But it is easy to create modules for 3.9 and 3.10 using the Python utility machomachomangler (it is available in pip).
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
A dropbox link points to an archive with a runtime library.

valentina.pyd is linked to 3.7 now.
But as you're using 3.8 we need to adjust valentina.pyd to change reference to 3.7.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Hi Sergey
Please which attached archive are you talking about? For the interpreter I'm using python 3.8
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Please download and uncompress the attached archive to C:\Program Files\Paradigma Software\vcomponents_win_vc

Also, the Valentina extension is linked to Python 3.7, so it is necessary to use this interpreter. Can you check what is used in PyCharm?
添付ファイル
Screenshot 2022-09-10 at 07.36.40.png Screenshot 2022-09-10 at 07.36.40.png
参照
  1. https://www.dropbox.com/s/sa1snw77asunkx2/msvcp140_codecvt_ids.dll.zip?dl=0
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Ok thanks, I will be standing by for a stable version then.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Sergey Pashkov
Sergey Pashkov 承諾済みの回答
Windows 10. But we can't be sure it will work after the downgrade. There are too many factors, I'll know more in a couple of hours.
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
Ben Antwi
Ben Antwi 承諾済みの回答
Please which windows version did you use for the successful testing so that I can downgrade to that version for the mean time?
コメント
There are no comments made yet.
  1. 一ヶ月以上前
  2. Valentina Reports ADK
  3. この返信へのパーマリンク
  • ページ :
  • 1
  • 2
  • 3
  • 4
  • 5


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