empulse, about the connection string;
you are right: if you use the settings variable from the web.config as the Application connection string it will not work of course to import the fields.

That's why i made it pop up asking for the connection string.

again sorry for not getting this on time. i do not get notified for replies anymore.

wonder why

Hi Talal

I updated to 1.9.8. something like that <img src='desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'> and while I'm not getting any errors during loading of your generated LPs, I'm not seeing the tabs being installed. They're in the .zip.

Any ideas? BTW, I also upgraded to DNN 4.6.0

hmm in that case i am not sure.
By the way; the application is still Work in Progress for example the WYSIWYG is not functional yet (i need help on that).

What field types did you use?

Can you provide more information?

Did it ever work for you?

Thank you

Talal,

I have the majority of the WYSIWYG using TinyMCE coded. I have the control itself as well as the header javascript.

I still need to work on the Listx configuration settings code, which of course will be conditional to using the control.

You're welcome to what I have now if you like or I will send the completed once I get it.

-e

Hi Talal

Check your email - I sent you the simple LP.

myearwood,

You might want to double check your installation version. There were LP install errors in versions prior to 1.9.8.8 - note the last "8" is important to the fix.

hth,
-e

Hi emaynard

I was kidding. I have 1.9.8.8 - it's just more digits than I expected <img src='desktopmodules/ntforums/images/emoticons/smile.gif' height='20' width='20' border='0' title='Smile' align='absmiddle'>

OK! Finally I got Talal's builder to do stuff!!!! I did two LPs with it in about 10 minutes. That's more like it! Talal that's pretty good stuff. Now to integrate GoMap with it. Basically what I want to see is the currently displayed records in the list appearing in the map.

Where can this be downloaded?

http://symphonyoffire.com/ListX/tabid/368/Default.aspx

I'm seeing an error when I try to install the LP;
"The format of this file does not appear to be a ListX Package, or a configuration of any kind. Please try another file."

I'm using Access 2007, is that the problem because the generator seems to work fine except for this issue.

i think you did not zip the files properly.
please do not zip the folder.
Zip the content of the folder.

so that the package zip file contains the files.. not a folder

You are so right, that made the difference! Thanks for your work on this, as a beginner it helps me to get a better understanding of how Listx is working.<img src='desktopmodules/ntforums/images/emoticons/biggrin.gif' height='20' width='20' border='0' title='Big Grin' align='absmiddle'>

Has anyone gotten this to work with Access 2007? No matter what I enter, it throws an error and steps into debug. This seems like a great tool, but I can't get it to work.

For example I would like to import an existing table, but a null error shows up and says the connection string is empty. When I try to manually add the columns, it allows me to enter the information and click save but doesn't save any of the data.

What am I doing wrong here?

<img src='desktopmodules/ntforums/images/emoticons/whistling.gif' height='20' width='20' title='Whistling' align='absmiddle'>

Never mind, I'm an idiot. Getting the connection string right is the key to everything...sorry.

I've used this to set up a simple listing with data entry, etc. Just the basics. What I tried to add was a message being displayed with the status of the save so there would be a "yes it saved" or "no, something went wrong" type message shown to the user after they save an entry. I have been trying to figure this out for several days now and nothing is working except that the message actions are created just fine. I've verified that by setting a session variable to contain the values of the [aMessage,Action] messages. I've tried placing these messages in the main listing as well as the edit module and they are never actually displayed on screen unless I display the session variable. I then tried working around the problem by displaying the session variable which works fine, but I couldn't figure out a way to display the message once and then clear it the next time the screen refreshed; it just stays there until the session is cleared which is what a session variable should do. So, not being a programmer as much as a designer, what would anyone advise be done in regards to just showing a simple message that clears when the view is refreshed? I have tried everything I can think of including adding a new module that displayed the session variable with the message data, and was fetched with an action call that would set another variable [MessageShown,S] to 0 causing the message to no longer be displayed until the save routine ran again and changed it to 1 again, but again I could not get the action message monitoring stuff to actually "hear" the action message. In a nutshell, something simple has turned into a complete nightmare. Any advice on how to approach this???

Thanks,
Rick

Hi there

I would strongly advise against adding a Yes it saved message. Once the record has saved or changes have been made it should update the list, so the user should not need more confirmation than that. Besides that is just another click to make which slows down data entry.

Beyond that I don't know how to handle such messaging off the top of my head.

What do you do after saving?
options:
1. create a "thank you" page and direct there is saving is successful or "sorry unable to save" page for errors.
2. if you are opening an existing record pass a flag as a URL (or session variable) then check for the flag and display the msg accordingly.


Do not forget to clear the flag session variable after each use.

If you need a small example on each way please create a small ListX XML and i will change it for each scenario

myearwood,

The list doesn't update with the new addition included if you require approval before the record is "posted" to the live data. This is a links listing that allows site visitors to add their own link. So, I was going to have a confirmation or error shown to let the user know something happened so they don't post a hundred times before reading the small print about posts needing approval before they will show up in the listing. Hence, the logic behind giving them some kind of result message so they know something did indeed happen when they pressed submit. It's also sending an email to the admin to let them know a record was submitted, so some error trapping feedback there is also needed in case there is a problem sending the email. If any errors, then contact admin, but without an error message they'll never know to do that.

Talal,

I tried passing a flag but couldn't get the flag to clear after the message appears once because the data refreshes and clears the flag before it's seen, or it was stuck "on" because I couldn't get the lxfetch to process with an action message telling it to turn it "off". It's not just for one record, it's for the inline edit and add in the entire listing. What I had tried to do was use a lxfetch for displaying a message and maybe that was the wrong approach. I just couldn't find the right combination setup that worked.

It's not opening an existing record. Well, actually, for the user it is when adding a record. For the admin, it's receiving error messages after approving the record. I've attached the xml files for the listing and the edit modules for the admin process. I don't have any type of message trap set up now, but am able to do that and assign the value to a session variable with no problem. The admin approves the record and, it's not in the code yet, but an email will be sent to the submitter letting them know their record was approved by admin, so again, I'd like any error messages shown to the admin in case there was a problem saving the record or emailing the submitter with their approval notice. I can catch the error messages in a session variable, but how would you approach setting a flag to show the message once and then not again when the data listing updates after the record is saved? What I had in the actions was the execute save, send email, then set a session variable to the errors, then set a flag to 1. Then in the listing I had an IIF that would show the session variable containing the error if the flag = 1. But the page refreshed and looped through setting the flag to zero again before ever actually showing the message. So, I tried adding another module that contained just the error message and changed the IIF in the listing module to do an lxfetch if the flag was 1 and I tried to add an action message in that lxfetch which would then turn the flag to 0. But I couldn't get any of the modules involved to "hear" the action message. The lxfetch worked fine and brought the message into the listing, but that was it, the "message" to process the session variable assignment was never heard or executed, with the actions contained in the listing module, the edit module, or the message module and I just finally gave up. I could do the redirection to a custom error page that displays the message, but it would be preferrable to have the message just show up on the page the user is on. So, how do I approach this? Or better, how would you do it? My logic wasn't working at all.

Thanks for any input or advice,
Rick

1. on the calling page save to a session variable. (eg. sResults)
2. The called page:
a. set sResultsTemp session variable to the value of sResults
b. set sResults tp nothing
c. use sResultsTemp on the page to display the message