File format for Data Load input files
When you are creating your CSV or XML file, ensure that you follow the tips and recommendations for CSV and XML files that are included in Data Load utility best practices.
If you must load UserData into existing HCL Commerce database tables that are
extended, add your UserData into a default provided sample or example input file. To load a file
with UserData, you can use the provided TableObjectBuilder and TableObjectMediator to load the file
with UserData into the correct table and columns. If you customize Management Center or generate SDO
extensions to use this UserData, you must first map the custom data to a logic noun
UserData
field. Then, you can load your input file with UserData.
If you are loading custom data into a custom table, you can use the TableObjectBuilder and TableObjectMediator to load your file when you run the Data Load utility. You can also create your own custom column handlers or custom mediators.
Sample input files
You can also use the CSV or XML input files that include keywords for use with the Catalog Upload feature in Management Center to help you create your own input files. You do not need to remove the keywords. For more information, see File format for uploading catalog data.