Excel Import - Overwrite instead of append

[cgilliss]

Hi All,

I have 2 action buttons on my grid...."Export to Excel" and "Import from Excel". This is useful as it is easier to do mass updates for the user. Unfortunately, the file appends to the database upon upload. Is there an option to overwrite the DB instead of appending? If so, where do I find it? If that option does not exist, how can I solve this appending instead of overwriting problem? Any assistance would be appreciated. Thanks.

Chris

[cgilliss]

Re: Excel Import - Overwrite instead of append

Bump. Anyone?

[swksys]

Re: Excel Import - Overwrite instead of append

Chris,

You could execute a function that empties the file before importing. One of the videos on V10 feature pack v10FP12 has a sample function to delete. You can do it on Server Side or add an action button to do it.

a_tbl = table.open("upif")
a_tbl.delete_range(.T.)
a_tbl.close()

I use a ajax callback action button to clear selected records with Xbasic Function under Code.

Function Clearpoll as c (e as p)
dim t as p
dim mco as c
mco = e.rc.session.__protected__Ulink
t = table.open("transaction")
t.fetch_first()
while .not. t.fetch_eof()
'If t.co = mco
t.change_begin()
t.delete()
t.change_end()
'End if
t.fetch_next()
end while
t.close()
end function

I have the If and End If commented out because I can not get the session variable to work.

[Al Buchholz]

Re: Excel Import - Overwrite instead of append

Look at table.zap if you are emptying a dbf table - truncate if an SQL table.

The process of deleting all records takes a longer time while zap/truncate is fast regardless of the number of records in the table.

Also deleted records remain in the table until a pack is executed. Zap/truncate moves the end of table marker so all records are removed in a simple process.

[swksys]

Re: Excel Import - Overwrite instead of append

Yes, zap is way I go if I want to delete all records. But if you are importing into a table with multiple company data and you only want to delete one specific company, then reading through whole file and deleted only records is the only way I know. If you have a better way to do it, I would welcome it, as I can not get session variable from logon to work.

[Al Buchholz]

Re: Excel Import - Overwrite instead of append

Yes, zap is way I go if I want to delete all records. But if you are importing into a table with multiple company data and you only want to delete one specific company, then reading through whole file and deleted only records is the only way I know. If you have a better way to do it, I would welcome it, as I can not get session variable from logon to work.

I was answering Chris's question. Your post looked like an answer to Chris's question and didn't state the multi company issue - let alone be a question.

[swksys]

Re: Excel Import - Overwrite instead of append

Al,

1. I was agreeing with you. 2. Just commenting as to why I suggested reading through a file. 3. Was hoping you would see why my check for a selected company did not work.
Don't understand the reason for you to be nasty.

[Al Buchholz]

Re: Excel Import - Overwrite instead of append

So you are mixing another thread where you still have a question into this thread where a similar but different answer is needed..

This causes confusion for the original poster in this thread and is not good form.

The forum works better keeping questions and answers focused on the problem at hand.

[swksys]

Re: Excel Import - Overwrite instead of append

I can see why that can create a problem. I will keep that in mind for the future. Thanks.