Send Imported Medhelper Data to the Database

[mikepsinn]

we need to figure out how to get data from these converters to the database
https://github.com/mikepsinn/QuantiModo-Converters/wiki/_pages

so we have converters and readers here
they need to send the measurements they read to the database through the API, I reckon.

https://github.com/mikepsinn/QuantiModo-Converters/wiki/Converter:-Medhelper

We import the medication measurements for those with the reader and converter. Those go into memory, I guess? We currently have the MedHelper one working.

So you can upload your file and it will display the data on the screen.

We need to send that data to the database via the API

[nwaresoftdev]

As i am thinking when user will upload file then this converter will convert file then we can use spreadsheet file and there will be spreadsheet reader that will read this file by api and will save in db .

[quintstoffers]

Look at the code in the repo you're commenting on. It's all implemented
except for the actual storing.
On Apr 1, 2014 10:13 PM, "nishant kumar" notifications@github.com wrote:

As i am thinking when user will upload file then this converter will
convert file in spreadsheet format then there will be spreadsheet reader
that will read this file by api and will save in db .

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39252797
.

[nwaresoftdev]

yeah i am talking about storing. we use this spreadsheed and then spreadsheet reader will read this file and store in db . i have done code for reading spreadsheet file and get this data in array .

[quintstoffers]

Again, it's already implemented.
On Apr 1, 2014 10:18 PM, "nishant kumar" notifications@github.com wrote:

yeah i am talking about storing. we use this spreadsheed and then
spreadsheet reader will read this file and store in db . i have done code
for reading spreadsheet file and get this data in array .

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39253334
.

[mikepsinn]

Nishant made a spreadsheet converter. I asked him to explain how he would create a button in a WordPress page and facilitate getting the data in the database.

Then I asked him to explain the process here and ask any questions he had.

[quintstoffers]

Is the reader fully implemented? What file formats does it support, and
does it properly handle a situation where it can't read the spreadsheet (eg
it isn't a spreadsheet)? That'll have to go into it's own issue.

The button in WordPress isn't an issue, very simple.

The data has to be stored through a class that extends the Storage class.
TesterStorage.php, and QuantimodoStorage.php in the connector repo are both
good resources.

Keep in mind that this script is run on demand, so don't load all
variables, units and sources on startup like we do in the converters.
On Apr 1, 2014 10:22 PM, "Mike P. Sinn" notifications@github.com wrote:

Nishant made a spreadsheet converter. I asked him to explain how he would
create a button in a WordPress page and facilitate getting the data in the
database.

Then I asked him to explain the process here and ask any questions he had.

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39253731
.

[nwaresoftdev]

it will support .xls format and yes, it'll handle that situation when it cant read the spreadsheet.

[quintstoffers]

If it's just XLS you'll want to name it XlsReader. Do you use an external
library?
On Apr 1, 2014 10:34 PM, "nishant kumar" notifications@github.com wrote:

it will support .xls format and yes, it'll handle that situation when it
cant read the spreadsheet.

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39255092
.

[nwaresoftdev]

yes

[quintstoffers]

Make sure to import it through Composer if possible.
On Apr 1, 2014 10:35 PM, "nishant kumar" notifications@github.com wrote:

yeah

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39255275
.

[mikepsinn]

Will we need to use rabbitMQ with this for any reason?

[quintstoffers]

Not really, it's impractical to send the files, and unnecessary to send the
measurements.
On Apr 1, 2014 10:58 PM, "Mike P. Sinn" notifications@github.com wrote:

Will we need to use rabbitMQ with this for any reason?

Reply to this email directly or view it on GitHubhttps://github.com//issues/2#issuecomment-39258022
.

[nwaresoftdev]

Will you please guide me how can i setup this module with project ? Becuse i couldn't find any way to work with wordpress and connectors . i need to test .

[mikepsinn]

Can you get measurements from your local database using your local API?