training:exporting_inventory_pictures
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revision | ||
training:exporting_inventory_pictures [2014/12/23 08:44 (9 years ago)] – cliff | training:exporting_inventory_pictures [2021/09/02 22:15 (3 years ago)] (current) – jbalasabas | ||
---|---|---|---|
Line 1: | Line 1: | ||
+ | This article is linked to from this employee only article: [[employee: | ||
+ | |||
+ | Freshdesk: [[https:// | ||
+ | |||
+ | |||
===== Problem Description ===== | ===== Problem Description ===== | ||
Exporting Pictures from System Five | Exporting Pictures from System Five | ||
- | * Export Inventory to Excel | + | |
- | * Find the Pictures Folder | + | * Find the Pictures Folder |
- | * Export Images to the Picture Folder | + | * Export Images to the Picture Folder |
==== Query ==== | ==== Query ==== | ||
+ | This query can be used to identify all items with the lookup word of PICTURE attached to them. | ||
< | < | ||
select inventry.cat, | select inventry.cat, | ||
Line 11: | Line 17: | ||
join inventry on inventry.invunique = lkupword.kwunique | join inventry on inventry.invunique = lkupword.kwunique | ||
where lkupword.filenumber = 7 | where lkupword.filenumber = 7 | ||
- | And lkupword.word = 'DELETE' | + | And lkupword.word = 'PICTURE' |
; | ; | ||
</ | </ | ||
+ | |||
===== Solution ===== | ===== 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 | 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 |
training/exporting_inventory_pictures.1419353072.txt.gz · Last modified: 2014/12/23 08:44 (9 years ago) by cliff