Access mdb files aren't possible without a server side language since they are binary files. CSV files can be read using the LoadVars class. Maybe you can be a bit more specific about what you are trying to accomplish.
Thanks...now
I have in my Database many Products... with Prices, Infos and many Picturepaths...
I have from these Products a csv File!
Can I load a Field (from my csv file) in a Listbox to select and then link to a page?
Example:
Product A with 10 Fields (Price, Info...)
Product B with 10 Fields (Price, Info...)
Product C with 10 Fields (Price, Info...)
KM should now import these Products (Infolist to click...) in a Listbox named Products
The Listbox should select Product A and link to the Main-Infopage with these 10 Fields (Price, Picture, Infotext....
We have many many Products...that means a lot of work....
It's possible but how easy it will be depends on the complexity of the database.
When you use the LoadVars class, it's onData event is triggered as soon as the file is read and passes the entire file as one big string. That means you'll have to do the field conversion yourself. Normally you'll first use the String.split function to split it on \n (line feed). After that you have an array where each item contains a record. Then you split each record into fields. If the delimiter is always "," it's no problem. If it sometimes is , and sometimes "," it becomes more difficult because if you would split on , you would also split a string that contains a , as part of the string and not as a field separator.
How many records does your database contain ?
If it's very large it might take the flash player a little time to process the data.
Thanks all...
Germany 7:30 in the morning...KM is running...
My csv List shows some fields like:
Nr;Name;Artikelnummer;Kommentare;Beschreibung; There are 300-500 entries...
Could you send me an example...? LoadVars class...? Difficult to understand ( Germany..) If it is to difficult, it would help me, if there is a possiblity to load data
from 1 field in a listbox. Then I would to the rest yourself
Bye
Uwe
P.S. My server can run csv Files and php...
It seems like you are using ; as a field delimiter.
Here's an example
Code:
lv = new LoadVars(); // create a loadVars object
lv.onData = function(src){ // set the onData function
records = src.split('\n'); // create the record array
for (var i = 0; i < records.length; i++){
fields = records[i].split(';'); // split record into field array using ; as a field delimiter
records[i] = {label:fields[0], value:fields[2]}; // replace a record with a label and value for the listbox
}
_root.listbox1.setItems(records); // set the listbox items
}
lv.load('myData.csv'); // load the CSV file
In the example I'm using the first and third field as label and value for the listbox. Of course you can use other fields. If the csv file starts with a line that shows the field names you have to start at var i = 1; to skip the first line.
but where exactly must I place this code?
At Frame action?
Yes, you attach the code to a frame where the listbox exists.
You will also have to set the onChange handler of the listbox to do something when the selection changes. You can do that using the gui's onChange parameter or integrate it into the code example.
Ok ...I understand
I will try it....thanks...again
I posted today another big problem with images (Links...)
I would be very grateful, if you could help me! I can not fix it...
Wilbert won't he need to add src= to the begining of the csv file?
No, that would be if you use the onLoad event. The onData event proceeds that. When you set an onData event you can process any entire file that's not binary encoded. That's what makes it so powerful
Uwe, Can you post a csv with the structure you are using without information that's important to you, It should be something small but without the fun or csv file I can't tell you what it is.
Chris, Bret and Bob do a great job moderating. Being a mod isn't my desire. It takes a lot of time since one has to read all posts and posting in english still takes me extra time since it isn't my native language.
all here are great and do their best!
We have to translate...and it is sometimes realy hard...
I included a Standard *.csv File for you
This file is working with other applications very well.
I can import it without problems.
Could it be on the header:
something like this
"Produkt-ID";"Bezeichnung";"Preis";"
thank you so much... It is not possible to upload *.csv (rename the file...to: wilbert.csv)
It's working you just need to understand what Wilbert has done in his code and go from there: I'll add comments
code:
//create a loadVars Object
lv = new LoadVars();
//set what to do when it has loaded it's data
lv.onData = function(src){//src is the a "pointer" to the data
records = src.split('\n');//This splits the text at each new line and puts it into an array called records
//So for example your records[0] would contain the first line of the text file
for (var i = 1; i < records.length; i++){//Now loop through the array and split it each again at each ;
fields = records[i].split(';');
now fields[0] will contain the first item in the first line and fields[1] will contain the second item
records[i] = {label:fields[0], value:fields[1]};//Here he's reusing the records array and putting in the label and value pairs you need
}
_root.listbox1.setItems(records);//Set the label and Value using the array
}
lv.load('myData.csv'); // load the CSV file
What he didn't show you was something to show that the values are there
Reply With Quote
Originally Posted by Uwe S.
