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.
Import CSV having splitted categories
Moderator: Renato
-
- New User
- Posts: 2
- Joined: Wed Apr 19, 2023 4:30 am
- Are you a spam bot?: No
-
- MVP User
- Posts: 300
- Joined: Tue Mar 02, 2021 10:24 am
- Are you a spam bot?: No
Re: Import CSV having splitted categories
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?
-
- New User
- Posts: 2
- Joined: Wed Apr 19, 2023 4:30 am
- Are you a spam bot?: No
Re: Import CSV having splitted categories
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.
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.