Topic: Exporting issues - csv and internal database

Hello

I am running the 0.9-dev version on my arch based linux machine. I used flatpak to install.

The export to csv function does not have all elements in the csv document.

I also do not have the export internal database function available. I have sqlite installed.

Any advice will be appreciated



Below my setup for reference

QElectroTech V 0.90-DEV+855162bb0
Compilation : GCC 10.2.0
Built with Qt 5.15.3 - Date : Jan 15 2022 : 09:11:13
Run with Qt 5.15.3 using 4 thread(s)
CPU : model name : Intel(R) Core(TM) i5-2520M CPU @ 2.50GHz
RAM Total : 7828 MB
RAM Available : 4009 MB
GPU : Intel Corporation 2nd Generation Core Processor Family Integrated Graphics Controller (rev 09) NVIDIA Corporation GF119M [NVS 4200M] (rev a1)
GPU RAM : @ToDo
OS : linux - x86_64 - Version : KDE Flatpak runtime - Kernel : 5.16.10-arch1-1
*** Qt screens ***
( 1 : 1920 x 1080 )

  • scorpio810
  • scorpio810
  • QElectroTech Team Manager, Developer, Packager
  • Offline

Re: Exporting issues - csv and internal database

Hi,

humm ....  If I remember Sqlite3 code in sources to export QET project database to SQL was disabled on my packages : AppImage, Flatpak, and macOS.

sed -i 's/DEFINES += QET_EXPORT_PROJECT_DB/#DEFINES += QET_EXPORT_PROJECT_DB/' qelectrotech.pro

Because either it works badly, or very complicated to integrate sqlite3 dependency in macOS bundles ...

Maybe you could compile QET yourself or check Arch package?

"Le jour où tu découvres le Libre, tu sais que tu ne pourras jamais plus revenir en arrière..."
  • scorpio810
  • scorpio810
  • QElectroTech Team Manager, Developer, Packager
  • Offline

Re: Exporting issues - csv and internal database

I removed sed command line and send new Flapak build, please try it.

"Le jour où tu découvres le Libre, tu sais que tu ne pourras jamais plus revenir en arrière..."

Re: Exporting issues - csv and internal database

scorpio810 wrote:

I removed sed command line and send new Flapak build, please try it.

Hi Scorpio

I will try tonight.

I created a python script to generate a basic parts list in csv format.

  • scorpio810
  • scorpio810
  • QElectroTech Team Manager, Developer, Packager
  • Offline

Re: Exporting issues - csv and internal database

FYI, I also removed sed command line and send new AppImage build.

https://git.tuxfamily.org/qet/qet.git/c … 65320400a0

@Xenotek: I tried Flatpak and AppImage database export and export to csv function works now.

Icon: qelectrotech
Exec: qelectrotech %F 
Comment: Edit electrical diagrams.
Type: Application
Categories: Graphics;Qt;VectorGraphics;Science;Electricity;Engineering;
/home/laurent/qet_git/appdir/qelectrotech/usr/bin/qelectrotech used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libpcre2-16.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libavahi-common.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libicui18n.so.63 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libXi.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-glx.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libfam.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libgraphite2.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Xml.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libwebp.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libgssapi_krb5.so.2 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Gui.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libjbig.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libicudata.so.63 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-shape.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-xfixes.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5CoreAddons.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-util.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5X11Extras.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libbz2.so.1.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5Archive.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libmng.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libpng16.so.16 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-xinerama.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libzstd.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libhogweed.so.4 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-sync.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libXau.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libnettle.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5Codecs.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libGLX.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libcups.so.2 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Core.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5IconThemes.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libtasn1.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libIlmThread-2_2.so.23 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libkrb5support.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libdouble-conversion.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libgnutls.so.30 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5ConfigGui.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5ItemViews.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libmariadb.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libImath-2_2.so.23 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5ConfigCore.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5I18n.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Widgets.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-xkb.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5WidgetsAddons.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libk5crypto.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-render.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libffi.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libXdmcp.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libtiff.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libkrb5.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libicuuc.so.63 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-shm.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-keysyms.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libIex-2_2.so.23 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5GuiAddons.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxkbcommon.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libXrender.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/liblz4.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libX11-xcb.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-image.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5XcbQpa.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libjpeg.so.62 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libHalf.so.23 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5Auth.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libIlmImf-2_2.so.23 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5PrintSupport.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Network.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libsqlite3.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Svg.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libgmp.so.10 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libpcre.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libXext.so.6 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libgcrypt.so.20 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libsystemd.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libunistring.so.2 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-randr.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libbsd.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Concurrent.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-icccm.so.4 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libEGL.so.1 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libavahi-client.so.3 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libKF5ConfigWidgets.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxkbcommon-x11.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/liblcms2.so.2 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libGLdispatch.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5DBus.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libwebpdemux.so.2 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libidn2.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/liblzma.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libQt5Sql.so.5 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libxcb-render-util.so.0 used for determining architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libdbus-1.so.3 used for determining architecture x86_64
Using architecture x86_64
App name for filename: QElectroTech_0.9-DEV-r7545
/home/laurent/qet_git/appdir/qelectrotech should be packaged as QElectroTech_0.9-DEV-r7545-x86_64.AppImage
Generating squashfs...
Size of the embedded runtime: 157624 bytes
mksquashfs commandline: /tmp/.mount_linuxdV4Lch0/usr/bin/../lib/appimagekit/mksquashfs /home/laurent/qet_git/appdir/qelectrotech QElectroTech_0.9-DEV-r7545-x86_64.AppImage -offset 157624 -comp gzip -root-owned -noappend -mkfs-fixed-time 0 
Parallel mksquashfs: Using 24 processors
Creating 4.0 filesystem on QElectroTech_0.9-DEV-r7545-x86_64.AppImage, block size 131072.
[=========================================================================================================================================================================================================================================================-] 11091/11091 100%
 
