SAVE TIME by matching columns in a CSV import file to existing Custom Field Names (and the secret to emojis)

This is a tale of where @Bastien_Siebman’s beloved ideograms traded in their playful ways to punish the innocent! :laughing:

I’m sharing this tip because it got the best of me and required a bit of cleanup to undue the emoji mischief. The moral of this story is: If you are an avid user of the Asana CSV Importer, be sure that when adding emojis to the name of a Custom Field you UPDATE YOUR IMPORT TEMPLATE!

Personally, I like to make sure that the names of the columns in my CSV import file match the names of existing Custom Fields within the Project I am importing data to. For one, Asana does a great job of making sure the data is mapped to the correct field when doing so. This allows me to “Go to project” and not have to “Make Changes” (as seen below) allowing for the import process to begin right away. This can be quite rewarding when you repeatedly import project information using a standard file template.

image

In instances where the preview doesn’t seem correct and changes need to be made, having matching column names makes it easier for users to pinpoint any issues and correct accordingly.

Recently, I decided that I wanted to add an emoji to the beginning of two distinct Custom Fields to help differentiate between them. One represents a Box Link (web address) where the other is a Box Path (Windows File Path). Well… because I added an emoji to each, Asana didn’t associate the columns with these recently modified Custom Fields. Because changes were not made, new non-global Custom Fields were added to this Project (as seen below)

image

So now what? Emojis are so fun though! Have no fear. Simply copy the emoji into your CSV import template and Asana will get back to associating the columns that match existing Custom Field names (as seen below)

image

I know this is a minor detail, but perhaps one worth creating some awareness around. Especially for those that rely heavily on the CSV importer, like me. It is easy to get complacent when you doing something often enough that you have built a blind confidence to the process. Pay attention to the details and audit your processes on occasion to intercept long-term damages that tweaks like this could cause.

Asana on, my friends! :slight_smile:

6 Likes

That is the conclusion of the post right? :grimacing:

image

Hi Jerod
thanks for your hints. I haven’t thought about using emoji’s yet but will do so.
What drives me nuts though when using imports is that I can’t get the tasks assigned to the correction column/ section. The import either adds them all to the first column or creates new columns - how did you bypass this issue? I have been in touch with Asana support many times and applied all their advise but it just doesn’t work.

@anon33409932 happy to take a look at a sample. If you want to PM me with a file and brief description of what isn’t happening I can offer some suggestions.

1 Like

@Bastien_Siebman @LEGGO @Marquis_Murray - Does Asana allow you to import the Projects field so you can link your imported Tasks to other Projects to Multi-Home?
Also has anyone handled Field Values for a Single Select or Multi-Select where the field value has a comma in it? I am hoping there is a simple was to handle this versus having to convert each comma to an ascii character etc?

Hi,

I don’t know sorry…