FOG - Label Print....

[ecoele]

Hey, I’ve been playing around with FOG for a while now. I’m mainly interested in the quick inventory feature, which works great. However, I’d like to slightly redesign the system and need your help.

Specifically, I need to be able to manually add the grade and a short description to a given laptop after the inventory is completed. After adding an entry to the database, I’d like the server to automatically print a label with the laptop’s information.

Can anyone suggest how to approach this?

Thanks in advance.

[george1421]

@ecoele I can say this option will not probably be added by the developers since its such a niche or one off requirement. But I’m not speaking on behalf of the developers, I’m just stating my opinion. Its up to them to decide if a feature request has merit.

But fog being opensource its free for you to modify to your needs.

What I can tell you that there are several user defined fields you are free to add whatever data you want. On the database side I think the fields are called user1 and user2.

The second part is that FOG’s database runs on mysql (mariadb). This is much like any other sql server. If you have a windows computer and the mysql odbc driver installed you can query the fog database from a reporting writing tool running on windows. From there you can print labels, etc. You could do something as an excel macro to query mysql on the fog server.

Again on the mysql server, you could program something on the fog server in either python or php to extract the data from mysql.