Small Improvements to an exiting Workflow Application (Xls. Dropbox)

Closed Posted 6 years ago Paid on delivery
Closed Paid on delivery

The actual application takes data from an email with att.

- store att. document through a proper path in a Dropbox-folder

- and fill xls records using information stored in mail filed

It is working very well but some process improvements need to be carried out:

Remove folder automatically created by application (i.e./ 019)

I can't delete them manually as they are regenerated by the application.

Improvements

1. The app will generate automatically a Business Protocol Code for each email (document) sent

This unique code will be numeric:

Year (2 digit) Month (2 digit) Day (2 digit) Serial (2 digit) = Document Protocol (concatenation 8 digit)

i.e. 18022304 =23 February 2018 serial 04

2. The new mail body should contain the following information while protocol should go in the header:

Document Type: PI Purchasing Invoice, SL Sales, EL Engagement Letters, BS Bank Statements (Drop Down List)

Company: ZF, HH, EX (Drop Down List)

Fiscal Month: Take by default the one of the protocol, but it can be changed (actual month)

Competence: Yes/No (Drop Down List)

Job: Text to be picked up from an xls in dropbox or a mysql (nice-to-have to be discussed)

Account: Text to be picked up from an xls in dropbox or a mysql (nice-to-have to be discussed)

Sub-account: Text to be picked up from an xls in dropbox or a mysql (nice-to-have to be discussed)

NET: numeric (2 decimal)

VAT: numeric (2 decimal)

TOT: numeric (2 decimal)

Payment: Yes/No (Drop Down List)

- if Yes is selected then go to step 3:

3. In Email Body request:

Payment Source: HSBC, Intesa, Fire, HSBCcard, NEXI, Bancomat, Cash (Drop Down List)

3.1. The app will generate automatically a Payment Protocol Code for email (document) sent

This unique code will be numeric:

Year (2 digit) Month (2 digit) Day (2 digit) Serial (2 digit) = Payment Protocol (concatenation 8 digit)

i.e. 18022304 =23 February 2018 serial 04

AMOUNT PAID:=TOT

PAYMENT MONTH:=Take by default the one of the protocol, but it can be changed (actual month)

STATUS:=PAID

4. When the email is sent:

4.1. Post the doc in the following Dropbox path: Year/Administration/Company/Accounts/Month/Type

i.e. 018//Administration/HH/Accounts/01/BS 019//Administration/ZF/Accounts/02/EL

4.2 Rename file with its protocol number in mail header (present yet)

4.3. Put a watermark on the document with its Document Protocol Number (nice-to-have to be discussed)

It also would be nice to be able to process different extension (i.e. xls or jpg) to be converted in pdf (nice-to-have to be discussed)

Send the document to a physical printer queue (nice-to-have to be discussed)

4.4. Fill the xls cartel workflow in Administration Folder

This would be made of two sheets:

Document Protocols

Payment Protocols

All fields will be populated form mail records.

5. Each time a new doc is enter the [login to view URL] filed is renamed with [login to view URL] Protocol Extension i.e. wf.18010204

Android C# Programming Mobile App Development PHP Software Architecture

Project ID: #16051092

About the project

32 proposals Remote project Active 6 years ago

32 freelancers are bidding on average €564 for this job

fleetways

Thank you for looking at our bid. Not sure whether the existing application is windows native (C#/Vb) or using scripting languages like Python/PHP - watching mails in coming, request your response to discuss. Would a More

€750 EUR in 21 days
(95 Reviews)
8.2
langlangFan

Hello I am an expert in Mobile and web development with 15+ years of experience and good track records. I am interested in your projects and I believe I can deliver rich features of the application to beat your i More

€555 EUR in 10 days
(97 Reviews)
7.7
globaltechnosys

Hello! I am a professional app developer. I will surely perform the customization in your app. Let's chat to discuss. Skills: I have expertise in Android, XML, Web Services, Java, Eclipse, Android SDK, Swift, Objec More

€500 EUR in 10 days
(224 Reviews)
7.9
yashtechsolution

Hello, I have viewed your requirements and found our self the most appropriate for the project Please share all the requirement details across to me So i can go through it and start working on it. I am having More

€400 EUR in 10 days
(104 Reviews)
7.6
kalidass678

Hi, I am interested on your project. We have separate team for Android and IOS. Ourskills : Android Studio,java,Objective-C,Swift in Xcode and c#. If you share more details with me i will discuss with you More

€500 EUR in 15 days
(180 Reviews)
7.4
Julian29

Hey! I have gone through the post and understood that you need small improvement to an existing workflow application and i will do that as you need. HAVING MORE THAN 6 YEARS OF EXPERIENCED IN PROGRAMMING AND ACCOMP More

€555 EUR in 10 days
(86 Reviews)
7.5
moderninfotech

Hello sir, How are you? We have gone through your requirement and ready to implement those improvements on the priority basis. We have the team of experts having six years experience and they are well versed in all PH More

€444 EUR in 15 days
(160 Reviews)
7.1
sherifamgadnabih

i am a lead .NET software engineer and responsible for creating a web and desktop applications using different languages and technologies if u r interested just send me a message thank you and good luck

€400 EUR in 10 days
(113 Reviews)
6.7
sflogics

We are .Net expert and can do software enhancement. We can work according to your timezone and can start work immediately.

€400 EUR in 10 days
(66 Reviews)
6.4
sanjayios

Hello, I have gone through your proposal carefully, i can do this job, please send me a message so we can discuss in detail. Thanks!

€555 EUR in 10 days
(16 Reviews)
6.2
shubhi8982

Hello I am interested in your project because I have a many year of experience and completed many project based on this field so I do this job very well on time So reply me Thanks

€833 EUR in 8 days
(43 Reviews)
5.8
KeyboardSolution

Hello, I read through the job details extremely carefully.... ***Available to Start work now and able to complete this job. Looking forward for your response. Regards

€250 EUR in 5 days
(8 Reviews)
3.3
tahatech484

Taha technologies is an international software development company in Siliguri, WB, India, EG office in Cairo, Egypt and development centers in Eastern Europe and Asia

€555 EUR in 10 days
(1 Review)
0.0
Krishnanand84068

I Rakesh and I represent a company named RDM. We have a team of 40+ creative people and we cater the market of the Web & Mobile App design and development. We got Android developer, who specializes in firebase and J More

€555 EUR in 10 days
(0 Reviews)
0.0