Import CSV: numerical value to text

This topic contains 1 reply, has 2 voices, and was last updated by  Guust 6 years, 6 months ago.

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket

Tagged: , ,

  • Author
    Posts
  • April 12, 2018 at 9:42 pm #426321

    Cassie
    Free User
    Post count: 8

    Hello,

    I have a mammoth of a task ahead of me. I’m trying to work out a way in which this won’t take hours upon hours to do and I thought I would ask to see if this was possible…

    I have a database of over 300+ people to log into the GeoDirectory, I’ll be doing this via import CSV. One of the column will list what services each person does, this could be one thing or it could be 27 services for one person.

    Is it possible to assign a numerical value to each service, so that I can type in the number which then will convert to text on the website. (ie. 7 = Connective Tissue, 2 = Rehabilitation Massage, etc,.)

    Possible?

    Thank you

    April 12, 2018 at 10:06 pm #426329

    Guust
    Moderator
    Post count: 29970

    Sorry, but that is not possibel.

    One suggestion is to create a separate spreasdsheet which converts an entry like “7,2” to “Connective Tissue, Rehabilitation Massage)” by way of a formuala.
    You can then copy and paste the converted text into your upload CSV.

    Thanks

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)

We have moved to a support ticketing system and our forums are now closed.

Open Support Ticket
20% Discount Offer
Hurry! Get your 20% discount before it expires. Get 20% Discount