link to file on Android from Excel - Android Q&A, Help & Troubleshooting

Hi all!
I am very curious if anyone here can give me a push in the right direction...
Let me start by saying that i have made an excel sheet in windows for the purpose of administring my mail. I scan my mail and name it in de sheet accordingly. F.e.: filename 2018-02-015.jpg is in excel as follows:
column A: 2018-02-015. Column B "jpg". In that way i can numer the files continuesly, but can select different filetypes (f.e.: pfd, msg, docx etc...) along the way. Now....
I use a formula to calculate the complete filepath so i can click in the cel to open the file. In windows this looks als follows:
=HYPERLINK(TEKST.SAMENVOEGEN("C:\Data\CloudStation\Post\gescande stukken\Inkomend\2018";A5;".";B5); "doc")
I use a duch version of excel... sorry... "tekst.samenvoegen" is probably "concatenate". Now... if the file i link to exists in the location mentioned in the formula, windows opens it flawless.
You might have noticed the term cloudstation in the path. That's because my goal is to sync with my mobile. That's the part that works already. But since i do not have the same paths on my Phone as i have in windows. I had to create another comlumn for the sake of opening files on android. At the moment i can open the sheet on android, look up the line i need and then navigate manually through the filesystem to open it. But it would be really neat if i could (just like in windows) click on the file in excel en open it that way.
What i tried is the following:
=HYPERLINK(TEKST.SAMENVOEGEN("/storage/0123-4567/Android/data/com.synology.dscloud/files/Data/Post/gescande stukken/Inkomend/2018/";A5;".";B5); "and")
since the name of the SD card seems to be 0123-4567 and the files i want to call upon also exsist in the target dir. i think it should work. But since i'm more of a windows man i'm afraid i'm overlooking something.... Android tells me that the link is not valid or i'm not authorized tot open it...
Who can halp me along? Thanks in advance!
kind regards,
some dutch guy

Related

Modifying ActionMenu.dll?

Hi all,
I was trying to modify the ActionMenu that pops up when you slide the querty out. This is on a HTC S740, but I suppose it would be the same for all HTC devices with a slide out keyboard. My intention was to edit it in a way that option nr. 3 (messenger) brings up a different messenger than WLMessenger, as I never use this one.
My findings so far are that the information to the links are stored in a dll called ActionMenu in the windows folder. I was able to open it with notepad, however editing the path for the messenger somehow broke the whole dll so ActionMenu won't pop up at all anymore when sliding the keyboard open. I also tried editing it with XN Resource Editor, but there nothing is displayed. So for now I am at my wits end.
Maybe someone else could help out here? Would truly be appreciated.
Regards,
.-ombre-.
Dll is a compiled library and therefore a binary file... If you would like to edit it this brute way you should use hex editor and only REPLACE links. That means, new link must have the same lenght as the old one and none of bytes should be moved. Then obviously, final file must have the same size as the old one.
Anyway, then it mustn't work either.
yeah, thats something I tried in the meantime and no, that doesnt work either..
Oh well..

UPDATED: DeviceID fetcher (now showing multiple IDs)

This a small application I wrote to automatically retrieve the DeviceID on your PC without having to open the registry editor. It can also create the DeviceID.txt file with the id value stored. It's written in Java so it requires JRE to be installed (most of you already have this)
http://rapidshare.com/files/403680176/DeviceID.jar.html
Make sure you have Sony Ericsson Update Service installed otherwise the device id will not be created in the registry
UPDATE: App updated to show all Device Ids stored in the registry
still dont work for me
windows 7 x64
It's been downloaded too many times (10) for a Free Rapid Share account, it is no longer downloadable, you'll have to upload elsewhere
Balur said:
It's been downloaded too many times (10) for a Free Rapid Share account, it is no longer downloadable, you'll have to upload elsewhere
Click to expand...
Click to collapse
new link posted
Hi !
As you can see I have more Strings in the registry ?
Whats your methot of determining which is the right one as they all show different DeviceID Strings ?
THX
pietropizzi said:
Hi !
As you can see I have more Strings in the registry ?
Whats your methot of determining which is the right one as they all show different DeviceID Strings ?
THX
Click to expand...
Click to collapse
I always get the first one, there is no way afaik to determine which one is getting used at any point. I can maybe change it so that it displays everything and lets u select the one you want to use
Well the point's not what I want to use, it more what's the right one at time of flashing. Is it save to delete those keys so the right one is rebuilt inn case of reconnecting the device ?
it's really not easy to find which one is being used at any point. i don't know if it's safe to delete them from the registry, although i would suspect that it is. just make sure you use the same usb port whenever you flash. that way you avoid overcomplications with this issue
THX for the info. I'd try to find out the right one.
In my case it was the second key found, not the first!
So this tool does not work for everyone.

