Multi Step Import Needed --

Closed Posted 3 years ago Paid on delivery
Closed Paid on delivery

XML Uploader Tool

[login to view URL]

take a look at this import tool

The idea is that the xml files is uploaded and then the fields are mapped to a staging tabell to hold the information.

From there we will then be able to add information to production database, so it is a two step process.

Import xml files to staging tables, and then we check the data before going further.

Transfer data from staging tables to production tables

Have added the excel sheet that shows the fields that we have already gone through and where it should be mapped to

but I think that the faster we can make the basic import script we can add also the transfer script.

And just add more values after we have them, since there are more then we have in the document also but those are the ones we know of at this point.

so this is how i have broken down the steps:

1. Staging and production DB config (able to switch db environment)

2. Staging import module

3. Staging to production transfer/import module

4. Excel upload field data mapping module

5. XML field data mapping module

For the staging database, everything can be in one table, so just call it patient_field, customer_field etc. Just use the excel sheet to make the names.

And we use that for mapping to production database

The idea is to combine multiple related tables into one staging table, i.e. customer and patient. Customers and patients are linked to each other and a customer will always be created and linked to the patient when a patient is created.

So xml (and other) files would be imported into the staging table. The application will then take staging table records and create data in the application based on existing business rules, i.e customer and patient.

the tool link i shared is the very basic import we developed

we need to expand its scope to make it as per requirements above

Laravel MySQL PHP Software Architecture XML

Project ID: #25695114

About the project

6 proposals Remote project Active 3 years ago

6 freelancers are bidding on average $180 for this job

crduran

Hi I will satisfy You during a short time. If You really must do this, please contact me. Thanks. Carlos My main skills (for 5 years): * Languages: Php, JavaScript, Html5... * Frameworks: Laravel, Vue js... * Database More

$180 USD in 7 days
(5 Reviews)
3.4
Gurindersinghd20

Greetings!!! I have read job details. I have skills and experience for this project. I can implement it. NOTE: I deliver best code quality which is easily editable and maintainable in future. Lets make quick schedule More

$222 USD in 4 days
(1 Review)
1.9
imranwork44

Hi, I have read your project details carefully. I will build your website using Laravel and Mysql. I am a web developer with 5 years of experience. I have worked on several similar projects using Laravel and mysql, and More

$200 USD in 2 days
(0 Reviews)
0.0
renukanair26

Hi, I can do this perfectly. We are having experts in database management. So uploading the xml file and then convert and re-join it with production excel file to add more information is perfectly alright. We will More

$200 USD in 7 days
(0 Reviews)
0.0