Import from csv

[Chukapi]

Hi,

I just try MMEX and i like the software.
I need some hand to help me import all my previous data I stored in an excel file.

In my Excel file i have those information in this specific order :

- A code : can be something like PARK or MIAM or AUTRE.
- A Code Bank : On which account was the payment
- Debit
- Credit
- Balance (if i have 100 in credit it will show 100, if i have 100 in debit it will show -100)
- Information about the code
- Information about the bank
- Month : 1,2,3,4,5... on which month
- Date of the payment
- Date of bank reconciliation
- Some personnal information about the
- C, E. C mean the reconciliation has been made, E mean i paid someone but it still not been reconciliate yet.


If someone can help to understand the export/import function it will be great !

Thanks for your help!

[alfred07380]

Hi,

Did you see these help ?
- https://moneymanagerex.org/docs/features/importexport/
- https://moneymanagerex.org/moneymanager ... #section13

[Chukapi]

Is there a way to export or import categories ? I create a bunch and i will need them to match them with my old code.

[alfred07380]

From the software, it seems not. At least not directly. You'd have to go through a csv export of transactions, then work on this csv file.
Alternatively, you can inject an sql query directly into the database.
The table is called category_v1.
Maybe someone has another method.

[Chukapi]

I could extract it with sql

Code: Select all

SELECT * 
FROM CATEGORY_V1 
ORDER  BY CATEGNAME

[nstein]

The documentation is abysmal, but the CSV import functionality itself is fairly straightforward. You open the CSV import dialog (right click on an account and select "Import from > CSV Files...", select your file using "Browse" button, select the columns in the order you need from the left box to the right via the "Add/Remove" buttons (use the preview at the bottom to see how your data matches up), then click import. Make sure to adjust things like Date setting and delimiter to actually match the file you are importing.

Given your list of columns in your Excel, most of these columns would either be set to "Don't Care" (if you don't actually need the information in MMEX), or "Notes" to concatenate the information into the Notes column. For example, you would map "Bank" to the "Account" column, but the "Information about the bank" would either be dropped (Don't Care) or be added to Notes. If you really want to store everything separately you would have to create custom fields to hold the extra information.

If you are concerned about creating categories for the import, you don't need to. MMEX will auto-create any missing categories during import.
If you really just want to load the categories, you could utilize the auto-creation to do it. Just create a dummy file with the minimum fields (Date, Amount, and Category), just defaulting Date to a single date and amount to 0 and import it to create them. You can even auto-create a hierarchy this way if you nest your categories with the ":" character, e.g. importing a category like

Code: Select all

Paycheck:Taxes:Federal

would create a 3-level category hierarchy

Code: Select all

Paycheck
  - Taxes
    - Federal

[Chukapi]

Thanks for this reply ! I will try this !