Windward Software Wiki

This page is read only. You can view the source, but not change it. Ask your administrator if you think this is wrong.
This article is linked to from this employee only article: [[employee:system_restart_procedure:system_restart_data_restart:system_restart_data_restart_how_to_set_up_restarted_data#pictures]]

Freshdesk: [[https://support.windwardsoftware.com/a/solutions/articles/66000495280]]


===== Problem Description =====
Exporting Pictures from System Five
  * Export Inventory to Excel
  * Find the Pictures Folder
  * Export Images to the Picture Folder
==== Query ====
This query can be used to identify all items with the lookup word of PICTURE attached to them.
<code>
select inventry.cat, inventry.invunique, inventry.part, lkupword.LkupUnique,
lkupword.FileNumber,lkupword.word, lkupword.kwunique
from "lkupword"
join inventry on inventry.invunique = lkupword.kwunique
where lkupword.filenumber = 7
And lkupword.word = 'PICTURE'
;
</code>

===== Solution =====
System Five has various methods of reporting on your data, and getting information out of your data. We will be taking advantage of the ability to export inventory information to excel / csv, as well as the ability to export pictures using the specialized XML interface called XML Central. We are not going to be working with XML files as these are complicated and only something that I would normally  have a programmer from Windward Software work on. We will be taking advantage of one of the options in XML Central, and looking at how we can make use of it.

Note: this article is also publicly available at http://wiki.wws5.com/share/Exporting%20Inventory%20Pictures1307151557.html

{{training:exportinginventorypictures1307151557.flv|}}



Created by Clifford MacKay at 7/15/2013 3:57:24 PM