M
M
marrs2016-04-17 02:18:32
Data transfer
marrs, 2016-04-17 02:18:32

Flexible tool to import xml, xlsx to mysql?

Hello!
Task:
There is a database in mysql, which needs to import the nomenclature, the problem is that for this you need to import a lot of prices - some in xml, some in xlsx.
That is, I need a flexible tool where I can: 1 - Set the matching fields of a table cell in mysql
and a price node
2 - Save the settings for this price list and then update from this price list automatically
there is an unlimited number of price lists and everywhere the structure and order of nodes is different (there is no single format for price lists).
It seems that this is what you need, but I haven’t tried it, if anyone has tried it, I also ask for feedback -
https://www.devart.com/en/dbforge/mysql/studio/

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question