Total : 0.00 €

Before contacting us, please make sure to check our F.A.Q

Please, login or register to our website in order to be able to post a presale question in the forum.

Request: Automatic Update of Mapping File

More
3 months 6 days ago #2570 by David Boyle
David Boyle replied the topic: Request: Automatic Update of Mapping File
What I can say right now that any Excel formula works fine in most cases even with the last Excel version but if you want to work safely I strongly suggest you use a *.xls extension and in this case, you have 100% of compatibility.
In your example, "Formula.xlsx", the VLOOKUP works fine but the first column (key column) has to be ordered starting from the lowest value.

Second point
===========
We have a lot of support options.
And my first suggestion could be our live chat fully dedicated to you.
It is a module of 15 minutes with one of our developers and you make to him all the questions you want and you will receive real transparent answers.
Unfortunately, this support must be prepaid at the booking time at the price of € 24.00.

WARRANTIES
Because we use PayPal as a merchant bank, if we do not respect the below promise, PayPal directly will fully refund you according to his sales protection policy at the link
www.paypal.com/us/webapps/mpp/paypal-safety-and-security

* If during the live chat you will express your dissatisfaction regarding the live chat, you have the right to request a full refund of the booked chat.

Let me know if you are interested to learn more about our technical support that is unfolded in 8 levels.
David
at2017

Please Log in or Create an account to join the conversation.

More
3 months 6 days ago #2569 by FABIO MARTARI
FABIO MARTARI replied the topic: Request: Automatic Update of Mapping File
Hello David, thanks for the answer, it would be great.
I answer your requests below:
1- i will send file with ftp upload (every day or every week, i've not decided yet)
2- The worksheet is composed by two sheet. The first one contains "calculation formula", the second one is only a list of value. There is a VLOOKUP function in formula that search the right value in the second sheet. This list may vary, depending on the number of products extracted from the company management program.
3- Yes (Ftp, Database, Wordpress Administrator)
4- Yes it is. Every day the company management program extract value, that update the xls file, and then this will be automatically upload, and update the previous version. This file not modify the "calculation formula" in sheet one, but only the list of value in second one.
5- I would like to try to find a solution on myself with a little help first, but if I can't, I will need your help

i attach my xls and calculator.zip file for better evaluation.
Thanks for support

Fabio
Attachments:

Please Log in or Create an account to join the conversation.

More
3 months 1 week ago #2568 by David Boyle
David Boyle replied the topic: Request: Automatic Update of Mapping File
Hello Fabio,
Yes, It is possible and we did similar customization at least with another customer of ours.
It is not a trivial work but it depends on the constraints you are thinking about.
So please answer the below questions so we can formulate a rough estimation.

Our questions are:
1- How do you want to send the excel files on the server?
2- What kind of changes do you think you may do on the worksheet (position of the cells, formulas, constants, mapping, format etc.)?
3- Do you have full access to the server?
4- Is this automatic upload associated with processes like versioning, notification, diagnostics, email, approving before being operative in production?
5- are you going to develop the solution by yourself receiving from us only some tips and basic knowledge or are you asking for our estimation for a turnkey solution?

If you want to answer us using a more private channel use the contact form link at altoswebsolutions.com/contact-us

David
at2017

Please Log in or Create an account to join the conversation.

More
3 months 1 week ago #2567 by FABIO MARTARI
FABIO MARTARI created the topic: Request: Automatic Update of Mapping File
Hi, i would need to update my xls mapping file every day.
Could it be possible to create a cron job to update it automatically, instead of upload it manually?
I search in folder inside ftp, but i find only json file renamed (in upload folder) and i have no idea to work with.
Thanks in advance.

Fabio

Please Log in or Create an account to join the conversation.

Moderators: david
Time to create page: 0.163 seconds

Cart

Total : 0.00 €