You providing them with a schema is definitely good. Saves both parties a
lot of headaches...
Yes, requesting for additional data now itself is an idea, but keep in mind
that there may be situations where the other system starts capturing data at
a later date that they were not capturing earlier...They would have to send
it to you also...
All said and done, these should not stop you from having a go at XML to get
a hang of what it is...I was just putting across my apprehensions of using
this approach in a production environment. You can always try out XML on the
development end, no stopping you from that!
All the best,
----- Original Message -----
From: "dont worry" <aspmailbox@y...>
To: "Code Clinic" <proasp_codeclinic@p...>
Sent: Monday, December 17, 2001 9:40 PM
Subject: [proasp_codeclinic] Re: Dissussion xml or text file and importing
I'm not sure if they will provide me with an xml file,
but if they agree I can provide them with schema and
sample xml file. Will that be enough for them?
If they don't I will just go the text file route.
I expect future additions to the program. Maybe I
should ask them for extra data that I'm not using.
So, when I do an addition to the program I can just
incorporate the data that hasn't been used?
--- Deepak Parthasarathy M <deepakp@n...> wrote:
> Hi DW,
> A few questions you need to get answers to before
> you decide to go with
> 1. Will the third party system (or developers,
> whatever the case maybe)
> provide you with the XML file? If they do provide,
> who will decide the
> schema for such an XML file? My experience is that a
> third party (developers
> in my case) never want to commit to any extra work
> on their end! So you may
> have to do all the hard work!
> 2. If they don't agree to supply you with an XML
> file & you still want to go
> the XML way, then you have to write a script that
> converts their text file
> into XML as and when it comes & then another script
> to update the DB from
> this XML file. Meaning you are bringing one more
> step into the existing
> process...More work for you...
> 3. What if at a later date your system needs more
> information (more DB
> fields to be updated) from the 3rd party? Assuming
> that the 3rd party had
> agreed to send you the XML file, they would have to
> make changes on their
> end & send you the XML with the new fields...Then
> you have to make changes
> to your programs to read these new fields and update
> the DB...It gets more
> complicated when they are still sending you text
> files and you are using XML
> on your end (point 2)..You have to change more
> I'm not one who would embrace a new technology just
> because it's new...If an
> existing technology helps me do things easily, I
> don't see a reason for
> changing over...But that's just me ;-) Other's may
> have a different view on
> Over to you to scratch your head!!
> ----- Original Message -----
> From: "dont worry" <aspmailbox@y...>
> To: "Code Clinic" <proasp_codeclinic@p...>
> Sent: Friday, December 14, 2001 10:21 PM
> Subject: [proasp_codeclinic] Dissussion xml or text
> file and importing
> This is my System (W2k, IIS 5, IE5.5, SQL 7.0., ASP)
> A) I'm doing a 1-time import of thousands of records
> and daily import of fewer records. The data is
> from a third party system and I have to import this
> data into the above mentioned system. For best
> results and FUTURE considerations should I try an
> files or just regular flat text file delimited for
> NOTE:I know that Third party can FTP a file to a
> specific directory.
> B)My guess is a text file, since SQL Server has
> support for this and I don't have to write an asp
> script. I can schedule a task in SQL to do this
> C)On the other hand I think xml file to start
> the basis for a standard data exchange.
> C1)I guess I would have to write a special .vbs
> script to read the xml file and import? I could
> schedule the .vbs to run every day.
> C2)Would there be problem if the xml file is
> thousands of records (very large)?
> D)Also, I will write a script to have a admin browse
> and upload other (text or xml) files. The script
> should process each record one at a time and if any
> error occurs allow the admin to overwrite existing
> data or enter other values.
> D1) Is this possible?
> D2) If it is possible is it easier with a flat
> file or xml file?
> Please discuss and if you have any question ask
> Thank you for your time,
> Do You Yahoo!?
> Check out Yahoo! Shopping and Yahoo! Auctions for
> all of
> your unique holiday gifts! Buy at
> or bid at http://auctions.yahoo.com
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com