NetSuite Smart View Mac permite trabajar con datos de planificación desde Excel en macOS. Antes de instalarlo, confirme la versión compatible de Excel, sus permisos y las credenciales de NetSuite.

Step 1 – Creating “Wef” Folder
In order to install SmartView on Mac, we first need to create a folder called “wef” This is where we will save the manifest file. First, we need to determine our home user. To do this, open the terminal
and write-out the following command: whoami
Paso de instalación de NetSuite Smart View Mac
As can be seen, the home user for me is jared. We now need to create the “wef” folder. It will be nested here and will look like this:


/users/(user)/Library/Containers/com.microsoft.Excel/Data/Documents/wef

In my instance, is jared, so my folder would look like this:


/users/jared/Library/Containers/com.microsoft.Excel/Data/Documents/wef

In order to create this folder, we will again use the terminal. Input this command into the terminal: Paso de instalación de NetSuite Smart View Mac

mkdir /users/jared/Library/Containers/com.microsoft.Excel/Data/Documents/wef
We will now want to navigate to this folder in finder. We can do this pressing  Shift + Cmd + G at the same time on our keyboard. This will make our screen look like this:
Paso de instalación de NetSuite Smart View Mac
You may or may not see recent folders that you have gone to. In the search bar, paste the folder that was just created and then hit the return key.
Paso de instalación de NetSuite Smart View Mac
Your screen should now look like this:
Paso de instalación de NetSuite Smart View Mac
This is where we will be putting the XML file that will be generated in the next step. We will come back to this finder window. Minimize it for now.
Step 2 – Generating an XML File
First, we need to log-in to the PBCS environment. The service URL should look like this: epm-a999999.epm.us6.oraclecloud.com). Paste this link into your browser. Your screen should look like this: Paso de instalación de NetSuite Smart View Mac
Log-in to your PBCS environment. By clicking Sign-in. Your screen should look like this:

Paso de instalación de NetSuite Smart View Mac

Pay attention to the URL. Delete the highlighted portion of the URL below and add /CreateManifest.html to the end of the URL.

Paso de instalación de NetSuite Smart View Mac

The new URL should look like this:

Paso de instalación de NetSuite Smart View Mac

And your screen should now look like this:
Paso de instalación de NetSuite Smart View Mac
In the Domain URL section, add https://login.oci.oraclecloud.com by clicking the plus button.
Paso de instalación de NetSuite Smart View Mac
After adding, delete the original App Domain listed by selecting it and then click the trash icon.

You do not need to check anything here unless you will be updating dimension members. (Note: For admins who will be updating dimensions, you will need to check EPM Admin Extension in the bottom right
box). Select Create Manifest.


Paso de instalación de NetSuite Smart View Mac
This will prompt the XML file to be downloaded to your Mac.
Paso de instalación de NetSuite Smart View Mac
Navigate to where this XML file was downloaded to and move it manually to “wef” folder that was created in Step 1. Your “wef” folder should now look like this:
Paso de instalación de NetSuite Smart View Mac
Open the XML file in a text editor.

Paso de instalación de NetSuite Smart View Mac

Once the XML file is open it should look like this. Do not get overwhelmed. Only one small line needs to be added.
Paso de instalación de NetSuite Smart View Mac
Once inside the XML file, press cc and search for <AppDomains> inside the document.
Paso de instalación de NetSuite Smart View Mac
Underneath <AppDomains>, we are going to write a new line. This line will contain the link in your browser that appears when you log out of PBCS. It is used to trigger the pop-up box in Smart View
and is for security. Minimize the text editor and return to your PBCS environment.
Your screen should look like this:
Paso de instalación de NetSuite Smart View Mac
Click Sign Out
Paso de instalación de NetSuite Smart View Mac
Now, turn your attention to the link in the browser. It should look like this:

Paso de instalación de NetSuite Smart View Mac
Take this URL and add this to the end of it

/u1/v1/adminconsole

. It should now look like this.

Paso de instalación de NetSuite Smart View Mac
Copy this URL to your clipboard and return to the XML file. Underneath <AppDomains>, you are going to create a new line that begins with <AppDomain> and ends with </AppDomain>, and has
the URL sandwiched in between. It should look like this.

Paso de instalación de NetSuite Smart View Mac

Save the file by pressing Cmd + S at the same time. You can now close the XML file.
Step 3 – Launch SmartView in Excel
Open Excel 365. (If already have it open, you will need to close Excel and re-open it). Go to the “Insert” tab and select the drop-down icon next to My Add-ins. The Smart View add-in should now be listed under Developer Add-ins. Select Smart View to add it to your Excel.

Paso de instalación de NetSuite Smart View Mac

To login to your environment, select the “Smart View” ribbon and select the “Home” button to the left. This will open a panel in the right side of your excel prompting you to login.

Paso de instalación de NetSuite Smart View Mac

Enter your credentials and login to be connected to your environment.

Paso de instalación de NetSuite Smart View Mac

Smart View is now ready to use.

Paso de instalación de NetSuite Smart View Mac

Pruebe NetSuite Smart View Mac después de cada actualización. Si NetSuite Smart View Mac no aparece, reinicie Excel y confirme que la extensión está habilitada. Revise también que macOS permita ejecutar el complemento y que la red alcance el servicio.

Cuando falle la conexión de NetSuite Smart View Mac, valide la URL, el entorno, el usuario y el método de autenticación. Pruebe con una sesión nueva y registre el mensaje exacto.

Amplíe la instalación de NetSuite Smart View Mac con consultoría de NetSuite, planificación y presupuesto de NetSuite, NetSuite Analytics Warehouse, soporte de NetSuite, información de NetSuite Analytics Warehouse. Consulte además la documentación oficial de NetSuite.