Import Options

(10 posts) (2 voices)
  • Started 1 month ago by roadrunner
  • Latest reply from roadrunner

Tags:

  1. roadrunner, Member

    Hello everyone, I'm new to myDBR and so far absolutely admire the functionality and integration possibilities with this reporting system. As I'm creating several reports and interfaces for my clients, I'm curious on just one small question thus far:

    Are 'xls' imports not available? I do see the ability to export as an 'xls' but haven't managed a successful import this way. Worst case scenario I require the user to save the file as an xlsx or csv.

    Posted 1 month ago #
  2. myDBR Team, Key Master

    The XLS format is so old that has largely been replaced by XLSX. We can add support for XLS import to the next builds, not a big deal.

    --
    myDBR Team

    Posted 1 month ago #
  3. roadrunner, Member

    Thanks! That'd be great- No idea why another piece of database software chooses to provide such an archaic format but such is life.
    I can resave the relevant files for the time being but so I know, how often do you mind myDBR is updated?

    Posted 1 month ago #
  4. myDBR Team, Key Master

    We new builds are created quite regularly (every few days). You should expect this feature in couple of days.

    --
    myDBR Team

    Posted 1 month ago #
  5. roadrunner, Member

    Also curious if it may be worth (or possible) to add some functionality in specifying which sheet to import from the document? Either via an index number or by name I imagine may be useful.

    Keep up the great work and excellent to know there's an active community and support forum.

    Much appreciated.

    Posted 1 month ago #
  6. myDBR Team, Key Master

    It would be possible yes. The challenge comes with more complex Excel documents with multiple sheets that usually they are no longer just data, but multiple sections with different calculations / cross references etc, so it might be bit tricky to define the section excactly which data to import and which one to skip / ignore. We can take a look if some kind of custom ruleset could be applied.

    --
    myDBR Team

    Posted 1 month ago #
  7. myDBR Team, Key Master

    The lastest build includes support for import Excel 97-2003 XLS and Excel 2003 XML formats. When importing, use formats "xls" and "xls_xml" respectively.

    --
    myDBR Team

    Posted 1 month ago #
  8. roadrunner, Member

    A bit of delay in response but thank you for the update. I went to attempt an xls upload today and noticed an error "Unknown format xls"

    Is there a particular way to ensure this update was appended to my install or was this functionality removed again?

    Thanks!

    edit: for reference, I'm using mydbr 5.2.6

    Posted 1 week ago #
  9. myDBR Team, Key Master

    What is the myDBR build version you are running?

    The xls-import capability was added into myDBR 5.2.6, build 3765. If you are running version earlier than that, just run the automatic updater.

    --
    myDBR Team

    Posted 1 week ago #
  10. roadrunner, Member

    Appears to be working now on the latest. Must have been a build I missed, thank you!

    Posted 1 week ago #

Reply

You must log in to post.