Hi all
We are using the EGW resources module as an inventory/equipment loan tracker, and would like to import a large csv into Resources.
I can do this using MySQL, but I am concerned that I might munge the resources module. I was able to export a csv FROM Resources, so I know the TABLE schema, but I am worried that if I upload the data, it won’t be visible in Resources, as I know you cannot create a new resource, without assigning it to a category. I am not a database guru, so I don’t know if I need to add some form of primary key to the csv upload, or how I would even go about that.
I was able to sequential number the new entries starting just after the highest number shown in my Resources module.
Any pointers would be appreciated.
regards
Ken