Quick Tip: Manually restructuring databases

Manually restructuring databases

If you are noticing item placement compatibility issues between your Paper Tiger database and your actual database, it is probably due to the fact that you may have erroneously inserted an item into a random location which forces the remainder of your reference location to be out of sync.

Here is a quick tip on how to manually sync your database to its proper form.

Our location of choice is named "Bottom Drawer" within the "Atlanta Office" database

1. Create a new location and name it "Bottom Drawer Temp"

create_location.png

2. Open the old location "Bottom Drawer"

3. Locate the first file that seems to be causing the reference incompatibility.

find_X.png

4. Select all the files prior to that and duplicate these files into "Bottom Drawer Temp"

i.e. If item 5 is the item that is causing our database to be off, Select items 1 - 4

duplicate_before.png

6. Select all the files after the misplaced item and duplicate these files into "Bottom Drawer Temp" (Should be the remainder of the location)

duplicate_next.png

8. Delete "Bottom Drawer"

delete_location.png

9. Rename "Bottom Drawer Temp" to "Bottom Drawer"

rename_temp.png

Our newly manufactured location!

finished_transform.png


Can't find the right answer?

  • Contact our support team and we will personally get back to you as fast as we can.