• Registered: 2008-12-19
  • Posts: 1

Topic: Customize the logo/image

Anyone know where to specify the 'Company' logo. (the live demo has 'Fictional Inc.'s logo displayed.)

Also, are there specifics to the image requirements? Does it have to be a PNG as it is in the live demo? Specific dimensions?

Are there other customization options such as interface colors?

Much appreciated.

Last edited by lshores (2008-12-19 11:23:25)

  • From: San Diego, CA
  • Registered: 2008-07-30
  • Posts: 37

Re: Customize the logo/image

The filename for the logo is located in the database table - admin_setting under 'company_logo'. This will then look for the file in the /images directory. So change the value in the database and upload the file to the /images directory and you should be good to go.

No specifics for the image requirements to my knowledge, but you will need to size it how you want it before uploading (it will not resize it for you).

No other interface customization options at this time without getting into the code.

Let me know if you have other questions.

-- Hunter

hjensen's Website

  • Registered: 2009-04-05
  • Posts: 7

Re: Customize the logo/image

The database table "admin_setting" does not list 'company_log' as a Field. Am I doing something wrong:

mysql> describe admin_setting;
+-------------------+------------------+------+-----+---------+----------------+
| Field             | Type             | Null | Key | Default | Extra          |
+-------------------+------------------+------+-----+---------+----------------+
| setting_id        | int(10) unsigned | NO   | PRI | NULL    | auto_increment | 
| short_description | varchar(255)     | NO   | UNI | NULL    |                | 
| value             | text             | YES  |     | NULL    |                | 
+-------------------+------------------+------+-----+---------+----------------+
  • From: San Francisco, California, USA
  • Registered: 2008-05-13
  • Posts: 362

Re: Customize the logo/image

company_logo is not an actual column on the admin_setting table, but rather one of the administration settings stored in the table. 

mysql> SELECT * FROM admin_setting;
+------------+-----------------------------+-----------+
| setting_id | short_description           | value     |
+------------+-----------------------------+-----------+
|          1 | company_id                  | NULL      | 
|          2 | image_upload_prefix         | NULL      | 
|          3 | fedex_gateway_URI           | NULL      | 
|          4 | company_logo                | empty.gif | 
|          5 | packing_list_terms          | NULL      | 
|          6 | packing_list_logo           | NULL      | 
|          7 | min_asset_code              | NULL      | 
|          8 | fedex_account_id            | NULL      | 
|          9 | autodetect_tracking_numbers | NULL      | 
|         10 | custom_shipment_numbers     | NULL      | 
|         11 | custom_receipt_numbers      | NULL      | 
|         12 | receive_to_last_location    | NULL      | 
|         13 | portable_pin_required       | 1         | 
+------------+-----------------------------+-----------+

So if you upload an image called "mylogo.jpg" to the images directory, you could run the following SQL on your tracmor database to use it:

UPDATE `admin_setting` SET `value` = 'mylogo.jpg' WHERE `short_description` = 'company_logo';
Justin Sinclair

Got Inventory? Get Tracmor.

jsinclair's Website