Tools that help you to get data information or fix data before import.

This tool helps to find invalid email addresses and skip them in the .csv file. After running this tool will be created two .csv files:

• the first will contain the list of correct records.
• the second will contain the list of invalid records.

php command.php data-tool skipInvalidEmails --src="data/contacts.csv" --dest="data/valid.csv" --invalidDest="data/invalid.csv" --cells="Email Address, Work Email" --delimiter=","

• src: Input .csv file, e.g. "data/src.csv".
• dest: Valid list saved to .csv file, e.g. "data/valid.csv".
• invalidDest: Invalid list saved to .csv file, e.g. "data/invalid.csv".
• delimiter: Delimiter of your .csv file.
• cells: List of cells which data should be fixed, e.g. "Email Address, Work Email".

This tool help to fix data when one cell contains multiple data.

php command.php data-tool fixCellData --src="data/contacts.csv" --dest="data/converted.csv" --cells="Work Email, Mobile Phone" --delimiter=";" --delimiterInsideCell=","

• src: Input .csv file, e.g. "data/src.csv".
• dest: Output .csv file, e.g. "data/dest.csv".
• delimiter: Delimiter of your .csv file.
• delimiterInsideCell: Delimiter inside a cell, e.g. "," for the data "[email protected], [email protected]".
• cells: List of cells which data should be fixed, e.g. "Phone Number, Work Email".

In case of deleting a field from Administration > Entity Manager, the field still exists in the database.

php command.php data-tool deletedColumns

• dest: Output .csv file, e.g. --dest="data/list.csv".
• delimiter: Delimiter of generated .csv file, e.g. --delimiter=",".
• entityTypes: List of checked entities, e.g. --entityTypes="Account, Contact".

Change a license in LICENSE file. The current license is intended for scripts of this repository.