CSV Splitter

February 25, 2012   /   by Marco  / Categories :  Technology

In a previous post https://www.businesslegions.com/blog/2012/02/12/csv-import-for-jigoshop-wordpress-plugin/, I talked about using the CSV import tool for Jigoshop and how useful it was to import products into your store. I stumbled into a problem with Godaddy hosting, which prevents changing the hard limits on execution times. This means that after 2 minutes, the script times out. Now this sucks but there’s still a way to import all your products. The process is a bit more tedious but it will work. The only way of doing this is splitting the CSV file so that it imports only a set amount of records for each file (100 seems to have worked for me). You need to download a tool called FXFisherman’s CSV splitter.

Then you basically select the original file that you want to split and the number of lines (records) you want to include in each file. Max Pieces means the number of files it will output, setting it to 0 will mean unlimited. Once you’re done click Split Now! and then start importing each file.

 

DO YOU LIKE WHAT YOU'VE READ?
Join our subscription list and receive our content right in your mailbox. If you like to receive some Great deals our Freebies then subscribe now!

Our Sponsors

  • Follow us:

OTHER ARTICLES YOU MAY LIKE


REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

REVIEWING AND UNBOXING THE TOOCKI USB-C RIGHT ANGLE 1.2M CABLE

USB C cables are among the most ordinary accessories we own, yet they can make a surprisingly noticeable difference to how comfortable our devices are to use while charging. The Toocki USB C right angle cable is a good example of a simple accessory that tries to solve a very common irritation, because instead of […]

read more
SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

SUPABASE BACKUP TUTORIAL: USE DBEAVER TO EXPORT YOUR DATABASE SAFELY

If you are building anything serious on Supabase, whether that is a client portal, a SaaS app, an internal dashboard, or even a small side project that is starting to get traction, having a reliable database backup process is one of those tasks that quickly moves from optional to essential. Supabase makes a lot of […]

read more

Like our Page