Ruby migration: convert an Excel-file into XML using a gem
Start: an excel file (XLSX) containing customer data. Result: an XML file that a CRM system can import. Tools: Command Prompt, Ruby gem move-to-go.
I'm following a step-by-step guide and have done steps 1-9. I need help with steps 9-12.
- In command prompt: cd (Change direction) to folder where you want to put the migration folder.
- Enter this command move-to-go new MigrationFolder excel (or other list-source).
- Now a folder named “MigrationFolder” is created COMMENT: The folder came with several files already included, File B was one of them. I moved File A here manually, not through command prompt. (Picture 1).
Enter the folder. Enter the command cd MigrationFolder.
Open up the ruby file “Converter.rb”, this is the place where you do the mapping of the fields. COMMENT: There's no file with that name in the folder, however I was able to find the file in their Git. I copied and pasted the code to a text editor and modified it to suit my excel file A.
Now that you are done with your mapping, you want to run the conversion. COMMENT: After I thought I was done with modifying the file, I pasted the code from text editor to command prompt as a whole.
Enter the command move-to-go run. Now Ruby maps the source-file data with the converter file you edited. Which results in a XML file that contains the fetched data and that the CRM-system can read.COMMENT: It resulted in a zipfolder containing an XML-file with data from File B, not A although I wrote the filename for it.
How do I go about converting my excel file into XML (in a zipfolder) with Ruby gem move-to-go?
Do I have to change any fields in the excel file?
Do I need to map data? If yes, how?
All files: https://github.com/Lundalogik/move-to-go
Original code: https://github.com/Lundalogik/move-to-go/blob/master/sources/excel/converter.rb
My modified code: https://github.com/mr-pinkman/repo/blob/master/code
Step-by-step guide: https://github.com/Lundalogik/move-to-go/blob/master/step-by-step.md
Please help a rookie (who wants to learn) out!
I'm willing to pay for someone to teach me by demonstrating this through Skype and Remote Assistance or similar software. My hair is starting to fall out.
ruby excel rubygems migration
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
|
show 1 more comment
Start: an excel file (XLSX) containing customer data. Result: an XML file that a CRM system can import. Tools: Command Prompt, Ruby gem move-to-go.
I'm following a step-by-step guide and have done steps 1-9. I need help with steps 9-12.
- In command prompt: cd (Change direction) to folder where you want to put the migration folder.
- Enter this command move-to-go new MigrationFolder excel (or other list-source).
- Now a folder named “MigrationFolder” is created COMMENT: The folder came with several files already included, File B was one of them. I moved File A here manually, not through command prompt. (Picture 1).
Enter the folder. Enter the command cd MigrationFolder.
Open up the ruby file “Converter.rb”, this is the place where you do the mapping of the fields. COMMENT: There's no file with that name in the folder, however I was able to find the file in their Git. I copied and pasted the code to a text editor and modified it to suit my excel file A.
Now that you are done with your mapping, you want to run the conversion. COMMENT: After I thought I was done with modifying the file, I pasted the code from text editor to command prompt as a whole.
Enter the command move-to-go run. Now Ruby maps the source-file data with the converter file you edited. Which results in a XML file that contains the fetched data and that the CRM-system can read.COMMENT: It resulted in a zipfolder containing an XML-file with data from File B, not A although I wrote the filename for it.
How do I go about converting my excel file into XML (in a zipfolder) with Ruby gem move-to-go?
Do I have to change any fields in the excel file?
Do I need to map data? If yes, how?
All files: https://github.com/Lundalogik/move-to-go
Original code: https://github.com/Lundalogik/move-to-go/blob/master/sources/excel/converter.rb
My modified code: https://github.com/mr-pinkman/repo/blob/master/code
Step-by-step guide: https://github.com/Lundalogik/move-to-go/blob/master/step-by-step.md
Please help a rookie (who wants to learn) out!
I'm willing to pay for someone to teach me by demonstrating this through Skype and Remote Assistance or similar software. My hair is starting to fall out.
ruby excel rubygems migration
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51
|
show 1 more comment
Start: an excel file (XLSX) containing customer data. Result: an XML file that a CRM system can import. Tools: Command Prompt, Ruby gem move-to-go.
I'm following a step-by-step guide and have done steps 1-9. I need help with steps 9-12.
- In command prompt: cd (Change direction) to folder where you want to put the migration folder.
- Enter this command move-to-go new MigrationFolder excel (or other list-source).
- Now a folder named “MigrationFolder” is created COMMENT: The folder came with several files already included, File B was one of them. I moved File A here manually, not through command prompt. (Picture 1).
Enter the folder. Enter the command cd MigrationFolder.
Open up the ruby file “Converter.rb”, this is the place where you do the mapping of the fields. COMMENT: There's no file with that name in the folder, however I was able to find the file in their Git. I copied and pasted the code to a text editor and modified it to suit my excel file A.
Now that you are done with your mapping, you want to run the conversion. COMMENT: After I thought I was done with modifying the file, I pasted the code from text editor to command prompt as a whole.
Enter the command move-to-go run. Now Ruby maps the source-file data with the converter file you edited. Which results in a XML file that contains the fetched data and that the CRM-system can read.COMMENT: It resulted in a zipfolder containing an XML-file with data from File B, not A although I wrote the filename for it.
How do I go about converting my excel file into XML (in a zipfolder) with Ruby gem move-to-go?
Do I have to change any fields in the excel file?
Do I need to map data? If yes, how?
All files: https://github.com/Lundalogik/move-to-go
Original code: https://github.com/Lundalogik/move-to-go/blob/master/sources/excel/converter.rb
My modified code: https://github.com/mr-pinkman/repo/blob/master/code
Step-by-step guide: https://github.com/Lundalogik/move-to-go/blob/master/step-by-step.md
Please help a rookie (who wants to learn) out!
I'm willing to pay for someone to teach me by demonstrating this through Skype and Remote Assistance or similar software. My hair is starting to fall out.
ruby excel rubygems migration
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
Start: an excel file (XLSX) containing customer data. Result: an XML file that a CRM system can import. Tools: Command Prompt, Ruby gem move-to-go.
I'm following a step-by-step guide and have done steps 1-9. I need help with steps 9-12.
- In command prompt: cd (Change direction) to folder where you want to put the migration folder.
- Enter this command move-to-go new MigrationFolder excel (or other list-source).
- Now a folder named “MigrationFolder” is created COMMENT: The folder came with several files already included, File B was one of them. I moved File A here manually, not through command prompt. (Picture 1).
Enter the folder. Enter the command cd MigrationFolder.
Open up the ruby file “Converter.rb”, this is the place where you do the mapping of the fields. COMMENT: There's no file with that name in the folder, however I was able to find the file in their Git. I copied and pasted the code to a text editor and modified it to suit my excel file A.
Now that you are done with your mapping, you want to run the conversion. COMMENT: After I thought I was done with modifying the file, I pasted the code from text editor to command prompt as a whole.
Enter the command move-to-go run. Now Ruby maps the source-file data with the converter file you edited. Which results in a XML file that contains the fetched data and that the CRM-system can read.COMMENT: It resulted in a zipfolder containing an XML-file with data from File B, not A although I wrote the filename for it.
How do I go about converting my excel file into XML (in a zipfolder) with Ruby gem move-to-go?
Do I have to change any fields in the excel file?
Do I need to map data? If yes, how?
All files: https://github.com/Lundalogik/move-to-go
Original code: https://github.com/Lundalogik/move-to-go/blob/master/sources/excel/converter.rb
My modified code: https://github.com/mr-pinkman/repo/blob/master/code
Step-by-step guide: https://github.com/Lundalogik/move-to-go/blob/master/step-by-step.md
Please help a rookie (who wants to learn) out!
I'm willing to pay for someone to teach me by demonstrating this through Skype and Remote Assistance or similar software. My hair is starting to fall out.
ruby excel rubygems migration
ruby excel rubygems migration
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
edited Nov 23 '18 at 18:26
Mr Pinkman
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
asked Nov 23 '18 at 16:50
Mr PinkmanMr Pinkman
13
13
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51
|
show 1 more comment
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51
|
show 1 more comment
0
active
oldest
votes
Your Answer
StackExchange.ifUsing("editor", function () {
StackExchange.using("externalEditor", function () {
StackExchange.using("snippets", function () {
StackExchange.snippets.init();
});
});
}, "code-snippets");
StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "1"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);
StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});
function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});
}
});
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450411%2fruby-migration-convert-an-excel-file-into-xml-using-a-gem%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
0
active
oldest
votes
0
active
oldest
votes
active
oldest
votes
active
oldest
votes
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53450411%2fruby-migration-convert-an-excel-file-into-xml-using-a-gem%23new-answer', 'question_page');
}
);
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Sign up or log in
StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
You need to provide some code and at least the url of the guide you are following. I recommendo to create a git repo in github or gitlab and share it in order to help you.
– hernanvicente
Nov 23 '18 at 16:53
You should link to the gem you are using.
– Kris
Nov 23 '18 at 17:17
@Kris github.com/Lundalogik/move-to-go
– Mr Pinkman
Nov 23 '18 at 17:57
@hernanvicente I've added links now!
– Mr Pinkman
Nov 23 '18 at 18:27
"Enter the folder. Enter the command cd MigrationFolder." - Are you having a problem with this step because this is a shell command and depends on which operating system you are using, Windows, Mac, Linux etc...
– Kris
Nov 27 '18 at 15:51