|
Posted by Ryan on June 23, 2008, 12:31 pm
Please log in for more thread options By and large, you should be able to copy a field like AccountNumber, change
AccountNumber to PictureName and you should be set for adding it to a
report. As far as the full path, that would be tricky, at best and, I
believe, impossible if you want it to be auto updated if you change it in
Administrator.
--
Thank you,
Ryan Sakry
Program Manager
Retail Information Technology Enterprises
320-230-2288
rsakry@rite.us
www.rite.us
>
> Thanks that worked can you tell me how I can I add PictureName to the
> default price list report in manager is there away I can add it to a the
> column to show image path names
>
> Thanks Al
>
>
>
> "Ryan" wrote:
>
>> No reports that will make this happen for you out of the box, but here is
>> an
>> SQL Query;
>>
>> SELECT * FROM Item WHERE PictureName <> ''
>>
>> This will show you all of the items that have a picture associated to
>> them.
>> The PictureName is just that, the name of a file. The path to that file
>> is
>> dictated by the contents of the Pictures property located in RMS SO
>> Administrator -> File Configuration -> Paths.
>>
>> Hope this helps.
>>
>> --
>> Thank you,
>> Ryan Sakry
>> Program Manager
>> Retail Information Technology Enterprises
>> 320-230-2288
>> rsakry@rite.us
>> www.rite.us
>> >
>> >
>> > Looking for away to create a report for manager or query to see all
>> > items
>> > in
>> > my data base that has a images and image paths associated to items
>> > manage
>> > pictures better for my net display for retail store is there any
>> > default
>> > reports that give any image info ????
>> >
>> > Please help
>> >
>>
>>
>>
| 
Yahoo! 
Google 
Windows Live 
del.icio.us 
digg 
Netscape 
XML Sitemap