1

(4 replies, posted in Questions & Answers)

QcodoMan wrote:

Thank you very much for reply. I will change the queries myself where needed. Your reply implies that I would be able to connect to Oracle using Tracmor and most likely, where the simple queries are used in tracmore, the code should work. Actually, changing the SQL code to fit the corresponding database is the easiest part as opposed to changing Qcodo code embedded in the Tramor. Thanks again

I should note that Tracmor has not been tested with Oracle, but in theory should work if you convert the database and rewrite the necessary queries as mentioned. Of course there may be some additional challenges that we are unaware of, but we'll do our best to assist via these forums if needed.

2

(4 replies, posted in Questions & Answers)

Unfortunately Tracmor will not work "out of the box" with Oracle. There are several queries that were written specifically for MySQL in the source, so these would all need to be updated where necessary for Oracle, or reimplemented using the QQ (Qcodo Query) API instead, which would support all databases that Qcodo supports.

3

(2 replies, posted in Feature Requests)

Yes, this feature is being worked on and should be available to Tracmor customers within the next month.

This feature was added earlier this year, as well as the ability to check out to other users and to contacts. These features are currently available for users of our hosted service. The code is of course available in our svn repo, but this is recommended for developers only, as there is no automated upgrade process from 0.3.0 to the latest code at present.

5

(1 replies, posted in Bug Reports)

Can you check your web server log for errors? Also, have you considered our hosted service?

6

(2 replies, posted in Questions & Answers)

Assuming you have knowledge of PHP programming, take a look in admin/labels.php and find the function called CreateTableByBarCodeArray(). There you should be able to see how the label options are defined, and use them as a starting point for adding your own.

To get rid of the dividing lines, in the first line of CreateTableByBarCodeArray(), change the table border from 1 to 0.

Strange. Maybe it's a Javascript issue. Can you check for errors in your browsers Javascript console?

You should either get an "AJAX error" popup or something in the error logs. What browser are you using? If you're using IE, give it a try in Firefox.

Unique asset codes (also known as asset tags or IDs) are fundamental to an asset tracking system. However, it's important to note that the asset code you assign to your assets does not need to be its serial number (though you can do it that way if you choose). Some of our customers use Tracmor that way, but many others create an asset custom field called 'Serial Number', and use this custom field to store the manufacturers serial number. This way you can have as many assets with the same serial number as you want.

On the other hand, if you are actually dealing with items that do not need to be uniquely tracked, but instead you need to track quantities of identical items that share a common bar code, the Inventory module in Tracmor is a better fit for this type of tracking.

This is a known bug affecting webkit browsers (Safari and Chrome). We recently committed a fix for this in svn, but an easy workaround for now is to just use Firefox to save your default shipping and receiving company. Once it's saved you can continue to use whatever browser you want again.

Some projects code that Tracmor uses (e.g. PHPReports) were written before PHP 5.3 came out, and hence have some incompatibilities that we have had to address. See this thread that may address your problem.

12

(4 replies, posted in Questions & Answers)

If you want to print to Avery label stock, then the label printing feature in the Admin tab is the way to go. If you just need a bar code to print, the Print Asset Tag button is not in the current downloads. You can see the code change for it here though.

13

(4 replies, posted in Questions & Answers)

If Turnkey is based on Ubuntu 10.04.1, then you're probably already running PHP 5.3, which is fine.

The error you're getting about ImageCreateFromPNG() indicates that you don't have the GD extension enabled in PHP. This post in the Turnkey Linux forums explains how to enable it. I will quote it here:

apt-get update
apt-get install php5-gd

Make sure to restart apache for this to take effect. Let us know if that does the trick.

14

(5 replies, posted in Questions & Answers)

You are correct. This has already been addressed in svn: http://code.google.com/p/tracmor/source … &r=765

15

(2 replies, posted in Questions & Answers)

It appears that your web server does not have write access to the tmp directory at /var/www/Test-tracmor/tmp. Changing the permissions should fix your issue.

Note that Tracmor requires PHP 5.2 or higher. I see you are running PHP 5.1.6. Upgrading to a newer version of WAMP should solve your problem.

17

(1 replies, posted in Questions & Answers)

It is not possible yet, but we are in the process of improving the import features in Tracmor. We do not have an ETA yet, but when completed it will allow for assigning and locking children to parents when importing assets.

18

(2 replies, posted in Questions & Answers)

See this thread for a solution to the issue you are having.

http://www.tracmor.com/forum/topic/317/ … -as-array/

Looks like you don't have gd enabled for your PHP installation. See this post for more information.

Could you check your web server error log and see if any errors are being logged when this happens?

21

(2 replies, posted in Questions & Answers)

Have a look in your web server error log, and post any errors here so we can help you troubleshoot.

1) Typically you would create an inventory model (with unique ID) for each unique type of item you will be tracking. You wouldn't want to use a single model to represent all sizes of black t-shirts, for example, because then small black t-shirts and large black t-shirts would have the same bar code, and the quantities could not be tracked individually.

2) Yes, you can easily add any custom fields to the item listing. Check out our video tutorial on custom fields here, specifically the section on customizing.

3) You can think of a bar code scanner as just a different kind of keyboard, in fact that is how your computer views most bar code scanners. When you scan a bar code, it sends the scanned characters to the computer as if they were typed. We usually recommend the cheapest Wasp or Symbol scanner you can find, depending on your needs. You can read more about choosing a bar code scanner here.

As for bar code labels, Tracmor has a couple methods of printing your own labels. If you want to purchase pre-printed labels, we usually recommend MetalCraft.

23

(2 replies, posted in Questions & Answers)

It is designed to be used with a bar code scanner that sends the ENTER key event. Hitting enter will add the asset.

24

(2 replies, posted in Questions & Answers)

It appears you are missing one or more entries in your admin_setting table. you'll need to make sure you have an entry for each of the following:

company_id
image_upload_prefix
fedex_gateway_URI
company_logo
packing_list_terms
packing_list_logo
min_asset_code
fedex_account_id
autodetect_tracking_numbers
custom_shipment_numbers
custom_receipt_numbers
receive_to_last_location
portable_pin_required
user_limit
fedex_label_printer_type
fedex_label_format_type
fedex_thermal_printer_port
asset_limit

My guess is that asset_limit is the culprit. Running the following query will add it:

INSERT INTO admin_setting (short_description, value) VALUES ('asset_limit', NULL)

25

(0 replies, posted in Announcements)

On May 31, 2012, FedEx will be retiring the FedEx Ship Manager Direct API. This is the API that Tracmor uses to provide direct integration with FedEx for scheduling shipments and generating FedEx shipping labels. FedEx has provided a migration path to their new FedEx Web Services API, but due to the extensive amount of development effort this would involve, and lack of customer interest, Tracmor will not be updated to support this new API.

What this means is that after May 31, 2012, Tracmor users will no longer be able to generate shipping labels for FedEx from Tracmor, and will be required to use the FedEx website or a 3rd party shipping solution to generate these labels. Users will still be able to record FedEx shipments in Tracmor the same way they currently do for other couriers (e.g. UPS and USPS) by creating a "FedEx" courier in the Shipping/Receiving screen in the Admin module, or by choosing 'Other' for the courier when scheduling a shipment. FedEx tracking numbers entered in a shipment will also continue to link to FedEx for tracking of shipments as they do now.

For a list of FedEx compatible 3rd party shipping solutions, go here.

If a 3rd party solution doesn't work for you, and you are interested in funding the development of Tracmor integration with the new FedEx Web Services API, please contact us. If there is enough demand along with financial support, we would be more than willing to add this functionality in order to retain FedEx integration in Tracmor.