Importing is not updating correctly

Sravan_Kumar
Community Boss

Importing is not updating correctly

Hi Friends,

I am trying to import this .csv file into my module.

But I can't do so.

I think I need to create a Col ID.

 

My ques: will the newly created Col ID able to match data in another module with different ID?

 

I will brief my problem elaborately, in case you find any difficulty in understanding.

 

Sravan_Kumar_0-1587192293778.png

 

 

 

 

 

2 ACCEPTED SOLUTIONS

Accepted Solutions
Akhtar.shahbaz
Community Boss

Re: Importing is not updating correctly

Hi @Sravan_Kumar 

 

I have tried to create import action as per your import file

Template in csv format

Screenshot_299.png

 

2. Create a module with Product as a dimension and one line item Unit sold

Screenshot_300.png

If you want sales type then add as dimension

3. Create import action:

Screenshot_301.png

Make sure set the correct mapping for time period:

Screenshot_302.png

 

Output after running the action:

Screenshot_303.png

 

 

Hope this helps!

Thanks

Akhtar

View solution in original post

naushad786
Frequent Contributor

Re: Importing is not updating correctly

Hi @Sravan_Kumar ,

 

I think that you are not mapping TIME Dimension correctly in the mapping Tab. you have to choose Period  to M-Y  then it will import successfully.

 

Thanks,

Naushad

View solution in original post

6 REPLIES 6
Rashmih
Certified Master Anaplanner

Re: Importing is not updating correctly

Hi @Sravan_Kumar ,

 

Newly created Col ID will only be able to match data if you use the same dimension in the other module or you build some mapping mechanism such that newly created Col ID can match/lookup the dimension in another module.

 

Sravan_Kumar
Community Boss

Re: Importing is not updating correctly

Okay @Rashmih.

 

Please tell me, how will I import this file.

Rashmih
Certified Master Anaplanner

Re: Importing is not updating correctly

Hi @Sravan_Kumar ,

 

Do you have Products as a dimension? 

You can create a module with Product and Time as Dimension and Units Sold as line item (Format Number) and then import the data.

Akhtar.shahbaz
Community Boss

Re: Importing is not updating correctly

Hi @Sravan_Kumar 

 

I have tried to create import action as per your import file

Template in csv format

Screenshot_299.png

 

2. Create a module with Product as a dimension and one line item Unit sold

Screenshot_300.png

If you want sales type then add as dimension

3. Create import action:

Screenshot_301.png

Make sure set the correct mapping for time period:

Screenshot_302.png

 

Output after running the action:

Screenshot_303.png

 

 

Hope this helps!

Thanks

Akhtar

View solution in original post

Sravan_Kumar
Community Boss

Re: Importing is not updating correctly

Thanks @Rashmih & @naushad786

It worked correctly.

 

Thanks @Akhtar.shahbaz again for the detailed screenshots.

 

 

naushad786
Frequent Contributor

Re: Importing is not updating correctly

Hi @Sravan_Kumar ,

 

I think that you are not mapping TIME Dimension correctly in the mapping Tab. you have to choose Period  to M-Y  then it will import successfully.

 

Thanks,

Naushad

View solution in original post