How can I create a calculated DB column?

[RobertJay]

I need a numeric DB column called "Location" in the form of e.g.: [48.143,11.574]. As I understand from a prior post, Appery does not support direct developer use of the Mongo Shell, and I don't believe I can import a CSV file with a column like that. Is there a cURL command that Appery will accept or some JS that will do that? Thanks.

[Serhii Kulibaba]

Hello Robert,

Appery.io supports data like that. It is "array" data type. You are free to use it in your application.

[RobertJay]

Thanks Sergiy. Both elements exist now as separate columns - what is the best way to create the new column?

[RobertJay]

Sergiy, I'm able to export from Excel this csv file...

http://screencast.com/t/Bs5NyZ1FKieV

... which gets imported into Appery as this collection...

http://screencast.com/t/EuZCZd0fR

I need the location column to be numeric, and I know there's a way of doing it either in Appery or in the csv file - but I forget how and can't find any instruction. How can that be done?

By the way, if I remove the commas from the csv file, I get this error...
http://screencast.com/t/FOUuLnt7

[RobertJay]

UPDATE: I found this https://getsatisfaction.com/apperyio/... and have asked Evgene to help me implement his solution.

[Serhii Kulibaba]

Robert, you should set column's data type = number, as it is described here: https://getsatisfaction.com/apperyio/...

[RobertJay]

UPDATE: Thanks for the information - it looks like exactly what I need. However, I'm not able to import the csv file, and have started a new thread at:

https://getsatisfaction.com/apperyio/...