Hey There, i'm absolutly new in this.
I'm trying to create an APP that scans an Barcode, saving this Barcode-Number with an changeable Timestamp an 3 to 5 more Informations (Free text, or selectable text from a list) to a DB. The DB must be exportable to Excel. Maybe by sending a CSV to an Email-Account...
Is this posible with the App-Inventor. Can anybody give me some Starting-Help.
--
AI2 can create a csv file from a List. A list can be saved to a TinyDB. What is in a TinyDB can be read into a csv after converting the info to a list. The csv probablly can be emailed. A csv can be read by Microsoft's Excel.
I'm trying to create an APP that scans an Barcode, saving this Barcode-Number with an changeable Timestamp an 3 to 5 more Informations (Free text, or selectable text from a list) to a DB. The DB must be exportable to Excel. Maybe by sending a CSV to an Email-Account...
Is this posible with the App-Inventor. Can anybody give me some Starting-Help.
--
AI2 can create a csv file from a List. A list can be saved to a TinyDB. What is in a TinyDB can be read into a csv after converting the info to a list. The csv probablly can be emailed. A csv can be read by Microsoft's Excel.
Will it work for you? Your biggest issue is getting AI2 to scan the barcode. I do not know how you would do that.
--
okay excellent, the Barcode is scaned by the Mobile-Camera and it just generates a Number witch would be the Tag for every entry to the DB. I startet today, bozld it would't work. should try further...
--
I am in need of this too, glad I found this page.
So, what is exactly is csv? willl i be able to get the data that was collected in my fusiontable to be transferred to excel? that would be great
Is there a specific program for that?
--
CSV is a Comma Separated Value file... each line has the same number of fielkds, separated by commas. And example of this would be:
Mr.,Jim,Johnson,222 Any Street,Duluth,Minnesota,12345,123-4565-7890,Male,Likes Carpentry
Mrs.,Jane,Smith,123 Over There,New York City,NY,54321,,Female.Painter
The two lines have the same number of fields, all comma separated. the second one, Jane, doesn't have a phone number but you need to have the field there.
Mr.,Jim,Johnson,222 Any Street,Duluth,Minnesota,12345,123-4565-7890,Male,Likes Carpentry
Mrs.,Jane,Smith,123 Over There,New York City,NY,54321,,Female.Painter
The two lines have the same number of fields, all comma separated. the second one, Jane, doesn't have a phone number but you need to have the field there.
The first would translate to:
Mr. Jim Johnson
222 Any Street
Duluth, Minnesota 12345
123-456-7890
Male
Likes Carpentry
Look up CSV on the web. CSV files can be imported by Excel.
Mr. Jim Johnson
222 Any Street
Duluth, Minnesota 12345
123-456-7890
Male
Likes Carpentry
Look up CSV on the web. CSV files can be imported by Excel.
--
댓글 없음:
댓글 쓰기