Discussion
MCImportData Import issue
Hi,
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.
Thanks, Owen
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.
Owen
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
Hi Bellerophon
Thank you for sharing your observations; much appreciated.
Regards
Guru
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."
Owen,
Thanks a lot for your feedback.
Great to hear that you managed to work around the Bulk Edit issue.
Sorry for the inconvenience.
Marco.