Track-IT 8.5 importing excel files to inventory???

By brian.busbey ·
new to this software, all looks great so far. only thing is, we have around 500 phones and phone numbers, 300 laptops, projectors, printers, etc... i need to import all these from an excel file. i cannot for the life of me find a solution to my questions. there has to be a program or a 3rd party software that links into Track-IT that fills in all the info. of course there might be a certain way the excel file has to be formatted or something.

would anyone like to assist me or shoot me in the right direction for help? i called the company and they do not support this question but said that it is possible. is my direct email. thank you in advance!!!

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Answers

Collapse -

lotsa answers

by shasca In reply to Track-IT 8.5 importing ex ...

Here is a link to a support forum for Track-It

Collapse -

Create Link in Access

by Ann.Bingaman In reply to Track-IT 8.5 importing ex ...

You can LINK to the tables in'll need the password - contact your support person at Numara for that.

Then go here to get the Data Dictionary - - you'll need to login with your Numara account - that'll tell you how to map out your fields.

Then you can import them into the tables.

You'll also need to do some other tweaking, like changing the NextIdValue in the TI_IdGenerator table for TableName WORKSTAT.WS_NUM.

In earlier versions of TrackIt they gave you the Access links - I haven't yet upgraded to 8.5, but they may also have your support person at Numara.

Hope this helps.

Related Discussions

Related Forums