This used to happen occasionally, but now seems to be a regular occurrence: our output files (exceptions, updates) get written with tabs delimiting fields, rather than commas. This is irritating as Excel doesn't handle this nicely. Our workaround is to open the file in notepad and then paste the contents into Excel using the "text import wizard" - not ideal.
Is this likely to be caused by something in our file structure? Whilst it used to feel random, I'm now beginning to suspect that it happens to some profiles more than others.
Any thoughts welcome.
I see this all the time. Usually from the 3rd expections files From the exceptions files
#1 except file is comma-delimited
then we upload #1
#2 except file is comma-delimited
then we upload #2
3rd except file is then tab-delimited.
and no, the headers do not have tab chars.
glad to know it's not just us!
I'm also having this issue - with some, not all, output files. Has anyone figured out how to fix this? Thanks
I work with Tom at Alzheimer's Research UK and I have also noticed this happening in the exception files. Recently we also had something strange happen where the exception file came out in both tabs delimiting fields and commas. We are currently using version 22.214.171.124. Any ideas what's happening here?
I work at Alzheimer's Research Uk and we are still getting the above issue. It's been 3 years since the original question was asked by my organisation, has anyone from Importomatic worked out what was causing this issue and how we can resolve it?
Can you please create a case with our support team and send your data file and profile? We'll try it here and see if we can replicate the issue to see what may be happening.
Once we find a resolution I will post it here.