Import CSV with PHP instead of Manually?

Tobias…

Getting an error in jquery.dataTables.js: Reference error: jQuery is not defined
—————————————————————–
(function( factory ) {
“use strict”;

// Define as an AMD module if possible
if ( typeof define === ‘function’ && define.amd )
{
define( [‘jquery’], factory );
}
/* Define using browser globals otherwise
* Prevent multiple instantiations if the script is loaded twice
*/
else if ( jQuery && !jQuery.fn.dataTable )
{
factory( jQuery );
}
}
——————————————————————
Maybe I have a bad download???

Thanks…

Hi rictans,

no, no bad download. Just the line

<script type="text/javascript" charset="utf-8" src="https://www.sohopoints.org/wp-includes/js/DataTables/media/js/jquery.dataTables.js"></script>

should be moved down, before the

jQuery(document).ready(function(){

part.
Also, you might want to put the DataTables JavaScript files into “wp-content” and not “wp-includes”, to be on the safe side when WordPress is updated.

Regards,
Tobias

Hi Bloggorus,

no, you don’t need to switch to a custom PHP/mySQL solution! TablePress is perfectly suited for your needs. Maintaining a table in Excel, and importing from the CSV file is no problem.
Please disregard rictans’s comment about this. (rictans: No offense meant here!)

Now, you are lucky about the auto import. I’m currently working on a TablePress Extension to add exactly this feature. I might have something ready at the beginning of next week. So, no need to try to do this with some PHP code!

Regards,
Tobias

Great!

Actually, using Excel docs rather than SQL databases is better in many situations, especially small businesses without tech support on hand 24/7.

We track all of your product prices through dynamic excel documents.

It’s easier to get staff members to modify excel speadsheets than SQL or PHP files ??

I was surprised there aren’t more solutions for what I wanted.

Automatic updating + a basic web shop shortcode system and you’re up and running with minimal complications, and you can hand it over to the most computer illiterate person with few worries.

Hi,

yes, that’s a good workflow for something like, if you don’t want or can’t use a full shop system.

The main code for the automatic import is ready, but I still want to add some user interface to it over the weekend, so that’s easier to use it.
I will post here again, once it’s ready.

Regards,
Tobias

“Please disregard rictans’s comment about this. (rictans: No offense meant here!)”

No worries… I was just rambling on at 3am in the morning, but still awake enough to put in a “disclaimer”.

Your latest suggestion worked, so I am now using the DataTables plugin for jQuery “natively”.

I am looking forward to your latest addition to TablePress: importing data by “auto import”:

“Now, you are lucky about the auto import. I’m currently working on a TablePress Extension to add exactly this feature. I might have something ready at the beginning of next week. So, no need to try to do this with some PHP code!”

How are you going to notify users when you are done? Release a new version?

Ric

Hi,

great to hear that manually loading DataTables works for your project ??

About the “Auto Import”: This will be released as a “TablePress Extension”, a new TablePress release is not necessary for this. I’ll (once I find the time) add an entry and a “How-To” at https://tablepress.org/extensions/ Meanwhile, it will be available in the TablePress GitHub repository at https://github.com/TobiasBg/TablePress-Extensions

Additionally, I’ll post into the thread where you found this extension, once the Extension is ready.

Best wishes,
Tobias

Subscribed! ??

I would like to populate my table rows by using your upcoming auto-import extension. More specifically, I would like to import some specific fields from a custom post, created using pods plugin.

Will it be possible ?

Please keep us informed of the development!

Hi,

thanks for your post! The Auto Import Extension is actually already available at https://tablepress.org/extensions/table-auto-import/ I guess, I forgot to post here ?? Sorry.

However, this will not be helpful for you, I’m afraid. Neither the Extension, nor the default manual import in TablePress can import fields from other plugins, like Pods. TablePress can only import tables from files in CSV, HTML, and JSON format, from different sources. Importing from other plugins or a database is not possible, sorry.

Regards,
Tobias