contact  |  about  |  sitemap

how can add daily data from xml to a xls or dbf file ?
Last Post 25 Mar 2009 09:33 AM by iorgae. 3 Replies.
Sort:
PrevPrev NextNext
Author Messages
iorgae

--
18 Mar 2009 11:25 AM
hi ,
i'm newbie and i try to add into a single dbf file ( xls file ) a data from one xml page. this page is changed daily because is a exchange rate page.
my question is how to ADD data to the oldest data in my dbf ( xls ) ?
i realize a djs for a one single call a xml page but next day the data will be erase and replaces with a new data .
here is my file

xml_dbf_exch_data.djs

Tijn

--
18 Mar 2009 09:41 PM
Hi,

Currently Djuggler can write to an XLS file but it will replace all content in first sheet.

So what you have to do is: Import the existing XLS file into a data grid, then add your data to that data grid and next export it to Excel and overwrite your XLS file.

Or you can save all your data to a CSV file. You can use the Append Line to Text File action from the Text Files section to append a single line, without opening the the file.
This is the fastest way to write log files for example. Note you can open CSV files with Excel with a simple double click.

Hope this helps.
Regards,
Tijn


Tijn

--
18 Mar 2009 09:46 PM
In the attached example I put in the import of a dbf file at the begin of your script and it will add data and save it again to a dbf file.

Regards,
Tijn

xml_dbf_exch_data_updated.djs

iorgae

--
25 Mar 2009 09:33 AM
many thk's Tijn
with your help is working
here is final form ... for other who is begginer like me

xml_dbf_exch_data_final.djs



Quick Reply
toggle
  Username:
Subject:
Body:
Security Code:
Enter the code shown above:

Submit

Powered by Active Forums

Forum participation and optional registration

You don't need to be registered to partcipate in the Djuggler forums, however if you want to subscribe to email notifications you need to register. You can also subscribe to the forum RSS feed.