kmfabercreative
Member
Hi there,
So we have a table / list with 20 elements associated with it. The client needs to import a CSV (they do not have experience with / access to MySQL) to populate the data. This needs to happen ~1 time per month.
Problem is that the CSV file has 40 columns (2*fields due to including raw format), and ~64,000 rows. Huge.
We're testing things out to see what a minimum size for the CSV should be, but do you have any suggestions, without having to break up the file into 100 different files, for how to go about getting this imported?
I think initially we're going to want to just do a db import ourselves, but this isn't something that can be sustained.
Any thoughts are appreciated
Thanks much!
Cheers
Kyle
So we have a table / list with 20 elements associated with it. The client needs to import a CSV (they do not have experience with / access to MySQL) to populate the data. This needs to happen ~1 time per month.
Problem is that the CSV file has 40 columns (2*fields due to including raw format), and ~64,000 rows. Huge.
We're testing things out to see what a minimum size for the CSV should be, but do you have any suggestions, without having to break up the file into 100 different files, for how to go about getting this imported?
I think initially we're going to want to just do a db import ourselves, but this isn't something that can be sustained.
Any thoughts are appreciated
Thanks much!
Cheers
Kyle