Questions

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

+
0 Votes
Locked

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

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.

tha5150@aim.com is my direct email. thank you in advance!!!
  • +
    0 Votes
    shasca

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

    http://www.trackitforums.com/index.php

    +
    0 Votes
    Ann.Bingaman

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

    Then go here to get the Data Dictionary - https://www.numarasoftware.com/support/MySupport.asp - 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 that....contact your support person at Numara.

    Hope this helps.

  • +
    0 Votes
    shasca

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

    http://www.trackitforums.com/index.php

    +
    0 Votes
    Ann.Bingaman

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

    Then go here to get the Data Dictionary - https://www.numarasoftware.com/support/MySupport.asp - 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 that....contact your support person at Numara.

    Hope this helps.