About the BaylaDexThe BaylaDex stores data on your smart device organized by Items within Categories for quick and easy lookup. Create your content, organize it in a way that makes sense to you, and then easily find it when you need it.
The BaylaDex uses Categories and Items much like folders and files, except it stores the content you create in an encrypted database on your device. Associate a photo and toggle with one swipe on the same screen.
About the Programmer
William R. Vitanyi lives in northwestern Pennsylvania with his family and many pets. He is an Edinboro University of Pennsylvania alumnus, with a Bachelor's degree in Russian Language and additional certifications in computer programming and operations.
For Android programming Bill uses B4A, or Basic for Android. This is a rapid application design (RAD) software suite that facilitates application design for Android devices.
In addition to Android apps, he has written several books, numerous articles at Hubpages.com (see under Hubs on this page) and founded the Build-A-Book project.
Bill has appeared in several independent films, and served as script supervisor in Schism, an independent film by Lyon's Den Productions about one man's descent into Alzheimer's. Bill won awards for his writing at the St. David's Christian Writers Conference, and in 2008 he won an IPPY award (humor) for The Official Guide to Office Wellness.
Connect with the Programmer
Create a Website at 1and1
To contact me send email to: Contact Bayla
Sign up to receive our monthly newsletter, Bayla Bits. Stay up to date with news about Bayla Publishing, get writing and publishing tips, and be amused by our team. Provide your email address below, and click Submit. Sent as a pdf link.
We will never sell or provide your email address to anyone.
Using the BaylaDex
On install the only Category is the Help category, which contains many help Items, each explaining some aspect of BaylaDex operations.
Moving forward you can create many new Categories, each containing its own set of Items. Each Item contains a text note, and can also have a photo associated with it.
You can create Categories, or Items within Categories, very easily. You then create the text that goes with an Item. For example, you may have a Category called TRIPS. That Category may contain an Item called NEWYORK18, which contains notes about that trip. To find it, you would use the Category pull-down to select TRIPS, and then the Item pull-down to select NEWYORK18. Your notes about that Item would display in an editable text box.
If the Item itself is more complex, you can make it its own Category, and then create Items within that Category. It all depends on the organization that you require.
Main Screen Text
The Category pull-down menu, beneath the large display box, lists all Categories. The Item pull-down menu lists all Items for the currently selected Category. The large edit box displays the content of the currently selected Item.
You can switch spellcheck or the keyboard on/off, and to edit data, type in the large edit box, then press Save.
Swipe horizontally to toggle between text and an associated photo.
Main Screen Photo
To associate a photo with an Item, open the main menu and select Get Pic. Choose a photo. To toggle between text and photo, simply swipe left or right beneath the edit box or photo.
When you associate a photo, the original is copied and reduced to a size appropriate for your display.
To replace an existing, associated photo, repeat the process of selecting a photo. To unassociate, select Delete Pic from the Main menu.
This is where you add new Categories or Items. Each Category can contain many Items, and both have a maximum length of 12 characters.
When you enter a new Item name and press Save, you are sent back to the Main screen to enter your content. If you entered a new Category it is automatically created along with the new Item.
To duplicate an entire Category select Duplicate Category from the device menu.
The Full View screen provides a larger viewing area for content. From the BaylaDex Main Screen open the device menu and select Full View.
This opens the Full View screen, which provides a larger display area. You can switch spellcheck or the keyboard on/off. If editing is not needed, toggle the keyboard off.
If a photo is associated with the text it will automatically display.
Import or export a content file from this screen. The file can be encrypted or not, and can be created via the export function, or can be created on a PC in a specific format.
To export, enter an Export Filename, and choose a Category to export, or All. If you choose All, your entire database will be exported to a file, useful for backups. To encrypt the file, enter a File Password to be used to open the file.
For import, choose to overwrite or skip.
Import from Excel
Like any technical process, creating a file in Excel and importing it into the BaylaDex may seem daunting, but it is actually fairly simple, and given practice, will become second nature. The following takes you through all the steps.
Create the Excel File
To create a file in Excel for import into the BaylaDex the file structure is critical. The steps for creating the file using Excel are as follows:
- 1. Create a new Excel worksheet
- 2. Enter these headings: CATEGORY, ITEM, DESCRIPTION, ACTDATE.
- 3. In each subsequent row enter a Category and Item in the appropriate column, maximun 12 characters each.
- 4. The Description is your content. Use the Excel editing box at the top of the screen, and expand its height for better readability.
- 5. For each row enter a date under ACTDATE, in the format 12/25/2014.
- 6. Save the spreadsheet as a csv file using the File, Save As menu in Excel.
- 7. Save the file as bd_nnn.csv, where nnn is your choice.
The file is now ready to send to your device. Note that you can have many duplicate Categories, but Items must be unique within a Category. You can have duplicate Item names in different Categories.
There is no definitive limit as to the length of the Description, which is your actual content. However, if it is very long, you may want to consider breaking it into more Items, or even new Categories.
Email File to BaylaDex
The steps to email the file are shown below, but you can use whatever means you are comfortable with to move the file from your PC to your smart device. In the end, the file must end up in this folder on your device:
It must be named like this: bd_nnn.csv, such as bd_myimport0813.csv
- 1. Name the file bd_nnn.csv, all lower case (replace the the nnn as desired).
- 2. Email it as an attachment to your Android.
- 3. Copy or move the attached bd_nnn.csv file from the Download folder to this folder: Android/data/baylapublishing.bayladex/files/import/.
- 4. From the BaylaDex Filer screen press the Import pulldown. All available files should be listed.
- 5. Select the desired file. It can now be imported into the BaylaDex.
An import file with the correct structure and name must be in the import folder on your device. To verify, you can use a file manager app to navigate on your smart device. The required location of the file is:
If it is in the correct location, and is named properly, it should show up in the Filer screen Import pulldown. To import it into the BaylaDex:
- 1. Go to the Filer screen. Indicate if encrypted. Only files of the type specified will be shown.
- 2. Select a file from the Import pulldown.
- 3. Select Replace or Skip. Replace overwrites any existing Category/Item combinations. Skip leaves them intact, but adds any new ones.
- 4. Press Import. The file is loaded into the appropriate Categories/Items.
A message should appear indicating how many records were processed.
You can create all of your content within the BaylaDex itself, but sometimes it is convenient to work with your data on a PC. In this case, you can create a file from Excel, and save it as a csv file for importing into the BaylaDex.
When importing a file into the BaylaDex you can specify whether to overwrite or ignore existing records, so it is an easy matter to incorporate files from others into your own BaylaDex without deleting your existing data.
For this same reason, it is easy to share your content with another BaylaDex user, and the data can be encrypted or unencrypted. Just send them the file, tell them the password, and they can import your data. It will have to be stored in the correct location on the Android device for the import to work.
We are a participant in the Amazon Services LLC Associates Program, an affiliate advertising program designed to provide a means for us to earn fees by linking to Amazon.com and affiliated sites.
© 2020 Bayla Publishing LLC