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.
Hi,
I am exporting data from our old system as a CSV file, and importing that into our new system.
The files I create can be imported from within the WebUI, under "Tools->Import Data". However, if I do this as an automatic import by coping the CSV file into the import directory which the CRON job is looking at, the import is failing with this message:
ERROR - Provided file type and selected file format do not match
Import aborted
I have tried to simplify the CSV file down to a very simple file, but no joy. I have attached the file for reference. (I had to rename the .csv extension to .txt so that I could upload it)
Any help to decipher why the file is not accepted on the automatic import would be very much appreciated.
BR,
Daniel
BR,
Dan
Hi,
The error you're facing is not due to file content but to file name.
Please check your log file, you'll find something like :
ERROR - Type : File Type and Type selected are not consistent
File Name : xxxxx
Type Selected : xxxxx
Please report it here.
Hi Babynus,
The file I uploaded was renamed from .csv to .txt. I had to do this as the forum site doesn't allow me to upload .csv file extensions.
If I try to import my file with a .txt extension, I do get the error message you are seeing, but not as much information. I only see this first line:
ERROR - Type : File Type and Type selected are not consistent
This information I do not see:
File Name : xxxxx
Type Selected : xxxxx
I am looking at the log file in [import_directory]/logs.
Do you still get the same message if you rename the .txt file back to a .csv file and then do the import?
BR,
Daniel
BR,
Dan
Hi,
I tired to import your file, after changing .txt to .csv :
- manual import : success !
- automatic import : success !
Could you provide your file without changing the name, just zipped into a .zip file.
Oh, that is good news. Possibly something with our setup. We are using v 3.4.4
Anyhow, I have zipped the CSV file for you.
BR,
Daniel
BR,
Dan
Thank you Babynus
We are going to upgrade our version soon, so hopefully that will fix our automatic import.
What version are you using that your automatic import with my file is successful?
BR,
Dan
I just tried on V4.1.2.
Thank you Babynus,
I think we will upgrade our version, and will give it another go. Hopefully that will resolve it.
Thank you for your help 🙂
BR,
Dan