Exportable Squashfs 4.0 filesystem, gzip compressed, data block size 131072
        compressed data, compressed metadata, compressed fragments, compressed xattrs
        duplicates are removed
Filesystem size 51976.09 Kbytes (50.76 Mbytes)
        24.44% of uncompressed filesystem size (212681.71 Kbytes)
Inode table size 104186 bytes (101.74 Kbytes)
        28.38% of uncompressed inode table size (367046 bytes)
Directory table size 109077 bytes (106.52 Kbytes)
        33.16% of uncompressed directory table size (328912 bytes)
Number of duplicate files found 209
Number of inodes 11316
Number of files 10091
Number of fragments 631
Number of symbolic links  1
Number of device nodes 0
Number of fifo nodes 0
Number of socket nodes 0
Number of directories 1224
Number of ids (unique uids + gids) 1
Number of uids 1
        root (0)
Number of gids 1
        root (0)
Embedding ELF...
Marking the AppImage as executable...
Embedding MD5 digest
Success
 
Please consider submitting your AppImage to AppImageHub, the crowd-sourced
central directory of available AppImages, by opening a pull request
at https://github.com/AppImage/appimage.github.io
+ rm qelectrotech/AppRun
+ sed -i 's/QElectroTech_0.9-DEV.*/QElectroTech_0.9-DEV-r7547/' qelectrotech/qelectrotech.desktop
+ cp AppRun qelectrotech/
+ rm QElectroTech_0.9-DEV-r7545-x86_64.AppImage
+ ARCH=x86_64
+ ./appimagetool-x86_64.AppImage qelectrotech
appimagetool, continuous build (commit 758f8e7), build 1771 built on 2018-07-10 10:44:25 UTC
/home/laurent/qet_git/appdir/qelectrotech/qelectrotech.desktop: warning: key "Keywords" in group "Desktop Entry" is a reserved key for KDE
Using architecture x86_64
/home/laurent/qet_git/appdir/qelectrotech should be packaged as QElectroTech_0.9-DEV-r7547-x86_64.AppImage
WARNING: AppStream upstream metadata is missing, please consider creating it
         in usr/share/metainfo/qelectrotech.appdata.xml
         Please see https://www.freedesktop.org/software/appstream/docs/chap-Quickstart.html#sect-Quickstart-DesktopApps
         for more information or use the generator at http://output.jsbin.com/qoqukof.
Generating squashfs...
Parallel mksquashfs: Using 24 processors
Creating 4.0 filesystem on QElectroTech_0.9-DEV-r7547-x86_64.AppImage, block size 131072.
[=========================================================================================================================================================================================================================================================-] 11092/11092 100%
 
Exportable Squashfs 4.0 filesystem, gzip compressed, data block size 131072
        compressed data, compressed metadata, compressed fragments, compressed xattrs
        duplicates are removed
Filesystem size 51976.37 Kbytes (50.76 Mbytes)
        24.44% of uncompressed filesystem size (212681.87 Kbytes)
Inode table size 104211 bytes (101.77 Kbytes)
        28.39% of uncompressed inode table size (367034 bytes)
Directory table size 109191 bytes (106.63 Kbytes)
        33.20% of uncompressed directory table size (328900 bytes)
Number of duplicate files found 209
Number of inodes 11316
Number of files 10092
Number of fragments 631
Number of symbolic links  0
Number of device nodes 0
Number of fifo nodes 0
Number of socket nodes 0
Number of directories 1224
Number of ids (unique uids + gids) 1
Number of uids 1
        root (0)
Number of gids 1
        root (0)
Embedding ELF...
Marking the AppImage as executable...
Embedding MD5 digest
Success
 
Please consider submitting your AppImage to AppImageHub, the crowd-sourced
central directory of available AppImages, by opening a pull request
at https://github.com/AppImage/appimage.github.io
+ chmod -x QElectroTech_0.9-DEV-r7547-x86_64.AppImage

/home/laurent/qet_git/appdir/qelectrotech/usr/lib/libsqlite3.so.0 used for determining architecture x86_64

"Le jour où tu découvres le Libre, tu sais que tu ne pourras jamais plus revenir en arrière..."