giowck / symphytum Goto Github PK

The CSV Import and Export doesn't allow fields with quotation marks.

e.g.
"john";"doe"

It would be nice to have this. And it would be much nicer if the character " could be userdefined. Sometimes e.g. | is needed.

Probably, the easiest way to support mega.nz is through the MEGAcmd command line application, which could be shipped just like the python dropbox cli by implementing an appropriate sync driver.

Selecting an image from the field image type widget I can only see .jpg, .png, ... files but not .JPG, .PNG

Tested on linux

Background info:

Hello,

We are reaching out to you because we have discovered an issue with the Dropbox API v2 Python SDK that your app is currently using. Although the issue does not break any existing behavior, it limits our ability to make non-breaking changes to our API endpoints going forward.

For that reason, we ask that you update your app to the latest version of the SDK within the next two months. This bug was fixed specifically in v8.0.0.

If you do not update SDK versions within the next two months, return types from some endpoints may fail to deserialize correctly, raising a runtime exception.

We apologize for the inconvenience.

Please reach out to us if you have any questions or concerns.

Sincerely,
The Dropbox API Team

I'm experimenting with cloud sync but I want to back everything up first.

There's a regression where if all collections are deleted there's still data shown in form and table view.
Also creating a new collection is not possible, the old state is still shown.

Is there anyway that this program can sync with another cloud service besides Dropbox? I'm wanting to sync with Nextcloud in particular. Thanks.

Using Version 2.1 Build 6.

The "Format:" field in the the Export-dialog says: Comma-separated values (CSV)
This is not full correct. Symphytum offers semicolon separated values, too.
I would suggest to correct that to just CSV.

Add language selection to the settings dialog.
Update code and doc.

Unable to change field type from text to link, etc.

The TS file has been created and is ready for translation into italian with the use of Qt4Linguist.

Thinking about implementing an option in settings dialog to specify a custom path for the database location. This is useful for different use cases, especially when using a not supported sync service where pointing the location to the sync folder allows syncing, of course without in app conflict handling.

The number field type doesn't accept inputs with decimal places after the separator (for example 5.5 or 5,5 for localisations using comma as separator).

I am trying to compile lists of airplane models, manufacturers, vendors, and prices. Since one manufacturer makes multiple models, my usecase -- and surely: many other usecases -- require some way to represent and query relational data.

Printing is not possible on windows 7. When clicking on print button nothing happens.
But it works on a windows 10 machine with Qt SDK installed.

Maybe some .dll file is missing.

Dropbox v1 SDK is being deprecated and disable on June 30 2017.

Migrate to Dropbox v2 Python SDK, probably requires rewriting of the dropbox sync driver since all API calls changed in structure.

When searching it would be a good feature to see the matches in a text field highlighted somehow.

Other distros or unsupported ones (like the ubuntu 16.04 LTS one) could be able to run Symphytum with newer Qt versions, if bundled.

When trying to restore an existing backup Symphytum fails to delete the 3 sample images for some strange reason.

Workaround:
open cmd.exe
type: explorer %APPDATA%
hit enter
then go a directory back (up), and step into the Local directory
here inside the Symphytum folder, delete the files folder manually
then try again

It would be lovely to be able to use 32bit Symphytum in Yakkety Yak.

It would be wonderful to be able to duplicate an existing collection, with or without its records, or to be able to save an existing collection as a template for use in other collections.

The table view is incorrectly displaying the 'progress bar' results. It is displaying the 'step' value with a percent sign instead of the corresponding percentage.

As an example, if you had an item with 5 steps in the progress and you were at the first step it would correctly show 20% in the form view however in the table view it would show 1%.

If I could only code to fix this sort of thing.... :-)

It would be brilliant if one was able to put collections into "meta-collections". Essentially just headers in the left side nav bars which could be expanded and collapsed containing one or more collections.

Hi, I would like to help the project translating the software into Portuguese and Spanish.

