Import Fail - Invalid date or Timescale error

Hi Team,

I have a line item where the data is Imported from another module in the model

I have also created another line item in the same module which is set to No Data that I Import to the line item mentioned above to clear it before running the previously mentioned import action.

I have these 2 Actions in a process (1st is the CLEAR Action and 2nd is the standard import of values Action)

The Clear Import action is failing (as stated in the Action Report - see below for Screenshot) but it does work and clears all the values. The Process does not run the 2nd Action which I assume is because the 1st Action has "Failed"

I'm struggling to understand how the import could be failing as it is from 1 line item to another in the same module and hence there should be very room for error...

Any ideas on why this is 'Failing'?

Mark

Accepted answers

Harsha

@MarkTurkenburg

In the mapping instead of selecting fixed line item from drop down, select line item columns. After that in "Cash Balance - Rec item line items" map line items manually.

Reconciliation item - Blank -> Reconciliation item - Download

Ignore other line items.

Thanks,

Harsha

jasonblinn

In your error message you can see that there were 8 failures because there was an "Invalid date or Timescale". In your mapping, you can see that you have Time set to the column headers and then you have Versions and line items set to fixed, Becasue of this, it is seeing it as a Time Period, and giving an error because there is no time period named Version or Line item. There were 8 failures in your message, 4 from versions and 4 from line items.

As @Harsha mentioned, you can map the columns via the import. I would also recommend making sure that your saved view is set up to only show the line items and versions that you have selected in the import, and then when you select the columns to use in the import they should map automatically.

Jason

All comments

Harsha

@MarkTurkenburg

From the SS I could say that there is mapping issue.

Could you please share SS for mapping of action and blue print of two modules?

Thanks,

Harsha

MarkTurkenburg_*8288

Hi @Harsha

Below is the mapping and the Module Blueprint (Both the source and target are in the same module). What I really don't understand is that the Action works - but I receive the failure notification

Thanks

Mark

Harsha

@MarkTurkenburg

In the mapping instead of selecting fixed line item from drop down, select line item columns. After that in "Cash Balance - Rec item line items" map line items manually.

Reconciliation item - Blank -> Reconciliation item - Download

Ignore other line items.

Thanks,

Harsha

jasonblinn

Jason

einas.ibrahim

Hi @MarkTurkenburg

I am curious about something. Are you saying you are attempting to import into a Target line item (Format Number) from the Source line item (Format No Data)?

Source (No Data) ==> Target (Number).

Did I understand you right?

MarkTurkenburg_*8288

Thanks @Harsha

That makes sense, appreciate your help!

MarkTurkenburg_*8288

Thanks @jasonblinn

That is a great explanation as to why it wasn't working - I get it now!

Mark

MarkTurkenburg_*8288

Hi @einas.ibrahim

Yes I use a No Data Format line item when clearing out a Number line item. Rather than a Line Item set to 0

It just saves some space

Thanks

MarkTurkenburg_*8288

Hi @jasonblinn

I'm just recreating the error in a test model but I cannot get the Import to Fail like I did in my example above. When I run a process with an Action that has the same issue as above it will fail on lines items but it will not fail the entire import like above & hence will run the 2nd Action in the process

Any idea why the entire Action above failed rather than those specific items?

Thanks!

Mark

jasonblinn

@MarkTurkenburg

It is hard to say without seeing the details of the failure for the import that originally failed vs the new one that is completing with failures.

Originally it might have had another error that was fixed with the re-mapping as well. But to be honest, I am not sure!

Jason

rob_marshall

@MarkTurkenburg ,

By chance are you using the same view for different actions within the process?

MarkTurkenburg_*8288

Hi @rob_marshall

No I was using 2 saved views to run the 2 Actions

Thanks

Mark

MarkTurkenburg_*8288

Thanks @jasonblinn

I'll keep an eye out in the future for any Action Failures and try and determine the root cause!

Mark

Quick Links

Can you help?

Unanswered questions

How to create identical child items for multiple parents
The data I'm trying to import is as follows Parent-Code A B A C B D C D D E I want to generate the following list from this data: L1 L2 L3 L4 A A-B A-B-D A-B-D-E A A-C A-C-D A-C-D-E You can create up to L3.However, L4 has multiple parents for one row of data When I try to create L4 from D-E, only one list row is generated…
Predefaulting A Feild in ANAPLAN
Hello Anaplan Community, I have a special requirement from a customer and would appreciate your input. Let me explain the situation: We have a hierarchy with three levels: Level 1, Level 2, and Level 3. Screen 1: Creation of Level 1 Items On this screen, the user selects a team. Based on their selection, an action runs to…
Looking for Anaplan End-Users to take a short survey!
We are looking for Anaplan end-users to provide feedback on their experiences with the Excel add-in. Interested individuals will respond to this 5-minute survey to help us understand personal needs and behavior when using the add-in. The feedback provided by survey takers is essential to the roadmap of Anaplan's products.…