Hello everyone,
I have created product sheets in SuiteCRM.
To attach a PDF file to each product sheet, I set up a “Relationship” between the product sheet and the Notes module as “One to Many.”
Now, each product sheet displays the associated PDF file underneath.
However, when exporting the product list to CSV, there is no trace of the associated PDF files.
Even when exporting the Notes list, there is no reference to the Product IDs to which the PDFs are linked.
How can I generate a CSV export containing the product list along with their associated PDF files?
I don’t think you can do this. Files are not stored in the DB. Only a coded file key and file type. The actual file is stored in the /uploads/ directory with the coded key. SuiteCRM looks up the key in the DB and then a separate proces matches it to the actual file and file extension stored in the DB and opens the file.
When you make a relationship, the associated record is not stored in the module table, so when you export you will not get the related records. You’d have to write a report to get related records. However as noted above, this doesn’t work (I’ve just tried to report on notes with the file attachement and url).
SuiteCRM doens’t have a “file” filed that you could create in the products module, but you could get a developer or a plugin to do this. There is a “product” image field in the products module but this expects an image file.
. Looks complicated task to me. You may need to write custom code or find add-on on the store.