Tamamlanmış

VBA Script to parse XML and create records in two tables

The script in the attached [login to view URL] is used in Microsoft Access 365. It monitors the folder C:\123 for new files every 60 seconds. When a new file is created there it displays a message box.

I need code to that instead of displaying a message box will:

- Load XML from an xml file created in that folder (ignore if file is not .xml)

- Create a record in the table "ListOrdersResponse" with using the xml file name as ListOrdersResponseId and populate any of the other fields where the corresponding elements have attributes in that file.

- For each "AmazonOrderId" in the xml file, create a record in the table "Order" and populate any of the other fields where the corresponding elements have attributes in that file, again using the using the xml file name as ListOrdersResponseId

Note regarding naming in tables:

You can change these if you wish. Currently, fields are named the same as the corresponding elements. Where there are child nodes they are named ParentNode_ChildNode_ChildNode. The exceptions are the 2 "PaymentExecutionDetails" nodes due to length - these are shortened to PaymentED_PaymentExecutionDetailItem_Payment_CurrencyCode and PaymentED_PaymentExecutionDetailItem_Payment_Amount.

Please see attached files. [login to view URL] is a sample. [login to view URL] contains (edited) real information. Please note that they use the same element names, but they are in a different order, some are not included in each and example456 contains more than one order.

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

[login to view URL]

Beceriler: Uygulamalar için Visual Basic

Daha fazlasını gör: php script parse html xml, script parse xml results, mysql script parse xml files linux, write script parse xml, parse xml file create tables, php script parse xml mysql database, script parse xml html, vbs script parse xml, script parse xml linux, script parse xml file, script parse xml, bash script parse xml, php script parse xml file, shell script parse xml, php script parse xml populate database, perl script parse xml, vba excel parse xml, script parse xml text, python script parse xml file

İşveren Hakkında:
( 0 değerlendirme ) Ireland

Proje NO: #17754353

Seçilen:

abhinovpankaj

Hello, I have been working as freelancer since last ~ 6 years,prior to this was working with a MNC as an Sr. Software Professional. Below are some key areas of my skills: -- VBA and Excel,Word,Office Applicat Daha Fazla

%selectedBids___i_period_sub_7% gün içinde 35%project_currencyDetails_sign_sub_9% %project_currencyDetails_code_sub_10%
(22 Değerlendirme)
4.6

Bu iş için 5 freelancer ortalamada $24 teklif veriyor

rinabuoy13

Hello, I am experienced excel expert. I can help with this task with quick turnaorund. looking to hearing from you. Kind regards

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(6 Değerlendirme)
3.5
vsprybhanu

Hi, Experienced Data Analyst and Macro Developer. I have read your instructions carefully. I can develop a macro to parse xml files and create tables I have done mostly Excel VBA Programming job. Plea Daha Fazla

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(9 Değerlendirme)
3.3
boscojfelix

Dear Sir, Please check my portfolio item with your project name i.e. "VBA Script to parse XML and create records in two tables" in my profile page https://www.freelancer.in/u/boscojfelix for my sample work on your pro Daha Fazla

in %bids___i_period_sub_35% gün içinde10%project_currencyDetails_sign_sub_37% %project_currencyDetails_code_sub_38%
(1 Yorum)
0.5
bijuenathu

Hi, I have 20 years of experience in developing MA Access appliucation. I offer my expertise to parse xml data into MS Access table as per your requirement. Thanks, Biju

1 gün içinde %bids___i_sum_sub_32%%project_currencyDetails_sign_sub_33% USD
(0 Değerlendirme)
0.0