Attachment's name list

General discussion on all other topics under the sun.

Moderator: Renato

Marco
New MMEX User
Posts: 8
Joined: Sun May 24, 2020 6:26 am
Are you a spam bot?: No

Attachment's name list

Post by Marco »

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
dbolton
Super MMEX User
Posts: 126
Joined: Fri Jan 03, 2020 3:24 pm
Are you a spam bot?: No
Contact:

Re: Attachment's name list

Post by dbolton »

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.
Marco
New MMEX User
Posts: 8
Joined: Sun May 24, 2020 6:26 am
Are you a spam bot?: No

Re: Attachment's name list

Post by Marco »

Yes, it pulls all past names.
But, is there a way to avoid it or clear this list?
Thanks
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Attachment's name list

Post by MartinArmstrong »

@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
Marco
New MMEX User
Posts: 8
Joined: Sun May 24, 2020 6:26 am
Are you a spam bot?: No

Re: Attachment's name list

Post by Marco »

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
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Attachment's name list

Post by Renato »

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".
Renato Forum Administrator
Marco
New MMEX User
Posts: 8
Joined: Sun May 24, 2020 6:26 am
Are you a spam bot?: No

Re: Attachment's name list

Post by Marco »

Sorry for the question Renato, but how can I manually manage the mmb database?
Thanks
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Attachment's name list

Post by Renato »

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.
Renato Forum Administrator
Marco
New MMEX User
Posts: 8
Joined: Sun May 24, 2020 6:26 am
Are you a spam bot?: No

Re: Attachment's name list

Post by Marco »

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.
:(
User avatar
Renato
MVP MMEX User
Posts: 655
Joined: Mon Apr 25, 2011 7:36 pm
Are you a spam bot?: No
Location: near Zurich

Re: Attachment's name list

Post by Renato »

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