ver 2.2 does not open in Mint 18.2 after installation, when reverting to 2.1 it works. Any suggestions?

First let me congratulate you on a job well done. I was surprised that there was no user manual...and did not need one. Pretty much everything does what I expected it to do.
My situation is that I have a large quantity of books on computers, forensics and other technical subjects. I have them in CSV format so importing them into Symphytum is not issue. However, I lend out books on occasion. I have included fields for the person I lent a book to, the date and the expected return date (a reminder). However, it would be very useful if I could have a second form that just showed the title, the recipient, the lent date and the expected return date. I have not found any way to do that.

If there is a way to create more than one form, please enlighten me - if not, please consider implementing it.

Thank you, Liu Si Guang

The app freezes completely when this action is clicked but only if cloud sync is active.
Looks like the app is trying to delete files from the cloud and failing in a loop.

Deleting an entry of combo box list works only when editing an existing field.
When clicking on remove button during a new combo box creation or duplication, nothing happens.

When I get to sync to Dropbox for the first time I have this error after I enter the API authorization keys:

Error:'ascii' codec can't encode character u'\xe9'
in position 15: ordinal not in range(128)
Please try again.

On start-up the "check update" functionality fails.
Needs investigation, probably something resulting from migration of Qt4 to Qt5.

How do I increase font size or change font?

Similar to the URL field type, having a field type of email would be great. In the form view there could be an icon which would function like a 'mailto' link.

That's a huge issue.

I've got a bunch of questions and suggestions. What do I do with them?

OS X 10.6 has python version 2.6 but the shipped .pyc files have been generated using python 2.7. Solution is to ship .py files.

URLs should be clickable. This could be realized, e.g., using a new field type "URL".

Things to do:

• Check DefinitionHolder, remove unused definitions and update the rest
• Update deployment doc

Maybe the SQL escaping causes this.
Interestingly, it would require investigating other states like field name and other field types in case the user inputs SQL escaped characters...

Reproduce:
Create a combo box field, add some values containing quotation marks like: "8x
Duplicate that field.
New Field has an empty list as combo box values.

The current installer requires admin privileges, which regular user often doesn't have in enterprise/organizational environment. Would it be possible to generate a non-installer-based build/distribution on Windows? I.e. a installerless zip or similar.

Ability to add non-data field elements to forms to allow users to make forms easier to add and review data.

The prioritized list would be:

• plain text
• inserting a horizontal line
• predefined style elements (like 'section header')
• expandable/collapsible sections

Being able to add a URL would open up tons of applications for this great product.

• when the item is saved on the form view you could have an icon next to the field so the user could launch the link.

With the migration to the Dropbox API v2 the old access token (Dropbox v1 API) is recognized as invalid and an error is shown "Internal Server Error".

As a workaround it is necessary to disable the cloud sync from the settings (Menu->Tools->Settings->Cloud Sync-> change status to "disabled"). Then restart symphytum and start the sync process over again. It is advised to do a backup (Menu->Backup) before trying this.

With snaps probably becoming the future packaging format for Linux, it makes sense to provide a snap package for Symphytum. Since Ubuntu integrated the snap store into the software center, and other distros are following, it would allow for Symphytum to expand its user base and discoverability.

https://docs.snapcraft.io/

Scrolling in table view mode is really choppy and slow in presence of image fields (columns).
Especially when the image files are big and there are more than one image columns.

Implementing caching of images in memory works and the result is a smooth scrolling experience.
I tested this by using QPixmapCache with a larger database with 2 image columns.
The big disadvantage is that this increases memory usage dramatically: symphytum uses around 30-50 MiB now, with this patch it uses at least 900 MiB to 1.3 GiB memory (only if needed).

On modern computers with large amounts of RAM this is not a problem, but many still use notebooks with 2GiB RAM.

I think, it would be possible to check RAM availability and enable this optimization only on high end (RAM at least 4 GiB) machines. And of course, providing an option in the setting to disable this.

