Options for exporting data from your free Purchase Order Software

You may have noticed that there is more than one way to export items, suppliers, PO history and other data out of the Free Version of SpendMap.  I am referring to the “Export Any Table” utility versus the “dedicated” export utilities under UTILITY > DATA INTERFACES in each module…

export data from PO system

While you could use Export Any Table to export the same data that is available via the dedicated export utilities, the dedicated exports provide some additional features that might come in handy if you’re going to be doing this on a regular basis, such as…

  • The dedicated exports allow you to set up “export templates”, so that you don’t have to manually select the fields that you want to export each time.
  • When configuring the dedicated exports, you can specify the location/position of each field in the export file.  While Export Any Table does allow you to select the fields that you want to export, you cannot specify, for example, the target column in the Excel file.
  • You can specify the format of date fields (e.g. MM/DD/YY vs. YY-MM-DD) if the other system that will be importing the data uses a different format than you use in SpendMap.
  • You can specify a default value for fields that might be blank in the source table.

Hope this help you pick the best tool for the job!

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s