We installed compiere 3.1 on linux with oracle xe.
During initial tenent setup the load accountingUS.csv failes with a message about unique default account. The file has unique accounts and none are repeated.
Are you sure you used the file from the correct version of Compiere and did not modify it? It should have 72 unique default accounts in Column H (2 new default accounts were added in 3.1). I have a version that works for me I can send you if you are still having problems.
The .csv file was in one of the directories when we installed 3.1.0 so I am assuming they match.
The file has 371 rows which is a lot more than 72
can you please email your file to email@example.com
also do you have 3.1 docs. the docs we have are 3.2
Thank you for the quick response.
The file you sent matches the one we are using.
The documentation on wiki was also for 3.2; do you know where we can find 3.1?
Also are you running compiere on windows?
We are running on linux; Do you think running on linux could be the problem?
One of my colleagues had a similar problem loading the accounting csv files. They would load OK on windows but not on Linux.
He found the problem was that we were opening the file with either OpenOffice or a text editor, and the applications were adding double quotes to the file when closing and saving the file. Next time we opened the file was opened by OpenOffice the double quotes would be removed.
If you are very careful about opening the csv file and saving it with no extra charachters on Linux then it should work ok. We have got it working so it is possible!!