CSV SplitterFebruary 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.
Limit to 5 sponsors.
OTHER ARTICLES YOU MAY LIKE
Online education has quickly become a widespread tool for any student around the world. It’s convenient, affordable, and allows for greater access to education for those who don’t have the opportunity to attend the courses at a physical location. Online courses are also a great way to supplement traditional education, allowing students to experience more […]read more
If you’re an entrepreneur, business owner or simply someone who manages a website, you need to make sure your website is constantly backed up. I use to just write bash scripts on my VPS server to backup the website to an external NAS drive and sometimes the backup process would fail or the storage space […]read more