Using Creator script can I control files on my local hard drive
Hi.
First, I love your program Creator. We have been working with it for only a few days and have found it easy to use, flexible and scalable.
We have a need for an online asset management system as our warehouse is remotely located from our sales office.
I have started to create an asset management database using Creator. I have the asset data collection form completed.
Each asset has a unique SKU number, auto generated from creator using a maxvalueholder form.
During processing of our assets we use a digital camera to take a picture or multiple pictures of each asset.
I would like to place a radio button on the data collection form. When the user clicks the radio button the following happens:
1- Each picture on the camera is renamed to SKU + -1, SKU + 2, etc. for all pictures.
2- All pictures are then copied from the camera to a local directory on our computer.
3- All pictures are deleted from the camera
We currently do this within MSAccess. The code is fairly straight forward:
Dim strPathOriginal As String (To hold path to camera)
Dim strPathNew as String (To hold path to directory on local hard drive)
Dim strOriginalPicNames As String (To hold original picture names)
Dim strPathPicOriginal as string (To hold original Path + original picture name)
Dim strPathPicNew as string (To hold path to directory on local hard drive + NEW picture name)
strPathOriginal = "G:\DCIM\" (Where camera is located)
strPathNew = "C:\images\" (Where we want to store the renamed pictures)
strOriginalPicNames = Dir(strPathOriginal & "*.*")
Do While strOriginalPicNames <> ""
strPathPicOriginal = strPathOriginal & strOriginalPicNames
strPathPicNew = strPathNew & SKU (Very important, we need to pull the SKU from the Creator form, input.SKU)
Name strPathPicOriginal As strPathPicNew
Kill strPathPicOriginal
strOriginalPicNames = Dir
Loop
-------------------------
Can this be functionality be duplicated using a Creator script?
Thanks!
David