Create lists with Code in text format

Hi,

I have list called "Employee" with code like "0000007". I need to import this employee details to my list. But when i convert my input file from excel to CSV, the code column getting convereted as number (like only '7').

Can someone help me to create the list with text formatted code.

Thanks,

Sangeetha

Accepted answers

All comments

PaulRitner

Hi,

losing the leading zeros is annoying with CSV's.

I'll typically place a single quote in front of the value (in excel) before saving as a CSV... '000007

Paul

Importing__27836.docx

gajends

Hi Paul, Thanks for the reply.

I tried this way adding single quote in front of the code & imported the same to Anaplan. The issue is single quote appearing in Anaplan as well. Is there any other way where i can upload the data without single quote.

Regardss

Sangeetha

Importing__27836.docx

PaulRitner

The key is to ensure the value is a text string (in excel) prior to saving. If the leading zeros are in the CSV file, they will get loaded into Anaplan correctly... try opening the CSV file with a text editor (I use Notepad++)... you should see the zeros in the text editor. You shouldn't see the single quote.

The single quote, for me, works every time, but I only use it if I have to. When opening the file in Excel (if you want to view it) open the file in a way that doesn't cause Excel to convert the column to numbers (and remove the leading zeros). For example, open the file using: Data > From CSV > Do Not Detect Data Type. There are other ways...

Importing__27836.docx

jerrywu

When you manipulate or open a .csv file the leading zero's get truncated. If you need to manipulate the data, you can perform a text import of the .csv file into excel and format the columns to preserve the leading zeros. I've attached some screenshots in a word document as an example. Hope this helps.

Importing__27836.docx

gajends

Thank you all for the replies.

I found the solution. I saved the .csv file as .csv.txt & then reopened the file in excel using text to columns options & changed the code format to text. I used this file for importing into Anaplan.

Cheers.

Sangeetha

Importing__27836.docx

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…