EDIT: it makes sense to clear the cache before printing as printing requires all free resources in case the database file is really big...

EDIT2: Qt5 doesn't offer a way to check for system RAM, so either a new utility needs to beimplemented for each platform or the default state for this should be disabled and an option provided in the settings to enable it.

While in table view, in read only mod (cloud sync), data cannot be changed, in formview it is allowed on specific field types like combo, image, files and others.

It should also block changes to the layout.
Maybe a new setReadOnly function for FormView is required...

EDIT: further inspection shows that also in table view there are some fields like image and others that still allow editing...

Errors:

qt.network.ssl: QSslSocket: cannot resolve CRYPTO_num_locks
qt.network.ssl: QSslSocket: cannot resolve CRYPTO_set_id_callback
qt.network.ssl: QSslSocket: cannot resolve CRYPTO_set_locking_callback
qt.network.ssl: QSslSocket: cannot resolve ERR_free_strings
qt.network.ssl: QSslSocket: cannot resolve EVP_CIPHER_CTX_cleanup
qt.network.ssl: QSslSocket: cannot resolve EVP_CIPHER_CTX_init
qt.network.ssl: QSslSocket: cannot resolve sk_new_null
qt.network.ssl: QSslSocket: cannot resolve sk_push
qt.network.ssl: QSslSocket: cannot resolve sk_free
qt.network.ssl: QSslSocket: cannot resolve sk_num
qt.network.ssl: QSslSocket: cannot resolve sk_pop_free
qt.network.ssl: QSslSocket: cannot resolve sk_value
qt.network.ssl: QSslSocket: cannot resolve SSL_library_init
qt.network.ssl: QSslSocket: cannot resolve SSL_load_error_strings
qt.network.ssl: QSslSocket: cannot resolve SSL_get_ex_new_index
qt.network.ssl: QSslSocket: cannot resolve SSLv2_client_method
qt.network.ssl: QSslSocket: cannot resolve SSLv3_client_method
qt.network.ssl: QSslSocket: cannot resolve SSLv23_client_method
qt.network.ssl: QSslSocket: cannot resolve SSLv2_server_method
qt.network.ssl: QSslSocket: cannot resolve SSLv3_server_method
qt.network.ssl: QSslSocket: cannot resolve SSLv23_server_method
qt.network.ssl: QSslSocket: cannot resolve X509_STORE_CTX_get_chain
qt.network.ssl: QSslSocket: cannot resolve OPENSSL_add_all_algorithms_noconf
qt.network.ssl: QSslSocket: cannot resolve OPENSSL_add_all_algorithms_conf
qt.network.ssl: QSslSocket: cannot resolve SSLeay
qt.network.ssl: QSslSocket: cannot resolve SSLeay_version
qt.network.ssl: Incompatible version of OpenSSL
qt.network.ssl: QSslSocket: cannot call unresolved function SSLv23_client_method
qt.network.ssl: QSslSocket: cannot call unresolved function SSL_library_init
We got a connection error when networkLayerState is Unknown

Seems to be a known issue caused by Qt's SDK linking to a specific SSL lib as discussed here:
subsurface/subsurface#779

Solution or better workaround is meanwhile to patch the binary

Hello,
I'm currently using the 1.1 version downloaded from Giowysis, should I download the updated version ?
Will all my existing data automatically be saved in the new version ?

Add code and instruction for future translation work.

As in the screenshot below, there's issues running Symphytum on Linux using a HiDPI display at 2x scaling. Among them:

• Field elements do not respect scale; text contained within does.
• Sidebar text does not respect scale.
• Columns in the form view do not respect scale.

System is Ubuntu 15.04 with the display scale set to 2.0 to accommodate the HiDPI (13-inch 3200 x 1800px) display.

The TS file has been created and is ready for translation into german with the use of Qt4Linguist.