We are building an intranet using Active Project. We want to upload our data to the intranet automatically.
I am working in the following environment.
Data in Visual Foxpro DBF format.
Fields: Name, Business Telephone, Desk location, email will be downloaded into dbf format.
We also want to link the employee's photos (.gif format) automatically, with little or no manual intervention.
Is there an XML or SQL or Visual Fox command that will assign the image source by using variables? Example: Employee 1's id is 50789; Employee 2's id is 50969.
Photos will be identied as 789.gif and 969.gif
Finally, do you have any other recommendations?