Importing error Question

[schmutly]

Hi Thomas,
I know I'm doing something wrong here. I've made a video.
I am trying to add a category of drop-down choices (like I did with doc/sheet categories on my other apps and that
actually works as it's just showing a category in the table for people to choose say, Work, personal, other...etc.

What I'm trying to do in my TripManager is add a drop-down for different link types...like facebook, website, youtube, search, etc.
I don't want to use the drop-down 'editor' as you cant add items AFTER you create them from the ribbon, well..the customer can't.
So Jim, who used to be here had the workaround to use a text editor and have a one-to-many pointing at the gridform...and that still works today, which is good.
So I never noticed this during an import as I haven't tried to import data from a grid form with another gridform connected to it via a relationship.

In the import it sees all the data and "SEES" the mylinksss text editor in that gridform but gives this error:

Message :TypeConverter cannot convert from System.String.<br/>
StackTrace : at System.ComponentModel.TypeConverter.GetConvertFromException(Object value)
at System.ComponentModel.TypeConverter.ConvertFrom(ITypeDescriptorContext context, CultureInfo culture, Object value)
at TigerSoftware.Core.Helper.ImportHelper.SetProperty(Object item, String propertyName, String value)
at TigerSoftware.Core.Helper.ImportHelper.GetObject(Int32 indexRow)
at TigerSoftware.Modules.Controls.Importing.ImportWizard.<>c__DisplayClass15_2.<LoadMappedData>b__1()
at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at TigerSoftware.Modules.Controls.Importing.ImportWizard.<LoadMappedData>d__15.MoveNext()
Date :17/09/2023 1:39:37 PM

-----------------------------------------------------------------------------

Posting the video shortly,
Robbie

 

[schmutly]

Here's the video--> https://screencast-o-matic.com/watch/c0QbhxVCAu7

What am I doing wrong? I tried, out of desperation, all relationship types and noticed on a one-to-one it only shows the linkzzzz column.
Anyway...eerrr....help
Robbie

 

[TigerSoftware]

Sorry, I don't understand what you are trying to do here.

You have a one to one relationship that I see. When importing data, it is for the current form. If you want to import data into a related form, you will have to open that form and import from there.


Thomas

 

[schmutly]

morning,
sorry, i thought the video showed it clearly.. but thinking about it I have a better way to explain -->
Currently we have a drop down editor.We have to add the list of items to that editor from esb. there's no way for a customer to add more drop down items once the app is build.

So the only way around it up until now, which works perfect, is by having another form with just one text editor... then a one to many relationship, run esb to test and that added form has a drop down(we only added a text editor) with a 'new' button so you can add as many items to it as needed... so that's great, used it from V3 onwards.
Nothing's changed in V4 or that method so that's good however as you saw my list of links in the video I will delete them and supply as a CSV a small list to get started which they will "import" into that form.

I'm at work so I can't make another video but I guess the simplest thing is to ask:
Is there a way to add the drop down editor so that when it's built other items can be added?
I had one with a Mr,miss,Mrs,eat and allowed them to add as many as wanted. The method using a text editor in a form and adding it to the main form of field's via one to many works and always has... the trouble comes when you want to import those field's in from CSV...I completely understand that you can only import all the fields that match only with the editor in a FORM...i got that, but if i had 4 different drop downs in that other form that's pointing via relationship to the main form of urls i was trying to import it can't do it...I know it can't because you can only import to one form at a time, got it
That's why I thought just today Thomas to ask is there a way for that "drop down editor" in esb to be able to add other list items once we have clicked 'run' then when we click the drop down arrow for that editor it has my list but a new button to allow customers to add more to that list?

Thank you for reading and being patient with me and I hope and pray that it make sense
Robbie

 

[TigerSoftware]

Mate, I am the superman of software programming. Of course I could build a editor that allows the end user to add/remove options. Add a post in the wishlist so I don't forget.


Thanks!


Thomas

 

[schmutly]

Thanks superman awesomeness flows through your veins hahaha .... I'll add it to wish list , thank you sir🫡

 

[Mel Bel]

That's one of the main requests we get is for the user to have the ability to add/remove categories or other options in those box editors, so that would be great.

Mel

 

[TigerSoftware]

It's a great idea.


Thomas