Level 1 Model Building SYS08 Employee Details Import Issue

RobinSilk
Contributor

Level 1 Model Building SYS08 Employee Details Import Issue

 

We are asked to import Emloyees.csv into SYS08 Employee Details and I am unable to get the names in the list to match on the names in the employees list that I already have in. I checked and I have the data type as "Text" listed within the SYS08 module, and the .csv has the data in that column listed as "General". I also tried changing that to "Text"; neither work. I can do it manually but it will take a long time.

 

Is there something I'm missing or should consider?

 

 

 

Import Problem.PNG

31 REPLIES 31
Richashah0909
New Contributor

 

 

 I am also getting the same error. Did you find any solution?

 

Richashah0909_0-1587512418132.png

 

Richa Shah
Star
Regular Contributor

Hi @VIGNESH.M , @RobinSilk , team

Below is the mapping of the line items and the Grid View after loading.

 

Star_2-1583804978502.png

Star_3-1583805080772.png

 

1)  The Code cells are blank.  What item should be mapped to Code?

2)  Are Code, Name, Department, Country, Start Date, Leave Date, Current Salary, Commission % supposed to be in Rows or Columns?  

     In the Model downloaded as per training activity, these are displayed as Columns.  Wondering if there are any steps missing at this point or are there future activities that result in these being displayed as Columns.

 

 

 

 

 

 

 

Tiffany.Rice
Certified Master Anaplanner

@Star 

 

The code should be derived via a formula, no source items need to be mapped to the "Code" line item for the import.   The code is related to the #E2 Employees list, you will need to use the appropriate formula to return the CODE for a list ITEM.

 

To your second question, you can change the view of a module by selecting Pivot, moving the elements and then saving the view as default.  From a functionality perspective, it doesn't matter if the items are in rows or columns (the calculations will work regardless).  The question you must ask yourself is: what view makes the data easiest to read (Line Items in Columns is likely the best bet here). 

 

Hope this helps! Shout if you have any more questions.

Star
Regular Contributor

@Tiffany.Rice
Thanks for explaining.
Essentially, at this loading stage, the Code should be blank until further activities, correct?
Yup, pivoting did the trick 🙂


Tiffany.Rice
Certified Master Anaplanner

@Star  That's correct.  You should see some additional instruction in the "Activities: Enter System Module Formulas" section later in the course.

Star
Regular Contributor

Thanks so much, @Tiffany.Rice 🙂
SatyamArora
Frequent Contributor

Hi Tiffany,

 

I was stuck with this too and I'm at a similar stage in the training. So the output in the screenshot above which @Star has shared is correct?

 

Also, I populated the code line item with a name and the only way to fix it was by deleting the line item and inserting a new Code line item again in the module. I reimported again by not ignoring code in the mapping (not sure if this step was required again though).


Thank you.

SatyamArora
Frequent Contributor

@JaredDolich @Akhtar.shahbaz  can you guys help on this one too pls? Thank you Sirs 😊

braju
New Contributor

Hello,

I am trying to build SYS08 Employee Details using the import file, i see the import is successful but not getting the emp name & company after successful load. 

Added the E2 Employee list image and all the import steps. Please let me know if i am missing any step to get the Employee & Country to make it as active field.

E2 Employees#.JPGEmployee formula.JPGImport_Mapping.JPGE2 Employees Active.JPGSY08 Employee Details.JPGAfterload.JPG

 

jjayavalli
Contributor

Hi,

 

For E2 Employees# mapping, have you selected the Fixed Item?

 

Thank you

J