Inventory Solutions for a Symbol SPT 1700

Posted on 2004-04-06
Last Modified: 2013-12-27
Hi There

I have an spt1700 which I want to use for Asset Inventory walkabouts. Problem is, symbol don't give you any software to do this.

I bought code warrior and I know C but its just too much work to write my own.

Does anyone know of any solutions out there which I can buy or download (free would be good) for doing basic Asset Inventory stuff. I have an asset management database and can produce CSV / tab sep files to upload or download either way.

Question by:plq
  • 4
  • 3

Expert Comment

ID: 10792341
I did a similar project a while back.
For the palm application I used NSBasic, which is a good Rapid Application Development Tool(not free)
Then using the palm SDK; dveloped a conduit in VB/com controls to transfer data to SQL server.
If you go the programming route, After you get your data into the pdb,  I can help you get it from the palm to a csv or whatever you want and it shouldn't be much trouble at all.(Or does your asset management tool do the transfer part between the palm and desktop too?)

If your task requires no functionalities other than scanning; Depending on how often program will be used, who will be doing it, how much quality you want, Just scanning data into the memodb or a similar program then uploading and working with the data might be an efficient way of jerry-rigging such a system together.

Author Comment

ID: 10792613
NS Basic looks good, just went to their web site. The pricing seems to be low. Quality is important.

I want two versions of the software.

One to do "existence" audits, so we just go around zapping location codes and barcodes, and maybe an exception code if there's a problem with the asset

And one to do "update" audits, where you can scan a barcode and then a few fields from the asset record come up on a palm form for editing. This might also need dropdowns.

The backend software can import and export csv files so no problem, its just the file transfer which seems to be on palm already.

Did you manage to get nsbasic to talk to the scanning part of the scanner ok ? In codewarrior it was a nightmare. Can you trigger some nsbasic code as soon as a barcode is scanned ?


Expert Comment

ID: 10792924
Yes, no trouble with NSBasic and scanning bar codes.  You can scan right into a field, or if you want it to trigger a code when there's a scanner event, thats easy too(I did it my project)[When a scanning event happens it calls event()]
The only trouble I had with scanning bar codes, was I was using POSE emulator to test the program, and it won't load nsbasic programs when they use scanning functions.

NSBasic produces a nice interface, only drawback is its not as fast as if you were to use codwarrior

It won't take anytime at all to make the NSBasic program to do the scanning stuff.
Courses: Start Training Online With Pros, Today

Brush up on the basics or master the advanced techniques required to earn essential industry certifications, with Courses. Enroll in a course and start learning today. Training topics range from Android App Dev to the Xen Virtualization Platform.


Author Comment

ID: 10793242
Thanks for your help. I'll give it a try.

Did you include any dropdowns or tables in your software ?

thanks again

Expert Comment

ID: 10795540
dropdowns yes, no problem there
Didn't use tables
There's some documentation on it in the tech notes.

These Technotes and 'NS Basic Programming for Palm OS' by Michael J. Verive are the two best references for NSBasic.

Accepted Solution

itbeme earned 500 total points
ID: 10795605
The only trouble I had with NSBasic had to do with the databases,  I switched between using keyed and non-keyed several times, in the end I used a mixture of both, which I think Verive talks about in his book.  Make sure to look over tech note 2. Probably shouldn't have been as difficult as I made it.  Don't worry about the complicated stuff in 2a. But take a look at 2 to give you an overview of the databases and how you'll be paging between records.  It'll help you set up code and decide what features to scroll between records you may want.

Author Comment

ID: 10795758
thanks for your help

Featured Post

Gigs: Get Your Project Delivered by an Expert

Select from freelancers specializing in everything from database administration to programming, who have proven themselves as experts in their field. Hire the best, collaborate easily, pay securely and get projects done right.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I think the most popular question in our Windows Mobile Programming zone is about the backlight - we all want to keep it on when our application is running. Few years ago the function SystemIdleTimerReset() did this job. On our side we had to detec…
Progress means simplifying, not complicating. Bruno Munari Preface How to detect the name of the internal storage or an SD-card on Windows Mobile device from the desktop application? I got this question, when I was working on a PC applicati…
This tutorial gives a high-level tour of the interface of Marketo (a marketing automation tool to help businesses track and engage prospective customers and drive them to purchase). You will see the main areas including Marketing Activities, Design …
This Micro Tutorial demonstrates using Microsoft Excel pivot tables, how to reverse engineer competitors' marketing strategies through backlinks.

815 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now