Posted: 3 Mar 2015 14:16 EST Last activity: 30 Apr 2015 9:49 EDT
MCImportData Import issue
as part of the final NBAM Essentials Exercise, "Understanding the Sales Sub-Strategy"; I was un-successful in importing the MCImportData excel file as new propositions using Bulk Edit under the Sales > MemoryCards issue and group.
OS Name Microsoft Windows 7 Professional
Version 6.1.7601 Service Pack 1 Build 7601
using Excel and Microsoft Office Professional Plus 2013 (32 Bit)
When I click follow the instructions,
b. Click Edit in Excel.
c. Paste the Content of the supplied file MCImportData.xlsx into the spread sheet
d. Click on Add-ins and then Add.
.. after b. Excel opens but all menu options are unavailable, also I can find an Add-ins option but it only suggests sending a document copy via bluetooth.
I overcame the issue by manually entering the new proposition details.
Owen were you doing this in the 7.1 version of the course or 6.x version - Marketing Essentials? I had similar issue, you have to enable macros and it opened multiple Excel windows , the window with the Add In was different than where I pasted the data but it worked. (I was doing the newer course)
Hi, I was on the latest course 7.1 - I'm not sure if I'll have time in the near future to try your suggestion, but if you're right and update to the instructions would help those that follow. Thanks for taking the time to feedback.
Yes, just tried it again. Ironically, my work colleague just had the same issue. Security settings in Excel must allow macros. Also when you click on "Edit in Excel" it opened 3 workbooks NBAM....., PRTemplate.... and a blank one with no name. The blank one has the "Add In" tab and I believe you click "Add" after you pasted the data in the file that starts with NBAM.... Make sure you paste in B1, Import Status (first) and Instance Key (last) columns are generated by Pega.
Also note you must refresh the data when back in NBA Studio, maybe even close and reopen the Bulk Edit window to see the updated data.
When I edited data in Excel from data tables in FT/BC course it would only open one Excel file which is much simpler
Thanks again to Jeff Silver (Bellerophon) for sharing the following observation via email:
"I had difficulty getting Excel to open with the Add In tab being enabled. I have IE 11 and the latest version of Excel (Office 2013). In IE, if you go to the security tab in options and uncheck protected mode it works."