Exporting Products and related information from one DB to another.

Good Afternoon, I have a new question and could use some advice....I am trying to export the products and its related versions..from one database to another.
With the issues I was having with adding an invoice (which the patch from 12.0.0 to 12.0.1 didn't work, HOWEVER, I DID fix my issue, more later on that and why I am attempting this.).

The ONLY data I want to export or import IS the products, it's related links (?) to the components and component versions. The most extensive work I have done is figuring out how to set the products and its components up to track within ProjeqtOr.

I tried trough phpMyAdmin to export all table that have "product" or  "version" ("Catalog" also)in their name. Imported the tables into the new DB. Annndd...
All looked well. The data was there.
Then the problem started. ProjeqtOr completely locked up when trying to add data into the product or its version.
Nothing in the logs. Had to close the browser and wait a few minutes before trying to log back in.
So started back over with a clean working database, system and the issue happened again.
As soon as I tried to save a changed product (didn't matter what I changed) ProjeQtOr would lock up and do nothing. If I clicked away, ProjeQtOr would say I had to save or cancel to continue. All the buttons would be greyed out. No save, export, emails.  Then the only button that was still blue was the talking bubble.

So my question is this. Which tables do I need to export from one  and import to the other the products, their components and versions so if I had to start over with a clean DB, no resources, actions, tickets, decisions requirements etc... and so that ProjeQtOr will still recognize the data and not lock up?

I am assuming that there is a table that I am not importing that is important somehow for this but don't know which ones to grab.

And thats because with my other issue with not able to add invoice lines or change or save or anything....
The patch didn't fix the issues I was having with that.
WHAT DID FIX IT?
A clean database.
Many steps later and after the patch, to trying to fix the invoice issue...
I gave up and decided to start fresh. New install (same files, local test XAMPP stack), new DB.
Invoicing worked correctly and had no issues. I imported the old database annnndddd....
Invoicing locked up and I got the error again.
Tried a few times and every time I imported the old data into the fresh DB invoicing would have errors.

I can only assume there is something in the DB that is causing the invoicing to crash. I looked through all the tables, nothing jumps out at me.
If you would like, I can email you the DB Dump and other relevant technical information, that is causing the error and you can look at it. Maybe something in it will jump out at you?

Thanks for your help.
 

Hi,You can do this with the API. it'easy for Read.
You have first to to adapt your .htaccess in projector/api/.htaccess, put the full path for your projector/api/.htpassword.
$ htpassword -s  projector/api/.htpasswd projapi
--> put twice the same password
after that you can test the API with the software Postmant
for a GET (what you want to do with Product, url is :
http://192.168.12.10/projeqtor/api/Product/all
for all products
http://192.168.12.10/projeqtor/api/Product/search/name='name of the product' for searching by name
http://192.168.12.10/projeqtor/api/Product/10 for Product id 10

In postman, before Send, In the tab Authorization,
select 'Auth Type' : Basic Auth
type the username and the password you gived for the .htpasswd
In the tab Header, add the key : Content-Type, Value: application/json
In the left of the URL, you can choose the GET method and clic Send in the rigth of th URL.
An exemple of résult{    "identifier": "id",    "items": [        {            "id": "3121",            "name": "742-3606-1_",            "idProductType": "212",            "nameProductType": "PF",            "designation": "OUTIL CARTE SRI REV B ELDEART GESTION DOC + ECRAN + PROG",            "idClient": "",            "nameClient": "",            "idContact": "11",            "nameContact": "Patrick NIVES",            "idResource": "11",            "nameResource": "Patrick NIVES",            "idProduct": "",            "nameProduct": "",            "creationDate": "2025-03-05",            "idUser": "3",            "nameUser": "Guénolé MICHEL",            "idStatus": "11",            "nameStatus": "accepted",            "idle": "0",            "description": ""        }    ]}
Guénolé