Hello, Very newbie here.
Hi everyone, I had a little webapp form for years that creates a databse record with a few attributes, example (patient_name, town_name, zip_code, file_name, directory) into a mysql db. Once the record is created in the database my webbapp allows me to I upload and "attach" a file by retreiving /creating a directory structure from the patient_name/town_name/zip_code and stores this in the directory field along with the file_name of the file I am uploading, allowing me to find the record again someday via a web link. pretty simple works create and I can find records and documents. As long was the file names are different, otherwise it just over writes them not good…..
My question and I apologize if this is wrong forum category, is there away to move these documents to alfresco, with PHP code, using my existing MySQL data (patient_name, town_name, zip_code, file_name) as meta data using some php. I know how to get to the files, I know the meta data (patient_name, town_name, zip_code, file_name).
thanks for any insights. I believe some else surely has had this problem with existing data and wanting to preload tags or meta data in afresco.
Thank you for any examples or ideas.
