Suljettu

Multi Step Import Needed --

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

Taidot: Laravel, MySQL, PHP, tietojärjestelmäarkkitehtuuri, XML

Näytä lisää: complete step import dmp file, multi step form booking example design, create multi step sign, wordpress multi step form with conditional fields, multi step form wordpress, angular 8 multi step form, multi step widget angular 6, ionic 4 multi step form, multi step form with progress bar angular, multi step form plus nulled, angular 2 multi step form example, design multi step process, multi step registration form drupal, multi step web design, create cool pictures web multi step, multi step math problems flow chart, multi step order upload joomla, 5 4 3 2 1 countdown sound effect free, 9/8 4/3 2 1/8 3 1/3 7/3 42/8 3 1/3 7 1/4 13/3 7/2 5 1/3, κωνσταντινοσ κουφοσ 5 4 3 2 1

Tietoa työnantajasta:
( 62 arvostelua ) Mesa, United States

Projektin tunnus: #25695114

7 freelanceria on tarjonnut keskimäärin 177$ tähän työhön

omartini

Hello, there. I have carefully read your job description with great interests. and I have good experiences in web developing for about 10 years. Please visit my past references here. [login to view URL] http://augme Lisää

$140 USD 7 päivässä
(4 arvostelua)
3.8
olegprokopiv39

Hi there! I went over your job description thoroughly. Laravel's fundamental concepts include Routing, Views, Eloquent ORM, Controllers, Middleware, Models & Migrations, Requests, and Responses and I masterd all larave Lisää

$160 USD 3 päivässä
(4 arvostelua)
3.7
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 Lisää

$180 USD 7 päivässä
(5 arvostelua)
3.4
igorchrepanovdev

Hi there! i have just read your project description carefully. I am an experienced developer having 7+ years of experience in this field. I can start your work immediately. Let's jump on a chat and get started. So Lisää

$140 USD 7 päivässä
(2 arvostelua)
2.8
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 Lisää

$222 USD 4 päivässä
(0 arvostelua)
0.0
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 Lisää

$200 USD 2 päivässä
(0 arvostelua)
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 Lisää

$200 USD 7 päivässä
(0 arvostelua)
0.0