Page 1 of 1

How can I create a calculated DB column?

Posted: Tue Aug 04, 2015 6:07 pm
by 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.


How can I create a calculated DB column?

Posted: Wed Aug 05, 2015 5:55 am
by Serhii Kulibaba

Hello Robert,

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


How can I create a calculated DB column?

Posted: Wed Aug 05, 2015 7:56 am
by RobertJay

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


How can I create a calculated DB column?

Posted: Wed Aug 05, 2015 2:49 pm
by 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


How can I create a calculated DB column?

Posted: Thu Aug 06, 2015 3:30 pm
by RobertJay

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


How can I create a calculated DB column?

Posted: Sun Aug 09, 2015 4:39 pm
by Serhii Kulibaba

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


How can I create a calculated DB column?

Posted: Wed Aug 12, 2015 8:32 pm
by 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/...