What are Multi Files?

A (multi) file is when a dealer or vendor includes data for multiple stores in 1 file.  The file MUST contain a Dealership Name column with the following rules:

• The Dealership Name column must be populated on all data rows.  It cannot be left blank or the file will get stuck due to an error.
• The Dealership Name column must have unique values for each dealership.
•  The values must not be generic values such as 1, 2, 3.  They must be unique values such as the store name, or an ID number consisting of 4 or more digits.

Mapping a (multi) file needs to be done for:

• Multi files loaded through Dropbox Insyncing Data Drop folders.
  • This may include files received in the SFTP that get transferred to Dropbox Insyncing Data Drop by a DAG (example: Tekion Sales)
• Leads files pulled by Wall-E/the scraper.  See Data Integration: Scraper Method for information on how to obtain the property aliases from each vendor system.

Process for Mapping Multi Files

1. Insert rows into the claripedia -> tables -> property_aliases table
   1. property_alias = the name of the property in the Multi file *property column - ALL lowercase, no punctuations or spaces EXCEPT DO include #
   2. property_id = Clarivoy property ID
2. Remember to commit changes!