Level 2: Activity 1.3.4 Update System Modules

In order to get the SYS05 Country Details module to populate properly to load I had to use the Region codes (AMER, EMEA, APAC) in the Region Flat file, but when I I try to load the SYS07 Location Details module it is looking for the region names to be spelled out (Americas, etc.).

TIA

snip1_90744.JPG

snip2_90744.JPG

Accepted answers

kevin.cho

I just went back into the lesson content just to double check.

You're importing into a module dimensioned by the list "Location Flat". Each item in this list should correspond to an item in the "Locations.csv" source file in lesson 1.3.3.3, with codes ranging from G001 (New York) to H001 (Head Office).

If this is not correct, you'll need to review that first.

Your Locations.csv import into the SYS07 module should then match 1-1 - it's the exact same data source used to populate the list.

aashikbharath

Hi @kevin.cho,

Thanks for the help. I was able to solve it now.

All comments

kevin.cho

Take a look at the columns available in your data source, and the list members that have been created in the Locations list. Which column in your data source matches a property in the Locations list?

aashikbharath

Hi @kevin.cho,

Thanks for your reply. Actually, the columns in my current .csv file doesnt have any matches to the target. The target has only codes of the country and region. But my source has the country and region name which causes a mismatch. Hope you understood my question.

Thanks,

kevin.cho

I just went back into the lesson content just to double check.

If this is not correct, you'll need to review that first.

Your Locations.csv import into the SYS07 module should then match 1-1 - it's the exact same data source used to populate the list.

aashikbharath

Hi @kevin.cho,

Thanks for the help. I was able to solve it now.

kevin.cho

No worries - I tend to find that these training courses are very good and in-depth in the content they cover, but they require following the instructions very very closely. If you ever tend to run into issues (and the lesson content doesn't expect you to, or ask you to debug the issues), try go back a couple of steps and re-do them.

Good luck!

Quick Links

Can you help?

Unanswered questions

Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…
Automating Flat File Uploads to Anaplan Data Orchestrator (ADO) – Best Practices and Methods
Hello Anaplan Community, I am seeking guidance on the most effective ways to automatically upload flat files to Anaplan Data Orchestrator (ADO). Currently, our process involves loading flat files to an Anaplan Datahub using Anaplan APIs and custom Python scripting. With Anaplan Data Orchestrator's capabilities for data…
OAUTH 2.0 vs Google Sheets Extension
Hi, My org is looking to explore leveraging Google Apps script to extract data out of Anaplan and update already built templates in Google Sheets. We use the Anaplan Extension currently but find it crashes often with the amount of tabs, data, etc. Has anyone used both Anaplan OAUTH 2.0 API and Goolge Apps Script to write…