Import csv or xlsx files
Autor: Wagner A.
Besucht 2116,
Followers 1,
Geteilt 0
I need to implement a list of users with theirs name, first name and email adress.
The purpose is to have usser to have access to email adress of members, click onn the email and have the email input form open ready to type a message.
Any Ideas?
Thanks
AW
Gepostet am
Autor
I have the csv or xlsx data to be updated on a regulat base.
You could use a script that displays a csv-file in a table. The script should be able to have a field ( e-mail address ) as a link. When link is clicked then the users mail-program will open.
A script that is able to do this, can be found here : https://github.com/derekeder/csv-to-html-table
You can see a demo here : http://derekeder.github.io/csv-to-html-table/
The data is searcable. The index-file can be configured : Name of csv-file to use,link, delimiter in csv file and so .
In your project ( on the server ) you create a subfolder - could be csvdisp. You upload the files to this folder.
You upload the csv file to the data folder ( under the csvdisp )
In your X5 project you insert a html-object on a page. In here you specify an iframe where the source is the index page in the csvdisp folder.
You should then see the csv file as a table on the page and with the e-mail address as a link. When the link is clicked, the users email program should open and the email is inserted automatically.
This is not exactly what you described.
If you want to have the email parsed to another field on the parent-page then you will have to modify the script - or find another script.
Remember to specify the email with mailto:
Example : mailto:***
This will make the mailprogram open and set the mail recipient as ***
The mailto:*** can be specified instead of a "normal" URL.
When you have it to function, then all you have to do in future, is to upload a new csv ( replace ) - the system will then operate on the newly updated file.
No need to upload an entire project - just one file.
My example was changed by the system - forgot mailaddresses is replaced with **
Here it is as a clip:
Made a test here : http://eksempelsite.dk/csvtest/
In row 20 is the example.
You could also in the search field specify : park
Look what happens as you type - cool isn't
And here it can be seen in an iframe : http://eksempelsite.dk/sparta02/bullet-list---kopier3.html#Anchor03
Autor
Thank you John. I am not avaible tomorrow to test your scripts I wi;; do it during the weekend
I will let you know the results
AW
Autor
Good afternoon John,
After having a meeting with the board it has been decided to drop the ideas of publishing the name and email of member's . I try something else. I publish the names and email in a pdf format and it worked perfectly.
Thanks anyway for the info. I keep the reference for further use.
Regards
AW