Loading Catalog Items through the Back Door

[alefterasm]

I am currently using CMS 1.2 with PHP 3.01 and MySQL 5.0.45. I am not the actual developer, but an IT team member of the client.

I am trying to figure out the best approach to loading large amounts of data through a SQL script or Java program. These would be catalog items, and there are a thousand or so (plus all associated data - addresses, so on). This could be a very time intensive manual process. I understand I would be loading into cms_content and cms_content_props. Are there dependencies? How does the hierarchy system work? Is this an achievable goal?

Thanks!

Melody