Add attachment to form, save file to network drive

  • 8 August 2018
  • 4 replies
  • 32 views

Badge +8

Hi

We have a form that creates a notification, and also enables the user to upload an attachment

i get data stored in SQL table for the notification, and also the attachment gets stored

the content is like below.

How do  get this to be saved to network location. we have the File Service broker, but can't seem to get it to work

is the right path moving forward?, or a better /different way?

  

<file><name>Capture.png</name><content>iVBORw0KGgoAAAANSUhEUgAAAdAAAAFjCAYAAACNA1rbAAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAAAJcEhZcwAADsMAAA7DAcdvqGQAALnpSURBVHhe7Z0HmNXE+rj53ea1Xb0qKr03kd57R5oiAiKouIAISLHQe2fpsPTOAgtso7elV6W6oKIgYFc6Uu3e//f/vplMziRncvZsAZbdj+d5STKZmUwm2bxnJskkQ7bsOSH+4+MwavwUGDluMgwfMwmGjR4Pw0aNg6EjxyJjkNEwZESoxSgYMnwUDLWg+cHWVDF0eCgMHTEahmPa4aOQ0LEwAvMcNXYijB4/GcZMmgpjJ01HpgnGWNNxGDZuMhI2A8aHzYQJU2bBxGlzYNJ0Yi5MmjkfwgQLBJNxftL0eWLdhKmzMZ/pEDo+DEaMmYjbpfKPwfIiw6n8Y3CfxsJwLMcI3MeRYyU0L5ZF2GTBKKwHyid0wlQYPUGWj/IeM3EajLagdaMwzshxuD3MZzjlZaWnsFHjaf1UCKW4E7FcBOYxWs0jo2l50gyLmXI9zofaYXJ+1ETFdBg1YTqMGDcNtzcFhoROgoEjx8PA4WOg35BQ6DNoBPTsNxS69xkE7/UeCO/27Avv9OgDXd/rBZ3f6Q4du7wHb3bqAm3bd4KQdh2gdZv20Kp1G2j52hvwcqvXoWmLVtCk+SvwwksvQ8MXm0HDxk2gXqMXoW7DF6BO/eehNlKzbgOogdC0ep36UK1WPahaqy5UqfkcVKlRBypXrwOVatSGStVrQcVqtaFC1ZpQvkpNKFelBpSrXB3KVKoGZSpWhdIVqkKpClWgZLnKUKJcJShRthIUL1MRipWpAMVKV4AipcpBkZLl4NkSZQWFS5SBwsXLwDPFSkOhYqWgUNFSULBISSggKAEFni0O+QsXg3zPSPIWKooUEeQpWARyFXgWeUaS/xnIme8ZyJ63EFJQkqcgZMtdQJA1V34HWZDMOfMheSFzjryQKXsewdOC3A6eypZLklXyZJackFGQQ5JZ8oQguyRTdnj86WzwmB9ZnTwl+S9N9fVa+H+fyiJ50sIVpuIqHrcQy1p+VB5BJgKXCSuMyktkxLITT9I+aftI+/wU8iTtf1acx/p4OrskE9ZRphx5sC4RnGbB+syCdZslVz7Imjsf1n9+yJanAB4TSQ48NjnxONExy5W/MOQugBQsjMf0WXFs8z1TVBz3As8iRYrjeVECz5GSSCk8X0rDsyXL4HlUFoqWKovnVTmkPJ5rFZCKUKp8JTwPq+D5WAXKVqoK5fDcLI/nKZ2zFavVxHO4tjin6fyuVus5qIHne8269aF2vYb4t9AI6jR4AZ5r2BjqPf8i1EcavNAEGjVuCo1ebIp/Q82hcbMW8CLS5OWW8JKgFTRv+Rryuvh7e/nV1+GVV9+Alq+HIG3g1TfaCl4LeRNeJ9q8Ca3btoc32r0loL9ZmrZp31HQ9q1O0E7R4W14s2NnaI9/35KuNm+97aND524a79h07OKjU9d3Nd5z8HY3J53feT9BurzbHY7EH4WmVSvA8dUr4MDkMXA4bAwcQeKRo1PHwDHkU+T4tNGCE8hJ5BRyevpoOCMIha8cjPbjS0OYTDsG8xmD+Y3BfMdg/rQtyadTx+L2x2I5xmJ5xmK5xmL5xsIB5PialaLc8UePwbs9etvs+3A//PexxyHDuAmTYPHyFTB+ymwYO3mGlATJA0UXOm4SymQiThGS37gJgjG4PGb8JMFYAuONQcQ8gXmOmzgZhTgFxqMsx0+eChPDpsOkqTMhDGU4deZcmDprPk7nWeCymGLY7PkwbfYCZCHMmBsOM+cthlkLlsDshUuRZTAnfBnMXbRcEr5chM1aGAEzMN5UTDd5+myYgAIeN3EqjJ04Bcs4GfdnkoCWx02eBhOnzBRloakfU2fhOsSSdhiWbQqWi5Dyno/ingeTZ6DQcf1EFPcEzEtBy8QkIX6MQ/HsdFL8YbMWwpTZ4VheZM4iDdyHuZIpuCzAODQNmxWO6RdiXgtgIv5oGD9tLv7QmCUlizIfjuIeGjoBBuOPnoHDQqH/4BEo1OHQp/8QlOog6NFngBBqt/d6Qudu70NH/KNpj39wbd7sKP5IX32jHf4xt4Zm+MdNIm3ctAU0atJcXBTq4UWC5Fm7XiNxARHirP0cXlhImnWhshAnSbM2XnhqiQtQBbwQ0cWoXJXqeHFCaVriJGmWKl/ZKM6ipcoLdHkGFifybAkpTkRKU4qTpEnkRnHSRTcXkpPEieTAC7JEyjMbyRPJihdvGyVPIU4JXfiVPHWeykbi1ORpCZRE4idQTaK6TKWoLGlZ+IlUiU7IzkugmjAtnOv9w504w1U57PIJmcp5XaT0Q0AJVe2XEqmSqaojW6RYdyRRIVSSKf5AMYk0Bx4bkmiOfBKSqVukeZ+RMlUiLYg/qhwiLVFaiFRJtHgZEmlFPA8rOURKEiXo/KXzmM5pOrer1qzrFOlz+CPyOSnSuihS+qFJIm3wfBNo0PglKdImzWyRNmn2ii3SZi1eFSJVEm2BElUibdXaX6KELtGQNyVt8Icw/RiWApUSbddBl6hPpHdboiTQJpXKwrHYKPhw7FA4QIwfCoeQI0j8hKFwzOJT5DjyOXJSMAROIWc0xmO5mr78lg0tn8G4XuGn7LyGYb7DMP9huJ1huD1JPHJk/DAszzAsFzJuGHyIHFsRLcrtFui4iWEwaPAQyHDy9Jfiwh02C+UzY54UAgpoAgqPpDchDIVjMXnqdEHYtJkwZfpMmGoh52dJZsyCaTNnw/SZc2D6rLmCGSjFWXMXwKz5i2AuynDeoqU2cxdFoAgl82hehC+D+ciCJVEQvjQaFi2LhcWRK2BJ1CpkNUTErBHQPIUtjlwJ4ctiMM1ylO1imI4iFVKeMQfLNgsmY3nDqGwYNh3LMmPuQphJckZI0gpanjV3kWT+Ypi9IAKFTWVU0qapZA6JG/eF4s2Yt8jKYxEKH+dJ+vNxHa3HPEj+tvgXR8E83K95S6JhQQSWOSIWFixdAQuW+aAwYh6xRDIX489ZFAWzFkXCLPzhMHPBMpg+b4mQ8OQZ1BKfK1rtY7EFHzp+imgVjxg9AYZiq3vwiFAYNHQk9Bs8DHr3Gwjde/eDd97vBV3xl6ESaVv8Rft6m3bij5j+qJvir2X69Uy/puujROnXdi28YFSvU09cROiXOeGQJlK+smxpCixplsGLE12gvMRJLU4vcSppOsQppEktzuIozuJ48URp4gXUJE4hT2y55ETUBZjEKeSJF2a95SlanwJqdWKriFpGQpzY6hTIi70NCuBplIKOanUJSBxCni6BWugtUOJxgSUqkpYlL5NAdRnq4c71zniqBeqVlsKlQBFXa1Uvjy1SK0yVXe2PLVJrP0UrVBOp3SpFMmGdEdSaz5Qjt0+klkyFSPGYZEeZkkjFDx88hvRDyNQipfMgmBapuzXqE2llcc6K1iiew3ROU2uUJErQOV+NRIo/IJVIqUVKfx9CpFprVIj0xWbih2jjpi/j3xNKtPkrVmtUilRIFGmBP15Joq+4WqM+iWotUUugIfjjlwTqlGhngak1mjyJOkXqlmhCIj3yUTw0LlcSjkZGwN7hfWGfxX7kwMi+cAg5gsQjxyw+HdkHjiOfIycFvW1Ijvo/Wh77dhdjuEzbF/Ppi/lRvpR/P0E8cgQ5hBxA9o/oB/ss9iJHo5aKcrsF+n4vLPPhI5Dh4uWfYLa4IC+F6SiA6XMWWq3DuShCahnOwekcmIEinDVnHsyeOx9ZAHPnLxTMsabEvAXhMG/hIpi/cDHMD18iWIBCXLh4GYQvWY4ijIIly2MgAmW4NHolREShFCNjDcj1y2JWQ+SKtRC1cj3ErN4IMWs2QezazbBynSR2bZwIi8Z1FIfSLFqGYsLtzcNtz8VyzFmwCGaLclLZsExUHixLeEQkLCSWEMutqQWGLxLijhFliYhehaC4xVSyJGolttxjheAXRkRZaXEaQcuIlT4c5b9IyH8lLBF5rIGlsWthWew6WLZiAyxfuQEiV21ENuH8JohElq/cKMIJirM0FvcN4y+JWYt5rIXFmE/48pUoW5QrCpnETKImgVPLPYxavdOwJYwtampxU8s7FFvgI0LHw+DhoTBAiRRPgndRpNQi7dC5q/gF+0Y7bI22bgMtWrUWf+SiOxcvBNRVRRcKumjQL3G6mJA4K5I0sZVJFxslzbIVNXGWt8SJwqQLVQmUZnGSJrYA6AIWsLXpbnH6iRNbnUKeRSEPtjzz4AU0N15I6YJK0AVWyDOf7LJVAlVdt9TCEWgCpe5aunCr7lo3SqaOrltLnqrb1u6+tWThL9OcPnkSCQpUk6iHTE3hap0uUKdEfev1tCI/gSVTgRWmledxG59IBdZ+OURqtUglUqpCpFhHukhFqx4lSnWtJGq3SvHYuGUqRerfItW7dqk1qkSqWqMkUurWlV27TpHSjz2Cek7s1iiii5RapFKk9aAm/k3Uom5dS6TP6SLFvx36+7FboyhSvTXaFCWqREoSFa3R10KESM2tUWeXrmyJytao3p2rcEvUW6RmifqLNGmtURJowxKF4dDiebCtV1fY3rsr7EB2Ibv7dIF9yIfIgb5d4BByBInv21nwMfIJ8mnft+G4xWjcZ5Ms9X+0PAbjHe/3NnzaD/NAjloc6dcFDuM2DiL7kX19u8IeZHefbrAT2YFs690NDi+ZL8rtFijx3fc/QIbLKNB52BKatyRGXIjnLMQWE7W+sLU4B4U4FwVEzA9fDAsXLUERLoVFEUthccRyB0uWLocIFGTEciIalqEol0XFwvLoFbA8ZiVExa6C6JVrIGblOohdvQFi1yA0XY1yXLVOhIspsVrGWbl2E6xevxnWbNwK6+K2Iztg/ZZdsGHrbsH6LTth3eadsBbXrd6wFVZg/OiVKCeScySKGsuxBMu0GMu2WJTNKlPMKoiMXY1TYpULGU7ro6hMoqybMO84WCEEboHztI7iRMaugeWUn5j6kPJfJ+ROkhc/ANZgPuu2wMoNW2DVhm2waiOWfdMOZCesjkPE/A4RTqzEOEQsgeli126BaMwjajWKdgWKVbTEVwlRk7jnL6au7aXYel6MreFw/EGEP4bwx08YdW2jTKlLewS1Sodhi3TgUOjVdwC8L+6TdodO+MdCv2Jbt31L3BulbqYmzVvC8/jHX69RY7xINBICrYIXj0ooT9FFi9IUXbQVq6Aw6d5mZRSmam1aLU0lTmxp0sWqKAqzCF64iOSIU0qzKF44lTjpPqdEddfmpNaKaHVKVKtTtDwFUqKqy1Z11wqBKix5CoHSBZ5angKr2xYl4IVRola3rVugCUtUh2SmRGdJzxCu1rklqstUj+OXpxIoxbXiy2358N0jdcrU0SrFeYG176JlqiCRqq5do0ilRG2Raq1S0bVL4DH2tUifDapFqkSqWqSyW9d0f1SKVLVI6f6+LVJja/R5IdHnGr7gbI02bgrPo0Td3bp0y8TZGnVKtJWhS5f+Rm2JIlKi/vdFiZRvjSZeoiTQBkULwv4Fs2HTux1gC7IN2YHsfL897EL2dW8PH/ZoDweInu3hiMVR5JjFJxqh+GPfLU31j8Jp/Sc938J0kqPIEYsDRI+3cHtv4Xbfgl3ITmTHex1hG7IFiUMOLJwjyu0t0J+uYmsGL8DLV2CrKQYWqNYUXojDl1gtx4hlKKBIIcdlkShHZHlUDIIyEpKMhUgkKmYFipJkuRKiV6yGWBSmYNVaWIFSXLl2I6xetwnWbCApboE1KMfV6+NE2CqEpoL1xGZYi+Jcv3k7bERRbtq2GzZt3wNxO/bC5h37YPNOBKdx2/eKdRswzpqNKCRMH4vbil6xBsuBEkR5R5LEEVqOQcGStFesWS+mPkjahJyn9STwVULgWNZN20T+Yirmt6K0UYTrSKwbBbGE+nFAYZh+BZaH4lA+JPnVIo8dKH5iJ/4IwB8CW/fA+m3EXmt+N6zDcMkuWLt5F6zBuEqsJNQV67cKGUehmJevwNYsdWtTyxiPI3V5U6uYZDovPAJb3yjTuQtFl/akKTNg7ITJMDJ0HLZGR0L/QbI1+l5PkmgP/MPBlij+8b0W0l78IqYHH55/qRleCJqIX9nV8Rc33fOkC4l4KEg8EETCrCRbmeXwVzxegIrjhYhamqK1SdKk1iaJEy9WRVCaz5I08QKmxKnkSdJ0i9MnzWDEKbtrc+an1olZnArVXavueaouW4UuU73bVglUyDMRAlX3Bv0EqiDhaJhk6hOqJTBNdgpdbuY4Tpn61vnC3WG2QK11ep6qPD6JSpFSuCq/2iddpAJXq1TVqd0qxXqmbl31A0ZJ1Os+Kf1YMnXtJtQi1R80UiKlH4CqRers1nXeH1XduvRsgBSpao1aIsUfn86HjFRrVD5kpHfpNmtpiVTr0vVrjeoSRXz3Ra2Hiwz3RUmiPpHeeYmSQOsVzgcfzp0OGzq3gU3IZmQrsq3rG7Ad2Y3s6/YGfEi88wYcsvgIibc45iK0TVshy2vXrtkIebZpB8feDREctfgIOWTxIfFOCOxD9nQLgR3IdmRbl7awBYlDNiL7580Q5fYW6JWroktwsXUvkbolFy+LFi22Ua9ngAytx6MwUZZCkhOgdQYMC5kAMStWSeYNhAoZKkK/+QugX0VcV3EQzENhrlyNrFkHq9auF6xetxHWoizXoYzWx6EY47ZhixJblpuiYHCVDFB5WCTOb0EoDOPgdANKZtPWnRCHctmM4tyC0ty66wPYtnu/gOYpbMvOvRiHJLoDpYstO5IWCnAFbp/kHUMtX5I4hq1aGwEDK2M5aT+IN6eL+E5Q9ChxEudaLMd6bOGux7KsF8KzwHlqFa8VMvX9GFhlQ8tSvuHDquK2qsLgZbTP1IrG9FtlS3oj7ttGFOfG7fvkVEPIFFmH8aRIV4i6ylAlFBagiFeKFmkcRC8cBuUzVIbe87D1ja3npbZIo0VX9fzFy2DuwiUwc84CmDJDtkRHj6MnlcfAoKEjoN+AIdBD3BftCW/jHwf9odGvW7of2vSVV/GPvYV4OIIeIqqOv7bpwqHkqbpnfbK0hEkPBOHFiLpoRYsTL1BCmiRMvGjRhYtaAYXwIlaoKEmzhJRmssVpPShErU5EPWGro7prSaCqy9ZGF6hqdQqkQPX7ncaHhwhNoEqiGanliZJQ3Zk+iRpkaskmkES9RGrjsd4hUZSh4lELXaI2Kj6JlMAwXaZqvdqOkqjctiyDLVJrH4NpkRJ2q9RqkTruk6oWqdWLYHft4nGnH09+XbvWg0ZCp


