Hello,
I am importing a CSV file created with Google Sheets into Wix CMS. While the import process completes successfully, the tag fields (e.g., “物件特徴タグ1”) are not recognized properly, and a yellow warning icon appears.
Problem Details
- The “物件特徴タグ1” column in the CSV file is formatted with comma-separated values.
- After importing, the tag field in the CMS displays a yellow warning icon.
- Clicking the warning icon and selecting “Convert to Tags” fixes the issue, but I would like to bypass this extra step.
What I’ve Tried
- Reformatted the CSV data by removing trailing commas and extra spaces.
- Deleted and recreated the tag field in Wix CMS.
- Used a different tag field for mapping during import.
- Saved the CSV file in UTF-8 format and re-imported it.
- Tested with a simple database containing only the tag field.
Despite trying these solutions, the issue persists.
I would greatly appreciate guidance on how to ensure the tags are recognized correctly during the import process without requiring manual conversion after import.
Thank you!
When you do the import you have to change the field for the tags to tags. it is automatically saving as a text field.
Dan, am I understanding correctly that you have to import the data into a new field every time if you want the Wix import Wizard to not import it as text?
In my case, I am trying to import addresses into an existing address field. When importing into the existing Address field, it does not give me an option to specify the field type, although the review stage shows the correct field type. (I am working in basic Wix rather than Studio, if that’s relevant.) In spite of this, upon import all of the addresses are showing an incorrect field type error, which, as for the OP, is easily corrected by clicking “Convert value to address”.
I will also note that the import wizard is correctly importing URLs, so long at they include “http://” or “https://” at the beginning of the string.
Is there really no way to make Wix convert the data to the field type of an existing field automatically?
@Nchrien have you exported the existing CMS to see how the address field is formatted ? ( I have never had to use the import of the address field)
When I export an address, it looks like this (aside from the light redaction of the exact address details):
“{”“subdivisions”“:[{”“code”“:”“CA”“,”“name”“:”“California”“,”“type”“:”“ADMINISTRATIVE_AREA_LEVEL_1"”},{““code””:““San Diego County””,““name””:““San Diego County””,““type””:““ADMINISTRATIVE_AREA_LEVEL_2"”},{”“code”“:”“San Diego”“,”“name”“:”“San Diego”“,”“type”“:”“ADMINISTRATIVE_AREA_LEVEL_3"”},{““code””:““College West””,““name””:““College West””,““type””:““ADMINISTRATIVE_AREA_LEVEL_4"”},{”“code”“:”“US”“,”“name”“:”“United States”“,”“type”“:”“COUNTRY”“}],”“city”“:”“San Diego”“,”“location”“:{”“latitude”“:32.XXXXXXX,”“longitude”“:-117.XXXXXXX},”“countryFullname”“:”“United States”“,”“streetAddress”“:{”“number”“:”“5XXX”“,”“name”“:”“Hardy Avenue”“,”“apt”“:”“”“,”“formattedAddressLine”“:”“5XXX Hardy Ave”“},”“formatted”“:”“5XXX Hardy Avenue, San Diego, CA, USA”“,”“country”“:”“US”“,”“postalCode”“:”“92115-XXXX”“,”“subdivision”“:”“CA”“}”
I am not going to try to encode all of that into a formula in my client’s Google Sheet. Just clicking the “convert value” button a few hundred times would be less harrowing, but it’s frustrating that the CSV import wizard is apparently so bare bones that it can’t just do that for me. Importing a bunch of mailing addresses is not exactly a complicated or exotic use case for a simple database setup.
Thank you very much.
I learned that when importing, tags in the CSV need to be enclosed in double quotes (") and the entire field needs to be wrapped in square brackets ([]).
I’ve reviewed the past posts, and I deeply appreciate your detailed and thoughtful advice.
Thank you so much again.
2 Likes
