PDA

View Full Version : Import to database


MikeBoswell
06-10-2004, 08:57 AM
I have implemented a macro that imports files into the WM database from a directory. The files are placed into a packet I created for the imports. I am going to increase the frequency of this macro running. I will be calling up the packet license quite a bit and we only have 1.


I would like the files to bypass the packet . I know there is a 'packet_policy' that can be toggled. Will this allow me to import into the database avoiding the packet? What is the syntax of the command?

Thanks,

Mike b

John van Doorn
06-11-2004, 02:34 AM
Dear Mike,

The packet policy is used to switch off the need to create an element into a packet, by default every element you create must be in a packet.

While importing large amount of data, this can be very time consuming.

By switching the packet policy to off you do not have a need in your macro to create a new element into a packet.

Here is the syntax of the command:
Let current_policy (TOGGLE_PACKET_POLICY)

the variable current_policy has the value 1 or 0 which means on or off.

hope this information helps.
John van Doorn

MikeBoswell
06-11-2004, 06:17 AM
Thanks.

Im using "DMS_ADD_TO_ELEMENT_SET" to import the files.

What would be the macro to load directly to the DB?

Do I now go directly to "DMS_ADD_FILE"?

Mike

MikeBoswell
06-11-2004, 10:37 AM
Yup , that was the trick, thanks John !