4 replies

Hi Braddo,

 

You can easily create a network drive on "My ComputerThis PC" that is shared on your network by mapping that location to my computerThis pc. Then you can be able to create folders and save your documents.

 

However please follow the link below on How do I map a network drive in Windows?
https://kb.netgear.com/19864/How-do-I-map-a-network-drive-in-Windows

 

Kind Regards
Luyanda

 

Please Note: K2 will not accept any liability for any issues arising from actions taken in respect of the information provided by any forum member.
Userlevel 2

Hi Braddo,


 


I did some search on your query and came accross the below community post that I think would be helpfull with saving the file to a shared network location.


http://community.k2.com/t5/K2-blackpearl/File-Service-Broker-v2-0/ba-p/92469


 


Kind regards


Themba

Badge +5

Hey,

 

can you show us the SMO-Configuration? I use the File-System Broker too and it works fine for me.

But I save my files in a SharePoint-Library.

 

Best Regards

Alex

Badge +8

i am using that file service broker

my issue is that i am able to write data to SQL fine, and then when i use the fileservice broker to create the file, it works with some items, but not others

for example, i am able to perform a read of my attachment table in SQL via smart object, and i can see the pictures

but if i load the data into file service create method, sometimes it works, others it doesn't

 

basically, some photos are stored in SQL correctly with tags correct

eg file, name and content tags open and closed

<file><name>Course1-4_25mm.png</name><content>iVBORw0KGgoAAAANSUhEUgAAAi4AAAEjCAMAAAFV5Uo4AAAAAXNSR0IArs4c6QAAAARnQU1BAACxjwv8YQUAAACHUExURQAAAP///8/Pz5+fn4eHh1BQUGBgYEBAQPv7+01</content></file>

 

this works with file service broker

but other pictures stored in SQL, are missing the end tags - and therefore don't work

Reply