MMEX Discussion Forum

Hi, when I add a new attachment, now MMEX asks me its name.
I can choose from a list (old operations), but this list is too long...
How can I clean it?
Thank you

If I remember right it pulls all past names, so standizing past attachment names shortens the list. I use "receipt" and "invoice" as my file labels because I also like that list to be short. For multipage receipts, I label "receipt p1", "receipt p2", etc.

Yes, it pulls all past names.
But, is there a way to avoid it or clear this list?
Thanks

@Marco
I do not (yet) understand why you need to clear the list.

It would be very helpful in thinking about the user interface for attachments if your could explain:
- How you use attachments
- How your files are named
- How you 'name' them in the 'Description' field (which I think is what you are asking about in this thread)
- How you would like to use the dropdown Description list to help you
- Why you want the list to be cleared (or reduced)

Understanding what you are trying to achieve will help enhance MMEX in the future.

Thanks

Hi Martin,
I have probably misused this field in the past, so now, in the history I have a lot of different names (invoice xxx, invoice yyy, receipt zzz, etc.).
Now I would like to clean up this situation and restart with a more correct logic (invoice, receipt, etc.).
Of course I cannot modify all the previous movements.
I hope I have clarified my "problems".
Thank you

From my point of view, in the database (.mmb), in the table ATTACHMENT_V1, you could replace the values stored so far, for example, by "Misc".

Sorry for the question Renato, but how can I manually manage the mmb database?
Thanks

I would first create a backup copy of the xxxx.mmb database file.

Download and install the program https://sqlitebrowser.org/.

Open the xxxx.mmb database in sqlitebrowser.
Select Execute SQL
Enter UPDATE ATTACHMENT_V1 SET DESCRIPTION = "Misc"
and execute this command.
Under Browse Data select the ATTACHMENT_V1 table and check the changes.
save the modified database.

Alternative: send the xxxx.mmb database as .zip to the address mmex-reg@bluewin.ch and I will send back the corrected version.
Of course I guarantee discretion.

Thank you Renato.
I tried to do this, but I use an encypted database (.emb).
I tried to use SQLCipher but unfortunalety I can't open the database.
Of course I know the password, but it's not enough...
I should know some other encryption parameters I don't know (page size, KDF iterations, HMAC algoritm, KDF algorithm, Plaintext header size).
Default values don't works.

I would decrypt the database first
See: viewtopic.php?p=22517&hilit=convert#p22517

It works perfetcly, Renato.
Thanks a lot

Thanks for the feedback