Is it possible to restore/import an excel file?

Is it possible to restore/import an excel file?

Hi Shawn,

Yes, but not using ChronoForms alone. Set up a form with an empty table in ChronoForms then use a MySQL tool to import the data. I think PHPMyAdmin can do this, if not then there are other tools that can do so.

Bob

PS You may need to export the Excel file to CSV first.<br><br>Post edited by: GreyHead, at: 2008/02/22 10:15

Hi,

You may try a popular Excel file recovery tool called Advanced Excel Repair to repair your Excel file. It is a powerful tool to repair corrupt or damaged Excel files.

Detailed information about Advanced Excel Repair can be found at http://www.datanumen.com/aer/

And you can also download a free demo version at http://www.datanumen.com/aer/aer.exe

Alan

Hi Bob,

I upgraded to v2.3.8.1. Prior to doing this I backed up my forms. After upgrading I restored them. It appread that all of them have the right data except one that had 350 records, it now only shows 25. I saved the data in an EXCEL file and wish to repopulate, import this data from the EXCEL file?

I searched the Forums and found this post, but it is not clear enough for me to follow. Also, I am not fluent in MyPHPAdmin.

Can you help me through this?

Thanks,

Mike

Hi Mike,

Open this form and check the AutoGenerated code, it should have something like this :

INSERT INTO jos_chronoforms_1 , the "1" may be any number actually but it should equal the form id, so back to the form management page, assure that this number is the same as this form id!

Let us know if this fix it or not!

Cheers

Max

Hi Mike,

If you like, export the 25 records to a new Excel file than send me that and the 350 record file to the address in my sig and I'll merge them for you.

Once that's done you'll need to either use a Restore command in PHPMyAdmin or to drop the current table and recreate it with the merged file.

Bob

Bob,

As usual you are on the ball...thanks for being so fast to respond.

I took an entirely different tack.

Uninstalled 2.3.8.1 and reinstalled the old version 2.3.x.
Restored the forms, but the data in only 1 form is correct. The news is it was the 350 record one. For the others, I notices a new FORM ID is created when I import the BU form, while this is true I can import via the myphpadmin database backend, but this is not fun. Was wondering if I can change the FORM ID # in the myphpadmin database backend? I could not find a way to do this and was hoping if I did that, then inport the form backup the data would also appear. Plus as anal as I am going from FORRM ID 1 to 16 is killin me, as opposed to 1, 2, 3 etc.

Hope this makes sense. Should have left well enough alone and not tried to upgrade to 2.3.8.1, my inexperience caused me lots and lots of sleep and pain to get only 5% recovered.

Thanks in advance to you and Max for your great support.

Mike

Hi Mike,

The Form ID is a serial number used which shows the record number in the ChronoForms database. When you Create a table ChronoForms uses the FormID to create a corresponding database table - but I think! the only place this is used is in AutoGenerated code. So, as long as the Autogenerated code and the table name match up you ought to be able to call your table anything you like. (Test carefully before use!)

Bob

Bob,

Hey...

Hummm...

Changed the Autogenerate from _13 to _3 and nothing changed. Ideally wish to RESET the FORM ID #.s

See the gif file.

I am not being clear and perhaps goofy.

Mike

Hi Mike,

You have to change both the database table name and the AutoGenerated code - they both have to match.

But neither of these will change the form ID!

If you must (not recommended, certainly not guaranteed - but it seems to work OK) go into PHPMyAdmin open the jos_chrono_contact table and edit the id column. Make sure that there are no duplicates!

Note: this will have no effect on the form tables - BUT if you create new form tables then you run the risk of a conflict.

Bob