Import CSV having splitted categories

General discussion on all other topics under the sun.

Moderator: Renato

Post Reply
kovacs80bela
New MMEX User
Posts: 2
Joined: Wed Apr 19, 2023 4:30 am
Are you a spam bot?: No

Import CSV having splitted categories

Post by kovacs80bela »

I'd like to import data from csv file. Each item has multiple categories so the deposit is splitted. How can I import this kind of data?

If I export this kind of data from mmex to CSV I get one row for each category, like:
ID;category;deposit
13;70;1000
13;82;3000

If I import it back to a new db, that will be two separate line in the database.

Thanks.
MartinArmstrong
MVP MMEX User
Posts: 300
Joined: Tue Mar 02, 2021 10:24 am
Are you a spam bot?: No

Re: Import CSV having splitted categories

Post by MartinArmstrong »

I'd like to import data from csv file. Each item has multiple categories so the deposit is splitted.

Where is your CSV file that you wish to import coming from?

a) Are you generating it yourself?

b) Is it downloaded from a bank?

c) Is it from a previous export from MMEX?

If c), then could you say what you are trying to achieve by exporting and re-importing please?
kovacs80bela
New MMEX User
Posts: 2
Joined: Wed Apr 19, 2023 4:30 am
Are you a spam bot?: No

Re: Import CSV having splitted categories

Post by kovacs80bela »

The CSV I try to use is generated by myself. So it's a)

Exporting and re-importing was only for testing reasons. I was hoping, that the exported csv will guide me how to create one which can be imported.
Post Reply