Problem/Motivation

When importing a xml file with a field that contains ampersand & in the This & that. It causes the module to error with "no data in file"

Steps to reproduce

Importing CA high schools with some names containing an "&".

Proposed resolution

A escape for special characters.

Remaining tasks

User interface changes

API changes

Data model changes

CommentFileSizeAuthor
#4 San_francisco.txt1.46 KBTy.Melvin

Comments

Ty.Melvin created an issue. See original summary.

vuil’s picture

vuil
Location Bulgaria 🇧🇬 🇪🇺 🌍
commented
Version: 2.0.3 » 2.x-dev
vuil’s picture

vuil
Location Bulgaria 🇧🇬 🇪🇺 🌍
commented
Status: Active » Postponed (maintainer needs more info)

Could you provide us an example CSV file? Thank you in advance.

Ty.Melvin’s picture

Ty.Melvin commented
StatusFileSize
new San_francisco.txt1.46 KB

It would not let me upload the csv file because of a file type requirement. I had to change it to a txt file. There is ampersand on line 3 and 15 of the file.

Ty.Melvin’s picture

Ty.Melvin commented

Also, I ended up converting the csv to xml format and removing the ampersands with [and] so I could go back and replace them after import. Thanks for your response and work on this module.

vuil’s picture

vuil
Location Bulgaria 🇧🇬 🇪🇺 🌍
commented
Status: Postponed (maintainer needs more info) » Active
vuil’s picture

vuil
Location Bulgaria 🇧🇬 🇪🇺 🌍
commented
Version: 2.x-dev » 2.0.x-dev
vuil’s picture

vuil
Location Bulgaria 🇧🇬 🇪🇺 🌍
commented
Status: Active » Fixed

I close the issue as done. Thank you too.

Now that this issue is closed, please review the contribution record.

As a contributor, attribute any organization that helped you, or if you volunteered your own time.

Maintainers, please credit people who helped resolve this issue.

Status: Fixed » Closed (fixed)

Automatically closed - issue fixed for 2 weeks with no activity.