How do I rename spreadsheet columns and alter app to suit? - Android Studio

I have built an app from a tutorial but I am having problems adapting it to my needs. I need to rename the spreadsheet columns but when I do (and match the names in the app) if fails to get the data.

I'm not sure what spreadsheet you are referring to, but just going off my excel & VBA knowledge, can you check that auto calc is turned on? and/or hit F9 to recalc. How about the name manager section in the tool ribbon in excel? Say for example the column you want is called "variables" and it was originally defined as $A:$A (i.e., all of column A) but you did something and now it's been altered so that it's $A:$B (i.e., is all of columns A & B) then that could cause problems. Similar thing if it the area was smaller, like $A$2:$A$6. If you added a row to cell A7, the name manager is not looking past A6 in this example so your new info won't get a hit.
Hope that helps

I am using a google sheet to hold data for the app, one entry per row. I have tried with the code I have that builds the basic app. The tutorial app has first_name, last_name, email as column headers. I need them to be gridref, fallname, w3w. I have to name the data fields (?) within the app but if I use GridRef it fails but gridref works. can string names not have/be capitalised?
Also if I create a new project called WF the code I'm using works but if I name it waterfalls it fails.

I can rename them in the spreadsheet, there are no calculation fields etc. just simply text in a cell, typed in to be passed over to the app in JSON format.
I can add a new line which displays in tha app as a new entry which is what I want. I will need to add columns at some stage but I'll be happy to get this working first.
I have managed to rename 3 of the four columns but it fails when i change the name of the 4th That may not be a problem but changing last_name to aw3w causes an issue. In the app I think they are called 'holders', are some names reserved by the system?

I have figured this one out.

Related

Sliding keyboard sound

Does anybody knows where the sounds of sliding keyboard being stored? I'd like to change them but don't find..
They're in the Windows DIR, example: 0_in.wav 0_out.wav
In the sliding keyboard settings it calls "wind chimes", "piano" and "xylophone". Do you think they're the same? How should I call the new one I'd like to use?
I'm sure you could replace the original .WAVs then select the corresponding name (windchimes etc) in the option (I haven't bothered to see which ones are which, but seeing as there are only 3 sets, it shouldn't take that long
WINDOWS\0_in.wav
WINDOWS\0_out.wav
WINDOWS\1_in.wav
WINDOWS\1_out.wav
WINDOWS\2_in.wav
WINDOWS\2_out.wav
There is most likely a way to install new ones... i have a feeling you have to 'buy' them from the MS site or something :S
how do i get the windows directory to show up while browsing on my computer?
also, what is the directory for the sounds used for receiving text messages? i think it is just system sounds but yeah.
Pooper said:
I'm sure you could replace the original .WAVs then select the corresponding name (windchimes etc) in the option (I haven't bothered to see which ones are which, but seeing as there are only 3 sets, it shouldn't take that long
WINDOWS\0_in.wav
WINDOWS\0_out.wav
WINDOWS\1_in.wav
WINDOWS\1_out.wav
WINDOWS\2_in.wav
WINDOWS\2_out.wav
There is most likely a way to install new ones... i have a feeling you have to 'buy' them from the MS site or something :S
Click to expand...
Click to collapse
To install new ones:
Using your favorite registry editor, drill down to HKEY_LOCAL_MACHINE\Software\HTC\SlidingSound.
You'll see a number of subkeys named 0, 1, 2, etc. Create a new subkey whose name is 1 greater than the last subkey.
In the subkey you just created, set the following values:
Default value -- set this to the name you want to appear in the sliding sound control panel.
in -- a string value containing the name of the wav file you want to play when the keyboard is being closed.
out -- a string value containing the name of the wav file you want to play when the keyboard is being opened.
Close the registry editor
Copy the wav files referenced above into the Windows directory.
Great! Thank you!

HTC Weather, problem & fix

