2014년 12월 27일 토요일

Collecting Data in TinyDB an Export them to Excel


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.

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.

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.

--
See attached screen shot of how to request a csv download of
a fusion table.


--

댓글 없음:

댓글 쓰기