![Tamás Tárnok = [ C#, Sitecore, … ]](https://trnktms.com/wp-content/uploads/2021/11/pxart_white-small.png)
The module is developed by @maaakstiles and I really like it because it’s easy to extend/change to fit your requirements. The basic idea is very easy. It gets data from somewhere (Sitecore/CSV/SQL/MySQL). I played with the SQL part.
I would like to import files from another database and create a media item from it. To make it work I had to do 2 changes.
Make it to deal with byte[]
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.Data; | |
| using Sitecore.Data; | |
| using Sitecore.Data.Items; | |
| namespace Sitecore.SharedSource.DataImporter.Providers | |
| { | |
| public class CustomSqlDataMap : Sitecore.SharedSource.DataImporter.Providers.SqlDataMap | |
| { | |
| public CustomSqlDataMap(Database db, string connectionString, Item importItem) | |
| : base(db, connectionString, importItem) | |
| {} | |
| protected override string GetFieldValue(object importRow, string fieldName) | |
| { | |
| var item = importRow as DataRow; | |
| var f = item[fieldName]; | |
| // it was the missing area because the default solution calls the .ToString() | |
| // and if it's byte[] then I get "System.Byte[]" | |
| var bytes = f as byte[]; | |
| if (bytes != null) | |
| { | |
| return Convert.ToBase64String(bytes); | |
| } | |
| return (f != null) ? f.ToString() : string.Empty; | |
| } | |
| } | |
| } |
So now I have the byte array converted to string. This value is passed to the FillField method so now I need to change that to attach this stream to the media item.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| using System; | |
| using System.IO; | |
| using Sitecore.Data.Items; | |
| using Sitecore.Resources.Media; | |
| using Sitecore.SharedSource.DataImporter.Mappings.Fields; | |
| using Sitecore.SharedSource.DataImporter.Providers; | |
| namespace Sitecore.SharedSource.DataImporter.Mappings.Fields | |
| { | |
| public class ToMedia : ToText | |
| { | |
| public ToMedia(Item i) | |
| : base(i) | |
| {} | |
| public override void FillField(BaseDataMap map, ref Item newItem, string importValue) | |
| { | |
| var bytes = Convert.FromBase64String(importValue); | |
| var media = MediaManager.GetMedia(newItem); | |
| // here upload the picture as a .jpg | |
| media.SetStream(new MemoryStream(bytes, false), "jpg"); | |
| // it's needed to make it editable after SetStream becauase it closes the edit context | |
| if (!newItem.Editing.IsEditing) | |
| { | |
| newItem.Editing.BeginEdit(); | |
| } | |
| } | |
| } | |
| } |
Remaining step is create a new template for Field in Sitecore and use it. This video shows how you can do that:
Tamás Tárnok = [ C#, Sitecore, ... ] 