[HOW-TO] View Folders in Kin Storage

Notice to users: This is an "At-Your-Own-Risk" type thing. We'll be meddling in the Registry so make a backup and follow instructions. I, myself and Xda-Developers.com, are not responsible for your screw-ups. Kay, Pumpkins?
In order to make the Kin Device Viewable by the windows shell, we'll first need to do some registry editing.
Run "RegEdit" to get to the registry editor. From here we're going to navigate to the following:
Code:
HKEY_LOCAL_MACHINE\System\ControlSet001\Enum\USB\
Once there, do a search for the following Line:
Code:
PortableDeviceNameSpace
Now, unless you have multiple Kin/Zune, this will be the entry for YOUR Kin. I'll edit this later for multiple kin/zune devices but for now lets continue.
At this point, Disconnect Kin from USB and Close the Zune Software.
After that edit the following lines to say the following:
Code:
EnableLegacySupport 1
PortableDeviceNameSpaceExcludeFromShell 0
ShowInShell 1
PortableDeviceType 3
After this, close up shop. Plug in the Kin. Zune player should come up if all is well, and you should be able to see your device in your "My Computer" area. Do a random sync of anything, something thats going to take time. This will allow you to view the contents of your device, only the zune side though.
Curious. I found that this worked for the KIN TWOm, although I needed to keep PortableDeviceType set to a value of 2, instead of a 3, to actually view the contents on it. I don't know if this is a change with the M version of the software. I also found that I was able to browse the contents, but not do anything with them (no retrieving or copying).
This post is great, I was able to at least see my device in "My Computer". Changing the values for the devicetype did not seem to make a difference for me, it worked in either case and I'm using a Kin TwoM.
I do have a different issue, however, I'm unable to actually access the files on the device. I cannot open them directly nor copy them to my desktop. It throws an access denied error.
I figured this out, looked up how to do it on the zune, but i too am getting the access denied error

[Q] WANTED: Need someone in San Diego to install awesome build of Android on my HD2

