Forum

Welcome to ProjeQtOr new Forum. We migrated old forum to the new website.
You will find all your posts here, with your usual account.
Just one point : you’ll have to reinitialize your password. Use “Lost password” feature.

CSV import error in...
 
Notifications
Clear all

CSV import error in specific use case

4 Posts
2 Users
0 Reactions
3,177 Views
 Dan
(@caccia)
Posts: 340
Contributor
Topic starter
 
[#4874]

Hello,
There seems to be an error in the import of CSV files - in a specific use case only: if a text field ends with a trailing backslash, then the import will be corrupted.
I guess it is seen as an escape character.

If using XLSX format, there is no issue.
For example see attached file.


 
Posted : 02 Jan 2018 13H41
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Issue recorded as Ticket #3180


 
Posted : 03 Jan 2018 17H01
babynus
(@babynus)
Posts: 14953
Main Contributor Admin
 

Hi,

I cannot reproduce.
Import works fine with your attahced file (after renaming 'type' to 'activity type')

Possibly value for parameter "export CSV to UTF-8 format" is set to YES and import file is not in UTF-8 format ?
(but my tests could not generate issue even in this config)

Can you please give more information :
- complete error logged
- value for parameter "export CSV to UTF-8 format"


 
Posted : 23 Jan 2018 14H45
 Dan
(@caccia)
Posts: 340
Contributor
Topic starter
 

I tried again on my test environment with this file and also could not reproduce ! :S
I'll have to dig back into the messages which came up at the time - if anything relevant comes out I'll let you know.


 
Posted : 26 Jan 2018 17H32
Share:

Scroll to Top