Logo Walcu Library - CRM for auto dealerships

Categories

Data provider: CSV files

Create your data provider with data from a CSV file

Add this application to create a data provider with data from a CSV file.

Configuration:

1. Access and duplicate the following 3 CSV files.

Modify CSV files

a) Version file:

In this file you will define the details of the vehicle like make, model, transmission…

To add more fields: In a new column, add the field name from the Walcu database. To add custom fields, add “custom.fieldname”.

IMPORTANT: The “id” field must have a different number for each vehicle. This “id” is used in the other files to synchronize the equipment and images.

b) Equipment file:

In this file you will define the equipment of your vehicles.

IMPORTANT: To synchronize an equipment to a vehicle, in the “version_id” column you must put the same “id” as in the “Version file” CSV.

c) Images file:

In this file you will define the images of your vehicles. The links must be direct links to images.

IMPORTANT: To synchronize the images to a vehicle, in the “version_id” column you must put the same “id” as in the CSV “Version file”.

3. Make your CSV files public and copy the links.

If you have your files in Google Drive:
– From the document -> File – Share – Share with others.
– Change the “General access” from “Restricted” to “Anyone with the link” (“Reader” permission).
– Copy the link with the “Copy link” button.

If you have it in a local file:
– Upload it to Google Drive
– Right-click on the document
– From there, click “Share” and then “Share”.
– Change the “General Access” from “Restricted” to “Anyone with the link” (“Reader” permission).
– Copy the link with the “Copy link” button.

4. Add the WAPP to your Walcu Account

Add the WAPP to your Walcu account by clicking the “Add” button at the top of the page.

5. Add links to CSV files

Add the URLs of the different CSV files to the WAPP in Walcu.

6. Select the attributes to display

Add from the “attributes” selector the attributes you want to display in your account.