Skip to main content
Answer

Insert Image via script

  • February 17, 2025
  • 4 replies
  • 62 views
Varsity I
Forum|alt.badge.img

Hi All,

Trying to insert image to UploadFileRevision table via script. Converted the image to hexadecimal/base64 , though the script works without any issues unable to see the image on screen.

Any thoughts?

Best answer by vkumar

Hi 

You may check this thread. This has instructions for an alternate approach

Hope this helps.

Regards,

4 replies

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • praveenpo
  • Semi-Pro III
  • February 17, 2025

Hi ​@ vib1980 ,

if you can share what scripts you have tried and what records are updated in that  UploadFileRevision  table will be helpful to suggest anything.

Praveen
Chris Hackett
Varsity I
Forum|alt.badge.img
  • vib1980
  • Author
  • February 17, 2025

Hi ​@praveenpo ,

Below is the script

 

INSERT UploadFileRevision(`CompanyID`, `FileID`, `FileRevisionID`, `Data`, `Size`, `CreatedByID`, `CreatedDateTime`, `CompanyMask`)
VALUES (
@CompanyId
, @FileId
, 1
, FFD8FFE000104A46494600010100000100010000FFDB0084000906070E0D10100E0E101015120E0F0E0F0D0D100F0F12120F0E1511161615111313191D2820181A251B151521312125292D2E2E2E171F3338332C37282D2E2B010A0A0A0D0D0E1A10101A2F221E262D2D2D2D2D2F2B2D2F2D2D2D2D2B2D2E2D2D2D2F2D2D352D2B2D2D2D2D2D2F352B2D2D2D2D2D2D352D2D2D2D2D2D2D2D2D2DFFC000110800C800FA03012200021101031101FFC4001B00010002030101000000000000000000000005060104070203FFC4004010000202000304070603060309000000000001020304051106122131132241516171815291A1B1C1D10732621423427282F033A2D224343543447392E1F1FFC400190101000301010000000000000000000000000304050201FFC40032110002010302010907050100000000000000010203041112312113324151618191A1F00522B1C1D1E1F1152342527114FFDA000C03010002110311003F00EE200000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001E2738C56ADA4976B7A200F40D19E6D868F3BE95E0EC87DCCC335C34BF2DF53F05643EE75A5F51C7290EB46F03CC649F14D3F27A9E8E4EC000000000000000000000000000000000000000000000000000000F245E6D9E51835FBC96B26B58D51E327F65E2C88DA7DA7E85CA8C3B4E6B84ECE6A1E0BBE5F229B86C35D8AB1C60A539CDEF49B7AFACDBFA97685A6A5AAA70465DD7B434CB93A4B3226331DAFC4DBAAAB4AE2F96EF5A7EF7F4441DB6D973EB4A7393EF94A6CBAE55B195C1296225BF2F622E5182FABF8166C3E12BA96ED708C5774629133BAA34B8538E4AEACAE6B7BD5658F3F2D8E590CA314D7570F6F9F46D18B329C4C575A8B7CFA26CEB40E3F509FF525FD2218E7338FD188B697D49CE125D8A528BF713F976D8E22BD15C9591ED7F966BD57065E31581A6E5A5B5C24BF5453D0AC66DB1717ACB0B2DD7CFA29BD62FC9F35EBA9DAB9A1578548E3D75913B2BAA1EF52967B3EDB160CAB38A316B5AA5C52EB56F84E3E71FA9207229C2EC2D9C77EBB20F55D8D78AEF5F02F1B35B4AB13A537691B52E0F946CF2EE7E0435ED1C16A871459B5BF551E8A8B122CE00291A600000000000000000000000000000000000000001E595BDAFCEFF66874553FDEDAB9AE7087B5E7DC4FE2B111AA12B24F48C22E527E08E4F8EC54F1574AC7AB95B2EAC57676282F822E59D0539665B2337DA372E9434C79CFE07D329CB6CC5D8AB87F34E6F8A82EF7FDF13A665596558486E56BC6527F9A6FBDB35B67B2A584A54386FCBAD6C976CFBBC9723ED9DE66B0B53B34D64DA8D70F6EC7CA22E2BCAACB4C76F88B4B68D0A7CA4F9DD3D9D84883570554A15C54DEF4B83B25DF37CFD3E86D14DAE268A7959320007A00001179CE4F56321BB35A497E4B12EB41FDBC0E6B8EC1DB85B5D73D54A0D4A324F9AEC9C19D7481DA9C9D62A96E297495A72ADF6CBBE1EBF32E5ADCB83D32E6BF2336FACD545AE2BDE5E6365F3AFDAEBDD9E9D2D7A29AF69764D79FCC9E392E4D8F785BA16AD744F49AF6AB7CD7F7DA8EAD5D8A6949714D269AED4CF2EE87273CAD99D585CBAB4F12E723EA002A1A000000000000000000000000000000000000055F6F719B9878D49F1BA7A3FE58F17F1D0AFEC5607A6C4A9B5D5A16FF00F53E11FABF43636FED6EFAE1D90AB7B4F1949FFA5127B01528D16D9DB3B34D7F4C62BEECD45FB76995BBF9FD8C297EF5F61ED1F97DC9DC4633F7D0C3C38CA49D967E8A976F9B7C17AF7159CFF11D366386C3FF000D53ADB5DF37D77F048DAD92BFF69BF19887CE4EB8C3C2BE3A2F72457B157EE664EC97F0E2A3ABF0D52F91151A589C974A8F9B26B8B8D54E2FA1CBC93FB1D3119308C940D700000000000000E5FB5781E8313349756CFDEC579F35EFD4B7EC5E33A5C2C53E75375BF25C63F06BDC46FE20E1DB545914DE929C1E8B5E0D26BE4CF1F87D294657D72525AAAE4B58B5DE9FD0D3A8F94B54DEEBF062515C8DEB8AD9FCF8976001986D8000000000000000000000000000000000001CE36E7FDEDFFDAAF4F7C89CD95FF87CF4E7FED1EFE2457E2055A5F5CFB2756EEBE3193FF5224F602D52A2DAFD9B38AF09457D99A951E6D62FAB0615258BD9C7AF3F5347F0EAF4A7755ED42B9C7D354FE688EDB3C1BAB15297F0DCA3645F8F27F15F13CDD09E578CD527A425270FD743ECF770F345CB34C055995117092E2B7E9B3BA5DCFC3B1AFB1ECA6A9D6553F8C9085375683A3FCA2CFB6CE662B154467AADF8ADCB5774D7DF9FA92A8E6797E2B11955FA5909692E1643B270F6E0F936BFF4742C0E32BBE0ACAA4A517DABB1F73EE653B8A3A25AA3CD7B1A16771CA474CB8496EBE66D800AC5D3064D0CCF35C3E121BF7DB082ECDE7C5F92E6FD0A1677F89327AC3055E8B974F6AD5FF4D7F7F712D3A13A9CD4453AB086ECE8D7DF0AD394E518C573949A497AB2BD8DDB9CBEAE0AC958D7655072FF0033D17C4E4D8FCCAFC4CB7F116CE6FB1CDF05E4B92F43732DC8B1989D1D5458D3FE36B721EF9688BD1B284566A4BE4519DE4DBC538979B3F11AAFE1C358FC653AE3F73DD1F8874BFCD87B178C65097D8ADD7B26E0D2C462B0F5B7FF002E2E564FDC895A362AB97E5BEF7AF6FECCE0BFCCD0953B54BF244AADD37C31E5F92D7976D3E0F13A285A949F2858B71BF2D783F464D1CF319B0DD1AEAE2ABD5FF0DB1DCF937F23EF9762B31CB74E962EEC3AE0E509749B8BBE0F9AF27C3C8AF3A14DACD397732CC2E6A45E2AC71DAB8F897D326AE0B175E2211B6B929466B58C97F7CCD92A34D17934D65190003D0000000000000000000000000002ADB7B83DFA236A5C699EAFF925C1FC7420362B1FD0E2771BEADEB73FA9718FD57A9D0313446D84EB9AD6338B8C97834728C7616785BA55BD54AA97564BB7B54D7C19A769255294A93F5E99897F1952AD1AEBD7A45E36A6542496363A51269578C8FF00D35AF8696F745F64B9763D3837AD9565F8CC13D68942FA26F7B7633516FF005C35E1AFAE8C96C8B31863E8EBA4DEEEE5F5B49A6F4E3C3B995EC76C3DF4373C9F19661B57BCF0B293961DBF05C777DCCAD1938A74E4F1FEEDF545FE4A9D5C558EFD6B7FB96D9D50C4D7A5B56ABB6BB2316D3F8FBD1A746CFD34CB7E89595B7F9A309EB1979C65AA28B8A9ED755AAEACD2E0A7547092D7DE93F811189CBF69F17AC6D58AD1F35D2D5547DD068EA345E31AD25FE9DCA31CA6E396BA71C4EA19C6D3607029F4F7C1492FF0A2F7EC7FD0B8FBCA1677F89D759AC3055AAE2F874D6A52B1FF002C392F5D4D0CBBF0BF30B1EB74E9A937D6D652B25EE5C3E25A705B019660A3D262EC7669CDDB28D75FA4173F56CEE31B7A7BBD4CF272A925FD51CDAAAF17985ADA575F6BFCD2EB4DAF37C92F722DD96FE1E5DA7498DBA14C17194538CA4BCDFE55F12DF5E6CDAE872BC2EB18F056B87454C7CB96A6BE2B2FAA1FBDCD715BED715426E305E515C65E8912CABCF65EEF66EFC3A3BCA8F4F47BDDAF82F1E9EE3472EA30544B732EC23C45AB83C45BC6317DFBD2E5E9A1298AC24F4E9333C5EEC5F2C3D52E8E2FF4F0E33314E37157A55E030EA9AB92BEC8A5C3BE10FF00E9A39DE069C157D25B377626C4E3095AF551EF928772F1EDD08D71925D2FBDFD11CCE4D45CB74BBA3E1BB3E766D2D1875B980C3C23D9D2CD68DFA737EAC97CA72FB717542EC5DD6BE916F2A612E8A0A3D9AEEE8DEAB8F32999365EF1574295AE8DEB63F66B5CDFD3D4EAD5C14528A5A24924BB92176A14B118EFD7D27361AEBE67539AB825B2F035B0D96E1E9FF0EA827ED28AD7DFCCDD00A0DB7B9AEA292C2469E1B055D5394EB5BBBFC6718F08CA5ED69D8FC7B4DC064F1BC9EA496C0000F4000000000000000000000000000C15BDAFC93F69874B52FDED4B92E738FB3E7DC5901DD39CA125244556946AC1C65B3392E53995984B1590FE59C1F0535DCFFBE074CCAF33AB170E92A7E128BFCD07DCD103B4FB31D3377E1D2563E33AF92B3C5774BE65370B89BB0B66F41CA1383DD926B4F49A7F534A7085D47547848C5854AB633D135983F5C3E875D461FA78154CAB6CEB9251C447725EDC54A507F55F12CB86C5D76AD6B9C64BBE324CCEA94A74DFBC8D8A5714AAACC5FD4D7BF097CF5FF6894577575C13F7CB523E591D7096F2A3A69F65988B9CBE69FC89FD4C9E29C91ECA8C5F1FBFC4849E0F1B6F5657429872DDA21ACB4FE7972F447D305B3F86AA4E7BBBF37C5DB6B73937E6CDDC56369A16B6D908AFD524B52B19AEDA463AC70B1DE7CBA59AD22BC9737EBA12D38D6A9C22B8787995EACADE8F19BCBEDE2FB97413D9CE6F560E0E537AB6BA95A7D693FA2F139AE3B196E2AD764F5729B518C52E5DD0823139DD8AB78EFD964DE8BB5BF05DCBE05E366B66561B4BAED256B5C12E31AFCBBDF89763185A472F8C999B2955BE9E98AC417AF1EC36365B25FD92BDE9E9D2D9A39BF657641797CC9E00CC9CDCE4E4F766E52A71A71518EC8C800E4900000000000000000000000000000000000000000304566F91D18B5AD91D249691B23C24BEEBC192A0F633945E62F0CE274E335892CA39CE63B2189AB8D7A5915CB77AB3F73FA320EDAACA5F5A3384977C65067613CCEB8BE0D269F635AA2F42FE69624B26654F6541BCC1E0E510CDF14BF2E22DF2E91B31666D8992EB5F6F974AD1D3A794E165CE8A5F8BAE1F610CAB0D1E31A2A5E2AB87D8EFFEDA7BE8F811FE9B5B6D7C3BCE574E1EDB9F52139C9F6A5293FF00C89FCBB63B116692B9AAE3DABF34DFA2E08E811825C125E5A68648E77F37C22B04B4BD954E2F337A88ECAB27A308B4AA3C5AEB4DF19CBCE5F42480294A4E4F2DE59A708460B115846400787400000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000000001FFFD9
, 10
, @UserID
, @Now
, @CompanyMask)

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • praveenpo
  • Semi-Pro III
  • February 17, 2025

Hi ​@ vib1980,

Please store the image data in bytes format.

 

Praveen
Chris Hackett
V
Acumatica Employee
Forum|alt.badge.img+12
  • vkumar
  • Acumatica Support Team
  • Answer
  • February 17, 2025

Hi 

You may check this thread. This has instructions for an alternate approach

Hope this helps.

Regards,

VijayKumarU
Chris Hackett
Terms & ConditionsCookie settingsAccessibility statement
About Acumatica ERP system
Acumatica Cloud ERP provides the best business management solution for transforming your company to thrive in the new digital economy. Built on a future-proof platform with open architecture for rapid integrations, scalability, and ease of use, Acumatica delivers unparalleled value to small and midmarket organizations. Connected Business. Delivered.
© 2008 — 2024  Acumatica, Inc. All rights reserved