I want to upload info for 500 items into my directory (e.g. hotel name, descirption, contact details, region). Is it possible to do this using an sql script rather than loading each individually? Is there a good reference document dealing with data structure on the xmod directory?

XMod Online Help - Importing Data Into Xmod

Thanks for the reference material. I got the import working perfectly and learned quite a bit along the way!

Now I'm trying to do an update import. I have my XModId's and related fields in an Access table. Trouble I have is modifying the xsml transformation to specify the opening Record Id field using the XModId in my table.

For the import transformation the transform code is:

Record id is hardcoded in this case. How do I read it from my Access table? 

Stephen,

I just happen to be talking to Kelly Ford, developer of XMod.

The import process was not designed to update existing XMod records. It was designed only to add data to the Xmod database.

It may be possible to perform an update but you will have to ensure that your Access database somehow has the ID of the Xmod record(s) you want to update.

Buck