I thought I would add this here unless anyone else runs into the same problem. I broke my HTC Weather yesterday while trying to upload local cities into it. I am running the Dec 03 release of HyperDragon, but HTC Weather seems to be the same (at least in terms of files to edit) across different platforms.
After adding my local city, and uploading it back to the phone when I went into the weather tab to add a new city, I was unable to search for any cities. In fact the search screen contained no entries at all. Essentially, I corrupted the xml file, and the phone was unable to read it.
How I broke it:
Be careful what you edit with. I just opened the file with word pad in Vista to copy my new city information, but the xml file and word pad don't like each other. I found that the tilde ( ` ) <--- that character appearing over letters was unsupported in word pad. The xml file was unable to then read it. It saw it as corrupted data.
To fix it:
I just deleted the offending cities with tilde's in them. I didn't need them anyways. However, one could also just edit the file with a better program and re-upload it to the phone. Once I fixed the file, HTC Weather saw my new cities and was more than happy to read them.
Maybe someone else already went over this. I don't know. But I know I searched on the forum for quite some time without finding out what I did wrong.
AT&T tilt running Hyperdragon
The first mistake was editing an XML file with wordpad. Try using Komodo next time. Always use the proper software for certain editing functions.
Heres a link to the Freeware Komodo XML Editor.
http://community.activestate.com/products/Komodo
didnt I say that
SpiritOne said:
I thought I would add this here unless anyone else runs into the same problem. I broke my HTC Weather yesterday while trying to upload local cities into it. I am running the Dec 03 release of HyperDragon, but HTC Weather seems to be the same (at least in terms of files to edit) across different platforms.
After adding my local city, and uploading it back to the phone when I went into the weather tab to add a new city, I was unable to search for any cities. In fact the search screen contained no entries at all. Essentially, I corrupted the xml file, and the phone was unable to read it.
How I broke it:
Be careful what you edit with. I just opened the file with word pad in Vista to copy my new city information, but the xml file and word pad don't like each other. I found that the tilde ( ` ) <--- that character appearing over letters was unsupported in word pad. The xml file was unable to then read it. It saw it as corrupted data.
To fix it:
I just deleted the offending cities with tilde's in them. I didn't need them anyways. However, one could also just edit the file with a better program and re-upload it to the phone. Once I fixed the file, HTC Weather saw my new cities and was more than happy to read them.
Maybe someone else already went over this. I don't know. But I know I searched on the forum for quite some time without finding out what I did wrong.
AT&T tilt running Hyperdragon
Click to expand...
Click to collapse
Next time use notepad that is what i use...also the XML file is in my download section go there and download it open it in notepad and edit then move it into the windows folder...u should be good to go..
How did you manage to get adding cities to WORK?
I followed the instructions that have been posted around, but the URL fragment is NOT as displayed in those posts anymore on www.accuweather.com.
Going to htc.accuweather.com from my Kaiser gets me something that looks SOMEWHAT similar, but its not the same - if I try to use the same format that other US cities are in for mine, I can locate it in the list but it won't update.
Any help?
Genesis3 said:
How did you manage to get adding cities to WORK?
I followed the instructions that have been posted around, but the URL fragment is NOT as displayed in those posts anymore on www.accuweather.com.
Going to htc.accuweather.com from my Kaiser gets me something that looks SOMEWHAT similar, but its not the same - if I try to use the same format that other US cities are in for mine, I can locate it in the list but it won't update.
Any help?
Click to expand...
Click to collapse
I am not sure what you are asking...I just added my city like MOD Scotchua said to do and it worked...
http://forum.xda-developers.com/showpost.php?p=2644237&postcount=2366
Aha - I screwed up. Its working now
Spoke too soon..... it KINDA works.
The currnet Manila 2D executable will go back to the top screen (the home page) if you hit the END button twice. It also will mark an incoming SMS "read" if you sit on it on the top page for a few seconds.
The patched one does neither. It will not go back to home unless you navigate there, and SMS do not get marked read.
Is the patch involved (e.g. could I go in with a hex editor and make a change to the CURRENT Manila executable?)
Update to THAT....
I took a quick look at the executables and found the change, with the different URLs. However, it appears the new one is longer than the old, which means that a quick "patch in place" is unlikely to work (I have no idea what's AFTER that block of data - and it ain't zeros, and IS apparent UTF-8 text - so I'm likely to scramble something doing a quick overwrite.)
This in turn implies that you need a way to disassemble the exe file and replace the data, then reassemble it (e.g. to assembler, at least) assuming you don't have source.
So..... anyone have a tool for this or is this a case of "have lots of fun playing with something that can disassemble it, find a clean place in the data segment to put the new reference, and fix it that way" sort of game?
SpiritOne said:
didnt I say that
Click to expand...
Click to collapse
yep... just rubbing it in some more
I wouldn't use notepad either. I'd rather not get into a long discussion about editing xml files with notepad either
An XML editor is definitely the way to go.
Yet another update....
What's with the app here? I patched it with a string that fits using a hex editor.
What I wind up with refuses to run. Are these apps cryptographically signed?
Answer: Yep, and once modified, the signature is no good. I don't see anything in Advanced Config that can turn that protection off either; you can disable the requirement that CABs be signed, but I don't see where you can disable the requirement that APPLICATIONS be signed. My security policy settings are such that all security is off, but attempting to run the patched executable by hand elicits a complaint about the signature being invalid. I presume that a MISSING signature would be ok, but a CORRUPT one is going to get complained about - and I have no means to fix that.
Yet more....
I have found the code-signing tools after rooting around and re-signed the application.
It still fails to work; it appears there is a SECOND call to an HTC web site in the current Manila2D code which is NOT in the other patched file.
That one goes to: http://weather.manila1.htc.com/widget/htc/forecast-data_v3.asp?locCode=
DNS shows the address is a CNAME to htc.accuweather.com, and the worse news is that the replacement string that goes in the other place doesn't fit in there - its one byte too long.
It also looks like THIS is the one being called for updates, because changing the other, direct call to the htc.accuweather.com link doesn't change anything - the codes in the file that refer to places accuweather handles still work, but those that refer to other places do not.
Any ideas?
Final Fix - Read
Ok, here's what I've accomplished.
I patched the Manila2D.exe (the CURRENT copy from HyperDragon and others) and have re-signed the code (with a self-signed cert)
I also grabbed the php script and set it up on a VERY short domain name I registered this afternoon, htcwx.org - it exists ONLY for this purpose and is NOT a generic HTC web site.
I have modified the script as necessary, and the firmware as necessary. The replacement Manila2D.exe file is attached. To implement this simply replace the Manila2D.exe in your \Windows directory on the device with the one in this ZIP file. That's it; you can then add city codes at will in the weather file list and they will work.
The previously-posted version of Manila2D.exe has a couple of bugs that I consider show-stoppers, and patching the current version necessitated having a shorter URL as one of the places required to be patched would not allow the "not2advanced" url to fit.
Note that this weather reflector is being run by me, is OPEN and will remain indefinitely; I have a very high-bandwidth connection and expect no interruption in that service. Feel free to use it.
I now have WORKING HTC weather in Manila for virtually anywhere.... and you can too without the restrictions that existed in the previous patched copy (no return to home screen with the END key, and no SMS message marking)
This script "portal" should also work with any other patched HTC Home or HTC Manila applications; the complete url is http://htcwx.org/wx.php?
Note that there is NO general content on that web site.
Enjoy!
PS: As of this instant the .ORG TLD nameservers haven't picked the domain up yet from my registrar. That's abnormal; I see it on my infrastructure but not globally. It should be globally visible by morning.
There's just one thing left to say:
Thank you!
I've been fiddling with this for quite some time, and once I've found this thread everything worked as advertised!!
Happy new year!!
Glad it works for you! Happy New Year to you as well.
Hi Genesis3,
I have installed yesterday Josh's v15 M2D Plain 3G ROM and would like to customize the Weather and add my location.
Your Manila2D.exe is 1.1 Mo where the Manila2D.exe included in this ROM is only 410 KB .... Do you think I can change the original by your's ?
Thanks
That copy is PROBABLY compressed. If it is, the strings can no longer be patched.
You need to talk to the chef and get the uncompressed EXE file - if he has it.
Packed manila2d.exe
I haven't seen anyone post about this but the compressed manila2d.exe that I have uses UPX it worked for me to both unpack and repack the file.
Look into the file for "$Info" if it say's packed with UPX the link above may work for you too. (about 350h char's in)
ENJOY!
Genesis3 said:
That copy is PROBABLY compressed. If it is, the strings can no longer be patched.
You need to talk to the chef and get the uncompressed EXE file - if he has it.
Click to expand...
Click to collapse
As with everything here YMMV, make backups and if you blow it up don't blame anyone but the operator.

