1.5.6.2 Import Data into Historic Volumes Module

Hi I am having the much trouble trying to import data to the module:

 

aveikoso_0-1626856844138.png

 

 

I've matched all 

aveikoso_1-1626856844035.png

aveikoso_4-1626856891842.png

aveikoso_6-1626856924992.png

aveikoso_7-1626856944241.png

aveikoso_8-1626856966075.png

 

 

 

Run the upload and says it is successful:

aveikoso_2-1626856844127.png

 

 

But then there is no data loaded? I also not that the Time is incorrect?

 

aveikoso_3-1626856844196.png

Have spent about 3 hours trying to mitigate this with no resolution. 

 

Please help! 😞

 

Comments

  • For anyone who stumbles across this - the mapping was completely correct and the data was present in the table I just missed expanding the time.

     

    aveikoso_0-1626859982478.png

     

    aveikoso_2-1626860052006.png

     

     

     

  • Your pics is not visible

  • Hi @aveikoso ,

    If your import didnt give you any errors or warnings then it must have imported the data correctly,

    I will suggest once to review the module pivot view , try to pivot in such a way you have viewing ability to lowest level of hierarchy.

    - Rohan

  • Can someone help me out and tell me why I'm not getting the result that I should?

    First pic is what it's supposed to look like, second pic is my result. Don't know what I'm doing wrong

    Thanks!!!

  • @LeticiaHurtadodeM - Looks like your decimal & comma separator are interchanged which is causing this issue. You can go to the excel & change those options & retry the import.