Import Fail - Invalid date or Timescale error

MarkTurkenburg_*8288 · May 2020

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

Harsha · May 2020

@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 · May 2020

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

Harsha · May 2020

@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 · May 2020

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

einas.ibrahim · May 2020

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 · May 2020

Thanks @Harsha

That makes sense, appreciate your help!

MarkTurkenburg_*8288 · May 2020

Thanks @jasonblinn

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

Mark

MarkTurkenburg_*8288 · May 2020

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 · May 2020

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