Data Import

Hi,

I need a clarity on data import through integration.

For the first time load the load was set and configured in the Integration process, but what if next time the data load comes in with a different delimiter or separators. Will the Integration load auto detects the load and adjust the import or will it give a error.

Thanks.

Accepted answers

All comments

SandeepB

@ShivankurSharma,

Once you save the import definition, Anaplan expects the file in the same format (delimiter or separator or column header or column number)

if it is a different format (delimiter or separator) it won't get loaded.

Thanks,

Sandeep

ShivankurSharma

@sandeep_bk thanks Sandeep. If during the initial creation of the action if we select all the separators and save the process even if the file is not using all the separators in the load. That will be saved in history, and even if next load is with different separator it will get loaded since that was already selected during the creation, correct?

SandeepB

@ShivankurSharma,

Yes, you are right. In fact, I have tried that too. It works when you select all the separators irrespective of your file.

But still, you don't have the control over column header. Make sure your file header remains the same including the position of the header.

Thanks,

Sandeep

ShivankurSharma

Yes, correct headers should remain intact. Even I can add separator in others after discussing with client if he foresee any separator that can be a part.

Thanks for checking.

Quick Links

Can you help?

Unanswered questions

Best way to Architect Financial Statements in Anaplan for Scalability
I have seen two methods used to build financial statements and I am wondering what others have experienced in scalability/maintenance between the two or if there is a better approach. Assume that we have a flat data source for our general ledger within Anaplan. Our line item we are focused on within the source data is the…
Curious Comparison: Forecast Modeling for Unusual Products
I've been experimenting with some forecast modeling techniques in Anaplan recently and decided to test them on a few quirky, offbeat product categories just for fun. One of the categories I played around with was love dolls—yes, you read that right. It actually turned out to be more interesting than expected. Unlike…
OData Rest API for
Hi, Does anyone know how to get an outbound OData Rest API, (OAuth2) to establish a connection between SAP and Anaplan. Thanks Khaled