[APP] Notepad v4.0

Name: Notepad
About the app:
The Office app is powerful, but its syncing features slow it down. Notepad by AppsForMe is a great app to choose if you just want to take plaintext notes without the wait. It’s also the only text editor that supports folder structures, and the look of the app makes it feel like a part of the operating system (animations included). You can also pin documents or directories to the Start screen and send documents as emails or text messages.
The app has 4.6/5 stars over 48 reviews.
“Amazing app and it does what it says without any problems. Easily the best Notepad app on the marketplace and the fastest” 5/5
“Superb. You can store email and SMS templates. It makes life a lot easier. Don't miss it.” 5/5
“Very, very, very well done. Thank you.” 5/5
Developer's notes:
I'm always looking for more feedback on Notepad. Unfortunately, I don't get a huge number of support emails, so I'm left up to my own devices to figure out what could be added or needs to be changed.
Please give the application a shot. If you like it, great! If you don't, let me know what's up (in the comments). Chances are I can do something about it. Thanks for reading!
Possible future features (not guaranteed in any way, and not listed in any particular order.)
+ change keyboard theme
+ password-protect
+ lists
+ quick folders (swipe in directory view)
+ "emtpy trash" button
+ scroll sideways on long filenames
+ "import all" to parse "backup all"/"export all"
+ "export all" -> skydrive
+ import from url (skydrive/dropbox)
+ "are you sure?" -> "ready to send?"
+ title of note title -> "document title"
+ custom-name "root"
Source:
http://www.windowsphone.com/en-US/apps/626c487d-f1b0-e011-a53c-78e7d1fa76f8
I'll be watching this thread as well as my developer email, [email protected], for any questions, comments, complaints, or concerns. Thanks!
Some screenshots (attached).
Thank you!!!
Glad you like it!
Please let me know anything about it that seems weird or cool. I do things a lot differently than all of the other text editor applications, and I want to know what's good and what's not.
Wow really good Idea ! I have searched this for Quick Notes ( i use on the PC often the Editor ) and I would use a similiar App on the Phone ...
Thank you!!! i need this for school
simple and does what it says, good app
Notepad Suggestion
First, great Notepad app. I would just like to add a password to a note file.
Thanks!
It's good to see interest in the application! Notepad just hit 15,000 downloads today, and I'm always looking to make that number higher, so the more suggestions you guys have the better.
So far I'm seeing requests for:
(1) a new live tile, particularly for pinned documents/directories
(2) change the name of the "root" directory (to what, though, I wonder?)
(3) password-protect documents
(4) implement lists as well as documents
Anyone have any other suggestions, or want to plus-one a feature?
--AppsForMe
Guess you had missed our review. Skydrive Integration and ability to send notes as attachment.
Yes, I definitely saw your review! I actually did implement two of your suggestions (preview of content when pinned, ability to move folders).
Here's how I feel about your other requests:
First, the Windows Phone operating system prevents third-party developers (read: me) from sending email attachments. Same goes for speech-to-text.
Second, as soon as you want SkyDrive, you should just be using Office. The Office app supports either (a) local files without folders, or (b) SkyDrive files with SkyDrive folders. Goodness knows that I can never match the Office app for stability, integration, features, or UI. Plus, Notepad's other sell is that it's fast--loading notes, saving notes, navigating folders--implementing web functions would slow everything wayyyy down. I see the lack of SkyDrive as a selling point.
(Side note: Office supports sending documents as attachments. Two birds with one stone!)
Notepad for WP the best
I think the requests thus far are pretty much what is missing although it seems it's going to be an uphill battle due to OS restrictions. Installed the app last week on my Lumia and it's amazing, clean and easy to use. Keep up the good work.
I used to use this app, but it had this bug where i could not scroll to the bottom of the longer note. Has that been resloved in the meantime?
Also, I think skydrive sync is important (or even dropbox). When someone changes phones, how is he going to transfer notes?
thank you i need this apps
All the problems with long notes have been fixed.
I'm going to leave the auto-syncing between SkyDrive and the phone up to the native Office application--it does it better, faster, and more reliably than I ever could.
If you need to back up your documents, use the "backup all" feature to email yourself the text of the documents.
Hi Isaac,
Great app. I registered here just to say that, and thank you. I'm a note taking person but one that wants to keep them organize and your app is the only one that does it with ease. (I must of downloaded a dozen to try and removed..only one other did folders, the rest was just one giant list of notes).
If you're serious about taking users feedback, here are some of mine...all are minor little things that are mostly ui based and these are just my opinions. I think your application here is quite impressive so take these only to help out for those you agree with..
- replace 'root' with 'home' or 'my folders' perhaps?
- replace 'Remarks' when creating a new directory with 'Note: ' or remove the word entirely and place the remark note under the text field.
- titles of Directories and Notes become all lower-cased when viewing
- clicking the back button when in Search mode hides the keyboard only, so it requires clicking the back button again to exit the search function..this may be an OS thing I've seen and not something that can be changed unless you can find a way around this.
- add a Folders button at the bottom when in a non root directory to take you back, just like how it appears when in a note to take you back to its directory.
- when in a directory, can the word Notepad and the Directory name on top take you back to the folder list view or one folder out if in a subfolder?
- possible to allow user to choose which directory(ies) to list mango-syle to the right where they can swipe to the right and to go into that directory (sorry if this is unclear, I'm not too familiar with WP terminology yet)
- Button to empty trash when viewing trash directory. btw, how does the trash work..deletes automatically after so long?
- when viewing a file that has a long filename (and the feature is turned on), can it scroll?
- reduce space between documents filenames ..currently lists 5 before needing to scroll?
- backup all..cool feature. I would change 'Are you sure?' which sounds a little scary to something like 'Ready to Send?' btw, can you import back into Notepad? If note, perhaps call the feature 'email all' instead for now..
- when creating a new note it shows 'new document', the next screen where it ask for the file name it displays 'new note' ..just a consistence thing
- are all notes saved as txt files on the device? what if you remove the .txt? does it need to be displayed if it's automatically saving them as txt files.
- Can titles of notes and directories names be the system's accent color and turn black when choosing them? ..the reverse essentially.
- when adjusting toggle sliders in Settings, the phone wants to swipe to it's neighboring page a little too freely (btw, love all the settings you have here!)
- remove the larger 'root' when in the root directory list to gain some real estate back to see more directories and so it's not repeating perhaps?
And if you need any simple graphics help, I can help out.
I'd love to see Dropbox support with everything being saved to dropbox and loaded from dropbox. I'd even pay for a dropbox enabled version.
Can it handle long text file ?
Can it import text file from skydrive?
Can we Password lock the app or folder?
thanx
First: Thanks, Lumiame, for the excellent feedback. You've greatly extended the set of features I'm considering adding, and you've noted UI inconsistencies and confusions that I'll make sure to address in the next update.
To everyone who's commented so far: thanks for the good feedback. This quarter at my university is slower than my last quarter, so I should be able to get to work on the app.
Look for a good number of changes in the next updates.
thanks for sharing

Set custom sms/email sounds on Samsung Ativ S

(I'm posting this in the Questions Forum because i have not enough posts to either create a topic in the Development and Hacking Forum or reply to the registry hacks-thread.
But since it's also somehow a question I hope it's ok in here.)
______________________________________________________________________________________________________
Edit October 15th, 2013: With the GDR3-Update you get this feature built-in, so no more need to do this then!
Hi Folks,
while AlvinPhilemon found out a registry tweak to set custom sounds on the Samsung Ativ S (as explained in this post), it is not quite practical, since you can't see the sound in the list with the others, so you can't choose or switch them without always edit the registry.
I found another way to do this, and I think it's a bit more elegant (see attachment to have a look), although it only can change the sms, e-mail or mailbox sounds.
This is what you need:
1. Interop Unlock
2. Registry Editor (use SamWP8 Tools)
3. Full File System Access (use SamWP8 Tools)
4. Your Notification sound (I tried mp3-, wav- and wma-format, all worked)
This is how you do it:
1. On your PC, browse to your Phone\PROGRAMS\CommonFiles\Sounds\ and paste your new sound there.
2. To make it visible in your sounds selection list inside the Settings-app you have to create a registry entry: Go to HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shell\OEM\Sounds\Notifications\ (This is the Samsung specific location for notifications; I tried the whole thing with the standard Microsoft sound location HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Shell\Sounds\Notifications\ but it didn't work). In this registry location you can see a list of the the existing Samsung notification sounds ("Knock.wma", "On time.wma" and "Whistle.wma") and how their name is displayed in the Settings-app ("Knock", "On time" and "Whistle").
3. Create a new key and set the Value to the name of your soundfile (for example "Silvestro.mp3"), the Type to String and the Data to the name how you want it to be displayed. There might be an error notification after writing, but just read the key to check you wrote it correctly.
4. Done! Go to the Settings-app and choose the newly created sound as message, mailbox, or e-mail-sound!
What do you think of this solution? Of course it would be nice to pack this feature in an app that first lets you choose a soundfile from the Public or SD-Folder, then copies it, then creates a registry entry and then also is able to delete those things an put everything back to normal, but since I'm just starting with C# there's no way I can do this myself. Anybody interested in trying?
Thanks for your comments!
Very nice work, and good tutorial. It would, indeed, be good to get an app to automate this. You would need ID_CAP_SOUND_CONTROL (may require full capability unlock); this capability should enable both the requisite file system and registry access.
It's a shame that is not available by default like on every other smart and dumb phone in the world. This is one of WP many short comings that MS refuses to address.
Thanks
Nice tuturial, thanks.
I am a satisfied galaxy s4 owner. Before this phone i had the htc 8x. I liked wp8 a lot, but unfortunally some essential apps (for me) where still missing. Beside the very good os, i also like all the default sounds. Thats where my question comes in.
I'm looking for the complete set of Windows phone 8 notification sounds. Is it possible to copy them from a wp8 phone and post them here? I would like to have the windows sounds in my galaxy.
Great news!
With the GDR3-update comes the feature to set custom sounds for Messages/Mailbox/Reminder!
So this is no longer needed...
more easy way
I just renamed my ringtone the same as the existing tone in the map \PROGRAMS\CommonFiles\Sounds\.
Then I renamed the original sound (I have put "old" in front of the original tekst.)
Now I copied the rington in the map \PROGRAMS\CommonFiles\Sounds\.
Choose the ringtone on your phone, and it plays your ringtone.
I converted the mp3 ringtone to wma. I didn't try if it plays mp3.
The name of the original ringtones doesn't match the name in the phone, but you can play them first on your pc, to see witch one to replace.

[APP] RK Noter - save excerpts from documents to your SD card

Here is a little app I've been writing which I think will be useful for eReader users. It adds an entry in the share menu when you share some text, and it saves what you shared to your SD card in a folder you can specify. You can also set a divider (or no divider) to separate the notes you've saved. The file name is set to be either the 'subject' of the share intent (e.g. the name of the file/book you were viewing), or the name of the app which you shared from if it doesn't provide a subject field.
To do:
- Note headers e.g. time and date
- Optional editing/selection of note file and optional editing of note content prior to saving (current insta-save is nice but more options are also nice!)
- Implement a folder browser instead of typing in manually
- Preview of note dividers
- ??
Let me know if you have any suggestions or requests for additional features.
Downloads here: https://www.mediafire.com/folder/63k32it3d7mdt/RK_Noter
P.S. If your regular reader apps don't have an option to select and share text, my recommendations are Orion Viewer for PDF/djvu, and EBook Reader by Rabbit for most anything else. I would recommend AI Reader which I really like, but it has a few more steps involved to share text, and it provides a really over-helpful subject string, complete with the time the text was shared, thus a new file is generated each time...
...reserved? Accidental post actually, can be deleted!

Categories

Resources