Skip to main content
Solved

Insert Image via script

  • Feb 17, 2025 5:55 AM UTC
  • 4 replies
  • 115 views
  • Translate All
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,

View original

4 replies

praveenpo
Semi-Pro III
Forum|alt.badge.img+3
  • praveenpo
  • Semi-Pro III
  • Feb 17, 2025 6:04 AM UTC

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.

Translate
Praveen
    Varsity I
    Forum|alt.badge.img
    • vib1980
    • Author
    • Feb 17, 2025 7:35 AM UTC

    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)

    Translate
    praveenpo
    Semi-Pro III
    Forum|alt.badge.img+3
    • praveenpo
    • Semi-Pro III
    • Feb 17, 2025 7:46 AM UTC

    Hi ​@ vib1980,

    Please store the image data in bytes format.

     

    Translate
    Praveen
      Acumatica Employee
      Forum|alt.badge.img+12
      • vkumar
      • Acumatica Support Team
      • Answer
      • Feb 17, 2025 11:28 AM UTC

      Hi 

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

      Hope this helps.

      Regards,

      Translate
      VijayKumarU
        Terms & ConditionsAccessibility 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