|
|
Scan and validate
Posted: 28 May 09 3:16 AM
|
Hello,
I am trying to create an application for the Dolphin 7450 (PPC 2002) that will scan barcodes and validate them using a specified list.
Till now I have managed to load a combobox with the values, scan each barcode and if found I use a button to save it.
My problem is that I want to be notified from the program that the barcode is already scanned and if I accept this, increase the quantity counter.
I tried to use a grid that collects the scanned barcodes, but it does not fit me. I want the values to be added only if I press the "save" button first.
Amy suggestions?
Also if possible, is there any way to create 2 seperate files with the scanned results? I mean, each user to create his specific file with barcodes.
Thank you very much for your time.
|
|
|
Bev Connor
Posts: 93
|
 |
|
Re: Scan and validate
Posted: 28 May 09 11:02 AM
|
To check for a duplicate record on your mobile device (only when in batch transfer mode), a script can be added to your Save button to look up the scanned barcode against previously-collected data. Saved records are stored in a collected data file on the device; and the ITScriptNet function LookupCollect is used to search that file. You can download a PDF which describes this function from the Knowledge Base article below:
http://www.z-space.com/kb/PDF/10175/Duplicate_Checkfor.pdf
For the custom message, the Message function is used in the script. In the example provided in the PDF, the Message function simply displays an alert. In your program, you may want the user to make a choice. In this case, the Message function can be further expanded. In the ITScriptNet design view, select the Message function from the functions list in the upper-left pane; then in the upper-right pane, note the function's required parameters. Example:
;a semi-colon denotes a comment line
@VariableName@ = Message("Barcode already scanned, Save or Esc?","Confirm","Yes-Save","No-ESc")
;note function response 1 is the yes and 2 is the no.
IF(@VariableName@ = 2)
;Escape from saving and return to the scan element
SetFocus("promptname.elementname")
Exit
ELSE
;Save the scan and increment the counter
ENDIF
-------------------------------
To send your collected data to two separately-named files on the computer would require a data processing script written in VBScript. These script windows are located in the ITScriptNet program designer's Configure Receive > Edit Scripts button. For more information, please see the ITScriptNet User Guide section on Data Processing Scripts. You can access the User Guide from the ITScriptNet System Console's Documentation tab.
|
|
|
|
Re: Scan and validate
Posted: 29 May 09 2:56 AM
|
Thank you very much for your quick response! Until now the validation check i was performing was
1) Scan barcode
2) check if it exists from a combobox (a) that has all the values expected
3) adds the value to another hidden combobox (b)
4) Scan barcode
5) check if it exists from a combobox (a) that has all the values expected
6) if the value scanned also exists in combobox (b) then do nothing.
..
and so on.
If i want to save the data, i have added a save button that performs "SaveCollectedData".
This procedures works for me, but still I cannot send the scanned barcodes to an Access database after sync.
My problem is that I cannot comprehent how to match the values to my table in access.Apart from the Timestamp and the Alias
all the others are blank.
On the other hand, everything works fine when i export to csv file.
What I am doing wrong?
Thanks |
|
|
Bev Connor
Posts: 93
|
|
|
Scan and validate and send to Access
Posted: 29 May 09 10:40 AM
|
You do not need to save the scanned items to combobox (b); (that is, unless you are using this second combobox as a review list). The ITScriptNet software saves each record in a collected data file on the device. The program can use that data file to look up the records that have been already saved in the data file. This data file is the collected data that is then processed to the computer, whether to Access or csv or other.
To send your collected data to Microsoft Access, you will need to set up Configure Receive. Please see the User Guide section for Configure Receive and sending to Accesss. The program can save directly to Access, or use Microsoft's ODBC to save to the database.
User Guide (from the System Console, Documentation tab):
For ITScriptNet version 3.0, see page 260 through page 267.
For ITScriptNet version 2.4 Omni, see page 197 through 205.
For ITScriptnet version 2.4 Plus, see page 193 through 201.
Once Access has been set up in Configure Receive, each element in your program will display a field list drop-down (toward the bottm of the element's properties window) to select the specific field in Access to save that element's data.
|
|
|
|
Re: Scan and validate and send to Access
Posted: 02 Jun 09 10:34 AM
|
Is there any way to save temporary user variables in the mdb output?
ex @Date@ = DateFormat( [datetime] , "D")
I want to save this format of timestamp.. |
|
|
Bev Connor
Posts: 93
|
|
|
Re: Scan and validate and send to Access
Posted: 02 Jun 09 1:13 PM
|
Variables cannot be saved directly to the output. The program should set the value to a textbox element; then the textbox element is set to the appropriate database field.
For saved records, ITScriptNet records a TimeStamp for every record. When saving the TimeStamp to an Access database, the download process will automatically detect the field type in the database, and adjust the data accordingly. If your database field is a Date/Time type, the data will be converted into a Date type and assigned to that database field. Note: in the Configure Receive window of the designer view, there is a drop-down to set the TimeStamp to the database field.
Please see the user guides* for information:
ITScriptNet Plus - See page 198
ITScriptNet Omni - See page 202
If your program uses a date field other than the TimeStamp, you can format the date and set it to an element in the program design. The element's properties window is set to the date field in the Access database (a drop-down is displayed toward the bottom of the element's properties window to select the database field - See user guides page 89).
Examples:
$PromptName.ElementName$ = DateFormat( [datetime], "D" )
$PromptName.ElementName$ = Date( [datetime] )
*User Guides can be accessed through the ITScriptNet System Console, click on the Documentation tab in the left pane.
|
|
|
|
|