ECI: Create Multifile Project
Easy CSV Importer is currently the only plugin with this feature. It is very new but works great. If you have multiple CSV files that you want to import for one project then this is the tool to use.
Key Information
- Currently your CSV file data in each file must be in the same order i.e. a database simply exported into separate files with no changes made since. This is due to the method of pairing the files together being simply by the order of records/rows. Eventually I hope to provide the option of doing it using an ID column. If your records are in different orders within each of your CSV files but you have have ID column that can be used to tie the data together then you will need this ability to be added. Please comment below and request this.
- This is a very new feature. Some of the plugins abilities are restricted when using this feature i.e. automatic data updating, staggered import. This is due to the complexity of data integration and really we should encourage a full speed import.
- You must ensure you have imported all of your data or an equal number of rows per file before creating post. Consider the effect if data for a single CSV file has not been imported and the record is used to create a post. It is the user responsibility to get this right. I will not code anything that warns or monitors data integrity for a long time to come.
Features
Select Data Match-up Method
Right now you can only use By Order which assumes each row in all of your CSV files is part of the same record i.e. row 5 in one file is part of the data for row 5 in another file.
Overall Effects
The plugin will create a project database table that includes all of your CSV file columns. The plugin will then allow you to import your data at full speed, one file at a time.