Is there anyone in San Diego that could install a fast, smooth and reliable version of Android on my HD2? If so, please let me know when you can do it and for how much $.
I spend my time between coastal North County and Chula Vista.
Thanks
Steve
It's so simple. Why on Earth would you pay someone to do it?
You download the one that looks best to you from HD2 Android Development, unzip it, and put the Android folder onto your sd card.
Not inside any folders on your card, just on the card.
Then in Windows Mobile, you go to your file explorer, go into the Android folder on your sd card, tap CLRCAD (nothing will happen, thats ok just tap it each time you start Android) and then tap Haret.
It really is as simple as putting a folder onto your sd card.
Just do it yourself. If you manage to screw it up, it won't mess up your phone and somebody on this forum will take pity on you and show you where you messed up
don't forget to flash a newer radio!
kypeth said:
don't forget to flash a newer radio!
Click to expand...
Click to collapse
good point, forgot about radio.
as long as it's a XX.XX.50.XXX radio, its good
I started this thread because I had just discovered that I can't do the install on my mac with an emulator. I really need to do it myself just so I know how to do it so I don't have to hassle finding someone to do updates. Sooooo, I'm doing a clean install on an old Windows machine just to get this done.
Are there simple non-developer instructions anywhere on how to do this? I've had two people tell me how simple this is but the instructions on this forum don't seem that simple with terms like "flash, etc. What does the term "flash" mean?
magentawave said:
I started this thread because I had just discovered that I can't do the install on my mac with an emulator. I really need to do it myself just so I know how to do it so I don't have to hassle finding someone to do updates. Sooooo, I'm doing a clean install on an old Windows machine just to get this done.
Are there simple non-developer instructions anywhere on how to do this? I've had two people tell me how simple this is but the instructions on this forum don't seem that simple with terms like "flash, etc. What does the term "flash" mean?
Click to expand...
Click to collapse
It's called that because of the type of memory. Anyway, it basically means install. "Flashing" a new radio means you're installing a different version while overwriting the existing one.
HOW TO FLASH:
Use "CustomRUU.exe" to flash the file (.nbh file extension). Phone must be connected and have >50% battery. If the CustomRUU.exe isn't included, download here:
http://forum.xda-developers.com/attachment.php?attachmentid=239860&d=1256298258
Step 1 - HSPL3 must be installed.
http://forum.xda-developers.com/showpost.php?p=6891358&postcount=1893
The .zip attached to this must be extracted and installed. Simple enough, no?
Step 2 - Flash a new Radio ROM.
I recommend the newest one (2.15.50.14)
http://forum.xda-developers.com/showthread.php?t=611787
Step 3 (OPTIONAL) - New Windows Mobile ROM
I put optional because Android will run without a different one, it just might not be as well. Download the "RELOADED 3" one in red. I use this one. Flash the same way.
http://forum.xda-developers.com/showthread.php?t=776971
Step 4 - Download Android flavor of your choice and copy it onto your SD card. I recommend http://forum.xda-developers.com/showthread.php?t=870518
Step 5 - Go into WM, navigate to the Android folder on the root of your SD, and click CLDCAD.exe (nothing will happen, this is normal) then click haret.exe
Step 6 - Celebrate.
If you need any help, feel free to message me.
No can do with any Virtual Machine on Macintosh?
Just use the newest official.They come with a newer radio.
If you cant flash with your mac extract the file and copy the nbh file as leoimg.nbh in the root of your SD.
Start the phone with vol down and let it flash.
sthEn said:
No can do with any Virtual Machine on Macintosh?
Click to expand...
Click to collapse
Instead of a virtual machine (is it Parallels?) why not use BootCamp, then you have a full Windows os on your mac - and you can flash.
I'll see if I can borrow a mac again and test flashing via Parallels.
I would love to help you for free - you just have to spend a plane ticket from Denmark (with lots of snow and freezing temperature) ;-)
fred_up said:
Instead of a virtual machine (is it Parallels?) why not use BootCamp, then you have a full Windows os on your mac - and you can flash.
I'll see if I can borrow a mac again and test flashing via Parallels.
Click to expand...
Click to collapse
I am a mac user and i used both Parallels and boot camp and i did it successfully without any issues.
I am a mac user and i used both Parallels and boot camp and i did it successfully without any issues.
Click to expand...
Click to collapse
I'm utterly stunned... I thought a Mac could do everything... and do it better than Windows, faster than Windows, more stylishly than Windows and made the user more intelligent, more likable and better looking at the same time...
Oh well...
I'm in South Orange County...If you don't get it figured out, and you are willing to come to me, I will do it for free. Just let me know.
mm0
Airborne Aircrew said:
I'm utterly stunned... I thought a Mac could do everything... and do it better than Windows, faster than Windows, more stylishly than Windows and made the user more intelligent, more likable and better looking at the same time...
Oh well...
Click to expand...
Click to collapse
On the few times I have run Windows on a Mac (via Parallels and Bootcamp), it runs really well. It just goes to show that the main problems with Windows is that of the sloppy drivers for the hardware that the hardware manufacturors provide. Since Apple only have a couple of computers, therefore they can afford to take time to develop device drivers for Windows.
Just to clarify please and sorry to be asking lame questions...
1) Is this true? "The best most reliable Froyo ROM for the HD2 is the 2.2.1 Custom Nexus HD2-FRG83D V1.8 Froyo ROM. Very stable and everything works perfectly." Is that accurate?
2) Are you saying that I can do the entire install of everything on my Mac with an emulator (VMWare Fusion) as long as I do it the way you describe?
3) Are you saying that I should change the name of the nbh file to leoimg.nbh and then drop it into my SD card?
4) My HD2 came with Android on it but it runs slow and clunky and won't make calls, etc. Its basically unusable so I'm assuming it wasn't installed correctly. There is nothing on the SD card that I care about. Should I format the SD card before starting the new build? And is there anything on the Windows side that I should delete first before starting too?
Thanks again.
Steve
Ultimaex said:
Just use the newest official.They come with a newer radio.
If you cant flash with your mac extract the file and copy the nbh file as leoimg.nbh in the root of your SD.
Start the phone with vol down and let it flash.
Click to expand...
Click to collapse
I would be willing to pay somebody for simple step by step clear non-nerdy instructions on how to install this stuff (Android, reformat SD card to FAT32, radio, etc., etc.) Seriously! You know, Step 1: Do this ya moron. Step 2: Now put this file named this in here idiot. Step 3: Now do this retard, etc.
Here are some more questions please...
1) What is the difference between a "sense" build and a "non-sense" build? Advantages, disadvantages?
2) When I plug the usb from my hd2 into my computer I don't see or recognize what is the SD card folder and I don't know where to install what I'm supposed to install. Here is what I see...
Removable Disk (E) > Application Data folder > HTC folder > databases folder > DocExp folder (with all this stuff in the DocExp folder: flintlock, postlist, postlist.baseB, record.baseA, termlist, termlist.baseB, iamflint, post.baseA, record, record.baseB, termlist.baseA)
...and next to the Application Data folder above there is also this: EncFiltLog.menc
and this is also in the HTC folder too...
ImageCache folder > DocExp folder (which is empty)​
Thanks again.
Steve
magentawave said:
I would be willing to pay somebody for simple step by step clear non-nerdy instructions on how to install this stuff (Android, reformat SD card to FAT32, radio, etc., etc.) Seriously! You know, Step 1: Do this ya moron. Step 2: Now put this file named this in here idiot. Step 3: Now do this retard, etc.
Here are some more questions please...
1) What is the difference between a "sense" build and a "non-sense" build? Advantages, disadvantages?
2) When I plug the usb from my hd2 into my computer I don't see or recognize what is the SD card folder and I don't know where to install what I'm supposed to install. Here is what I see...Removable Disk (E) > Application Data folder > HTC folder > databases folder > DocExp folder (with all this stuff in the DocExp folder: flintlock, postlist, postlist.baseB, record.baseA, termlist, termlist.baseB, iamflint, post.baseA, record, record.baseB, termlist.baseA)
...and next to the Application Data folder above there is also this: EncFiltLog.menc
and this is also in the HTC folder too...
ImageCache folder > DocExp folder (which is empty)​Thanks again.
Steve
Click to expand...
Click to collapse
OK, when you first start up your phone, and there are little red numbers and stuff down it the corner, look next to the letter 'R'
If it is X.XX.50.XXXX, then you're OK and don't need to change radio's and the process is very simple. (The X's can be any number, doesn't matter, as long as the 3rd set as shown are 50, not 51 or anything else.) So if it's 50, don't worry about the signed_ruu.nbh file or leoimg.nbh or flashing a radio. If it's not 50, you will need to change radio.
Next, when you plug the phone to your computer, the place where you find the 'Application Data' folder and the file 'EncFiltLog.menc', that is the root of your sd card. That is where the Android folder that you download and unzip will go.
So you will download the nicest looking build that you like the best, it will be in a .zip or .7z archive. You open the archive and take the 'Android' folder out and place it on your desktop. Then you drag it and drop it right next to your 'Application Data' folder. Don't put it in the 'Application Data' folder, just in the same place where that folder is at.
Removeable Disk E is your memory card, the root of the card simply means just on the card, not within any folders on the card, just on the card. That's where the Android folder goes, on the root of the card.
As far as Sense vs. No-Sense builds, Sense is maybe a little more user(noob) friendly, but it uses more of your phone's resources, so sometimes tends to lag (slow down, run slow) more than a no-sense build. For you, I would say try a Sense build first. Once you have installed one build, you will become more confident and really see how easy it is. Then you can experiment with different builds and see what is best for you.
After you have put the Android folder on the root of your sd card, alls there is left to do is to use the File Explorer on your phone to find the Android folder on your sd card, go inside that folder, first tap CLRCAD (it won't appear to do anything, but it actually enables sound in Android) (if your phone says the application is not from a trusted source,and asks do you want to continue, just click 'yes') and then tap Haret, a box will appear with a progress bar, and then Android will boot up (start).
The first time you run an Android build, it can take up to 15 minutes to start up. This is normal, just give it a while.
Then when it starts up, enter all the data it asks for (GMail, email addresses, etc. nothin major) and then when you have finished with that, and you end up at the phone's Android homescreen, hold the 'End Call' button, and choose 'reboot' and if there's no reboot option, just choose 'shut down' and then restart Android the same way as before. For some reason, rebooting after the first time like that actually helps Android to run more stable over the long term.
If you follow these instructions exactly as I have written them, you cannot fail. Now go, and enjoy Android
No need to pay me, just remember the 'thanks' button
On the few times I have run Windows on a Mac (via Parallels and Bootcamp), it runs really well. It just goes to show that the main problems with Windows is that of the sloppy drivers for the hardware that the hardware manufacturors provide. Since Apple only have a couple of computers, therefore they can afford to take time to develop device drivers for Windows.
Click to expand...
Click to collapse
I think you prove my point quite well... Macs are pretty much a single entity unto themselves. What Apple says, goes. Nothing else is acceptable. If you are prepared to be so limited then go ahead and stay with Apple products - they are for those who think they have imagination but are actually fooled into a "groupthink".
Huggs! Thank you very much for taking the time to explain that to me.
I installed Android and added my info (email address, etc.) and then restarted it like you said to do. Of course Windows loads first and when I tap the Android icon to launch Android it says: "The file Android cannot be opened. Either is not signed with a trusted certificate, or one of its components cannot be found. If the problem persists, try reinstalling or restoring this file." Since this phone had Android on it when I bought it last week (but it didn't work properly), I'm assuming that is the old Android launcher?? I did reformat the SD card via the Windows side of the phone before I installeded Android just now. Can you or anyone please tell me how I can get Android to launch now?
Thanks again.
Steve
UPDATE: I opened the Android folder and tapped CLRCAD and then HARET again and got the same error message as I explained above when I tap the Android icon. Also, and maybe this is normal since I'm still in Windows, but when I try to open any of the other files in the same folder (like INITRD, ROOTFS, etc., I get an error message that says: "There is no application associated with XXXXX. Run the application first, then open this file from within the application."
Another question please: The guy I bought this phone from was using T-Mobile but I'm going to use Simple Mobile. Does doing all the stuff I just did unlock this phone or do I still need to use an unlock code when I insert the sim card? (I will need to call Simple Mobile to activate the new Simple Mobile sim card in order to transfer my existing number over to this HD2)
Install this .cab in WinMo (install to device not sd)
Soft reset device (just fully off n then on, not factory reset)
try running Android again
Sounds like your phone just doesn't trust Haret, this should make it relax a little
let me know how it goes, it should work for ya

Opening Zinio PDFs

I was digging around in Zinio app folder on my tablet and it appears that each page of a magazine is stored as a PDF. When I try to open it, it says it's password protected. Has anyone taken a look at this? Is the password floating around or is there a way to open the file without the password?
Thanks!
fruv said:
I was digging around in Zinio app folder on my tablet and it appears that each page of a magazine is stored as a PDF. When I try to open it, it says it's password protected. Has anyone taken a look at this? Is the password floating around or is there a way to open the file without the password?
Thanks!
Click to expand...
Click to collapse
Hey it seems peeps here either can't or won't answer this question.
I have the same problem ... Common everyone, please assist us. Any answer is cool, but preferably a solution.
Thank you
Zinio PDF files
Hello there. Look into the same folder where those PDFs are downloaded. There you will find the same exact files but in JPEG format and they will open freely with any image viewer
Sorry but they are just thumbnails - not large enough to read...
It seems that each magazine's PDFs are encrypted using a different password, although the PDFs for the same magazine all use the same password. Two such passwords I recovered are ca2f3a202e73a5588510be105454d8f3 and f51daacd3e62829f0088f387bf5b311d. What I basically did was make a dump of the Zinio process's memory using gdb, run "strings" on it, then feed it into John the Ripper (jumbo) to crack the password. Unfortunately, I'm not sure how this password is generated - it must be stored/accessible somewhere locally, as you can read magazines you've already downloaded without an internet connection. However, the string only appeared once in memory, and it did not appear in plaintext in any of the other stored files, leading me to believe it is probably generated by the app at runtime somehow. MD5 of something maybe?
My device is running jailbroken iOS, so you all will have to figure out how to dump the process's memory for yourselves, but after I tarred and scp'd everything off my device:
Code:
pdf2john page0.pdf > crackme
strings memdumps.tar | tr -d ' ' | john --stdin crackme
then you can mass-decrypt and merge all the PDFs with something like this (replace 200 with the last-numbered file in the directory, I do this because simply doing *.pdf would merge the pages in the wrong order.):
Code:
mkdir decrypted
for i in *.pdf; do qpdf --decrypt --password=de4dbeeflongpasswordhere "$i" decrypted/"$i"; done
cd decrypted
pdfunite page{0..200}.pdf allpages.pdf
Hi, I have jailbroken IOS also but IOS 14.8. Is dumping the application heap what is needed to get the app's memory? I would be looking for ideas how to do this as I can't find gdb for 14.8?
thank you

Categories

Resources