0

Importing addresses into the location field in a Ninox table

We are trying to import a csv file with the list of our members and their addresses into our new Ninox database.
But unfortunately we cannot import the address into the location field in Ninox. The address field always stays blank.

How can we import addresses into the Ninox address field?

 

1 reply

null
    • Mel_Charles
    • 2 yrs ago
    • Reported - view

    You don't say how you are doing this

    You shoule be able to simply match the csv name to the ninox name on the import table.

    Are you trying to import multiple fields (ie address1 + address2 etc) in your csv file into one single field in Ninox (Location) ?

    if so then what i did was load the csv file into Excel etc and added an extra field (ie MainAddress) then concatenated the seperate address fields into that new field (with a char(10) to give a line feed ant thend of each line fro display purposes). The resaved the csv and then matched Nixox 'Location" to csv 'MainAddress'

    there are opther options - ie add evary line into Ninox (on a tab page out of th way - do the import then have one master formula field on main form to read each seperate field!)

    or as above then add a text filed tfor main address and a button to fire the date from the seperate fileds into that one field - the delete the sperate fields afterwards

Content aside

  • 2 yrs agoLast active
  • 1Replies
  • 327Views