Importing from Bento – no records present

Tap Forms – Organizer Database App for Mac, iPhone, and iPad › Forums › Using Tap Forms › Importing from Bento – no records present

Viewing 17 reply threads
  • Author
    Posts
  • August 2, 2014 at 7:37 AM #10583

    Christine Murdoch
    Participant

    I have just started using Tap Forms and have quite a strange issue. I can import templates complete with records from Bento, providing the original library was not in a folder or does not contain a collection. I have tried moving the libraries out of folders and restarting Bento, but that still does not help. Tap Forms does import the template, but not the records which is what I really need.
    Any help would be appreciated. Many thanks.

    August 2, 2014 at 8:32 AM #10584

    Christine Murdoch
    Participant

    I can work round this by exporting a cdv file from Bento and importing that into Tap Forms.

    August 2, 2014 at 10:48 AM #10586

    Brendan
    Keymaster

    Hi Christine,

    You will need Bento version 4.1.2 in order to export the records along with your template.

    There’s a link to the Bento 4.1.2 download in the online user manual.

    Thanks!

    Brendan

    August 3, 2014 at 5:33 AM #10587

    Christine Murdoch
    Participant

    Hi Brendan,
    I am using 4.1.2 – some seem to work and others (especially libraries which were in folders) don’t.
    Christine

    August 4, 2014 at 9:14 PM #10593

    Brendan
    Keymaster

    Hi Christine,

    Hmm… If you’d like to send me a sample I can take a look at it for you.

    Thanks,

    Brendan

    August 5, 2014 at 6:34 AM #10597

    Christine Murdoch
    Participant

    Dear Brendan,
    I have taken a screen shot of Bento before I tried to import to Tap Forms. I was able to import the libraries “St Modan’s Roll”, “Craigrownie Roll” & “Garelochhead Roll”. None of the other libraries imported the records along with the library. In other words I had the library with no records. I don’t have a screen shot of those as I deleted them, exported the Bento libraries as CVS files and then imported to Tap Forms.
    Thanks

    Attachments:
    You must be logged in to view attached files.
    August 5, 2014 at 1:49 PM #10599

    Brendan
    Keymaster

    Hi Christine,

    Well that’s very strange because I know that Tap Forms can import libraries that reference other libraries. Although I’m not sure about importing libraries that are represented by a folder. For example, you have a folder called Music. But you also have a library under it called Music List. If you just export Music List as a template, I would think that should import properly.

    Thanks,

    Brendan

    August 7, 2014 at 10:08 AM #10606

    Christine Murdoch
    Participant

    Hi Brendan,
    I tried importing Music List as a template, but none of the records were imported to it. I tried removing Music List from the folder and then importing and that didn’t work either.
    As I say I have been able to work round it.
    Thanks
    Christine

    March 19, 2017 at 8:54 AM #21563

    George Middleton
    Participant

    I’m having a similar issue using Tap Forms 5 where no records are imported from a Bento 4.1.2 .bentoTemplate file.
    As shown in the attached screenshot, the import completes “successfully” but also returns an error message. After the import, the “Pick Lists” sheet does show 5 of the approximately 20 different “choice” type fields in my Bento db with their corresponding values, but that’s about all I see that was imported… No actual records at all. Any thoughts on what to try to achieve a successful import?

    Attachments:
    You must be logged in to view attached files.
    March 19, 2017 at 9:44 AM #21578

    Brendan
    Keymaster

    Sounds like a problem with the embedded Template.xml file that’s inside the .bentoTemplate file. I would need to take a look at it to see exactly what the problem is. Probably just an invalid character at that location described by the error message.

    March 19, 2017 at 5:37 PM #21579

    George Middleton
    Participant

    I could put the file in Dropbox for you to take a look at; it’s 39MB.
    If so, what email should I send invite too?
    Thank you!

    March 19, 2017 at 10:10 PM #21581

    Brendan
    Keymaster

    Just use my support account. support@tapforms.com

    March 20, 2017 at 7:24 AM #21605

    George Middleton
    Participant

    Thanks Brendan, file is in DB.

    March 20, 2017 at 12:33 PM #21611

    Brendan
    Keymaster

    I corrected the Template.xml file embedded within the .bentoTemplate file. Had to remove a bunch of invalid characters. It imported fine after that.

    March 20, 2017 at 4:14 PM #21614

    George Middleton
    Participant

    Thank you so much Brendan for the rapid support response!

    All is fixed and I’m up and running, learning how to edit my layout as we speak.
    Who would have thought the export file from Bento would have contained invalid characters?!

    March 20, 2017 at 8:02 PM #21620

    Brendan
    Keymaster

    Ya, I’ve seen it quite often actually. I think it happens on input, possibly from copying and pasting the values from some external source. But then when the Template.xml file is exported, they’re not stripping out invalid characters. So anything that reads it during import causes the import to fail on those characters.

    June 27, 2017 at 12:19 PM #23613

    Cedric Van Tenten
    Participant

    hi,

    I have the same issue here. My library is not complicated, I don’t have related libraries or something.
    Just a simple comic book lib and a DVD lib. I can try to export an excel and import it to Tap Forms 5 Mac but then I don’t have the images of the covers.

    Thanks in advance for your help!
    kind regards
    Cedric

    June 27, 2017 at 12:51 PM #23614

    Brendan
    Keymaster

    Hi Cedric,

    Would you like to email me your Bento template and I can try and import it to find out what is causing your trouble?

    Thanks,

    Brendan

    September 12, 2017 at 7:37 PM #24550

    Charles Kouns
    Participant

    I am having a similar issue… I export one of my libraries from Bento onto my desktop (i clicked the include all records). I go into TapForms and open the form that I want to import the file into. I have set this form up with exactly the same fields. Upon completing the import, which it says it has done, nothing shows up in the file nor can I find it anywhere else.

    What am I doing wrong?

    Thanks

    Charlie

    September 12, 2017 at 8:08 PM #24557

    Brendan
    Keymaster

    You don’t have to create a form to import into. You only need a document. So setting up the fields the same as in Bento is not required.

    Check to see if the form is hiding inside the Uncategorized category or another category. Click the button to the right of the category name to expand it. You should see them there.

    September 12, 2017 at 8:16 PM #24559

    Charles Kouns
    Participant

    Brendan — thanks — there it was. I somehow got from what I was reading is the help stuff that you should create the form first. Now I know what to do.

    Many thanks for the amazing response.

  • Author
    Posts
Viewing 17 reply threads

You must be logged in to reply to this topic.