04-19-2021 06:11 AM
I have various types of binary files such as word document, Excel, PDF, images etc. stored in MySQL DB as blob storage. I am transferring this files to NetSuite File Cabinet using NetSuite Create snap and selecting File as record type. The problem is that when I run the snap, it is only creating partial files on NetSuite. For e.g. I have one PDF file of 21KB but on NetSuite it is only creating PDF file with size of 6Bytes hence it is a corrupted file. How do I make sure the file is getting transferred correctly from MySQL blob to NetSuite File cabinet?
02-17-2022 12:48 AM
I don’t beleive that the issue is it on NetSuite side. Please chek how the file/content is stored in MySQL DB.
In order to ensure that the issue is not related with NetSuite, try to read a local sample file(using File Reader Snap, not to read the file from DB), get the content and create in NetSuite File Cabinet.
Regards,
Spiro Taleski