ghazale

Hi @ksieluzycki

Thanks for the post! Regarding your question, if you mean deleting the entries on front-end side, then unfortunately it’s not part of the plugin features at this moment. However on backend side everything is manageable (deleting or editing).
If there is anything I can help you with, let me know and I try my best to guide you or help you with that ??

Cheers,
Ghazale

Hi Martin,

This is the first report of incompatibility. I cannot reproduce this problem on my end but I’d investigate more about it to find out what could have possibly gone wrong.

Thank you so much for reporting it. I’d definitely take a look at it as soon as possible:)

Cheers;
Ghazale

Hi!

The plugin automatically searches through all the tables that you have provided in the backend. The shortcode [sds-search] is meant to search through all tables.
And if you activate the separated search in the backend, then it only searches the table that you explicitly specified in its shortcode attribute.

For more information please refer to the documentation that is provided in the “Welcome” page of the plugin.

Cheers;
Ghazale

Hi Sanket

Thank you so much for your suggestion. Yes of course it would be really nice to have it; but that would need some extra features that I would consider to add in the next versions.
It’s not just a small script that you could add and make it work. It would need some customized script that could be able to seamlessly integrate with the current architecture of the plugin. I’d definitely take that into consideration for further improvements of the next release ??

Cheers;
Ghazale

You’re most welcome:)
For that purpose you should consult your IT guy to communicate with the respective governmental entity.

As for dropdown, yes it can be easily modified to accommodate as much as name you want however as I understood, you want the result to be shown based on school name. And it happens when the school name is changed from the dropdown. So basically the “Search Field” becomes irrelevant for your user interface. And this requires much more than a small modification. It requires very extensive modifications to the current plugin. So you may want to look into much more customized plugin solutions which can accommodate all your unique needs. I don’t think you can find something on the opensource plugins repository that completely suit your needs.

Hi @random1234

Please excuse me for my late response as I was out of town for some time.
Yes, with a bit of change in the code you can achieve the look you want.
I’m actually too busy to make that sort of small changes for every individual user with different needs. But if you’re a bit familiar with coding, I’m sure you can make this sort of changes on your own:)

If there’s anything else that I can help you with, feel free to let me know ??

Cheers;
Ghazale

Hi @discgosforth

Well, some modifications in the code is going to be needed to be able to achieve the exact thing you want.
At the current and default state of the plugin, this sort of functionality is not possible.

If there’s anything else that I can help you with, feel free to express yourself:)

Cheers;
Ghazale

Hi @ronniegregorym

Please excuse me for my late response as I was too busy.
As for your first question, I personally haven’t tried it on Multisite mode. So I’m not sure if the database can be accessed from a different sub-site.

As for your second question, yes of course it can be modified, however to get that sort of information you might need special permissions and credentials to access that database. The default state of the plugin is such that it can only access its own related tables in the database.

Cheers;
Ghazale

Hi @ptj254

Yes of course it is possible, however you should tweak the code a bit.
I’m really busy to do this sort of customization right now but I’ll do my best to make in optional in the future versions.

Cheers;
Ghazale

Hi @vbptrin

That functionality that you look for requires customization or even developing a new plugin that exactly fits your needs.
However you can take a look at the Pro version of this plugin here.
In the pro version, the user has the chance to put their needs in a customized form that you provide for them in the last step.
I personally don’t know any plugin which exactly fits all your needs. So if the pro version also doesn’t work for you, then you should look for a customized version of such a plugin.

Cheers;

hi @ranggagas

Of course it is possible:)
I have developed a separate version of this plugin in which you can edit the entries on front-end seamlessly.

You can have that version if you kindly make a donation and directly email me the receipt that you automatically receive after donation. You may also already know that your donation will go for protecting helpless animals. So it’s highly appreciated!

So let me know if you’re interested!

Cheers;
Ghazale

Hi @targhan,

You can simply make the search engine to return the “exact match” only. This is easily achievable. Just follow below instructions:

1. Go to your plugins list on your admin dashboard find the Custom Searchable Data Entry System plugin and click on the “Edit” link.
2. On the page that opens, make sure you’re viewing custom-searchable-data-entry-system/sds-main.php (active)
3. Find the place where it looks like below (there are 2 occasions: line 1441 and line 1527 – do the following changes on both occasions)
4. $results_sql = "SELECT id,field_id,field_input FROM " . $table . " WHERE field_input COLLATE UTF8_GENERAL_CI LIKE '" . $_POST['sds-search-data'] . "%' ORDER BY id ASC";
5. Remove the percentage sign after $_POST. So it should look like below
6. $results_sql = "SELECT id,field_id,field_input FROM " . $table . " WHERE field_input COLLATE UTF8_GENERAL_CI LIKE '" . $_POST['sds-search-data'] . "' ORDER BY id ASC";
7. Don’t forget that you should do this on 2 places: on line 1439 and on line 1525
8. Click on “Update File” and you’re done.
9. You may need to reactivate the plugin after updating the file.

That’s it!

If there’s anything else that I can help you with, you’re always welcome to get in touch:)

Cheers;

Hi @laderiva,

Thank you for getting in touch:)
I will definitely add the ability to reorder the fields in the next version. However at its current state, you can just “Edit” the fields one after another to achieve the order you want. (taking into consideration that you already have input or not, as it affects the input columns’ names as well)

If the search functionality of this plugin is not important to you and you only want to make and present the forms on front end and get the data on back end, then you can also take a look at Data Storage plugin.

If there’s anything else that I can help you with, feel free to contact me:)

Cheers;

already responded.
marked as resolved.

Hi @ jcmiz

When you upload a CSV file, the plugin automatically generates a new table with a random number (like you mentioned in your post). This is to avoid duplicated table names in the database and a to avoid a disaster that might be caused by it.

After you uploaded your CSV file, if you see just one row with no entry, it means that your server is a bit over protected and it doesn’t allow some mysql statements including “LOAD DATA LOCAL INFILE…”. It is just related to your server and not the plugin, thus unfortunately it is out of my control.

As for your second question, when you make your file as “CSV”, the commas are being generated automatically, meaning that each cell is separated by a comma from the cell next to it. (this comma is being generated automatically when you save your file as CSV to differentiate the cells and to realize where the cell starts and where it ends – you can see it if you open your csv file with another program like noptepad if you use windows). If you use a comma (,) in the data that you put in the cells, when the code reads the CSV file and it faces that comma, it thinks that it’s the end of the cell and it should skip to the next cell or row; and consequently it will result in a messed up table. This is the reason why extra commas in the data can be problematic.I’m planning to improve the code in the next versions to tackle this sort of situations, so it works regardless of where the comma is.

I hope my explanations have been enough, nonetheless if you ever needed more explanation or help, you’re always welcome to come back to me:)

Cheers;
Ghazale