Adding email functionality in QtreeWidget--Urgent reply needed

mrjj

iqbalfaheem21

Ouch. One more functionality needed to be added. I request all my folks to please assist me in this as well.

Now I need to get the data from the SharePoint site. So what can be the code in Qt that can get the data from SharePoint and work in the same manner. So, in other words, it will get the data from SharePoint, and display all the data from it. Then whatever is checked from the tree will be included with the "mailto:" string.
So basically, no hard coding but getting the data from Sharepoint.
Pleae let mek now.

mrjj

Hi

get the data from the SharePoint site
From rest service ?
From SQL server ?
From ?
What data ?

Unless the SharePoint devs knows 100% what you mean, i doubt
there be many answer :)
Maybe I just dont know SharePoint well enough :)

iqbalfaheem21

@mrjj

I am linking the sharepoint data with an access file. Now I need to connect the access file with the Qt application that I made. So I need the code to connect to the access file, read the data from there and display it.. Also let me know where to write the code. In the header file, main.cpp, mainwindow.cpp or somewhere else.

mrjj

Ok, what is "the access file"
a db file, a text file or what is it?

iqbalfaheem21

@mrjj

A .accdb file

mrjj

@iqbalfaheem21 said in Adding email functionality in QtreeWidget--Urgent reply needed:

.accdb

"ACCDB files can be opened with Microsoft Access (version 2007 and newer)."

So you need to use install driver and set it up.
then you can use

db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=c:/test.accdb");

https://www.microsoft.com/en-us/download/details.aspx?id=13255

You might need some ODBC also. Not sure. Did Not use Access for many years.

Also pay HUUUUUUUUUUUUUUGE notice to the connection string. its always an issue :)
https://www.connectionstrings.com/access-2007/#p127

If you run into issue, there are many posts on google and this forum on how to use Access with Qt.

iqbalfaheem21

@mrjj
Can you send me the exact possible code for this?

mrjj

@iqbalfaheem21
That is really not possible as you will need a ODBC + Access driver installed and have exact accdb
to open etc. This you must master yourself.

You could start with small sample and try to get a database open.
There are many examples on the internet but you could start
practice with the ones from Qt

http://doc.qt.io/qt-5/examples-sql.html

and try with with sqllite.
then when you understand how database and
http://doc.qt.io/qt-5/qsqlquery.html
works then try to open the accdb file.
You will need this to read the data anyways. You can also ask here for help but
you need a bit of SQL and database+qsqlquery

iqbalfaheem21

@mrjj

Forget about SharePoint. Just a code to read data from MS Access file in Qt application.

mrjj

@iqbalfaheem21
You do it like any other database
http://doc.qt.io/qt-5/qsqldatabase.html
the connect line is different. read the docs for it.
db.setDatabaseName("DRIVER={Microsoft Access Driver (*.mdb, *.accdb)};FIL={MS Access};DBQ=c:/test.accdb");

then use
http://doc.qt.io/qt-5/qsqlquery.html
to read data.
QSqlQuery query("SELECT country FROM artist");
while (query.next()) {
QString country = query.value(0).toString();
doSomething(country);
}

iqbalfaheem21

@mrjj

I am able to connect to the database. Now I need to call the data from the database in such a way that it is displayed in a tree format. Like parent child. Just like if we use filesystem model, all the drives and folders are displayed.
And now if I want to iterate I cannot do that because I am using treeview not treeWidget. So I cant use QtreeWidgetItemIterator. So how to iterate also is a question for me.

mrjj

When you are using a view, you must use a model.
The widget version is item based and has hidden model
for that but A view wants a model from you or
one of the predefined
http://doc.qt.io/qt-5/sql-model.html

If read-only is ok then
http://doc.qt.io/qt-5/qsqlquerymodel.html#details
might be useful.

iqbalfaheem21

@mrjj

I only need a read model. But when it reads from the database, it should display the data in treewidget format. Dont know how to do that. It is easy to display in rows and columns, but tough to display in tree. Kindly assist.

VRonin

You need to execute the query manually and add the data to the model or widget. I have an example using a QStandardItemModel here: https://github.com/VSRonin/FXhelper/blob/master/FXhelperApp/PortfoliosTab.cpp#L4220

iqbalfaheem21

@VRonin

I am able to connect to the database. But how to get the data in a tree view. Do I need to pull the data in a treeview format?
the data in the database has no parent child relation. I am lost?

VRonin

There is no magically working solution, you have to iterate through each record of the query and build your tree model manually (using QStandardItemModel?)

iqbalfaheem21

@VRonin said in Adding email functionality in QtreeWidget--Urgent reply needed:

using

But using QStandardItemModel will compel me to specify the data. For example, reportsto name("John").QStandardItem(0,1,"Adam"); I want a general code that will keep working fine even if the employees changes. I need to do mapping and dont know how to do it. Any example please?

VRonin

@iqbalfaheem21 said in Adding email functionality in QtreeWidget--Urgent reply needed:

But using QStandardItemModel will compel me to specify the data

No, common misconception though.
you can use QStandardItem::setData to specify the content of a single item or, and this is what I suggest, stick with just using QAbstactItemModel interface either explicitly (declaring the model something like: QAbstactItemModel *model =new QStandardItemModel(parent); ) or limiting yourself in the methods you call. in this case you can use QAbstactItemModel::insertRows, QAbstactItemModel::insertColumns and QAbstactItemModel::setData to populate your model.

The explicit use of the interface also allows you, in case further into development you realise you QStandardItemModel is too slow or doesn't suit your needs, to change the model just by changing the constructor call (the line with new) and everything will work out of the box

@iqbalfaheem21 said in Adding email functionality in QtreeWidget--Urgent reply needed:

Any example please?

I linked it above, https://github.com/VSRonin/FXhelper/blob/master/FXhelperApp/PortfoliosTab.cpp#L4220

iqbalfaheem21

@VRonin

Okay just help me in the code that will index the parent child mapping. Below code I got online. Tried to implement it, but in vain.

QSqlQuery q;
QStandardItemModel *myModel;
q = db->atpSelect("SELECT * FROM group_tbl");
myModel->clear();
myModel->setColumnCount(3);
myModel->setHeaderData(0, Qt::Horizontal,"Name");
myModel->setHeaderData(1, Qt::Horizontal,"ID");
myModel->setHeaderData(2, Qt::Horizontal,"Parent");

QStandardItem *parent;
while(q.next()) {

int id = q.value(0).toInt();
QString name = q.value(1).toString();
int parentId = q.value(2).toInt();

QStandardItem *pId = new QStandardItem(QString::number(id));
QStandardItem *pName = new QStandardItem(name);
QStandardItem *pParentId = new QStandardItem(QString::number(parentId));

QList<QStandardItem *> row;
row.append(pName);
row.append(pId);
row.append(pParentId);

rowItemMap.insert(id, pName);

if (parentId == 0 && id != 0) {
myModel->appendRow(row);
} else {
parent = rowItemMap[parentId];
parent->appendRow(row);
}
}