there are different options to achieve this.
You can import your column with cell text information to an attribute dimension. Then before data is posted to the main table (Event script ImportAction / subevent PostWorkToMainProcess), you can create memo items based on this attribute and data being loaded. You can use either SQL to insert into memo item tables or use fMemoAddItem (class ArchiveMgr)
You have to enable "Cell Text loading" from adapter in order these memo items are loaded as cell texts in HFM.
Hope that clarifies
thanks for your quick reply. Your suggestion worked and I am able to write cell text to memo fields on import. There appear to be a few memo items that are always required, e.g. Author and ItemDate. When I export the memo field to HFM it writes not only the LongText to CellText but includes the Author and timestamp as well. I cannot regulate on import what to write to memo fields since some information is required so I would have to limit what it exported to HFM. Any ideas?
I include the action script to import to memo fields:
'Write Celltext to Memo field
'Get the variables from the POV for the Import
strPartKey = API.POVMgr.fCheckLocProf(API.POVMgr.PPOVLocation).lngLocKey
strCatKey = API.POVMgr.fCategoryKey(API.POVMgr.PPOVCategory)
strPerKey = API.POVMgr.fPeriodKey(API.POVMgr.PPOVPeriod).strDateKey
strTable = "tDataSeg" & RES.PlngSegKey
If strPartKey = 835 Then
strSQL = "SELECT t.dataKey, t.Attr1 AS Celltext"
strSQL = strSQL & " FROM " & strTable & " t"
strSQL = strSQL & " WHERE t.partitionKey = " & strPartKey
strSQL = strSQL & " AND t.CatKey = " & strCatKey
strSQL = strSQL & " AND t.PeriodKey = '" & strPerKey & "'"
' 'Initialize the recordset object
Set rs = DW.DataAccess.farsSnap(strSQL)
'Loop through results
If Not rs.BOF And Not rs.EOF Then
Do While Not rs.EOF
'Create new object
'Process the field value
.strAuthor = DW.Connection.PstrUserID
.dteMemoItemDate = Now
.lngDataKey = rs.fields("datakey").value
.lngDataTableID = RES.PlngSegKey
.strCategory = strCatKey
.strPeriod = strPerKey
.strShortText = "Memo"
.strLongText = rs.fields("Celltext").value
.lngPartitionKey = strPartKey
.lngMemoItemType = 1
If API.ArchiveMgr.fMemoAddItem(API.ArchiveMgr.PobjMemoItem) Then
bOk = True
bOk = False
'Move to the next record
Sorry, a short search on the forum revealed the answer:
Follow Yves LOADB script to eliminate unwanted memo field info from cell text
Thanks again for your input, Francisco