Forums

Hi, I have an existing data table with exact fields and hundreds of existing entries in excel. i cant change that table it gets imported into a filemaker database.

i created a new table off a form in v1.5 and it works great. BUT when i view the datatable in cf it shows three added fields
(cf_id, recordtime, ipaddress).
these do not match up to the original data and i cant add them into the excel table.
1. can i safely delete these columns ? my guess is no, since they are probably integrated into joomlas systems??
2. if yes great, if no then is there a way to change the code to prevent them from being written to the excel writer?

thanks! MM

Hi MM,

You can easily leave the recordtime and ipaddress fields out of the ChronoForms records. You'll need to drop the fields from the database table with PHPMyAdmin and then remove the corresponding entries from the Autogenerated code.

cf_id is more of a problem as it's the index field for the table. Do you have a record id in your existing database - perhaps this could be synched with the ChronoForms one??

Bob

hi bob thanks!
that worked great. i did match the id with the first id field in my database...
this is a great!!! component!!

Hi MM,

You may need to tweak the cf_id to match up. I think if you find the last value in use in your Excel sheet, then manually change the last entry in the MySQL table then the two *should* sync OK.

Bob

thanks for the hint... its working.
can you point me in the right direction to get the validation working in the new v1.5. is it working off mootools? is there any documentation relating to that? all i found is docs for the older version...
thanks!

Hi Minnie Mouse,

The validation is pretty much the same in both versions - at least up to 2.3.6. Max added the Mootools option for Joomla 1.0.x in 2.3.7 but hasn't yet released an equivalent for Joomla 1.5. I hope that this will come soon.

Bob