Brett, open TMS and find an object record in the Objects Module. View that record in List View and change the view to "Export for Import", thus is a default view, but might not be activated in your system. Right-click in the List View and export into Excel. That spreadsheet is the template that is used by the Import Tool. On Jul 14, 2016 9:47 AM, "Brett Lavoie" <[log in to unmask]> wrote: > Hello, > > > > I’m preparing to import some data from a FileMaker Pro database to TMS. I > know this topic was brought up a bit ago, but I’m still unsure of a few > things. The main thing I’m looking for right now is some documentation on > what fields need to be present in the Excel spreadsheet and which fields > can be imported in total. The User Guide shows pictures of a bunch of > columns (which I’m assuming are probably from a TMS export), but the data > that I have is not in that format and I can’t find information for what > structure it needs to be in. > > > > Also, can I add fields into that structure or does any data that falls out > of the scope of what the TMS Importer expects just get discarded? > > > > Thanks, > > Brett > > > > -------------------------------------------- > Brett Lavoie > > University College > > Computing Services Coordinator > > Email: [log in to unmask] > > Phone: 416-978-0422 > > > To unsubscribe, send an email to [log in to unmask] with the > following commands in the body of the email: > > signoff TMSUSERS > > // eoj > > You will receive a confirmation that your subscription has been removed. > To unsubscribe, send an email to [log in to unmask] with the following commands in the body of the email: signoff TMSUSERS // eoj You will receive a confirmation that your subscription has been removed.