How is the data stored?

Hi,

Thanks for contacting us here about this extension.

I'm a curious about how the data from sheets/tables are stored. For my application I'd like the ability to query the data collected from the sheets tables/later in mysql. Is the data stored in a manner that will allow for this?

Yes, the data will be stored in the table with the prefix droptables_ so you can query data in mysql.
However, be careful with the query, it could damage your database.

Thanks a lot!
Cheers,

Thanks! But it seems all of the data for an entire sheet ends up in one field in the database, can that be right? The data for the entire sheet is in the "datas" column/field of "droptables_tables" table? Is that right?

IS that the best way to layout the data? What is the approximate max number of records a sheet can handle?

Thanks!

Hi,

Thanks for getting back to me with more information.

But it seems all of the data for an entire sheet ends up in one field in the database, can that be right? The data for the entire sheet is in the "datas" column/field of "droptables_tables" table? Is that right?

IS that the best way to layout the data? What is the approximate max number of records a sheet can handle?

Yes, all data is stored at datas columns. Our droptables could handle approximate 10k cells.
I'm not sure about the technical issues, if you confuse something, please drop us a ticket (menu Support > Ticket support).
Our developer in charge will take a look at that.

Thanks a lot!
Regards,

Hmm… that might push me over towards going another way. I’m curious if a refund is possible?


Thanks!

Jason Formicola

Training Director



The Kamson Corporation

270 Sylvan Ave.

Englewood Cliffs, NJ 07632

Phone: (201) 871-1055

[email]This email address is being protected from spambots. You need JavaScript enabled to view it.[/email]

From: JoomUnited <This email address is being protected from spambots. You need JavaScript enabled to view it.>

Sent: Thursday, December 5, 2019 9:30 PM

To: Jason Formicola, M/O Kamson <This email address is being protected from spambots. You need JavaScript enabled to view it.>

Subject: [#13135]: How is the data stored? (Reply)


New Reply Added


Assistance replied to the discussion
How is the data stored?


Hello,

This is a notification to let you know that Assistance has replied to the discussion on the site. You may find the snippet of the reply below:


Hi,


Thanks for getting back to me with more information.


But it seems all of the data for an entire sheet ends up in one field in the database, can that be right? The data for the entire sheet is in the "datas" column/field of "droptables_tables" table? Is that right?


IS that the best way to layout the data? What is the approximate max number of records a sheet can handle?


Yes, all data is stored at datas columns. Our droptables could handle approximate 10k cells.

I'm not sure about the technical issues, if you confuse something, please drop us a ticket (menu Support > Ticket support).


Our developer in charge will take a look at that.


Thanks a lot!

Regards,


Read
this discussion


This email was sent to you, because you have subscribed to the discussion.

To unsubscribe, please
click here.
Manage subscriptions.

Hi,

Thanks for your response.

that might push me over towards going another way. I’m curious if a refund is possible?

I'm not sure what the issues do you encounter? Please drop us a ticket support, our dev may help you with that.

For the refund, please check here: https://www.joomunited.com/refund-policy

Cheers,