import data into module

Occasional Contributor

import data into module

HI,

I'm trying to import data(below 1) into module(below 2). And mapping are(below 3 4).

But result was below 5.

Please let me know if there is solution.

 

Best, Regards,

 

2.PNG1.PNG3.PNG4.PNGerror .PNG

Message 1 of 12
11 REPLIES 11
Certified Master Anaplanner

Re: import data into module

Hi @Takamasa ,

 

Try Custom pattern as shown below,

001.png

 

Regards,

Vignesh M

Message 2 of 12
Certified Master Anaplanner

Re: import data into module

HI @Takamasa,

The mapping looks good but i think the issue is because of the language for month names. Can you please change it to 'English' as your import file has month names in English? I hope this should work.

Let me know if you are still facing the issue!!

Regards,

Kavin.

Message 3 of 12
Highlighted
Occasional Contributor

Re: import data into module

I tried custom(DD-MMM-YY) and changed to ”English"。But error showed.......

aa.PNGaaa.PNG

Message 4 of 12
Certified Master Anaplanner

Re: import data into module

HI @Takamasa,

I meant in your previous approach!!

image.png

 

Message 5 of 12
Occasional Contributor

Re: import data into module

英語 means English in Japanese.

So I adjusted, but can't import...

Message 6 of 12
Certified Master Anaplanner

Re: import data into module

Hi,

Can you format your Date column in excel as shown below and try the import.

001.png

 

Regards,

Vignesh M

Message 7 of 12
Occasional Contributor

Re: import data into module

I got it by changing dd-mmm-yy in excel and format from date to text on module, and mapping from column header to fixed line item.

So I think my excel data was thought as text.

What should i do to change format to date?(I want to use this data as date because of function)

Message 8 of 12
Certified Master Anaplanner

Re: import data into module

Hi,

Don't change your line item format to text in module.

After you made format change in excel, have you tried to import? Line item keep it as Date format.
Are you still getting error?

Regards,
Vignesh M
Message 9 of 12
Occasional Contributor

Re: import data into module

I got it!

But i have one question.

On the source, when i selected column headers(previous photo), this resulted in error,.

But when i selected fixed line item(below), result in success.

There are difference between column header and  fixed line item?

 

Best regards.

bb.PNG

Message 10 of 12