Silog data export to Excel
Solved
goldrigger
-
Badr -
Badr -
Hello,
I would like to know if there is anyone who knows Silog?
If yes, I would like to know how to export data to an Excel spreadsheet.
I would like to know if there is anyone who knows Silog?
If yes, I would like to know how to export data to an Excel spreadsheet.
Configuration: Windows XP Firefox 2.0.0.11
22 answers
- 1
- 2
Next
Hello,
On SILOG, the easiest way is to create a crystal report with the columns and data.
In the report displayed by SILOG, there is an envelope at the top and you have options to export to Excel and many other formats.
It is even possible to perform exports via command line at specific times, generating a file automatically.
Hoping I was able to help you.
On SILOG, the easiest way is to create a crystal report with the columns and data.
In the report displayed by SILOG, there is an envelope at the top and you have options to export to Excel and many other formats.
It is even possible to perform exports via command line at specific times, generating a file automatically.
Hoping I was able to help you.
Hello everyone, I am currently doing an internship and I need to set up a production schedule on Silog.
For this, I go to the launches module and the workload plan editing, my concern is that the system loads the positions to a maximum of 35 hours per week as if there was only one person working on this position.
Yet in the capacity plan, I have defined a capacity of 70 hours for the concerned position.
Can someone help me?
Thank you in advance
For this, I go to the launches module and the workload plan editing, my concern is that the system loads the positions to a maximum of 35 hours per week as if there was only one person working on this position.
Yet in the capacity plan, I have defined a capacity of 70 hours for the concerned position.
Can someone help me?
Thank you in advance
Good evening,
finally someone who knows Silog.
Is it possible to export only a specific piece of data to an Excel spreadsheet in a specific cell?
I have a dashboard, and in certain cells I need data like operator times or other times.
Thank you for your help.
I may need your services again later.
finally someone who knows Silog.
Is it possible to export only a specific piece of data to an Excel spreadsheet in a specific cell?
I have a dashboard, and in certain cells I need data like operator times or other times.
Thank you for your help.
I may need your services again later.
Hello,
If I understand correctly, you have an existing Excel file (dashboard) and you want to input data into certain specified cells.
The easiest way is to have 2 Excel files.
File A: your dashboard
File B: your freshly exported GPAO SILOG data
In your file A, you create a macro that updates the cells in your file based on the data from file B.
Or even without creating a macro (I'm silly), you can create links in the Excel formulas that point to file B.
For your file B, you just need to create a .bat with a command line that generates it, and with the task scheduler, you can run it once a day to update your file.
I can give you the command line if needed.
If I understand correctly, you have an existing Excel file (dashboard) and you want to input data into certain specified cells.
The easiest way is to have 2 Excel files.
File A: your dashboard
File B: your freshly exported GPAO SILOG data
In your file A, you create a macro that updates the cells in your file based on the data from file B.
Or even without creating a macro (I'm silly), you can create links in the Excel formulas that point to file B.
For your file B, you just need to create a .bat with a command line that generates it, and with the task scheduler, you can run it once a day to update your file.
I can give you the command line if needed.
which version of SILOG are you on?
I created an account so you can send me a private message if you want us to exchange information via email about SILOG.
I created an account so you can send me a private message if you want us to exchange information via email about SILOG.
Hi,
Yes, I think I will create a file to import the data from Silog and I will link it to my dashboard.
Actually, I don't have Silog at home, I'm not very familiar with this software. It's at my company where I will do an internship that Silog is available.
I will go tomorrow to continue my dashboard project and I will let you know.
I want to share information via email, but how do we do that? (DM?)
Yes, I think I will create a file to import the data from Silog and I will link it to my dashboard.
Actually, I don't have Silog at home, I'm not very familiar with this software. It's at my company where I will do an internship that Silog is available.
I will go tomorrow to continue my dashboard project and I will let you know.
I want to share information via email, but how do we do that? (DM?)
I think you need to create an account on the forum
then on the left of my messages, you have an envelope to send a private message (PM)
then on the left of my messages, you have an envelope to send a private message (PM)
Hi,
Yes okay, I will sign up so we can share information. After my work at the company tomorrow, I will send you a message.
Yes okay, I will sign up so we can share information. After my work at the company tomorrow, I will send you a message.
Good evening,
I would like to know if you know what TRS is?
Normally ssilog calculates it automatically but I don't know the formula.
I would like to know if you know what TRS is?
Normally ssilog calculates it automatically but I don't know the formula.
Hello,
I have no knowledge of the Silog software and I would like someone to explain to me how it works and how to use this software.
I would also like to have more in-depth information about its use and to know why we use Silog.
Thank you for answering my questions.
I have no knowledge of the Silog software and I would like someone to explain to me how it works and how to use this software.
I would also like to have more in-depth information about its use and to know why we use Silog.
Thank you for answering my questions.
What do you call TRS?
SILOG in 2 Words:
ERP managing purchases, sales, production, and quality for small businesses, SMEs, and also large companies.
Flexible in terms of usable modules (for example, only sales).
Also flexible in terms of adaptability to the company thanks to a simple system for modifying and configuring the default screens.
Having used it for quite some time, I am satisfied; we have really customized it to fit very unique needs!
There you go!
SILOG in 2 Words:
ERP managing purchases, sales, production, and quality for small businesses, SMEs, and also large companies.
Flexible in terms of usable modules (for example, only sales).
Also flexible in terms of adaptability to the company thanks to a simple system for modifying and configuring the default screens.
Having used it for quite some time, I am satisfied; we have really customized it to fit very unique needs!
There you go!
Hello,
I have been using SILOG for a few days as part of my internship. I would like to set up a zone action for editing a mask. I used some examples I had to do this. When I click on the associated image, my query is displayed. However, the value I select does not appear in my editable zone, which only shows the formula, that is, the name of my variable. Could someone help me?
I used the following syntax: SER ("","SELECT NoAccuseReception FROM Come ","f01105$";)
NoAccuseReception is the field I want to see, Come is the table and f01105$ is my variable.
Thank you.
I have been using SILOG for a few days as part of my internship. I would like to set up a zone action for editing a mask. I used some examples I had to do this. When I click on the associated image, my query is displayed. However, the value I select does not appear in my editable zone, which only shows the formula, that is, the name of my variable. Could someone help me?
I used the following syntax: SER ("","SELECT NoAccuseReception FROM Come ","f01105$";)
NoAccuseReception is the field I want to see, Come is the table and f01105$ is my variable.
Thank you.
Hi,
Take an editable zone object, like the formula f01105$, but make sure you're in the CDE application.
Then set it up, and create an action to which you assign SER ("","SELECT NoAccuseReception FROM Come ","f01105$")
And that's it! When you click on the associated image, it offers you all the acknowledgments of receipt; choose one by clicking on it and your editable zone field takes the value of your choice.
If you're not in CDE, I'll tell you how to proceed.
See you!
Take an editable zone object, like the formula f01105$, but make sure you're in the CDE application.
Then set it up, and create an action to which you assign SER ("","SELECT NoAccuseReception FROM Come ","f01105$")
And that's it! When you click on the associated image, it offers you all the acknowledgments of receipt; choose one by clicking on it and your editable zone field takes the value of your choice.
If you're not in CDE, I'll tell you how to proceed.
See you!
Hi,
TRS: Total Return Rate: used in the industry for quality.
Is this calculation not in your Silog?
In mine, this calculation is included but it doesn't specify how it's calculated.
I'll look into it.
TRS: Total Return Rate: used in the industry for quality.
Is this calculation not in your Silog?
In mine, this calculation is included but it doesn't specify how it's calculated.
I'll look into it.
I don't have the quality module on mine
To understand how it calculates it, it's not going to be easy.
We need to find the right calculation rule or the stored procedure on the SQL server.
To understand how it calculates it, it's not going to be easy.
We need to find the right calculation rule or the stored procedure on the SQL server.
Hello everyone, I have been practicing Silog full-time for 3 years, you can contact Silog's hotline.
You can also import data from Excel into Silog using a Silog macro.
You can also import data from Excel into Silog using a Silog macro.
Hello, I'm sharing the link to the Silog site: https://www.silog.fr/
Otherwise, I'll keep my company to myself.
See you!
Otherwise, I'll keep my company to myself.
See you!
Hello,
Hacking SILOG isn't really useful; what's important is to have maintenance, as getting updates is crucial for patches.
SILOG is a good tool, but be careful, don't get sidetracked, do things well.
I feel that sometimes you create too many modules and they aren't always fully developed.
It's better to do a few less but with better quality.
Dan.
Hacking SILOG isn't really useful; what's important is to have maintenance, as getting updates is crucial for patches.
SILOG is a good tool, but be careful, don't get sidetracked, do things well.
I feel that sometimes you create too many modules and they aren't always fully developed.
It's better to do a few less but with better quality.
Dan.
I am at the headquarters, in Caen.
Regarding the modules, I won’t be able to answer you.
And which region are you from?
Regarding the modules, I won’t be able to answer you.
And which region are you from?
Hello,
I have known SILOG since the Paradox version. I have already done quite a bit of configuration, masks, states, exporting proprietary databases for import into SQL SERVER... if anyone is interested.
And now I'm a bit stuck with SILOG macros under VISUAL BASIC 2008 EXPRESS and SILDDE2.
If anyone has any information.
Thanks in advance.
I have known SILOG since the Paradox version. I have already done quite a bit of configuration, masks, states, exporting proprietary databases for import into SQL SERVER... if anyone is interested.
And now I'm a bit stuck with SILOG macros under VISUAL BASIC 2008 EXPRESS and SILDDE2.
If anyone has any information.
Thanks in advance.
- 1
- 2
Next