Level 2, 1.3.10.1 Import Data into G1 Region List

Hi all,

I'm stuck with importing data from a saved view to the G1 region list and I don't understand where the error is coming from.

Region Flat:

Saved View (SYS05 Region Details, Build Regions)

Regions:

Import dialogue:

Error message:

So something's not working with the code/line item, but I don't get what it might be.

Can anyone give me a hint where the mistake is located?

Thanks,
Peter

Accepted answers

ankit_cheeni

Hi @PeterC

I might have understood what is wrong. So my understanding is that your saved view looks something like this:

If you use this saved view, the import definition would look something like this:

However, if you saved view looks something like this:

Then your import definition will show Line Items instead of the code column(because as you see, there is no code column).

Let me know if this is a possibility.

All comments

ankit_cheeni

Hi @PeterC

You're in the right direction. Your saved view is fine. You need to check your import definition - specifically what column are you mapping to the Code in the list. In your screenshots, it says Column 2: Line Items. I'd request you to check two things:

Check if you are picking the right saved view (as per your saved view, your column 2 should be code but your import definition says line items)
Reconfirm the import definition - If you are picking the right saved view, your code should match with code column on the view.

Let me know if this helps!

PeterC_*51361

hi @ankit_cheeni ,

thanks for helping out! It is definitely the correct saved view. I was also realizing that in the import, it says "Line Item" instead of "Code". But no matter what I do, it does not work.

Does this depend on how I pivot the Saved view?

ankit_cheeni

Hi @PeterC

I might have understood what is wrong. So my understanding is that your saved view looks something like this:

If you use this saved view, the import definition would look something like this:

However, if you saved view looks something like this:

Then your import definition will show Line Items instead of the code column(because as you see, there is no code column).

Let me know if this is a possibility.

PeterC_*51361

Hey @ankit_cheeni,

that did solve the problem, thank you so much for your help!

Quick Links

Can you help?

Unanswered questions

Batch Script
Hello team, I am logging into Anaplan through SSO. I would like to create a batch script to import a file into Anaplan. For the Spoke model, I would like to run an process via a batch script to import data from the Data Hub. Can anyone provide me script for both the condition.
import monthly data with months in columns
is there a way to import data with months in columns (usual excel table view)? I have to transform the data so there are rows to cover each period in the upload data form, but I am wondering if there is a better way to just import the data as is with the months in the columns. please let me know what you think. thank you,
Cloudworks Big Query Integration Fail
Hello, I am receiving an 'Anaplan Upload Failed' Status Description when testing my integration with a Big Query dataset. The integration imports data from BQ to our Anaplan model. No other details given in the error log. I suspect that Cloudworks is not even picking up the file but am not sure what we did wrong on the set…