KM and Databases? CSV, mdb...

Hi Wilbert and Bret,

I loaded the fun file and the *.csv file!
But when I play it in web browser nothing happens!
Everything seems to be ok, Action Script... but only a blanc screen!
I also add the code from Bret...

I do not understand why?

Most likely you are not using Internet Explorer and your flash player is version 6 or 7. The example I created requires flash 8. IE checks the required version KM exports in the html code and will inform you to upgrade but browsers like FireFox don't do that.

KM 5.3 will have an automatic actionscript based check. As soon as you use a flash 8 component and someone with a flash 6 or 7 player wants to view it a warning message will be displayed.

Hi Wilbert,

I have the Internet Explorer!
My KM Version is 5,2,3,0
I am using Flash player 7
That means people with Version 6 cannot read this Data.
With my machine XP there was no message!
Could it be that a lot of People do not see any message? They see a blanc screen?
Do I have to download the Player 8 from Macromedia or is there
another possibility for User with older Versions?

I don't know why IE didn't warn you.

Attached is an updated zip file. I included the swf file created with the 5.3 beta so you can see how it will be displayed in the future if flash player 8 isn't present. I also included a modified v6 version for flash 6. There is a flash 6 version of the listbox but I consider the flash 8 version of the listbox to be superior with a better internal architecture compared to the flash 6 version.

Thank you so much for today!
Tomorrow morning I will try all posibilities!
I let you know...

It was a hard day (with me...) and you helped me so much...
1000 Thanks Wilbert...
and of course Bret and all the other Heros here...!
I need my bed now...10 houres KM let me sleep...

Good Morning Wilbert,

I hope you had a good sleep
7:00 am I try to open your files but some error are there:

1. csv2listboxv6.fun can't loaded
Message:...KoolMoves Version later than the current one!
unknown tag $bo$
2. I have the Version 5.2.3

Import SWF File

I tried to loading the smf File, but I see only 2 Textboxes

Version 8 csv2Listbox.fun is possible to load in Version 5.2.3

Could you send me the code of Version 6, then I try to laod
your first example (version 8) and replace there the code.

Another Day with Errors (the Best Friend of us...)

Bye Uwe

Quote:

---

Originally Posted by Uwe S.

KoolMoves Version later than the current one!

---

My mistake, I accidently used the 5.3 beta. Try again with the zip file attached to this post.

Quote:

---

Originally Posted by Uwe S.

I tried to loading the swf File, but I see only 2 Textboxes

---

Didn't you see any warning message displayed in red ?
The textbox in the center of the movie should contain a warning message. :confused:

wow...it is working!
Thanks so much Wilbert
Great... :thumbsup: :thumbsup: :thumbsup:

One queston..
Is that possible?

If I have a picture path in my *csv e.g. c:\Pictures\Product.jpg

Could I see this picture too like the text information? We have hundreds of images and it would realy safe a lot of time.

Yes, it's possible to load external images.

I don't know what format they are in. If you have also images in png format or any jpg files that are progressive jpg's you have to switch to flash 8. If you would use flash 8, you could use the content pane to easily load and display those images. You can also try the flash 6 content pane or create your own image loader.

Can you please answer my question also ?
Didn't you see a warning message in one of the boxes from the swf file I included ?

Hi Wilbert,

I have imported your swf and played it in Web browser with KM
I see 2 boxes "without text"! There is NO warning message!

One Picture question with contentpane1:
I changed the csv File as follow:
I made a Field Picture and the entry is c:\picture.jpg

1. I drag a contentpane1
2. I changed your code to: _root.contentpane1.setContent(4,v,0,0.5); ???

but how can I change the code to the csv that I can see the picture?

I'm totally confused :confused:

If you can see and use a flash 8 contentpane your flash player has to be flash 8. If it isn't you have to use the flash 6 version and in that case setContent(4,v,0,0.5) won't work.

I viewed the file I created with flash players 6, 7 and 8 and both 6 and 7 display a warning message at my computer. If anyone who reads this post has flash player 6 or 7 installed and wants to try please do so and let me know if you see a warning message. It's important for me to find out why it isn't working.
http://www.waterlijn.info/km/csv/test/index.html

Wilbert

Hallo Wilbert,

I have installed the player 8 from your link!
And a "message appeared" to install Player 8 I did it!
And... I can see all the Data!
KM can read all your files too

But, please help me with the code for the Picture in my csv file!
I am confused too...

Didn't Wilbert give you many examples in your earlier Listbox threads? Are you taking the time to absorb them and understand them or just more comfortable posting a request that is always fulfilled?

Here's proof it can be done
http://www.waterlijn.info/km/csv/test/csv2listbox2.html

Assuming you are using the flash 8 code now, your images are in the right subdirectory and you dragged a contentpane on stage you just count the field number and use that to set the content

Code:

---

lv = new LoadVars();

lv.onData = function(src){
 
 records = src.split('\n');
 items = [];
 
 for (var i = 0; i < records.length; i++){
  var fields = records[i].split(';');
  if (fields[0] > 0){
  items.push( {label:fields[1]+' <font color=\'#808080\'>[ #'+fields[2]+' ]</font>', value:fields} );
  }
 }
 _root.listbox1.setItems(items, false, new TextFormat('_sans',12), true);

 _root.listbox1.onChange = function(v){
  _root.txt1.text = 'Nr : ' + v[0];
  _root.txt1.text += '\nArtikelnummer : ' + v[2];
  _root.txt1.text += '\nBeschreibung : ' + v[4];
  _root.contentpane1.setContent(4,v[8],0,0.5);
 }

}

lv.load('myData.csv');

---

Hallo Chris,

this is not what I want to do!
I have realy problems to understand the komplexibility...I do not get ahead
I worked houres and houres on this problems with csv Files...
For you: since 7:00 am this morning

I regret that you think in such a way
Again thanks at Wilbert and its patience with me and to all others...

You've shown no attempts. You ask and he provides. He is little by little building your whole sales routine and most of this you yourself have asked before..especially as it pertains to listboxes.

As all of this will be used for your business, you'll have to forgive my not feeling bad for pointing out you are not asking for support....you are always asking for code.

Your post history speaks for itself.

Dear Chris,

this is not like you are thinking...!

Buy a Software which is completely in Spanish and you as an English man should write a code "which is completely in spanish too" and you will try and read and have of course big big problems too.
For you it is very very easy and you think I do absolutely nothing?

You and all others here helped me a lot! Again to all THANKS.....

:hug: If I have the solution and it works I will post the solution for all foreign people which can feel like I do.

Uwe

I have helped you in the past so I'm not being biased. Spanish is such a common language in my country, almost all things have a spanish translation. I think you rely on that excuse...it's convenient. It's working for you.....as your post history shows.

ok Enough on the off topic rant....

Dear Wilbert,

I have in the meantime a bad conscience to ask you again:

I have flash code 8 now and I can see your beautyful example
But it doesn't work: I am realy confused

1. I changed the entry in my csv in the Field NR ( c:\picture.jpg)
2. I have a contentpane1
3. I changed the code...
but It doesn't work...
My contentpane shows only a! I tried other contentpane with pictures they work....

1. I changed the onchange Event in the Listbox (no chance...)

This is the csv..
Nr;Name;Artikelnummer;Kommentare;
C:\Picture.jpg;.....
It should work...?
I copied the picture in the folder where the fun file is....it doesn't work!

And I changed the Header of the csv....it doesn't work!