rhaamo / StockazIO

Components/hardware management webapp for DIYers.
https://demo.stockazio.squeaky.tech/public/parts
GNU Affero General Public License v3.0
18 stars 1 forks source link

Feature request: Import from Part-DB or Part-DB-symfony? #537

Open virtadpt opened 1 year ago

virtadpt commented 1 year ago

How difficult would it be to import the JSON dumps from installations of Part-DB or Part-DB-symfony?

rhaamo commented 1 year ago

maybe not a lot, I just need to manage to get a dump from thoses and see what can be easily imported

virtadpt commented 1 year ago

I'm having great difficulty getting a data export from Part-DB-symfony master/8e6bc25 right now. I'll try again after work today.

virtadpt commented 1 year ago

Welp, I just remembered why I opened this ticket. I just updated my install of Part-DB-symfony to the latest checkout, but the JSON and CSV exports are worthless. Zero entries. Observe:

[
  {
    "children": [],
    "comment": "These things breed like rabbits.  May as well inventory them to keep them straight.",
    "name": "Cables and Connectors",
    "lastModified": "2022-09-07T21:36:05+00:00",
    "addedDate": "2022-09-07T21:36:05+00:00",
    "type": null
  }
]

(This category has 24 entries.)

rhaamo commented 1 year ago

arg, if they fix that issue I should be possible to import that

virtadpt commented 1 year ago

I was able to work around it by exporting all of my tables that had stuff in them as JSON docs using the mysql shell. Would those help?

rhaamo commented 1 year ago

hey, yes that could be useful, for a one-shot import. I don't know when I will be able to look at that, probably more in january, you can drop me an email with the file redacted of personal/private infos and I will look at what I can do.