http://www.database4iphone.com/support/ The iPhone Database en Sun, 05 Feb 2012 08:30:54 +0000 http://www.database4iphone.com/support/topic.php?id=401#post-643 Mon, 30 Jan 2012 06:29:09 +0000 facdatum 643@http://www.database4iphone.com/support/ <p>Sorry to hear about this. Did it crash immediately from install or did you use the application for a bit first? What version of iOS is your phone running?</p> <p>When an app crashes it writes a crash report that can help developers track down the cause. If you could send over the crash reports from your phone using the instructions below then that will help us identify what has gone wrong. Thanks.</p> <p>Here are the steps you need to follow to get the crash reports.</p> <p>iTunes copies the report to a directory on the user's computer when the device is synchronized. Depending on the platform, the directory is:</p> <p>- Mac OS X: ~/Library/Logs/CrashReporter/MobileDevice/&lt;DEVICE_NAME&gt;<br /> - Windows XP: C:\Documents and Settings\&lt;USERNAME&gt;\Application Data\Apple Computer\Logs\CrashReporter\MobileDevice\&lt;DEVICE_NAME&gt;<br /> - Windows Vista: C:\Users\&lt;USERNAME&gt;\AppData\Roaming\Apple<br /> Computer\Logs\CrashReporter\MobileDevice\&lt;DEVICE_NAME&gt;</p> <p>&lt;USERNAME&gt; is the user's login name for the computer. &lt;DEVICE_NAME&gt; is the name of the iPod touch or iPhone, for example, "My iPhone".</p> <p>We only need the .crash files. The crash report's file name begins with the application name and contains date/time information. In addition, &lt;DEVICE_NAME&gt; will appear at the end of the file name, before the extension.</p> <p>Having said this, if you have just started and are not going to lose much work then just re-installing the app may be the quickest way to get going again. Sorry for the inconvience. </p> http://www.database4iphone.com/support/topic.php?id=401#post-642 Thu, 26 Jan 2012 18:55:09 +0000 H1wtr 642@http://www.database4iphone.com/support/ <p>Downloaded app cannot open it, what do i do now? </p> http://www.database4iphone.com/support/topic.php?id=74#post-641 Mon, 16 Jan 2012 04:12:07 +0000 nvshootist357 641@http://www.database4iphone.com/support/ <p>I also have the same issue, please help, btw there are 3 entries but not needed to save </p> http://www.database4iphone.com/support/topic.php?id=400#post-640 Wed, 11 Jan 2012 06:38:11 +0000 facdatum 640@http://www.database4iphone.com/support/ <p>This sort of problem normally indicates something going on with the local network configuration. If you've tried rebooting your phone then other users have managed to get things connected with a reboot of their wireless router. That might help solve your problem.</p> <p>If you can reboot the router then open the app and tap the sync button, more than likely the url will have changed so you will need to make sure the one you type into your browser matches up again.</p> <p>If this still doesn't work then have a go at this. The url will be displayed as the following on the StoreIt Link screen on your phone: <a href="http://&lt;ip-address&gt;:&lt;port-no&gt;/" rel="nofollow">http://&lt;ip-address&gt;:&lt;port-no&gt;/</a> (e.g. <a href="http://192.168.0.2:49698" rel="nofollow">http://192.168.0.2:49698</a>). While the StoreIt Link screen is displayed open a Command Prompt/Terminal window on your desktop computer and type in: ping &lt;ip-address&gt; (e.g. ping 192.168.0.2). It should respond with:</p> <p>Reply from &lt;ip-address&gt; ....</p> <p>several times. This checks whether you can see the phone on your network at all. If it doesn't respond correctly (will probably say "Request timed out." then this points to a network issue. Is it possible that their is a firewall blocking the connection to your phone?</p> <p>Hope this helps. </p> http://www.database4iphone.com/support/topic.php?id=400#post-638 Sun, 08 Jan 2012 14:26:10 +0000 jlieberman 638@http://www.database4iphone.com/support/ <p>Greetings -</p> <p>I just purchased the StoreIT Pro (8-JAN-2012) and installed on iPhone 4. I created a new category, created and saved a record and shut down the app. Re-started the app and attempted a connection with web browser on PC. No web page or connection was available. The address was: <a href="http://192.168.1.2:55408/" rel="nofollow">http://192.168.1.2:55408/</a></p> <p>I tried shutting down and re-booting the iPhone. Re-started the app and tried to get a browser link but same result - no such site is available to the browser. iPhone is definitely connected to WiFi network. Tried with Firefox and Chrome browsers. Same failure. Any ideas would be appreciated. The ability to access the DB from a PC was the reason I chose this app over the multitude of others.</p> <p>Thanks in advance -</p> <p>Joel Lieberman </p> http://www.database4iphone.com/support/topic.php?id=393#post-634 Mon, 31 Oct 2011 15:16:57 +0000 facdatum 634@http://www.database4iphone.com/support/ <p>The new update is now available from the App Store </p> http://www.database4iphone.com/support/topic.php?id=393#post-633 Fri, 28 Oct 2011 07:03:56 +0000 facdatum 633@http://www.database4iphone.com/support/ <p>A new version of SQLConsole (1.4.0) has been submitted to Apple for approval which should offer more consistent connectivity on iOS5. The reported problem was not consistent across all devices/setups. The update also aims to fix a long standing problem with the saving and recovery of favourite commands on some devices. We'll let you know when it's available. </p> http://www.database4iphone.com/support/topic.php?id=395#post-632 Fri, 28 Oct 2011 06:59:04 +0000 facdatum 632@http://www.database4iphone.com/support/ <p>Have you tried restoring from a laptop or desktop computer over the StoreIt WiFi Link? This is the approach to transfer data to a new phone. </p> http://www.database4iphone.com/support/topic.php?id=395#post-631 Tue, 25 Oct 2011 08:09:03 +0000 vduk 631@http://www.database4iphone.com/support/ <p>I have just upgraded from Iphone 3GS to Iphone 4S. All my apps seemed to be backed up in iTunes but pretty much none of my data. StoreIt is on the new phone but none of the critical passwords etc that were stored in it. I managed to get the PC to suck the data out of the old phone, but can't see any way of putting it into the new phone. I did try to use the browser on the new phone to suck the data from the old one, but whilst it appeared game to start with it then said it couldn't when the chips were down - very frustrating.</p> <p>Can you please help..</p> <p>Thanx</p> <p>Ralph </p> http://www.database4iphone.com/support/topic.php?id=393#post-629 Fri, 14 Oct 2011 10:16:46 +0000 mm.stone 629@http://www.database4iphone.com/support/ <p>I confirm that it worked previously - I use it a couple of times each week. The address on the screen is the same pattern as before. The port number changes every time I use it. Doubt that this helps but I've also tried under Safari, Chrome and Firefox. </p> http://www.database4iphone.com/support/topic.php?id=392#post-628 Fri, 14 Oct 2011 08:26:56 +0000 facdatum 628@http://www.database4iphone.com/support/ <p>No we are not dead:) We continue to support our apps and users either through this forum, email or the support button in the apps. Updates are really dictated by demand and unfortunately demand has not been high recently:( </p> http://www.database4iphone.com/support/topic.php?id=393#post-627 Fri, 14 Oct 2011 08:21:37 +0000 facdatum 627@http://www.database4iphone.com/support/ <p>Thanks for letting us know. We shall look into it. Could you just confirm that this is something that worked for you previously?</p> <p>Also, after an iOS upgrade it is possible that the ip address or port number on the connection details displayed on the app screen will have changed 'http://ip-address:port-no/'. Could you also confirm what you entered in your browser matched what was displayed on the screen? Thanks. </p> http://www.database4iphone.com/support/topic.php?id=393#post-626 Thu, 13 Oct 2011 15:48:07 +0000 mm.stone 626@http://www.database4iphone.com/support/ <p>Trying to sync using SQLite Database Console after upgrading iPhone 3GS to iOS5. Message returned on the Mac is:<br /> You have made an invalid request. To return to SQLite Connect Main page go to: (same URL I just entered) </p> http://www.database4iphone.com/support/topic.php?id=392#post-625 Wed, 12 Oct 2011 00:09:12 +0000 mg082009 625@http://www.database4iphone.com/support/ <p>3 mos since last post and forever since an update? </p> http://www.database4iphone.com/support/topic.php?id=390#post-623 Fri, 24 Jun 2011 06:38:48 +0000 facdatum 623@http://www.database4iphone.com/support/ <p>When an app crashes it writes a crash report that can help developers track down the cause.</p> <p>If you could send over the crash reports from your phone using the instructions below then that will help us identify what has gone wrong. Please send to contact [at] database4iphone [dot] com. Thanks.</p> <p>Here are the steps you need to follow to get the crash reports.</p> <p>iTunes copies the report to a directory on the user's computer when the device is synchronized. Depending on the platform, the directory is:</p> <p>- Mac OS X: ~/Library/Logs/CrashReporter/MobileDevice/&lt;DEVICE_NAME&gt;<br /> - Windows XP: C:\Documents and Settings\&lt;USERNAME&gt;\Application Data\Apple Computer\Logs\CrashReporter\MobileDevice\&lt;DEVICE_NAME&gt;<br /> - Windows Vista: C:\Users\&lt;USERNAME&gt;\AppData\Roaming\Apple<br /> Computer\Logs\CrashReporter\MobileDevice\&lt;DEVICE_NAME&gt;</p> <p>&lt;USERNAME&gt; is the user's login name for the computer. &lt;DEVICE_NAME&gt; is the name of the iPod touch or iPhone, for example, "Donna's iPhone".</p> <p>We only need the .crash files. The crash report's file name begins with the application name and contains date/time information. In addition, &lt;DEVICE_NAME&gt; will appear at the end of the file name, before the extension.</p> <p>Sorry for the inconvenience. </p> http://www.database4iphone.com/support/topic.php?id=390#post-622 Tue, 21 Jun 2011 12:53:54 +0000 Donna Reggett 622@http://www.database4iphone.com/support/ <p>I have just set everything up and now I can't open without it crashing </p> http://www.database4iphone.com/support/topic.php?id=389#post-621 Wed, 15 Jun 2011 08:03:46 +0000 facdatum 621@http://www.database4iphone.com/support/ <p>There is no trap on memory or paging for large results at present. It's possible that it is running out of memory as it reads this large result set.</p> <p>Do you need to see all those results at the same time? One thing you could do is add a "LIMIT n" at the end of the query to restrict the number of results returned to some 'n'. SQLite also supports "OFFSET m" to offset into a result set as well so "... LIMIT 10 OFFSET 10" at the end of a query would get the results from 10 through to 19. Hope this is useful. </p> http://www.database4iphone.com/support/topic.php?id=389#post-620 Tue, 14 Jun 2011 19:38:19 +0000 ronanhigg 620@http://www.database4iphone.com/support/ <p>If I run a SQL query that returns a significant number of results (12,000) the app crashes after displaying the first 100 or so results)</p> <p>Here's the query:<br /> select Asset.AssetID from Asset inner join AssetCategory ON AssetCategory.AssetID=Asset.AssetID where categoryID = 685</p> <p>Hope that helps </p> http://www.database4iphone.com/support/topic.php?id=388#post-618 Fri, 06 May 2011 14:11:55 +0000 facdatum 618@http://www.database4iphone.com/support/ <p>At the moment checkboxes are just 2 value fields, either checked (true) or unchecked(false). There is no 'empty' entry. I appreciate it might be useful in certain situations but it not on the roadmap at the moment (but we'll add it to the list of potentials).</p> <p>I guess if you wanted this then you could simulate with a 2 value drop down (Field Values -&gt; Choose One From) with the values Yes and No (or True and False).</p> <p>Thanks for the input. </p> http://www.database4iphone.com/support/topic.php?id=387#post-617 Fri, 06 May 2011 14:05:37 +0000 facdatum 617@http://www.database4iphone.com/support/ <p>Thanks for letting us know about this. You're right. It is a bit awkward as it currently works. We shall aim to address this in the next update we do. </p> http://www.database4iphone.com/support/topic.php?id=388#post-616 Wed, 04 May 2011 21:07:49 +0000 paulgareau 616@http://www.database4iphone.com/support/ <p>It would be useful to have an "X" in addition to the checkmark (and nothing) as options in the checkmark field. This would avoid the potential ambiguity of an empty checkmark field meaning something doesn't exist, or that the person entering data doesn't know if it exists. Three taps could cycle between "check", "x", "empty".</p> <p>Great software, thanks! </p> http://www.database4iphone.com/support/topic.php?id=387#post-615 Wed, 04 May 2011 19:47:00 +0000 paulgareau 615@http://www.database4iphone.com/support/ <p>Hello. I have a category named "Places", which contains a category field named "Lodging". This includes a category field named "Price". The logic is that a "Place" can have multiple "Lodgings", and a "Lodging" can have multiple "Prices" (different types of rooms, etc.). The problem is with the "Prices" category - if I create a new place, then a new lodging, then add a price and tap "Save", the price record is lost. If I save the "Lodging" record first, I can then add and save the "Price" record, but this requires extra steps and isn't intuitive for the user. </p> http://www.database4iphone.com/support/topic.php?id=105#post-614 Fri, 29 Apr 2011 09:16:05 +0000 oleimann 614@http://www.database4iphone.com/support/ <p>Please also add the option to link two iPhones or an iPhone and iPad to sync databases.<br /> I noticed you can't click on the .storeit file in your e-mail to import or sync the database directly on the iphone. </p> http://www.database4iphone.com/support/topic.php?id=32#post-608 Tue, 08 Mar 2011 08:57:30 +0000 facdatum 608@http://www.database4iphone.com/support/ <p>There is currently no support for importing data from publically available web services although I appreciate it is something that could be useful for certain users. </p> http://www.database4iphone.com/support/topic.php?id=381#post-607 Tue, 08 Mar 2011 08:53:41 +0000 facdatum 607@http://www.database4iphone.com/support/ <p>At present there is no desktop version of StoreIt for data entry. The only option for off-phone access is to use a desktop tool to generate a comma or tab separated file for input (such as Excel that you mention). I appreciate this is not always the most straightforward approach. </p> http://www.database4iphone.com/support/topic.php?id=381#post-606 Sun, 06 Mar 2011 17:52:29 +0000 LGSW 606@http://www.database4iphone.com/support/ <p>Just purchased StoreIt. Looks cool. Q: Other than importing from another DB such as Excel, is it possible to import from a computer-input version of StoreIt? Probably a dumb question. I have a lot of data that is not currently stored in a DB and the thought of keying it all in on my iPhone's tiny keys makes my head ache. Setting up an Excel document exactly right so that it will import easily to StoreIt may be beyond my ordinary-user capability. Is there a computer-input version of StoreIt? </p> http://www.database4iphone.com/support/topic.php?id=32#post-605 Sun, 06 Mar 2011 07:41:32 +0000 AccessCoder 605@http://www.database4iphone.com/support/ <p>Can I import data from a public web service? If not, this would be a fantastic feature and attract a lot more customers for you. For example I have thousands of users of my software product that would like to download data to their iPhones. I can either build a specialised app at great expense to my company or else suggest that they buy a copy of store-it and access their data through my website. If you don't offer this service but would like to, I would be happy to work with you to make it happen. </p> http://www.database4iphone.com/support/topic.php?id=132#post-357 Mon, 10 Jan 2011 08:19:34 +0000 facdatum 357@http://www.database4iphone.com/support/ <p>Search and replace might be tricky for picking out the right lines to move. I guess an option would be to build an Excel macro (or possibly a set of formulas) that moved the text to where you wanted it from the nested data. The would be dependent on the category name in the first exported column. Could set up two sheets with the first where you paste the exported data into and the second that copies the data from the first sheet into the 'right' places. </p> http://www.database4iphone.com/support/topic.php?id=133#post-356 Fri, 07 Jan 2011 00:10:38 +0000 jemfree 356@http://www.database4iphone.com/support/ <p>You can export filemaker tables as tab delimited text files and then import using the web interface, but you need to create the 'category' first on your iPhone with the same number of fields as in the table. There's a FAQ on importing text files into Storeit. Cheers </p> http://www.database4iphone.com/support/topic.php?id=133#post-355 Thu, 06 Jan 2011 16:01:06 +0000 dcire 355@http://www.database4iphone.com/support/ <p>Any FileMaker Pro users know how to transfer data from Filemaker to Storeit? </p> http://www.database4iphone.com/support/topic.php?id=132#post-354 Wed, 05 Jan 2011 23:28:03 +0000 jemfree 354@http://www.database4iphone.com/support/ <p>There is a nested item so the exported text file has a carriage return in each line.<br /> I guess I can do a 'search and replace' in the text file.<br /> Is there another option? </p> http://www.database4iphone.com/support/topic.php?id=132#post-353 Wed, 05 Jan 2011 17:26:00 +0000 facdatum 353@http://www.database4iphone.com/support/ <p>The 3 additional fields at the start of each line are not necessary for import if the category does not contain any nested data. If a field has an embedded carriage return then this will be exported, but on export it should be possible to select to surround fields with quotes(") and these should then get imported okay. </p> http://www.database4iphone.com/support/topic.php?id=132#post-352 Wed, 05 Jan 2011 03:01:45 +0000 jemfree 352@http://www.database4iphone.com/support/ <p>I am trying to import category data into an Excel spreadsheet.<br /> There are items in the delimited text file that I don't understand and would like not to be there; there is a 3-digit entries after the category name (e.g. 344) and before the last field<br /> Also, the entry is split over 2 lines with a carriage return in the middle of each entry<br /> If I can fix the fact that the entry is over two lines, then when importing the data I can just not import the columns with the 3-digit codes.<br /> Please advise how to fix this behaviour </p> http://www.database4iphone.com/support/topic.php?id=131#post-351 Tue, 04 Jan 2011 09:42:16 +0000 facdatum 351@http://www.database4iphone.com/support/ <p>You can rearrange fields by using the 'grabber' bars on the right of the field name list. Just press and hold down and you can move the field. You'll see them in this screenshot: <a href="http://www.database4iphone.com/wp-content/uploads/faq1-11.png." rel="nofollow">http://www.database4iphone.com/wp-content/uploads/faq1-11.png.</a> (They are the 3 horizontal bars.) </p> http://www.database4iphone.com/support/topic.php?id=131#post-350 Mon, 03 Jan 2011 22:15:07 +0000 bmcintire62 350@http://www.database4iphone.com/support/ <p>I created a catagory then began editing the fields. I needed to insert a field between 2 other fields but was not able to. I had to create the field at the end of the other fields. I was also not able to rearrange the order of the fields. The only option I can see is to delete the other fields below the one I want to insert and recreate them in the order I want. My question is: Can you rearrange the order of the fields after the catagory is created. I need it to match the order of the spreadsheet I am importing. Thanks, Brad </p>