Hello everyone
So, I'm setting up CMDBuild to manage my workplaces computers and I've run into some problems. When I try to import my csv with employees all the special characters like å,ä,ö get messed up.
The file is saved in UTF-8 and I also checked the DB and that should run in UTF-8. Anyone have some ideas! Right now I'm trying to import assets but since the "Assigned to" won't work without all the letters being right I can't continue at the moment.
One last thing, is there any updated technical manual, the versions of Jasper and the document plugin in the instructions is really old and I'm having some problem following them.
Not sure if it's worth going on with CMDBuild since it's looking pretty dead!
Pretty dead ? how you can see in the project changelog http://www.cmdbuild.org/it/download/changelog a new CMDBuild version comes out every about two months.
And this is an interview with CMDBuild, the SourceForge August 2014 "Staff Pick" Project of the Month: http://sourceforge.net/blog/august-2014-staff-pick-project-of-the-month-cmdbuild/
Regarding JasperReports, the latest released version should be the 5.5 and CMDBuild supports the 5.1 version since last year.
With Alfresco we were still at a quite older version. Consider, however, that CMDBuild is an open source project, if you want to help are welcome.
CMDBuild Team
hehe, well my plan succeeded! By insulting you I go an answer at once!
yeah I read the newsletter and the reason that I really really want to get CMDBuild working is the QR mobile integration that's coming! :D
So, any idea why my special characters fail to import?
Previously Tecnoteca wrote:
Pretty dead ? how you can see in the project changelog http://www.cmdbuild.org/it/download/changelog a new CMDBuild version comes out every about two months.
And this is an interview with CMDBuild, the SourceForge August 2014 "Staff Pick" Project of the Month: http://sourceforge.net/blog/august-2014-staff-pick-project-of-the-month-cmdbuild/
Regarding JasperReports, the latest released version should be the 5.5 and CMDBuild supports the 5.1 version since last year.
With Alfresco we were still at a quite older version. Consider, however, that CMDBuild is an open source project, if you want to help are welcome.
CMDBuild Team
In the open source world it is important collaboration, not insults.
About your special characters try to convert them into UTF without BOM.
CMDBuild Team
My sincere appologies then for the first post, I really think CMDBuild is a great piece of software but it might take a bit getting used to.
I used my PC last night to create the CSV's instead of my mac and suddenly worked, guess it was something with my macbook so now it's all working!
One last question, I need to create some reports but I can't figure out how to create the sql queries in ireport, is there any guide out there that you can recommend?
Previously Tecnoteca wrote:
In the open source world it is important collaboration, not insults.
About your special characters try to convert them into UTF without BOM.
CMDBuild Team
We do not have a guide to writing SQL queries.
The data model, however, is quite simple to understand because all the tables follow the same standards and then you can reuse very similar patterns .
Queries are always like this:
select Class1.Attribute1, Class1.Attribute2, ..., Class2.Description, ...
from Class1
left outer join Class2 on Class2.Id = Class1.Attribute4 and Class2.Status = 'A'
left outer join ...
where Class1.Status = 'A';
As you may have read on our site, is also available a training course on this topic:
http://www.tecnoteca.com/en/cmdbuild/supporto/formazione/module-b
CMDBuild Team